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 57
- 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
- 30087 709
- 30017 699
- 30105 694
- 30027 693
- 30021 691
- 30103 688
- 30039 686
- 30099 680
- 30091 679
- 30025 669
- 30033 668
- 30089 668
- 30109 668
- 30097 667
- 30005 665
- 30055 661
- 30015 660
- 30045 659
- 30075 658
- 30019 656
- 30077 652
- 30079 646
- 30071 645
- 30061 639
- 30011 595
- 30069 584
- - 2
county 57
- 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
- Rosebud 709
- Custer 699
- Valley 694
- Fergus 693
- Dawson 691
- Treasure 688
- Granite 686
- Teton 680
- Sheridan 679
- Fallon 669
- Garfield 668
- Sanders 668
- Wibaux 668
- Sweet Grass 667
- Blaine 665
- McCone 661
- Chouteau 660
- Judith Basin 659
- Powder River 658
- Daniels 656
- Powell 652
- Prairie 646
- Phillips 645
- Mineral 639
- Carter 595
- Petroleum 584
- Unknown 2
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);