ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 12119 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1716274 | 1716274 | 2021-09-14 | Sumter | Florida | 12119 | 13322 | 389 |
1713028 | 1713028 | 2021-09-13 | Sumter | Florida | 12119 | 13322 | 284 |
1709781 | 1709781 | 2021-09-12 | Sumter | Florida | 12119 | 13322 | 284 |
1706534 | 1706534 | 2021-09-11 | Sumter | Florida | 12119 | 13322 | 284 |
1703286 | 1703286 | 2021-09-10 | Sumter | Florida | 12119 | 13322 | 284 |
1700036 | 1700036 | 2021-09-09 | Sumter | Florida | 12119 | 12830 | 284 |
1696787 | 1696787 | 2021-09-08 | Sumter | Florida | 12119 | 12830 | 284 |
1693539 | 1693539 | 2021-09-07 | Sumter | Florida | 12119 | 12830 | 284 |
1690290 | 1690290 | 2021-09-06 | Sumter | Florida | 12119 | 12830 | 284 |
1687040 | 1687040 | 2021-09-05 | Sumter | Florida | 12119 | 12830 | 284 |
1683790 | 1683790 | 2021-09-04 | Sumter | Florida | 12119 | 12830 | 284 |
1680539 | 1680539 | 2021-09-03 | Sumter | Florida | 12119 | 12830 | 284 |
1677291 | 1677291 | 2021-09-02 | Sumter | Florida | 12119 | 12311 | 284 |
1674044 | 1674044 | 2021-09-01 | Sumter | Florida | 12119 | 12311 | 284 |
1670796 | 1670796 | 2021-08-31 | Sumter | Florida | 12119 | 12311 | 284 |
1667549 | 1667549 | 2021-08-30 | Sumter | Florida | 12119 | 12311 | 284 |
1664302 | 1664302 | 2021-08-29 | Sumter | Florida | 12119 | 12311 | 284 |
1661054 | 1661054 | 2021-08-28 | Sumter | Florida | 12119 | 12311 | 284 |
1657806 | 1657806 | 2021-08-27 | Sumter | Florida | 12119 | 12311 | 284 |
1654558 | 1654558 | 2021-08-26 | Sumter | Florida | 12119 | 11718 | 284 |
1651311 | 1651311 | 2021-08-25 | Sumter | Florida | 12119 | 11718 | 284 |
1648062 | 1648062 | 2021-08-24 | Sumter | Florida | 12119 | 11718 | 284 |
1644814 | 1644814 | 2021-08-23 | Sumter | Florida | 12119 | 11718 | 284 |
1641564 | 1641564 | 2021-08-22 | Sumter | Florida | 12119 | 11718 | 284 |
1638314 | 1638314 | 2021-08-21 | Sumter | Florida | 12119 | 11718 | 284 |
1635064 | 1635064 | 2021-08-20 | Sumter | Florida | 12119 | 11718 | 284 |
1631815 | 1631815 | 2021-08-19 | Sumter | Florida | 12119 | 11176 | 284 |
1628568 | 1628568 | 2021-08-18 | Sumter | Florida | 12119 | 11176 | 284 |
1625321 | 1625321 | 2021-08-17 | Sumter | Florida | 12119 | 11176 | 284 |
1622074 | 1622074 | 2021-08-16 | Sumter | Florida | 12119 | 11176 | 284 |
1618827 | 1618827 | 2021-08-15 | Sumter | Florida | 12119 | 11176 | 284 |
1615579 | 1615579 | 2021-08-14 | Sumter | Florida | 12119 | 11176 | 284 |
1612330 | 1612330 | 2021-08-13 | Sumter | Florida | 12119 | 11176 | 284 |
1609082 | 1609082 | 2021-08-12 | Sumter | Florida | 12119 | 10726 | 284 |
1605833 | 1605833 | 2021-08-11 | Sumter | Florida | 12119 | 10726 | 284 |
1602584 | 1602584 | 2021-08-10 | Sumter | Florida | 12119 | 10726 | 284 |
1599335 | 1599335 | 2021-08-09 | Sumter | Florida | 12119 | 10726 | 284 |
1596086 | 1596086 | 2021-08-08 | Sumter | Florida | 12119 | 10726 | 284 |
1592837 | 1592837 | 2021-08-07 | Sumter | Florida | 12119 | 10726 | 284 |
1589588 | 1589588 | 2021-08-06 | Sumter | Florida | 12119 | 10726 | 284 |
1586339 | 1586339 | 2021-08-05 | Sumter | Florida | 12119 | 10297 | 284 |
1583089 | 1583089 | 2021-08-04 | Sumter | Florida | 12119 | 10297 | 284 |
1579839 | 1579839 | 2021-08-03 | Sumter | Florida | 12119 | 10297 | 284 |
1576591 | 1576591 | 2021-08-02 | Sumter | Florida | 12119 | 10297 | 284 |
1573343 | 1573343 | 2021-08-01 | Sumter | Florida | 12119 | 10297 | 284 |
1570095 | 1570095 | 2021-07-31 | Sumter | Florida | 12119 | 10297 | 284 |
1566847 | 1566847 | 2021-07-30 | Sumter | Florida | 12119 | 10297 | 284 |
1563599 | 1563599 | 2021-07-29 | Sumter | Florida | 12119 | 9975 | 284 |
1560351 | 1560351 | 2021-07-28 | Sumter | Florida | 12119 | 9975 | 284 |
1557104 | 1557104 | 2021-07-27 | Sumter | Florida | 12119 | 9975 | 284 |
1553857 | 1553857 | 2021-07-26 | Sumter | Florida | 12119 | 9975 | 284 |
1550610 | 1550610 | 2021-07-25 | Sumter | Florida | 12119 | 9975 | 284 |
1547363 | 1547363 | 2021-07-24 | Sumter | Florida | 12119 | 9975 | 284 |
1544116 | 1544116 | 2021-07-23 | Sumter | Florida | 12119 | 9975 | 284 |
1540868 | 1540868 | 2021-07-22 | Sumter | Florida | 12119 | 9778 | 284 |
1537621 | 1537621 | 2021-07-21 | Sumter | Florida | 12119 | 9778 | 284 |
1534373 | 1534373 | 2021-07-20 | Sumter | Florida | 12119 | 9778 | 284 |
1531126 | 1531126 | 2021-07-19 | Sumter | Florida | 12119 | 9778 | 284 |
1527879 | 1527879 | 2021-07-18 | Sumter | Florida | 12119 | 9778 | 284 |
1524632 | 1524632 | 2021-07-17 | Sumter | Florida | 12119 | 9778 | 284 |
1521384 | 1521384 | 2021-07-16 | Sumter | Florida | 12119 | 9778 | 284 |
1518136 | 1518136 | 2021-07-15 | Sumter | Florida | 12119 | 9648 | 284 |
1514889 | 1514889 | 2021-07-14 | Sumter | Florida | 12119 | 9648 | 284 |
1511643 | 1511643 | 2021-07-13 | Sumter | Florida | 12119 | 9648 | 284 |
1508396 | 1508396 | 2021-07-12 | Sumter | Florida | 12119 | 9648 | 284 |
1505150 | 1505150 | 2021-07-11 | Sumter | Florida | 12119 | 9648 | 284 |
1501904 | 1501904 | 2021-07-10 | Sumter | Florida | 12119 | 9648 | 284 |
1498658 | 1498658 | 2021-07-09 | Sumter | Florida | 12119 | 9648 | 284 |
1495411 | 1495411 | 2021-07-08 | Sumter | Florida | 12119 | 9565 | 284 |
1492165 | 1492165 | 2021-07-07 | Sumter | Florida | 12119 | 9565 | 284 |
1488918 | 1488918 | 2021-07-06 | Sumter | Florida | 12119 | 9565 | 284 |
1485671 | 1485671 | 2021-07-05 | Sumter | Florida | 12119 | 9565 | 284 |
1482425 | 1482425 | 2021-07-04 | Sumter | Florida | 12119 | 9565 | 284 |
1479178 | 1479178 | 2021-07-03 | Sumter | Florida | 12119 | 9565 | 284 |
1475932 | 1475932 | 2021-07-02 | Sumter | Florida | 12119 | 9565 | 284 |
1472686 | 1472686 | 2021-07-01 | Sumter | Florida | 12119 | 9515 | 284 |
1469440 | 1469440 | 2021-06-30 | Sumter | Florida | 12119 | 9515 | 284 |
1466195 | 1466195 | 2021-06-29 | Sumter | Florida | 12119 | 9515 | 284 |
1462950 | 1462950 | 2021-06-28 | Sumter | Florida | 12119 | 9515 | 284 |
1459705 | 1459705 | 2021-06-27 | Sumter | Florida | 12119 | 9515 | 284 |
1456460 | 1456460 | 2021-06-26 | Sumter | Florida | 12119 | 9515 | 284 |
1453215 | 1453215 | 2021-06-25 | Sumter | Florida | 12119 | 9515 | 284 |
1449969 | 1449969 | 2021-06-24 | Sumter | Florida | 12119 | 9472 | 284 |
1446724 | 1446724 | 2021-06-23 | Sumter | Florida | 12119 | 9472 | 284 |
1443479 | 1443479 | 2021-06-22 | Sumter | Florida | 12119 | 9472 | 284 |
1440234 | 1440234 | 2021-06-21 | Sumter | Florida | 12119 | 9472 | 284 |
1436987 | 1436987 | 2021-06-20 | Sumter | Florida | 12119 | 9472 | 284 |
1433740 | 1433740 | 2021-06-19 | Sumter | Florida | 12119 | 9472 | 284 |
1430494 | 1430494 | 2021-06-18 | Sumter | Florida | 12119 | 9472 | 284 |
1427249 | 1427249 | 2021-06-17 | Sumter | Florida | 12119 | 9434 | 284 |
1424004 | 1424004 | 2021-06-16 | Sumter | Florida | 12119 | 9434 | 284 |
1420756 | 1420756 | 2021-06-15 | Sumter | Florida | 12119 | 9434 | 284 |
1417511 | 1417511 | 2021-06-14 | Sumter | Florida | 12119 | 9434 | 284 |
1414265 | 1414265 | 2021-06-13 | Sumter | Florida | 12119 | 9434 | 284 |
1411020 | 1411020 | 2021-06-12 | Sumter | Florida | 12119 | 9434 | 284 |
1407775 | 1407775 | 2021-06-11 | Sumter | Florida | 12119 | 9434 | 284 |
1404529 | 1404529 | 2021-06-10 | Sumter | Florida | 12119 | 9400 | 284 |
1401284 | 1401284 | 2021-06-09 | Sumter | Florida | 12119 | 9400 | 284 |
1398039 | 1398039 | 2021-06-08 | Sumter | Florida | 12119 | 9400 | 284 |
1394792 | 1394792 | 2021-06-07 | Sumter | Florida | 12119 | 9400 | 284 |
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);