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 deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
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
- …
date (date) >30 ✖
- 2020-10-05 56
- 2020-10-06 56
- 2020-10-07 56
- 2020-10-08 56
- 2020-10-09 56
- 2020-10-10 56
- 2020-10-11 56
- 2020-10-12 56
- 2020-10-13 56
- 2020-10-14 56
- 2020-10-15 56
- 2020-10-16 56
- 2020-10-17 56
- 2020-10-18 56
- 2020-10-19 56
- 2020-10-20 56
- 2020-10-21 56
- 2020-10-22 56
- 2020-10-23 56
- 2020-10-24 56
- 2020-10-25 56
- 2020-10-26 56
- 2020-10-27 56
- 2020-10-28 56
- 2020-10-29 56
- 2020-10-30 56
- 2020-10-31 56
- 2020-11-01 56
- 2020-11-02 56
- 2020-11-03 56
- …
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 ▼ |
---|---|---|---|---|---|---|---|
1783 | 1783 | 2020-03-13 | Gallatin | Montana | 30031 | 1 | 0 |
1784 | 1784 | 2020-03-13 | Lewis and Clark | Montana | 30049 | 1 | 0 |
1785 | 1785 | 2020-03-13 | Silver Bow | Montana | 30093 | 1 | 0 |
1786 | 1786 | 2020-03-13 | Yellowstone | Montana | 30111 | 1 | 0 |
2128 | 2128 | 2020-03-14 | Gallatin | Montana | 30031 | 1 | 0 |
2129 | 2129 | 2020-03-14 | Lewis and Clark | Montana | 30049 | 1 | 0 |
2130 | 2130 | 2020-03-14 | Missoula | Montana | 30063 | 2 | 0 |
2131 | 2131 | 2020-03-14 | Silver Bow | Montana | 30093 | 1 | 0 |
2132 | 2132 | 2020-03-14 | Yellowstone | Montana | 30111 | 1 | 0 |
2535 | 2535 | 2020-03-15 | Gallatin | Montana | 30031 | 1 | 0 |
2536 | 2536 | 2020-03-15 | Lewis and Clark | Montana | 30049 | 1 | 0 |
2537 | 2537 | 2020-03-15 | Missoula | Montana | 30063 | 2 | 0 |
2538 | 2538 | 2020-03-15 | Silver Bow | Montana | 30093 | 1 | 0 |
2539 | 2539 | 2020-03-15 | Yellowstone | Montana | 30111 | 1 | 0 |
2990 | 2990 | 2020-03-16 | Gallatin | Montana | 30031 | 1 | 0 |
2991 | 2991 | 2020-03-16 | Lewis and Clark | Montana | 30049 | 1 | 0 |
2992 | 2992 | 2020-03-16 | Missoula | Montana | 30063 | 2 | 0 |
2993 | 2993 | 2020-03-16 | Silver Bow | Montana | 30093 | 1 | 0 |
2994 | 2994 | 2020-03-16 | Yellowstone | Montana | 30111 | 3 | 0 |
3500 | 3500 | 2020-03-17 | Gallatin | Montana | 30031 | 1 | 0 |
3501 | 3501 | 2020-03-17 | Lewis and Clark | Montana | 30049 | 1 | 0 |
3502 | 3502 | 2020-03-17 | Missoula | Montana | 30063 | 2 | 0 |
3503 | 3503 | 2020-03-17 | Silver Bow | Montana | 30093 | 1 | 0 |
3504 | 3504 | 2020-03-17 | Yellowstone | Montana | 30111 | 3 | 0 |
4091 | 4091 | 2020-03-18 | Gallatin | Montana | 30031 | 2 | 0 |
4092 | 4092 | 2020-03-18 | Lewis and Clark | Montana | 30049 | 1 | 0 |
4093 | 4093 | 2020-03-18 | Missoula | Montana | 30063 | 3 | 0 |
4094 | 4094 | 2020-03-18 | Silver Bow | Montana | 30093 | 1 | 0 |
4095 | 4095 | 2020-03-18 | Yellowstone | Montana | 30111 | 5 | 0 |
4810 | 4810 | 2020-03-19 | Broadwater | Montana | 30007 | 1 | 0 |
4811 | 4811 | 2020-03-19 | Flathead | Montana | 30029 | 1 | 0 |
4812 | 4812 | 2020-03-19 | Gallatin | Montana | 30031 | 2 | 0 |
4813 | 4813 | 2020-03-19 | Lewis and Clark | Montana | 30049 | 3 | 0 |
4814 | 4814 | 2020-03-19 | Madison | Montana | 30057 | 1 | 0 |
4815 | 4815 | 2020-03-19 | Missoula | Montana | 30063 | 4 | 0 |
4816 | 4816 | 2020-03-19 | Roosevelt | Montana | 30085 | 1 | 0 |
4817 | 4817 | 2020-03-19 | Silver Bow | Montana | 30093 | 1 | 0 |
4818 | 4818 | 2020-03-19 | Yellowstone | Montana | 30111 | 5 | 0 |
5649 | 5649 | 2020-03-20 | Broadwater | Montana | 30007 | 1 | 0 |
5650 | 5650 | 2020-03-20 | Flathead | Montana | 30029 | 1 | 0 |
5651 | 5651 | 2020-03-20 | Gallatin | Montana | 30031 | 2 | 0 |
5652 | 5652 | 2020-03-20 | Lewis and Clark | Montana | 30049 | 3 | 0 |
5653 | 5653 | 2020-03-20 | Madison | Montana | 30057 | 1 | 0 |
5654 | 5654 | 2020-03-20 | Missoula | Montana | 30063 | 4 | 0 |
5655 | 5655 | 2020-03-20 | Roosevelt | Montana | 30085 | 1 | 0 |
5656 | 5656 | 2020-03-20 | Silver Bow | Montana | 30093 | 1 | 0 |
5657 | 5657 | 2020-03-20 | Yellowstone | Montana | 30111 | 5 | 0 |
6639 | 6639 | 2020-03-21 | Broadwater | Montana | 30007 | 1 | 0 |
6640 | 6640 | 2020-03-21 | Cascade | Montana | 30013 | 3 | 0 |
6641 | 6641 | 2020-03-21 | Flathead | Montana | 30029 | 2 | 0 |
6642 | 6642 | 2020-03-21 | Gallatin | Montana | 30031 | 7 | 0 |
6643 | 6643 | 2020-03-21 | Lewis and Clark | Montana | 30049 | 3 | 0 |
6644 | 6644 | 2020-03-21 | Madison | Montana | 30057 | 1 | 0 |
6645 | 6645 | 2020-03-21 | Missoula | Montana | 30063 | 4 | 0 |
6646 | 6646 | 2020-03-21 | Ravalli | Montana | 30081 | 1 | 0 |
6647 | 6647 | 2020-03-21 | Roosevelt | Montana | 30085 | 1 | 0 |
6648 | 6648 | 2020-03-21 | Silver Bow | Montana | 30093 | 1 | 0 |
6649 | 6649 | 2020-03-21 | Yellowstone | Montana | 30111 | 5 | 0 |
7728 | 7728 | 2020-03-22 | Broadwater | Montana | 30007 | 1 | 0 |
7729 | 7729 | 2020-03-22 | Cascade | Montana | 30013 | 3 | 0 |
7730 | 7730 | 2020-03-22 | Flathead | Montana | 30029 | 2 | 0 |
7731 | 7731 | 2020-03-22 | Gallatin | Montana | 30031 | 10 | 0 |
7732 | 7732 | 2020-03-22 | Lewis and Clark | Montana | 30049 | 3 | 0 |
7733 | 7733 | 2020-03-22 | Madison | Montana | 30057 | 1 | 0 |
7734 | 7734 | 2020-03-22 | Missoula | Montana | 30063 | 4 | 0 |
7735 | 7735 | 2020-03-22 | Ravalli | Montana | 30081 | 1 | 0 |
7736 | 7736 | 2020-03-22 | Roosevelt | Montana | 30085 | 1 | 0 |
7737 | 7737 | 2020-03-22 | Silver Bow | Montana | 30093 | 2 | 0 |
7738 | 7738 | 2020-03-22 | Yellowstone | Montana | 30111 | 6 | 0 |
8921 | 8921 | 2020-03-23 | Broadwater | Montana | 30007 | 1 | 0 |
8922 | 8922 | 2020-03-23 | Cascade | Montana | 30013 | 3 | 0 |
8923 | 8923 | 2020-03-23 | Flathead | Montana | 30029 | 4 | 0 |
8924 | 8924 | 2020-03-23 | Gallatin | Montana | 30031 | 16 | 0 |
8925 | 8925 | 2020-03-23 | Lewis and Clark | Montana | 30049 | 3 | 0 |
8926 | 8926 | 2020-03-23 | Madison | Montana | 30057 | 1 | 0 |
8927 | 8927 | 2020-03-23 | Missoula | Montana | 30063 | 6 | 0 |
8928 | 8928 | 2020-03-23 | Ravalli | Montana | 30081 | 1 | 0 |
8929 | 8929 | 2020-03-23 | Roosevelt | Montana | 30085 | 1 | 0 |
8930 | 8930 | 2020-03-23 | Silver Bow | Montana | 30093 | 2 | 0 |
8931 | 8931 | 2020-03-23 | Yellowstone | Montana | 30111 | 7 | 0 |
10223 | 10223 | 2020-03-24 | Broadwater | Montana | 30007 | 1 | 0 |
10224 | 10224 | 2020-03-24 | Cascade | Montana | 30013 | 3 | 0 |
10225 | 10225 | 2020-03-24 | Flathead | Montana | 30029 | 4 | 0 |
10226 | 10226 | 2020-03-24 | Gallatin | Montana | 30031 | 19 | 0 |
10227 | 10227 | 2020-03-24 | Jefferson | Montana | 30043 | 1 | 0 |
10228 | 10228 | 2020-03-24 | Lewis and Clark | Montana | 30049 | 3 | 0 |
10229 | 10229 | 2020-03-24 | Madison | Montana | 30057 | 1 | 0 |
10230 | 10230 | 2020-03-24 | Missoula | Montana | 30063 | 6 | 0 |
10231 | 10231 | 2020-03-24 | Ravalli | Montana | 30081 | 1 | 0 |
10232 | 10232 | 2020-03-24 | Roosevelt | Montana | 30085 | 1 | 0 |
10233 | 10233 | 2020-03-24 | Silver Bow | Montana | 30093 | 3 | 0 |
10234 | 10234 | 2020-03-24 | Yellowstone | Montana | 30111 | 8 | 0 |
11652 | 11652 | 2020-03-25 | Broadwater | Montana | 30007 | 2 | 0 |
11653 | 11653 | 2020-03-25 | Cascade | Montana | 30013 | 3 | 0 |
11654 | 11654 | 2020-03-25 | Flathead | Montana | 30029 | 5 | 0 |
11655 | 11655 | 2020-03-25 | Gallatin | Montana | 30031 | 24 | 0 |
11656 | 11656 | 2020-03-25 | Hill | Montana | 30041 | 1 | 0 |
11657 | 11657 | 2020-03-25 | Jefferson | Montana | 30043 | 1 | 0 |
11658 | 11658 | 2020-03-25 | Lewis and Clark | Montana | 30049 | 3 | 0 |
11659 | 11659 | 2020-03-25 | Madison | Montana | 30057 | 2 | 0 |
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);