ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
40,656 rows where state = "Montana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
- 30031 792
- 30049 792
- 30093 792
- 30111 792
- 30063 791
- 30007 786
- 30029 786
- 30057 786
- 30085 786
- 30013 784
- 30081 784
- 30043 781
- 30041 780
- 30053 779
- 30059 779
- 30101 779
- 30047 778
- 30067 778
- 30023 776
- 30051 774
- 30065 774
- 30009 773
- 30035 771
- 30001 770
- 30083 766
- 30095 765
- 30003 764
- 30037 763
- 30073 759
- 30107 750
- …
county >30
- Gallatin 792
- Lewis and Clark 792
- Silver Bow 792
- Yellowstone 792
- Missoula 791
- Broadwater 786
- Flathead 786
- Madison 786
- Roosevelt 786
- Cascade 784
- Ravalli 784
- Jefferson 781
- Hill 780
- Lincoln 779
- Meagher 779
- Toole 779
- Lake 778
- Park 778
- Deer Lodge 776
- Liberty 774
- Musselshell 774
- Carbon 773
- Glacier 771
- Beaverhead 770
- Richland 766
- Stillwater 765
- Big Horn 764
- Golden Valley 763
- Pondera 759
- Wheatland 750
- …
state 1
- Montana · 40,656 ✖
| Link | rowid | date ▲ | county | state | fips | cases | deaths |
|---|---|---|---|---|---|---|---|
| 2501193 | 2501193 | 2022-05-13 | Beaverhead | Montana | 30001 | 2137 | 30 |
| 2501194 | 2501194 | 2022-05-13 | Big Horn | Montana | 30003 | 4980 | 96 |
| 2501195 | 2501195 | 2022-05-13 | Blaine | Montana | 30005 | 2077 | 32 |
| 2501196 | 2501196 | 2022-05-13 | Broadwater | Montana | 30007 | 1283 | 21 |
| 2501197 | 2501197 | 2022-05-13 | Carbon | Montana | 30009 | 2080 | 28 |
| 2501198 | 2501198 | 2022-05-13 | Carter | Montana | 30011 | 252 | 5 |
| 2501199 | 2501199 | 2022-05-13 | Cascade | Montana | 30013 | 25246 | 341 |
| 2501200 | 2501200 | 2022-05-13 | Chouteau | Montana | 30015 | 991 | 14 |
| 2501201 | 2501201 | 2022-05-13 | Custer | Montana | 30017 | 3062 | 48 |
| 2501202 | 2501202 | 2022-05-13 | Daniels | Montana | 30019 | 386 | 9 |
| 2501203 | 2501203 | 2022-05-13 | Dawson | Montana | 30021 | 2357 | 58 |
| 2501204 | 2501204 | 2022-05-13 | Deer Lodge | Montana | 30023 | 2563 | 29 |
| 2501205 | 2501205 | 2022-05-13 | Fallon | Montana | 30025 | 680 | 10 |
| 2501206 | 2501206 | 2022-05-13 | Fergus | Montana | 30027 | 2515 | 56 |
| 2501207 | 2501207 | 2022-05-13 | Flathead | Montana | 30029 | 29318 | 281 |
| 2501208 | 2501208 | 2022-05-13 | Gallatin | Montana | 30031 | 34972 | 122 |
| 2501209 | 2501209 | 2022-05-13 | Garfield | Montana | 30033 | 225 | 3 |
| 2501210 | 2501210 | 2022-05-13 | Glacier | Montana | 30035 | 3978 | 74 |
| 2501211 | 2501211 | 2022-05-13 | Golden Valley | Montana | 30037 | 150 | 5 |
| 2501212 | 2501212 | 2022-05-13 | Granite | Montana | 30039 | 537 | 9 |
| 2501213 | 2501213 | 2022-05-13 | Hill | Montana | 30041 | 4574 | 73 |
| 2501214 | 2501214 | 2022-05-13 | Jefferson | Montana | 30043 | 2601 | 23 |
| 2501215 | 2501215 | 2022-05-13 | Judith Basin | Montana | 30045 | 225 | 1 |
| 2501216 | 2501216 | 2022-05-13 | Lake | Montana | 30047 | 6634 | 100 |
| 2501217 | 2501217 | 2022-05-13 | Lewis and Clark | Montana | 30049 | 17709 | 185 |
| 2501218 | 2501218 | 2022-05-13 | Liberty | Montana | 30051 | 398 | 4 |
| 2501219 | 2501219 | 2022-05-13 | Lincoln | Montana | 30053 | 4787 | 89 |
| 2501220 | 2501220 | 2022-05-13 | Madison | Montana | 30057 | 1819 | 20 |
| 2501221 | 2501221 | 2022-05-13 | McCone | Montana | 30055 | 383 | 9 |
| 2501222 | 2501222 | 2022-05-13 | Meagher | Montana | 30059 | 412 | 10 |
| 2501223 | 2501223 | 2022-05-13 | Mineral | Montana | 30061 | 1100 | 17 |
| 2501224 | 2501224 | 2022-05-13 | Missoula | Montana | 30063 | 27678 | 209 |
| 2501225 | 2501225 | 2022-05-13 | Musselshell | Montana | 30065 | 917 | 31 |
| 2501226 | 2501226 | 2022-05-13 | Park | Montana | 30067 | 4260 | 35 |
| 2501227 | 2501227 | 2022-05-13 | Petroleum | Montana | 30069 | 35 | 1 |
| 2501228 | 2501228 | 2022-05-13 | Phillips | Montana | 30071 | 1060 | 28 |
| 2501229 | 2501229 | 2022-05-13 | Pondera | Montana | 30073 | 1183 | 8 |
| 2501230 | 2501230 | 2022-05-13 | Powder River | Montana | 30075 | 343 | 10 |
| 2501231 | 2501231 | 2022-05-13 | Powell | Montana | 30077 | 1869 | 29 |
| 2501232 | 2501232 | 2022-05-13 | Prairie | Montana | 30079 | 263 | 3 |
| 2501233 | 2501233 | 2022-05-13 | Ravalli | Montana | 30081 | 7089 | 164 |
| 2501234 | 2501234 | 2022-05-13 | Richland | Montana | 30083 | 2646 | 35 |
| 2501235 | 2501235 | 2022-05-13 | Roosevelt | Montana | 30085 | 3279 | 74 |
| 2501236 | 2501236 | 2022-05-13 | Rosebud | Montana | 30087 | 2633 | 60 |
| 2501237 | 2501237 | 2022-05-13 | Sanders | Montana | 30089 | 2164 | 47 |
| 2501238 | 2501238 | 2022-05-13 | Sheridan | Montana | 30091 | 698 | 11 |
| 2501239 | 2501239 | 2022-05-13 | Silver Bow | Montana | 30093 | 8511 | 130 |
| 2501240 | 2501240 | 2022-05-13 | Stillwater | Montana | 30095 | 1538 | 32 |
| 2501241 | 2501241 | 2022-05-13 | Sweet Grass | Montana | 30097 | 785 | 13 |
| 2501242 | 2501242 | 2022-05-13 | Teton | Montana | 30099 | 1290 | 24 |
| 2501243 | 2501243 | 2022-05-13 | Toole | Montana | 30101 | 1249 | 24 |
| 2501244 | 2501244 | 2022-05-13 | Treasure | Montana | 30103 | 133 | 1 |
| 2501245 | 2501245 | 2022-05-13 | Valley | Montana | 30105 | 1705 | 37 |
| 2501246 | 2501246 | 2022-05-13 | Wheatland | Montana | 30107 | 386 | 14 |
| 2501247 | 2501247 | 2022-05-13 | Wibaux | Montana | 30109 | 204 | 8 |
| 2501248 | 2501248 | 2022-05-13 | Yellowstone | Montana | 30111 | 43099 | 551 |
| 2497935 | 2497935 | 2022-05-12 | Beaverhead | Montana | 30001 | 2136 | 30 |
| 2497936 | 2497936 | 2022-05-12 | Big Horn | Montana | 30003 | 4976 | 95 |
| 2497937 | 2497937 | 2022-05-12 | Blaine | Montana | 30005 | 2073 | 32 |
| 2497938 | 2497938 | 2022-05-12 | Broadwater | Montana | 30007 | 1282 | 21 |
| 2497939 | 2497939 | 2022-05-12 | Carbon | Montana | 30009 | 2076 | 28 |
| 2497940 | 2497940 | 2022-05-12 | Carter | Montana | 30011 | 252 | 5 |
| 2497941 | 2497941 | 2022-05-12 | Cascade | Montana | 30013 | 25219 | 341 |
| 2497942 | 2497942 | 2022-05-12 | Chouteau | Montana | 30015 | 991 | 14 |
| 2497943 | 2497943 | 2022-05-12 | Custer | Montana | 30017 | 3060 | 48 |
| 2497944 | 2497944 | 2022-05-12 | Daniels | Montana | 30019 | 386 | 9 |
| 2497945 | 2497945 | 2022-05-12 | Dawson | Montana | 30021 | 2355 | 58 |
| 2497946 | 2497946 | 2022-05-12 | Deer Lodge | Montana | 30023 | 2560 | 29 |
| 2497947 | 2497947 | 2022-05-12 | Fallon | Montana | 30025 | 679 | 10 |
| 2497948 | 2497948 | 2022-05-12 | Fergus | Montana | 30027 | 2512 | 56 |
| 2497949 | 2497949 | 2022-05-12 | Flathead | Montana | 30029 | 29253 | 281 |
| 2497950 | 2497950 | 2022-05-12 | Gallatin | Montana | 30031 | 34927 | 122 |
| 2497951 | 2497951 | 2022-05-12 | Garfield | Montana | 30033 | 225 | 3 |
| 2497952 | 2497952 | 2022-05-12 | Glacier | Montana | 30035 | 3961 | 74 |
| 2497953 | 2497953 | 2022-05-12 | Golden Valley | Montana | 30037 | 150 | 5 |
| 2497954 | 2497954 | 2022-05-12 | Granite | Montana | 30039 | 536 | 9 |
| 2497955 | 2497955 | 2022-05-12 | Hill | Montana | 30041 | 4570 | 73 |
| 2497956 | 2497956 | 2022-05-12 | Jefferson | Montana | 30043 | 2598 | 23 |
| 2497957 | 2497957 | 2022-05-12 | Judith Basin | Montana | 30045 | 225 | 1 |
| 2497958 | 2497958 | 2022-05-12 | Lake | Montana | 30047 | 6621 | 100 |
| 2497959 | 2497959 | 2022-05-12 | Lewis and Clark | Montana | 30049 | 17686 | 185 |
| 2497960 | 2497960 | 2022-05-12 | Liberty | Montana | 30051 | 398 | 4 |
| 2497961 | 2497961 | 2022-05-12 | Lincoln | Montana | 30053 | 4784 | 89 |
| 2497962 | 2497962 | 2022-05-12 | Madison | Montana | 30057 | 1818 | 20 |
| 2497963 | 2497963 | 2022-05-12 | McCone | Montana | 30055 | 383 | 9 |
| 2497964 | 2497964 | 2022-05-12 | Meagher | Montana | 30059 | 409 | 10 |
| 2497965 | 2497965 | 2022-05-12 | Mineral | Montana | 30061 | 1100 | 17 |
| 2497966 | 2497966 | 2022-05-12 | Missoula | Montana | 30063 | 27597 | 209 |
| 2497967 | 2497967 | 2022-05-12 | Musselshell | Montana | 30065 | 916 | 31 |
| 2497968 | 2497968 | 2022-05-12 | Park | Montana | 30067 | 4232 | 35 |
| 2497969 | 2497969 | 2022-05-12 | Petroleum | Montana | 30069 | 35 | 1 |
| 2497970 | 2497970 | 2022-05-12 | Phillips | Montana | 30071 | 1060 | 28 |
| 2497971 | 2497971 | 2022-05-12 | Pondera | Montana | 30073 | 1178 | 8 |
| 2497972 | 2497972 | 2022-05-12 | Powder River | Montana | 30075 | 343 | 10 |
| 2497973 | 2497973 | 2022-05-12 | Powell | Montana | 30077 | 1868 | 29 |
| 2497974 | 2497974 | 2022-05-12 | Prairie | Montana | 30079 | 263 | 3 |
| 2497975 | 2497975 | 2022-05-12 | Ravalli | Montana | 30081 | 7082 | 164 |
| 2497976 | 2497976 | 2022-05-12 | Richland | Montana | 30083 | 2645 | 33 |
| 2497977 | 2497977 | 2022-05-12 | Roosevelt | Montana | 30085 | 3279 | 74 |
| 2497978 | 2497978 | 2022-05-12 | Rosebud | Montana | 30087 | 2633 | 60 |
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);