ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 28045 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054943 | 1054943 | 2021-02-22 | Hancock | Mississippi | 28045 | 3371 | 73 |
1051696 | 1051696 | 2021-02-21 | Hancock | Mississippi | 28045 | 3366 | 73 |
1048449 | 1048449 | 2021-02-20 | Hancock | Mississippi | 28045 | 3363 | 73 |
1045203 | 1045203 | 2021-02-19 | Hancock | Mississippi | 28045 | 3355 | 73 |
1041958 | 1041958 | 2021-02-18 | Hancock | Mississippi | 28045 | 3355 | 73 |
1038713 | 1038713 | 2021-02-17 | Hancock | Mississippi | 28045 | 3354 | 73 |
1035468 | 1035468 | 2021-02-16 | Hancock | Mississippi | 28045 | 3334 | 72 |
1032223 | 1032223 | 2021-02-15 | Hancock | Mississippi | 28045 | 3320 | 72 |
1028976 | 1028976 | 2021-02-14 | Hancock | Mississippi | 28045 | 3315 | 72 |
1025730 | 1025730 | 2021-02-13 | Hancock | Mississippi | 28045 | 3300 | 72 |
1022485 | 1022485 | 2021-02-12 | Hancock | Mississippi | 28045 | 3294 | 72 |
1019240 | 1019240 | 2021-02-11 | Hancock | Mississippi | 28045 | 3270 | 71 |
1015995 | 1015995 | 2021-02-10 | Hancock | Mississippi | 28045 | 3259 | 71 |
1012750 | 1012750 | 2021-02-09 | Hancock | Mississippi | 28045 | 3248 | 71 |
1009505 | 1009505 | 2021-02-08 | Hancock | Mississippi | 28045 | 3237 | 70 |
1006258 | 1006258 | 2021-02-07 | Hancock | Mississippi | 28045 | 3225 | 70 |
1003012 | 1003012 | 2021-02-06 | Hancock | Mississippi | 28045 | 3214 | 70 |
999767 | 999767 | 2021-02-05 | Hancock | Mississippi | 28045 | 3208 | 70 |
996521 | 996521 | 2021-02-04 | Hancock | Mississippi | 28045 | 3194 | 70 |
993275 | 993275 | 2021-02-03 | Hancock | Mississippi | 28045 | 3179 | 67 |
990029 | 990029 | 2021-02-02 | Hancock | Mississippi | 28045 | 3174 | 67 |
986782 | 986782 | 2021-02-01 | Hancock | Mississippi | 28045 | 3162 | 66 |
983535 | 983535 | 2021-01-31 | Hancock | Mississippi | 28045 | 3154 | 66 |
980289 | 980289 | 2021-01-30 | Hancock | Mississippi | 28045 | 3128 | 66 |
977043 | 977043 | 2021-01-29 | Hancock | Mississippi | 28045 | 3107 | 65 |
973798 | 973798 | 2021-01-28 | Hancock | Mississippi | 28045 | 3072 | 63 |
970553 | 970553 | 2021-01-27 | Hancock | Mississippi | 28045 | 3042 | 63 |
967308 | 967308 | 2021-01-26 | Hancock | Mississippi | 28045 | 3009 | 63 |
964064 | 964064 | 2021-01-25 | Hancock | Mississippi | 28045 | 2963 | 62 |
960819 | 960819 | 2021-01-24 | Hancock | Mississippi | 28045 | 2942 | 62 |
957573 | 957573 | 2021-01-23 | Hancock | Mississippi | 28045 | 2918 | 62 |
954328 | 954328 | 2021-01-22 | Hancock | Mississippi | 28045 | 2884 | 61 |
951083 | 951083 | 2021-01-21 | Hancock | Mississippi | 28045 | 2853 | 60 |
947837 | 947837 | 2021-01-20 | Hancock | Mississippi | 28045 | 2825 | 59 |
944590 | 944590 | 2021-01-19 | Hancock | Mississippi | 28045 | 2744 | 59 |
941345 | 941345 | 2021-01-18 | Hancock | Mississippi | 28045 | 2734 | 59 |
938100 | 938100 | 2021-01-17 | Hancock | Mississippi | 28045 | 2665 | 59 |
934855 | 934855 | 2021-01-16 | Hancock | Mississippi | 28045 | 2604 | 58 |
931610 | 931610 | 2021-01-15 | Hancock | Mississippi | 28045 | 2535 | 57 |
928365 | 928365 | 2021-01-14 | Hancock | Mississippi | 28045 | 2469 | 57 |
925119 | 925119 | 2021-01-13 | Hancock | Mississippi | 28045 | 2433 | 57 |
921874 | 921874 | 2021-01-12 | Hancock | Mississippi | 28045 | 2383 | 57 |
918629 | 918629 | 2021-01-11 | Hancock | Mississippi | 28045 | 2370 | 56 |
915384 | 915384 | 2021-01-10 | Hancock | Mississippi | 28045 | 2357 | 56 |
912139 | 912139 | 2021-01-09 | Hancock | Mississippi | 28045 | 2320 | 56 |
908894 | 908894 | 2021-01-08 | Hancock | Mississippi | 28045 | 2290 | 57 |
905648 | 905648 | 2021-01-07 | Hancock | Mississippi | 28045 | 2252 | 56 |
902403 | 902403 | 2021-01-06 | Hancock | Mississippi | 28045 | 2204 | 56 |
899158 | 899158 | 2021-01-05 | Hancock | Mississippi | 28045 | 2167 | 56 |
895913 | 895913 | 2021-01-04 | Hancock | Mississippi | 28045 | 2138 | 55 |
892666 | 892666 | 2021-01-03 | Hancock | Mississippi | 28045 | 2108 | 55 |
889420 | 889420 | 2021-01-02 | Hancock | Mississippi | 28045 | 2094 | 55 |
886174 | 886174 | 2021-01-01 | Hancock | Mississippi | 28045 | 2074 | 55 |
882929 | 882929 | 2020-12-31 | Hancock | Mississippi | 28045 | 2033 | 55 |
879684 | 879684 | 2020-12-30 | Hancock | Mississippi | 28045 | 1981 | 54 |
876439 | 876439 | 2020-12-29 | Hancock | Mississippi | 28045 | 1929 | 54 |
873194 | 873194 | 2020-12-28 | Hancock | Mississippi | 28045 | 1912 | 53 |
869949 | 869949 | 2020-12-27 | Hancock | Mississippi | 28045 | 1899 | 53 |
866704 | 866704 | 2020-12-26 | Hancock | Mississippi | 28045 | 1882 | 53 |
863459 | 863459 | 2020-12-25 | Hancock | Mississippi | 28045 | 1871 | 53 |
860214 | 860214 | 2020-12-24 | Hancock | Mississippi | 28045 | 1832 | 53 |
856969 | 856969 | 2020-12-23 | Hancock | Mississippi | 28045 | 1797 | 53 |
853724 | 853724 | 2020-12-22 | Hancock | Mississippi | 28045 | 1726 | 51 |
850479 | 850479 | 2020-12-21 | Hancock | Mississippi | 28045 | 1708 | 50 |
847234 | 847234 | 2020-12-20 | Hancock | Mississippi | 28045 | 1687 | 50 |
843988 | 843988 | 2020-12-19 | Hancock | Mississippi | 28045 | 1667 | 50 |
840743 | 840743 | 2020-12-18 | Hancock | Mississippi | 28045 | 1644 | 49 |
837498 | 837498 | 2020-12-17 | Hancock | Mississippi | 28045 | 1624 | 49 |
834252 | 834252 | 2020-12-16 | Hancock | Mississippi | 28045 | 1564 | 49 |
831005 | 831005 | 2020-12-15 | Hancock | Mississippi | 28045 | 1539 | 46 |
827759 | 827759 | 2020-12-14 | Hancock | Mississippi | 28045 | 1508 | 46 |
824512 | 824512 | 2020-12-13 | Hancock | Mississippi | 28045 | 1504 | 46 |
821266 | 821266 | 2020-12-12 | Hancock | Mississippi | 28045 | 1486 | 46 |
818020 | 818020 | 2020-12-11 | Hancock | Mississippi | 28045 | 1454 | 45 |
814774 | 814774 | 2020-12-10 | Hancock | Mississippi | 28045 | 1445 | 45 |
811529 | 811529 | 2020-12-09 | Hancock | Mississippi | 28045 | 1410 | 45 |
808284 | 808284 | 2020-12-08 | Hancock | Mississippi | 28045 | 1388 | 45 |
805039 | 805039 | 2020-12-07 | Hancock | Mississippi | 28045 | 1365 | 43 |
801794 | 801794 | 2020-12-06 | Hancock | Mississippi | 28045 | 1347 | 43 |
798549 | 798549 | 2020-12-05 | Hancock | Mississippi | 28045 | 1341 | 43 |
795304 | 795304 | 2020-12-04 | Hancock | Mississippi | 28045 | 1328 | 42 |
792059 | 792059 | 2020-12-03 | Hancock | Mississippi | 28045 | 1309 | 42 |
788814 | 788814 | 2020-12-02 | Hancock | Mississippi | 28045 | 1276 | 41 |
785569 | 785569 | 2020-12-01 | Hancock | Mississippi | 28045 | 1243 | 41 |
782325 | 782325 | 2020-11-30 | Hancock | Mississippi | 28045 | 1236 | 40 |
779079 | 779079 | 2020-11-29 | Hancock | Mississippi | 28045 | 1228 | 40 |
775834 | 775834 | 2020-11-28 | Hancock | Mississippi | 28045 | 1211 | 39 |
772589 | 772589 | 2020-11-27 | Hancock | Mississippi | 28045 | 1202 | 39 |
769344 | 769344 | 2020-11-26 | Hancock | Mississippi | 28045 | 1176 | 39 |
766098 | 766098 | 2020-11-25 | Hancock | Mississippi | 28045 | 1159 | 39 |
762853 | 762853 | 2020-11-24 | Hancock | Mississippi | 28045 | 1141 | 39 |
759608 | 759608 | 2020-11-23 | Hancock | Mississippi | 28045 | 1141 | 37 |
756361 | 756361 | 2020-11-22 | Hancock | Mississippi | 28045 | 1133 | 37 |
753115 | 753115 | 2020-11-21 | Hancock | Mississippi | 28045 | 1123 | 37 |
749869 | 749869 | 2020-11-20 | Hancock | Mississippi | 28045 | 1114 | 37 |
746623 | 746623 | 2020-11-19 | Hancock | Mississippi | 28045 | 1098 | 37 |
743376 | 743376 | 2020-11-18 | Hancock | Mississippi | 28045 | 1095 | 36 |
740129 | 740129 | 2020-11-17 | Hancock | Mississippi | 28045 | 1082 | 35 |
736885 | 736885 | 2020-11-16 | Hancock | Mississippi | 28045 | 1071 | 34 |
733639 | 733639 | 2020-11-15 | Hancock | Mississippi | 28045 | 1068 | 34 |
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);