ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
39 rows where county = "Saline" and deaths = 69 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 |
---|---|---|---|---|---|---|---|
1297703 | 1297703 | 2021-05-08 | Saline | Illinois | 17165 | 2561 | 69 |
1294457 | 1294457 | 2021-05-07 | Saline | Illinois | 17165 | 2561 | 69 |
1291211 | 1291211 | 2021-05-06 | Saline | Illinois | 17165 | 2557 | 69 |
1287965 | 1287965 | 2021-05-05 | Saline | Illinois | 17165 | 2552 | 69 |
1284719 | 1284719 | 2021-05-04 | Saline | Illinois | 17165 | 2551 | 69 |
1281472 | 1281472 | 2021-05-03 | Saline | Illinois | 17165 | 2551 | 69 |
1278225 | 1278225 | 2021-05-02 | Saline | Illinois | 17165 | 2549 | 69 |
1274978 | 1274978 | 2021-05-01 | Saline | Illinois | 17165 | 2549 | 69 |
1271731 | 1271731 | 2021-04-30 | Saline | Illinois | 17165 | 2547 | 69 |
1268484 | 1268484 | 2021-04-29 | Saline | Illinois | 17165 | 2541 | 69 |
1265237 | 1265237 | 2021-04-28 | Saline | Illinois | 17165 | 2539 | 69 |
1261990 | 1261990 | 2021-04-27 | Saline | Illinois | 17165 | 2536 | 69 |
1258743 | 1258743 | 2021-04-26 | Saline | Illinois | 17165 | 2531 | 69 |
1255496 | 1255496 | 2021-04-25 | Saline | Illinois | 17165 | 2530 | 69 |
1252249 | 1252249 | 2021-04-24 | Saline | Illinois | 17165 | 2527 | 69 |
1249002 | 1249002 | 2021-04-23 | Saline | Illinois | 17165 | 2525 | 69 |
1245755 | 1245755 | 2021-04-22 | Saline | Illinois | 17165 | 2517 | 69 |
1242508 | 1242508 | 2021-04-21 | Saline | Illinois | 17165 | 2514 | 69 |
1239261 | 1239261 | 2021-04-20 | Saline | Illinois | 17165 | 2511 | 69 |
1236014 | 1236014 | 2021-04-19 | Saline | Illinois | 17165 | 2505 | 69 |
1232767 | 1232767 | 2021-04-18 | Saline | Illinois | 17165 | 2502 | 69 |
1229518 | 1229518 | 2021-04-17 | Saline | Illinois | 17165 | 2496 | 69 |
1226270 | 1226270 | 2021-04-16 | Saline | Illinois | 17165 | 2493 | 69 |
1223023 | 1223023 | 2021-04-15 | Saline | Illinois | 17165 | 2490 | 69 |
1219775 | 1219775 | 2021-04-14 | Saline | Illinois | 17165 | 2480 | 69 |
1216527 | 1216527 | 2021-04-13 | Saline | Illinois | 17165 | 2468 | 69 |
1213280 | 1213280 | 2021-04-12 | Saline | Illinois | 17165 | 2469 | 69 |
1210032 | 1210032 | 2021-04-11 | Saline | Illinois | 17165 | 2468 | 69 |
1206783 | 1206783 | 2021-04-10 | Saline | Illinois | 17165 | 2465 | 69 |
1203535 | 1203535 | 2021-04-09 | Saline | Illinois | 17165 | 2463 | 69 |
1200287 | 1200287 | 2021-04-08 | Saline | Illinois | 17165 | 2461 | 69 |
1197038 | 1197038 | 2021-04-07 | Saline | Illinois | 17165 | 2453 | 69 |
1193790 | 1193790 | 2021-04-06 | Saline | Illinois | 17165 | 2452 | 69 |
1190540 | 1190540 | 2021-04-05 | Saline | Illinois | 17165 | 2451 | 69 |
1187293 | 1187293 | 2021-04-04 | Saline | Illinois | 17165 | 2450 | 69 |
1184046 | 1184046 | 2021-04-03 | Saline | Illinois | 17165 | 2448 | 69 |
1180799 | 1180799 | 2021-04-02 | Saline | Illinois | 17165 | 2445 | 69 |
898700 | 898700 | 2021-01-05 | Saline | Kansas | 20169 | 4636 | 69 |
895455 | 895455 | 2021-01-04 | Saline | Kansas | 20169 | 4636 | 69 |
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);