ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
98 rows where deaths = 92 and state = "Montana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 6
- Big Horn 47
- Lewis and Clark 38
- Missoula 8
- Gallatin 3
- Cascade 1
- Yellowstone 1
state 1
- Montana · 98 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2396989 | 2396989 | 2022-04-11 | Big Horn | Montana | 30003 | 4956 | 92 |
2393734 | 2393734 | 2022-04-10 | Big Horn | Montana | 30003 | 4956 | 92 |
2390478 | 2390478 | 2022-04-09 | Big Horn | Montana | 30003 | 4956 | 92 |
2387222 | 2387222 | 2022-04-08 | Big Horn | Montana | 30003 | 4956 | 92 |
2383967 | 2383967 | 2022-04-07 | Big Horn | Montana | 30003 | 4956 | 92 |
2380712 | 2380712 | 2022-04-06 | Big Horn | Montana | 30003 | 4956 | 92 |
2377457 | 2377457 | 2022-04-05 | Big Horn | Montana | 30003 | 4956 | 92 |
2374204 | 2374204 | 2022-04-04 | Big Horn | Montana | 30003 | 4956 | 92 |
2370952 | 2370952 | 2022-04-03 | Big Horn | Montana | 30003 | 4956 | 92 |
2367699 | 2367699 | 2022-04-02 | Big Horn | Montana | 30003 | 4956 | 92 |
2364446 | 2364446 | 2022-04-01 | Big Horn | Montana | 30003 | 4956 | 92 |
2361192 | 2361192 | 2022-03-31 | Big Horn | Montana | 30003 | 4956 | 92 |
2357938 | 2357938 | 2022-03-30 | Big Horn | Montana | 30003 | 4956 | 92 |
2354685 | 2354685 | 2022-03-29 | Big Horn | Montana | 30003 | 4955 | 92 |
2351432 | 2351432 | 2022-03-28 | Big Horn | Montana | 30003 | 4954 | 92 |
2348180 | 2348180 | 2022-03-27 | Big Horn | Montana | 30003 | 4953 | 92 |
2344927 | 2344927 | 2022-03-26 | Big Horn | Montana | 30003 | 4953 | 92 |
2341674 | 2341674 | 2022-03-25 | Big Horn | Montana | 30003 | 4953 | 92 |
2338421 | 2338421 | 2022-03-24 | Big Horn | Montana | 30003 | 4953 | 92 |
2335167 | 2335167 | 2022-03-23 | Big Horn | Montana | 30003 | 4953 | 92 |
2331913 | 2331913 | 2022-03-22 | Big Horn | Montana | 30003 | 4954 | 92 |
2328660 | 2328660 | 2022-03-21 | Big Horn | Montana | 30003 | 4951 | 92 |
2325408 | 2325408 | 2022-03-20 | Big Horn | Montana | 30003 | 4951 | 92 |
2322154 | 2322154 | 2022-03-19 | Big Horn | Montana | 30003 | 4951 | 92 |
2318900 | 2318900 | 2022-03-18 | Big Horn | Montana | 30003 | 4951 | 92 |
2315647 | 2315647 | 2022-03-17 | Big Horn | Montana | 30003 | 4951 | 92 |
2312394 | 2312394 | 2022-03-16 | Big Horn | Montana | 30003 | 4951 | 92 |
2309141 | 2309141 | 2022-03-15 | Big Horn | Montana | 30003 | 4951 | 92 |
2305889 | 2305889 | 2022-03-14 | Big Horn | Montana | 30003 | 4951 | 92 |
2302638 | 2302638 | 2022-03-13 | Big Horn | Montana | 30003 | 4949 | 92 |
2299386 | 2299386 | 2022-03-12 | Big Horn | Montana | 30003 | 4949 | 92 |
2296134 | 2296134 | 2022-03-11 | Big Horn | Montana | 30003 | 4949 | 92 |
2292882 | 2292882 | 2022-03-10 | Big Horn | Montana | 30003 | 4949 | 92 |
2289630 | 2289630 | 2022-03-09 | Big Horn | Montana | 30003 | 4947 | 92 |
2286378 | 2286378 | 2022-03-08 | Big Horn | Montana | 30003 | 4945 | 92 |
2279873 | 2279873 | 2022-03-06 | Big Horn | Montana | 30003 | 4941 | 92 |
2276620 | 2276620 | 2022-03-05 | Big Horn | Montana | 30003 | 4941 | 92 |
2273367 | 2273367 | 2022-03-04 | Big Horn | Montana | 30003 | 4941 | 92 |
2270115 | 2270115 | 2022-03-03 | Big Horn | Montana | 30003 | 4788 | 92 |
2266862 | 2266862 | 2022-03-02 | Big Horn | Montana | 30003 | 4778 | 92 |
2263611 | 2263611 | 2022-03-01 | Big Horn | Montana | 30003 | 4784 | 92 |
2260360 | 2260360 | 2022-02-28 | Big Horn | Montana | 30003 | 4782 | 92 |
2257109 | 2257109 | 2022-02-27 | Big Horn | Montana | 30003 | 4780 | 92 |
2253858 | 2253858 | 2022-02-26 | Big Horn | Montana | 30003 | 4780 | 92 |
2250607 | 2250607 | 2022-02-25 | Big Horn | Montana | 30003 | 4780 | 92 |
2247356 | 2247356 | 2022-02-24 | Big Horn | Montana | 30003 | 4776 | 92 |
2244105 | 2244105 | 2022-02-23 | Big Horn | Montana | 30003 | 4775 | 92 |
1928723 | 1928723 | 2021-11-18 | Gallatin | Montana | 30031 | 21911 | 92 |
1925473 | 1925473 | 2021-11-17 | Gallatin | Montana | 30031 | 21829 | 92 |
1922224 | 1922224 | 2021-11-16 | Gallatin | Montana | 30031 | 21775 | 92 |
1577847 | 1577847 | 2021-08-02 | Lewis and Clark | Montana | 30049 | 7197 | 92 |
1574599 | 1574599 | 2021-08-01 | Lewis and Clark | Montana | 30049 | 7160 | 92 |
1571351 | 1571351 | 2021-07-31 | Lewis and Clark | Montana | 30049 | 7160 | 92 |
1568103 | 1568103 | 2021-07-30 | Lewis and Clark | Montana | 30049 | 7160 | 92 |
1564855 | 1564855 | 2021-07-29 | Lewis and Clark | Montana | 30049 | 7142 | 92 |
1561607 | 1561607 | 2021-07-28 | Lewis and Clark | Montana | 30049 | 7139 | 92 |
1558359 | 1558359 | 2021-07-27 | Lewis and Clark | Montana | 30049 | 7126 | 92 |
1555112 | 1555112 | 2021-07-26 | Lewis and Clark | Montana | 30049 | 7107 | 92 |
1551865 | 1551865 | 2021-07-25 | Lewis and Clark | Montana | 30049 | 7098 | 92 |
1548618 | 1548618 | 2021-07-24 | Lewis and Clark | Montana | 30049 | 7098 | 92 |
1545371 | 1545371 | 2021-07-23 | Lewis and Clark | Montana | 30049 | 7098 | 92 |
1542123 | 1542123 | 2021-07-22 | Lewis and Clark | Montana | 30049 | 7096 | 92 |
1538876 | 1538876 | 2021-07-21 | Lewis and Clark | Montana | 30049 | 7095 | 92 |
1535629 | 1535629 | 2021-07-20 | Lewis and Clark | Montana | 30049 | 7091 | 92 |
1532381 | 1532381 | 2021-07-19 | Lewis and Clark | Montana | 30049 | 7088 | 92 |
1529134 | 1529134 | 2021-07-18 | Lewis and Clark | Montana | 30049 | 7085 | 92 |
1525887 | 1525887 | 2021-07-17 | Lewis and Clark | Montana | 30049 | 7085 | 92 |
1522640 | 1522640 | 2021-07-16 | Lewis and Clark | Montana | 30049 | 7085 | 92 |
1519391 | 1519391 | 2021-07-15 | Lewis and Clark | Montana | 30049 | 7079 | 92 |
1516144 | 1516144 | 2021-07-14 | Lewis and Clark | Montana | 30049 | 7078 | 92 |
1506405 | 1506405 | 2021-07-11 | Lewis and Clark | Montana | 30049 | 7074 | 92 |
1503159 | 1503159 | 2021-07-10 | Lewis and Clark | Montana | 30049 | 7074 | 92 |
1499913 | 1499913 | 2021-07-09 | Lewis and Clark | Montana | 30049 | 7074 | 92 |
1496667 | 1496667 | 2021-07-08 | Lewis and Clark | Montana | 30049 | 7072 | 92 |
1493420 | 1493420 | 2021-07-07 | Lewis and Clark | Montana | 30049 | 7071 | 92 |
1490173 | 1490173 | 2021-07-06 | Lewis and Clark | Montana | 30049 | 7069 | 92 |
1486926 | 1486926 | 2021-07-05 | Lewis and Clark | Montana | 30049 | 7069 | 92 |
1483680 | 1483680 | 2021-07-04 | Lewis and Clark | Montana | 30049 | 7069 | 92 |
1480434 | 1480434 | 2021-07-03 | Lewis and Clark | Montana | 30049 | 7069 | 92 |
1477187 | 1477187 | 2021-07-02 | Lewis and Clark | Montana | 30049 | 7069 | 92 |
1473941 | 1473941 | 2021-07-01 | Lewis and Clark | Montana | 30049 | 7068 | 92 |
1470695 | 1470695 | 2021-06-30 | Lewis and Clark | Montana | 30049 | 7064 | 92 |
1467450 | 1467450 | 2021-06-29 | Lewis and Clark | Montana | 30049 | 7062 | 92 |
1464205 | 1464205 | 2021-06-28 | Lewis and Clark | Montana | 30049 | 7058 | 92 |
1460960 | 1460960 | 2021-06-27 | Lewis and Clark | Montana | 30049 | 7053 | 92 |
1457715 | 1457715 | 2021-06-26 | Lewis and Clark | Montana | 30049 | 7053 | 92 |
1454470 | 1454470 | 2021-06-25 | Lewis and Clark | Montana | 30049 | 7053 | 92 |
1451225 | 1451225 | 2021-06-24 | Lewis and Clark | Montana | 30049 | 7049 | 92 |
1236977 | 1236977 | 2021-04-19 | Missoula | Montana | 30063 | 8912 | 92 |
1233730 | 1233730 | 2021-04-18 | Missoula | Montana | 30063 | 8905 | 92 |
1230482 | 1230482 | 2021-04-17 | Missoula | Montana | 30063 | 8890 | 92 |
1227234 | 1227234 | 2021-04-16 | Missoula | Montana | 30063 | 8887 | 92 |
1223986 | 1223986 | 2021-04-15 | Missoula | Montana | 30063 | 8888 | 92 |
1220739 | 1220739 | 2021-04-14 | Missoula | Montana | 30063 | 8869 | 92 |
1217491 | 1217491 | 2021-04-13 | Missoula | Montana | 30063 | 8858 | 92 |
1214244 | 1214244 | 2021-04-12 | Missoula | Montana | 30063 | 8849 | 92 |
870132 | 870132 | 2020-12-27 | Cascade | Montana | 30013 | 6551 | 92 |
681976 | 681976 | 2020-10-30 | Yellowstone | Montana | 30111 | 6728 | 92 |
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);