ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
41 rows where deaths = 189 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2217235 | 2217235 | 2022-02-15 | Marshall | Indiana | 18099 | 12229 | 189 |
2213984 | 2213984 | 2022-02-14 | Marshall | Indiana | 18099 | 12217 | 189 |
2210732 | 2210732 | 2022-02-13 | Marshall | Indiana | 18099 | 12203 | 189 |
2207479 | 2207479 | 2022-02-12 | Marshall | Indiana | 18099 | 12203 | 189 |
2204226 | 2204226 | 2022-02-11 | Marshall | Indiana | 18099 | 12203 | 189 |
2083855 | 2083855 | 2022-01-05 | Henry | Indiana | 18065 | 10349 | 189 |
2080603 | 2080603 | 2022-01-04 | Henry | Indiana | 18065 | 10243 | 189 |
1960334 | 1960334 | 2021-11-28 | Hancock | Indiana | 18059 | 12672 | 189 |
1957083 | 1957083 | 2021-11-27 | Hancock | Indiana | 18059 | 12672 | 189 |
1953832 | 1953832 | 2021-11-26 | Hancock | Indiana | 18059 | 12672 | 189 |
1950581 | 1950581 | 2021-11-25 | Hancock | Indiana | 18059 | 12672 | 189 |
1947330 | 1947330 | 2021-11-24 | Hancock | Indiana | 18059 | 12672 | 189 |
1944079 | 1944079 | 2021-11-23 | Hancock | Indiana | 18059 | 12616 | 189 |
1898553 | 1898553 | 2021-11-09 | Bartholomew | Indiana | 18005 | 12013 | 189 |
1869360 | 1869360 | 2021-10-31 | Morgan | Indiana | 18109 | 9569 | 189 |
1866111 | 1866111 | 2021-10-30 | Morgan | Indiana | 18109 | 9569 | 189 |
1862862 | 1862862 | 2021-10-29 | Morgan | Indiana | 18109 | 9569 | 189 |
1609425 | 1609425 | 2021-08-12 | Floyd | Indiana | 18043 | 8453 | 189 |
1599683 | 1599683 | 2021-08-09 | Grant | Indiana | 18053 | 7974 | 189 |
1596435 | 1596435 | 2021-08-08 | Grant | Indiana | 18053 | 7928 | 189 |
1593186 | 1593186 | 2021-08-07 | Grant | Indiana | 18053 | 7928 | 189 |
1589937 | 1589937 | 2021-08-06 | Grant | Indiana | 18053 | 7928 | 189 |
1213319 | 1213319 | 2021-04-12 | Delaware | Indiana | 18035 | 10277 | 189 |
1210071 | 1210071 | 2021-04-11 | Delaware | Indiana | 18035 | 10265 | 189 |
1086674 | 1086674 | 2021-03-04 | Clark | Indiana | 18019 | 12039 | 189 |
1083428 | 1083428 | 2021-03-03 | Clark | Indiana | 18019 | 12020 | 189 |
1080182 | 1080182 | 2021-03-02 | Clark | Indiana | 18019 | 11997 | 189 |
1076937 | 1076937 | 2021-03-01 | Clark | Indiana | 18019 | 11986 | 189 |
1073691 | 1073691 | 2021-02-28 | Clark | Indiana | 18019 | 11967 | 189 |
1041313 | 1041313 | 2021-02-18 | Wayne | Indiana | 18177 | 6948 | 189 |
1038068 | 1038068 | 2021-02-17 | Wayne | Indiana | 18177 | 6943 | 189 |
1021830 | 1021830 | 2021-02-12 | Tippecanoe | Indiana | 18157 | 19262 | 189 |
989358 | 989358 | 2021-02-02 | Porter | Indiana | 18127 | 15262 | 189 |
986111 | 986111 | 2021-02-01 | Porter | Indiana | 18127 | 15244 | 189 |
982864 | 982864 | 2021-01-31 | Porter | Indiana | 18127 | 15208 | 189 |
979618 | 979618 | 2021-01-30 | Porter | Indiana | 18127 | 15173 | 189 |
882242 | 882242 | 2020-12-31 | Madison | Indiana | 18095 | 8994 | 189 |
726436 | 726436 | 2020-11-13 | Elkhart | Indiana | 18039 | 13622 | 189 |
687570 | 687570 | 2020-11-01 | St. Joseph | Indiana | 18141 | 10679 | 189 |
496310 | 496310 | 2020-09-03 | Allen | Indiana | 18003 | 5154 | 189 |
493076 | 493076 | 2020-09-02 | Allen | Indiana | 18003 | 5088 | 189 |
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);