ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Jackson" and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387290 | 387290 | 2020-07-31 | Jackson | Minnesota | 27063 | 68 | 0 |
384072 | 384072 | 2020-07-30 | Jackson | Minnesota | 27063 | 69 | 0 |
380855 | 380855 | 2020-07-29 | Jackson | Minnesota | 27063 | 67 | 0 |
377638 | 377638 | 2020-07-28 | Jackson | Minnesota | 27063 | 65 | 0 |
374423 | 374423 | 2020-07-27 | Jackson | Minnesota | 27063 | 64 | 0 |
371211 | 371211 | 2020-07-26 | Jackson | Minnesota | 27063 | 64 | 0 |
368001 | 368001 | 2020-07-25 | Jackson | Minnesota | 27063 | 64 | 0 |
364794 | 364794 | 2020-07-24 | Jackson | Minnesota | 27063 | 61 | 0 |
361587 | 361587 | 2020-07-23 | Jackson | Minnesota | 27063 | 60 | 0 |
358382 | 358382 | 2020-07-22 | Jackson | Minnesota | 27063 | 60 | 0 |
355179 | 355179 | 2020-07-21 | Jackson | Minnesota | 27063 | 60 | 0 |
351977 | 351977 | 2020-07-20 | Jackson | Minnesota | 27063 | 60 | 0 |
348777 | 348777 | 2020-07-19 | Jackson | Minnesota | 27063 | 61 | 0 |
345576 | 345576 | 2020-07-18 | Jackson | Minnesota | 27063 | 61 | 0 |
342376 | 342376 | 2020-07-17 | Jackson | Minnesota | 27063 | 61 | 0 |
339180 | 339180 | 2020-07-16 | Jackson | Minnesota | 27063 | 60 | 0 |
335984 | 335984 | 2020-07-15 | Jackson | Minnesota | 27063 | 59 | 0 |
332791 | 332791 | 2020-07-14 | Jackson | Minnesota | 27063 | 58 | 0 |
329604 | 329604 | 2020-07-13 | Jackson | Minnesota | 27063 | 58 | 0 |
326418 | 326418 | 2020-07-12 | Jackson | Minnesota | 27063 | 57 | 0 |
323235 | 323235 | 2020-07-11 | Jackson | Minnesota | 27063 | 57 | 0 |
320056 | 320056 | 2020-07-10 | Jackson | Minnesota | 27063 | 57 | 0 |
316881 | 316881 | 2020-07-09 | Jackson | Minnesota | 27063 | 57 | 0 |
313707 | 313707 | 2020-07-08 | Jackson | Minnesota | 27063 | 55 | 0 |
310537 | 310537 | 2020-07-07 | Jackson | Minnesota | 27063 | 55 | 0 |
307369 | 307369 | 2020-07-06 | Jackson | Minnesota | 27063 | 55 | 0 |
304202 | 304202 | 2020-07-05 | Jackson | Minnesota | 27063 | 55 | 0 |
301038 | 301038 | 2020-07-04 | Jackson | Minnesota | 27063 | 55 | 0 |
297875 | 297875 | 2020-07-03 | Jackson | Minnesota | 27063 | 55 | 0 |
294717 | 294717 | 2020-07-02 | Jackson | Minnesota | 27063 | 55 | 0 |
291563 | 291563 | 2020-07-01 | Jackson | Minnesota | 27063 | 54 | 0 |
288412 | 288412 | 2020-06-30 | Jackson | Minnesota | 27063 | 54 | 0 |
285262 | 285262 | 2020-06-29 | Jackson | Minnesota | 27063 | 54 | 0 |
282117 | 282117 | 2020-06-28 | Jackson | Minnesota | 27063 | 54 | 0 |
278969 | 278969 | 2020-06-27 | Jackson | Minnesota | 27063 | 53 | 0 |
275821 | 275821 | 2020-06-26 | Jackson | Minnesota | 27063 | 53 | 0 |
272678 | 272678 | 2020-06-25 | Jackson | Minnesota | 27063 | 53 | 0 |
269541 | 269541 | 2020-06-24 | Jackson | Minnesota | 27063 | 53 | 0 |
266408 | 266408 | 2020-06-23 | Jackson | Minnesota | 27063 | 53 | 0 |
263282 | 263282 | 2020-06-22 | Jackson | Minnesota | 27063 | 53 | 0 |
260153 | 260153 | 2020-06-21 | Jackson | Minnesota | 27063 | 52 | 0 |
257027 | 257027 | 2020-06-20 | Jackson | Minnesota | 27063 | 50 | 0 |
253907 | 253907 | 2020-06-19 | Jackson | Minnesota | 27063 | 50 | 0 |
250792 | 250792 | 2020-06-18 | Jackson | Minnesota | 27063 | 50 | 0 |
247680 | 247680 | 2020-06-17 | Jackson | Minnesota | 27063 | 48 | 0 |
244567 | 244567 | 2020-06-16 | Jackson | Minnesota | 27063 | 48 | 0 |
241456 | 241456 | 2020-06-15 | Jackson | Minnesota | 27063 | 48 | 0 |
238347 | 238347 | 2020-06-14 | Jackson | Minnesota | 27063 | 46 | 0 |
235240 | 235240 | 2020-06-13 | Jackson | Minnesota | 27063 | 46 | 0 |
232134 | 232134 | 2020-06-12 | Jackson | Minnesota | 27063 | 43 | 0 |
229030 | 229030 | 2020-06-11 | Jackson | Minnesota | 27063 | 43 | 0 |
225928 | 225928 | 2020-06-10 | Jackson | Minnesota | 27063 | 43 | 0 |
222830 | 222830 | 2020-06-09 | Jackson | Minnesota | 27063 | 42 | 0 |
219735 | 219735 | 2020-06-08 | Jackson | Minnesota | 27063 | 42 | 0 |
216643 | 216643 | 2020-06-07 | Jackson | Minnesota | 27063 | 42 | 0 |
213555 | 213555 | 2020-06-06 | Jackson | Minnesota | 27063 | 42 | 0 |
210471 | 210471 | 2020-06-05 | Jackson | Minnesota | 27063 | 42 | 0 |
207390 | 207390 | 2020-06-04 | Jackson | Minnesota | 27063 | 42 | 0 |
204309 | 204309 | 2020-06-03 | Jackson | Minnesota | 27063 | 40 | 0 |
201232 | 201232 | 2020-06-02 | Jackson | Minnesota | 27063 | 40 | 0 |
198159 | 198159 | 2020-06-01 | Jackson | Minnesota | 27063 | 39 | 0 |
195088 | 195088 | 2020-05-31 | Jackson | Minnesota | 27063 | 39 | 0 |
192020 | 192020 | 2020-05-30 | Jackson | Minnesota | 27063 | 39 | 0 |
188956 | 188956 | 2020-05-29 | Jackson | Minnesota | 27063 | 39 | 0 |
185898 | 185898 | 2020-05-28 | Jackson | Minnesota | 27063 | 39 | 0 |
182843 | 182843 | 2020-05-27 | Jackson | Minnesota | 27063 | 39 | 0 |
179797 | 179797 | 2020-05-26 | Jackson | Minnesota | 27063 | 39 | 0 |
176753 | 176753 | 2020-05-25 | Jackson | Minnesota | 27063 | 39 | 0 |
173710 | 173710 | 2020-05-24 | Jackson | Minnesota | 27063 | 39 | 0 |
170668 | 170668 | 2020-05-23 | Jackson | Minnesota | 27063 | 38 | 0 |
167630 | 167630 | 2020-05-22 | Jackson | Minnesota | 27063 | 37 | 0 |
164594 | 164594 | 2020-05-21 | Jackson | Minnesota | 27063 | 36 | 0 |
161565 | 161565 | 2020-05-20 | Jackson | Minnesota | 27063 | 36 | 0 |
158539 | 158539 | 2020-05-19 | Jackson | Minnesota | 27063 | 36 | 0 |
155521 | 155521 | 2020-05-18 | Jackson | Minnesota | 27063 | 36 | 0 |
152507 | 152507 | 2020-05-17 | Jackson | Minnesota | 27063 | 36 | 0 |
149496 | 149496 | 2020-05-16 | Jackson | Minnesota | 27063 | 35 | 0 |
146491 | 146491 | 2020-05-15 | Jackson | Minnesota | 27063 | 34 | 0 |
143491 | 143491 | 2020-05-14 | Jackson | Minnesota | 27063 | 34 | 0 |
140496 | 140496 | 2020-05-13 | Jackson | Minnesota | 27063 | 33 | 0 |
137502 | 137502 | 2020-05-12 | Jackson | Minnesota | 27063 | 33 | 0 |
134512 | 134512 | 2020-05-11 | Jackson | Minnesota | 27063 | 33 | 0 |
131521 | 131521 | 2020-05-10 | Jackson | Minnesota | 27063 | 32 | 0 |
128531 | 128531 | 2020-05-09 | Jackson | Minnesota | 27063 | 31 | 0 |
125544 | 125544 | 2020-05-08 | Jackson | Minnesota | 27063 | 29 | 0 |
122562 | 122562 | 2020-05-07 | Jackson | Minnesota | 27063 | 29 | 0 |
119589 | 119589 | 2020-05-06 | Jackson | Minnesota | 27063 | 25 | 0 |
116629 | 116629 | 2020-05-05 | Jackson | Minnesota | 27063 | 25 | 0 |
113748 | 113748 | 2020-05-04 | Jackson | Minnesota | 27063 | 24 | 0 |
110869 | 110869 | 2020-05-03 | Jackson | Minnesota | 27063 | 18 | 0 |
107998 | 107998 | 2020-05-02 | Jackson | Minnesota | 27063 | 18 | 0 |
105133 | 105133 | 2020-05-01 | Jackson | Minnesota | 27063 | 16 | 0 |
102273 | 102273 | 2020-04-30 | Jackson | Minnesota | 27063 | 14 | 0 |
99421 | 99421 | 2020-04-29 | Jackson | Minnesota | 27063 | 12 | 0 |
96575 | 96575 | 2020-04-28 | Jackson | Minnesota | 27063 | 9 | 0 |
93740 | 93740 | 2020-04-27 | Jackson | Minnesota | 27063 | 8 | 0 |
90919 | 90919 | 2020-04-26 | Jackson | Minnesota | 27063 | 7 | 0 |
88103 | 88103 | 2020-04-25 | Jackson | Minnesota | 27063 | 7 | 0 |
85293 | 85293 | 2020-04-24 | Jackson | Minnesota | 27063 | 6 | 0 |
82489 | 82489 | 2020-04-23 | Jackson | Minnesota | 27063 | 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);