ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 12101 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1839730 | 1839730 | 2021-10-22 | Pasco | Florida | 12101 | 78907 | 1511 |
1836481 | 1836481 | 2021-10-21 | Pasco | Florida | 12101 | 78642 | 1511 |
1833232 | 1833232 | 2021-10-20 | Pasco | Florida | 12101 | 78642 | 1511 |
1829983 | 1829983 | 2021-10-19 | Pasco | Florida | 12101 | 78642 | 1511 |
1826734 | 1826734 | 2021-10-18 | Pasco | Florida | 12101 | 78642 | 1511 |
1823485 | 1823485 | 2021-10-17 | Pasco | Florida | 12101 | 78642 | 1466 |
1820236 | 1820236 | 2021-10-16 | Pasco | Florida | 12101 | 78642 | 1466 |
1816987 | 1816987 | 2021-10-15 | Pasco | Florida | 12101 | 78642 | 1466 |
1813739 | 1813739 | 2021-10-14 | Pasco | Florida | 12101 | 78245 | 1406 |
1810490 | 1810490 | 2021-10-13 | Pasco | Florida | 12101 | 78245 | 1406 |
1807241 | 1807241 | 2021-10-12 | Pasco | Florida | 12101 | 78245 | 1406 |
1803990 | 1803990 | 2021-10-11 | Pasco | Florida | 12101 | 78245 | 1406 |
1800741 | 1800741 | 2021-10-10 | Pasco | Florida | 12101 | 78245 | 1406 |
1797492 | 1797492 | 2021-10-09 | Pasco | Florida | 12101 | 78245 | 1406 |
1794243 | 1794243 | 2021-10-08 | Pasco | Florida | 12101 | 78245 | 1406 |
1790995 | 1790995 | 2021-10-07 | Pasco | Florida | 12101 | 77645 | 1406 |
1787746 | 1787746 | 2021-10-06 | Pasco | Florida | 12101 | 77645 | 1406 |
1784497 | 1784497 | 2021-10-05 | Pasco | Florida | 12101 | 77645 | 1406 |
1781248 | 1781248 | 2021-10-04 | Pasco | Florida | 12101 | 77645 | 1406 |
1777998 | 1777998 | 2021-10-03 | Pasco | Florida | 12101 | 77645 | 1406 |
1774748 | 1774748 | 2021-10-02 | Pasco | Florida | 12101 | 77645 | 1355 |
1771498 | 1771498 | 2021-10-01 | Pasco | Florida | 12101 | 77645 | 1355 |
1768249 | 1768249 | 2021-09-30 | Pasco | Florida | 12101 | 76559 | 1355 |
1765000 | 1765000 | 2021-09-29 | Pasco | Florida | 12101 | 76559 | 1355 |
1761751 | 1761751 | 2021-09-28 | Pasco | Florida | 12101 | 76559 | 1355 |
1758503 | 1758503 | 2021-09-27 | Pasco | Florida | 12101 | 76559 | 1355 |
1755255 | 1755255 | 2021-09-26 | Pasco | Florida | 12101 | 76559 | 1355 |
1752007 | 1752007 | 2021-09-25 | Pasco | Florida | 12101 | 76559 | 1355 |
1748758 | 1748758 | 2021-09-24 | Pasco | Florida | 12101 | 76559 | 1275 |
1745508 | 1745508 | 2021-09-23 | Pasco | Florida | 12101 | 74913 | 1275 |
1742259 | 1742259 | 2021-09-22 | Pasco | Florida | 12101 | 74913 | 1275 |
1739010 | 1739010 | 2021-09-21 | Pasco | Florida | 12101 | 74913 | 1275 |
1735761 | 1735761 | 2021-09-20 | Pasco | Florida | 12101 | 74913 | 1275 |
1732511 | 1732511 | 2021-09-19 | Pasco | Florida | 12101 | 74913 | 1275 |
1729261 | 1729261 | 2021-09-18 | Pasco | Florida | 12101 | 74913 | 1275 |
1726011 | 1726011 | 2021-09-17 | Pasco | Florida | 12101 | 74913 | 1173 |
1722762 | 1722762 | 2021-09-16 | Pasco | Florida | 12101 | 72254 | 1173 |
1719513 | 1719513 | 2021-09-15 | Pasco | Florida | 12101 | 72254 | 1173 |
1716265 | 1716265 | 2021-09-14 | Pasco | Florida | 12101 | 72254 | 1173 |
1713019 | 1713019 | 2021-09-13 | Pasco | Florida | 12101 | 72254 | 802 |
1709772 | 1709772 | 2021-09-12 | Pasco | Florida | 12101 | 72254 | 802 |
1706525 | 1706525 | 2021-09-11 | Pasco | Florida | 12101 | 72254 | 802 |
1703277 | 1703277 | 2021-09-10 | Pasco | Florida | 12101 | 72254 | 802 |
1700027 | 1700027 | 2021-09-09 | Pasco | Florida | 12101 | 68963 | 802 |
1696778 | 1696778 | 2021-09-08 | Pasco | Florida | 12101 | 68963 | 802 |
1693530 | 1693530 | 2021-09-07 | Pasco | Florida | 12101 | 68963 | 802 |
1690281 | 1690281 | 2021-09-06 | Pasco | Florida | 12101 | 68963 | 802 |
1687031 | 1687031 | 2021-09-05 | Pasco | Florida | 12101 | 68963 | 802 |
1683781 | 1683781 | 2021-09-04 | Pasco | Florida | 12101 | 68963 | 802 |
1680530 | 1680530 | 2021-09-03 | Pasco | Florida | 12101 | 68963 | 802 |
1677282 | 1677282 | 2021-09-02 | Pasco | Florida | 12101 | 65142 | 802 |
1674035 | 1674035 | 2021-09-01 | Pasco | Florida | 12101 | 65142 | 802 |
1670787 | 1670787 | 2021-08-31 | Pasco | Florida | 12101 | 65142 | 802 |
1667540 | 1667540 | 2021-08-30 | Pasco | Florida | 12101 | 65142 | 802 |
1664293 | 1664293 | 2021-08-29 | Pasco | Florida | 12101 | 65142 | 802 |
1661045 | 1661045 | 2021-08-28 | Pasco | Florida | 12101 | 65142 | 802 |
1657797 | 1657797 | 2021-08-27 | Pasco | Florida | 12101 | 65142 | 802 |
1654549 | 1654549 | 2021-08-26 | Pasco | Florida | 12101 | 60753 | 802 |
1651302 | 1651302 | 2021-08-25 | Pasco | Florida | 12101 | 60753 | 802 |
1648053 | 1648053 | 2021-08-24 | Pasco | Florida | 12101 | 60753 | 802 |
1644805 | 1644805 | 2021-08-23 | Pasco | Florida | 12101 | 60753 | 802 |
1641555 | 1641555 | 2021-08-22 | Pasco | Florida | 12101 | 60753 | 802 |
1638305 | 1638305 | 2021-08-21 | Pasco | Florida | 12101 | 60753 | 802 |
1635055 | 1635055 | 2021-08-20 | Pasco | Florida | 12101 | 60753 | 802 |
1631806 | 1631806 | 2021-08-19 | Pasco | Florida | 12101 | 56511 | 802 |
1628559 | 1628559 | 2021-08-18 | Pasco | Florida | 12101 | 56511 | 802 |
1625312 | 1625312 | 2021-08-17 | Pasco | Florida | 12101 | 56511 | 802 |
1622065 | 1622065 | 2021-08-16 | Pasco | Florida | 12101 | 56511 | 802 |
1618818 | 1618818 | 2021-08-15 | Pasco | Florida | 12101 | 56511 | 802 |
1615570 | 1615570 | 2021-08-14 | Pasco | Florida | 12101 | 56511 | 802 |
1612321 | 1612321 | 2021-08-13 | Pasco | Florida | 12101 | 56511 | 802 |
1609073 | 1609073 | 2021-08-12 | Pasco | Florida | 12101 | 52639 | 802 |
1605824 | 1605824 | 2021-08-11 | Pasco | Florida | 12101 | 52639 | 802 |
1602575 | 1602575 | 2021-08-10 | Pasco | Florida | 12101 | 52639 | 802 |
1599326 | 1599326 | 2021-08-09 | Pasco | Florida | 12101 | 52639 | 802 |
1596077 | 1596077 | 2021-08-08 | Pasco | Florida | 12101 | 52639 | 802 |
1592828 | 1592828 | 2021-08-07 | Pasco | Florida | 12101 | 52639 | 802 |
1589579 | 1589579 | 2021-08-06 | Pasco | Florida | 12101 | 52639 | 802 |
1586330 | 1586330 | 2021-08-05 | Pasco | Florida | 12101 | 49233 | 802 |
1583080 | 1583080 | 2021-08-04 | Pasco | Florida | 12101 | 49233 | 802 |
1579830 | 1579830 | 2021-08-03 | Pasco | Florida | 12101 | 49233 | 802 |
1576582 | 1576582 | 2021-08-02 | Pasco | Florida | 12101 | 49233 | 802 |
1573334 | 1573334 | 2021-08-01 | Pasco | Florida | 12101 | 49233 | 802 |
1570086 | 1570086 | 2021-07-31 | Pasco | Florida | 12101 | 49233 | 802 |
1566838 | 1566838 | 2021-07-30 | Pasco | Florida | 12101 | 49233 | 802 |
1563590 | 1563590 | 2021-07-29 | Pasco | Florida | 12101 | 46341 | 802 |
1560342 | 1560342 | 2021-07-28 | Pasco | Florida | 12101 | 46341 | 802 |
1557095 | 1557095 | 2021-07-27 | Pasco | Florida | 12101 | 46341 | 802 |
1553848 | 1553848 | 2021-07-26 | Pasco | Florida | 12101 | 46341 | 802 |
1550601 | 1550601 | 2021-07-25 | Pasco | Florida | 12101 | 46341 | 802 |
1547354 | 1547354 | 2021-07-24 | Pasco | Florida | 12101 | 46341 | 802 |
1544107 | 1544107 | 2021-07-23 | Pasco | Florida | 12101 | 46341 | 802 |
1540859 | 1540859 | 2021-07-22 | Pasco | Florida | 12101 | 44705 | 802 |
1537612 | 1537612 | 2021-07-21 | Pasco | Florida | 12101 | 44705 | 802 |
1534364 | 1534364 | 2021-07-20 | Pasco | Florida | 12101 | 44705 | 802 |
1531117 | 1531117 | 2021-07-19 | Pasco | Florida | 12101 | 44705 | 802 |
1527870 | 1527870 | 2021-07-18 | Pasco | Florida | 12101 | 44705 | 802 |
1524623 | 1524623 | 2021-07-17 | Pasco | Florida | 12101 | 44705 | 802 |
1521375 | 1521375 | 2021-07-16 | Pasco | Florida | 12101 | 44705 | 802 |
1518127 | 1518127 | 2021-07-15 | Pasco | Florida | 12101 | 43825 | 802 |
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);