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)
fips >30
- 30093 791
- 30111 791
- 30031 790
- 30049 790
- 30063 789
- 30007 784
- 30029 784
- 30057 784
- 30085 784
- 30013 782
- 30081 782
- 30043 779
- 30041 778
- 30101 778
- 30053 777
- 30059 777
- 30047 776
- 30067 776
- 30023 774
- 30051 772
- 30065 772
- 30009 771
- 30035 769
- 30001 768
- 30083 764
- 30095 764
- 30003 762
- 30037 761
- 30073 757
- 30107 749
- …
county >30
- Silver Bow 791
- Yellowstone 791
- Gallatin 790
- Lewis and Clark 790
- Missoula 789
- Broadwater 784
- Flathead 784
- Madison 784
- Roosevelt 784
- Cascade 782
- Ravalli 782
- Jefferson 779
- Hill 778
- Toole 778
- Lincoln 777
- Meagher 777
- Lake 776
- Park 776
- Deer Lodge 774
- Liberty 772
- Musselshell 772
- Carbon 771
- Glacier 769
- Beaverhead 768
- Richland 764
- Stillwater 764
- Big Horn 762
- Golden Valley 761
- Pondera 757
- Wheatland 749
- …
state 1
- Montana · 40,556 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2497979 | 2497979 | 2022-05-12 | Sanders | Montana | 30089 | 2153 | 47 |
2497980 | 2497980 | 2022-05-12 | Sheridan | Montana | 30091 | 698 | 11 |
2497981 | 2497981 | 2022-05-12 | Silver Bow | Montana | 30093 | 8497 | 130 |
2497982 | 2497982 | 2022-05-12 | Stillwater | Montana | 30095 | 1538 | 32 |
2497983 | 2497983 | 2022-05-12 | Sweet Grass | Montana | 30097 | 783 | 13 |
2497984 | 2497984 | 2022-05-12 | Teton | Montana | 30099 | 1285 | 24 |
2497985 | 2497985 | 2022-05-12 | Toole | Montana | 30101 | 1246 | 24 |
2497986 | 2497986 | 2022-05-12 | Treasure | Montana | 30103 | 133 | 1 |
2497987 | 2497987 | 2022-05-12 | Valley | Montana | 30105 | 1703 | 37 |
2497988 | 2497988 | 2022-05-12 | Wheatland | Montana | 30107 | 386 | 14 |
2497989 | 2497989 | 2022-05-12 | Wibaux | Montana | 30109 | 204 | 8 |
2497990 | 2497990 | 2022-05-12 | Yellowstone | Montana | 30111 | 43038 | 551 |
2494677 | 2494677 | 2022-05-11 | Beaverhead | Montana | 30001 | 2136 | 30 |
2494678 | 2494678 | 2022-05-11 | Big Horn | Montana | 30003 | 4976 | 95 |
2494679 | 2494679 | 2022-05-11 | Blaine | Montana | 30005 | 2073 | 32 |
2494680 | 2494680 | 2022-05-11 | Broadwater | Montana | 30007 | 1282 | 21 |
2494681 | 2494681 | 2022-05-11 | Carbon | Montana | 30009 | 2076 | 28 |
2494682 | 2494682 | 2022-05-11 | Carter | Montana | 30011 | 252 | 5 |
2494683 | 2494683 | 2022-05-11 | Cascade | Montana | 30013 | 25219 | 341 |
2494684 | 2494684 | 2022-05-11 | Chouteau | Montana | 30015 | 991 | 14 |
2494685 | 2494685 | 2022-05-11 | Custer | Montana | 30017 | 3060 | 48 |
2494686 | 2494686 | 2022-05-11 | Daniels | Montana | 30019 | 386 | 9 |
2494687 | 2494687 | 2022-05-11 | Dawson | Montana | 30021 | 2355 | 58 |
2494688 | 2494688 | 2022-05-11 | Deer Lodge | Montana | 30023 | 2560 | 29 |
2494689 | 2494689 | 2022-05-11 | Fallon | Montana | 30025 | 679 | 10 |
2494690 | 2494690 | 2022-05-11 | Fergus | Montana | 30027 | 2512 | 56 |
2494691 | 2494691 | 2022-05-11 | Flathead | Montana | 30029 | 29253 | 281 |
2494692 | 2494692 | 2022-05-11 | Gallatin | Montana | 30031 | 34880 | 122 |
2494693 | 2494693 | 2022-05-11 | Garfield | Montana | 30033 | 225 | 3 |
2494694 | 2494694 | 2022-05-11 | Glacier | Montana | 30035 | 3961 | 74 |
2494695 | 2494695 | 2022-05-11 | Golden Valley | Montana | 30037 | 150 | 5 |
2494696 | 2494696 | 2022-05-11 | Granite | Montana | 30039 | 536 | 9 |
2494697 | 2494697 | 2022-05-11 | Hill | Montana | 30041 | 4570 | 73 |
2494698 | 2494698 | 2022-05-11 | Jefferson | Montana | 30043 | 2598 | 23 |
2494699 | 2494699 | 2022-05-11 | Judith Basin | Montana | 30045 | 225 | 1 |
2494700 | 2494700 | 2022-05-11 | Lake | Montana | 30047 | 6621 | 100 |
2494701 | 2494701 | 2022-05-11 | Lewis and Clark | Montana | 30049 | 17686 | 185 |
2494702 | 2494702 | 2022-05-11 | Liberty | Montana | 30051 | 398 | 4 |
2494703 | 2494703 | 2022-05-11 | Lincoln | Montana | 30053 | 4784 | 89 |
2494704 | 2494704 | 2022-05-11 | Madison | Montana | 30057 | 1818 | 20 |
2494705 | 2494705 | 2022-05-11 | McCone | Montana | 30055 | 383 | 9 |
2494706 | 2494706 | 2022-05-11 | Meagher | Montana | 30059 | 409 | 10 |
2494707 | 2494707 | 2022-05-11 | Mineral | Montana | 30061 | 1100 | 17 |
2494708 | 2494708 | 2022-05-11 | Missoula | Montana | 30063 | 27597 | 209 |
2494709 | 2494709 | 2022-05-11 | Musselshell | Montana | 30065 | 916 | 31 |
2494710 | 2494710 | 2022-05-11 | Park | Montana | 30067 | 4232 | 35 |
2494711 | 2494711 | 2022-05-11 | Petroleum | Montana | 30069 | 35 | 1 |
2494712 | 2494712 | 2022-05-11 | Phillips | Montana | 30071 | 1060 | 28 |
2494713 | 2494713 | 2022-05-11 | Pondera | Montana | 30073 | 1178 | 8 |
2494714 | 2494714 | 2022-05-11 | Powder River | Montana | 30075 | 343 | 10 |
2494715 | 2494715 | 2022-05-11 | Powell | Montana | 30077 | 1868 | 29 |
2494716 | 2494716 | 2022-05-11 | Prairie | Montana | 30079 | 263 | 3 |
2494717 | 2494717 | 2022-05-11 | Ravalli | Montana | 30081 | 7082 | 164 |
2494718 | 2494718 | 2022-05-11 | Richland | Montana | 30083 | 2645 | 33 |
2494719 | 2494719 | 2022-05-11 | Roosevelt | Montana | 30085 | 3279 | 74 |
2494720 | 2494720 | 2022-05-11 | Rosebud | Montana | 30087 | 2633 | 60 |
2494721 | 2494721 | 2022-05-11 | Sanders | Montana | 30089 | 2153 | 47 |
2494722 | 2494722 | 2022-05-11 | Sheridan | Montana | 30091 | 698 | 11 |
2494723 | 2494723 | 2022-05-11 | Silver Bow | Montana | 30093 | 8497 | 130 |
2494724 | 2494724 | 2022-05-11 | Stillwater | Montana | 30095 | 1538 | 32 |
2494725 | 2494725 | 2022-05-11 | Sweet Grass | Montana | 30097 | 783 | 13 |
2494726 | 2494726 | 2022-05-11 | Teton | Montana | 30099 | 1285 | 24 |
2494727 | 2494727 | 2022-05-11 | Toole | Montana | 30101 | 1246 | 24 |
2494728 | 2494728 | 2022-05-11 | Treasure | Montana | 30103 | 133 | 1 |
2494729 | 2494729 | 2022-05-11 | Valley | Montana | 30105 | 1703 | 37 |
2494730 | 2494730 | 2022-05-11 | Wheatland | Montana | 30107 | 386 | 14 |
2494731 | 2494731 | 2022-05-11 | Wibaux | Montana | 30109 | 204 | 8 |
2494732 | 2494732 | 2022-05-11 | Yellowstone | Montana | 30111 | 43038 | 551 |
2491419 | 2491419 | 2022-05-10 | Beaverhead | Montana | 30001 | 2136 | 30 |
2491420 | 2491420 | 2022-05-10 | Big Horn | Montana | 30003 | 4976 | 95 |
2491421 | 2491421 | 2022-05-10 | Blaine | Montana | 30005 | 2073 | 32 |
2491422 | 2491422 | 2022-05-10 | Broadwater | Montana | 30007 | 1282 | 21 |
2491423 | 2491423 | 2022-05-10 | Carbon | Montana | 30009 | 2076 | 28 |
2491424 | 2491424 | 2022-05-10 | Carter | Montana | 30011 | 252 | 5 |
2491425 | 2491425 | 2022-05-10 | Cascade | Montana | 30013 | 25219 | 341 |
2491426 | 2491426 | 2022-05-10 | Chouteau | Montana | 30015 | 991 | 14 |
2491427 | 2491427 | 2022-05-10 | Custer | Montana | 30017 | 3060 | 48 |
2491428 | 2491428 | 2022-05-10 | Daniels | Montana | 30019 | 386 | 9 |
2491429 | 2491429 | 2022-05-10 | Dawson | Montana | 30021 | 2355 | 58 |
2491430 | 2491430 | 2022-05-10 | Deer Lodge | Montana | 30023 | 2560 | 29 |
2491431 | 2491431 | 2022-05-10 | Fallon | Montana | 30025 | 679 | 10 |
2491432 | 2491432 | 2022-05-10 | Fergus | Montana | 30027 | 2512 | 56 |
2491433 | 2491433 | 2022-05-10 | Flathead | Montana | 30029 | 29253 | 281 |
2491434 | 2491434 | 2022-05-10 | Gallatin | Montana | 30031 | 34828 | 122 |
2491435 | 2491435 | 2022-05-10 | Garfield | Montana | 30033 | 225 | 3 |
2491436 | 2491436 | 2022-05-10 | Glacier | Montana | 30035 | 3961 | 74 |
2491437 | 2491437 | 2022-05-10 | Golden Valley | Montana | 30037 | 150 | 5 |
2491438 | 2491438 | 2022-05-10 | Granite | Montana | 30039 | 536 | 9 |
2491439 | 2491439 | 2022-05-10 | Hill | Montana | 30041 | 4570 | 73 |
2491440 | 2491440 | 2022-05-10 | Jefferson | Montana | 30043 | 2598 | 23 |
2491441 | 2491441 | 2022-05-10 | Judith Basin | Montana | 30045 | 225 | 1 |
2491442 | 2491442 | 2022-05-10 | Lake | Montana | 30047 | 6621 | 100 |
2491443 | 2491443 | 2022-05-10 | Lewis and Clark | Montana | 30049 | 17686 | 185 |
2491444 | 2491444 | 2022-05-10 | Liberty | Montana | 30051 | 398 | 4 |
2491445 | 2491445 | 2022-05-10 | Lincoln | Montana | 30053 | 4784 | 89 |
2491446 | 2491446 | 2022-05-10 | Madison | Montana | 30057 | 1818 | 20 |
2491447 | 2491447 | 2022-05-10 | McCone | Montana | 30055 | 383 | 9 |
2491448 | 2491448 | 2022-05-10 | Meagher | Montana | 30059 | 409 | 10 |
2491449 | 2491449 | 2022-05-10 | Mineral | Montana | 30061 | 1100 | 17 |
2491450 | 2491450 | 2022-05-10 | Missoula | Montana | 30063 | 27597 | 209 |
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);