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 |
---|---|---|---|---|---|---|---|
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 |
79677 | 79677 | 2020-04-22 | Chisago | Minnesota | 27025 | 7 | 1 |
76892 | 76892 | 2020-04-21 | Chisago | Minnesota | 27025 | 7 | 1 |
74112 | 74112 | 2020-04-20 | Chisago | Minnesota | 27025 | 7 | 1 |
71339 | 71339 | 2020-04-19 | Chisago | Minnesota | 27025 | 7 | 1 |
68575 | 68575 | 2020-04-18 | Chisago | Minnesota | 27025 | 7 | 1 |
65824 | 65824 | 2020-04-17 | Chisago | Minnesota | 27025 | 7 | 1 |
63085 | 63085 | 2020-04-16 | Chisago | Minnesota | 27025 | 7 | 1 |
60363 | 60363 | 2020-04-15 | Chisago | Minnesota | 27025 | 7 | 1 |
57653 | 57653 | 2020-04-14 | Chisago | Minnesota | 27025 | 7 | 1 |
54955 | 54955 | 2020-04-13 | Chisago | Minnesota | 27025 | 7 | 1 |
52273 | 52273 | 2020-04-12 | Chisago | Minnesota | 27025 | 7 | 1 |
49603 | 49603 | 2020-04-11 | Chisago | Minnesota | 27025 | 6 | 1 |
46958 | 46958 | 2020-04-10 | Chisago | Minnesota | 27025 | 6 | 1 |
44349 | 44349 | 2020-04-09 | Chisago | Minnesota | 27025 | 5 | 1 |
41773 | 41773 | 2020-04-08 | Chisago | Minnesota | 27025 | 5 | 1 |
39220 | 39220 | 2020-04-07 | Chisago | Minnesota | 27025 | 5 | 1 |
36711 | 36711 | 2020-04-06 | Chisago | Minnesota | 27025 | 5 | 1 |
34251 | 34251 | 2020-04-05 | Chisago | Minnesota | 27025 | 4 | 1 |
31826 | 31826 | 2020-04-04 | Chisago | Minnesota | 27025 | 4 | 1 |
29448 | 29448 | 2020-04-03 | Chisago | Minnesota | 27025 | 4 | 1 |
27129 | 27129 | 2020-04-02 | Chisago | Minnesota | 27025 | 3 | 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);