ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
407 rows where deaths = 19 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Glades 178
- Liberty 47
- Gilchrist 28
- Lafayette 18
- Levy 12
- Bradford 11
- Dixie 9
- Baker 6
- Holmes 6
- Osceola 6
- Clay 5
- Hardee 5
- Santa Rosa 5
- Gulf 4
- Hendry 4
- Hillsborough 4
- Jefferson 4
- Lake 4
- Brevard 3
- Calhoun 3
- Escambia 3
- Nassau 3
- St. Lucie 3
- Suwannee 3
- Flagler 2
- Madison 2
- Manatee 2
- Martin 2
- Monroe 2
- Okeechobee 2
- …
state 1
- Florida · 407 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1865712 | 1865712 | 2021-10-30 | Liberty | Florida | 12077 | 1827 | 19 |
1862463 | 1862463 | 2021-10-29 | Liberty | Florida | 12077 | 1827 | 19 |
1859214 | 1859214 | 2021-10-28 | Liberty | Florida | 12077 | 1823 | 19 |
1855965 | 1855965 | 2021-10-27 | Liberty | Florida | 12077 | 1823 | 19 |
1852716 | 1852716 | 2021-10-26 | Liberty | Florida | 12077 | 1823 | 19 |
1849467 | 1849467 | 2021-10-25 | Liberty | Florida | 12077 | 1823 | 19 |
1846217 | 1846217 | 2021-10-24 | Liberty | Florida | 12077 | 1823 | 19 |
1842967 | 1842967 | 2021-10-23 | Liberty | Florida | 12077 | 1823 | 19 |
1839717 | 1839717 | 2021-10-22 | Liberty | Florida | 12077 | 1823 | 19 |
1836468 | 1836468 | 2021-10-21 | Liberty | Florida | 12077 | 1815 | 19 |
1833219 | 1833219 | 2021-10-20 | Liberty | Florida | 12077 | 1815 | 19 |
1829970 | 1829970 | 2021-10-19 | Liberty | Florida | 12077 | 1815 | 19 |
1826721 | 1826721 | 2021-10-18 | Liberty | Florida | 12077 | 1815 | 19 |
1823472 | 1823472 | 2021-10-17 | Liberty | Florida | 12077 | 1815 | 19 |
1820223 | 1820223 | 2021-10-16 | Liberty | Florida | 12077 | 1815 | 19 |
1816974 | 1816974 | 2021-10-15 | Liberty | Florida | 12077 | 1815 | 19 |
1813726 | 1813726 | 2021-10-14 | Liberty | Florida | 12077 | 1802 | 19 |
1810477 | 1810477 | 2021-10-13 | Liberty | Florida | 12077 | 1802 | 19 |
1807228 | 1807228 | 2021-10-12 | Liberty | Florida | 12077 | 1802 | 19 |
1803977 | 1803977 | 2021-10-11 | Liberty | Florida | 12077 | 1802 | 19 |
1800728 | 1800728 | 2021-10-10 | Liberty | Florida | 12077 | 1802 | 19 |
1797479 | 1797479 | 2021-10-09 | Liberty | Florida | 12077 | 1802 | 19 |
1794230 | 1794230 | 2021-10-08 | Liberty | Florida | 12077 | 1802 | 19 |
1790982 | 1790982 | 2021-10-07 | Liberty | Florida | 12077 | 1787 | 19 |
1787733 | 1787733 | 2021-10-06 | Liberty | Florida | 12077 | 1787 | 19 |
1784484 | 1784484 | 2021-10-05 | Liberty | Florida | 12077 | 1787 | 19 |
1781235 | 1781235 | 2021-10-04 | Liberty | Florida | 12077 | 1787 | 19 |
1777985 | 1777985 | 2021-10-03 | Liberty | Florida | 12077 | 1787 | 19 |
1774735 | 1774735 | 2021-10-02 | Liberty | Florida | 12077 | 1787 | 19 |
1771485 | 1771485 | 2021-10-01 | Liberty | Florida | 12077 | 1787 | 19 |
1768236 | 1768236 | 2021-09-30 | Liberty | Florida | 12077 | 1774 | 19 |
1764987 | 1764987 | 2021-09-29 | Liberty | Florida | 12077 | 1774 | 19 |
1761738 | 1761738 | 2021-09-28 | Liberty | Florida | 12077 | 1774 | 19 |
1758490 | 1758490 | 2021-09-27 | Liberty | Florida | 12077 | 1774 | 19 |
1755242 | 1755242 | 2021-09-26 | Liberty | Florida | 12077 | 1774 | 19 |
1751994 | 1751994 | 2021-09-25 | Liberty | Florida | 12077 | 1774 | 19 |
1748745 | 1748745 | 2021-09-24 | Liberty | Florida | 12077 | 1774 | 19 |
1745495 | 1745495 | 2021-09-23 | Liberty | Florida | 12077 | 1749 | 19 |
1742246 | 1742246 | 2021-09-22 | Liberty | Florida | 12077 | 1749 | 19 |
1738997 | 1738997 | 2021-09-21 | Liberty | Florida | 12077 | 1749 | 19 |
1735748 | 1735748 | 2021-09-20 | Liberty | Florida | 12077 | 1749 | 19 |
1732498 | 1732498 | 2021-09-19 | Liberty | Florida | 12077 | 1749 | 19 |
1729248 | 1729248 | 2021-09-18 | Liberty | Florida | 12077 | 1749 | 19 |
1725998 | 1725998 | 2021-09-17 | Liberty | Florida | 12077 | 1749 | 19 |
1722749 | 1722749 | 2021-09-16 | Liberty | Florida | 12077 | 1705 | 19 |
1719500 | 1719500 | 2021-09-15 | Liberty | Florida | 12077 | 1705 | 19 |
1716252 | 1716252 | 2021-09-14 | Liberty | Florida | 12077 | 1705 | 19 |
1712989 | 1712989 | 2021-09-13 | Glades | Florida | 12043 | 1323 | 19 |
1709742 | 1709742 | 2021-09-12 | Glades | Florida | 12043 | 1323 | 19 |
1706495 | 1706495 | 2021-09-11 | Glades | Florida | 12043 | 1323 | 19 |
1703247 | 1703247 | 2021-09-10 | Glades | Florida | 12043 | 1323 | 19 |
1699997 | 1699997 | 2021-09-09 | Glades | Florida | 12043 | 1273 | 19 |
1696748 | 1696748 | 2021-09-08 | Glades | Florida | 12043 | 1273 | 19 |
1693500 | 1693500 | 2021-09-07 | Glades | Florida | 12043 | 1273 | 19 |
1690251 | 1690251 | 2021-09-06 | Glades | Florida | 12043 | 1273 | 19 |
1687001 | 1687001 | 2021-09-05 | Glades | Florida | 12043 | 1273 | 19 |
1683751 | 1683751 | 2021-09-04 | Glades | Florida | 12043 | 1273 | 19 |
1680500 | 1680500 | 2021-09-03 | Glades | Florida | 12043 | 1273 | 19 |
1677252 | 1677252 | 2021-09-02 | Glades | Florida | 12043 | 1218 | 19 |
1674005 | 1674005 | 2021-09-01 | Glades | Florida | 12043 | 1218 | 19 |
1670757 | 1670757 | 2021-08-31 | Glades | Florida | 12043 | 1218 | 19 |
1667510 | 1667510 | 2021-08-30 | Glades | Florida | 12043 | 1218 | 19 |
1664263 | 1664263 | 2021-08-29 | Glades | Florida | 12043 | 1218 | 19 |
1661015 | 1661015 | 2021-08-28 | Glades | Florida | 12043 | 1218 | 19 |
1657767 | 1657767 | 2021-08-27 | Glades | Florida | 12043 | 1218 | 19 |
1654519 | 1654519 | 2021-08-26 | Glades | Florida | 12043 | 1153 | 19 |
1651272 | 1651272 | 2021-08-25 | Glades | Florida | 12043 | 1153 | 19 |
1648023 | 1648023 | 2021-08-24 | Glades | Florida | 12043 | 1153 | 19 |
1644775 | 1644775 | 2021-08-23 | Glades | Florida | 12043 | 1153 | 19 |
1641525 | 1641525 | 2021-08-22 | Glades | Florida | 12043 | 1153 | 19 |
1638275 | 1638275 | 2021-08-21 | Glades | Florida | 12043 | 1153 | 19 |
1635025 | 1635025 | 2021-08-20 | Glades | Florida | 12043 | 1153 | 19 |
1631776 | 1631776 | 2021-08-19 | Glades | Florida | 12043 | 1094 | 19 |
1628529 | 1628529 | 2021-08-18 | Glades | Florida | 12043 | 1094 | 19 |
1625282 | 1625282 | 2021-08-17 | Glades | Florida | 12043 | 1094 | 19 |
1622035 | 1622035 | 2021-08-16 | Glades | Florida | 12043 | 1094 | 19 |
1618788 | 1618788 | 2021-08-15 | Glades | Florida | 12043 | 1094 | 19 |
1615540 | 1615540 | 2021-08-14 | Glades | Florida | 12043 | 1094 | 19 |
1612291 | 1612291 | 2021-08-13 | Glades | Florida | 12043 | 1094 | 19 |
1609043 | 1609043 | 2021-08-12 | Glades | Florida | 12043 | 1050 | 19 |
1605794 | 1605794 | 2021-08-11 | Glades | Florida | 12043 | 1050 | 19 |
1602545 | 1602545 | 2021-08-10 | Glades | Florida | 12043 | 1050 | 19 |
1599296 | 1599296 | 2021-08-09 | Glades | Florida | 12043 | 1050 | 19 |
1596047 | 1596047 | 2021-08-08 | Glades | Florida | 12043 | 1050 | 19 |
1592798 | 1592798 | 2021-08-07 | Glades | Florida | 12043 | 1050 | 19 |
1589549 | 1589549 | 2021-08-06 | Glades | Florida | 12043 | 1050 | 19 |
1586300 | 1586300 | 2021-08-05 | Glades | Florida | 12043 | 1031 | 19 |
1583050 | 1583050 | 2021-08-04 | Glades | Florida | 12043 | 1031 | 19 |
1579800 | 1579800 | 2021-08-03 | Glades | Florida | 12043 | 1031 | 19 |
1576552 | 1576552 | 2021-08-02 | Glades | Florida | 12043 | 1031 | 19 |
1573304 | 1573304 | 2021-08-01 | Glades | Florida | 12043 | 1031 | 19 |
1570056 | 1570056 | 2021-07-31 | Glades | Florida | 12043 | 1031 | 19 |
1566808 | 1566808 | 2021-07-30 | Glades | Florida | 12043 | 1031 | 19 |
1563560 | 1563560 | 2021-07-29 | Glades | Florida | 12043 | 1022 | 19 |
1560312 | 1560312 | 2021-07-28 | Glades | Florida | 12043 | 1022 | 19 |
1557065 | 1557065 | 2021-07-27 | Glades | Florida | 12043 | 1022 | 19 |
1553818 | 1553818 | 2021-07-26 | Glades | Florida | 12043 | 1022 | 19 |
1550571 | 1550571 | 2021-07-25 | Glades | Florida | 12043 | 1022 | 19 |
1547324 | 1547324 | 2021-07-24 | Glades | Florida | 12043 | 1022 | 19 |
1544077 | 1544077 | 2021-07-23 | Glades | Florida | 12043 | 1022 | 19 |
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);