ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
419 rows where deaths = 22 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Wilkinson 47
- Wayne 32
- Humphreys 24
- Carroll 18
- Lawrence 18
- Kemper 16
- Greene 15
- Winston 15
- Scott 14
- Franklin 12
- Marshall 12
- Hancock 11
- Chickasaw 9
- Covington 9
- Jefferson Davis 9
- Tunica 9
- Adams 8
- Clay 8
- Warren 8
- Calhoun 7
- Jasper 7
- Sharkey 7
- Benton 6
- Leflore 6
- Noxubee 6
- Perry 6
- Claiborne 5
- Clarke 5
- Newton 5
- Walthall 5
- …
state 1
- Mississippi · 419 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2289502 | 2289502 | 2022-03-09 | Unknown | Mississippi | 163 | 22 | |
2201697 | 2201697 | 2022-02-10 | Sharkey | Mississippi | 28125 | 931 | 22 |
2198443 | 2198443 | 2022-02-09 | Sharkey | Mississippi | 28125 | 929 | 22 |
2195189 | 2195189 | 2022-02-08 | Sharkey | Mississippi | 28125 | 927 | 22 |
2178925 | 2178925 | 2022-02-03 | Sharkey | Mississippi | 28125 | 893 | 22 |
2175673 | 2175673 | 2022-02-02 | Sharkey | Mississippi | 28125 | 883 | 22 |
2172420 | 2172420 | 2022-02-01 | Sharkey | Mississippi | 28125 | 880 | 22 |
2169167 | 2169167 | 2022-01-31 | Sharkey | Mississippi | 28125 | 877 | 22 |
1697880 | 1697880 | 2021-09-08 | Quitman | Mississippi | 28119 | 990 | 22 |
1175057 | 1175057 | 2021-03-31 | Franklin | Mississippi | 28037 | 806 | 22 |
1171810 | 1171810 | 2021-03-30 | Franklin | Mississippi | 28037 | 803 | 22 |
1171830 | 1171830 | 2021-03-30 | Lawrence | Mississippi | 28077 | 1250 | 22 |
1168562 | 1168562 | 2021-03-29 | Franklin | Mississippi | 28037 | 803 | 22 |
1168582 | 1168582 | 2021-03-29 | Lawrence | Mississippi | 28077 | 1249 | 22 |
1165314 | 1165314 | 2021-03-28 | Franklin | Mississippi | 28037 | 803 | 22 |
1165334 | 1165334 | 2021-03-28 | Lawrence | Mississippi | 28077 | 1249 | 22 |
1162066 | 1162066 | 2021-03-27 | Franklin | Mississippi | 28037 | 802 | 22 |
1162086 | 1162086 | 2021-03-27 | Lawrence | Mississippi | 28077 | 1248 | 22 |
1158818 | 1158818 | 2021-03-26 | Franklin | Mississippi | 28037 | 802 | 22 |
1158838 | 1158838 | 2021-03-26 | Lawrence | Mississippi | 28077 | 1247 | 22 |
1155571 | 1155571 | 2021-03-25 | Franklin | Mississippi | 28037 | 801 | 22 |
1155591 | 1155591 | 2021-03-25 | Lawrence | Mississippi | 28077 | 1244 | 22 |
1152324 | 1152324 | 2021-03-24 | Franklin | Mississippi | 28037 | 799 | 22 |
1152344 | 1152344 | 2021-03-24 | Lawrence | Mississippi | 28077 | 1242 | 22 |
1149077 | 1149077 | 2021-03-23 | Franklin | Mississippi | 28037 | 799 | 22 |
1149097 | 1149097 | 2021-03-23 | Lawrence | Mississippi | 28077 | 1242 | 22 |
1145830 | 1145830 | 2021-03-22 | Franklin | Mississippi | 28037 | 795 | 22 |
1145850 | 1145850 | 2021-03-22 | Lawrence | Mississippi | 28077 | 1239 | 22 |
1142583 | 1142583 | 2021-03-21 | Franklin | Mississippi | 28037 | 795 | 22 |
1142603 | 1142603 | 2021-03-21 | Lawrence | Mississippi | 28077 | 1239 | 22 |
1139336 | 1139336 | 2021-03-20 | Franklin | Mississippi | 28037 | 795 | 22 |
1139356 | 1139356 | 2021-03-20 | Lawrence | Mississippi | 28077 | 1237 | 22 |
1136110 | 1136110 | 2021-03-19 | Lawrence | Mississippi | 28077 | 1235 | 22 |
1132864 | 1132864 | 2021-03-18 | Lawrence | Mississippi | 28077 | 1234 | 22 |
1129616 | 1129616 | 2021-03-17 | Lawrence | Mississippi | 28077 | 1231 | 22 |
1126369 | 1126369 | 2021-03-16 | Lawrence | Mississippi | 28077 | 1228 | 22 |
1123123 | 1123123 | 2021-03-15 | Lawrence | Mississippi | 28077 | 1227 | 22 |
1119876 | 1119876 | 2021-03-14 | Lawrence | Mississippi | 28077 | 1227 | 22 |
1116629 | 1116629 | 2021-03-13 | Lawrence | Mississippi | 28077 | 1227 | 22 |
1064691 | 1064691 | 2021-02-25 | Kemper | Mississippi | 28069 | 895 | 22 |
1061447 | 1061447 | 2021-02-24 | Kemper | Mississippi | 28069 | 894 | 22 |
1058201 | 1058201 | 2021-02-23 | Kemper | Mississippi | 28069 | 892 | 22 |
1054955 | 1054955 | 2021-02-22 | Kemper | Mississippi | 28069 | 891 | 22 |
1051708 | 1051708 | 2021-02-21 | Kemper | Mississippi | 28069 | 891 | 22 |
1048461 | 1048461 | 2021-02-20 | Kemper | Mississippi | 28069 | 888 | 22 |
1045215 | 1045215 | 2021-02-19 | Kemper | Mississippi | 28069 | 887 | 22 |
1041970 | 1041970 | 2021-02-18 | Kemper | Mississippi | 28069 | 887 | 22 |
1038725 | 1038725 | 2021-02-17 | Kemper | Mississippi | 28069 | 887 | 22 |
1035480 | 1035480 | 2021-02-16 | Kemper | Mississippi | 28069 | 884 | 22 |
1032235 | 1032235 | 2021-02-15 | Kemper | Mississippi | 28069 | 881 | 22 |
1028988 | 1028988 | 2021-02-14 | Kemper | Mississippi | 28069 | 880 | 22 |
1025742 | 1025742 | 2021-02-13 | Kemper | Mississippi | 28069 | 875 | 22 |
1022497 | 1022497 | 2021-02-12 | Kemper | Mississippi | 28069 | 872 | 22 |
1019252 | 1019252 | 2021-02-11 | Kemper | Mississippi | 28069 | 866 | 22 |
1016007 | 1016007 | 2021-02-10 | Kemper | Mississippi | 28069 | 861 | 22 |
1006243 | 1006243 | 2021-02-07 | Carroll | Mississippi | 28015 | 1117 | 22 |
1002997 | 1002997 | 2021-02-06 | Carroll | Mississippi | 28015 | 1116 | 22 |
999752 | 999752 | 2021-02-05 | Carroll | Mississippi | 28015 | 1112 | 22 |
996506 | 996506 | 2021-02-04 | Carroll | Mississippi | 28015 | 1108 | 22 |
996570 | 996570 | 2021-02-04 | Tunica | Mississippi | 28143 | 934 | 22 |
993260 | 993260 | 2021-02-03 | Carroll | Mississippi | 28015 | 1102 | 22 |
993324 | 993324 | 2021-02-03 | Tunica | Mississippi | 28143 | 926 | 22 |
990014 | 990014 | 2021-02-02 | Carroll | Mississippi | 28015 | 1102 | 22 |
990078 | 990078 | 2021-02-02 | Tunica | Mississippi | 28143 | 924 | 22 |
986767 | 986767 | 2021-02-01 | Carroll | Mississippi | 28015 | 1101 | 22 |
986831 | 986831 | 2021-02-01 | Tunica | Mississippi | 28143 | 924 | 22 |
983520 | 983520 | 2021-01-31 | Carroll | Mississippi | 28015 | 1100 | 22 |
983584 | 983584 | 2021-01-31 | Tunica | Mississippi | 28143 | 923 | 22 |
980274 | 980274 | 2021-01-30 | Carroll | Mississippi | 28015 | 1095 | 22 |
980338 | 980338 | 2021-01-30 | Tunica | Mississippi | 28143 | 913 | 22 |
977028 | 977028 | 2021-01-29 | Carroll | Mississippi | 28015 | 1091 | 22 |
977092 | 977092 | 2021-01-29 | Tunica | Mississippi | 28143 | 907 | 22 |
973782 | 973782 | 2021-01-28 | Calhoun | Mississippi | 28013 | 1461 | 22 |
973783 | 973783 | 2021-01-28 | Carroll | Mississippi | 28015 | 1080 | 22 |
973807 | 973807 | 2021-01-28 | Jefferson | Mississippi | 28063 | 575 | 22 |
973847 | 973847 | 2021-01-28 | Tunica | Mississippi | 28143 | 904 | 22 |
970537 | 970537 | 2021-01-27 | Calhoun | Mississippi | 28013 | 1431 | 22 |
970538 | 970538 | 2021-01-27 | Carroll | Mississippi | 28015 | 1077 | 22 |
970602 | 970602 | 2021-01-27 | Tunica | Mississippi | 28143 | 897 | 22 |
967292 | 967292 | 2021-01-26 | Calhoun | Mississippi | 28013 | 1420 | 22 |
967293 | 967293 | 2021-01-26 | Carroll | Mississippi | 28015 | 1069 | 22 |
964048 | 964048 | 2021-01-25 | Calhoun | Mississippi | 28013 | 1418 | 22 |
964049 | 964049 | 2021-01-25 | Carroll | Mississippi | 28015 | 1069 | 22 |
960803 | 960803 | 2021-01-24 | Calhoun | Mississippi | 28013 | 1413 | 22 |
960804 | 960804 | 2021-01-24 | Carroll | Mississippi | 28015 | 1068 | 22 |
957557 | 957557 | 2021-01-23 | Calhoun | Mississippi | 28013 | 1408 | 22 |
957558 | 957558 | 2021-01-23 | Carroll | Mississippi | 28015 | 1066 | 22 |
954312 | 954312 | 2021-01-22 | Calhoun | Mississippi | 28013 | 1399 | 22 |
954313 | 954313 | 2021-01-22 | Carroll | Mississippi | 28015 | 1064 | 22 |
951068 | 951068 | 2021-01-21 | Carroll | Mississippi | 28015 | 1059 | 22 |
944619 | 944619 | 2021-01-19 | Noxubee | Mississippi | 28103 | 1108 | 22 |
941374 | 941374 | 2021-01-18 | Noxubee | Mississippi | 28103 | 1105 | 22 |
938129 | 938129 | 2021-01-17 | Noxubee | Mississippi | 28103 | 1103 | 22 |
934884 | 934884 | 2021-01-16 | Noxubee | Mississippi | 28103 | 1102 | 22 |
931639 | 931639 | 2021-01-15 | Noxubee | Mississippi | 28103 | 1096 | 22 |
928347 | 928347 | 2021-01-14 | Benton | Mississippi | 28009 | 797 | 22 |
928394 | 928394 | 2021-01-14 | Noxubee | Mississippi | 28103 | 1089 | 22 |
928407 | 928407 | 2021-01-14 | Smith | Mississippi | 28129 | 1173 | 22 |
925101 | 925101 | 2021-01-13 | Benton | Mississippi | 28009 | 796 | 22 |
925161 | 925161 | 2021-01-13 | Smith | Mississippi | 28129 | 1160 | 22 |
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);