ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
69 rows where deaths = 197 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 15
county 15
- Marshall 24
- Morgan 12
- Floyd 7
- LaPorte 7
- Kosciusko 3
- Allen 2
- Bartholomew 2
- Lawrence 2
- Tippecanoe 2
- Warrick 2
- Wayne 2
- Delaware 1
- Hamilton 1
- Johnson 1
- St. Joseph 1
state 1
- Indiana · 69 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500329 | 2500329 | 2022-05-13 | Marshall | Indiana | 18099 | 12437 | 197 |
2497071 | 2497071 | 2022-05-12 | Marshall | Indiana | 18099 | 12427 | 197 |
2493813 | 2493813 | 2022-05-11 | Marshall | Indiana | 18099 | 12427 | 197 |
2490555 | 2490555 | 2022-05-10 | Marshall | Indiana | 18099 | 12415 | 197 |
2487298 | 2487298 | 2022-05-09 | Marshall | Indiana | 18099 | 12415 | 197 |
2484040 | 2484040 | 2022-05-08 | Marshall | Indiana | 18099 | 12400 | 197 |
2480782 | 2480782 | 2022-05-07 | Marshall | Indiana | 18099 | 12400 | 197 |
2477524 | 2477524 | 2022-05-06 | Marshall | Indiana | 18099 | 12400 | 197 |
2474266 | 2474266 | 2022-05-05 | Marshall | Indiana | 18099 | 12400 | 197 |
2471009 | 2471009 | 2022-05-04 | Marshall | Indiana | 18099 | 12400 | 197 |
2467753 | 2467753 | 2022-05-03 | Marshall | Indiana | 18099 | 12395 | 197 |
2464498 | 2464498 | 2022-05-02 | Marshall | Indiana | 18099 | 12395 | 197 |
2461242 | 2461242 | 2022-05-01 | Marshall | Indiana | 18099 | 12394 | 197 |
2457986 | 2457986 | 2022-04-30 | Marshall | Indiana | 18099 | 12394 | 197 |
2454730 | 2454730 | 2022-04-29 | Marshall | Indiana | 18099 | 12394 | 197 |
2451474 | 2451474 | 2022-04-28 | Marshall | Indiana | 18099 | 12386 | 197 |
2448218 | 2448218 | 2022-04-27 | Marshall | Indiana | 18099 | 12386 | 197 |
2444962 | 2444962 | 2022-04-26 | Marshall | Indiana | 18099 | 12381 | 197 |
2441706 | 2441706 | 2022-04-25 | Marshall | Indiana | 18099 | 12381 | 197 |
2438450 | 2438450 | 2022-04-24 | Marshall | Indiana | 18099 | 12370 | 197 |
2435194 | 2435194 | 2022-04-23 | Marshall | Indiana | 18099 | 12370 | 197 |
2431938 | 2431938 | 2022-04-22 | Marshall | Indiana | 18099 | 12370 | 197 |
2428682 | 2428682 | 2022-04-21 | Marshall | Indiana | 18099 | 12355 | 197 |
2425426 | 2425426 | 2022-04-20 | Marshall | Indiana | 18099 | 12355 | 197 |
2096872 | 2096872 | 2022-01-09 | Kosciusko | Indiana | 18085 | 16457 | 197 |
2093620 | 2093620 | 2022-01-08 | Kosciusko | Indiana | 18085 | 16457 | 197 |
2090368 | 2090368 | 2022-01-07 | Kosciusko | Indiana | 18085 | 16457 | 197 |
2018860 | 2018860 | 2021-12-16 | Lawrence | Indiana | 18093 | 8457 | 197 |
2015610 | 2015610 | 2021-12-15 | Lawrence | Indiana | 18093 | 8431 | 197 |
1996145 | 1996145 | 2021-12-09 | Warrick | Indiana | 18173 | 12502 | 197 |
1992894 | 1992894 | 2021-12-08 | Warrick | Indiana | 18173 | 12440 | 197 |
1989559 | 1989559 | 2021-12-07 | Bartholomew | Indiana | 18005 | 13253 | 197 |
1986309 | 1986309 | 2021-12-06 | Bartholomew | Indiana | 18005 | 13204 | 197 |
1963610 | 1963610 | 2021-11-29 | Morgan | Indiana | 18109 | 10272 | 197 |
1960359 | 1960359 | 2021-11-28 | Morgan | Indiana | 18109 | 10154 | 197 |
1957108 | 1957108 | 2021-11-27 | Morgan | Indiana | 18109 | 10154 | 197 |
1953857 | 1953857 | 2021-11-26 | Morgan | Indiana | 18109 | 10154 | 197 |
1950606 | 1950606 | 2021-11-25 | Morgan | Indiana | 18109 | 10154 | 197 |
1947355 | 1947355 | 2021-11-24 | Morgan | Indiana | 18109 | 10154 | 197 |
1944104 | 1944104 | 2021-11-23 | Morgan | Indiana | 18109 | 10093 | 197 |
1940854 | 1940854 | 2021-11-22 | Morgan | Indiana | 18109 | 10063 | 197 |
1937604 | 1937604 | 2021-11-21 | Morgan | Indiana | 18109 | 9990 | 197 |
1934354 | 1934354 | 2021-11-20 | Morgan | Indiana | 18109 | 9990 | 197 |
1931103 | 1931103 | 2021-11-19 | Morgan | Indiana | 18109 | 9990 | 197 |
1927852 | 1927852 | 2021-11-18 | Morgan | Indiana | 18109 | 9955 | 197 |
1677635 | 1677635 | 2021-09-02 | Floyd | Indiana | 18043 | 9521 | 197 |
1674388 | 1674388 | 2021-09-01 | Floyd | Indiana | 18043 | 9442 | 197 |
1671139 | 1671139 | 2021-08-31 | Floyd | Indiana | 18043 | 9379 | 197 |
1667892 | 1667892 | 2021-08-30 | Floyd | Indiana | 18043 | 9318 | 197 |
1664645 | 1664645 | 2021-08-29 | Floyd | Indiana | 18043 | 9185 | 197 |
1661397 | 1661397 | 2021-08-28 | Floyd | Indiana | 18043 | 9185 | 197 |
1658149 | 1658149 | 2021-08-27 | Floyd | Indiana | 18043 | 9185 | 197 |
1378905 | 1378905 | 2021-06-02 | Delaware | Indiana | 18035 | 10913 | 197 |
1119215 | 1119215 | 2021-03-14 | Wayne | Indiana | 18177 | 7081 | 197 |
1115968 | 1115968 | 2021-03-13 | Wayne | Indiana | 18177 | 7077 | 197 |
1060745 | 1060745 | 2021-02-24 | LaPorte | Indiana | 18091 | 9735 | 197 |
1057499 | 1057499 | 2021-02-23 | LaPorte | Indiana | 18091 | 9730 | 197 |
1054253 | 1054253 | 2021-02-22 | LaPorte | Indiana | 18091 | 9726 | 197 |
1051006 | 1051006 | 2021-02-21 | LaPorte | Indiana | 18091 | 9717 | 197 |
1047759 | 1047759 | 2021-02-20 | LaPorte | Indiana | 18091 | 9701 | 197 |
1047793 | 1047793 | 2021-02-20 | Tippecanoe | Indiana | 18157 | 19676 | 197 |
1044514 | 1044514 | 2021-02-19 | LaPorte | Indiana | 18091 | 9682 | 197 |
1044548 | 1044548 | 2021-02-19 | Tippecanoe | Indiana | 18157 | 19603 | 197 |
1041269 | 1041269 | 2021-02-18 | LaPorte | Indiana | 18091 | 9661 | 197 |
814080 | 814080 | 2020-12-10 | Johnson | Indiana | 18081 | 9048 | 197 |
804333 | 804333 | 2020-12-07 | Hamilton | Indiana | 18057 | 16984 | 197 |
713517 | 713517 | 2020-11-09 | St. Joseph | Indiana | 18141 | 12365 | 197 |
518944 | 518944 | 2020-09-10 | Allen | Indiana | 18003 | 5491 | 197 |
515709 | 515709 | 2020-09-09 | Allen | Indiana | 18003 | 5438 | 197 |
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);