ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
56 rows where deaths = 28 and fips = 46009 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 |
---|---|---|---|---|---|---|---|
1559187 | 1559187 | 2021-07-27 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1555940 | 1555940 | 2021-07-26 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1552693 | 1552693 | 2021-07-25 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1549446 | 1549446 | 2021-07-24 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1546199 | 1546199 | 2021-07-23 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1542952 | 1542952 | 2021-07-22 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1539704 | 1539704 | 2021-07-21 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1536457 | 1536457 | 2021-07-20 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1533209 | 1533209 | 2021-07-19 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1529962 | 1529962 | 2021-07-18 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1526715 | 1526715 | 2021-07-17 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1523468 | 1523468 | 2021-07-16 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1520220 | 1520220 | 2021-07-15 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1516972 | 1516972 | 2021-07-14 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1513725 | 1513725 | 2021-07-13 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1510479 | 1510479 | 2021-07-12 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1507232 | 1507232 | 2021-07-11 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1503986 | 1503986 | 2021-07-10 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1500740 | 1500740 | 2021-07-09 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1497494 | 1497494 | 2021-07-08 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1494247 | 1494247 | 2021-07-07 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1491000 | 1491000 | 2021-07-06 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1487753 | 1487753 | 2021-07-05 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1484506 | 1484506 | 2021-07-04 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1481260 | 1481260 | 2021-07-03 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1478013 | 1478013 | 2021-07-02 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1474767 | 1474767 | 2021-07-01 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1471521 | 1471521 | 2021-06-30 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1468276 | 1468276 | 2021-06-29 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1465031 | 1465031 | 2021-06-28 | Bon Homme | South Dakota | 46009 | 1555 | 28 |
1461786 | 1461786 | 2021-06-27 | Bon Homme | South Dakota | 46009 | 1555 | 28 |
1458541 | 1458541 | 2021-06-26 | Bon Homme | South Dakota | 46009 | 1555 | 28 |
1455296 | 1455296 | 2021-06-25 | Bon Homme | South Dakota | 46009 | 1555 | 28 |
1452051 | 1452051 | 2021-06-24 | Bon Homme | South Dakota | 46009 | 1555 | 28 |
1448805 | 1448805 | 2021-06-23 | Bon Homme | South Dakota | 46009 | 1555 | 28 |
1445560 | 1445560 | 2021-06-22 | Bon Homme | South Dakota | 46009 | 1555 | 28 |
1442315 | 1442315 | 2021-06-21 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1439070 | 1439070 | 2021-06-20 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1435823 | 1435823 | 2021-06-19 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1432576 | 1432576 | 2021-06-18 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1429330 | 1429330 | 2021-06-17 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1426085 | 1426085 | 2021-06-16 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1422838 | 1422838 | 2021-06-15 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1419592 | 1419592 | 2021-06-14 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1416347 | 1416347 | 2021-06-13 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1413101 | 1413101 | 2021-06-12 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1409856 | 1409856 | 2021-06-11 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1406611 | 1406611 | 2021-06-10 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1403365 | 1403365 | 2021-06-09 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1400120 | 1400120 | 2021-06-08 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1396875 | 1396875 | 2021-06-07 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1393628 | 1393628 | 2021-06-06 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1390383 | 1390383 | 2021-06-05 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1387138 | 1387138 | 2021-06-04 | Bon Homme | South Dakota | 46009 | 1554 | 28 |
1383893 | 1383893 | 2021-06-03 | Bon Homme | South Dakota | 46009 | 1555 | 28 |
1380647 | 1380647 | 2021-06-02 | Bon Homme | South Dakota | 46009 | 1555 | 28 |
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);