ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
720 rows where county = "Jackson" and fips = 46071 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637378 | 637378 | 2020-10-16 | Jackson | South Dakota | 46071 | 72 | 1 |
634132 | 634132 | 2020-10-15 | Jackson | South Dakota | 46071 | 69 | 1 |
630887 | 630887 | 2020-10-14 | Jackson | South Dakota | 46071 | 64 | 1 |
627643 | 627643 | 2020-10-13 | Jackson | South Dakota | 46071 | 57 | 1 |
624401 | 624401 | 2020-10-12 | Jackson | South Dakota | 46071 | 57 | 1 |
621158 | 621158 | 2020-10-11 | Jackson | South Dakota | 46071 | 55 | 1 |
617915 | 617915 | 2020-10-10 | Jackson | South Dakota | 46071 | 52 | 1 |
614673 | 614673 | 2020-10-09 | Jackson | South Dakota | 46071 | 50 | 1 |
611432 | 611432 | 2020-10-08 | Jackson | South Dakota | 46071 | 46 | 1 |
608190 | 608190 | 2020-10-07 | Jackson | South Dakota | 46071 | 44 | 1 |
604947 | 604947 | 2020-10-06 | Jackson | South Dakota | 46071 | 38 | 1 |
601705 | 601705 | 2020-10-05 | Jackson | South Dakota | 46071 | 38 | 1 |
598462 | 598462 | 2020-10-04 | Jackson | South Dakota | 46071 | 38 | 1 |
595219 | 595219 | 2020-10-03 | Jackson | South Dakota | 46071 | 37 | 1 |
591978 | 591978 | 2020-10-02 | Jackson | South Dakota | 46071 | 37 | 1 |
588737 | 588737 | 2020-10-01 | Jackson | South Dakota | 46071 | 37 | 1 |
585497 | 585497 | 2020-09-30 | Jackson | South Dakota | 46071 | 36 | 1 |
582257 | 582257 | 2020-09-29 | Jackson | South Dakota | 46071 | 35 | 1 |
579017 | 579017 | 2020-09-28 | Jackson | South Dakota | 46071 | 35 | 1 |
575776 | 575776 | 2020-09-27 | Jackson | South Dakota | 46071 | 34 | 1 |
572532 | 572532 | 2020-09-26 | Jackson | South Dakota | 46071 | 34 | 1 |
569290 | 569290 | 2020-09-25 | Jackson | South Dakota | 46071 | 32 | 1 |
566049 | 566049 | 2020-09-24 | Jackson | South Dakota | 46071 | 31 | 1 |
562808 | 562808 | 2020-09-23 | Jackson | South Dakota | 46071 | 29 | 1 |
559571 | 559571 | 2020-09-22 | Jackson | South Dakota | 46071 | 27 | 1 |
556334 | 556334 | 2020-09-21 | Jackson | South Dakota | 46071 | 26 | 1 |
553097 | 553097 | 2020-09-20 | Jackson | South Dakota | 46071 | 25 | 1 |
549858 | 549858 | 2020-09-19 | Jackson | South Dakota | 46071 | 24 | 1 |
546619 | 546619 | 2020-09-18 | Jackson | South Dakota | 46071 | 20 | 1 |
543382 | 543382 | 2020-09-17 | Jackson | South Dakota | 46071 | 18 | 1 |
540146 | 540146 | 2020-09-16 | Jackson | South Dakota | 46071 | 17 | 1 |
536909 | 536909 | 2020-09-15 | Jackson | South Dakota | 46071 | 15 | 1 |
533673 | 533673 | 2020-09-14 | Jackson | South Dakota | 46071 | 15 | 1 |
530438 | 530438 | 2020-09-13 | Jackson | South Dakota | 46071 | 13 | 1 |
527201 | 527201 | 2020-09-12 | Jackson | South Dakota | 46071 | 12 | 1 |
523965 | 523965 | 2020-09-11 | Jackson | South Dakota | 46071 | 12 | 1 |
520729 | 520729 | 2020-09-10 | Jackson | South Dakota | 46071 | 12 | 1 |
517493 | 517493 | 2020-09-09 | Jackson | South Dakota | 46071 | 12 | 1 |
514258 | 514258 | 2020-09-08 | Jackson | South Dakota | 46071 | 12 | 1 |
511025 | 511025 | 2020-09-07 | Jackson | South Dakota | 46071 | 12 | 1 |
507792 | 507792 | 2020-09-06 | Jackson | South Dakota | 46071 | 12 | 1 |
504560 | 504560 | 2020-09-05 | Jackson | South Dakota | 46071 | 12 | 1 |
501326 | 501326 | 2020-09-04 | Jackson | South Dakota | 46071 | 12 | 1 |
498092 | 498092 | 2020-09-03 | Jackson | South Dakota | 46071 | 12 | 1 |
494859 | 494859 | 2020-09-02 | Jackson | South Dakota | 46071 | 12 | 1 |
491625 | 491625 | 2020-09-01 | Jackson | South Dakota | 46071 | 12 | 1 |
488392 | 488392 | 2020-08-31 | Jackson | South Dakota | 46071 | 12 | 1 |
485159 | 485159 | 2020-08-30 | Jackson | South Dakota | 46071 | 12 | 1 |
481924 | 481924 | 2020-08-29 | Jackson | South Dakota | 46071 | 12 | 1 |
478690 | 478690 | 2020-08-28 | Jackson | South Dakota | 46071 | 12 | 1 |
475457 | 475457 | 2020-08-27 | Jackson | South Dakota | 46071 | 12 | 1 |
472223 | 472223 | 2020-08-26 | Jackson | South Dakota | 46071 | 12 | 1 |
468991 | 468991 | 2020-08-25 | Jackson | South Dakota | 46071 | 12 | 1 |
465763 | 465763 | 2020-08-24 | Jackson | South Dakota | 46071 | 12 | 1 |
462534 | 462534 | 2020-08-23 | Jackson | South Dakota | 46071 | 12 | 1 |
459306 | 459306 | 2020-08-22 | Jackson | South Dakota | 46071 | 12 | 1 |
456078 | 456078 | 2020-08-21 | Jackson | South Dakota | 46071 | 12 | 1 |
452850 | 452850 | 2020-08-20 | Jackson | South Dakota | 46071 | 12 | 1 |
449622 | 449622 | 2020-08-19 | Jackson | South Dakota | 46071 | 12 | 1 |
446394 | 446394 | 2020-08-18 | Jackson | South Dakota | 46071 | 12 | 1 |
443168 | 443168 | 2020-08-17 | Jackson | South Dakota | 46071 | 12 | 1 |
439941 | 439941 | 2020-08-16 | Jackson | South Dakota | 46071 | 12 | 1 |
436716 | 436716 | 2020-08-15 | Jackson | South Dakota | 46071 | 11 | 1 |
433489 | 433489 | 2020-08-14 | Jackson | South Dakota | 46071 | 11 | 1 |
430264 | 430264 | 2020-08-13 | Jackson | South Dakota | 46071 | 11 | 1 |
427037 | 427037 | 2020-08-12 | Jackson | South Dakota | 46071 | 11 | 1 |
423814 | 423814 | 2020-08-11 | Jackson | South Dakota | 46071 | 11 | 1 |
420592 | 420592 | 2020-08-10 | Jackson | South Dakota | 46071 | 11 | 1 |
417371 | 417371 | 2020-08-09 | Jackson | South Dakota | 46071 | 11 | 1 |
414150 | 414150 | 2020-08-08 | Jackson | South Dakota | 46071 | 11 | 1 |
410930 | 410930 | 2020-08-07 | Jackson | South Dakota | 46071 | 11 | 1 |
407711 | 407711 | 2020-08-06 | Jackson | South Dakota | 46071 | 11 | 1 |
404491 | 404491 | 2020-08-05 | Jackson | South Dakota | 46071 | 11 | 1 |
401273 | 401273 | 2020-08-04 | Jackson | South Dakota | 46071 | 10 | 1 |
398058 | 398058 | 2020-08-03 | Jackson | South Dakota | 46071 | 10 | 1 |
394841 | 394841 | 2020-08-02 | Jackson | South Dakota | 46071 | 9 | 1 |
391625 | 391625 | 2020-08-01 | Jackson | South Dakota | 46071 | 8 | 1 |
388408 | 388408 | 2020-07-31 | Jackson | South Dakota | 46071 | 8 | 1 |
385191 | 385191 | 2020-07-30 | Jackson | South Dakota | 46071 | 7 | 1 |
381973 | 381973 | 2020-07-29 | Jackson | South Dakota | 46071 | 7 | 1 |
378756 | 378756 | 2020-07-28 | Jackson | South Dakota | 46071 | 7 | 1 |
375540 | 375540 | 2020-07-27 | Jackson | South Dakota | 46071 | 7 | 1 |
372327 | 372327 | 2020-07-26 | Jackson | South Dakota | 46071 | 7 | 1 |
369115 | 369115 | 2020-07-25 | Jackson | South Dakota | 46071 | 7 | 1 |
365906 | 365906 | 2020-07-24 | Jackson | South Dakota | 46071 | 7 | 1 |
362700 | 362700 | 2020-07-23 | Jackson | South Dakota | 46071 | 7 | 1 |
359494 | 359494 | 2020-07-22 | Jackson | South Dakota | 46071 | 7 | 1 |
356290 | 356290 | 2020-07-21 | Jackson | South Dakota | 46071 | 7 | 1 |
353087 | 353087 | 2020-07-20 | Jackson | South Dakota | 46071 | 7 | 1 |
349884 | 349884 | 2020-07-19 | Jackson | South Dakota | 46071 | 7 | 1 |
346684 | 346684 | 2020-07-18 | Jackson | South Dakota | 46071 | 7 | 1 |
343484 | 343484 | 2020-07-17 | Jackson | South Dakota | 46071 | 7 | 1 |
340286 | 340286 | 2020-07-16 | Jackson | South Dakota | 46071 | 7 | 1 |
337089 | 337089 | 2020-07-15 | Jackson | South Dakota | 46071 | 7 | 1 |
333895 | 333895 | 2020-07-14 | Jackson | South Dakota | 46071 | 7 | 1 |
330703 | 330703 | 2020-07-13 | Jackson | South Dakota | 46071 | 7 | 1 |
327517 | 327517 | 2020-07-12 | Jackson | South Dakota | 46071 | 7 | 1 |
324332 | 324332 | 2020-07-11 | Jackson | South Dakota | 46071 | 6 | 1 |
321152 | 321152 | 2020-07-10 | Jackson | South Dakota | 46071 | 6 | 1 |
317974 | 317974 | 2020-07-09 | Jackson | South Dakota | 46071 | 6 | 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);