ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Lake" and state = "Montana" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-27 1
- 2020-03-28 1
- 2020-03-29 1
- 2020-03-30 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- 2020-04-10 1
- 2020-04-11 1
- 2020-04-12 1
- 2020-04-13 1
- 2020-04-14 1
- 2020-04-15 1
- 2020-04-16 1
- 2020-04-17 1
- 2020-04-18 1
- 2020-04-19 1
- 2020-04-20 1
- 2020-04-21 1
- 2020-04-22 1
- 2020-04-23 1
- 2020-04-24 1
- 2020-04-25 1
- …
state 1
- Montana · 778 ✖
fips 1
- 30047 778
county 1
- Lake · 778 ✖
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
14986 | 14986 | 2020-03-27 | Lake | Montana | 30047 | 1 | 0 |
16812 | 16812 | 2020-03-28 | Lake | Montana | 30047 | 2 | 0 |
18735 | 18735 | 2020-03-29 | Lake | Montana | 30047 | 3 | 0 |
20770 | 20770 | 2020-03-30 | Lake | Montana | 30047 | 3 | 0 |
22890 | 22890 | 2020-03-31 | Lake | Montana | 30047 | 3 | 0 |
25079 | 25079 | 2020-04-01 | Lake | Montana | 30047 | 4 | 0 |
27336 | 27336 | 2020-04-02 | Lake | Montana | 30047 | 4 | 0 |
29659 | 29659 | 2020-04-03 | Lake | Montana | 30047 | 4 | 0 |
32041 | 32041 | 2020-04-04 | Lake | Montana | 30047 | 4 | 0 |
34469 | 34469 | 2020-04-05 | Lake | Montana | 30047 | 4 | 0 |
36936 | 36936 | 2020-04-06 | Lake | Montana | 30047 | 5 | 0 |
39452 | 39452 | 2020-04-07 | Lake | Montana | 30047 | 5 | 0 |
42007 | 42007 | 2020-04-08 | Lake | Montana | 30047 | 5 | 0 |
47196 | 47196 | 2020-04-10 | Lake | Montana | 30047 | 5 | 0 |
49845 | 49845 | 2020-04-11 | Lake | Montana | 30047 | 5 | 0 |
52518 | 52518 | 2020-04-12 | Lake | Montana | 30047 | 5 | 0 |
55199 | 55199 | 2020-04-13 | Lake | Montana | 30047 | 5 | 0 |
57898 | 57898 | 2020-04-14 | Lake | Montana | 30047 | 5 | 0 |
60611 | 60611 | 2020-04-15 | Lake | Montana | 30047 | 5 | 0 |
63334 | 63334 | 2020-04-16 | Lake | Montana | 30047 | 5 | 0 |
66074 | 66074 | 2020-04-17 | Lake | Montana | 30047 | 5 | 0 |
68828 | 68828 | 2020-04-18 | Lake | Montana | 30047 | 5 | 0 |
71595 | 71595 | 2020-04-19 | Lake | Montana | 30047 | 5 | 0 |
74368 | 74368 | 2020-04-20 | Lake | Montana | 30047 | 5 | 0 |
77148 | 77148 | 2020-04-21 | Lake | Montana | 30047 | 5 | 0 |
79936 | 79936 | 2020-04-22 | Lake | Montana | 30047 | 5 | 0 |
82732 | 82732 | 2020-04-23 | Lake | Montana | 30047 | 5 | 0 |
85536 | 85536 | 2020-04-24 | Lake | Montana | 30047 | 5 | 0 |
88346 | 88346 | 2020-04-25 | Lake | Montana | 30047 | 5 | 0 |
91161 | 91161 | 2020-04-26 | Lake | Montana | 30047 | 5 | 0 |
93982 | 93982 | 2020-04-27 | Lake | Montana | 30047 | 5 | 0 |
96818 | 96818 | 2020-04-28 | Lake | Montana | 30047 | 5 | 0 |
99664 | 99664 | 2020-04-29 | Lake | Montana | 30047 | 5 | 0 |
102516 | 102516 | 2020-04-30 | Lake | Montana | 30047 | 5 | 0 |
105377 | 105377 | 2020-05-01 | Lake | Montana | 30047 | 5 | 0 |
108243 | 108243 | 2020-05-02 | Lake | Montana | 30047 | 5 | 0 |
111115 | 111115 | 2020-05-03 | Lake | Montana | 30047 | 5 | 0 |
113994 | 113994 | 2020-05-04 | Lake | Montana | 30047 | 5 | 0 |
116876 | 116876 | 2020-05-05 | Lake | Montana | 30047 | 5 | 0 |
119836 | 119836 | 2020-05-06 | Lake | Montana | 30047 | 5 | 0 |
122810 | 122810 | 2020-05-07 | Lake | Montana | 30047 | 5 | 0 |
125792 | 125792 | 2020-05-08 | Lake | Montana | 30047 | 5 | 0 |
128780 | 128780 | 2020-05-09 | Lake | Montana | 30047 | 5 | 0 |
131770 | 131770 | 2020-05-10 | Lake | Montana | 30047 | 5 | 0 |
134761 | 134761 | 2020-05-11 | Lake | Montana | 30047 | 5 | 0 |
137751 | 137751 | 2020-05-12 | Lake | Montana | 30047 | 5 | 0 |
140745 | 140745 | 2020-05-13 | Lake | Montana | 30047 | 5 | 0 |
143740 | 143740 | 2020-05-14 | Lake | Montana | 30047 | 5 | 0 |
146741 | 146741 | 2020-05-15 | Lake | Montana | 30047 | 5 | 0 |
149747 | 149747 | 2020-05-16 | Lake | Montana | 30047 | 5 | 0 |
152758 | 152758 | 2020-05-17 | Lake | Montana | 30047 | 5 | 0 |
155772 | 155772 | 2020-05-18 | Lake | Montana | 30047 | 5 | 0 |
158790 | 158790 | 2020-05-19 | Lake | Montana | 30047 | 5 | 0 |
161816 | 161816 | 2020-05-20 | Lake | Montana | 30047 | 5 | 0 |
164845 | 164845 | 2020-05-21 | Lake | Montana | 30047 | 5 | 0 |
167881 | 167881 | 2020-05-22 | Lake | Montana | 30047 | 5 | 0 |
170920 | 170920 | 2020-05-23 | Lake | Montana | 30047 | 5 | 0 |
173962 | 173962 | 2020-05-24 | Lake | Montana | 30047 | 5 | 0 |
177005 | 177005 | 2020-05-25 | Lake | Montana | 30047 | 5 | 0 |
180049 | 180049 | 2020-05-26 | Lake | Montana | 30047 | 5 | 0 |
183097 | 183097 | 2020-05-27 | Lake | Montana | 30047 | 5 | 0 |
186153 | 186153 | 2020-05-28 | Lake | Montana | 30047 | 5 | 0 |
189212 | 189212 | 2020-05-29 | Lake | Montana | 30047 | 5 | 0 |
192276 | 192276 | 2020-05-30 | Lake | Montana | 30047 | 5 | 0 |
195346 | 195346 | 2020-05-31 | Lake | Montana | 30047 | 5 | 0 |
198417 | 198417 | 2020-06-01 | Lake | Montana | 30047 | 5 | 0 |
201490 | 201490 | 2020-06-02 | Lake | Montana | 30047 | 5 | 0 |
204567 | 204567 | 2020-06-03 | Lake | Montana | 30047 | 5 | 0 |
207648 | 207648 | 2020-06-04 | Lake | Montana | 30047 | 5 | 0 |
210729 | 210729 | 2020-06-05 | Lake | Montana | 30047 | 5 | 0 |
213813 | 213813 | 2020-06-06 | Lake | Montana | 30047 | 5 | 0 |
216902 | 216902 | 2020-06-07 | Lake | Montana | 30047 | 5 | 0 |
219994 | 219994 | 2020-06-08 | Lake | Montana | 30047 | 5 | 0 |
223089 | 223089 | 2020-06-09 | Lake | Montana | 30047 | 5 | 0 |
226188 | 226188 | 2020-06-10 | Lake | Montana | 30047 | 5 | 0 |
229291 | 229291 | 2020-06-11 | Lake | Montana | 30047 | 5 | 0 |
44586 | 44586 | 2020-04-09 | Lake | Montana | 30047 | 6 | 0 |
232396 | 232396 | 2020-06-12 | Lake | Montana | 30047 | 6 | 0 |
235502 | 235502 | 2020-06-13 | Lake | Montana | 30047 | 9 | 0 |
238609 | 238609 | 2020-06-14 | Lake | Montana | 30047 | 9 | 0 |
241719 | 241719 | 2020-06-15 | Lake | Montana | 30047 | 9 | 0 |
244830 | 244830 | 2020-06-16 | Lake | Montana | 30047 | 9 | 0 |
247943 | 247943 | 2020-06-17 | Lake | Montana | 30047 | 9 | 0 |
251057 | 251057 | 2020-06-18 | Lake | Montana | 30047 | 10 | 0 |
254172 | 254172 | 2020-06-19 | Lake | Montana | 30047 | 10 | 0 |
257295 | 257295 | 2020-06-20 | Lake | Montana | 30047 | 10 | 0 |
260421 | 260421 | 2020-06-21 | Lake | Montana | 30047 | 11 | 0 |
263550 | 263550 | 2020-06-22 | Lake | Montana | 30047 | 12 | 0 |
266676 | 266676 | 2020-06-23 | Lake | Montana | 30047 | 12 | 0 |
269809 | 269809 | 2020-06-24 | Lake | Montana | 30047 | 12 | 0 |
272948 | 272948 | 2020-06-25 | Lake | Montana | 30047 | 12 | 0 |
276091 | 276091 | 2020-06-26 | Lake | Montana | 30047 | 12 | 0 |
279239 | 279239 | 2020-06-27 | Lake | Montana | 30047 | 12 | 0 |
282387 | 282387 | 2020-06-28 | Lake | Montana | 30047 | 16 | 0 |
285532 | 285532 | 2020-06-29 | Lake | Montana | 30047 | 16 | 0 |
288682 | 288682 | 2020-06-30 | Lake | Montana | 30047 | 17 | 0 |
291833 | 291833 | 2020-07-01 | Lake | Montana | 30047 | 18 | 0 |
294987 | 294987 | 2020-07-02 | Lake | Montana | 30047 | 18 | 0 |
298145 | 298145 | 2020-07-03 | Lake | Montana | 30047 | 18 | 0 |
301308 | 301308 | 2020-07-04 | Lake | Montana | 30047 | 19 | 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);