ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where county = "St. Johns" and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1716272 | 1716272 | 2021-09-14 | St. Johns | Florida | 12109 | 36945 | 370 |
1713026 | 1713026 | 2021-09-13 | St. Johns | Florida | 12109 | 36945 | 221 |
1709779 | 1709779 | 2021-09-12 | St. Johns | Florida | 12109 | 36945 | 221 |
1706532 | 1706532 | 2021-09-11 | St. Johns | Florida | 12109 | 36945 | 221 |
1703284 | 1703284 | 2021-09-10 | St. Johns | Florida | 12109 | 36945 | 221 |
1700034 | 1700034 | 2021-09-09 | St. Johns | Florida | 12109 | 35510 | 221 |
1696785 | 1696785 | 2021-09-08 | St. Johns | Florida | 12109 | 35510 | 221 |
1693537 | 1693537 | 2021-09-07 | St. Johns | Florida | 12109 | 35510 | 221 |
1690288 | 1690288 | 2021-09-06 | St. Johns | Florida | 12109 | 35510 | 221 |
1687038 | 1687038 | 2021-09-05 | St. Johns | Florida | 12109 | 35510 | 221 |
1683788 | 1683788 | 2021-09-04 | St. Johns | Florida | 12109 | 35510 | 221 |
1680537 | 1680537 | 2021-09-03 | St. Johns | Florida | 12109 | 35510 | 221 |
1677289 | 1677289 | 2021-09-02 | St. Johns | Florida | 12109 | 33917 | 221 |
1674042 | 1674042 | 2021-09-01 | St. Johns | Florida | 12109 | 33917 | 221 |
1670794 | 1670794 | 2021-08-31 | St. Johns | Florida | 12109 | 33917 | 221 |
1667547 | 1667547 | 2021-08-30 | St. Johns | Florida | 12109 | 33917 | 221 |
1664300 | 1664300 | 2021-08-29 | St. Johns | Florida | 12109 | 33917 | 221 |
1661052 | 1661052 | 2021-08-28 | St. Johns | Florida | 12109 | 33917 | 221 |
1657804 | 1657804 | 2021-08-27 | St. Johns | Florida | 12109 | 33917 | 221 |
1654556 | 1654556 | 2021-08-26 | St. Johns | Florida | 12109 | 32456 | 221 |
1651309 | 1651309 | 2021-08-25 | St. Johns | Florida | 12109 | 32456 | 221 |
1648060 | 1648060 | 2021-08-24 | St. Johns | Florida | 12109 | 32456 | 221 |
1644812 | 1644812 | 2021-08-23 | St. Johns | Florida | 12109 | 32456 | 221 |
1641562 | 1641562 | 2021-08-22 | St. Johns | Florida | 12109 | 32456 | 221 |
1638312 | 1638312 | 2021-08-21 | St. Johns | Florida | 12109 | 32456 | 221 |
1635062 | 1635062 | 2021-08-20 | St. Johns | Florida | 12109 | 32456 | 221 |
1631813 | 1631813 | 2021-08-19 | St. Johns | Florida | 12109 | 31195 | 221 |
1628566 | 1628566 | 2021-08-18 | St. Johns | Florida | 12109 | 31195 | 221 |
1625319 | 1625319 | 2021-08-17 | St. Johns | Florida | 12109 | 31195 | 221 |
1622072 | 1622072 | 2021-08-16 | St. Johns | Florida | 12109 | 31195 | 221 |
1618825 | 1618825 | 2021-08-15 | St. Johns | Florida | 12109 | 31195 | 221 |
1615577 | 1615577 | 2021-08-14 | St. Johns | Florida | 12109 | 31195 | 221 |
1612328 | 1612328 | 2021-08-13 | St. Johns | Florida | 12109 | 31195 | 221 |
1609080 | 1609080 | 2021-08-12 | St. Johns | Florida | 12109 | 29676 | 221 |
1605831 | 1605831 | 2021-08-11 | St. Johns | Florida | 12109 | 29676 | 221 |
1602582 | 1602582 | 2021-08-10 | St. Johns | Florida | 12109 | 29676 | 221 |
1599333 | 1599333 | 2021-08-09 | St. Johns | Florida | 12109 | 29676 | 221 |
1596084 | 1596084 | 2021-08-08 | St. Johns | Florida | 12109 | 29676 | 221 |
1592835 | 1592835 | 2021-08-07 | St. Johns | Florida | 12109 | 29676 | 221 |
1589586 | 1589586 | 2021-08-06 | St. Johns | Florida | 12109 | 29676 | 221 |
1586337 | 1586337 | 2021-08-05 | St. Johns | Florida | 12109 | 27916 | 221 |
1583087 | 1583087 | 2021-08-04 | St. Johns | Florida | 12109 | 27916 | 221 |
1579837 | 1579837 | 2021-08-03 | St. Johns | Florida | 12109 | 27916 | 221 |
1576589 | 1576589 | 2021-08-02 | St. Johns | Florida | 12109 | 27916 | 221 |
1573341 | 1573341 | 2021-08-01 | St. Johns | Florida | 12109 | 27916 | 221 |
1570093 | 1570093 | 2021-07-31 | St. Johns | Florida | 12109 | 27916 | 221 |
1566845 | 1566845 | 2021-07-30 | St. Johns | Florida | 12109 | 27916 | 221 |
1563597 | 1563597 | 2021-07-29 | St. Johns | Florida | 12109 | 26276 | 221 |
1560349 | 1560349 | 2021-07-28 | St. Johns | Florida | 12109 | 26276 | 221 |
1557102 | 1557102 | 2021-07-27 | St. Johns | Florida | 12109 | 26276 | 221 |
1553855 | 1553855 | 2021-07-26 | St. Johns | Florida | 12109 | 26276 | 221 |
1550608 | 1550608 | 2021-07-25 | St. Johns | Florida | 12109 | 26276 | 221 |
1547361 | 1547361 | 2021-07-24 | St. Johns | Florida | 12109 | 26276 | 221 |
1544114 | 1544114 | 2021-07-23 | St. Johns | Florida | 12109 | 26276 | 221 |
1540866 | 1540866 | 2021-07-22 | St. Johns | Florida | 12109 | 24997 | 221 |
1537619 | 1537619 | 2021-07-21 | St. Johns | Florida | 12109 | 24997 | 221 |
1534371 | 1534371 | 2021-07-20 | St. Johns | Florida | 12109 | 24997 | 221 |
1531124 | 1531124 | 2021-07-19 | St. Johns | Florida | 12109 | 24997 | 221 |
1527877 | 1527877 | 2021-07-18 | St. Johns | Florida | 12109 | 24997 | 221 |
1524630 | 1524630 | 2021-07-17 | St. Johns | Florida | 12109 | 24997 | 221 |
1521382 | 1521382 | 2021-07-16 | St. Johns | Florida | 12109 | 24997 | 221 |
1518134 | 1518134 | 2021-07-15 | St. Johns | Florida | 12109 | 24276 | 221 |
1514887 | 1514887 | 2021-07-14 | St. Johns | Florida | 12109 | 24276 | 221 |
1511641 | 1511641 | 2021-07-13 | St. Johns | Florida | 12109 | 24276 | 221 |
1508394 | 1508394 | 2021-07-12 | St. Johns | Florida | 12109 | 24276 | 221 |
1505148 | 1505148 | 2021-07-11 | St. Johns | Florida | 12109 | 24276 | 221 |
1501902 | 1501902 | 2021-07-10 | St. Johns | Florida | 12109 | 24276 | 221 |
1498656 | 1498656 | 2021-07-09 | St. Johns | Florida | 12109 | 24276 | 221 |
1495409 | 1495409 | 2021-07-08 | St. Johns | Florida | 12109 | 23854 | 221 |
1492163 | 1492163 | 2021-07-07 | St. Johns | Florida | 12109 | 23854 | 221 |
1488916 | 1488916 | 2021-07-06 | St. Johns | Florida | 12109 | 23854 | 221 |
1485669 | 1485669 | 2021-07-05 | St. Johns | Florida | 12109 | 23854 | 221 |
1482423 | 1482423 | 2021-07-04 | St. Johns | Florida | 12109 | 23854 | 221 |
1479176 | 1479176 | 2021-07-03 | St. Johns | Florida | 12109 | 23854 | 221 |
1475930 | 1475930 | 2021-07-02 | St. Johns | Florida | 12109 | 23854 | 221 |
1472684 | 1472684 | 2021-07-01 | St. Johns | Florida | 12109 | 23546 | 221 |
1469438 | 1469438 | 2021-06-30 | St. Johns | Florida | 12109 | 23546 | 221 |
1466193 | 1466193 | 2021-06-29 | St. Johns | Florida | 12109 | 23546 | 221 |
1462948 | 1462948 | 2021-06-28 | St. Johns | Florida | 12109 | 23546 | 221 |
1459703 | 1459703 | 2021-06-27 | St. Johns | Florida | 12109 | 23546 | 221 |
1456458 | 1456458 | 2021-06-26 | St. Johns | Florida | 12109 | 23546 | 221 |
1453213 | 1453213 | 2021-06-25 | St. Johns | Florida | 12109 | 23546 | 221 |
1449967 | 1449967 | 2021-06-24 | St. Johns | Florida | 12109 | 23278 | 221 |
1446722 | 1446722 | 2021-06-23 | St. Johns | Florida | 12109 | 23278 | 221 |
1443477 | 1443477 | 2021-06-22 | St. Johns | Florida | 12109 | 23278 | 221 |
1440232 | 1440232 | 2021-06-21 | St. Johns | Florida | 12109 | 23278 | 221 |
1436985 | 1436985 | 2021-06-20 | St. Johns | Florida | 12109 | 23278 | 221 |
1433738 | 1433738 | 2021-06-19 | St. Johns | Florida | 12109 | 23278 | 221 |
1430492 | 1430492 | 2021-06-18 | St. Johns | Florida | 12109 | 23278 | 221 |
1427247 | 1427247 | 2021-06-17 | St. Johns | Florida | 12109 | 23131 | 221 |
1424002 | 1424002 | 2021-06-16 | St. Johns | Florida | 12109 | 23131 | 221 |
1420754 | 1420754 | 2021-06-15 | St. Johns | Florida | 12109 | 23131 | 221 |
1417509 | 1417509 | 2021-06-14 | St. Johns | Florida | 12109 | 23131 | 221 |
1414263 | 1414263 | 2021-06-13 | St. Johns | Florida | 12109 | 23131 | 221 |
1411018 | 1411018 | 2021-06-12 | St. Johns | Florida | 12109 | 23131 | 221 |
1407773 | 1407773 | 2021-06-11 | St. Johns | Florida | 12109 | 23131 | 221 |
1404527 | 1404527 | 2021-06-10 | St. Johns | Florida | 12109 | 23020 | 221 |
1401282 | 1401282 | 2021-06-09 | St. Johns | Florida | 12109 | 23020 | 221 |
1398037 | 1398037 | 2021-06-08 | St. Johns | Florida | 12109 | 23020 | 221 |
1394790 | 1394790 | 2021-06-07 | St. Johns | Florida | 12109 | 23020 | 221 |
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);