ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Jackson" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921881 | 921881 | 2021-01-12 | Jackson | Mississippi | 28059 | 9800 | 171 |
918636 | 918636 | 2021-01-11 | Jackson | Mississippi | 28059 | 9717 | 167 |
915391 | 915391 | 2021-01-10 | Jackson | Mississippi | 28059 | 9625 | 167 |
912146 | 912146 | 2021-01-09 | Jackson | Mississippi | 28059 | 9522 | 166 |
908901 | 908901 | 2021-01-08 | Jackson | Mississippi | 28059 | 9423 | 166 |
905655 | 905655 | 2021-01-07 | Jackson | Mississippi | 28059 | 9364 | 164 |
902410 | 902410 | 2021-01-06 | Jackson | Mississippi | 28059 | 9189 | 164 |
899165 | 899165 | 2021-01-05 | Jackson | Mississippi | 28059 | 9057 | 164 |
895920 | 895920 | 2021-01-04 | Jackson | Mississippi | 28059 | 8988 | 159 |
892673 | 892673 | 2021-01-03 | Jackson | Mississippi | 28059 | 8928 | 159 |
889427 | 889427 | 2021-01-02 | Jackson | Mississippi | 28059 | 8869 | 159 |
886181 | 886181 | 2021-01-01 | Jackson | Mississippi | 28059 | 8820 | 159 |
882936 | 882936 | 2020-12-31 | Jackson | Mississippi | 28059 | 8771 | 158 |
879691 | 879691 | 2020-12-30 | Jackson | Mississippi | 28059 | 8717 | 156 |
876446 | 876446 | 2020-12-29 | Jackson | Mississippi | 28059 | 8600 | 156 |
873201 | 873201 | 2020-12-28 | Jackson | Mississippi | 28059 | 8476 | 153 |
869956 | 869956 | 2020-12-27 | Jackson | Mississippi | 28059 | 8419 | 151 |
866711 | 866711 | 2020-12-26 | Jackson | Mississippi | 28059 | 8367 | 151 |
863466 | 863466 | 2020-12-25 | Jackson | Mississippi | 28059 | 8342 | 151 |
860221 | 860221 | 2020-12-24 | Jackson | Mississippi | 28059 | 8290 | 151 |
856976 | 856976 | 2020-12-23 | Jackson | Mississippi | 28059 | 8219 | 151 |
853731 | 853731 | 2020-12-22 | Jackson | Mississippi | 28059 | 8126 | 151 |
850486 | 850486 | 2020-12-21 | Jackson | Mississippi | 28059 | 7998 | 147 |
847241 | 847241 | 2020-12-20 | Jackson | Mississippi | 28059 | 7946 | 147 |
843995 | 843995 | 2020-12-19 | Jackson | Mississippi | 28059 | 7843 | 147 |
840750 | 840750 | 2020-12-18 | Jackson | Mississippi | 28059 | 7779 | 145 |
837505 | 837505 | 2020-12-17 | Jackson | Mississippi | 28059 | 7711 | 145 |
834259 | 834259 | 2020-12-16 | Jackson | Mississippi | 28059 | 7624 | 144 |
831012 | 831012 | 2020-12-15 | Jackson | Mississippi | 28059 | 7565 | 142 |
827766 | 827766 | 2020-12-14 | Jackson | Mississippi | 28059 | 7459 | 142 |
824519 | 824519 | 2020-12-13 | Jackson | Mississippi | 28059 | 7426 | 142 |
821273 | 821273 | 2020-12-12 | Jackson | Mississippi | 28059 | 7357 | 142 |
818027 | 818027 | 2020-12-11 | Jackson | Mississippi | 28059 | 7274 | 139 |
814781 | 814781 | 2020-12-10 | Jackson | Mississippi | 28059 | 7196 | 137 |
811536 | 811536 | 2020-12-09 | Jackson | Mississippi | 28059 | 7123 | 137 |
808291 | 808291 | 2020-12-08 | Jackson | Mississippi | 28059 | 6976 | 137 |
805046 | 805046 | 2020-12-07 | Jackson | Mississippi | 28059 | 6898 | 131 |
801801 | 801801 | 2020-12-06 | Jackson | Mississippi | 28059 | 6845 | 131 |
798556 | 798556 | 2020-12-05 | Jackson | Mississippi | 28059 | 6808 | 131 |
795311 | 795311 | 2020-12-04 | Jackson | Mississippi | 28059 | 6774 | 131 |
792066 | 792066 | 2020-12-03 | Jackson | Mississippi | 28059 | 6708 | 128 |
788821 | 788821 | 2020-12-02 | Jackson | Mississippi | 28059 | 6655 | 128 |
785576 | 785576 | 2020-12-01 | Jackson | Mississippi | 28059 | 6566 | 128 |
782332 | 782332 | 2020-11-30 | Jackson | Mississippi | 28059 | 6521 | 124 |
779086 | 779086 | 2020-11-29 | Jackson | Mississippi | 28059 | 6440 | 124 |
775841 | 775841 | 2020-11-28 | Jackson | Mississippi | 28059 | 6360 | 119 |
772596 | 772596 | 2020-11-27 | Jackson | Mississippi | 28059 | 6270 | 119 |
769351 | 769351 | 2020-11-26 | Jackson | Mississippi | 28059 | 6218 | 119 |
766105 | 766105 | 2020-11-25 | Jackson | Mississippi | 28059 | 6178 | 119 |
762860 | 762860 | 2020-11-24 | Jackson | Mississippi | 28059 | 6124 | 118 |
759615 | 759615 | 2020-11-23 | Jackson | Mississippi | 28059 | 6068 | 116 |
756368 | 756368 | 2020-11-22 | Jackson | Mississippi | 28059 | 6043 | 116 |
753122 | 753122 | 2020-11-21 | Jackson | Mississippi | 28059 | 6019 | 116 |
749876 | 749876 | 2020-11-20 | Jackson | Mississippi | 28059 | 5947 | 113 |
746630 | 746630 | 2020-11-19 | Jackson | Mississippi | 28059 | 5892 | 112 |
743383 | 743383 | 2020-11-18 | Jackson | Mississippi | 28059 | 5830 | 111 |
740136 | 740136 | 2020-11-17 | Jackson | Mississippi | 28059 | 5786 | 111 |
736892 | 736892 | 2020-11-16 | Jackson | Mississippi | 28059 | 5763 | 105 |
733646 | 733646 | 2020-11-15 | Jackson | Mississippi | 28059 | 5746 | 105 |
730401 | 730401 | 2020-11-14 | Jackson | Mississippi | 28059 | 5713 | 105 |
727158 | 727158 | 2020-11-13 | Jackson | Mississippi | 28059 | 5640 | 105 |
723915 | 723915 | 2020-11-12 | Jackson | Mississippi | 28059 | 5567 | 103 |
720672 | 720672 | 2020-11-11 | Jackson | Mississippi | 28059 | 5528 | 103 |
717429 | 717429 | 2020-11-10 | Jackson | Mississippi | 28059 | 5481 | 103 |
714185 | 714185 | 2020-11-09 | Jackson | Mississippi | 28059 | 5437 | 102 |
710941 | 710941 | 2020-11-08 | Jackson | Mississippi | 28059 | 5390 | 102 |
707697 | 707697 | 2020-11-07 | Jackson | Mississippi | 28059 | 5316 | 102 |
704454 | 704454 | 2020-11-06 | Jackson | Mississippi | 28059 | 5248 | 101 |
701212 | 701212 | 2020-11-05 | Jackson | Mississippi | 28059 | 5184 | 100 |
697968 | 697968 | 2020-11-04 | Jackson | Mississippi | 28059 | 5077 | 100 |
694725 | 694725 | 2020-11-03 | Jackson | Mississippi | 28059 | 5024 | 99 |
691483 | 691483 | 2020-11-02 | Jackson | Mississippi | 28059 | 4978 | 91 |
688238 | 688238 | 2020-11-01 | Jackson | Mississippi | 28059 | 4952 | 91 |
684994 | 684994 | 2020-10-31 | Jackson | Mississippi | 28059 | 4940 | 91 |
681751 | 681751 | 2020-10-30 | Jackson | Mississippi | 28059 | 4917 | 90 |
678507 | 678507 | 2020-10-29 | Jackson | Mississippi | 28059 | 4884 | 88 |
675265 | 675265 | 2020-10-28 | Jackson | Mississippi | 28059 | 4800 | 88 |
672022 | 672022 | 2020-10-27 | Jackson | Mississippi | 28059 | 4693 | 87 |
668780 | 668780 | 2020-10-26 | Jackson | Mississippi | 28059 | 4622 | 85 |
665536 | 665536 | 2020-10-25 | Jackson | Mississippi | 28059 | 4578 | 84 |
662291 | 662291 | 2020-10-24 | Jackson | Mississippi | 28059 | 4578 | 84 |
659047 | 659047 | 2020-10-23 | Jackson | Mississippi | 28059 | 4503 | 84 |
655802 | 655802 | 2020-10-22 | Jackson | Mississippi | 28059 | 4450 | 84 |
652557 | 652557 | 2020-10-21 | Jackson | Mississippi | 28059 | 4393 | 83 |
649312 | 649312 | 2020-10-20 | Jackson | Mississippi | 28059 | 4350 | 81 |
646068 | 646068 | 2020-10-19 | Jackson | Mississippi | 28059 | 4319 | 78 |
642821 | 642821 | 2020-10-18 | Jackson | Mississippi | 28059 | 4291 | 78 |
639574 | 639574 | 2020-10-17 | Jackson | Mississippi | 28059 | 4291 | 78 |
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 |
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);