ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Jackson" and fips = 28059 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636328 | 636328 | 2020-10-16 | Jackson | Mississippi | 28059 | 4258 | 77 |
633082 | 633082 | 2020-10-15 | Jackson | Mississippi | 28059 | 4193 | 76 |
629837 | 629837 | 2020-10-14 | Jackson | Mississippi | 28059 | 4130 | 75 |
626593 | 626593 | 2020-10-13 | Jackson | Mississippi | 28059 | 4083 | 74 |
623351 | 623351 | 2020-10-12 | Jackson | Mississippi | 28059 | 4029 | 74 |
620108 | 620108 | 2020-10-11 | Jackson | Mississippi | 28059 | 4011 | 74 |
616866 | 616866 | 2020-10-10 | Jackson | Mississippi | 28059 | 4002 | 74 |
613625 | 613625 | 2020-10-09 | Jackson | Mississippi | 28059 | 3956 | 74 |
610383 | 610383 | 2020-10-08 | Jackson | Mississippi | 28059 | 3917 | 74 |
607141 | 607141 | 2020-10-07 | Jackson | Mississippi | 28059 | 3882 | 72 |
603898 | 603898 | 2020-10-06 | Jackson | Mississippi | 28059 | 3848 | 71 |
600656 | 600656 | 2020-10-05 | Jackson | Mississippi | 28059 | 3754 | 70 |
597413 | 597413 | 2020-10-04 | Jackson | Mississippi | 28059 | 3739 | 70 |
594172 | 594172 | 2020-10-03 | Jackson | Mississippi | 28059 | 3737 | 70 |
590931 | 590931 | 2020-10-02 | Jackson | Mississippi | 28059 | 3709 | 70 |
587690 | 587690 | 2020-10-01 | Jackson | Mississippi | 28059 | 3643 | 70 |
584450 | 584450 | 2020-09-30 | Jackson | Mississippi | 28059 | 3585 | 70 |
581209 | 581209 | 2020-09-29 | Jackson | Mississippi | 28059 | 3553 | 70 |
577968 | 577968 | 2020-09-28 | Jackson | Mississippi | 28059 | 3527 | 70 |
574727 | 574727 | 2020-09-27 | Jackson | Mississippi | 28059 | 3521 | 70 |
571484 | 571484 | 2020-09-26 | Jackson | Mississippi | 28059 | 3505 | 70 |
568242 | 568242 | 2020-09-25 | Jackson | Mississippi | 28059 | 3486 | 70 |
565002 | 565002 | 2020-09-24 | Jackson | Mississippi | 28059 | 3456 | 70 |
561762 | 561762 | 2020-09-23 | Jackson | Mississippi | 28059 | 3430 | 69 |
558525 | 558525 | 2020-09-22 | Jackson | Mississippi | 28059 | 3418 | 69 |
555288 | 555288 | 2020-09-21 | Jackson | Mississippi | 28059 | 3399 | 67 |
552050 | 552050 | 2020-09-20 | Jackson | Mississippi | 28059 | 3388 | 67 |
548811 | 548811 | 2020-09-19 | Jackson | Mississippi | 28059 | 3378 | 67 |
545573 | 545573 | 2020-09-18 | Jackson | Mississippi | 28059 | 3358 | 67 |
542336 | 542336 | 2020-09-17 | Jackson | Mississippi | 28059 | 3343 | 67 |
539100 | 539100 | 2020-09-16 | Jackson | Mississippi | 28059 | 3326 | 66 |
535863 | 535863 | 2020-09-15 | Jackson | Mississippi | 28059 | 3301 | 66 |
532628 | 532628 | 2020-09-14 | Jackson | Mississippi | 28059 | 3297 | 66 |
529392 | 529392 | 2020-09-13 | Jackson | Mississippi | 28059 | 3290 | 66 |
526156 | 526156 | 2020-09-12 | Jackson | Mississippi | 28059 | 3285 | 66 |
522920 | 522920 | 2020-09-11 | Jackson | Mississippi | 28059 | 3270 | 65 |
519683 | 519683 | 2020-09-10 | Jackson | Mississippi | 28059 | 3244 | 65 |
516448 | 516448 | 2020-09-09 | Jackson | Mississippi | 28059 | 3218 | 64 |
513214 | 513214 | 2020-09-08 | Jackson | Mississippi | 28059 | 3198 | 60 |
509982 | 509982 | 2020-09-07 | Jackson | Mississippi | 28059 | 3172 | 60 |
506749 | 506749 | 2020-09-06 | Jackson | Mississippi | 28059 | 3158 | 60 |
503516 | 503516 | 2020-09-05 | Jackson | Mississippi | 28059 | 3147 | 60 |
500282 | 500282 | 2020-09-04 | Jackson | Mississippi | 28059 | 3126 | 60 |
497048 | 497048 | 2020-09-03 | Jackson | Mississippi | 28059 | 3095 | 60 |
493815 | 493815 | 2020-09-02 | Jackson | Mississippi | 28059 | 3073 | 60 |
490581 | 490581 | 2020-09-01 | Jackson | Mississippi | 28059 | 3052 | 60 |
487348 | 487348 | 2020-08-31 | Jackson | Mississippi | 28059 | 3005 | 60 |
484114 | 484114 | 2020-08-30 | Jackson | Mississippi | 28059 | 2990 | 60 |
480879 | 480879 | 2020-08-29 | Jackson | Mississippi | 28059 | 2946 | 59 |
477647 | 477647 | 2020-08-28 | Jackson | Mississippi | 28059 | 2932 | 59 |
474414 | 474414 | 2020-08-27 | Jackson | Mississippi | 28059 | 2897 | 59 |
471182 | 471182 | 2020-08-26 | Jackson | Mississippi | 28059 | 2879 | 59 |
467952 | 467952 | 2020-08-25 | Jackson | Mississippi | 28059 | 2830 | 57 |
464723 | 464723 | 2020-08-24 | Jackson | Mississippi | 28059 | 2775 | 54 |
461492 | 461492 | 2020-08-23 | Jackson | Mississippi | 28059 | 2753 | 54 |
458265 | 458265 | 2020-08-22 | Jackson | Mississippi | 28059 | 2720 | 54 |
455037 | 455037 | 2020-08-21 | Jackson | Mississippi | 28059 | 2696 | 53 |
451809 | 451809 | 2020-08-20 | Jackson | Mississippi | 28059 | 2650 | 52 |
448581 | 448581 | 2020-08-19 | Jackson | Mississippi | 28059 | 2594 | 50 |
445355 | 445355 | 2020-08-18 | Jackson | Mississippi | 28059 | 2518 | 48 |
442129 | 442129 | 2020-08-17 | Jackson | Mississippi | 28059 | 2482 | 47 |
438902 | 438902 | 2020-08-16 | Jackson | Mississippi | 28059 | 2462 | 47 |
435677 | 435677 | 2020-08-15 | Jackson | Mississippi | 28059 | 2449 | 47 |
432451 | 432451 | 2020-08-14 | Jackson | Mississippi | 28059 | 2430 | 47 |
429224 | 429224 | 2020-08-13 | Jackson | Mississippi | 28059 | 2411 | 47 |
426000 | 426000 | 2020-08-12 | Jackson | Mississippi | 28059 | 2391 | 45 |
422778 | 422778 | 2020-08-11 | Jackson | Mississippi | 28059 | 2314 | 44 |
419556 | 419556 | 2020-08-10 | Jackson | Mississippi | 28059 | 2288 | 43 |
416335 | 416335 | 2020-08-09 | Jackson | Mississippi | 28059 | 2276 | 42 |
413115 | 413115 | 2020-08-08 | Jackson | Mississippi | 28059 | 2269 | 42 |
409895 | 409895 | 2020-08-07 | Jackson | Mississippi | 28059 | 2225 | 42 |
406675 | 406675 | 2020-08-06 | Jackson | Mississippi | 28059 | 2201 | 42 |
403457 | 403457 | 2020-08-05 | Jackson | Mississippi | 28059 | 2156 | 41 |
400240 | 400240 | 2020-08-04 | Jackson | Mississippi | 28059 | 2063 | 38 |
397026 | 397026 | 2020-08-03 | Jackson | Mississippi | 28059 | 1994 | 34 |
393810 | 393810 | 2020-08-02 | Jackson | Mississippi | 28059 | 1929 | 34 |
390593 | 390593 | 2020-08-01 | Jackson | Mississippi | 28059 | 1874 | 34 |
387376 | 387376 | 2020-07-31 | Jackson | Mississippi | 28059 | 1837 | 34 |
384158 | 384158 | 2020-07-30 | Jackson | Mississippi | 28059 | 1820 | 34 |
380941 | 380941 | 2020-07-29 | Jackson | Mississippi | 28059 | 1772 | 30 |
377724 | 377724 | 2020-07-28 | Jackson | Mississippi | 28059 | 1638 | 29 |
374509 | 374509 | 2020-07-27 | Jackson | Mississippi | 28059 | 1596 | 27 |
371297 | 371297 | 2020-07-26 | Jackson | Mississippi | 28059 | 1582 | 27 |
368087 | 368087 | 2020-07-25 | Jackson | Mississippi | 28059 | 1552 | 26 |
364879 | 364879 | 2020-07-24 | Jackson | Mississippi | 28059 | 1481 | 24 |
361672 | 361672 | 2020-07-23 | Jackson | Mississippi | 28059 | 1384 | 24 |
358467 | 358467 | 2020-07-22 | Jackson | Mississippi | 28059 | 1368 | 23 |
355264 | 355264 | 2020-07-21 | Jackson | Mississippi | 28059 | 1183 | 23 |
352062 | 352062 | 2020-07-20 | Jackson | Mississippi | 28059 | 1115 | 22 |
348862 | 348862 | 2020-07-19 | Jackson | Mississippi | 28059 | 1081 | 21 |
345661 | 345661 | 2020-07-18 | Jackson | Mississippi | 28059 | 1018 | 20 |
342461 | 342461 | 2020-07-17 | Jackson | Mississippi | 28059 | 900 | 20 |
339265 | 339265 | 2020-07-16 | Jackson | Mississippi | 28059 | 874 | 20 |
336069 | 336069 | 2020-07-15 | Jackson | Mississippi | 28059 | 828 | 20 |
332876 | 332876 | 2020-07-14 | Jackson | Mississippi | 28059 | 809 | 19 |
329689 | 329689 | 2020-07-13 | Jackson | Mississippi | 28059 | 804 | 19 |
326503 | 326503 | 2020-07-12 | Jackson | Mississippi | 28059 | 798 | 19 |
323320 | 323320 | 2020-07-11 | Jackson | Mississippi | 28059 | 775 | 19 |
320141 | 320141 | 2020-07-10 | Jackson | Mississippi | 28059 | 744 | 18 |
316966 | 316966 | 2020-07-09 | Jackson | Mississippi | 28059 | 727 | 17 |
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);