ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where fips = 12013 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1417458 | 1417458 | 2021-06-14 | Calhoun | Florida | 12013 | 1710 | 45 |
1414212 | 1414212 | 2021-06-13 | Calhoun | Florida | 12013 | 1710 | 45 |
1410967 | 1410967 | 2021-06-12 | Calhoun | Florida | 12013 | 1710 | 45 |
1407722 | 1407722 | 2021-06-11 | Calhoun | Florida | 12013 | 1710 | 45 |
1404476 | 1404476 | 2021-06-10 | Calhoun | Florida | 12013 | 1705 | 45 |
1401231 | 1401231 | 2021-06-09 | Calhoun | Florida | 12013 | 1705 | 45 |
1397986 | 1397986 | 2021-06-08 | Calhoun | Florida | 12013 | 1705 | 45 |
1394739 | 1394739 | 2021-06-07 | Calhoun | Florida | 12013 | 1705 | 45 |
1391494 | 1391494 | 2021-06-06 | Calhoun | Florida | 12013 | 1705 | 45 |
1388249 | 1388249 | 2021-06-05 | Calhoun | Florida | 12013 | 1705 | 45 |
1385004 | 1385004 | 2021-06-04 | Calhoun | Florida | 12013 | 1705 | 45 |
1381758 | 1381758 | 2021-06-03 | Calhoun | Florida | 12013 | 1707 | 45 |
1378513 | 1378513 | 2021-06-02 | Calhoun | Florida | 12013 | 1707 | 45 |
1375267 | 1375267 | 2021-06-01 | Calhoun | Florida | 12013 | 1707 | 45 |
1372022 | 1372022 | 2021-05-31 | Calhoun | Florida | 12013 | 1705 | 45 |
1368777 | 1368777 | 2021-05-30 | Calhoun | Florida | 12013 | 1705 | 45 |
1365531 | 1365531 | 2021-05-29 | Calhoun | Florida | 12013 | 1705 | 45 |
1362285 | 1362285 | 2021-05-28 | Calhoun | Florida | 12013 | 1705 | 45 |
1359038 | 1359038 | 2021-05-27 | Calhoun | Florida | 12013 | 1704 | 46 |
1355792 | 1355792 | 2021-05-26 | Calhoun | Florida | 12013 | 1704 | 46 |
1352546 | 1352546 | 2021-05-25 | Calhoun | Florida | 12013 | 1704 | 45 |
1349300 | 1349300 | 2021-05-24 | Calhoun | Florida | 12013 | 1702 | 45 |
1346053 | 1346053 | 2021-05-23 | Calhoun | Florida | 12013 | 1702 | 45 |
1342805 | 1342805 | 2021-05-22 | Calhoun | Florida | 12013 | 1702 | 45 |
1339557 | 1339557 | 2021-05-21 | Calhoun | Florida | 12013 | 1701 | 45 |
1336310 | 1336310 | 2021-05-20 | Calhoun | Florida | 12013 | 1701 | 45 |
1333063 | 1333063 | 2021-05-19 | Calhoun | Florida | 12013 | 1700 | 45 |
1329816 | 1329816 | 2021-05-18 | Calhoun | Florida | 12013 | 1699 | 45 |
1326569 | 1326569 | 2021-05-17 | Calhoun | Florida | 12013 | 1699 | 45 |
1323323 | 1323323 | 2021-05-16 | Calhoun | Florida | 12013 | 1699 | 45 |
1320077 | 1320077 | 2021-05-15 | Calhoun | Florida | 12013 | 1698 | 45 |
1316830 | 1316830 | 2021-05-14 | Calhoun | Florida | 12013 | 1697 | 45 |
1313583 | 1313583 | 2021-05-13 | Calhoun | Florida | 12013 | 1697 | 45 |
1310336 | 1310336 | 2021-05-12 | Calhoun | Florida | 12013 | 1696 | 44 |
1307090 | 1307090 | 2021-05-11 | Calhoun | Florida | 12013 | 1695 | 44 |
1303844 | 1303844 | 2021-05-10 | Calhoun | Florida | 12013 | 1695 | 44 |
1300597 | 1300597 | 2021-05-09 | Calhoun | Florida | 12013 | 1695 | 44 |
1297350 | 1297350 | 2021-05-08 | Calhoun | Florida | 12013 | 1694 | 44 |
1294104 | 1294104 | 2021-05-07 | Calhoun | Florida | 12013 | 1693 | 44 |
1290858 | 1290858 | 2021-05-06 | Calhoun | Florida | 12013 | 1693 | 44 |
1287612 | 1287612 | 2021-05-05 | Calhoun | Florida | 12013 | 1693 | 44 |
1284366 | 1284366 | 2021-05-04 | Calhoun | Florida | 12013 | 1689 | 46 |
1281119 | 1281119 | 2021-05-03 | Calhoun | Florida | 12013 | 1688 | 43 |
1277872 | 1277872 | 2021-05-02 | Calhoun | Florida | 12013 | 1688 | 43 |
1274625 | 1274625 | 2021-05-01 | Calhoun | Florida | 12013 | 1688 | 43 |
1271378 | 1271378 | 2021-04-30 | Calhoun | Florida | 12013 | 1688 | 43 |
1268131 | 1268131 | 2021-04-29 | Calhoun | Florida | 12013 | 1688 | 43 |
1264884 | 1264884 | 2021-04-28 | Calhoun | Florida | 12013 | 1686 | 43 |
1261637 | 1261637 | 2021-04-27 | Calhoun | Florida | 12013 | 1686 | 43 |
1258390 | 1258390 | 2021-04-26 | Calhoun | Florida | 12013 | 1686 | 43 |
1255143 | 1255143 | 2021-04-25 | Calhoun | Florida | 12013 | 1686 | 43 |
1251896 | 1251896 | 2021-04-24 | Calhoun | Florida | 12013 | 1686 | 43 |
1248649 | 1248649 | 2021-04-23 | Calhoun | Florida | 12013 | 1682 | 43 |
1245402 | 1245402 | 2021-04-22 | Calhoun | Florida | 12013 | 1680 | 43 |
1242155 | 1242155 | 2021-04-21 | Calhoun | Florida | 12013 | 1676 | 43 |
1238908 | 1238908 | 2021-04-20 | Calhoun | Florida | 12013 | 1673 | 43 |
1235661 | 1235661 | 2021-04-19 | Calhoun | Florida | 12013 | 1673 | 43 |
1232414 | 1232414 | 2021-04-18 | Calhoun | Florida | 12013 | 1673 | 43 |
1229165 | 1229165 | 2021-04-17 | Calhoun | Florida | 12013 | 1671 | 43 |
1225917 | 1225917 | 2021-04-16 | Calhoun | Florida | 12013 | 1671 | 43 |
1222670 | 1222670 | 2021-04-15 | Calhoun | Florida | 12013 | 1668 | 43 |
1219422 | 1219422 | 2021-04-14 | Calhoun | Florida | 12013 | 1665 | 43 |
1216174 | 1216174 | 2021-04-13 | Calhoun | Florida | 12013 | 1665 | 43 |
1212927 | 1212927 | 2021-04-12 | Calhoun | Florida | 12013 | 1666 | 43 |
1209679 | 1209679 | 2021-04-11 | Calhoun | Florida | 12013 | 1666 | 43 |
1206430 | 1206430 | 2021-04-10 | Calhoun | Florida | 12013 | 1666 | 47 |
1203182 | 1203182 | 2021-04-09 | Calhoun | Florida | 12013 | 1666 | 47 |
1199934 | 1199934 | 2021-04-08 | Calhoun | Florida | 12013 | 1666 | 42 |
1196685 | 1196685 | 2021-04-07 | Calhoun | Florida | 12013 | 1663 | 42 |
1193437 | 1193437 | 2021-04-06 | Calhoun | Florida | 12013 | 1663 | 42 |
1190187 | 1190187 | 2021-04-05 | Calhoun | Florida | 12013 | 1663 | 42 |
1186940 | 1186940 | 2021-04-04 | Calhoun | Florida | 12013 | 1663 | 42 |
1183693 | 1183693 | 2021-04-03 | Calhoun | Florida | 12013 | 1662 | 42 |
1180446 | 1180446 | 2021-04-02 | Calhoun | Florida | 12013 | 1661 | 42 |
1177199 | 1177199 | 2021-04-01 | Calhoun | Florida | 12013 | 1660 | 42 |
1173952 | 1173952 | 2021-03-31 | Calhoun | Florida | 12013 | 1658 | 42 |
1170705 | 1170705 | 2021-03-30 | Calhoun | Florida | 12013 | 1656 | 42 |
1167457 | 1167457 | 2021-03-29 | Calhoun | Florida | 12013 | 1655 | 42 |
1164209 | 1164209 | 2021-03-28 | Calhoun | Florida | 12013 | 1655 | 42 |
1160961 | 1160961 | 2021-03-27 | Calhoun | Florida | 12013 | 1653 | 42 |
1157713 | 1157713 | 2021-03-26 | Calhoun | Florida | 12013 | 1653 | 42 |
1154466 | 1154466 | 2021-03-25 | Calhoun | Florida | 12013 | 1647 | 42 |
1151219 | 1151219 | 2021-03-24 | Calhoun | Florida | 12013 | 1647 | 42 |
1147972 | 1147972 | 2021-03-23 | Calhoun | Florida | 12013 | 1647 | 42 |
1144725 | 1144725 | 2021-03-22 | Calhoun | Florida | 12013 | 1647 | 42 |
1141478 | 1141478 | 2021-03-21 | Calhoun | Florida | 12013 | 1647 | 42 |
1138232 | 1138232 | 2021-03-20 | Calhoun | Florida | 12013 | 1647 | 42 |
1134986 | 1134986 | 2021-03-19 | Calhoun | Florida | 12013 | 1647 | 42 |
1131739 | 1131739 | 2021-03-18 | Calhoun | Florida | 12013 | 1645 | 42 |
1128491 | 1128491 | 2021-03-17 | Calhoun | Florida | 12013 | 1643 | 42 |
1125245 | 1125245 | 2021-03-16 | Calhoun | Florida | 12013 | 1643 | 42 |
1121999 | 1121999 | 2021-03-15 | Calhoun | Florida | 12013 | 1644 | 42 |
1118752 | 1118752 | 2021-03-14 | Calhoun | Florida | 12013 | 1642 | 42 |
1115505 | 1115505 | 2021-03-13 | Calhoun | Florida | 12013 | 1642 | 42 |
1112259 | 1112259 | 2021-03-12 | Calhoun | Florida | 12013 | 1642 | 42 |
1109013 | 1109013 | 2021-03-11 | Calhoun | Florida | 12013 | 1636 | 42 |
1105767 | 1105767 | 2021-03-10 | Calhoun | Florida | 12013 | 1631 | 42 |
1102521 | 1102521 | 2021-03-09 | Calhoun | Florida | 12013 | 1626 | 42 |
1099275 | 1099275 | 2021-03-08 | Calhoun | Florida | 12013 | 1623 | 46 |
1096027 | 1096027 | 2021-03-07 | Calhoun | Florida | 12013 | 1623 | 46 |
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);