ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
773 rows where county = "Madison" and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1800729 | 1800729 | 2021-10-10 | Madison | Florida | 12079 | 3553 | 54 |
1797480 | 1797480 | 2021-10-09 | Madison | Florida | 12079 | 3553 | 54 |
1794231 | 1794231 | 2021-10-08 | Madison | Florida | 12079 | 3553 | 54 |
1790983 | 1790983 | 2021-10-07 | Madison | Florida | 12079 | 3531 | 54 |
1787734 | 1787734 | 2021-10-06 | Madison | Florida | 12079 | 3531 | 54 |
1784485 | 1784485 | 2021-10-05 | Madison | Florida | 12079 | 3531 | 54 |
1781236 | 1781236 | 2021-10-04 | Madison | Florida | 12079 | 3531 | 54 |
1777986 | 1777986 | 2021-10-03 | Madison | Florida | 12079 | 3531 | 54 |
1774736 | 1774736 | 2021-10-02 | Madison | Florida | 12079 | 3531 | 54 |
1771486 | 1771486 | 2021-10-01 | Madison | Florida | 12079 | 3531 | 54 |
1768237 | 1768237 | 2021-09-30 | Madison | Florida | 12079 | 3494 | 54 |
1764988 | 1764988 | 2021-09-29 | Madison | Florida | 12079 | 3494 | 54 |
1761739 | 1761739 | 2021-09-28 | Madison | Florida | 12079 | 3494 | 54 |
1758491 | 1758491 | 2021-09-27 | Madison | Florida | 12079 | 3494 | 54 |
1755243 | 1755243 | 2021-09-26 | Madison | Florida | 12079 | 3494 | 54 |
1751995 | 1751995 | 2021-09-25 | Madison | Florida | 12079 | 3494 | 54 |
1748746 | 1748746 | 2021-09-24 | Madison | Florida | 12079 | 3494 | 52 |
1745496 | 1745496 | 2021-09-23 | Madison | Florida | 12079 | 3418 | 52 |
1742247 | 1742247 | 2021-09-22 | Madison | Florida | 12079 | 3418 | 52 |
1738998 | 1738998 | 2021-09-21 | Madison | Florida | 12079 | 3418 | 52 |
1735749 | 1735749 | 2021-09-20 | Madison | Florida | 12079 | 3418 | 52 |
1732499 | 1732499 | 2021-09-19 | Madison | Florida | 12079 | 3418 | 52 |
1729249 | 1729249 | 2021-09-18 | Madison | Florida | 12079 | 3418 | 52 |
1725999 | 1725999 | 2021-09-17 | Madison | Florida | 12079 | 3418 | 52 |
1722750 | 1722750 | 2021-09-16 | Madison | Florida | 12079 | 3308 | 52 |
1719501 | 1719501 | 2021-09-15 | Madison | Florida | 12079 | 3308 | 52 |
1716253 | 1716253 | 2021-09-14 | Madison | Florida | 12079 | 3308 | 52 |
1713007 | 1713007 | 2021-09-13 | Madison | Florida | 12079 | 3308 | 45 |
1709760 | 1709760 | 2021-09-12 | Madison | Florida | 12079 | 3308 | 45 |
1706513 | 1706513 | 2021-09-11 | Madison | Florida | 12079 | 3308 | 45 |
1703265 | 1703265 | 2021-09-10 | Madison | Florida | 12079 | 3308 | 45 |
1700015 | 1700015 | 2021-09-09 | Madison | Florida | 12079 | 3118 | 45 |
1696766 | 1696766 | 2021-09-08 | Madison | Florida | 12079 | 3118 | 45 |
1693518 | 1693518 | 2021-09-07 | Madison | Florida | 12079 | 3118 | 45 |
1690269 | 1690269 | 2021-09-06 | Madison | Florida | 12079 | 3118 | 45 |
1687019 | 1687019 | 2021-09-05 | Madison | Florida | 12079 | 3118 | 45 |
1683769 | 1683769 | 2021-09-04 | Madison | Florida | 12079 | 3118 | 45 |
1680518 | 1680518 | 2021-09-03 | Madison | Florida | 12079 | 3118 | 45 |
1677270 | 1677270 | 2021-09-02 | Madison | Florida | 12079 | 2893 | 45 |
1674023 | 1674023 | 2021-09-01 | Madison | Florida | 12079 | 2893 | 45 |
1670775 | 1670775 | 2021-08-31 | Madison | Florida | 12079 | 2893 | 45 |
1667528 | 1667528 | 2021-08-30 | Madison | Florida | 12079 | 2893 | 45 |
1664281 | 1664281 | 2021-08-29 | Madison | Florida | 12079 | 2893 | 45 |
1661033 | 1661033 | 2021-08-28 | Madison | Florida | 12079 | 2893 | 45 |
1657785 | 1657785 | 2021-08-27 | Madison | Florida | 12079 | 2893 | 45 |
1654537 | 1654537 | 2021-08-26 | Madison | Florida | 12079 | 2681 | 45 |
1651290 | 1651290 | 2021-08-25 | Madison | Florida | 12079 | 2681 | 45 |
1648041 | 1648041 | 2021-08-24 | Madison | Florida | 12079 | 2681 | 45 |
1644793 | 1644793 | 2021-08-23 | Madison | Florida | 12079 | 2681 | 45 |
1641543 | 1641543 | 2021-08-22 | Madison | Florida | 12079 | 2681 | 45 |
1638293 | 1638293 | 2021-08-21 | Madison | Florida | 12079 | 2681 | 45 |
1635043 | 1635043 | 2021-08-20 | Madison | Florida | 12079 | 2681 | 45 |
1631794 | 1631794 | 2021-08-19 | Madison | Florida | 12079 | 2521 | 45 |
1628547 | 1628547 | 2021-08-18 | Madison | Florida | 12079 | 2521 | 45 |
1625300 | 1625300 | 2021-08-17 | Madison | Florida | 12079 | 2521 | 45 |
1622053 | 1622053 | 2021-08-16 | Madison | Florida | 12079 | 2521 | 45 |
1618806 | 1618806 | 2021-08-15 | Madison | Florida | 12079 | 2521 | 45 |
1615558 | 1615558 | 2021-08-14 | Madison | Florida | 12079 | 2521 | 45 |
1612309 | 1612309 | 2021-08-13 | Madison | Florida | 12079 | 2521 | 45 |
1609061 | 1609061 | 2021-08-12 | Madison | Florida | 12079 | 2388 | 45 |
1605812 | 1605812 | 2021-08-11 | Madison | Florida | 12079 | 2388 | 45 |
1602563 | 1602563 | 2021-08-10 | Madison | Florida | 12079 | 2388 | 45 |
1599314 | 1599314 | 2021-08-09 | Madison | Florida | 12079 | 2388 | 45 |
1596065 | 1596065 | 2021-08-08 | Madison | Florida | 12079 | 2388 | 45 |
1592816 | 1592816 | 2021-08-07 | Madison | Florida | 12079 | 2388 | 45 |
1589567 | 1589567 | 2021-08-06 | Madison | Florida | 12079 | 2388 | 45 |
1586318 | 1586318 | 2021-08-05 | Madison | Florida | 12079 | 2235 | 45 |
1583068 | 1583068 | 2021-08-04 | Madison | Florida | 12079 | 2235 | 45 |
1579818 | 1579818 | 2021-08-03 | Madison | Florida | 12079 | 2235 | 45 |
1576570 | 1576570 | 2021-08-02 | Madison | Florida | 12079 | 2235 | 45 |
1573322 | 1573322 | 2021-08-01 | Madison | Florida | 12079 | 2235 | 45 |
1570074 | 1570074 | 2021-07-31 | Madison | Florida | 12079 | 2235 | 45 |
1566826 | 1566826 | 2021-07-30 | Madison | Florida | 12079 | 2235 | 45 |
1563578 | 1563578 | 2021-07-29 | Madison | Florida | 12079 | 2150 | 45 |
1560330 | 1560330 | 2021-07-28 | Madison | Florida | 12079 | 2150 | 45 |
1557083 | 1557083 | 2021-07-27 | Madison | Florida | 12079 | 2150 | 45 |
1553836 | 1553836 | 2021-07-26 | Madison | Florida | 12079 | 2150 | 45 |
1550589 | 1550589 | 2021-07-25 | Madison | Florida | 12079 | 2150 | 45 |
1547342 | 1547342 | 2021-07-24 | Madison | Florida | 12079 | 2150 | 45 |
1544095 | 1544095 | 2021-07-23 | Madison | Florida | 12079 | 2150 | 45 |
1540847 | 1540847 | 2021-07-22 | Madison | Florida | 12079 | 2116 | 45 |
1537600 | 1537600 | 2021-07-21 | Madison | Florida | 12079 | 2116 | 45 |
1534352 | 1534352 | 2021-07-20 | Madison | Florida | 12079 | 2116 | 45 |
1531105 | 1531105 | 2021-07-19 | Madison | Florida | 12079 | 2116 | 45 |
1527858 | 1527858 | 2021-07-18 | Madison | Florida | 12079 | 2116 | 45 |
1524611 | 1524611 | 2021-07-17 | Madison | Florida | 12079 | 2116 | 45 |
1521363 | 1521363 | 2021-07-16 | Madison | Florida | 12079 | 2116 | 45 |
1518115 | 1518115 | 2021-07-15 | Madison | Florida | 12079 | 2099 | 45 |
1514868 | 1514868 | 2021-07-14 | Madison | Florida | 12079 | 2099 | 45 |
1511622 | 1511622 | 2021-07-13 | Madison | Florida | 12079 | 2099 | 45 |
1508375 | 1508375 | 2021-07-12 | Madison | Florida | 12079 | 2099 | 45 |
1505129 | 1505129 | 2021-07-11 | Madison | Florida | 12079 | 2099 | 45 |
1501883 | 1501883 | 2021-07-10 | Madison | Florida | 12079 | 2099 | 45 |
1498637 | 1498637 | 2021-07-09 | Madison | Florida | 12079 | 2099 | 45 |
1495390 | 1495390 | 2021-07-08 | Madison | Florida | 12079 | 2086 | 45 |
1492144 | 1492144 | 2021-07-07 | Madison | Florida | 12079 | 2086 | 45 |
1488897 | 1488897 | 2021-07-06 | Madison | Florida | 12079 | 2086 | 45 |
1485650 | 1485650 | 2021-07-05 | Madison | Florida | 12079 | 2086 | 45 |
1482404 | 1482404 | 2021-07-04 | Madison | Florida | 12079 | 2086 | 45 |
1479157 | 1479157 | 2021-07-03 | Madison | Florida | 12079 | 2086 | 45 |
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);