ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Duval" and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1716229 | 1716229 | 2021-09-14 | Duval | Florida | 12031 | 156313 | 2312 |
1712983 | 1712983 | 2021-09-13 | Duval | Florida | 12031 | 156313 | 1483 |
1709736 | 1709736 | 2021-09-12 | Duval | Florida | 12031 | 156313 | 1483 |
1706489 | 1706489 | 2021-09-11 | Duval | Florida | 12031 | 156313 | 1483 |
1703241 | 1703241 | 2021-09-10 | Duval | Florida | 12031 | 156313 | 1483 |
1699991 | 1699991 | 2021-09-09 | Duval | Florida | 12031 | 153259 | 1483 |
1696742 | 1696742 | 2021-09-08 | Duval | Florida | 12031 | 153259 | 1483 |
1693494 | 1693494 | 2021-09-07 | Duval | Florida | 12031 | 153259 | 1483 |
1690245 | 1690245 | 2021-09-06 | Duval | Florida | 12031 | 153259 | 1483 |
1686995 | 1686995 | 2021-09-05 | Duval | Florida | 12031 | 153259 | 1483 |
1683745 | 1683745 | 2021-09-04 | Duval | Florida | 12031 | 153259 | 1483 |
1680494 | 1680494 | 2021-09-03 | Duval | Florida | 12031 | 153259 | 1483 |
1677246 | 1677246 | 2021-09-02 | Duval | Florida | 12031 | 149122 | 1483 |
1673999 | 1673999 | 2021-09-01 | Duval | Florida | 12031 | 149122 | 1483 |
1670751 | 1670751 | 2021-08-31 | Duval | Florida | 12031 | 149122 | 1483 |
1667504 | 1667504 | 2021-08-30 | Duval | Florida | 12031 | 149122 | 1483 |
1664257 | 1664257 | 2021-08-29 | Duval | Florida | 12031 | 149122 | 1483 |
1661009 | 1661009 | 2021-08-28 | Duval | Florida | 12031 | 149122 | 1483 |
1657761 | 1657761 | 2021-08-27 | Duval | Florida | 12031 | 149122 | 1483 |
1654513 | 1654513 | 2021-08-26 | Duval | Florida | 12031 | 144249 | 1483 |
1651266 | 1651266 | 2021-08-25 | Duval | Florida | 12031 | 144249 | 1483 |
1648017 | 1648017 | 2021-08-24 | Duval | Florida | 12031 | 144249 | 1483 |
1644769 | 1644769 | 2021-08-23 | Duval | Florida | 12031 | 144249 | 1483 |
1641519 | 1641519 | 2021-08-22 | Duval | Florida | 12031 | 144249 | 1483 |
1638269 | 1638269 | 2021-08-21 | Duval | Florida | 12031 | 144249 | 1483 |
1635019 | 1635019 | 2021-08-20 | Duval | Florida | 12031 | 144249 | 1483 |
1631770 | 1631770 | 2021-08-19 | Duval | Florida | 12031 | 138903 | 1483 |
1628523 | 1628523 | 2021-08-18 | Duval | Florida | 12031 | 138903 | 1483 |
1625276 | 1625276 | 2021-08-17 | Duval | Florida | 12031 | 138903 | 1483 |
1622029 | 1622029 | 2021-08-16 | Duval | Florida | 12031 | 138903 | 1483 |
1618782 | 1618782 | 2021-08-15 | Duval | Florida | 12031 | 138903 | 1483 |
1615534 | 1615534 | 2021-08-14 | Duval | Florida | 12031 | 138903 | 1483 |
1612285 | 1612285 | 2021-08-13 | Duval | Florida | 12031 | 138903 | 1483 |
1609037 | 1609037 | 2021-08-12 | Duval | Florida | 12031 | 132528 | 1483 |
1605788 | 1605788 | 2021-08-11 | Duval | Florida | 12031 | 132528 | 1483 |
1602539 | 1602539 | 2021-08-10 | Duval | Florida | 12031 | 132528 | 1483 |
1599290 | 1599290 | 2021-08-09 | Duval | Florida | 12031 | 132528 | 1483 |
1596041 | 1596041 | 2021-08-08 | Duval | Florida | 12031 | 132528 | 1483 |
1592792 | 1592792 | 2021-08-07 | Duval | Florida | 12031 | 132528 | 1483 |
1589543 | 1589543 | 2021-08-06 | Duval | Florida | 12031 | 132528 | 1483 |
1586294 | 1586294 | 2021-08-05 | Duval | Florida | 12031 | 124371 | 1483 |
1583044 | 1583044 | 2021-08-04 | Duval | Florida | 12031 | 124371 | 1483 |
1579794 | 1579794 | 2021-08-03 | Duval | Florida | 12031 | 124371 | 1483 |
1576546 | 1576546 | 2021-08-02 | Duval | Florida | 12031 | 124371 | 1483 |
1573298 | 1573298 | 2021-08-01 | Duval | Florida | 12031 | 124371 | 1483 |
1570050 | 1570050 | 2021-07-31 | Duval | Florida | 12031 | 124371 | 1483 |
1566802 | 1566802 | 2021-07-30 | Duval | Florida | 12031 | 124371 | 1483 |
1563554 | 1563554 | 2021-07-29 | Duval | Florida | 12031 | 116028 | 1483 |
1560306 | 1560306 | 2021-07-28 | Duval | Florida | 12031 | 116028 | 1483 |
1557059 | 1557059 | 2021-07-27 | Duval | Florida | 12031 | 116028 | 1483 |
1553812 | 1553812 | 2021-07-26 | Duval | Florida | 12031 | 116028 | 1483 |
1550565 | 1550565 | 2021-07-25 | Duval | Florida | 12031 | 116028 | 1483 |
1547318 | 1547318 | 2021-07-24 | Duval | Florida | 12031 | 116028 | 1483 |
1544071 | 1544071 | 2021-07-23 | Duval | Florida | 12031 | 116028 | 1483 |
1540823 | 1540823 | 2021-07-22 | Duval | Florida | 12031 | 109603 | 1483 |
1537576 | 1537576 | 2021-07-21 | Duval | Florida | 12031 | 109603 | 1483 |
1534328 | 1534328 | 2021-07-20 | Duval | Florida | 12031 | 109603 | 1483 |
1531081 | 1531081 | 2021-07-19 | Duval | Florida | 12031 | 109603 | 1483 |
1527834 | 1527834 | 2021-07-18 | Duval | Florida | 12031 | 109603 | 1483 |
1524587 | 1524587 | 2021-07-17 | Duval | Florida | 12031 | 109603 | 1483 |
1521339 | 1521339 | 2021-07-16 | Duval | Florida | 12031 | 109603 | 1483 |
1518091 | 1518091 | 2021-07-15 | Duval | Florida | 12031 | 105165 | 1483 |
1514844 | 1514844 | 2021-07-14 | Duval | Florida | 12031 | 105165 | 1483 |
1511598 | 1511598 | 2021-07-13 | Duval | Florida | 12031 | 105165 | 1483 |
1508351 | 1508351 | 2021-07-12 | Duval | Florida | 12031 | 105165 | 1483 |
1505105 | 1505105 | 2021-07-11 | Duval | Florida | 12031 | 105165 | 1483 |
1501859 | 1501859 | 2021-07-10 | Duval | Florida | 12031 | 105165 | 1483 |
1498613 | 1498613 | 2021-07-09 | Duval | Florida | 12031 | 105165 | 1483 |
1495366 | 1495366 | 2021-07-08 | Duval | Florida | 12031 | 103026 | 1483 |
1492120 | 1492120 | 2021-07-07 | Duval | Florida | 12031 | 103026 | 1483 |
1488873 | 1488873 | 2021-07-06 | Duval | Florida | 12031 | 103026 | 1483 |
1485626 | 1485626 | 2021-07-05 | Duval | Florida | 12031 | 103026 | 1483 |
1482380 | 1482380 | 2021-07-04 | Duval | Florida | 12031 | 103026 | 1483 |
1479133 | 1479133 | 2021-07-03 | Duval | Florida | 12031 | 103026 | 1483 |
1475887 | 1475887 | 2021-07-02 | Duval | Florida | 12031 | 103026 | 1483 |
1472641 | 1472641 | 2021-07-01 | Duval | Florida | 12031 | 101623 | 1483 |
1469395 | 1469395 | 2021-06-30 | Duval | Florida | 12031 | 101623 | 1483 |
1466150 | 1466150 | 2021-06-29 | Duval | Florida | 12031 | 101623 | 1483 |
1462905 | 1462905 | 2021-06-28 | Duval | Florida | 12031 | 101623 | 1483 |
1459660 | 1459660 | 2021-06-27 | Duval | Florida | 12031 | 101623 | 1483 |
1456415 | 1456415 | 2021-06-26 | Duval | Florida | 12031 | 101623 | 1483 |
1453170 | 1453170 | 2021-06-25 | Duval | Florida | 12031 | 101623 | 1483 |
1449924 | 1449924 | 2021-06-24 | Duval | Florida | 12031 | 100811 | 1483 |
1446679 | 1446679 | 2021-06-23 | Duval | Florida | 12031 | 100811 | 1483 |
1443434 | 1443434 | 2021-06-22 | Duval | Florida | 12031 | 100811 | 1483 |
1440189 | 1440189 | 2021-06-21 | Duval | Florida | 12031 | 100811 | 1483 |
1436942 | 1436942 | 2021-06-20 | Duval | Florida | 12031 | 100811 | 1483 |
1433695 | 1433695 | 2021-06-19 | Duval | Florida | 12031 | 100811 | 1483 |
1430449 | 1430449 | 2021-06-18 | Duval | Florida | 12031 | 100811 | 1483 |
1427204 | 1427204 | 2021-06-17 | Duval | Florida | 12031 | 100193 | 1483 |
1423959 | 1423959 | 2021-06-16 | Duval | Florida | 12031 | 100193 | 1483 |
1420711 | 1420711 | 2021-06-15 | Duval | Florida | 12031 | 100193 | 1483 |
1417466 | 1417466 | 2021-06-14 | Duval | Florida | 12031 | 100193 | 1483 |
1414220 | 1414220 | 2021-06-13 | Duval | Florida | 12031 | 100193 | 1483 |
1410975 | 1410975 | 2021-06-12 | Duval | Florida | 12031 | 100193 | 1483 |
1407730 | 1407730 | 2021-06-11 | Duval | Florida | 12031 | 100193 | 1483 |
1404484 | 1404484 | 2021-06-10 | Duval | Florida | 12031 | 99506 | 1483 |
1401239 | 1401239 | 2021-06-09 | Duval | Florida | 12031 | 99506 | 1483 |
1397994 | 1397994 | 2021-06-08 | Duval | Florida | 12031 | 99506 | 1483 |
1394747 | 1394747 | 2021-06-07 | Duval | Florida | 12031 | 99506 | 1483 |
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);