ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
562 rows where deaths = 23 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Franklin 123
- Attala 41
- Lawrence 40
- Montgomery 34
- Tunica 28
- Perry 20
- Carroll 19
- Benton 18
- Union 17
- Kemper 13
- Sharkey 12
- Amite 9
- Panola 9
- Wayne 8
- Calhoun 7
- Jefferson 7
- Monroe 7
- Rankin 7
- Wilkinson 7
- Yalobusha 7
- George 6
- Greene 6
- Newton 6
- Walthall 6
- Webster 6
- Yazoo 6
- Adams 5
- Covington 5
- DeSoto 5
- Jasper 5
- …
state 1
- Mississippi · 562 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2240716 | 2240716 | 2022-02-22 | Sharkey | Mississippi | 28125 | 946 | 23 |
2237465 | 2237465 | 2022-02-21 | Sharkey | Mississippi | 28125 | 946 | 23 |
2234214 | 2234214 | 2022-02-20 | Sharkey | Mississippi | 28125 | 946 | 23 |
2230963 | 2230963 | 2022-02-19 | Sharkey | Mississippi | 28125 | 946 | 23 |
2227712 | 2227712 | 2022-02-18 | Sharkey | Mississippi | 28125 | 946 | 23 |
2224461 | 2224461 | 2022-02-17 | Sharkey | Mississippi | 28125 | 941 | 23 |
2221210 | 2221210 | 2022-02-16 | Sharkey | Mississippi | 28125 | 939 | 23 |
2217959 | 2217959 | 2022-02-15 | Sharkey | Mississippi | 28125 | 936 | 23 |
2214708 | 2214708 | 2022-02-14 | Sharkey | Mississippi | 28125 | 936 | 23 |
2211456 | 2211456 | 2022-02-13 | Sharkey | Mississippi | 28125 | 935 | 23 |
2208203 | 2208203 | 2022-02-12 | Sharkey | Mississippi | 28125 | 935 | 23 |
2204950 | 2204950 | 2022-02-11 | Sharkey | Mississippi | 28125 | 935 | 23 |
1574394 | 1574394 | 2021-08-01 | Franklin | Mississippi | 28037 | 879 | 23 |
1571146 | 1571146 | 2021-07-31 | Franklin | Mississippi | 28037 | 879 | 23 |
1567898 | 1567898 | 2021-07-30 | Franklin | Mississippi | 28037 | 879 | 23 |
1564650 | 1564650 | 2021-07-29 | Franklin | Mississippi | 28037 | 877 | 23 |
1561402 | 1561402 | 2021-07-28 | Franklin | Mississippi | 28037 | 872 | 23 |
1558154 | 1558154 | 2021-07-27 | Franklin | Mississippi | 28037 | 867 | 23 |
1554907 | 1554907 | 2021-07-26 | Franklin | Mississippi | 28037 | 862 | 23 |
1551660 | 1551660 | 2021-07-25 | Franklin | Mississippi | 28037 | 859 | 23 |
1548413 | 1548413 | 2021-07-24 | Franklin | Mississippi | 28037 | 859 | 23 |
1545166 | 1545166 | 2021-07-23 | Franklin | Mississippi | 28037 | 859 | 23 |
1541918 | 1541918 | 2021-07-22 | Franklin | Mississippi | 28037 | 859 | 23 |
1538671 | 1538671 | 2021-07-21 | Franklin | Mississippi | 28037 | 859 | 23 |
1535424 | 1535424 | 2021-07-20 | Franklin | Mississippi | 28037 | 859 | 23 |
1532176 | 1532176 | 2021-07-19 | Franklin | Mississippi | 28037 | 857 | 23 |
1528929 | 1528929 | 2021-07-18 | Franklin | Mississippi | 28037 | 855 | 23 |
1525682 | 1525682 | 2021-07-17 | Franklin | Mississippi | 28037 | 855 | 23 |
1522435 | 1522435 | 2021-07-16 | Franklin | Mississippi | 28037 | 855 | 23 |
1519186 | 1519186 | 2021-07-15 | Franklin | Mississippi | 28037 | 854 | 23 |
1515939 | 1515939 | 2021-07-14 | Franklin | Mississippi | 28037 | 854 | 23 |
1512693 | 1512693 | 2021-07-13 | Franklin | Mississippi | 28037 | 853 | 23 |
1509446 | 1509446 | 2021-07-12 | Franklin | Mississippi | 28037 | 853 | 23 |
1506200 | 1506200 | 2021-07-11 | Franklin | Mississippi | 28037 | 852 | 23 |
1502954 | 1502954 | 2021-07-10 | Franklin | Mississippi | 28037 | 852 | 23 |
1499708 | 1499708 | 2021-07-09 | Franklin | Mississippi | 28037 | 852 | 23 |
1496462 | 1496462 | 2021-07-08 | Franklin | Mississippi | 28037 | 852 | 23 |
1493215 | 1493215 | 2021-07-07 | Franklin | Mississippi | 28037 | 853 | 23 |
1489968 | 1489968 | 2021-07-06 | Franklin | Mississippi | 28037 | 852 | 23 |
1486721 | 1486721 | 2021-07-05 | Franklin | Mississippi | 28037 | 852 | 23 |
1483475 | 1483475 | 2021-07-04 | Franklin | Mississippi | 28037 | 852 | 23 |
1480229 | 1480229 | 2021-07-03 | Franklin | Mississippi | 28037 | 852 | 23 |
1476982 | 1476982 | 2021-07-02 | Franklin | Mississippi | 28037 | 852 | 23 |
1473736 | 1473736 | 2021-07-01 | Franklin | Mississippi | 28037 | 852 | 23 |
1470490 | 1470490 | 2021-06-30 | Franklin | Mississippi | 28037 | 852 | 23 |
1467245 | 1467245 | 2021-06-29 | Franklin | Mississippi | 28037 | 852 | 23 |
1464000 | 1464000 | 2021-06-28 | Franklin | Mississippi | 28037 | 852 | 23 |
1460755 | 1460755 | 2021-06-27 | Franklin | Mississippi | 28037 | 852 | 23 |
1457510 | 1457510 | 2021-06-26 | Franklin | Mississippi | 28037 | 852 | 23 |
1454265 | 1454265 | 2021-06-25 | Franklin | Mississippi | 28037 | 852 | 23 |
1451020 | 1451020 | 2021-06-24 | Franklin | Mississippi | 28037 | 850 | 23 |
1447774 | 1447774 | 2021-06-23 | Franklin | Mississippi | 28037 | 850 | 23 |
1444529 | 1444529 | 2021-06-22 | Franklin | Mississippi | 28037 | 850 | 23 |
1441284 | 1441284 | 2021-06-21 | Franklin | Mississippi | 28037 | 850 | 23 |
1438038 | 1438038 | 2021-06-20 | Franklin | Mississippi | 28037 | 850 | 23 |
1434791 | 1434791 | 2021-06-19 | Franklin | Mississippi | 28037 | 850 | 23 |
1431544 | 1431544 | 2021-06-18 | Franklin | Mississippi | 28037 | 850 | 23 |
1428299 | 1428299 | 2021-06-17 | Franklin | Mississippi | 28037 | 850 | 23 |
1425054 | 1425054 | 2021-06-16 | Franklin | Mississippi | 28037 | 850 | 23 |
1421806 | 1421806 | 2021-06-15 | Franklin | Mississippi | 28037 | 850 | 23 |
1418561 | 1418561 | 2021-06-14 | Franklin | Mississippi | 28037 | 850 | 23 |
1415316 | 1415316 | 2021-06-13 | Franklin | Mississippi | 28037 | 849 | 23 |
1412070 | 1412070 | 2021-06-12 | Franklin | Mississippi | 28037 | 849 | 23 |
1408825 | 1408825 | 2021-06-11 | Franklin | Mississippi | 28037 | 849 | 23 |
1405580 | 1405580 | 2021-06-10 | Franklin | Mississippi | 28037 | 849 | 23 |
1402334 | 1402334 | 2021-06-09 | Franklin | Mississippi | 28037 | 849 | 23 |
1399089 | 1399089 | 2021-06-08 | Franklin | Mississippi | 28037 | 849 | 23 |
1395843 | 1395843 | 2021-06-07 | Franklin | Mississippi | 28037 | 849 | 23 |
1392597 | 1392597 | 2021-06-06 | Franklin | Mississippi | 28037 | 849 | 23 |
1389352 | 1389352 | 2021-06-05 | Franklin | Mississippi | 28037 | 849 | 23 |
1386107 | 1386107 | 2021-06-04 | Franklin | Mississippi | 28037 | 849 | 23 |
1382862 | 1382862 | 2021-06-03 | Franklin | Mississippi | 28037 | 847 | 23 |
1379616 | 1379616 | 2021-06-02 | Franklin | Mississippi | 28037 | 846 | 23 |
1376371 | 1376371 | 2021-06-01 | Franklin | Mississippi | 28037 | 846 | 23 |
1373125 | 1373125 | 2021-05-31 | Franklin | Mississippi | 28037 | 846 | 23 |
1369880 | 1369880 | 2021-05-30 | Franklin | Mississippi | 28037 | 846 | 23 |
1366634 | 1366634 | 2021-05-29 | Franklin | Mississippi | 28037 | 846 | 23 |
1363388 | 1363388 | 2021-05-28 | Franklin | Mississippi | 28037 | 846 | 23 |
1360141 | 1360141 | 2021-05-27 | Franklin | Mississippi | 28037 | 845 | 23 |
1356895 | 1356895 | 2021-05-26 | Franklin | Mississippi | 28037 | 844 | 23 |
1353649 | 1353649 | 2021-05-25 | Franklin | Mississippi | 28037 | 844 | 23 |
1350403 | 1350403 | 2021-05-24 | Franklin | Mississippi | 28037 | 844 | 23 |
1347157 | 1347157 | 2021-05-23 | Franklin | Mississippi | 28037 | 843 | 23 |
1343909 | 1343909 | 2021-05-22 | Franklin | Mississippi | 28037 | 843 | 23 |
1340660 | 1340660 | 2021-05-21 | Franklin | Mississippi | 28037 | 843 | 23 |
1337413 | 1337413 | 2021-05-20 | Franklin | Mississippi | 28037 | 843 | 23 |
1334166 | 1334166 | 2021-05-19 | Franklin | Mississippi | 28037 | 843 | 23 |
1330919 | 1330919 | 2021-05-18 | Franklin | Mississippi | 28037 | 841 | 23 |
1327672 | 1327672 | 2021-05-17 | Franklin | Mississippi | 28037 | 839 | 23 |
1324426 | 1324426 | 2021-05-16 | Franklin | Mississippi | 28037 | 839 | 23 |
1321180 | 1321180 | 2021-05-15 | Franklin | Mississippi | 28037 | 839 | 23 |
1317934 | 1317934 | 2021-05-14 | Franklin | Mississippi | 28037 | 839 | 23 |
1314686 | 1314686 | 2021-05-13 | Franklin | Mississippi | 28037 | 838 | 23 |
1311440 | 1311440 | 2021-05-12 | Franklin | Mississippi | 28037 | 836 | 23 |
1308193 | 1308193 | 2021-05-11 | Franklin | Mississippi | 28037 | 836 | 23 |
1304947 | 1304947 | 2021-05-10 | Franklin | Mississippi | 28037 | 835 | 23 |
1301701 | 1301701 | 2021-05-09 | Franklin | Mississippi | 28037 | 836 | 23 |
1301721 | 1301721 | 2021-05-09 | Lawrence | Mississippi | 28077 | 1283 | 23 |
1298453 | 1298453 | 2021-05-08 | Franklin | Mississippi | 28037 | 836 | 23 |
1298473 | 1298473 | 2021-05-08 | Lawrence | Mississippi | 28077 | 1283 | 23 |
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);