ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
62 rows where deaths = 16 and fips = 30023 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 |
---|---|---|---|---|---|---|---|
1623316 | 1623316 | 2021-08-16 | Deer Lodge | Montana | 30023 | 1195 | 16 |
1620069 | 1620069 | 2021-08-15 | Deer Lodge | Montana | 30023 | 1185 | 16 |
1616821 | 1616821 | 2021-08-14 | Deer Lodge | Montana | 30023 | 1185 | 16 |
1613573 | 1613573 | 2021-08-13 | Deer Lodge | Montana | 30023 | 1185 | 16 |
1610324 | 1610324 | 2021-08-12 | Deer Lodge | Montana | 30023 | 1184 | 16 |
1607076 | 1607076 | 2021-08-11 | Deer Lodge | Montana | 30023 | 1184 | 16 |
1603827 | 1603827 | 2021-08-10 | Deer Lodge | Montana | 30023 | 1182 | 16 |
1600578 | 1600578 | 2021-08-09 | Deer Lodge | Montana | 30023 | 1179 | 16 |
1597330 | 1597330 | 2021-08-08 | Deer Lodge | Montana | 30023 | 1173 | 16 |
1594081 | 1594081 | 2021-08-07 | Deer Lodge | Montana | 30023 | 1173 | 16 |
1590832 | 1590832 | 2021-08-06 | Deer Lodge | Montana | 30023 | 1173 | 16 |
1587583 | 1587583 | 2021-08-05 | Deer Lodge | Montana | 30023 | 1173 | 16 |
1584332 | 1584332 | 2021-08-04 | Deer Lodge | Montana | 30023 | 1173 | 16 |
1581083 | 1581083 | 2021-08-03 | Deer Lodge | Montana | 30023 | 1163 | 16 |
1577834 | 1577834 | 2021-08-02 | Deer Lodge | Montana | 30023 | 1156 | 16 |
1574586 | 1574586 | 2021-08-01 | Deer Lodge | Montana | 30023 | 1151 | 16 |
1571338 | 1571338 | 2021-07-31 | Deer Lodge | Montana | 30023 | 1151 | 16 |
1568090 | 1568090 | 2021-07-30 | Deer Lodge | Montana | 30023 | 1151 | 16 |
1564842 | 1564842 | 2021-07-29 | Deer Lodge | Montana | 30023 | 1147 | 16 |
1561594 | 1561594 | 2021-07-28 | Deer Lodge | Montana | 30023 | 1141 | 16 |
1558346 | 1558346 | 2021-07-27 | Deer Lodge | Montana | 30023 | 1140 | 16 |
1555099 | 1555099 | 2021-07-26 | Deer Lodge | Montana | 30023 | 1136 | 16 |
1551852 | 1551852 | 2021-07-25 | Deer Lodge | Montana | 30023 | 1130 | 16 |
1548605 | 1548605 | 2021-07-24 | Deer Lodge | Montana | 30023 | 1130 | 16 |
1545358 | 1545358 | 2021-07-23 | Deer Lodge | Montana | 30023 | 1130 | 16 |
1542110 | 1542110 | 2021-07-22 | Deer Lodge | Montana | 30023 | 1130 | 16 |
1538863 | 1538863 | 2021-07-21 | Deer Lodge | Montana | 30023 | 1130 | 16 |
1535616 | 1535616 | 2021-07-20 | Deer Lodge | Montana | 30023 | 1130 | 16 |
1532368 | 1532368 | 2021-07-19 | Deer Lodge | Montana | 30023 | 1130 | 16 |
1529121 | 1529121 | 2021-07-18 | Deer Lodge | Montana | 30023 | 1130 | 16 |
1525874 | 1525874 | 2021-07-17 | Deer Lodge | Montana | 30023 | 1130 | 16 |
1522627 | 1522627 | 2021-07-16 | Deer Lodge | Montana | 30023 | 1130 | 16 |
1519378 | 1519378 | 2021-07-15 | Deer Lodge | Montana | 30023 | 1130 | 16 |
1516131 | 1516131 | 2021-07-14 | Deer Lodge | Montana | 30023 | 1130 | 16 |
1512885 | 1512885 | 2021-07-13 | Deer Lodge | Montana | 30023 | 1130 | 16 |
1509638 | 1509638 | 2021-07-12 | Deer Lodge | Montana | 30023 | 1130 | 16 |
1506392 | 1506392 | 2021-07-11 | Deer Lodge | Montana | 30023 | 1130 | 16 |
1503146 | 1503146 | 2021-07-10 | Deer Lodge | Montana | 30023 | 1130 | 16 |
1499900 | 1499900 | 2021-07-09 | Deer Lodge | Montana | 30023 | 1130 | 16 |
1496654 | 1496654 | 2021-07-08 | Deer Lodge | Montana | 30023 | 1128 | 16 |
1493407 | 1493407 | 2021-07-07 | Deer Lodge | Montana | 30023 | 1128 | 16 |
1490160 | 1490160 | 2021-07-06 | Deer Lodge | Montana | 30023 | 1128 | 16 |
1486913 | 1486913 | 2021-07-05 | Deer Lodge | Montana | 30023 | 1128 | 16 |
1483667 | 1483667 | 2021-07-04 | Deer Lodge | Montana | 30023 | 1128 | 16 |
1480421 | 1480421 | 2021-07-03 | Deer Lodge | Montana | 30023 | 1128 | 16 |
1477174 | 1477174 | 2021-07-02 | Deer Lodge | Montana | 30023 | 1128 | 16 |
1473928 | 1473928 | 2021-07-01 | Deer Lodge | Montana | 30023 | 1126 | 16 |
1470682 | 1470682 | 2021-06-30 | Deer Lodge | Montana | 30023 | 1126 | 16 |
1467437 | 1467437 | 2021-06-29 | Deer Lodge | Montana | 30023 | 1126 | 16 |
1464192 | 1464192 | 2021-06-28 | Deer Lodge | Montana | 30023 | 1126 | 16 |
1460947 | 1460947 | 2021-06-27 | Deer Lodge | Montana | 30023 | 1125 | 16 |
1457702 | 1457702 | 2021-06-26 | Deer Lodge | Montana | 30023 | 1125 | 16 |
1454457 | 1454457 | 2021-06-25 | Deer Lodge | Montana | 30023 | 1125 | 16 |
1451212 | 1451212 | 2021-06-24 | Deer Lodge | Montana | 30023 | 1125 | 16 |
1447966 | 1447966 | 2021-06-23 | Deer Lodge | Montana | 30023 | 1125 | 16 |
1444721 | 1444721 | 2021-06-22 | Deer Lodge | Montana | 30023 | 1124 | 16 |
1441476 | 1441476 | 2021-06-21 | Deer Lodge | Montana | 30023 | 1124 | 16 |
1438230 | 1438230 | 2021-06-20 | Deer Lodge | Montana | 30023 | 1123 | 16 |
1434983 | 1434983 | 2021-06-19 | Deer Lodge | Montana | 30023 | 1123 | 16 |
1431736 | 1431736 | 2021-06-18 | Deer Lodge | Montana | 30023 | 1123 | 16 |
1428491 | 1428491 | 2021-06-17 | Deer Lodge | Montana | 30023 | 1123 | 16 |
1425246 | 1425246 | 2021-06-16 | Deer Lodge | Montana | 30023 | 1123 | 16 |
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);