ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Jones" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
740140 | 740140 | 2020-11-17 | Jones | Mississippi | 28067 | 3276 | 86 |
736896 | 736896 | 2020-11-16 | Jones | Mississippi | 28067 | 3263 | 86 |
733650 | 733650 | 2020-11-15 | Jones | Mississippi | 28067 | 3253 | 86 |
730405 | 730405 | 2020-11-14 | Jones | Mississippi | 28067 | 3234 | 86 |
727162 | 727162 | 2020-11-13 | Jones | Mississippi | 28067 | 3207 | 85 |
723919 | 723919 | 2020-11-12 | Jones | Mississippi | 28067 | 3198 | 85 |
720676 | 720676 | 2020-11-11 | Jones | Mississippi | 28067 | 3184 | 85 |
717433 | 717433 | 2020-11-10 | Jones | Mississippi | 28067 | 3169 | 85 |
714189 | 714189 | 2020-11-09 | Jones | Mississippi | 28067 | 3145 | 84 |
710945 | 710945 | 2020-11-08 | Jones | Mississippi | 28067 | 3122 | 84 |
707701 | 707701 | 2020-11-07 | Jones | Mississippi | 28067 | 3115 | 84 |
704458 | 704458 | 2020-11-06 | Jones | Mississippi | 28067 | 3104 | 84 |
701216 | 701216 | 2020-11-05 | Jones | Mississippi | 28067 | 3082 | 84 |
697972 | 697972 | 2020-11-04 | Jones | Mississippi | 28067 | 3054 | 84 |
694729 | 694729 | 2020-11-03 | Jones | Mississippi | 28067 | 3042 | 84 |
691487 | 691487 | 2020-11-02 | Jones | Mississippi | 28067 | 3032 | 84 |
688242 | 688242 | 2020-11-01 | Jones | Mississippi | 28067 | 3022 | 84 |
684998 | 684998 | 2020-10-31 | Jones | Mississippi | 28067 | 3015 | 84 |
681755 | 681755 | 2020-10-30 | Jones | Mississippi | 28067 | 2999 | 84 |
678511 | 678511 | 2020-10-29 | Jones | Mississippi | 28067 | 2984 | 84 |
675269 | 675269 | 2020-10-28 | Jones | Mississippi | 28067 | 2966 | 84 |
672026 | 672026 | 2020-10-27 | Jones | Mississippi | 28067 | 2961 | 84 |
668784 | 668784 | 2020-10-26 | Jones | Mississippi | 28067 | 2957 | 84 |
665540 | 665540 | 2020-10-25 | Jones | Mississippi | 28067 | 2924 | 84 |
662295 | 662295 | 2020-10-24 | Jones | Mississippi | 28067 | 2924 | 84 |
659051 | 659051 | 2020-10-23 | Jones | Mississippi | 28067 | 2891 | 84 |
655806 | 655806 | 2020-10-22 | Jones | Mississippi | 28067 | 2877 | 84 |
652561 | 652561 | 2020-10-21 | Jones | Mississippi | 28067 | 2853 | 84 |
649316 | 649316 | 2020-10-20 | Jones | Mississippi | 28067 | 2837 | 82 |
646072 | 646072 | 2020-10-19 | Jones | Mississippi | 28067 | 2831 | 82 |
642825 | 642825 | 2020-10-18 | Jones | Mississippi | 28067 | 2816 | 82 |
639578 | 639578 | 2020-10-17 | Jones | Mississippi | 28067 | 2816 | 82 |
636332 | 636332 | 2020-10-16 | Jones | Mississippi | 28067 | 2799 | 81 |
633086 | 633086 | 2020-10-15 | Jones | Mississippi | 28067 | 2779 | 81 |
629841 | 629841 | 2020-10-14 | Jones | Mississippi | 28067 | 2739 | 81 |
626597 | 626597 | 2020-10-13 | Jones | Mississippi | 28067 | 2720 | 81 |
623355 | 623355 | 2020-10-12 | Jones | Mississippi | 28067 | 2708 | 81 |
620112 | 620112 | 2020-10-11 | Jones | Mississippi | 28067 | 2695 | 81 |
616870 | 616870 | 2020-10-10 | Jones | Mississippi | 28067 | 2679 | 81 |
613629 | 613629 | 2020-10-09 | Jones | Mississippi | 28067 | 2656 | 81 |
610387 | 610387 | 2020-10-08 | Jones | Mississippi | 28067 | 2636 | 81 |
607145 | 607145 | 2020-10-07 | Jones | Mississippi | 28067 | 2626 | 81 |
603902 | 603902 | 2020-10-06 | Jones | Mississippi | 28067 | 2609 | 81 |
600660 | 600660 | 2020-10-05 | Jones | Mississippi | 28067 | 2597 | 81 |
597417 | 597417 | 2020-10-04 | Jones | Mississippi | 28067 | 2583 | 81 |
594176 | 594176 | 2020-10-03 | Jones | Mississippi | 28067 | 2570 | 81 |
590935 | 590935 | 2020-10-02 | Jones | Mississippi | 28067 | 2560 | 81 |
587694 | 587694 | 2020-10-01 | Jones | Mississippi | 28067 | 2546 | 81 |
584454 | 584454 | 2020-09-30 | Jones | Mississippi | 28067 | 2527 | 80 |
581213 | 581213 | 2020-09-29 | Jones | Mississippi | 28067 | 2515 | 80 |
577972 | 577972 | 2020-09-28 | Jones | Mississippi | 28067 | 2504 | 79 |
574731 | 574731 | 2020-09-27 | Jones | Mississippi | 28067 | 2498 | 79 |
571488 | 571488 | 2020-09-26 | Jones | Mississippi | 28067 | 2487 | 79 |
568246 | 568246 | 2020-09-25 | Jones | Mississippi | 28067 | 2475 | 79 |
565006 | 565006 | 2020-09-24 | Jones | Mississippi | 28067 | 2468 | 79 |
561766 | 561766 | 2020-09-23 | Jones | Mississippi | 28067 | 2452 | 79 |
558529 | 558529 | 2020-09-22 | Jones | Mississippi | 28067 | 2438 | 78 |
555292 | 555292 | 2020-09-21 | Jones | Mississippi | 28067 | 2427 | 78 |
552054 | 552054 | 2020-09-20 | Jones | Mississippi | 28067 | 2420 | 78 |
548815 | 548815 | 2020-09-19 | Jones | Mississippi | 28067 | 2399 | 78 |
545577 | 545577 | 2020-09-18 | Jones | Mississippi | 28067 | 2376 | 78 |
542340 | 542340 | 2020-09-17 | Jones | Mississippi | 28067 | 2360 | 78 |
539104 | 539104 | 2020-09-16 | Jones | Mississippi | 28067 | 2340 | 77 |
535867 | 535867 | 2020-09-15 | Jones | Mississippi | 28067 | 2315 | 77 |
532632 | 532632 | 2020-09-14 | Jones | Mississippi | 28067 | 2298 | 76 |
529396 | 529396 | 2020-09-13 | Jones | Mississippi | 28067 | 2293 | 76 |
526160 | 526160 | 2020-09-12 | Jones | Mississippi | 28067 | 2288 | 76 |
522924 | 522924 | 2020-09-11 | Jones | Mississippi | 28067 | 2276 | 76 |
519687 | 519687 | 2020-09-10 | Jones | Mississippi | 28067 | 2253 | 76 |
516452 | 516452 | 2020-09-09 | Jones | Mississippi | 28067 | 2246 | 76 |
513218 | 513218 | 2020-09-08 | Jones | Mississippi | 28067 | 2239 | 75 |
509986 | 509986 | 2020-09-07 | Jones | Mississippi | 28067 | 2234 | 75 |
506753 | 506753 | 2020-09-06 | Jones | Mississippi | 28067 | 2222 | 75 |
503520 | 503520 | 2020-09-05 | Jones | Mississippi | 28067 | 2218 | 75 |
500286 | 500286 | 2020-09-04 | Jones | Mississippi | 28067 | 2212 | 75 |
497052 | 497052 | 2020-09-03 | Jones | Mississippi | 28067 | 2191 | 74 |
493819 | 493819 | 2020-09-02 | Jones | Mississippi | 28067 | 2178 | 74 |
490585 | 490585 | 2020-09-01 | Jones | Mississippi | 28067 | 2169 | 73 |
487352 | 487352 | 2020-08-31 | Jones | Mississippi | 28067 | 2159 | 72 |
484118 | 484118 | 2020-08-30 | Jones | Mississippi | 28067 | 2153 | 72 |
480883 | 480883 | 2020-08-29 | Jones | Mississippi | 28067 | 2146 | 72 |
477651 | 477651 | 2020-08-28 | Jones | Mississippi | 28067 | 2127 | 72 |
474418 | 474418 | 2020-08-27 | Jones | Mississippi | 28067 | 2111 | 71 |
471186 | 471186 | 2020-08-26 | Jones | Mississippi | 28067 | 2114 | 69 |
467956 | 467956 | 2020-08-25 | Jones | Mississippi | 28067 | 2087 | 69 |
464727 | 464727 | 2020-08-24 | Jones | Mississippi | 28067 | 2080 | 69 |
461496 | 461496 | 2020-08-23 | Jones | Mississippi | 28067 | 2073 | 69 |
458269 | 458269 | 2020-08-22 | Jones | Mississippi | 28067 | 2057 | 69 |
455041 | 455041 | 2020-08-21 | Jones | Mississippi | 28067 | 2041 | 68 |
451813 | 451813 | 2020-08-20 | Jones | Mississippi | 28067 | 2033 | 67 |
448585 | 448585 | 2020-08-19 | Jones | Mississippi | 28067 | 2020 | 66 |
445359 | 445359 | 2020-08-18 | Jones | Mississippi | 28067 | 2007 | 66 |
442133 | 442133 | 2020-08-17 | Jones | Mississippi | 28067 | 2002 | 65 |
438906 | 438906 | 2020-08-16 | Jones | Mississippi | 28067 | 1987 | 65 |
435681 | 435681 | 2020-08-15 | Jones | Mississippi | 28067 | 1978 | 64 |
432455 | 432455 | 2020-08-14 | Jones | Mississippi | 28067 | 1965 | 62 |
429228 | 429228 | 2020-08-13 | Jones | Mississippi | 28067 | 1945 | 62 |
426004 | 426004 | 2020-08-12 | Jones | Mississippi | 28067 | 1947 | 62 |
422782 | 422782 | 2020-08-11 | Jones | Mississippi | 28067 | 1931 | 59 |
419560 | 419560 | 2020-08-10 | Jones | Mississippi | 28067 | 1916 | 59 |
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);