ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
27 rows where deaths = 310 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 11
state 1
- Indiana · 27 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2145706 | 2145706 | 2022-01-24 | Wayne | Indiana | 18177 | 17359 | 310 |
2142451 | 2142451 | 2022-01-23 | Wayne | Indiana | 18177 | 16851 | 310 |
2139196 | 2139196 | 2022-01-22 | Wayne | Indiana | 18177 | 16851 | 310 |
2135940 | 2135940 | 2022-01-21 | Wayne | Indiana | 18177 | 16851 | 310 |
2119633 | 2119633 | 2022-01-16 | LaPorte | Indiana | 18091 | 22371 | 310 |
2116381 | 2116381 | 2022-01-15 | LaPorte | Indiana | 18091 | 22371 | 310 |
2113130 | 2113130 | 2022-01-14 | LaPorte | Indiana | 18091 | 22371 | 310 |
2077397 | 2077397 | 2022-01-03 | Tippecanoe | Indiana | 18157 | 35486 | 310 |
2074077 | 2074077 | 2022-01-02 | Clark | Indiana | 18019 | 21919 | 310 |
2070826 | 2070826 | 2022-01-01 | Clark | Indiana | 18019 | 21919 | 310 |
2067575 | 2067575 | 2021-12-31 | Clark | Indiana | 18019 | 21919 | 310 |
2064324 | 2064324 | 2021-12-30 | Clark | Indiana | 18019 | 21919 | 310 |
1918082 | 1918082 | 2021-11-15 | Howard | Indiana | 18067 | 15641 | 310 |
1914832 | 1914832 | 2021-11-14 | Howard | Indiana | 18067 | 15547 | 310 |
1911582 | 1911582 | 2021-11-13 | Howard | Indiana | 18067 | 15547 | 310 |
1908333 | 1908333 | 2021-11-12 | Howard | Indiana | 18067 | 15547 | 310 |
1853144 | 1853144 | 2021-10-26 | Vigo | Indiana | 18167 | 17575 | 310 |
1239346 | 1239346 | 2021-04-20 | Porter | Indiana | 18127 | 17972 | 310 |
1236099 | 1236099 | 2021-04-19 | Porter | Indiana | 18127 | 17955 | 310 |
1232852 | 1232852 | 2021-04-18 | Porter | Indiana | 18127 | 17960 | 310 |
1041256 | 1041256 | 2021-02-18 | Hendricks | Indiana | 18063 | 15689 | 310 |
1038011 | 1038011 | 2021-02-17 | Hendricks | Indiana | 18063 | 15637 | 310 |
1002326 | 1002326 | 2021-02-06 | Madison | Indiana | 18095 | 11482 | 310 |
765365 | 765365 | 2020-11-25 | Allen | Indiana | 18003 | 18045 | 310 |
467258 | 467258 | 2020-08-25 | Lake | Indiana | 18089 | 8804 | 310 |
464029 | 464029 | 2020-08-24 | Lake | Indiana | 18089 | 8760 | 310 |
460800 | 460800 | 2020-08-23 | Lake | Indiana | 18089 | 8653 | 310 |
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);