ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Chisago" and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387271 | 387271 | 2020-07-31 | Chisago | Minnesota | 27025 | 167 | 1 |
384053 | 384053 | 2020-07-30 | Chisago | Minnesota | 27025 | 160 | 1 |
380836 | 380836 | 2020-07-29 | Chisago | Minnesota | 27025 | 158 | 1 |
377619 | 377619 | 2020-07-28 | Chisago | Minnesota | 27025 | 156 | 1 |
374404 | 374404 | 2020-07-27 | Chisago | Minnesota | 27025 | 156 | 1 |
371192 | 371192 | 2020-07-26 | Chisago | Minnesota | 27025 | 154 | 1 |
367982 | 367982 | 2020-07-25 | Chisago | Minnesota | 27025 | 147 | 1 |
364775 | 364775 | 2020-07-24 | Chisago | Minnesota | 27025 | 141 | 1 |
361568 | 361568 | 2020-07-23 | Chisago | Minnesota | 27025 | 138 | 1 |
358363 | 358363 | 2020-07-22 | Chisago | Minnesota | 27025 | 135 | 1 |
355160 | 355160 | 2020-07-21 | Chisago | Minnesota | 27025 | 128 | 1 |
351958 | 351958 | 2020-07-20 | Chisago | Minnesota | 27025 | 126 | 1 |
348758 | 348758 | 2020-07-19 | Chisago | Minnesota | 27025 | 124 | 1 |
345557 | 345557 | 2020-07-18 | Chisago | Minnesota | 27025 | 121 | 1 |
342357 | 342357 | 2020-07-17 | Chisago | Minnesota | 27025 | 119 | 1 |
339161 | 339161 | 2020-07-16 | Chisago | Minnesota | 27025 | 114 | 1 |
335965 | 335965 | 2020-07-15 | Chisago | Minnesota | 27025 | 113 | 1 |
332772 | 332772 | 2020-07-14 | Chisago | Minnesota | 27025 | 112 | 1 |
329585 | 329585 | 2020-07-13 | Chisago | Minnesota | 27025 | 111 | 1 |
326399 | 326399 | 2020-07-12 | Chisago | Minnesota | 27025 | 110 | 1 |
323216 | 323216 | 2020-07-11 | Chisago | Minnesota | 27025 | 107 | 1 |
320037 | 320037 | 2020-07-10 | Chisago | Minnesota | 27025 | 105 | 1 |
316862 | 316862 | 2020-07-09 | Chisago | Minnesota | 27025 | 103 | 1 |
313688 | 313688 | 2020-07-08 | Chisago | Minnesota | 27025 | 102 | 1 |
310518 | 310518 | 2020-07-07 | Chisago | Minnesota | 27025 | 102 | 1 |
307350 | 307350 | 2020-07-06 | Chisago | Minnesota | 27025 | 100 | 1 |
304183 | 304183 | 2020-07-05 | Chisago | Minnesota | 27025 | 98 | 1 |
301019 | 301019 | 2020-07-04 | Chisago | Minnesota | 27025 | 97 | 1 |
297856 | 297856 | 2020-07-03 | Chisago | Minnesota | 27025 | 97 | 1 |
294698 | 294698 | 2020-07-02 | Chisago | Minnesota | 27025 | 97 | 1 |
291544 | 291544 | 2020-07-01 | Chisago | Minnesota | 27025 | 95 | 1 |
288393 | 288393 | 2020-06-30 | Chisago | Minnesota | 27025 | 93 | 1 |
285243 | 285243 | 2020-06-29 | Chisago | Minnesota | 27025 | 93 | 1 |
282098 | 282098 | 2020-06-28 | Chisago | Minnesota | 27025 | 92 | 1 |
278950 | 278950 | 2020-06-27 | Chisago | Minnesota | 27025 | 90 | 1 |
275802 | 275802 | 2020-06-26 | Chisago | Minnesota | 27025 | 90 | 1 |
272659 | 272659 | 2020-06-25 | Chisago | Minnesota | 27025 | 88 | 1 |
269522 | 269522 | 2020-06-24 | Chisago | Minnesota | 27025 | 87 | 1 |
266389 | 266389 | 2020-06-23 | Chisago | Minnesota | 27025 | 87 | 1 |
263263 | 263263 | 2020-06-22 | Chisago | Minnesota | 27025 | 87 | 1 |
260134 | 260134 | 2020-06-21 | Chisago | Minnesota | 27025 | 87 | 1 |
257008 | 257008 | 2020-06-20 | Chisago | Minnesota | 27025 | 83 | 1 |
253888 | 253888 | 2020-06-19 | Chisago | Minnesota | 27025 | 82 | 1 |
250773 | 250773 | 2020-06-18 | Chisago | Minnesota | 27025 | 81 | 1 |
247661 | 247661 | 2020-06-17 | Chisago | Minnesota | 27025 | 81 | 1 |
244548 | 244548 | 2020-06-16 | Chisago | Minnesota | 27025 | 80 | 1 |
241437 | 241437 | 2020-06-15 | Chisago | Minnesota | 27025 | 80 | 1 |
238328 | 238328 | 2020-06-14 | Chisago | Minnesota | 27025 | 78 | 1 |
235221 | 235221 | 2020-06-13 | Chisago | Minnesota | 27025 | 78 | 1 |
232116 | 232116 | 2020-06-12 | Chisago | Minnesota | 27025 | 77 | 1 |
229012 | 229012 | 2020-06-11 | Chisago | Minnesota | 27025 | 74 | 1 |
225910 | 225910 | 2020-06-10 | Chisago | Minnesota | 27025 | 73 | 1 |
222812 | 222812 | 2020-06-09 | Chisago | Minnesota | 27025 | 70 | 1 |
219717 | 219717 | 2020-06-08 | Chisago | Minnesota | 27025 | 70 | 1 |
216625 | 216625 | 2020-06-07 | Chisago | Minnesota | 27025 | 70 | 1 |
213537 | 213537 | 2020-06-06 | Chisago | Minnesota | 27025 | 70 | 1 |
210453 | 210453 | 2020-06-05 | Chisago | Minnesota | 27025 | 69 | 1 |
207372 | 207372 | 2020-06-04 | Chisago | Minnesota | 27025 | 64 | 1 |
204291 | 204291 | 2020-06-03 | Chisago | Minnesota | 27025 | 64 | 1 |
201214 | 201214 | 2020-06-02 | Chisago | Minnesota | 27025 | 62 | 1 |
198141 | 198141 | 2020-06-01 | Chisago | Minnesota | 27025 | 62 | 1 |
195070 | 195070 | 2020-05-31 | Chisago | Minnesota | 27025 | 61 | 1 |
192002 | 192002 | 2020-05-30 | Chisago | Minnesota | 27025 | 61 | 1 |
188938 | 188938 | 2020-05-29 | Chisago | Minnesota | 27025 | 60 | 1 |
185880 | 185880 | 2020-05-28 | Chisago | Minnesota | 27025 | 54 | 1 |
182825 | 182825 | 2020-05-27 | Chisago | Minnesota | 27025 | 50 | 1 |
179779 | 179779 | 2020-05-26 | Chisago | Minnesota | 27025 | 49 | 1 |
176735 | 176735 | 2020-05-25 | Chisago | Minnesota | 27025 | 48 | 1 |
173692 | 173692 | 2020-05-24 | Chisago | Minnesota | 27025 | 48 | 1 |
170650 | 170650 | 2020-05-23 | Chisago | Minnesota | 27025 | 44 | 1 |
167613 | 167613 | 2020-05-22 | Chisago | Minnesota | 27025 | 41 | 1 |
164577 | 164577 | 2020-05-21 | Chisago | Minnesota | 27025 | 39 | 1 |
161548 | 161548 | 2020-05-20 | Chisago | Minnesota | 27025 | 38 | 1 |
158522 | 158522 | 2020-05-19 | Chisago | Minnesota | 27025 | 38 | 1 |
155504 | 155504 | 2020-05-18 | Chisago | Minnesota | 27025 | 37 | 1 |
152490 | 152490 | 2020-05-17 | Chisago | Minnesota | 27025 | 34 | 1 |
149479 | 149479 | 2020-05-16 | Chisago | Minnesota | 27025 | 30 | 1 |
146474 | 146474 | 2020-05-15 | Chisago | Minnesota | 27025 | 27 | 1 |
143474 | 143474 | 2020-05-14 | Chisago | Minnesota | 27025 | 25 | 1 |
140479 | 140479 | 2020-05-13 | Chisago | Minnesota | 27025 | 23 | 1 |
137485 | 137485 | 2020-05-12 | Chisago | Minnesota | 27025 | 23 | 1 |
134495 | 134495 | 2020-05-11 | Chisago | Minnesota | 27025 | 20 | 1 |
131504 | 131504 | 2020-05-10 | Chisago | Minnesota | 27025 | 20 | 1 |
128514 | 128514 | 2020-05-09 | Chisago | Minnesota | 27025 | 19 | 1 |
125527 | 125527 | 2020-05-08 | Chisago | Minnesota | 27025 | 18 | 1 |
122545 | 122545 | 2020-05-07 | Chisago | Minnesota | 27025 | 14 | 1 |
119572 | 119572 | 2020-05-06 | Chisago | Minnesota | 27025 | 14 | 1 |
116612 | 116612 | 2020-05-05 | Chisago | Minnesota | 27025 | 13 | 1 |
113731 | 113731 | 2020-05-04 | Chisago | Minnesota | 27025 | 13 | 1 |
110852 | 110852 | 2020-05-03 | Chisago | Minnesota | 27025 | 13 | 1 |
107981 | 107981 | 2020-05-02 | Chisago | Minnesota | 27025 | 13 | 1 |
105117 | 105117 | 2020-05-01 | Chisago | Minnesota | 27025 | 12 | 1 |
102257 | 102257 | 2020-04-30 | Chisago | Minnesota | 27025 | 11 | 1 |
99405 | 99405 | 2020-04-29 | Chisago | Minnesota | 27025 | 10 | 1 |
96559 | 96559 | 2020-04-28 | Chisago | Minnesota | 27025 | 9 | 1 |
93724 | 93724 | 2020-04-27 | Chisago | Minnesota | 27025 | 7 | 1 |
90903 | 90903 | 2020-04-26 | Chisago | Minnesota | 27025 | 7 | 1 |
88087 | 88087 | 2020-04-25 | Chisago | Minnesota | 27025 | 7 | 1 |
85277 | 85277 | 2020-04-24 | Chisago | Minnesota | 27025 | 7 | 1 |
82473 | 82473 | 2020-04-23 | Chisago | Minnesota | 27025 | 7 | 1 |
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);