ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
645 rows where deaths = 5 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Clay 91
- Switzerland 72
- DeKalb 68
- Wayne 25
- Miami 23
- Huntington 21
- Wabash 19
- Howard 18
- Jefferson 16
- LaPorte 15
- Putnam 14
- Adams 13
- Kosciusko 13
- Jackson 12
- Starke 12
- Jennings 11
- Dearborn 10
- Tippecanoe 10
- Ripley 9
- Washington 9
- Clinton 8
- Martin 8
- Wells 8
- Whitley 7
- Jasper 6
- Morgan 6
- Newton 6
- Brown 5
- Greene 5
- Noble 5
- …
state 1
- Indiana · 645 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2392901 | 2392901 | 2022-04-10 | Unknown | Indiana | 0 | 5 | |
2389645 | 2389645 | 2022-04-09 | Unknown | Indiana | 0 | 5 | |
992618 | 992618 | 2021-02-03 | Switzerland | Indiana | 18155 | 713 | 5 |
989372 | 989372 | 2021-02-02 | Switzerland | Indiana | 18155 | 704 | 5 |
986125 | 986125 | 2021-02-01 | Switzerland | Indiana | 18155 | 702 | 5 |
982878 | 982878 | 2021-01-31 | Switzerland | Indiana | 18155 | 700 | 5 |
979632 | 979632 | 2021-01-30 | Switzerland | Indiana | 18155 | 696 | 5 |
976386 | 976386 | 2021-01-29 | Switzerland | Indiana | 18155 | 692 | 5 |
973141 | 973141 | 2021-01-28 | Switzerland | Indiana | 18155 | 685 | 5 |
969896 | 969896 | 2021-01-27 | Switzerland | Indiana | 18155 | 682 | 5 |
966652 | 966652 | 2021-01-26 | Switzerland | Indiana | 18155 | 670 | 5 |
963407 | 963407 | 2021-01-25 | Switzerland | Indiana | 18155 | 670 | 5 |
960162 | 960162 | 2021-01-24 | Switzerland | Indiana | 18155 | 667 | 5 |
956916 | 956916 | 2021-01-23 | Switzerland | Indiana | 18155 | 662 | 5 |
953671 | 953671 | 2021-01-22 | Switzerland | Indiana | 18155 | 658 | 5 |
950426 | 950426 | 2021-01-21 | Switzerland | Indiana | 18155 | 646 | 5 |
947180 | 947180 | 2021-01-20 | Switzerland | Indiana | 18155 | 633 | 5 |
943933 | 943933 | 2021-01-19 | Switzerland | Indiana | 18155 | 624 | 5 |
940688 | 940688 | 2021-01-18 | Switzerland | Indiana | 18155 | 624 | 5 |
940691 | 940691 | 2021-01-18 | Union | Indiana | 18161 | 641 | 5 |
937443 | 937443 | 2021-01-17 | Switzerland | Indiana | 18155 | 621 | 5 |
934198 | 934198 | 2021-01-16 | Switzerland | Indiana | 18155 | 618 | 5 |
930953 | 930953 | 2021-01-15 | Switzerland | Indiana | 18155 | 616 | 5 |
927708 | 927708 | 2021-01-14 | Switzerland | Indiana | 18155 | 604 | 5 |
924462 | 924462 | 2021-01-13 | Switzerland | Indiana | 18155 | 596 | 5 |
921217 | 921217 | 2021-01-12 | Switzerland | Indiana | 18155 | 580 | 5 |
917972 | 917972 | 2021-01-11 | Switzerland | Indiana | 18155 | 579 | 5 |
914727 | 914727 | 2021-01-10 | Switzerland | Indiana | 18155 | 575 | 5 |
911482 | 911482 | 2021-01-09 | Switzerland | Indiana | 18155 | 566 | 5 |
908237 | 908237 | 2021-01-08 | Switzerland | Indiana | 18155 | 561 | 5 |
904991 | 904991 | 2021-01-07 | Switzerland | Indiana | 18155 | 549 | 5 |
901746 | 901746 | 2021-01-06 | Switzerland | Indiana | 18155 | 542 | 5 |
898501 | 898501 | 2021-01-05 | Switzerland | Indiana | 18155 | 525 | 5 |
895256 | 895256 | 2021-01-04 | Switzerland | Indiana | 18155 | 524 | 5 |
892009 | 892009 | 2021-01-03 | Switzerland | Indiana | 18155 | 515 | 5 |
888763 | 888763 | 2021-01-02 | Switzerland | Indiana | 18155 | 514 | 5 |
885517 | 885517 | 2021-01-01 | Switzerland | Indiana | 18155 | 509 | 5 |
882272 | 882272 | 2020-12-31 | Switzerland | Indiana | 18155 | 497 | 5 |
879027 | 879027 | 2020-12-30 | Switzerland | Indiana | 18155 | 494 | 5 |
875782 | 875782 | 2020-12-29 | Switzerland | Indiana | 18155 | 481 | 5 |
872537 | 872537 | 2020-12-28 | Switzerland | Indiana | 18155 | 479 | 5 |
869292 | 869292 | 2020-12-27 | Switzerland | Indiana | 18155 | 477 | 5 |
866047 | 866047 | 2020-12-26 | Switzerland | Indiana | 18155 | 477 | 5 |
862802 | 862802 | 2020-12-25 | Switzerland | Indiana | 18155 | 468 | 5 |
859557 | 859557 | 2020-12-24 | Switzerland | Indiana | 18155 | 457 | 5 |
856312 | 856312 | 2020-12-23 | Switzerland | Indiana | 18155 | 445 | 5 |
853067 | 853067 | 2020-12-22 | Switzerland | Indiana | 18155 | 440 | 5 |
849822 | 849822 | 2020-12-21 | Switzerland | Indiana | 18155 | 437 | 5 |
846503 | 846503 | 2020-12-20 | Benton | Indiana | 18007 | 683 | 5 |
846577 | 846577 | 2020-12-20 | Switzerland | Indiana | 18155 | 433 | 5 |
843257 | 843257 | 2020-12-19 | Benton | Indiana | 18007 | 678 | 5 |
843331 | 843331 | 2020-12-19 | Switzerland | Indiana | 18155 | 424 | 5 |
840086 | 840086 | 2020-12-18 | Switzerland | Indiana | 18155 | 416 | 5 |
836841 | 836841 | 2020-12-17 | Switzerland | Indiana | 18155 | 406 | 5 |
833595 | 833595 | 2020-12-16 | Switzerland | Indiana | 18155 | 408 | 5 |
830348 | 830348 | 2020-12-15 | Switzerland | Indiana | 18155 | 394 | 5 |
827102 | 827102 | 2020-12-14 | Switzerland | Indiana | 18155 | 387 | 5 |
823855 | 823855 | 2020-12-13 | Switzerland | Indiana | 18155 | 385 | 5 |
820609 | 820609 | 2020-12-12 | Switzerland | Indiana | 18155 | 379 | 5 |
817363 | 817363 | 2020-12-11 | Switzerland | Indiana | 18155 | 364 | 5 |
814117 | 814117 | 2020-12-10 | Switzerland | Indiana | 18155 | 346 | 5 |
810872 | 810872 | 2020-12-09 | Switzerland | Indiana | 18155 | 331 | 5 |
807562 | 807562 | 2020-12-08 | Crawford | Indiana | 18025 | 418 | 5 |
807627 | 807627 | 2020-12-08 | Switzerland | Indiana | 18155 | 320 | 5 |
804382 | 804382 | 2020-12-07 | Switzerland | Indiana | 18155 | 319 | 5 |
801137 | 801137 | 2020-12-06 | Switzerland | Indiana | 18155 | 313 | 5 |
797892 | 797892 | 2020-12-05 | Switzerland | Indiana | 18155 | 304 | 5 |
794647 | 794647 | 2020-12-04 | Switzerland | Indiana | 18155 | 284 | 5 |
791402 | 791402 | 2020-12-03 | Switzerland | Indiana | 18155 | 284 | 5 |
788086 | 788086 | 2020-12-02 | Brown | Indiana | 18013 | 399 | 5 |
788157 | 788157 | 2020-12-02 | Switzerland | Indiana | 18155 | 278 | 5 |
784842 | 784842 | 2020-12-01 | Brown | Indiana | 18013 | 394 | 5 |
784913 | 784913 | 2020-12-01 | Switzerland | Indiana | 18155 | 276 | 5 |
781597 | 781597 | 2020-11-30 | Brown | Indiana | 18013 | 381 | 5 |
781668 | 781668 | 2020-11-30 | Switzerland | Indiana | 18155 | 275 | 5 |
778351 | 778351 | 2020-11-29 | Brown | Indiana | 18013 | 370 | 5 |
778422 | 778422 | 2020-11-29 | Switzerland | Indiana | 18155 | 274 | 5 |
775106 | 775106 | 2020-11-28 | Brown | Indiana | 18013 | 364 | 5 |
775177 | 775177 | 2020-11-28 | Switzerland | Indiana | 18155 | 272 | 5 |
771905 | 771905 | 2020-11-27 | Martin | Indiana | 18101 | 371 | 5 |
771932 | 771932 | 2020-11-27 | Switzerland | Indiana | 18155 | 267 | 5 |
768660 | 768660 | 2020-11-26 | Martin | Indiana | 18101 | 365 | 5 |
768687 | 768687 | 2020-11-26 | Switzerland | Indiana | 18155 | 262 | 5 |
765414 | 765414 | 2020-11-25 | Martin | Indiana | 18101 | 359 | 5 |
765441 | 765441 | 2020-11-25 | Switzerland | Indiana | 18155 | 259 | 5 |
762169 | 762169 | 2020-11-24 | Martin | Indiana | 18101 | 352 | 5 |
762196 | 762196 | 2020-11-24 | Switzerland | Indiana | 18155 | 257 | 5 |
758924 | 758924 | 2020-11-23 | Martin | Indiana | 18101 | 349 | 5 |
755677 | 755677 | 2020-11-22 | Martin | Indiana | 18101 | 343 | 5 |
752431 | 752431 | 2020-11-21 | Martin | Indiana | 18101 | 336 | 5 |
749185 | 749185 | 2020-11-20 | Martin | Indiana | 18101 | 328 | 5 |
749222 | 749222 | 2020-11-20 | Washington | Indiana | 18175 | 646 | 5 |
745976 | 745976 | 2020-11-19 | Washington | Indiana | 18175 | 620 | 5 |
742729 | 742729 | 2020-11-18 | Washington | Indiana | 18175 | 602 | 5 |
739454 | 739454 | 2020-11-17 | Owen | Indiana | 18119 | 481 | 5 |
739482 | 739482 | 2020-11-17 | Washington | Indiana | 18175 | 590 | 5 |
736238 | 736238 | 2020-11-16 | Washington | Indiana | 18175 | 581 | 5 |
732992 | 732992 | 2020-11-15 | Washington | Indiana | 18175 | 571 | 5 |
729747 | 729747 | 2020-11-14 | Washington | Indiana | 18175 | 552 | 5 |
726504 | 726504 | 2020-11-13 | Washington | Indiana | 18175 | 542 | 5 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);