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 |
---|---|---|---|---|---|---|---|
1054950 | 1054950 | 2021-02-22 | Jackson | Mississippi | 28059 | 12382 | 216 |
1051703 | 1051703 | 2021-02-21 | Jackson | Mississippi | 28059 | 12372 | 216 |
1048456 | 1048456 | 2021-02-20 | Jackson | Mississippi | 28059 | 12353 | 216 |
1045210 | 1045210 | 2021-02-19 | Jackson | Mississippi | 28059 | 12332 | 215 |
1041965 | 1041965 | 2021-02-18 | Jackson | Mississippi | 28059 | 12305 | 215 |
1038720 | 1038720 | 2021-02-17 | Jackson | Mississippi | 28059 | 12300 | 215 |
1035475 | 1035475 | 2021-02-16 | Jackson | Mississippi | 28059 | 12247 | 214 |
1032230 | 1032230 | 2021-02-15 | Jackson | Mississippi | 28059 | 12206 | 213 |
1028983 | 1028983 | 2021-02-14 | Jackson | Mississippi | 28059 | 12179 | 213 |
1025737 | 1025737 | 2021-02-13 | Jackson | Mississippi | 28059 | 12141 | 213 |
1022492 | 1022492 | 2021-02-12 | Jackson | Mississippi | 28059 | 12109 | 210 |
1019247 | 1019247 | 2021-02-11 | Jackson | Mississippi | 28059 | 12060 | 210 |
1016002 | 1016002 | 2021-02-10 | Jackson | Mississippi | 28059 | 12030 | 210 |
1012757 | 1012757 | 2021-02-09 | Jackson | Mississippi | 28059 | 11874 | 210 |
1009512 | 1009512 | 2021-02-08 | Jackson | Mississippi | 28059 | 11838 | 208 |
1006265 | 1006265 | 2021-02-07 | Jackson | Mississippi | 28059 | 11793 | 208 |
1003019 | 1003019 | 2021-02-06 | Jackson | Mississippi | 28059 | 11745 | 206 |
999774 | 999774 | 2021-02-05 | Jackson | Mississippi | 28059 | 11711 | 202 |
996528 | 996528 | 2021-02-04 | Jackson | Mississippi | 28059 | 11636 | 201 |
993282 | 993282 | 2021-02-03 | Jackson | Mississippi | 28059 | 11590 | 201 |
990036 | 990036 | 2021-02-02 | Jackson | Mississippi | 28059 | 11546 | 199 |
986789 | 986789 | 2021-02-01 | Jackson | Mississippi | 28059 | 11495 | 196 |
983542 | 983542 | 2021-01-31 | Jackson | Mississippi | 28059 | 11471 | 196 |
980296 | 980296 | 2021-01-30 | Jackson | Mississippi | 28059 | 11428 | 195 |
977050 | 977050 | 2021-01-29 | Jackson | Mississippi | 28059 | 11355 | 195 |
973805 | 973805 | 2021-01-28 | Jackson | Mississippi | 28059 | 11256 | 194 |
970560 | 970560 | 2021-01-27 | Jackson | Mississippi | 28059 | 11146 | 194 |
967315 | 967315 | 2021-01-26 | Jackson | Mississippi | 28059 | 11054 | 193 |
964071 | 964071 | 2021-01-25 | Jackson | Mississippi | 28059 | 10976 | 190 |
960826 | 960826 | 2021-01-24 | Jackson | Mississippi | 28059 | 10917 | 190 |
957580 | 957580 | 2021-01-23 | Jackson | Mississippi | 28059 | 10839 | 190 |
954335 | 954335 | 2021-01-22 | Jackson | Mississippi | 28059 | 10729 | 188 |
951090 | 951090 | 2021-01-21 | Jackson | Mississippi | 28059 | 10652 | 187 |
947844 | 947844 | 2021-01-20 | Jackson | Mississippi | 28059 | 10557 | 187 |
944597 | 944597 | 2021-01-19 | Jackson | Mississippi | 28059 | 10453 | 184 |
941352 | 941352 | 2021-01-18 | Jackson | Mississippi | 28059 | 10407 | 183 |
938107 | 938107 | 2021-01-17 | Jackson | Mississippi | 28059 | 10303 | 183 |
934862 | 934862 | 2021-01-16 | Jackson | Mississippi | 28059 | 10216 | 182 |
931617 | 931617 | 2021-01-15 | Jackson | Mississippi | 28059 | 10128 | 177 |
928372 | 928372 | 2021-01-14 | Jackson | Mississippi | 28059 | 9996 | 172 |
925126 | 925126 | 2021-01-13 | Jackson | Mississippi | 28059 | 9898 | 172 |
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 |
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);