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 fips
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 |
---|---|---|---|---|---|---|---|
32031 | 32031 | 2020-04-04 | Beaverhead | Montana | 30001 | 1 | 0 |
34459 | 34459 | 2020-04-05 | Beaverhead | Montana | 30001 | 1 | 0 |
36926 | 36926 | 2020-04-06 | Beaverhead | Montana | 30001 | 1 | 0 |
39442 | 39442 | 2020-04-07 | Beaverhead | Montana | 30001 | 1 | 0 |
41997 | 41997 | 2020-04-08 | Beaverhead | Montana | 30001 | 1 | 0 |
44576 | 44576 | 2020-04-09 | Beaverhead | Montana | 30001 | 1 | 0 |
47185 | 47185 | 2020-04-10 | Beaverhead | Montana | 30001 | 1 | 0 |
49833 | 49833 | 2020-04-11 | Beaverhead | Montana | 30001 | 1 | 0 |
52506 | 52506 | 2020-04-12 | Beaverhead | Montana | 30001 | 1 | 0 |
55187 | 55187 | 2020-04-13 | Beaverhead | Montana | 30001 | 1 | 0 |
57886 | 57886 | 2020-04-14 | Beaverhead | Montana | 30001 | 1 | 0 |
60599 | 60599 | 2020-04-15 | Beaverhead | Montana | 30001 | 1 | 0 |
63322 | 63322 | 2020-04-16 | Beaverhead | Montana | 30001 | 1 | 0 |
66062 | 66062 | 2020-04-17 | Beaverhead | Montana | 30001 | 1 | 0 |
68816 | 68816 | 2020-04-18 | Beaverhead | Montana | 30001 | 1 | 0 |
71583 | 71583 | 2020-04-19 | Beaverhead | Montana | 30001 | 1 | 0 |
74356 | 74356 | 2020-04-20 | Beaverhead | Montana | 30001 | 1 | 0 |
77136 | 77136 | 2020-04-21 | Beaverhead | Montana | 30001 | 1 | 0 |
79924 | 79924 | 2020-04-22 | Beaverhead | Montana | 30001 | 1 | 0 |
82720 | 82720 | 2020-04-23 | Beaverhead | Montana | 30001 | 1 | 0 |
85524 | 85524 | 2020-04-24 | Beaverhead | Montana | 30001 | 1 | 0 |
88334 | 88334 | 2020-04-25 | Beaverhead | Montana | 30001 | 1 | 0 |
91149 | 91149 | 2020-04-26 | Beaverhead | Montana | 30001 | 1 | 0 |
93970 | 93970 | 2020-04-27 | Beaverhead | Montana | 30001 | 1 | 0 |
96806 | 96806 | 2020-04-28 | Beaverhead | Montana | 30001 | 1 | 0 |
99652 | 99652 | 2020-04-29 | Beaverhead | Montana | 30001 | 1 | 0 |
102504 | 102504 | 2020-04-30 | Beaverhead | Montana | 30001 | 1 | 0 |
105365 | 105365 | 2020-05-01 | Beaverhead | Montana | 30001 | 1 | 0 |
108231 | 108231 | 2020-05-02 | Beaverhead | Montana | 30001 | 1 | 0 |
111103 | 111103 | 2020-05-03 | Beaverhead | Montana | 30001 | 1 | 0 |
113982 | 113982 | 2020-05-04 | Beaverhead | Montana | 30001 | 1 | 0 |
116864 | 116864 | 2020-05-05 | Beaverhead | Montana | 30001 | 1 | 0 |
119824 | 119824 | 2020-05-06 | Beaverhead | Montana | 30001 | 1 | 0 |
122798 | 122798 | 2020-05-07 | Beaverhead | Montana | 30001 | 1 | 0 |
125780 | 125780 | 2020-05-08 | Beaverhead | Montana | 30001 | 1 | 0 |
128768 | 128768 | 2020-05-09 | Beaverhead | Montana | 30001 | 1 | 0 |
131758 | 131758 | 2020-05-10 | Beaverhead | Montana | 30001 | 1 | 0 |
134749 | 134749 | 2020-05-11 | Beaverhead | Montana | 30001 | 1 | 0 |
137739 | 137739 | 2020-05-12 | Beaverhead | Montana | 30001 | 1 | 0 |
140733 | 140733 | 2020-05-13 | Beaverhead | Montana | 30001 | 1 | 0 |
143728 | 143728 | 2020-05-14 | Beaverhead | Montana | 30001 | 1 | 0 |
146729 | 146729 | 2020-05-15 | Beaverhead | Montana | 30001 | 1 | 0 |
149735 | 149735 | 2020-05-16 | Beaverhead | Montana | 30001 | 1 | 0 |
152746 | 152746 | 2020-05-17 | Beaverhead | Montana | 30001 | 1 | 0 |
155760 | 155760 | 2020-05-18 | Beaverhead | Montana | 30001 | 1 | 0 |
158778 | 158778 | 2020-05-19 | Beaverhead | Montana | 30001 | 1 | 0 |
161804 | 161804 | 2020-05-20 | Beaverhead | Montana | 30001 | 1 | 0 |
164833 | 164833 | 2020-05-21 | Beaverhead | Montana | 30001 | 1 | 0 |
167869 | 167869 | 2020-05-22 | Beaverhead | Montana | 30001 | 1 | 0 |
170908 | 170908 | 2020-05-23 | Beaverhead | Montana | 30001 | 1 | 0 |
173950 | 173950 | 2020-05-24 | Beaverhead | Montana | 30001 | 1 | 0 |
176993 | 176993 | 2020-05-25 | Beaverhead | Montana | 30001 | 1 | 0 |
180037 | 180037 | 2020-05-26 | Beaverhead | Montana | 30001 | 1 | 0 |
183085 | 183085 | 2020-05-27 | Beaverhead | Montana | 30001 | 1 | 0 |
186141 | 186141 | 2020-05-28 | Beaverhead | Montana | 30001 | 1 | 0 |
189200 | 189200 | 2020-05-29 | Beaverhead | Montana | 30001 | 1 | 0 |
192264 | 192264 | 2020-05-30 | Beaverhead | Montana | 30001 | 1 | 0 |
195334 | 195334 | 2020-05-31 | Beaverhead | Montana | 30001 | 1 | 0 |
198405 | 198405 | 2020-06-01 | Beaverhead | Montana | 30001 | 1 | 0 |
201478 | 201478 | 2020-06-02 | Beaverhead | Montana | 30001 | 1 | 0 |
204555 | 204555 | 2020-06-03 | Beaverhead | Montana | 30001 | 1 | 0 |
207636 | 207636 | 2020-06-04 | Beaverhead | Montana | 30001 | 1 | 0 |
210717 | 210717 | 2020-06-05 | Beaverhead | Montana | 30001 | 1 | 0 |
213801 | 213801 | 2020-06-06 | Beaverhead | Montana | 30001 | 1 | 0 |
216890 | 216890 | 2020-06-07 | Beaverhead | Montana | 30001 | 1 | 0 |
219982 | 219982 | 2020-06-08 | Beaverhead | Montana | 30001 | 1 | 0 |
223077 | 223077 | 2020-06-09 | Beaverhead | Montana | 30001 | 1 | 0 |
226176 | 226176 | 2020-06-10 | Beaverhead | Montana | 30001 | 1 | 0 |
229279 | 229279 | 2020-06-11 | Beaverhead | Montana | 30001 | 1 | 0 |
232383 | 232383 | 2020-06-12 | Beaverhead | Montana | 30001 | 1 | 0 |
235489 | 235489 | 2020-06-13 | Beaverhead | Montana | 30001 | 1 | 0 |
238596 | 238596 | 2020-06-14 | Beaverhead | Montana | 30001 | 1 | 0 |
241706 | 241706 | 2020-06-15 | Beaverhead | Montana | 30001 | 1 | 0 |
244817 | 244817 | 2020-06-16 | Beaverhead | Montana | 30001 | 1 | 0 |
247930 | 247930 | 2020-06-17 | Beaverhead | Montana | 30001 | 1 | 0 |
251043 | 251043 | 2020-06-18 | Beaverhead | Montana | 30001 | 1 | 0 |
254158 | 254158 | 2020-06-19 | Beaverhead | Montana | 30001 | 1 | 0 |
257280 | 257280 | 2020-06-20 | Beaverhead | Montana | 30001 | 1 | 0 |
260406 | 260406 | 2020-06-21 | Beaverhead | Montana | 30001 | 1 | 0 |
263535 | 263535 | 2020-06-22 | Beaverhead | Montana | 30001 | 1 | 0 |
266661 | 266661 | 2020-06-23 | Beaverhead | Montana | 30001 | 1 | 0 |
269794 | 269794 | 2020-06-24 | Beaverhead | Montana | 30001 | 1 | 0 |
272932 | 272932 | 2020-06-25 | Beaverhead | Montana | 30001 | 1 | 0 |
276075 | 276075 | 2020-06-26 | Beaverhead | Montana | 30001 | 1 | 0 |
279223 | 279223 | 2020-06-27 | Beaverhead | Montana | 30001 | 1 | 0 |
282371 | 282371 | 2020-06-28 | Beaverhead | Montana | 30001 | 1 | 0 |
285516 | 285516 | 2020-06-29 | Beaverhead | Montana | 30001 | 1 | 0 |
288666 | 288666 | 2020-06-30 | Beaverhead | Montana | 30001 | 1 | 0 |
291817 | 291817 | 2020-07-01 | Beaverhead | Montana | 30001 | 1 | 0 |
294971 | 294971 | 2020-07-02 | Beaverhead | Montana | 30001 | 1 | 0 |
298129 | 298129 | 2020-07-03 | Beaverhead | Montana | 30001 | 1 | 0 |
301292 | 301292 | 2020-07-04 | Beaverhead | Montana | 30001 | 1 | 0 |
304456 | 304456 | 2020-07-05 | Beaverhead | Montana | 30001 | 2 | 0 |
307623 | 307623 | 2020-07-06 | Beaverhead | Montana | 30001 | 2 | 0 |
310791 | 310791 | 2020-07-07 | Beaverhead | Montana | 30001 | 2 | 0 |
313962 | 313962 | 2020-07-08 | Beaverhead | Montana | 30001 | 2 | 0 |
317136 | 317136 | 2020-07-09 | Beaverhead | Montana | 30001 | 3 | 0 |
320311 | 320311 | 2020-07-10 | Beaverhead | Montana | 30001 | 3 | 0 |
323490 | 323490 | 2020-07-11 | Beaverhead | Montana | 30001 | 3 | 0 |
326673 | 326673 | 2020-07-12 | Beaverhead | Montana | 30001 | 5 | 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);