ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Harrison" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1064680 | 1064680 | 2021-02-25 | Harrison | Mississippi | 28047 | 16512 | 276 |
1061436 | 1061436 | 2021-02-24 | Harrison | Mississippi | 28047 | 16431 | 275 |
1058190 | 1058190 | 2021-02-23 | Harrison | Mississippi | 28047 | 16385 | 273 |
1054944 | 1054944 | 2021-02-22 | Harrison | Mississippi | 28047 | 16363 | 269 |
1051697 | 1051697 | 2021-02-21 | Harrison | Mississippi | 28047 | 16347 | 269 |
1048450 | 1048450 | 2021-02-20 | Harrison | Mississippi | 28047 | 16315 | 269 |
1045204 | 1045204 | 2021-02-19 | Harrison | Mississippi | 28047 | 16291 | 267 |
1041959 | 1041959 | 2021-02-18 | Harrison | Mississippi | 28047 | 16241 | 266 |
1038714 | 1038714 | 2021-02-17 | Harrison | Mississippi | 28047 | 16232 | 266 |
1035469 | 1035469 | 2021-02-16 | Harrison | Mississippi | 28047 | 16162 | 264 |
1032224 | 1032224 | 2021-02-15 | Harrison | Mississippi | 28047 | 16117 | 258 |
1028977 | 1028977 | 2021-02-14 | Harrison | Mississippi | 28047 | 16082 | 258 |
1025731 | 1025731 | 2021-02-13 | Harrison | Mississippi | 28047 | 16024 | 258 |
1022486 | 1022486 | 2021-02-12 | Harrison | Mississippi | 28047 | 15984 | 256 |
1019241 | 1019241 | 2021-02-11 | Harrison | Mississippi | 28047 | 15904 | 256 |
1015996 | 1015996 | 2021-02-10 | Harrison | Mississippi | 28047 | 15846 | 253 |
1012751 | 1012751 | 2021-02-09 | Harrison | Mississippi | 28047 | 15783 | 251 |
1009506 | 1009506 | 2021-02-08 | Harrison | Mississippi | 28047 | 15747 | 244 |
1006259 | 1006259 | 2021-02-07 | Harrison | Mississippi | 28047 | 15702 | 244 |
1003013 | 1003013 | 2021-02-06 | Harrison | Mississippi | 28047 | 15620 | 243 |
999768 | 999768 | 2021-02-05 | Harrison | Mississippi | 28047 | 15582 | 239 |
996522 | 996522 | 2021-02-04 | Harrison | Mississippi | 28047 | 15510 | 236 |
993276 | 993276 | 2021-02-03 | Harrison | Mississippi | 28047 | 15412 | 234 |
990030 | 990030 | 2021-02-02 | Harrison | Mississippi | 28047 | 15376 | 234 |
986783 | 986783 | 2021-02-01 | Harrison | Mississippi | 28047 | 15292 | 223 |
983536 | 983536 | 2021-01-31 | Harrison | Mississippi | 28047 | 15236 | 223 |
980290 | 980290 | 2021-01-30 | Harrison | Mississippi | 28047 | 15180 | 220 |
977044 | 977044 | 2021-01-29 | Harrison | Mississippi | 28047 | 15045 | 216 |
973799 | 973799 | 2021-01-28 | Harrison | Mississippi | 28047 | 14829 | 215 |
970554 | 970554 | 2021-01-27 | Harrison | Mississippi | 28047 | 14654 | 214 |
967309 | 967309 | 2021-01-26 | Harrison | Mississippi | 28047 | 14510 | 212 |
964065 | 964065 | 2021-01-25 | Harrison | Mississippi | 28047 | 14298 | 204 |
960820 | 960820 | 2021-01-24 | Harrison | Mississippi | 28047 | 14279 | 204 |
957574 | 957574 | 2021-01-23 | Harrison | Mississippi | 28047 | 14224 | 204 |
954329 | 954329 | 2021-01-22 | Harrison | Mississippi | 28047 | 14050 | 202 |
951084 | 951084 | 2021-01-21 | Harrison | Mississippi | 28047 | 13876 | 199 |
947838 | 947838 | 2021-01-20 | Harrison | Mississippi | 28047 | 13731 | 199 |
944591 | 944591 | 2021-01-19 | Harrison | Mississippi | 28047 | 13567 | 194 |
941346 | 941346 | 2021-01-18 | Harrison | Mississippi | 28047 | 13502 | 193 |
938101 | 938101 | 2021-01-17 | Harrison | Mississippi | 28047 | 13353 | 193 |
934856 | 934856 | 2021-01-16 | Harrison | Mississippi | 28047 | 13250 | 193 |
931611 | 931611 | 2021-01-15 | Harrison | Mississippi | 28047 | 13037 | 191 |
928366 | 928366 | 2021-01-14 | Harrison | Mississippi | 28047 | 12806 | 188 |
925120 | 925120 | 2021-01-13 | Harrison | Mississippi | 28047 | 12698 | 185 |
921875 | 921875 | 2021-01-12 | Harrison | Mississippi | 28047 | 12447 | 185 |
918630 | 918630 | 2021-01-11 | Harrison | Mississippi | 28047 | 12347 | 172 |
915385 | 915385 | 2021-01-10 | Harrison | Mississippi | 28047 | 12252 | 171 |
912140 | 912140 | 2021-01-09 | Harrison | Mississippi | 28047 | 12085 | 172 |
908895 | 908895 | 2021-01-08 | Harrison | Mississippi | 28047 | 11904 | 169 |
905649 | 905649 | 2021-01-07 | Harrison | Mississippi | 28047 | 11726 | 169 |
902404 | 902404 | 2021-01-06 | Harrison | Mississippi | 28047 | 11518 | 168 |
899159 | 899159 | 2021-01-05 | Harrison | Mississippi | 28047 | 11344 | 164 |
895914 | 895914 | 2021-01-04 | Harrison | Mississippi | 28047 | 11228 | 160 |
892667 | 892667 | 2021-01-03 | Harrison | Mississippi | 28047 | 11150 | 160 |
889421 | 889421 | 2021-01-02 | Harrison | Mississippi | 28047 | 11000 | 157 |
886175 | 886175 | 2021-01-01 | Harrison | Mississippi | 28047 | 10843 | 157 |
882930 | 882930 | 2020-12-31 | Harrison | Mississippi | 28047 | 10680 | 157 |
879685 | 879685 | 2020-12-30 | Harrison | Mississippi | 28047 | 10550 | 156 |
876440 | 876440 | 2020-12-29 | Harrison | Mississippi | 28047 | 10372 | 155 |
873195 | 873195 | 2020-12-28 | Harrison | Mississippi | 28047 | 10266 | 143 |
869950 | 869950 | 2020-12-27 | Harrison | Mississippi | 28047 | 10204 | 142 |
866705 | 866705 | 2020-12-26 | Harrison | Mississippi | 28047 | 10133 | 139 |
863460 | 863460 | 2020-12-25 | Harrison | Mississippi | 28047 | 10071 | 139 |
860215 | 860215 | 2020-12-24 | Harrison | Mississippi | 28047 | 9974 | 139 |
856970 | 856970 | 2020-12-23 | Harrison | Mississippi | 28047 | 9864 | 139 |
853725 | 853725 | 2020-12-22 | Harrison | Mississippi | 28047 | 9713 | 139 |
850480 | 850480 | 2020-12-21 | Harrison | Mississippi | 28047 | 9574 | 135 |
847235 | 847235 | 2020-12-20 | Harrison | Mississippi | 28047 | 9478 | 135 |
843989 | 843989 | 2020-12-19 | Harrison | Mississippi | 28047 | 9404 | 134 |
840744 | 840744 | 2020-12-18 | Harrison | Mississippi | 28047 | 9262 | 133 |
837499 | 837499 | 2020-12-17 | Harrison | Mississippi | 28047 | 9181 | 130 |
834253 | 834253 | 2020-12-16 | Harrison | Mississippi | 28047 | 8990 | 130 |
831006 | 831006 | 2020-12-15 | Harrison | Mississippi | 28047 | 8915 | 127 |
827760 | 827760 | 2020-12-14 | Harrison | Mississippi | 28047 | 8709 | 124 |
824513 | 824513 | 2020-12-13 | Harrison | Mississippi | 28047 | 8672 | 123 |
821267 | 821267 | 2020-12-12 | Harrison | Mississippi | 28047 | 8624 | 122 |
818021 | 818021 | 2020-12-11 | Harrison | Mississippi | 28047 | 8433 | 119 |
814775 | 814775 | 2020-12-10 | Harrison | Mississippi | 28047 | 8332 | 118 |
811530 | 811530 | 2020-12-09 | Harrison | Mississippi | 28047 | 8140 | 117 |
808285 | 808285 | 2020-12-08 | Harrison | Mississippi | 28047 | 8039 | 117 |
805040 | 805040 | 2020-12-07 | Harrison | Mississippi | 28047 | 7885 | 116 |
801795 | 801795 | 2020-12-06 | Harrison | Mississippi | 28047 | 7766 | 116 |
798550 | 798550 | 2020-12-05 | Harrison | Mississippi | 28047 | 7732 | 115 |
795305 | 795305 | 2020-12-04 | Harrison | Mississippi | 28047 | 7624 | 114 |
792060 | 792060 | 2020-12-03 | Harrison | Mississippi | 28047 | 7555 | 113 |
788815 | 788815 | 2020-12-02 | Harrison | Mississippi | 28047 | 7397 | 113 |
785570 | 785570 | 2020-12-01 | Harrison | Mississippi | 28047 | 7313 | 112 |
782326 | 782326 | 2020-11-30 | Harrison | Mississippi | 28047 | 7244 | 111 |
779080 | 779080 | 2020-11-29 | Harrison | Mississippi | 28047 | 7173 | 111 |
775835 | 775835 | 2020-11-28 | Harrison | Mississippi | 28047 | 7116 | 110 |
772590 | 772590 | 2020-11-27 | Harrison | Mississippi | 28047 | 7045 | 110 |
769345 | 769345 | 2020-11-26 | Harrison | Mississippi | 28047 | 6982 | 110 |
766099 | 766099 | 2020-11-25 | Harrison | Mississippi | 28047 | 6898 | 109 |
762854 | 762854 | 2020-11-24 | Harrison | Mississippi | 28047 | 6848 | 109 |
759609 | 759609 | 2020-11-23 | Harrison | Mississippi | 28047 | 6825 | 105 |
756362 | 756362 | 2020-11-22 | Harrison | Mississippi | 28047 | 6801 | 105 |
753116 | 753116 | 2020-11-21 | Harrison | Mississippi | 28047 | 6763 | 105 |
749870 | 749870 | 2020-11-20 | Harrison | Mississippi | 28047 | 6666 | 105 |
746624 | 746624 | 2020-11-19 | Harrison | Mississippi | 28047 | 6604 | 104 |
743377 | 743377 | 2020-11-18 | Harrison | Mississippi | 28047 | 6530 | 104 |
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);