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 cases
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 |
---|---|---|---|---|---|---|---|
22903 | 22903 | 2020-03-31 | Unknown | Montana | 0 | 1 | |
25092 | 25092 | 2020-04-01 | Unknown | Montana | 0 | 1 | |
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 |
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 |
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 |
2993 | 2993 | 2020-03-16 | Silver Bow | Montana | 30093 | 1 | 0 |
3500 | 3500 | 2020-03-17 | Gallatin | Montana | 30031 | 1 | 0 |
3501 | 3501 | 2020-03-17 | Lewis and Clark | Montana | 30049 | 1 | 0 |
3503 | 3503 | 2020-03-17 | Silver Bow | Montana | 30093 | 1 | 0 |
4092 | 4092 | 2020-03-18 | Lewis and Clark | Montana | 30049 | 1 | 0 |
4094 | 4094 | 2020-03-18 | Silver Bow | Montana | 30093 | 1 | 0 |
4810 | 4810 | 2020-03-19 | Broadwater | Montana | 30007 | 1 | 0 |
4811 | 4811 | 2020-03-19 | Flathead | Montana | 30029 | 1 | 0 |
4814 | 4814 | 2020-03-19 | Madison | Montana | 30057 | 1 | 0 |
4816 | 4816 | 2020-03-19 | Roosevelt | Montana | 30085 | 1 | 0 |
4817 | 4817 | 2020-03-19 | Silver Bow | Montana | 30093 | 1 | 0 |
5649 | 5649 | 2020-03-20 | Broadwater | Montana | 30007 | 1 | 0 |
5650 | 5650 | 2020-03-20 | Flathead | Montana | 30029 | 1 | 0 |
5653 | 5653 | 2020-03-20 | Madison | Montana | 30057 | 1 | 0 |
5655 | 5655 | 2020-03-20 | Roosevelt | Montana | 30085 | 1 | 0 |
5656 | 5656 | 2020-03-20 | Silver Bow | Montana | 30093 | 1 | 0 |
6639 | 6639 | 2020-03-21 | Broadwater | Montana | 30007 | 1 | 0 |
6644 | 6644 | 2020-03-21 | Madison | Montana | 30057 | 1 | 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 |
7728 | 7728 | 2020-03-22 | Broadwater | Montana | 30007 | 1 | 0 |
7733 | 7733 | 2020-03-22 | Madison | Montana | 30057 | 1 | 0 |
7735 | 7735 | 2020-03-22 | Ravalli | Montana | 30081 | 1 | 0 |
7736 | 7736 | 2020-03-22 | Roosevelt | Montana | 30085 | 1 | 0 |
8921 | 8921 | 2020-03-23 | Broadwater | Montana | 30007 | 1 | 0 |
8926 | 8926 | 2020-03-23 | Madison | Montana | 30057 | 1 | 0 |
8928 | 8928 | 2020-03-23 | Ravalli | Montana | 30081 | 1 | 0 |
8929 | 8929 | 2020-03-23 | Roosevelt | Montana | 30085 | 1 | 0 |
10223 | 10223 | 2020-03-24 | Broadwater | Montana | 30007 | 1 | 0 |
10227 | 10227 | 2020-03-24 | Jefferson | Montana | 30043 | 1 | 0 |
10229 | 10229 | 2020-03-24 | Madison | Montana | 30057 | 1 | 0 |
10231 | 10231 | 2020-03-24 | Ravalli | Montana | 30081 | 1 | 0 |
10232 | 10232 | 2020-03-24 | Roosevelt | Montana | 30085 | 1 | 0 |
11656 | 11656 | 2020-03-25 | Hill | Montana | 30041 | 1 | 0 |
11657 | 11657 | 2020-03-25 | Jefferson | Montana | 30043 | 1 | 0 |
11661 | 11661 | 2020-03-25 | Ravalli | Montana | 30081 | 1 | 0 |
11662 | 11662 | 2020-03-25 | Roosevelt | Montana | 30085 | 1 | 0 |
13254 | 13254 | 2020-03-26 | Hill | Montana | 30041 | 1 | 0 |
13255 | 13255 | 2020-03-26 | Jefferson | Montana | 30043 | 1 | 0 |
13257 | 13257 | 2020-03-26 | Lincoln | Montana | 30053 | 1 | 0 |
13259 | 13259 | 2020-03-26 | Meagher | Montana | 30059 | 1 | 0 |
13261 | 13261 | 2020-03-26 | Ravalli | Montana | 30081 | 1 | 0 |
13262 | 13262 | 2020-03-26 | Roosevelt | Montana | 30085 | 1 | 0 |
13264 | 13264 | 2020-03-26 | Toole | Montana | 30101 | 1 | 0 |
14984 | 14984 | 2020-03-27 | Hill | Montana | 30041 | 1 | 0 |
14986 | 14986 | 2020-03-27 | Lake | Montana | 30047 | 1 | 0 |
14990 | 14990 | 2020-03-27 | Meagher | Montana | 30059 | 1 | 0 |
14992 | 14992 | 2020-03-27 | Park | Montana | 30067 | 1 | 0 |
14993 | 14993 | 2020-03-27 | Ravalli | Montana | 30081 | 1 | 0 |
14994 | 14994 | 2020-03-27 | Roosevelt | Montana | 30085 | 1 | 0 |
16810 | 16810 | 2020-03-28 | Hill | Montana | 30041 | 1 | 0 |
16816 | 16816 | 2020-03-28 | Meagher | Montana | 30059 | 1 | 0 |
16819 | 16819 | 2020-03-28 | Ravalli | Montana | 30081 | 1 | 0 |
16820 | 16820 | 2020-03-28 | Roosevelt | Montana | 30085 | 1 | 0 |
18730 | 18730 | 2020-03-29 | Deer Lodge | Montana | 30023 | 1 | 0 |
18733 | 18733 | 2020-03-29 | Hill | Montana | 30041 | 1 | 0 |
18739 | 18739 | 2020-03-29 | Meagher | Montana | 30059 | 1 | 0 |
18742 | 18742 | 2020-03-29 | Ravalli | Montana | 30081 | 1 | 0 |
18743 | 18743 | 2020-03-29 | Roosevelt | Montana | 30085 | 1 | 0 |
20768 | 20768 | 2020-03-30 | Hill | Montana | 30041 | 1 | 0 |
20774 | 20774 | 2020-03-30 | Meagher | Montana | 30059 | 1 | 0 |
20777 | 20777 | 2020-03-30 | Ravalli | Montana | 30081 | 1 | 0 |
20778 | 20778 | 2020-03-30 | Roosevelt | Montana | 30085 | 1 | 0 |
22888 | 22888 | 2020-03-31 | Hill | Montana | 30041 | 1 | 0 |
22892 | 22892 | 2020-03-31 | Liberty | Montana | 30051 | 1 | 0 |
22895 | 22895 | 2020-03-31 | Meagher | Montana | 30059 | 1 | 0 |
22897 | 22897 | 2020-03-31 | Musselshell | Montana | 30065 | 1 | 0 |
22899 | 22899 | 2020-03-31 | Ravalli | Montana | 30081 | 1 | 0 |
22900 | 22900 | 2020-03-31 | Roosevelt | Montana | 30085 | 1 | 0 |
25072 | 25072 | 2020-04-01 | Carbon | Montana | 30009 | 1 | 0 |
25077 | 25077 | 2020-04-01 | Hill | Montana | 30041 | 1 | 0 |
25081 | 25081 | 2020-04-01 | Liberty | Montana | 30051 | 1 | 0 |
25084 | 25084 | 2020-04-01 | Meagher | Montana | 30059 | 1 | 0 |
25086 | 25086 | 2020-04-01 | Musselshell | Montana | 30065 | 1 | 0 |
25088 | 25088 | 2020-04-01 | Ravalli | Montana | 30081 | 1 | 0 |
25089 | 25089 | 2020-04-01 | Roosevelt | Montana | 30085 | 1 | 0 |
27329 | 27329 | 2020-04-02 | Carbon | Montana | 30009 | 1 | 0 |
27334 | 27334 | 2020-04-02 | Hill | Montana | 30041 | 1 | 0 |
27338 | 27338 | 2020-04-02 | Liberty | Montana | 30051 | 1 | 0 |
27341 | 27341 | 2020-04-02 | Meagher | Montana | 30059 | 1 | 0 |
27343 | 27343 | 2020-04-02 | Musselshell | Montana | 30065 | 1 | 0 |
27345 | 27345 | 2020-04-02 | Ravalli | Montana | 30081 | 1 | 0 |
27346 | 27346 | 2020-04-02 | Roosevelt | Montana | 30085 | 1 | 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);