ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
155 rows where deaths = 42 and state = "Montana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
county 10
- Glacier 69
- Roosevelt 27
- Hill 18
- Sanders 10
- Lake 9
- Lewis and Clark 9
- Rosebud 6
- Dawson 4
- Missoula 2
- Yellowstone 1
state 1
- Montana · 155 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2166093 | 2166093 | 2022-01-30 | Sanders | Montana | 30089 | 1996 | 42 |
2162838 | 2162838 | 2022-01-29 | Sanders | Montana | 30089 | 1996 | 42 |
2159583 | 2159583 | 2022-01-28 | Sanders | Montana | 30089 | 1996 | 42 |
2156329 | 2156329 | 2022-01-27 | Sanders | Montana | 30089 | 1969 | 42 |
2153076 | 2153076 | 2022-01-26 | Sanders | Montana | 30089 | 1966 | 42 |
2149824 | 2149824 | 2022-01-25 | Sanders | Montana | 30089 | 1925 | 42 |
2146572 | 2146572 | 2022-01-24 | Sanders | Montana | 30089 | 1917 | 42 |
2143317 | 2143317 | 2022-01-23 | Sanders | Montana | 30089 | 1890 | 42 |
2140062 | 2140062 | 2022-01-22 | Sanders | Montana | 30089 | 1890 | 42 |
2136806 | 2136806 | 2022-01-21 | Sanders | Montana | 30089 | 1890 | 42 |
1847482 | 1847482 | 2021-10-24 | Dawson | Montana | 30021 | 1565 | 42 |
1844232 | 1844232 | 2021-10-23 | Dawson | Montana | 30021 | 1565 | 42 |
1840982 | 1840982 | 2021-10-22 | Dawson | Montana | 30021 | 1565 | 42 |
1837733 | 1837733 | 2021-10-21 | Dawson | Montana | 30021 | 1551 | 42 |
1672051 | 1672051 | 2021-08-31 | Lake | Montana | 30047 | 2461 | 42 |
1668804 | 1668804 | 2021-08-30 | Lake | Montana | 30047 | 2440 | 42 |
1665557 | 1665557 | 2021-08-29 | Lake | Montana | 30047 | 2419 | 42 |
1662309 | 1662309 | 2021-08-28 | Lake | Montana | 30047 | 2419 | 42 |
1659061 | 1659061 | 2021-08-27 | Lake | Montana | 30047 | 2419 | 42 |
1655812 | 1655812 | 2021-08-26 | Lake | Montana | 30047 | 2407 | 42 |
1652565 | 1652565 | 2021-08-25 | Lake | Montana | 30047 | 2393 | 42 |
1649317 | 1649317 | 2021-08-24 | Lake | Montana | 30047 | 2384 | 42 |
1646068 | 1646068 | 2021-08-23 | Lake | Montana | 30047 | 2355 | 42 |
1444727 | 1444727 | 2021-06-22 | Glacier | Montana | 30035 | 1546 | 42 |
1441482 | 1441482 | 2021-06-21 | Glacier | Montana | 30035 | 1546 | 42 |
1438236 | 1438236 | 2021-06-20 | Glacier | Montana | 30035 | 1546 | 42 |
1434989 | 1434989 | 2021-06-19 | Glacier | Montana | 30035 | 1546 | 42 |
1431742 | 1431742 | 2021-06-18 | Glacier | Montana | 30035 | 1546 | 42 |
1428497 | 1428497 | 2021-06-17 | Glacier | Montana | 30035 | 1546 | 42 |
1425252 | 1425252 | 2021-06-16 | Glacier | Montana | 30035 | 1546 | 42 |
1422004 | 1422004 | 2021-06-15 | Glacier | Montana | 30035 | 1546 | 42 |
1418759 | 1418759 | 2021-06-14 | Glacier | Montana | 30035 | 1546 | 42 |
1415514 | 1415514 | 2021-06-13 | Glacier | Montana | 30035 | 1545 | 42 |
1412268 | 1412268 | 2021-06-12 | Glacier | Montana | 30035 | 1545 | 42 |
1409023 | 1409023 | 2021-06-11 | Glacier | Montana | 30035 | 1545 | 42 |
1405778 | 1405778 | 2021-06-10 | Glacier | Montana | 30035 | 1545 | 42 |
1402532 | 1402532 | 2021-06-09 | Glacier | Montana | 30035 | 1544 | 42 |
1399287 | 1399287 | 2021-06-08 | Glacier | Montana | 30035 | 1544 | 42 |
1396041 | 1396041 | 2021-06-07 | Glacier | Montana | 30035 | 1543 | 42 |
1392795 | 1392795 | 2021-06-06 | Glacier | Montana | 30035 | 1543 | 42 |
1389550 | 1389550 | 2021-06-05 | Glacier | Montana | 30035 | 1543 | 42 |
1386305 | 1386305 | 2021-06-04 | Glacier | Montana | 30035 | 1543 | 42 |
1383060 | 1383060 | 2021-06-03 | Glacier | Montana | 30035 | 1542 | 42 |
1379814 | 1379814 | 2021-06-02 | Glacier | Montana | 30035 | 1542 | 42 |
1376569 | 1376569 | 2021-06-01 | Glacier | Montana | 30035 | 1541 | 42 |
1373323 | 1373323 | 2021-05-31 | Glacier | Montana | 30035 | 1541 | 42 |
1370078 | 1370078 | 2021-05-30 | Glacier | Montana | 30035 | 1541 | 42 |
1366832 | 1366832 | 2021-05-29 | Glacier | Montana | 30035 | 1541 | 42 |
1363586 | 1363586 | 2021-05-28 | Glacier | Montana | 30035 | 1541 | 42 |
1360339 | 1360339 | 2021-05-27 | Glacier | Montana | 30035 | 1542 | 42 |
1357093 | 1357093 | 2021-05-26 | Glacier | Montana | 30035 | 1540 | 42 |
1353847 | 1353847 | 2021-05-25 | Glacier | Montana | 30035 | 1540 | 42 |
1350601 | 1350601 | 2021-05-24 | Glacier | Montana | 30035 | 1540 | 42 |
1347355 | 1347355 | 2021-05-23 | Glacier | Montana | 30035 | 1540 | 42 |
1344107 | 1344107 | 2021-05-22 | Glacier | Montana | 30035 | 1540 | 42 |
1340859 | 1340859 | 2021-05-21 | Glacier | Montana | 30035 | 1541 | 42 |
1337611 | 1337611 | 2021-05-20 | Glacier | Montana | 30035 | 1540 | 42 |
1334364 | 1334364 | 2021-05-19 | Glacier | Montana | 30035 | 1540 | 42 |
1331117 | 1331117 | 2021-05-18 | Glacier | Montana | 30035 | 1539 | 42 |
1327870 | 1327870 | 2021-05-17 | Glacier | Montana | 30035 | 1538 | 42 |
1324624 | 1324624 | 2021-05-16 | Glacier | Montana | 30035 | 1538 | 42 |
1321378 | 1321378 | 2021-05-15 | Glacier | Montana | 30035 | 1538 | 42 |
1318132 | 1318132 | 2021-05-14 | Glacier | Montana | 30035 | 1538 | 42 |
1314884 | 1314884 | 2021-05-13 | Glacier | Montana | 30035 | 1535 | 42 |
1311638 | 1311638 | 2021-05-12 | Glacier | Montana | 30035 | 1535 | 42 |
1308391 | 1308391 | 2021-05-11 | Glacier | Montana | 30035 | 1535 | 42 |
1305145 | 1305145 | 2021-05-10 | Glacier | Montana | 30035 | 1533 | 42 |
1301899 | 1301899 | 2021-05-09 | Glacier | Montana | 30035 | 1533 | 42 |
1298651 | 1298651 | 2021-05-08 | Glacier | Montana | 30035 | 1533 | 42 |
1295405 | 1295405 | 2021-05-07 | Glacier | Montana | 30035 | 1530 | 42 |
1292159 | 1292159 | 2021-05-06 | Glacier | Montana | 30035 | 1529 | 42 |
1288913 | 1288913 | 2021-05-05 | Glacier | Montana | 30035 | 1529 | 42 |
1285667 | 1285667 | 2021-05-04 | Glacier | Montana | 30035 | 1529 | 42 |
1282421 | 1282421 | 2021-05-03 | Glacier | Montana | 30035 | 1528 | 42 |
1279174 | 1279174 | 2021-05-02 | Glacier | Montana | 30035 | 1528 | 42 |
1275927 | 1275927 | 2021-05-01 | Glacier | Montana | 30035 | 1528 | 42 |
1272680 | 1272680 | 2021-04-30 | Glacier | Montana | 30035 | 1528 | 42 |
1269433 | 1269433 | 2021-04-29 | Glacier | Montana | 30035 | 1528 | 42 |
1266186 | 1266186 | 2021-04-28 | Glacier | Montana | 30035 | 1528 | 42 |
1262939 | 1262939 | 2021-04-27 | Glacier | Montana | 30035 | 1528 | 42 |
1259692 | 1259692 | 2021-04-26 | Glacier | Montana | 30035 | 1528 | 42 |
1256445 | 1256445 | 2021-04-25 | Glacier | Montana | 30035 | 1528 | 42 |
1253198 | 1253198 | 2021-04-24 | Glacier | Montana | 30035 | 1528 | 42 |
1249951 | 1249951 | 2021-04-23 | Glacier | Montana | 30035 | 1528 | 42 |
1246704 | 1246704 | 2021-04-22 | Glacier | Montana | 30035 | 1528 | 42 |
1243457 | 1243457 | 2021-04-21 | Glacier | Montana | 30035 | 1528 | 42 |
1240210 | 1240210 | 2021-04-20 | Glacier | Montana | 30035 | 1529 | 42 |
1236963 | 1236963 | 2021-04-19 | Glacier | Montana | 30035 | 1529 | 42 |
1233716 | 1233716 | 2021-04-18 | Glacier | Montana | 30035 | 1528 | 42 |
1230468 | 1230468 | 2021-04-17 | Glacier | Montana | 30035 | 1528 | 42 |
1227220 | 1227220 | 2021-04-16 | Glacier | Montana | 30035 | 1529 | 42 |
1223972 | 1223972 | 2021-04-15 | Glacier | Montana | 30035 | 1529 | 42 |
1191493 | 1191493 | 2021-04-05 | Hill | Montana | 30041 | 1945 | 42 |
1188245 | 1188245 | 2021-04-04 | Hill | Montana | 30041 | 1945 | 42 |
1184998 | 1184998 | 2021-04-03 | Hill | Montana | 30041 | 1945 | 42 |
1181752 | 1181752 | 2021-04-02 | Hill | Montana | 30041 | 1944 | 42 |
1178505 | 1178505 | 2021-04-01 | Hill | Montana | 30041 | 1944 | 42 |
1175258 | 1175258 | 2021-03-31 | Hill | Montana | 30041 | 1940 | 42 |
1172011 | 1172011 | 2021-03-30 | Hill | Montana | 30041 | 1940 | 42 |
1168763 | 1168763 | 2021-03-29 | Hill | Montana | 30041 | 1940 | 42 |
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);