ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
51 rows where deaths = 83, fips = 28031 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1564647 | 1564647 | 2021-07-29 | Covington | Mississippi | 28031 | 2918 | 83 |
1561399 | 1561399 | 2021-07-28 | Covington | Mississippi | 28031 | 2896 | 83 |
1558151 | 1558151 | 2021-07-27 | Covington | Mississippi | 28031 | 2871 | 83 |
1554904 | 1554904 | 2021-07-26 | Covington | Mississippi | 28031 | 2865 | 83 |
1551657 | 1551657 | 2021-07-25 | Covington | Mississippi | 28031 | 2824 | 83 |
1548410 | 1548410 | 2021-07-24 | Covington | Mississippi | 28031 | 2824 | 83 |
1545163 | 1545163 | 2021-07-23 | Covington | Mississippi | 28031 | 2824 | 83 |
1541915 | 1541915 | 2021-07-22 | Covington | Mississippi | 28031 | 2801 | 83 |
1538668 | 1538668 | 2021-07-21 | Covington | Mississippi | 28031 | 2795 | 83 |
1535421 | 1535421 | 2021-07-20 | Covington | Mississippi | 28031 | 2787 | 83 |
1532173 | 1532173 | 2021-07-19 | Covington | Mississippi | 28031 | 2781 | 83 |
1528926 | 1528926 | 2021-07-18 | Covington | Mississippi | 28031 | 2746 | 83 |
1525679 | 1525679 | 2021-07-17 | Covington | Mississippi | 28031 | 2746 | 83 |
1522432 | 1522432 | 2021-07-16 | Covington | Mississippi | 28031 | 2746 | 83 |
1519183 | 1519183 | 2021-07-15 | Covington | Mississippi | 28031 | 2740 | 83 |
1515936 | 1515936 | 2021-07-14 | Covington | Mississippi | 28031 | 2732 | 83 |
1512690 | 1512690 | 2021-07-13 | Covington | Mississippi | 28031 | 2723 | 83 |
1509443 | 1509443 | 2021-07-12 | Covington | Mississippi | 28031 | 2720 | 83 |
1506197 | 1506197 | 2021-07-11 | Covington | Mississippi | 28031 | 2710 | 83 |
1502951 | 1502951 | 2021-07-10 | Covington | Mississippi | 28031 | 2710 | 83 |
1499705 | 1499705 | 2021-07-09 | Covington | Mississippi | 28031 | 2710 | 83 |
1496459 | 1496459 | 2021-07-08 | Covington | Mississippi | 28031 | 2708 | 83 |
1493212 | 1493212 | 2021-07-07 | Covington | Mississippi | 28031 | 2702 | 83 |
1489965 | 1489965 | 2021-07-06 | Covington | Mississippi | 28031 | 2698 | 83 |
1486718 | 1486718 | 2021-07-05 | Covington | Mississippi | 28031 | 2692 | 83 |
1483472 | 1483472 | 2021-07-04 | Covington | Mississippi | 28031 | 2692 | 83 |
1480226 | 1480226 | 2021-07-03 | Covington | Mississippi | 28031 | 2692 | 83 |
1476979 | 1476979 | 2021-07-02 | Covington | Mississippi | 28031 | 2692 | 83 |
1473733 | 1473733 | 2021-07-01 | Covington | Mississippi | 28031 | 2690 | 83 |
1470487 | 1470487 | 2021-06-30 | Covington | Mississippi | 28031 | 2686 | 83 |
1467242 | 1467242 | 2021-06-29 | Covington | Mississippi | 28031 | 2684 | 83 |
1463997 | 1463997 | 2021-06-28 | Covington | Mississippi | 28031 | 2677 | 83 |
1460752 | 1460752 | 2021-06-27 | Covington | Mississippi | 28031 | 2677 | 83 |
1457507 | 1457507 | 2021-06-26 | Covington | Mississippi | 28031 | 2677 | 83 |
1454262 | 1454262 | 2021-06-25 | Covington | Mississippi | 28031 | 2677 | 83 |
1451017 | 1451017 | 2021-06-24 | Covington | Mississippi | 28031 | 2674 | 83 |
1447771 | 1447771 | 2021-06-23 | Covington | Mississippi | 28031 | 2672 | 83 |
1444526 | 1444526 | 2021-06-22 | Covington | Mississippi | 28031 | 2672 | 83 |
1441281 | 1441281 | 2021-06-21 | Covington | Mississippi | 28031 | 2672 | 83 |
1438035 | 1438035 | 2021-06-20 | Covington | Mississippi | 28031 | 2672 | 83 |
1434788 | 1434788 | 2021-06-19 | Covington | Mississippi | 28031 | 2672 | 83 |
1431541 | 1431541 | 2021-06-18 | Covington | Mississippi | 28031 | 2672 | 83 |
1428296 | 1428296 | 2021-06-17 | Covington | Mississippi | 28031 | 2672 | 83 |
1425051 | 1425051 | 2021-06-16 | Covington | Mississippi | 28031 | 2672 | 83 |
1421803 | 1421803 | 2021-06-15 | Covington | Mississippi | 28031 | 2671 | 83 |
1418558 | 1418558 | 2021-06-14 | Covington | Mississippi | 28031 | 2670 | 83 |
1415313 | 1415313 | 2021-06-13 | Covington | Mississippi | 28031 | 2666 | 83 |
1412067 | 1412067 | 2021-06-12 | Covington | Mississippi | 28031 | 2666 | 83 |
1408822 | 1408822 | 2021-06-11 | Covington | Mississippi | 28031 | 2666 | 83 |
1405577 | 1405577 | 2021-06-10 | Covington | Mississippi | 28031 | 2665 | 83 |
1402331 | 1402331 | 2021-06-09 | Covington | Mississippi | 28031 | 2663 | 83 |
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);