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 |
---|---|---|---|---|---|---|---|
636242 | 636242 | 2020-10-16 | Jackson | Minnesota | 27063 | 183 | 1 |
632996 | 632996 | 2020-10-15 | Jackson | Minnesota | 27063 | 181 | 1 |
629751 | 629751 | 2020-10-14 | Jackson | Minnesota | 27063 | 178 | 1 |
626507 | 626507 | 2020-10-13 | Jackson | Minnesota | 27063 | 176 | 1 |
623265 | 623265 | 2020-10-12 | Jackson | Minnesota | 27063 | 172 | 1 |
620022 | 620022 | 2020-10-11 | Jackson | Minnesota | 27063 | 169 | 1 |
616780 | 616780 | 2020-10-10 | Jackson | Minnesota | 27063 | 168 | 1 |
613539 | 613539 | 2020-10-09 | Jackson | Minnesota | 27063 | 167 | 1 |
610297 | 610297 | 2020-10-08 | Jackson | Minnesota | 27063 | 165 | 1 |
607055 | 607055 | 2020-10-07 | Jackson | Minnesota | 27063 | 161 | 1 |
603812 | 603812 | 2020-10-06 | Jackson | Minnesota | 27063 | 160 | 1 |
600570 | 600570 | 2020-10-05 | Jackson | Minnesota | 27063 | 160 | 1 |
597327 | 597327 | 2020-10-04 | Jackson | Minnesota | 27063 | 159 | 1 |
594086 | 594086 | 2020-10-03 | Jackson | Minnesota | 27063 | 159 | 1 |
590845 | 590845 | 2020-10-02 | Jackson | Minnesota | 27063 | 159 | 1 |
587604 | 587604 | 2020-10-01 | Jackson | Minnesota | 27063 | 157 | 1 |
584364 | 584364 | 2020-09-30 | Jackson | Minnesota | 27063 | 154 | 1 |
581123 | 581123 | 2020-09-29 | Jackson | Minnesota | 27063 | 153 | 1 |
577882 | 577882 | 2020-09-28 | Jackson | Minnesota | 27063 | 149 | 1 |
574641 | 574641 | 2020-09-27 | Jackson | Minnesota | 27063 | 150 | 1 |
571398 | 571398 | 2020-09-26 | Jackson | Minnesota | 27063 | 148 | 1 |
568156 | 568156 | 2020-09-25 | Jackson | Minnesota | 27063 | 145 | 1 |
564916 | 564916 | 2020-09-24 | Jackson | Minnesota | 27063 | 141 | 1 |
561676 | 561676 | 2020-09-23 | Jackson | Minnesota | 27063 | 137 | 1 |
558439 | 558439 | 2020-09-22 | Jackson | Minnesota | 27063 | 136 | 1 |
555202 | 555202 | 2020-09-21 | Jackson | Minnesota | 27063 | 134 | 1 |
551964 | 551964 | 2020-09-20 | Jackson | Minnesota | 27063 | 133 | 1 |
548725 | 548725 | 2020-09-19 | Jackson | Minnesota | 27063 | 128 | 1 |
545487 | 545487 | 2020-09-18 | Jackson | Minnesota | 27063 | 125 | 1 |
542250 | 542250 | 2020-09-17 | Jackson | Minnesota | 27063 | 120 | 1 |
539014 | 539014 | 2020-09-16 | Jackson | Minnesota | 27063 | 112 | 1 |
535777 | 535777 | 2020-09-15 | Jackson | Minnesota | 27063 | 112 | 1 |
532542 | 532542 | 2020-09-14 | Jackson | Minnesota | 27063 | 109 | 1 |
529306 | 529306 | 2020-09-13 | Jackson | Minnesota | 27063 | 104 | 1 |
526070 | 526070 | 2020-09-12 | Jackson | Minnesota | 27063 | 103 | 1 |
522834 | 522834 | 2020-09-11 | Jackson | Minnesota | 27063 | 100 | 1 |
519597 | 519597 | 2020-09-10 | Jackson | Minnesota | 27063 | 100 | 1 |
516362 | 516362 | 2020-09-09 | Jackson | Minnesota | 27063 | 99 | 1 |
513128 | 513128 | 2020-09-08 | Jackson | Minnesota | 27063 | 99 | 1 |
509896 | 509896 | 2020-09-07 | Jackson | Minnesota | 27063 | 99 | 1 |
506663 | 506663 | 2020-09-06 | Jackson | Minnesota | 27063 | 99 | 1 |
503430 | 503430 | 2020-09-05 | Jackson | Minnesota | 27063 | 98 | 1 |
500196 | 500196 | 2020-09-04 | Jackson | Minnesota | 27063 | 98 | 1 |
496962 | 496962 | 2020-09-03 | Jackson | Minnesota | 27063 | 97 | 1 |
493729 | 493729 | 2020-09-02 | Jackson | Minnesota | 27063 | 97 | 1 |
490495 | 490495 | 2020-09-01 | Jackson | Minnesota | 27063 | 96 | 1 |
487262 | 487262 | 2020-08-31 | Jackson | Minnesota | 27063 | 96 | 1 |
484028 | 484028 | 2020-08-30 | Jackson | Minnesota | 27063 | 95 | 1 |
480793 | 480793 | 2020-08-29 | Jackson | Minnesota | 27063 | 95 | 0 |
477561 | 477561 | 2020-08-28 | Jackson | Minnesota | 27063 | 93 | 0 |
474328 | 474328 | 2020-08-27 | Jackson | Minnesota | 27063 | 93 | 0 |
471096 | 471096 | 2020-08-26 | Jackson | Minnesota | 27063 | 91 | 0 |
467866 | 467866 | 2020-08-25 | Jackson | Minnesota | 27063 | 91 | 0 |
464637 | 464637 | 2020-08-24 | Jackson | Minnesota | 27063 | 91 | 0 |
461406 | 461406 | 2020-08-23 | Jackson | Minnesota | 27063 | 90 | 0 |
458179 | 458179 | 2020-08-22 | Jackson | Minnesota | 27063 | 89 | 0 |
454951 | 454951 | 2020-08-21 | Jackson | Minnesota | 27063 | 88 | 0 |
451723 | 451723 | 2020-08-20 | Jackson | Minnesota | 27063 | 87 | 0 |
448495 | 448495 | 2020-08-19 | Jackson | Minnesota | 27063 | 85 | 0 |
445269 | 445269 | 2020-08-18 | Jackson | Minnesota | 27063 | 85 | 0 |
442043 | 442043 | 2020-08-17 | Jackson | Minnesota | 27063 | 84 | 0 |
438816 | 438816 | 2020-08-16 | Jackson | Minnesota | 27063 | 83 | 0 |
435591 | 435591 | 2020-08-15 | Jackson | Minnesota | 27063 | 82 | 0 |
432365 | 432365 | 2020-08-14 | Jackson | Minnesota | 27063 | 81 | 0 |
429138 | 429138 | 2020-08-13 | Jackson | Minnesota | 27063 | 79 | 0 |
425914 | 425914 | 2020-08-12 | Jackson | Minnesota | 27063 | 79 | 0 |
422692 | 422692 | 2020-08-11 | Jackson | Minnesota | 27063 | 79 | 0 |
419470 | 419470 | 2020-08-10 | Jackson | Minnesota | 27063 | 86 | 0 |
416249 | 416249 | 2020-08-09 | Jackson | Minnesota | 27063 | 86 | 0 |
413029 | 413029 | 2020-08-08 | Jackson | Minnesota | 27063 | 81 | 0 |
409809 | 409809 | 2020-08-07 | Jackson | Minnesota | 27063 | 72 | 0 |
406589 | 406589 | 2020-08-06 | Jackson | Minnesota | 27063 | 72 | 0 |
403371 | 403371 | 2020-08-05 | Jackson | Minnesota | 27063 | 71 | 0 |
400154 | 400154 | 2020-08-04 | Jackson | Minnesota | 27063 | 70 | 0 |
396940 | 396940 | 2020-08-03 | Jackson | Minnesota | 27063 | 70 | 0 |
393724 | 393724 | 2020-08-02 | Jackson | Minnesota | 27063 | 70 | 0 |
390507 | 390507 | 2020-08-01 | Jackson | Minnesota | 27063 | 69 | 0 |
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 |
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);