ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where fips = 28149 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1811607 | 1811607 | 2021-10-13 | Warren | Mississippi | 28149 | 6632 | 175 |
1808358 | 1808358 | 2021-10-12 | Warren | Mississippi | 28149 | 6627 | 173 |
1805107 | 1805107 | 2021-10-11 | Warren | Mississippi | 28149 | 6625 | 173 |
1801858 | 1801858 | 2021-10-10 | Warren | Mississippi | 28149 | 6615 | 173 |
1798609 | 1798609 | 2021-10-09 | Warren | Mississippi | 28149 | 6615 | 173 |
1795360 | 1795360 | 2021-10-08 | Warren | Mississippi | 28149 | 6615 | 173 |
1792111 | 1792111 | 2021-10-07 | Warren | Mississippi | 28149 | 6610 | 173 |
1788862 | 1788862 | 2021-10-06 | Warren | Mississippi | 28149 | 6576 | 173 |
1785614 | 1785614 | 2021-10-05 | Warren | Mississippi | 28149 | 6568 | 173 |
1782365 | 1782365 | 2021-10-04 | Warren | Mississippi | 28149 | 6562 | 173 |
1779115 | 1779115 | 2021-10-03 | Warren | Mississippi | 28149 | 6531 | 172 |
1775865 | 1775865 | 2021-10-02 | Warren | Mississippi | 28149 | 6531 | 172 |
1772615 | 1772615 | 2021-10-01 | Warren | Mississippi | 28149 | 6531 | 172 |
1769366 | 1769366 | 2021-09-30 | Warren | Mississippi | 28149 | 6525 | 169 |
1766117 | 1766117 | 2021-09-29 | Warren | Mississippi | 28149 | 6508 | 169 |
1762868 | 1762868 | 2021-09-28 | Warren | Mississippi | 28149 | 6507 | 168 |
1759619 | 1759619 | 2021-09-27 | Warren | Mississippi | 28149 | 6486 | 166 |
1756371 | 1756371 | 2021-09-26 | Warren | Mississippi | 28149 | 6464 | 164 |
1753123 | 1753123 | 2021-09-25 | Warren | Mississippi | 28149 | 6464 | 164 |
1749875 | 1749875 | 2021-09-24 | Warren | Mississippi | 28149 | 6464 | 164 |
1746625 | 1746625 | 2021-09-23 | Warren | Mississippi | 28149 | 6439 | 163 |
1743376 | 1743376 | 2021-09-22 | Warren | Mississippi | 28149 | 6387 | 163 |
1740127 | 1740127 | 2021-09-21 | Warren | Mississippi | 28149 | 6366 | 163 |
1736878 | 1736878 | 2021-09-20 | Warren | Mississippi | 28149 | 6350 | 161 |
1733628 | 1733628 | 2021-09-19 | Warren | Mississippi | 28149 | 6326 | 161 |
1730378 | 1730378 | 2021-09-18 | Warren | Mississippi | 28149 | 6326 | 161 |
1727128 | 1727128 | 2021-09-17 | Warren | Mississippi | 28149 | 6326 | 161 |
1723879 | 1723879 | 2021-09-16 | Warren | Mississippi | 28149 | 6310 | 159 |
1720630 | 1720630 | 2021-09-15 | Warren | Mississippi | 28149 | 6267 | 159 |
1717382 | 1717382 | 2021-09-14 | Warren | Mississippi | 28149 | 6243 | 159 |
1714134 | 1714134 | 2021-09-13 | Warren | Mississippi | 28149 | 6235 | 153 |
1710888 | 1710888 | 2021-09-12 | Warren | Mississippi | 28149 | 6217 | 151 |
1707641 | 1707641 | 2021-09-11 | Warren | Mississippi | 28149 | 6217 | 151 |
1704394 | 1704394 | 2021-09-10 | Warren | Mississippi | 28149 | 6217 | 151 |
1701144 | 1701144 | 2021-09-09 | Warren | Mississippi | 28149 | 6203 | 151 |
1697895 | 1697895 | 2021-09-08 | Warren | Mississippi | 28149 | 6184 | 150 |
1694647 | 1694647 | 2021-09-07 | Warren | Mississippi | 28149 | 6178 | 150 |
1691398 | 1691398 | 2021-09-06 | Warren | Mississippi | 28149 | 6172 | 149 |
1688148 | 1688148 | 2021-09-05 | Warren | Mississippi | 28149 | 6100 | 148 |
1684898 | 1684898 | 2021-09-04 | Warren | Mississippi | 28149 | 6100 | 148 |
1681647 | 1681647 | 2021-09-03 | Warren | Mississippi | 28149 | 6100 | 148 |
1678399 | 1678399 | 2021-09-02 | Warren | Mississippi | 28149 | 6074 | 148 |
1675151 | 1675151 | 2021-09-01 | Warren | Mississippi | 28149 | 6054 | 148 |
1671903 | 1671903 | 2021-08-31 | Warren | Mississippi | 28149 | 6036 | 147 |
1668656 | 1668656 | 2021-08-30 | Warren | Mississippi | 28149 | 6020 | 145 |
1665409 | 1665409 | 2021-08-29 | Warren | Mississippi | 28149 | 5870 | 141 |
1662161 | 1662161 | 2021-08-28 | Warren | Mississippi | 28149 | 5870 | 141 |
1658913 | 1658913 | 2021-08-27 | Warren | Mississippi | 28149 | 5870 | 141 |
1655664 | 1655664 | 2021-08-26 | Warren | Mississippi | 28149 | 5848 | 139 |
1652417 | 1652417 | 2021-08-25 | Warren | Mississippi | 28149 | 5797 | 139 |
1649169 | 1649169 | 2021-08-24 | Warren | Mississippi | 28149 | 5731 | 139 |
1645920 | 1645920 | 2021-08-23 | Warren | Mississippi | 28149 | 5708 | 134 |
1642671 | 1642671 | 2021-08-22 | Warren | Mississippi | 28149 | 5618 | 132 |
1639421 | 1639421 | 2021-08-21 | Warren | Mississippi | 28149 | 5618 | 132 |
1636171 | 1636171 | 2021-08-20 | Warren | Mississippi | 28149 | 5618 | 132 |
1632921 | 1632921 | 2021-08-19 | Warren | Mississippi | 28149 | 5484 | 130 |
1629674 | 1629674 | 2021-08-18 | Warren | Mississippi | 28149 | 5427 | 130 |
1626427 | 1626427 | 2021-08-17 | Warren | Mississippi | 28149 | 5366 | 130 |
1623180 | 1623180 | 2021-08-16 | Warren | Mississippi | 28149 | 5289 | 129 |
1619933 | 1619933 | 2021-08-15 | Warren | Mississippi | 28149 | 5192 | 128 |
1616685 | 1616685 | 2021-08-14 | Warren | Mississippi | 28149 | 5192 | 128 |
1613437 | 1613437 | 2021-08-13 | Warren | Mississippi | 28149 | 5192 | 128 |
1610188 | 1610188 | 2021-08-12 | Warren | Mississippi | 28149 | 5146 | 128 |
1606940 | 1606940 | 2021-08-11 | Warren | Mississippi | 28149 | 5099 | 128 |
1603691 | 1603691 | 2021-08-10 | Warren | Mississippi | 28149 | 4970 | 128 |
1600442 | 1600442 | 2021-08-09 | Warren | Mississippi | 28149 | 4925 | 128 |
1597194 | 1597194 | 2021-08-08 | Warren | Mississippi | 28149 | 4860 | 128 |
1593945 | 1593945 | 2021-08-07 | Warren | Mississippi | 28149 | 4860 | 128 |
1590696 | 1590696 | 2021-08-06 | Warren | Mississippi | 28149 | 4860 | 128 |
1587447 | 1587447 | 2021-08-05 | Warren | Mississippi | 28149 | 4844 | 128 |
1584196 | 1584196 | 2021-08-04 | Warren | Mississippi | 28149 | 4828 | 128 |
1580947 | 1580947 | 2021-08-03 | Warren | Mississippi | 28149 | 4817 | 128 |
1577698 | 1577698 | 2021-08-02 | Warren | Mississippi | 28149 | 4803 | 128 |
1574450 | 1574450 | 2021-08-01 | Warren | Mississippi | 28149 | 4728 | 128 |
1571202 | 1571202 | 2021-07-31 | Warren | Mississippi | 28149 | 4728 | 128 |
1567954 | 1567954 | 2021-07-30 | Warren | Mississippi | 28149 | 4728 | 128 |
1564706 | 1564706 | 2021-07-29 | Warren | Mississippi | 28149 | 4709 | 127 |
1561458 | 1561458 | 2021-07-28 | Warren | Mississippi | 28149 | 4698 | 127 |
1558210 | 1558210 | 2021-07-27 | Warren | Mississippi | 28149 | 4690 | 127 |
1554963 | 1554963 | 2021-07-26 | Warren | Mississippi | 28149 | 4681 | 127 |
1551716 | 1551716 | 2021-07-25 | Warren | Mississippi | 28149 | 4640 | 127 |
1548469 | 1548469 | 2021-07-24 | Warren | Mississippi | 28149 | 4640 | 127 |
1545222 | 1545222 | 2021-07-23 | Warren | Mississippi | 28149 | 4640 | 127 |
1541974 | 1541974 | 2021-07-22 | Warren | Mississippi | 28149 | 4612 | 125 |
1538727 | 1538727 | 2021-07-21 | Warren | Mississippi | 28149 | 4585 | 124 |
1535480 | 1535480 | 2021-07-20 | Warren | Mississippi | 28149 | 4583 | 123 |
1532232 | 1532232 | 2021-07-19 | Warren | Mississippi | 28149 | 4580 | 122 |
1528985 | 1528985 | 2021-07-18 | Warren | Mississippi | 28149 | 4544 | 122 |
1525738 | 1525738 | 2021-07-17 | Warren | Mississippi | 28149 | 4544 | 122 |
1522491 | 1522491 | 2021-07-16 | Warren | Mississippi | 28149 | 4544 | 122 |
1519242 | 1519242 | 2021-07-15 | Warren | Mississippi | 28149 | 4530 | 122 |
1515995 | 1515995 | 2021-07-14 | Warren | Mississippi | 28149 | 4522 | 122 |
1512749 | 1512749 | 2021-07-13 | Warren | Mississippi | 28149 | 4507 | 122 |
1509502 | 1509502 | 2021-07-12 | Warren | Mississippi | 28149 | 4506 | 121 |
1506256 | 1506256 | 2021-07-11 | Warren | Mississippi | 28149 | 4489 | 121 |
1503010 | 1503010 | 2021-07-10 | Warren | Mississippi | 28149 | 4489 | 121 |
1499764 | 1499764 | 2021-07-09 | Warren | Mississippi | 28149 | 4489 | 121 |
1496518 | 1496518 | 2021-07-08 | Warren | Mississippi | 28149 | 4478 | 121 |
1493271 | 1493271 | 2021-07-07 | Warren | Mississippi | 28149 | 4478 | 121 |
1490024 | 1490024 | 2021-07-06 | Warren | Mississippi | 28149 | 4468 | 121 |
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);