ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
33 rows where deaths = 86, fips = 18113 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 |
---|---|---|---|---|---|---|---|
1304275 | 1304275 | 2021-05-10 | Noble | Indiana | 18113 | 5612 | 86 |
1301028 | 1301028 | 2021-05-09 | Noble | Indiana | 18113 | 5607 | 86 |
1297781 | 1297781 | 2021-05-08 | Noble | Indiana | 18113 | 5602 | 86 |
1294535 | 1294535 | 2021-05-07 | Noble | Indiana | 18113 | 5592 | 86 |
1291289 | 1291289 | 2021-05-06 | Noble | Indiana | 18113 | 5586 | 86 |
1288043 | 1288043 | 2021-05-05 | Noble | Indiana | 18113 | 5569 | 86 |
1284797 | 1284797 | 2021-05-04 | Noble | Indiana | 18113 | 5561 | 86 |
1281550 | 1281550 | 2021-05-03 | Noble | Indiana | 18113 | 5549 | 86 |
1278303 | 1278303 | 2021-05-02 | Noble | Indiana | 18113 | 5545 | 86 |
1275056 | 1275056 | 2021-05-01 | Noble | Indiana | 18113 | 5536 | 86 |
1271809 | 1271809 | 2021-04-30 | Noble | Indiana | 18113 | 5530 | 86 |
1268562 | 1268562 | 2021-04-29 | Noble | Indiana | 18113 | 5517 | 86 |
1265315 | 1265315 | 2021-04-28 | Noble | Indiana | 18113 | 5507 | 86 |
1262068 | 1262068 | 2021-04-27 | Noble | Indiana | 18113 | 5495 | 86 |
1258821 | 1258821 | 2021-04-26 | Noble | Indiana | 18113 | 5490 | 86 |
1255574 | 1255574 | 2021-04-25 | Noble | Indiana | 18113 | 5485 | 86 |
1252327 | 1252327 | 2021-04-24 | Noble | Indiana | 18113 | 5473 | 86 |
1249080 | 1249080 | 2021-04-23 | Noble | Indiana | 18113 | 5458 | 86 |
1245833 | 1245833 | 2021-04-22 | Noble | Indiana | 18113 | 5449 | 86 |
1242586 | 1242586 | 2021-04-21 | Noble | Indiana | 18113 | 5440 | 86 |
1239339 | 1239339 | 2021-04-20 | Noble | Indiana | 18113 | 5430 | 86 |
1236092 | 1236092 | 2021-04-19 | Noble | Indiana | 18113 | 5430 | 86 |
1232845 | 1232845 | 2021-04-18 | Noble | Indiana | 18113 | 5428 | 86 |
1229596 | 1229596 | 2021-04-17 | Noble | Indiana | 18113 | 5410 | 86 |
1226348 | 1226348 | 2021-04-16 | Noble | Indiana | 18113 | 5397 | 86 |
1223101 | 1223101 | 2021-04-15 | Noble | Indiana | 18113 | 5383 | 86 |
1219853 | 1219853 | 2021-04-14 | Noble | Indiana | 18113 | 5373 | 86 |
1216605 | 1216605 | 2021-04-13 | Noble | Indiana | 18113 | 5359 | 86 |
1213358 | 1213358 | 2021-04-12 | Noble | Indiana | 18113 | 5353 | 86 |
1210110 | 1210110 | 2021-04-11 | Noble | Indiana | 18113 | 5353 | 86 |
1206861 | 1206861 | 2021-04-10 | Noble | Indiana | 18113 | 5329 | 86 |
1203613 | 1203613 | 2021-04-09 | Noble | Indiana | 18113 | 5327 | 86 |
1200365 | 1200365 | 2021-04-08 | Noble | Indiana | 18113 | 5319 | 86 |
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);