ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
50 rows where deaths = 54 and fips = 30085 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 |
---|---|---|---|---|---|---|---|
1402557 | 1402557 | 2021-06-09 | Roosevelt | Montana | 30085 | 1667 | 54 |
1399312 | 1399312 | 2021-06-08 | Roosevelt | Montana | 30085 | 1666 | 54 |
1396066 | 1396066 | 2021-06-07 | Roosevelt | Montana | 30085 | 1664 | 54 |
1392820 | 1392820 | 2021-06-06 | Roosevelt | Montana | 30085 | 1663 | 54 |
1389575 | 1389575 | 2021-06-05 | Roosevelt | Montana | 30085 | 1663 | 54 |
1386330 | 1386330 | 2021-06-04 | Roosevelt | Montana | 30085 | 1663 | 54 |
1383085 | 1383085 | 2021-06-03 | Roosevelt | Montana | 30085 | 1662 | 54 |
1379839 | 1379839 | 2021-06-02 | Roosevelt | Montana | 30085 | 1661 | 54 |
1376594 | 1376594 | 2021-06-01 | Roosevelt | Montana | 30085 | 1660 | 54 |
1373348 | 1373348 | 2021-05-31 | Roosevelt | Montana | 30085 | 1660 | 54 |
1370103 | 1370103 | 2021-05-30 | Roosevelt | Montana | 30085 | 1658 | 54 |
1366857 | 1366857 | 2021-05-29 | Roosevelt | Montana | 30085 | 1658 | 54 |
1363611 | 1363611 | 2021-05-28 | Roosevelt | Montana | 30085 | 1658 | 54 |
1360364 | 1360364 | 2021-05-27 | Roosevelt | Montana | 30085 | 1656 | 54 |
1357118 | 1357118 | 2021-05-26 | Roosevelt | Montana | 30085 | 1653 | 54 |
1353872 | 1353872 | 2021-05-25 | Roosevelt | Montana | 30085 | 1651 | 54 |
1350626 | 1350626 | 2021-05-24 | Roosevelt | Montana | 30085 | 1640 | 54 |
1347380 | 1347380 | 2021-05-23 | Roosevelt | Montana | 30085 | 1640 | 54 |
1344132 | 1344132 | 2021-05-22 | Roosevelt | Montana | 30085 | 1640 | 54 |
1340884 | 1340884 | 2021-05-21 | Roosevelt | Montana | 30085 | 1640 | 54 |
1337636 | 1337636 | 2021-05-20 | Roosevelt | Montana | 30085 | 1635 | 54 |
1334389 | 1334389 | 2021-05-19 | Roosevelt | Montana | 30085 | 1635 | 54 |
1331142 | 1331142 | 2021-05-18 | Roosevelt | Montana | 30085 | 1635 | 54 |
1327895 | 1327895 | 2021-05-17 | Roosevelt | Montana | 30085 | 1634 | 54 |
1324649 | 1324649 | 2021-05-16 | Roosevelt | Montana | 30085 | 1634 | 54 |
1321403 | 1321403 | 2021-05-15 | Roosevelt | Montana | 30085 | 1634 | 54 |
1318157 | 1318157 | 2021-05-14 | Roosevelt | Montana | 30085 | 1633 | 54 |
1314909 | 1314909 | 2021-05-13 | Roosevelt | Montana | 30085 | 1633 | 54 |
1311663 | 1311663 | 2021-05-12 | Roosevelt | Montana | 30085 | 1632 | 54 |
1308416 | 1308416 | 2021-05-11 | Roosevelt | Montana | 30085 | 1631 | 54 |
1305170 | 1305170 | 2021-05-10 | Roosevelt | Montana | 30085 | 1631 | 54 |
1301924 | 1301924 | 2021-05-09 | Roosevelt | Montana | 30085 | 1631 | 54 |
1298676 | 1298676 | 2021-05-08 | Roosevelt | Montana | 30085 | 1631 | 54 |
1295430 | 1295430 | 2021-05-07 | Roosevelt | Montana | 30085 | 1630 | 54 |
1292184 | 1292184 | 2021-05-06 | Roosevelt | Montana | 30085 | 1629 | 54 |
1288938 | 1288938 | 2021-05-05 | Roosevelt | Montana | 30085 | 1630 | 54 |
1285692 | 1285692 | 2021-05-04 | Roosevelt | Montana | 30085 | 1627 | 54 |
1282446 | 1282446 | 2021-05-03 | Roosevelt | Montana | 30085 | 1627 | 54 |
1279199 | 1279199 | 2021-05-02 | Roosevelt | Montana | 30085 | 1627 | 54 |
1275952 | 1275952 | 2021-05-01 | Roosevelt | Montana | 30085 | 1627 | 54 |
1272705 | 1272705 | 2021-04-30 | Roosevelt | Montana | 30085 | 1627 | 54 |
1269458 | 1269458 | 2021-04-29 | Roosevelt | Montana | 30085 | 1625 | 54 |
1266211 | 1266211 | 2021-04-28 | Roosevelt | Montana | 30085 | 1625 | 54 |
1262964 | 1262964 | 2021-04-27 | Roosevelt | Montana | 30085 | 1624 | 54 |
1259717 | 1259717 | 2021-04-26 | Roosevelt | Montana | 30085 | 1621 | 54 |
1256470 | 1256470 | 2021-04-25 | Roosevelt | Montana | 30085 | 1620 | 54 |
1253223 | 1253223 | 2021-04-24 | Roosevelt | Montana | 30085 | 1620 | 54 |
1249976 | 1249976 | 2021-04-23 | Roosevelt | Montana | 30085 | 1617 | 54 |
1246729 | 1246729 | 2021-04-22 | Roosevelt | Montana | 30085 | 1617 | 54 |
1243482 | 1243482 | 2021-04-21 | Roosevelt | Montana | 30085 | 1616 | 54 |
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);