ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
101 rows where county = "Jackson", deaths = 1 and fips = 27063 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
808205 | 808205 | 2020-12-08 | Jackson | Minnesota | 27063 | 607 | 1 |
804960 | 804960 | 2020-12-07 | Jackson | Minnesota | 27063 | 595 | 1 |
801715 | 801715 | 2020-12-06 | Jackson | Minnesota | 27063 | 582 | 1 |
798470 | 798470 | 2020-12-05 | Jackson | Minnesota | 27063 | 572 | 1 |
795225 | 795225 | 2020-12-04 | Jackson | Minnesota | 27063 | 546 | 1 |
791980 | 791980 | 2020-12-03 | Jackson | Minnesota | 27063 | 532 | 1 |
788735 | 788735 | 2020-12-02 | Jackson | Minnesota | 27063 | 518 | 1 |
785490 | 785490 | 2020-12-01 | Jackson | Minnesota | 27063 | 506 | 1 |
782246 | 782246 | 2020-11-30 | Jackson | Minnesota | 27063 | 496 | 1 |
779000 | 779000 | 2020-11-29 | Jackson | Minnesota | 27063 | 488 | 1 |
775755 | 775755 | 2020-11-28 | Jackson | Minnesota | 27063 | 484 | 1 |
772510 | 772510 | 2020-11-27 | Jackson | Minnesota | 27063 | 458 | 1 |
769265 | 769265 | 2020-11-26 | Jackson | Minnesota | 27063 | 436 | 1 |
766019 | 766019 | 2020-11-25 | Jackson | Minnesota | 27063 | 436 | 1 |
762774 | 762774 | 2020-11-24 | Jackson | Minnesota | 27063 | 429 | 1 |
759529 | 759529 | 2020-11-23 | Jackson | Minnesota | 27063 | 409 | 1 |
756282 | 756282 | 2020-11-22 | Jackson | Minnesota | 27063 | 398 | 1 |
753036 | 753036 | 2020-11-21 | Jackson | Minnesota | 27063 | 384 | 1 |
749790 | 749790 | 2020-11-20 | Jackson | Minnesota | 27063 | 373 | 1 |
746544 | 746544 | 2020-11-19 | Jackson | Minnesota | 27063 | 358 | 1 |
743297 | 743297 | 2020-11-18 | Jackson | Minnesota | 27063 | 356 | 1 |
740050 | 740050 | 2020-11-17 | Jackson | Minnesota | 27063 | 350 | 1 |
736806 | 736806 | 2020-11-16 | Jackson | Minnesota | 27063 | 340 | 1 |
733560 | 733560 | 2020-11-15 | Jackson | Minnesota | 27063 | 326 | 1 |
730315 | 730315 | 2020-11-14 | Jackson | Minnesota | 27063 | 314 | 1 |
727072 | 727072 | 2020-11-13 | Jackson | Minnesota | 27063 | 307 | 1 |
723829 | 723829 | 2020-11-12 | Jackson | Minnesota | 27063 | 296 | 1 |
720586 | 720586 | 2020-11-11 | Jackson | Minnesota | 27063 | 283 | 1 |
717343 | 717343 | 2020-11-10 | Jackson | Minnesota | 27063 | 278 | 1 |
714099 | 714099 | 2020-11-09 | Jackson | Minnesota | 27063 | 273 | 1 |
710855 | 710855 | 2020-11-08 | Jackson | Minnesota | 27063 | 272 | 1 |
707611 | 707611 | 2020-11-07 | Jackson | Minnesota | 27063 | 266 | 1 |
704368 | 704368 | 2020-11-06 | Jackson | Minnesota | 27063 | 263 | 1 |
701126 | 701126 | 2020-11-05 | Jackson | Minnesota | 27063 | 261 | 1 |
697882 | 697882 | 2020-11-04 | Jackson | Minnesota | 27063 | 251 | 1 |
694639 | 694639 | 2020-11-03 | Jackson | Minnesota | 27063 | 248 | 1 |
691397 | 691397 | 2020-11-02 | Jackson | Minnesota | 27063 | 241 | 1 |
688152 | 688152 | 2020-11-01 | Jackson | Minnesota | 27063 | 240 | 1 |
684908 | 684908 | 2020-10-31 | Jackson | Minnesota | 27063 | 235 | 1 |
681665 | 681665 | 2020-10-30 | Jackson | Minnesota | 27063 | 226 | 1 |
678421 | 678421 | 2020-10-29 | Jackson | Minnesota | 27063 | 221 | 1 |
675179 | 675179 | 2020-10-28 | Jackson | Minnesota | 27063 | 219 | 1 |
671936 | 671936 | 2020-10-27 | Jackson | Minnesota | 27063 | 217 | 1 |
668694 | 668694 | 2020-10-26 | Jackson | Minnesota | 27063 | 215 | 1 |
665450 | 665450 | 2020-10-25 | Jackson | Minnesota | 27063 | 210 | 1 |
662205 | 662205 | 2020-10-24 | Jackson | Minnesota | 27063 | 208 | 1 |
658961 | 658961 | 2020-10-23 | Jackson | Minnesota | 27063 | 207 | 1 |
655716 | 655716 | 2020-10-22 | Jackson | Minnesota | 27063 | 204 | 1 |
652471 | 652471 | 2020-10-21 | Jackson | Minnesota | 27063 | 201 | 1 |
649226 | 649226 | 2020-10-20 | Jackson | Minnesota | 27063 | 198 | 1 |
645982 | 645982 | 2020-10-19 | Jackson | Minnesota | 27063 | 195 | 1 |
642735 | 642735 | 2020-10-18 | Jackson | Minnesota | 27063 | 189 | 1 |
639488 | 639488 | 2020-10-17 | Jackson | Minnesota | 27063 | 186 | 1 |
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 |
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);