ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
770 rows where fips = 12065 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1810471 | 1810471 | 2021-10-13 | Jefferson | Florida | 12065 | 2435 | 36 |
1807222 | 1807222 | 2021-10-12 | Jefferson | Florida | 12065 | 2435 | 36 |
1803971 | 1803971 | 2021-10-11 | Jefferson | Florida | 12065 | 2435 | 36 |
1800722 | 1800722 | 2021-10-10 | Jefferson | Florida | 12065 | 2435 | 36 |
1797473 | 1797473 | 2021-10-09 | Jefferson | Florida | 12065 | 2435 | 36 |
1794224 | 1794224 | 2021-10-08 | Jefferson | Florida | 12065 | 2435 | 36 |
1790976 | 1790976 | 2021-10-07 | Jefferson | Florida | 12065 | 2418 | 36 |
1787727 | 1787727 | 2021-10-06 | Jefferson | Florida | 12065 | 2418 | 36 |
1784478 | 1784478 | 2021-10-05 | Jefferson | Florida | 12065 | 2418 | 36 |
1781229 | 1781229 | 2021-10-04 | Jefferson | Florida | 12065 | 2418 | 36 |
1777979 | 1777979 | 2021-10-03 | Jefferson | Florida | 12065 | 2418 | 36 |
1774729 | 1774729 | 2021-10-02 | Jefferson | Florida | 12065 | 2418 | 36 |
1771479 | 1771479 | 2021-10-01 | Jefferson | Florida | 12065 | 2418 | 36 |
1768230 | 1768230 | 2021-09-30 | Jefferson | Florida | 12065 | 2400 | 36 |
1764981 | 1764981 | 2021-09-29 | Jefferson | Florida | 12065 | 2400 | 36 |
1761732 | 1761732 | 2021-09-28 | Jefferson | Florida | 12065 | 2400 | 36 |
1758484 | 1758484 | 2021-09-27 | Jefferson | Florida | 12065 | 2400 | 36 |
1755236 | 1755236 | 2021-09-26 | Jefferson | Florida | 12065 | 2400 | 36 |
1751988 | 1751988 | 2021-09-25 | Jefferson | Florida | 12065 | 2400 | 36 |
1748739 | 1748739 | 2021-09-24 | Jefferson | Florida | 12065 | 2400 | 34 |
1745489 | 1745489 | 2021-09-23 | Jefferson | Florida | 12065 | 2341 | 34 |
1742240 | 1742240 | 2021-09-22 | Jefferson | Florida | 12065 | 2341 | 34 |
1738991 | 1738991 | 2021-09-21 | Jefferson | Florida | 12065 | 2341 | 34 |
1735742 | 1735742 | 2021-09-20 | Jefferson | Florida | 12065 | 2341 | 34 |
1732492 | 1732492 | 2021-09-19 | Jefferson | Florida | 12065 | 2341 | 34 |
1729242 | 1729242 | 2021-09-18 | Jefferson | Florida | 12065 | 2341 | 34 |
1725992 | 1725992 | 2021-09-17 | Jefferson | Florida | 12065 | 2341 | 34 |
1722743 | 1722743 | 2021-09-16 | Jefferson | Florida | 12065 | 2279 | 34 |
1719494 | 1719494 | 2021-09-15 | Jefferson | Florida | 12065 | 2279 | 34 |
1716246 | 1716246 | 2021-09-14 | Jefferson | Florida | 12065 | 2279 | 34 |
1713000 | 1713000 | 2021-09-13 | Jefferson | Florida | 12065 | 2279 | 28 |
1709753 | 1709753 | 2021-09-12 | Jefferson | Florida | 12065 | 2279 | 28 |
1706506 | 1706506 | 2021-09-11 | Jefferson | Florida | 12065 | 2279 | 28 |
1703258 | 1703258 | 2021-09-10 | Jefferson | Florida | 12065 | 2279 | 28 |
1700008 | 1700008 | 2021-09-09 | Jefferson | Florida | 12065 | 2185 | 28 |
1696759 | 1696759 | 2021-09-08 | Jefferson | Florida | 12065 | 2185 | 28 |
1693511 | 1693511 | 2021-09-07 | Jefferson | Florida | 12065 | 2185 | 28 |
1690262 | 1690262 | 2021-09-06 | Jefferson | Florida | 12065 | 2185 | 28 |
1687012 | 1687012 | 2021-09-05 | Jefferson | Florida | 12065 | 2185 | 28 |
1683762 | 1683762 | 2021-09-04 | Jefferson | Florida | 12065 | 2185 | 28 |
1680511 | 1680511 | 2021-09-03 | Jefferson | Florida | 12065 | 2185 | 28 |
1677263 | 1677263 | 2021-09-02 | Jefferson | Florida | 12065 | 2091 | 28 |
1674016 | 1674016 | 2021-09-01 | Jefferson | Florida | 12065 | 2091 | 28 |
1670768 | 1670768 | 2021-08-31 | Jefferson | Florida | 12065 | 2091 | 28 |
1667521 | 1667521 | 2021-08-30 | Jefferson | Florida | 12065 | 2091 | 28 |
1664274 | 1664274 | 2021-08-29 | Jefferson | Florida | 12065 | 2091 | 28 |
1661026 | 1661026 | 2021-08-28 | Jefferson | Florida | 12065 | 2091 | 28 |
1657778 | 1657778 | 2021-08-27 | Jefferson | Florida | 12065 | 2091 | 28 |
1654530 | 1654530 | 2021-08-26 | Jefferson | Florida | 12065 | 1952 | 28 |
1651283 | 1651283 | 2021-08-25 | Jefferson | Florida | 12065 | 1952 | 28 |
1648034 | 1648034 | 2021-08-24 | Jefferson | Florida | 12065 | 1952 | 28 |
1644786 | 1644786 | 2021-08-23 | Jefferson | Florida | 12065 | 1952 | 28 |
1641536 | 1641536 | 2021-08-22 | Jefferson | Florida | 12065 | 1952 | 28 |
1638286 | 1638286 | 2021-08-21 | Jefferson | Florida | 12065 | 1952 | 28 |
1635036 | 1635036 | 2021-08-20 | Jefferson | Florida | 12065 | 1952 | 28 |
1631787 | 1631787 | 2021-08-19 | Jefferson | Florida | 12065 | 1823 | 28 |
1628540 | 1628540 | 2021-08-18 | Jefferson | Florida | 12065 | 1823 | 28 |
1625293 | 1625293 | 2021-08-17 | Jefferson | Florida | 12065 | 1823 | 28 |
1622046 | 1622046 | 2021-08-16 | Jefferson | Florida | 12065 | 1823 | 28 |
1618799 | 1618799 | 2021-08-15 | Jefferson | Florida | 12065 | 1823 | 28 |
1615551 | 1615551 | 2021-08-14 | Jefferson | Florida | 12065 | 1823 | 28 |
1612302 | 1612302 | 2021-08-13 | Jefferson | Florida | 12065 | 1823 | 28 |
1609054 | 1609054 | 2021-08-12 | Jefferson | Florida | 12065 | 1702 | 28 |
1605805 | 1605805 | 2021-08-11 | Jefferson | Florida | 12065 | 1702 | 28 |
1602556 | 1602556 | 2021-08-10 | Jefferson | Florida | 12065 | 1702 | 28 |
1599307 | 1599307 | 2021-08-09 | Jefferson | Florida | 12065 | 1702 | 28 |
1596058 | 1596058 | 2021-08-08 | Jefferson | Florida | 12065 | 1702 | 28 |
1592809 | 1592809 | 2021-08-07 | Jefferson | Florida | 12065 | 1702 | 28 |
1589560 | 1589560 | 2021-08-06 | Jefferson | Florida | 12065 | 1702 | 28 |
1586311 | 1586311 | 2021-08-05 | Jefferson | Florida | 12065 | 1623 | 28 |
1583061 | 1583061 | 2021-08-04 | Jefferson | Florida | 12065 | 1623 | 28 |
1579811 | 1579811 | 2021-08-03 | Jefferson | Florida | 12065 | 1623 | 28 |
1576563 | 1576563 | 2021-08-02 | Jefferson | Florida | 12065 | 1623 | 28 |
1573315 | 1573315 | 2021-08-01 | Jefferson | Florida | 12065 | 1623 | 28 |
1570067 | 1570067 | 2021-07-31 | Jefferson | Florida | 12065 | 1623 | 28 |
1566819 | 1566819 | 2021-07-30 | Jefferson | Florida | 12065 | 1623 | 28 |
1563571 | 1563571 | 2021-07-29 | Jefferson | Florida | 12065 | 1556 | 28 |
1560323 | 1560323 | 2021-07-28 | Jefferson | Florida | 12065 | 1556 | 28 |
1557076 | 1557076 | 2021-07-27 | Jefferson | Florida | 12065 | 1556 | 28 |
1553829 | 1553829 | 2021-07-26 | Jefferson | Florida | 12065 | 1556 | 28 |
1550582 | 1550582 | 2021-07-25 | Jefferson | Florida | 12065 | 1556 | 28 |
1547335 | 1547335 | 2021-07-24 | Jefferson | Florida | 12065 | 1556 | 28 |
1544088 | 1544088 | 2021-07-23 | Jefferson | Florida | 12065 | 1556 | 28 |
1540840 | 1540840 | 2021-07-22 | Jefferson | Florida | 12065 | 1524 | 28 |
1537593 | 1537593 | 2021-07-21 | Jefferson | Florida | 12065 | 1524 | 28 |
1534345 | 1534345 | 2021-07-20 | Jefferson | Florida | 12065 | 1524 | 28 |
1531098 | 1531098 | 2021-07-19 | Jefferson | Florida | 12065 | 1524 | 28 |
1527851 | 1527851 | 2021-07-18 | Jefferson | Florida | 12065 | 1524 | 28 |
1524604 | 1524604 | 2021-07-17 | Jefferson | Florida | 12065 | 1524 | 28 |
1521356 | 1521356 | 2021-07-16 | Jefferson | Florida | 12065 | 1524 | 28 |
1518108 | 1518108 | 2021-07-15 | Jefferson | Florida | 12065 | 1516 | 28 |
1514861 | 1514861 | 2021-07-14 | Jefferson | Florida | 12065 | 1516 | 28 |
1511615 | 1511615 | 2021-07-13 | Jefferson | Florida | 12065 | 1516 | 28 |
1508368 | 1508368 | 2021-07-12 | Jefferson | Florida | 12065 | 1516 | 28 |
1505122 | 1505122 | 2021-07-11 | Jefferson | Florida | 12065 | 1516 | 28 |
1501876 | 1501876 | 2021-07-10 | Jefferson | Florida | 12065 | 1516 | 28 |
1498630 | 1498630 | 2021-07-09 | Jefferson | Florida | 12065 | 1516 | 28 |
1495383 | 1495383 | 2021-07-08 | Jefferson | Florida | 12065 | 1506 | 28 |
1492137 | 1492137 | 2021-07-07 | Jefferson | Florida | 12065 | 1506 | 28 |
1488890 | 1488890 | 2021-07-06 | Jefferson | Florida | 12065 | 1506 | 28 |
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);