ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Washington" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921927 | 921927 | 2021-01-12 | Washington | Mississippi | 28151 | 4665 | 121 |
918682 | 918682 | 2021-01-11 | Washington | Mississippi | 28151 | 4649 | 119 |
915437 | 915437 | 2021-01-10 | Washington | Mississippi | 28151 | 4639 | 119 |
912192 | 912192 | 2021-01-09 | Washington | Mississippi | 28151 | 4621 | 119 |
908947 | 908947 | 2021-01-08 | Washington | Mississippi | 28151 | 4587 | 119 |
905701 | 905701 | 2021-01-07 | Washington | Mississippi | 28151 | 4578 | 119 |
902456 | 902456 | 2021-01-06 | Washington | Mississippi | 28151 | 4526 | 119 |
899211 | 899211 | 2021-01-05 | Washington | Mississippi | 28151 | 4504 | 119 |
895966 | 895966 | 2021-01-04 | Washington | Mississippi | 28151 | 4487 | 117 |
892719 | 892719 | 2021-01-03 | Washington | Mississippi | 28151 | 4459 | 117 |
889473 | 889473 | 2021-01-02 | Washington | Mississippi | 28151 | 4375 | 116 |
886227 | 886227 | 2021-01-01 | Washington | Mississippi | 28151 | 4322 | 116 |
882982 | 882982 | 2020-12-31 | Washington | Mississippi | 28151 | 4259 | 116 |
879737 | 879737 | 2020-12-30 | Washington | Mississippi | 28151 | 4231 | 116 |
876492 | 876492 | 2020-12-29 | Washington | Mississippi | 28151 | 4196 | 116 |
873247 | 873247 | 2020-12-28 | Washington | Mississippi | 28151 | 4171 | 114 |
870002 | 870002 | 2020-12-27 | Washington | Mississippi | 28151 | 4110 | 114 |
866757 | 866757 | 2020-12-26 | Washington | Mississippi | 28151 | 4075 | 112 |
863512 | 863512 | 2020-12-25 | Washington | Mississippi | 28151 | 4064 | 112 |
860267 | 860267 | 2020-12-24 | Washington | Mississippi | 28151 | 3971 | 112 |
857022 | 857022 | 2020-12-23 | Washington | Mississippi | 28151 | 3929 | 112 |
853777 | 853777 | 2020-12-22 | Washington | Mississippi | 28151 | 3897 | 112 |
850532 | 850532 | 2020-12-21 | Washington | Mississippi | 28151 | 3860 | 111 |
847287 | 847287 | 2020-12-20 | Washington | Mississippi | 28151 | 3839 | 111 |
844041 | 844041 | 2020-12-19 | Washington | Mississippi | 28151 | 3815 | 111 |
840796 | 840796 | 2020-12-18 | Washington | Mississippi | 28151 | 3778 | 111 |
837551 | 837551 | 2020-12-17 | Washington | Mississippi | 28151 | 3754 | 110 |
834305 | 834305 | 2020-12-16 | Washington | Mississippi | 28151 | 3738 | 110 |
831058 | 831058 | 2020-12-15 | Washington | Mississippi | 28151 | 3697 | 109 |
827812 | 827812 | 2020-12-14 | Washington | Mississippi | 28151 | 3660 | 109 |
824565 | 824565 | 2020-12-13 | Washington | Mississippi | 28151 | 3645 | 109 |
821319 | 821319 | 2020-12-12 | Washington | Mississippi | 28151 | 3632 | 108 |
818073 | 818073 | 2020-12-11 | Washington | Mississippi | 28151 | 3592 | 108 |
814827 | 814827 | 2020-12-10 | Washington | Mississippi | 28151 | 3564 | 108 |
811582 | 811582 | 2020-12-09 | Washington | Mississippi | 28151 | 3523 | 108 |
808337 | 808337 | 2020-12-08 | Washington | Mississippi | 28151 | 3486 | 108 |
805092 | 805092 | 2020-12-07 | Washington | Mississippi | 28151 | 3459 | 108 |
801847 | 801847 | 2020-12-06 | Washington | Mississippi | 28151 | 3453 | 108 |
798602 | 798602 | 2020-12-05 | Washington | Mississippi | 28151 | 3442 | 108 |
795357 | 795357 | 2020-12-04 | Washington | Mississippi | 28151 | 3421 | 108 |
792112 | 792112 | 2020-12-03 | Washington | Mississippi | 28151 | 3367 | 108 |
788867 | 788867 | 2020-12-02 | Washington | Mississippi | 28151 | 3321 | 108 |
785622 | 785622 | 2020-12-01 | Washington | Mississippi | 28151 | 3246 | 108 |
782378 | 782378 | 2020-11-30 | Washington | Mississippi | 28151 | 3241 | 108 |
779132 | 779132 | 2020-11-29 | Washington | Mississippi | 28151 | 3197 | 108 |
775887 | 775887 | 2020-11-28 | Washington | Mississippi | 28151 | 3179 | 107 |
772642 | 772642 | 2020-11-27 | Washington | Mississippi | 28151 | 3161 | 107 |
769397 | 769397 | 2020-11-26 | Washington | Mississippi | 28151 | 3153 | 107 |
766151 | 766151 | 2020-11-25 | Washington | Mississippi | 28151 | 3122 | 107 |
762906 | 762906 | 2020-11-24 | Washington | Mississippi | 28151 | 3097 | 107 |
759661 | 759661 | 2020-11-23 | Washington | Mississippi | 28151 | 3088 | 106 |
756414 | 756414 | 2020-11-22 | Washington | Mississippi | 28151 | 3043 | 106 |
753168 | 753168 | 2020-11-21 | Washington | Mississippi | 28151 | 3034 | 106 |
749922 | 749922 | 2020-11-20 | Washington | Mississippi | 28151 | 3002 | 106 |
746676 | 746676 | 2020-11-19 | Washington | Mississippi | 28151 | 2981 | 106 |
743429 | 743429 | 2020-11-18 | Washington | Mississippi | 28151 | 2948 | 107 |
740182 | 740182 | 2020-11-17 | Washington | Mississippi | 28151 | 2908 | 105 |
736938 | 736938 | 2020-11-16 | Washington | Mississippi | 28151 | 2901 | 105 |
733692 | 733692 | 2020-11-15 | Washington | Mississippi | 28151 | 2889 | 105 |
730447 | 730447 | 2020-11-14 | Washington | Mississippi | 28151 | 2873 | 105 |
727204 | 727204 | 2020-11-13 | Washington | Mississippi | 28151 | 2860 | 105 |
723961 | 723961 | 2020-11-12 | Washington | Mississippi | 28151 | 2843 | 105 |
720718 | 720718 | 2020-11-11 | Washington | Mississippi | 28151 | 2823 | 105 |
717475 | 717475 | 2020-11-10 | Washington | Mississippi | 28151 | 2787 | 105 |
714231 | 714231 | 2020-11-09 | Washington | Mississippi | 28151 | 2777 | 105 |
710987 | 710987 | 2020-11-08 | Washington | Mississippi | 28151 | 2774 | 105 |
707743 | 707743 | 2020-11-07 | Washington | Mississippi | 28151 | 2766 | 105 |
704500 | 704500 | 2020-11-06 | Washington | Mississippi | 28151 | 2760 | 105 |
701258 | 701258 | 2020-11-05 | Washington | Mississippi | 28151 | 2751 | 104 |
698014 | 698014 | 2020-11-04 | Washington | Mississippi | 28151 | 2710 | 102 |
694771 | 694771 | 2020-11-03 | Washington | Mississippi | 28151 | 2694 | 100 |
691529 | 691529 | 2020-11-02 | Washington | Mississippi | 28151 | 2691 | 100 |
688284 | 688284 | 2020-11-01 | Washington | Mississippi | 28151 | 2689 | 100 |
685040 | 685040 | 2020-10-31 | Washington | Mississippi | 28151 | 2688 | 100 |
681797 | 681797 | 2020-10-30 | Washington | Mississippi | 28151 | 2667 | 100 |
678553 | 678553 | 2020-10-29 | Washington | Mississippi | 28151 | 2644 | 100 |
675311 | 675311 | 2020-10-28 | Washington | Mississippi | 28151 | 2627 | 100 |
672068 | 672068 | 2020-10-27 | Washington | Mississippi | 28151 | 2603 | 99 |
668826 | 668826 | 2020-10-26 | Washington | Mississippi | 28151 | 2592 | 99 |
665582 | 665582 | 2020-10-25 | Washington | Mississippi | 28151 | 2583 | 99 |
662337 | 662337 | 2020-10-24 | Washington | Mississippi | 28151 | 2583 | 99 |
659093 | 659093 | 2020-10-23 | Washington | Mississippi | 28151 | 2564 | 99 |
655848 | 655848 | 2020-10-22 | Washington | Mississippi | 28151 | 2551 | 99 |
652603 | 652603 | 2020-10-21 | Washington | Mississippi | 28151 | 2537 | 99 |
649358 | 649358 | 2020-10-20 | Washington | Mississippi | 28151 | 2521 | 97 |
646114 | 646114 | 2020-10-19 | Washington | Mississippi | 28151 | 2514 | 97 |
642868 | 642868 | 2020-10-18 | Washington | Mississippi | 28151 | 2506 | 97 |
639620 | 639620 | 2020-10-17 | Washington | Mississippi | 28151 | 2506 | 97 |
636374 | 636374 | 2020-10-16 | Washington | Mississippi | 28151 | 2493 | 95 |
633128 | 633128 | 2020-10-15 | Washington | Mississippi | 28151 | 2477 | 95 |
629883 | 629883 | 2020-10-14 | Washington | Mississippi | 28151 | 2456 | 93 |
626639 | 626639 | 2020-10-13 | Washington | Mississippi | 28151 | 2422 | 91 |
623397 | 623397 | 2020-10-12 | Washington | Mississippi | 28151 | 2402 | 88 |
620154 | 620154 | 2020-10-11 | Washington | Mississippi | 28151 | 2400 | 88 |
616912 | 616912 | 2020-10-10 | Washington | Mississippi | 28151 | 2389 | 88 |
613671 | 613671 | 2020-10-09 | Washington | Mississippi | 28151 | 2366 | 86 |
610429 | 610429 | 2020-10-08 | Washington | Mississippi | 28151 | 2360 | 86 |
607187 | 607187 | 2020-10-07 | Washington | Mississippi | 28151 | 2351 | 86 |
603944 | 603944 | 2020-10-06 | Washington | Mississippi | 28151 | 2338 | 84 |
600702 | 600702 | 2020-10-05 | Washington | Mississippi | 28151 | 2319 | 84 |
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);