ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
719 rows where deaths = 7 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Ohio 172
- Fayette 82
- Ripley 52
- Randolph 34
- Franklin 28
- Steuben 23
- Switzerland 22
- Parke 21
- Putnam 18
- Jay 16
- Spencer 14
- Union 14
- Huntington 12
- Scott 12
- Vigo 11
- Crawford 10
- Wabash 10
- Whitley 10
- Clay 9
- Cass 8
- Dubois 8
- Fountain 8
- Clinton 7
- Washington 7
- Wayne 7
- Wells 7
- Owen 6
- Hancock 5
- Vanderburgh 5
- Warren 5
- …
state 1
- Indiana · 719 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2425458 | 2425458 | 2022-04-20 | Unknown | Indiana | 0 | 7 | |
2399412 | 2399412 | 2022-04-12 | Unknown | Indiana | 0 | 7 | |
1073759 | 1073759 | 2021-02-28 | Switzerland | Indiana | 18155 | 754 | 7 |
1070513 | 1070513 | 2021-02-27 | Switzerland | Indiana | 18155 | 754 | 7 |
1067268 | 1067268 | 2021-02-26 | Switzerland | Indiana | 18155 | 753 | 7 |
1064023 | 1064023 | 2021-02-25 | Switzerland | Indiana | 18155 | 753 | 7 |
1060778 | 1060778 | 2021-02-24 | Switzerland | Indiana | 18155 | 753 | 7 |
1057532 | 1057532 | 2021-02-23 | Switzerland | Indiana | 18155 | 751 | 7 |
1054286 | 1054286 | 2021-02-22 | Switzerland | Indiana | 18155 | 751 | 7 |
1051039 | 1051039 | 2021-02-21 | Switzerland | Indiana | 18155 | 751 | 7 |
1047792 | 1047792 | 2021-02-20 | Switzerland | Indiana | 18155 | 751 | 7 |
1044547 | 1044547 | 2021-02-19 | Switzerland | Indiana | 18155 | 749 | 7 |
1041302 | 1041302 | 2021-02-18 | Switzerland | Indiana | 18155 | 748 | 7 |
1038057 | 1038057 | 2021-02-17 | Switzerland | Indiana | 18155 | 746 | 7 |
1034812 | 1034812 | 2021-02-16 | Switzerland | Indiana | 18155 | 746 | 7 |
1031566 | 1031566 | 2021-02-15 | Switzerland | Indiana | 18155 | 745 | 7 |
1028319 | 1028319 | 2021-02-14 | Switzerland | Indiana | 18155 | 745 | 7 |
1025074 | 1025074 | 2021-02-13 | Switzerland | Indiana | 18155 | 743 | 7 |
1021829 | 1021829 | 2021-02-12 | Switzerland | Indiana | 18155 | 741 | 7 |
1018584 | 1018584 | 2021-02-11 | Switzerland | Indiana | 18155 | 734 | 7 |
1015339 | 1015339 | 2021-02-10 | Switzerland | Indiana | 18155 | 732 | 7 |
1012094 | 1012094 | 2021-02-09 | Switzerland | Indiana | 18155 | 730 | 7 |
1008848 | 1008848 | 2021-02-08 | Switzerland | Indiana | 18155 | 730 | 7 |
1005602 | 1005602 | 2021-02-07 | Switzerland | Indiana | 18155 | 728 | 7 |
992598 | 992598 | 2021-02-03 | Ohio | Indiana | 18115 | 510 | 7 |
992621 | 992621 | 2021-02-03 | Union | Indiana | 18161 | 667 | 7 |
989352 | 989352 | 2021-02-02 | Ohio | Indiana | 18115 | 508 | 7 |
989375 | 989375 | 2021-02-02 | Union | Indiana | 18161 | 665 | 7 |
986105 | 986105 | 2021-02-01 | Ohio | Indiana | 18115 | 508 | 7 |
986128 | 986128 | 2021-02-01 | Union | Indiana | 18161 | 663 | 7 |
982858 | 982858 | 2021-01-31 | Ohio | Indiana | 18115 | 506 | 7 |
982881 | 982881 | 2021-01-31 | Union | Indiana | 18161 | 663 | 7 |
979612 | 979612 | 2021-01-30 | Ohio | Indiana | 18115 | 504 | 7 |
979635 | 979635 | 2021-01-30 | Union | Indiana | 18161 | 662 | 7 |
976366 | 976366 | 2021-01-29 | Ohio | Indiana | 18115 | 504 | 7 |
976389 | 976389 | 2021-01-29 | Union | Indiana | 18161 | 662 | 7 |
973121 | 973121 | 2021-01-28 | Ohio | Indiana | 18115 | 500 | 7 |
973144 | 973144 | 2021-01-28 | Union | Indiana | 18161 | 662 | 7 |
969876 | 969876 | 2021-01-27 | Ohio | Indiana | 18115 | 497 | 7 |
969899 | 969899 | 2021-01-27 | Union | Indiana | 18161 | 659 | 7 |
966632 | 966632 | 2021-01-26 | Ohio | Indiana | 18115 | 496 | 7 |
966655 | 966655 | 2021-01-26 | Union | Indiana | 18161 | 656 | 7 |
963387 | 963387 | 2021-01-25 | Ohio | Indiana | 18115 | 497 | 7 |
963410 | 963410 | 2021-01-25 | Union | Indiana | 18161 | 656 | 7 |
960142 | 960142 | 2021-01-24 | Ohio | Indiana | 18115 | 495 | 7 |
960165 | 960165 | 2021-01-24 | Union | Indiana | 18161 | 655 | 7 |
956896 | 956896 | 2021-01-23 | Ohio | Indiana | 18115 | 490 | 7 |
956919 | 956919 | 2021-01-23 | Union | Indiana | 18161 | 655 | 7 |
953651 | 953651 | 2021-01-22 | Ohio | Indiana | 18115 | 486 | 7 |
953674 | 953674 | 2021-01-22 | Union | Indiana | 18161 | 653 | 7 |
950406 | 950406 | 2021-01-21 | Ohio | Indiana | 18115 | 478 | 7 |
950429 | 950429 | 2021-01-21 | Union | Indiana | 18161 | 649 | 7 |
947160 | 947160 | 2021-01-20 | Ohio | Indiana | 18115 | 474 | 7 |
943913 | 943913 | 2021-01-19 | Ohio | Indiana | 18115 | 472 | 7 |
940668 | 940668 | 2021-01-18 | Ohio | Indiana | 18115 | 470 | 7 |
937423 | 937423 | 2021-01-17 | Ohio | Indiana | 18115 | 467 | 7 |
934178 | 934178 | 2021-01-16 | Ohio | Indiana | 18115 | 464 | 7 |
930933 | 930933 | 2021-01-15 | Ohio | Indiana | 18115 | 462 | 7 |
927688 | 927688 | 2021-01-14 | Ohio | Indiana | 18115 | 454 | 7 |
924442 | 924442 | 2021-01-13 | Ohio | Indiana | 18115 | 449 | 7 |
921197 | 921197 | 2021-01-12 | Ohio | Indiana | 18115 | 445 | 7 |
917952 | 917952 | 2021-01-11 | Ohio | Indiana | 18115 | 442 | 7 |
914707 | 914707 | 2021-01-10 | Ohio | Indiana | 18115 | 438 | 7 |
911462 | 911462 | 2021-01-09 | Ohio | Indiana | 18115 | 434 | 7 |
908217 | 908217 | 2021-01-08 | Ohio | Indiana | 18115 | 429 | 7 |
904971 | 904971 | 2021-01-07 | Ohio | Indiana | 18115 | 426 | 7 |
901726 | 901726 | 2021-01-06 | Ohio | Indiana | 18115 | 415 | 7 |
898481 | 898481 | 2021-01-05 | Ohio | Indiana | 18115 | 411 | 7 |
895236 | 895236 | 2021-01-04 | Ohio | Indiana | 18115 | 408 | 7 |
891989 | 891989 | 2021-01-03 | Ohio | Indiana | 18115 | 404 | 7 |
888743 | 888743 | 2021-01-02 | Ohio | Indiana | 18115 | 403 | 7 |
885497 | 885497 | 2021-01-01 | Ohio | Indiana | 18115 | 400 | 7 |
882252 | 882252 | 2020-12-31 | Ohio | Indiana | 18115 | 396 | 7 |
879007 | 879007 | 2020-12-30 | Ohio | Indiana | 18115 | 390 | 7 |
879010 | 879010 | 2020-12-30 | Parke | Indiana | 18121 | 1172 | 7 |
875762 | 875762 | 2020-12-29 | Ohio | Indiana | 18115 | 389 | 7 |
875765 | 875765 | 2020-12-29 | Parke | Indiana | 18121 | 1164 | 7 |
872517 | 872517 | 2020-12-28 | Ohio | Indiana | 18115 | 385 | 7 |
872520 | 872520 | 2020-12-28 | Parke | Indiana | 18121 | 1157 | 7 |
869272 | 869272 | 2020-12-27 | Ohio | Indiana | 18115 | 385 | 7 |
869275 | 869275 | 2020-12-27 | Parke | Indiana | 18121 | 1153 | 7 |
865973 | 865973 | 2020-12-26 | Benton | Indiana | 18007 | 733 | 7 |
866027 | 866027 | 2020-12-26 | Ohio | Indiana | 18115 | 383 | 7 |
866030 | 866030 | 2020-12-26 | Parke | Indiana | 18121 | 1151 | 7 |
862728 | 862728 | 2020-12-25 | Benton | Indiana | 18007 | 725 | 7 |
862782 | 862782 | 2020-12-25 | Ohio | Indiana | 18115 | 379 | 7 |
862785 | 862785 | 2020-12-25 | Parke | Indiana | 18121 | 1146 | 7 |
859483 | 859483 | 2020-12-24 | Benton | Indiana | 18007 | 716 | 7 |
859537 | 859537 | 2020-12-24 | Ohio | Indiana | 18115 | 370 | 7 |
859540 | 859540 | 2020-12-24 | Parke | Indiana | 18121 | 1136 | 7 |
856238 | 856238 | 2020-12-23 | Benton | Indiana | 18007 | 705 | 7 |
856292 | 856292 | 2020-12-23 | Ohio | Indiana | 18115 | 367 | 7 |
856295 | 856295 | 2020-12-23 | Parke | Indiana | 18121 | 1115 | 7 |
853047 | 853047 | 2020-12-22 | Ohio | Indiana | 18115 | 362 | 7 |
853050 | 853050 | 2020-12-22 | Parke | Indiana | 18121 | 1106 | 7 |
849802 | 849802 | 2020-12-21 | Ohio | Indiana | 18115 | 351 | 7 |
849805 | 849805 | 2020-12-21 | Parke | Indiana | 18121 | 1102 | 7 |
846557 | 846557 | 2020-12-20 | Ohio | Indiana | 18115 | 346 | 7 |
846560 | 846560 | 2020-12-20 | Parke | Indiana | 18121 | 1102 | 7 |
843311 | 843311 | 2020-12-19 | Ohio | Indiana | 18115 | 333 | 7 |
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);