ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Clay" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1811545 | 1811545 | 2021-10-13 | Clay | Mississippi | 28025 | 3054 | 75 |
1808296 | 1808296 | 2021-10-12 | Clay | Mississippi | 28025 | 3046 | 75 |
1805045 | 1805045 | 2021-10-11 | Clay | Mississippi | 28025 | 3040 | 75 |
1801796 | 1801796 | 2021-10-10 | Clay | Mississippi | 28025 | 3037 | 75 |
1798547 | 1798547 | 2021-10-09 | Clay | Mississippi | 28025 | 3037 | 75 |
1795298 | 1795298 | 2021-10-08 | Clay | Mississippi | 28025 | 3037 | 75 |
1792049 | 1792049 | 2021-10-07 | Clay | Mississippi | 28025 | 3029 | 75 |
1788800 | 1788800 | 2021-10-06 | Clay | Mississippi | 28025 | 3023 | 74 |
1785552 | 1785552 | 2021-10-05 | Clay | Mississippi | 28025 | 3019 | 74 |
1782303 | 1782303 | 2021-10-04 | Clay | Mississippi | 28025 | 3009 | 74 |
1779053 | 1779053 | 2021-10-03 | Clay | Mississippi | 28025 | 2996 | 74 |
1775803 | 1775803 | 2021-10-02 | Clay | Mississippi | 28025 | 2996 | 74 |
1772553 | 1772553 | 2021-10-01 | Clay | Mississippi | 28025 | 2996 | 74 |
1769304 | 1769304 | 2021-09-30 | Clay | Mississippi | 28025 | 2994 | 74 |
1766055 | 1766055 | 2021-09-29 | Clay | Mississippi | 28025 | 2991 | 74 |
1762806 | 1762806 | 2021-09-28 | Clay | Mississippi | 28025 | 2982 | 74 |
1759557 | 1759557 | 2021-09-27 | Clay | Mississippi | 28025 | 2973 | 74 |
1756309 | 1756309 | 2021-09-26 | Clay | Mississippi | 28025 | 2964 | 73 |
1753061 | 1753061 | 2021-09-25 | Clay | Mississippi | 28025 | 2964 | 73 |
1749813 | 1749813 | 2021-09-24 | Clay | Mississippi | 28025 | 2964 | 73 |
1746563 | 1746563 | 2021-09-23 | Clay | Mississippi | 28025 | 2952 | 73 |
1743314 | 1743314 | 2021-09-22 | Clay | Mississippi | 28025 | 2941 | 73 |
1740065 | 1740065 | 2021-09-21 | Clay | Mississippi | 28025 | 2923 | 73 |
1736816 | 1736816 | 2021-09-20 | Clay | Mississippi | 28025 | 2912 | 73 |
1733566 | 1733566 | 2021-09-19 | Clay | Mississippi | 28025 | 2882 | 73 |
1730316 | 1730316 | 2021-09-18 | Clay | Mississippi | 28025 | 2882 | 73 |
1727066 | 1727066 | 2021-09-17 | Clay | Mississippi | 28025 | 2882 | 73 |
1723817 | 1723817 | 2021-09-16 | Clay | Mississippi | 28025 | 2861 | 72 |
1720568 | 1720568 | 2021-09-15 | Clay | Mississippi | 28025 | 2826 | 72 |
1717320 | 1717320 | 2021-09-14 | Clay | Mississippi | 28025 | 2813 | 72 |
1714072 | 1714072 | 2021-09-13 | Clay | Mississippi | 28025 | 2799 | 71 |
1710826 | 1710826 | 2021-09-12 | Clay | Mississippi | 28025 | 2779 | 70 |
1707579 | 1707579 | 2021-09-11 | Clay | Mississippi | 28025 | 2779 | 70 |
1704332 | 1704332 | 2021-09-10 | Clay | Mississippi | 28025 | 2779 | 70 |
1701082 | 1701082 | 2021-09-09 | Clay | Mississippi | 28025 | 2767 | 70 |
1697833 | 1697833 | 2021-09-08 | Clay | Mississippi | 28025 | 2753 | 67 |
1694585 | 1694585 | 2021-09-07 | Clay | Mississippi | 28025 | 2740 | 67 |
1691336 | 1691336 | 2021-09-06 | Clay | Mississippi | 28025 | 2733 | 66 |
1688086 | 1688086 | 2021-09-05 | Clay | Mississippi | 28025 | 2716 | 65 |
1684836 | 1684836 | 2021-09-04 | Clay | Mississippi | 28025 | 2716 | 65 |
1681585 | 1681585 | 2021-09-03 | Clay | Mississippi | 28025 | 2716 | 65 |
1678337 | 1678337 | 2021-09-02 | Clay | Mississippi | 28025 | 2701 | 64 |
1675089 | 1675089 | 2021-09-01 | Clay | Mississippi | 28025 | 2683 | 64 |
1671841 | 1671841 | 2021-08-31 | Clay | Mississippi | 28025 | 2668 | 62 |
1668594 | 1668594 | 2021-08-30 | Clay | Mississippi | 28025 | 2657 | 62 |
1665347 | 1665347 | 2021-08-29 | Clay | Mississippi | 28025 | 2596 | 62 |
1662099 | 1662099 | 2021-08-28 | Clay | Mississippi | 28025 | 2596 | 62 |
1658851 | 1658851 | 2021-08-27 | Clay | Mississippi | 28025 | 2596 | 62 |
1655602 | 1655602 | 2021-08-26 | Clay | Mississippi | 28025 | 2559 | 60 |
1652355 | 1652355 | 2021-08-25 | Clay | Mississippi | 28025 | 2531 | 60 |
1649107 | 1649107 | 2021-08-24 | Clay | Mississippi | 28025 | 2514 | 60 |
1645858 | 1645858 | 2021-08-23 | Clay | Mississippi | 28025 | 2483 | 58 |
1642609 | 1642609 | 2021-08-22 | Clay | Mississippi | 28025 | 2403 | 56 |
1639359 | 1639359 | 2021-08-21 | Clay | Mississippi | 28025 | 2403 | 56 |
1636109 | 1636109 | 2021-08-20 | Clay | Mississippi | 28025 | 2403 | 56 |
1632859 | 1632859 | 2021-08-19 | Clay | Mississippi | 28025 | 2369 | 56 |
1629612 | 1629612 | 2021-08-18 | Clay | Mississippi | 28025 | 2342 | 56 |
1626365 | 1626365 | 2021-08-17 | Clay | Mississippi | 28025 | 2314 | 56 |
1623118 | 1623118 | 2021-08-16 | Clay | Mississippi | 28025 | 2281 | 55 |
1619871 | 1619871 | 2021-08-15 | Clay | Mississippi | 28025 | 2230 | 55 |
1616623 | 1616623 | 2021-08-14 | Clay | Mississippi | 28025 | 2230 | 55 |
1613375 | 1613375 | 2021-08-13 | Clay | Mississippi | 28025 | 2230 | 55 |
1610126 | 1610126 | 2021-08-12 | Clay | Mississippi | 28025 | 2193 | 55 |
1606878 | 1606878 | 2021-08-11 | Clay | Mississippi | 28025 | 2169 | 55 |
1603629 | 1603629 | 2021-08-10 | Clay | Mississippi | 28025 | 2153 | 55 |
1600380 | 1600380 | 2021-08-09 | Clay | Mississippi | 28025 | 2124 | 55 |
1597132 | 1597132 | 2021-08-08 | Clay | Mississippi | 28025 | 2083 | 54 |
1593883 | 1593883 | 2021-08-07 | Clay | Mississippi | 28025 | 2083 | 54 |
1590634 | 1590634 | 2021-08-06 | Clay | Mississippi | 28025 | 2083 | 54 |
1587385 | 1587385 | 2021-08-05 | Clay | Mississippi | 28025 | 2067 | 54 |
1584134 | 1584134 | 2021-08-04 | Clay | Mississippi | 28025 | 2046 | 54 |
1580885 | 1580885 | 2021-08-03 | Clay | Mississippi | 28025 | 2019 | 54 |
1577636 | 1577636 | 2021-08-02 | Clay | Mississippi | 28025 | 2011 | 54 |
1574388 | 1574388 | 2021-08-01 | Clay | Mississippi | 28025 | 1976 | 54 |
1571140 | 1571140 | 2021-07-31 | Clay | Mississippi | 28025 | 1976 | 54 |
1567892 | 1567892 | 2021-07-30 | Clay | Mississippi | 28025 | 1976 | 54 |
1564644 | 1564644 | 2021-07-29 | Clay | Mississippi | 28025 | 1967 | 54 |
1561396 | 1561396 | 2021-07-28 | Clay | Mississippi | 28025 | 1957 | 54 |
1558148 | 1558148 | 2021-07-27 | Clay | Mississippi | 28025 | 1946 | 54 |
1554901 | 1554901 | 2021-07-26 | Clay | Mississippi | 28025 | 1937 | 54 |
1551654 | 1551654 | 2021-07-25 | Clay | Mississippi | 28025 | 1922 | 54 |
1548407 | 1548407 | 2021-07-24 | Clay | Mississippi | 28025 | 1922 | 54 |
1545160 | 1545160 | 2021-07-23 | Clay | Mississippi | 28025 | 1922 | 54 |
1541912 | 1541912 | 2021-07-22 | Clay | Mississippi | 28025 | 1915 | 54 |
1538665 | 1538665 | 2021-07-21 | Clay | Mississippi | 28025 | 1913 | 54 |
1535418 | 1535418 | 2021-07-20 | Clay | Mississippi | 28025 | 1912 | 54 |
1532170 | 1532170 | 2021-07-19 | Clay | Mississippi | 28025 | 1910 | 54 |
1528923 | 1528923 | 2021-07-18 | Clay | Mississippi | 28025 | 1906 | 54 |
1525676 | 1525676 | 2021-07-17 | Clay | Mississippi | 28025 | 1906 | 54 |
1522429 | 1522429 | 2021-07-16 | Clay | Mississippi | 28025 | 1906 | 54 |
1519180 | 1519180 | 2021-07-15 | Clay | Mississippi | 28025 | 1903 | 54 |
1515933 | 1515933 | 2021-07-14 | Clay | Mississippi | 28025 | 1902 | 54 |
1512687 | 1512687 | 2021-07-13 | Clay | Mississippi | 28025 | 1899 | 54 |
1509440 | 1509440 | 2021-07-12 | Clay | Mississippi | 28025 | 1897 | 54 |
1506194 | 1506194 | 2021-07-11 | Clay | Mississippi | 28025 | 1896 | 54 |
1502948 | 1502948 | 2021-07-10 | Clay | Mississippi | 28025 | 1896 | 54 |
1499702 | 1499702 | 2021-07-09 | Clay | Mississippi | 28025 | 1896 | 54 |
1496456 | 1496456 | 2021-07-08 | Clay | Mississippi | 28025 | 1895 | 54 |
1493209 | 1493209 | 2021-07-07 | Clay | Mississippi | 28025 | 1893 | 54 |
1489962 | 1489962 | 2021-07-06 | Clay | Mississippi | 28025 | 1891 | 54 |
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);