ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
28 rows where deaths = 8, fips = 18121 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
969879 | 969879 | 2021-01-27 | Parke | Indiana | 18121 | 1329 | 8 |
966635 | 966635 | 2021-01-26 | Parke | Indiana | 18121 | 1323 | 8 |
963390 | 963390 | 2021-01-25 | Parke | Indiana | 18121 | 1322 | 8 |
960145 | 960145 | 2021-01-24 | Parke | Indiana | 18121 | 1322 | 8 |
956899 | 956899 | 2021-01-23 | Parke | Indiana | 18121 | 1321 | 8 |
953654 | 953654 | 2021-01-22 | Parke | Indiana | 18121 | 1317 | 8 |
950409 | 950409 | 2021-01-21 | Parke | Indiana | 18121 | 1315 | 8 |
947163 | 947163 | 2021-01-20 | Parke | Indiana | 18121 | 1312 | 8 |
943916 | 943916 | 2021-01-19 | Parke | Indiana | 18121 | 1305 | 8 |
940671 | 940671 | 2021-01-18 | Parke | Indiana | 18121 | 1304 | 8 |
937426 | 937426 | 2021-01-17 | Parke | Indiana | 18121 | 1304 | 8 |
934181 | 934181 | 2021-01-16 | Parke | Indiana | 18121 | 1292 | 8 |
930936 | 930936 | 2021-01-15 | Parke | Indiana | 18121 | 1291 | 8 |
927691 | 927691 | 2021-01-14 | Parke | Indiana | 18121 | 1285 | 8 |
924445 | 924445 | 2021-01-13 | Parke | Indiana | 18121 | 1278 | 8 |
921200 | 921200 | 2021-01-12 | Parke | Indiana | 18121 | 1269 | 8 |
917955 | 917955 | 2021-01-11 | Parke | Indiana | 18121 | 1268 | 8 |
914710 | 914710 | 2021-01-10 | Parke | Indiana | 18121 | 1266 | 8 |
911465 | 911465 | 2021-01-09 | Parke | Indiana | 18121 | 1255 | 8 |
908220 | 908220 | 2021-01-08 | Parke | Indiana | 18121 | 1244 | 8 |
904974 | 904974 | 2021-01-07 | Parke | Indiana | 18121 | 1236 | 8 |
901729 | 901729 | 2021-01-06 | Parke | Indiana | 18121 | 1223 | 8 |
898484 | 898484 | 2021-01-05 | Parke | Indiana | 18121 | 1207 | 8 |
895239 | 895239 | 2021-01-04 | Parke | Indiana | 18121 | 1204 | 8 |
891992 | 891992 | 2021-01-03 | Parke | Indiana | 18121 | 1201 | 8 |
888746 | 888746 | 2021-01-02 | Parke | Indiana | 18121 | 1198 | 8 |
885500 | 885500 | 2021-01-01 | Parke | Indiana | 18121 | 1189 | 8 |
882255 | 882255 | 2020-12-31 | Parke | Indiana | 18121 | 1179 | 8 |
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);