ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Clay" and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1498608 | 1498608 | 2021-07-09 | Clay | Florida | 12019 | 20232 | 352 |
1495361 | 1495361 | 2021-07-08 | Clay | Florida | 12019 | 19853 | 352 |
1492115 | 1492115 | 2021-07-07 | Clay | Florida | 12019 | 19853 | 352 |
1488868 | 1488868 | 2021-07-06 | Clay | Florida | 12019 | 19853 | 352 |
1485621 | 1485621 | 2021-07-05 | Clay | Florida | 12019 | 19853 | 352 |
1482375 | 1482375 | 2021-07-04 | Clay | Florida | 12019 | 19853 | 352 |
1479128 | 1479128 | 2021-07-03 | Clay | Florida | 12019 | 19853 | 352 |
1475882 | 1475882 | 2021-07-02 | Clay | Florida | 12019 | 19853 | 352 |
1472636 | 1472636 | 2021-07-01 | Clay | Florida | 12019 | 19630 | 352 |
1469390 | 1469390 | 2021-06-30 | Clay | Florida | 12019 | 19630 | 352 |
1466145 | 1466145 | 2021-06-29 | Clay | Florida | 12019 | 19630 | 352 |
1462900 | 1462900 | 2021-06-28 | Clay | Florida | 12019 | 19630 | 352 |
1459655 | 1459655 | 2021-06-27 | Clay | Florida | 12019 | 19630 | 352 |
1456410 | 1456410 | 2021-06-26 | Clay | Florida | 12019 | 19630 | 352 |
1453165 | 1453165 | 2021-06-25 | Clay | Florida | 12019 | 19630 | 352 |
1449919 | 1449919 | 2021-06-24 | Clay | Florida | 12019 | 19512 | 352 |
1446674 | 1446674 | 2021-06-23 | Clay | Florida | 12019 | 19512 | 352 |
1443429 | 1443429 | 2021-06-22 | Clay | Florida | 12019 | 19512 | 352 |
1440184 | 1440184 | 2021-06-21 | Clay | Florida | 12019 | 19512 | 352 |
1436937 | 1436937 | 2021-06-20 | Clay | Florida | 12019 | 19512 | 352 |
1433690 | 1433690 | 2021-06-19 | Clay | Florida | 12019 | 19512 | 352 |
1430444 | 1430444 | 2021-06-18 | Clay | Florida | 12019 | 19512 | 352 |
1427199 | 1427199 | 2021-06-17 | Clay | Florida | 12019 | 19391 | 352 |
1423954 | 1423954 | 2021-06-16 | Clay | Florida | 12019 | 19391 | 352 |
1420706 | 1420706 | 2021-06-15 | Clay | Florida | 12019 | 19391 | 352 |
1417461 | 1417461 | 2021-06-14 | Clay | Florida | 12019 | 19391 | 352 |
1414215 | 1414215 | 2021-06-13 | Clay | Florida | 12019 | 19391 | 352 |
1410970 | 1410970 | 2021-06-12 | Clay | Florida | 12019 | 19391 | 352 |
1407725 | 1407725 | 2021-06-11 | Clay | Florida | 12019 | 19391 | 352 |
1404479 | 1404479 | 2021-06-10 | Clay | Florida | 12019 | 19268 | 352 |
1401234 | 1401234 | 2021-06-09 | Clay | Florida | 12019 | 19268 | 352 |
1397989 | 1397989 | 2021-06-08 | Clay | Florida | 12019 | 19268 | 352 |
1394742 | 1394742 | 2021-06-07 | Clay | Florida | 12019 | 19268 | 352 |
1391497 | 1391497 | 2021-06-06 | Clay | Florida | 12019 | 19268 | 352 |
1388252 | 1388252 | 2021-06-05 | Clay | Florida | 12019 | 19268 | 352 |
1385007 | 1385007 | 2021-06-04 | Clay | Florida | 12019 | 19268 | 352 |
1381761 | 1381761 | 2021-06-03 | Clay | Florida | 12019 | 19297 | 352 |
1378516 | 1378516 | 2021-06-02 | Clay | Florida | 12019 | 19275 | 352 |
1375270 | 1375270 | 2021-06-01 | Clay | Florida | 12019 | 19265 | 352 |
1372025 | 1372025 | 2021-05-31 | Clay | Florida | 12019 | 19206 | 351 |
1368780 | 1368780 | 2021-05-30 | Clay | Florida | 12019 | 19206 | 351 |
1365534 | 1365534 | 2021-05-29 | Clay | Florida | 12019 | 19206 | 351 |
1362288 | 1362288 | 2021-05-28 | Clay | Florida | 12019 | 19206 | 351 |
1359041 | 1359041 | 2021-05-27 | Clay | Florida | 12019 | 19185 | 352 |
1355795 | 1355795 | 2021-05-26 | Clay | Florida | 12019 | 19173 | 345 |
1352549 | 1352549 | 2021-05-25 | Clay | Florida | 12019 | 19160 | 345 |
1349303 | 1349303 | 2021-05-24 | Clay | Florida | 12019 | 19147 | 345 |
1346056 | 1346056 | 2021-05-23 | Clay | Florida | 12019 | 19125 | 345 |
1342808 | 1342808 | 2021-05-22 | Clay | Florida | 12019 | 19106 | 345 |
1339560 | 1339560 | 2021-05-21 | Clay | Florida | 12019 | 19064 | 344 |
1336313 | 1336313 | 2021-05-20 | Clay | Florida | 12019 | 19044 | 344 |
1333066 | 1333066 | 2021-05-19 | Clay | Florida | 12019 | 19018 | 344 |
1329819 | 1329819 | 2021-05-18 | Clay | Florida | 12019 | 18992 | 344 |
1326572 | 1326572 | 2021-05-17 | Clay | Florida | 12019 | 18959 | 344 |
1323326 | 1323326 | 2021-05-16 | Clay | Florida | 12019 | 18940 | 343 |
1320080 | 1320080 | 2021-05-15 | Clay | Florida | 12019 | 18909 | 342 |
1316833 | 1316833 | 2021-05-14 | Clay | Florida | 12019 | 18868 | 342 |
1313586 | 1313586 | 2021-05-13 | Clay | Florida | 12019 | 18833 | 342 |
1310339 | 1310339 | 2021-05-12 | Clay | Florida | 12019 | 18808 | 342 |
1307093 | 1307093 | 2021-05-11 | Clay | Florida | 12019 | 18772 | 342 |
1303847 | 1303847 | 2021-05-10 | Clay | Florida | 12019 | 18740 | 342 |
1300600 | 1300600 | 2021-05-09 | Clay | Florida | 12019 | 18711 | 342 |
1297353 | 1297353 | 2021-05-08 | Clay | Florida | 12019 | 18675 | 340 |
1294107 | 1294107 | 2021-05-07 | Clay | Florida | 12019 | 18647 | 340 |
1290861 | 1290861 | 2021-05-06 | Clay | Florida | 12019 | 18595 | 340 |
1287615 | 1287615 | 2021-05-05 | Clay | Florida | 12019 | 18562 | 340 |
1284369 | 1284369 | 2021-05-04 | Clay | Florida | 12019 | 18536 | 340 |
1281122 | 1281122 | 2021-05-03 | Clay | Florida | 12019 | 18509 | 340 |
1277875 | 1277875 | 2021-05-02 | Clay | Florida | 12019 | 18492 | 340 |
1274628 | 1274628 | 2021-05-01 | Clay | Florida | 12019 | 18467 | 340 |
1271381 | 1271381 | 2021-04-30 | Clay | Florida | 12019 | 18413 | 336 |
1268134 | 1268134 | 2021-04-29 | Clay | Florida | 12019 | 18374 | 337 |
1264887 | 1264887 | 2021-04-28 | Clay | Florida | 12019 | 18346 | 336 |
1261640 | 1261640 | 2021-04-27 | Clay | Florida | 12019 | 18318 | 336 |
1258393 | 1258393 | 2021-04-26 | Clay | Florida | 12019 | 18281 | 336 |
1255146 | 1255146 | 2021-04-25 | Clay | Florida | 12019 | 18255 | 336 |
1251899 | 1251899 | 2021-04-24 | Clay | Florida | 12019 | 18229 | 336 |
1248652 | 1248652 | 2021-04-23 | Clay | Florida | 12019 | 18181 | 336 |
1245405 | 1245405 | 2021-04-22 | Clay | Florida | 12019 | 18134 | 336 |
1242158 | 1242158 | 2021-04-21 | Clay | Florida | 12019 | 18072 | 331 |
1238911 | 1238911 | 2021-04-20 | Clay | Florida | 12019 | 18039 | 331 |
1235664 | 1235664 | 2021-04-19 | Clay | Florida | 12019 | 18009 | 331 |
1232417 | 1232417 | 2021-04-18 | Clay | Florida | 12019 | 17960 | 331 |
1229168 | 1229168 | 2021-04-17 | Clay | Florida | 12019 | 17907 | 331 |
1225920 | 1225920 | 2021-04-16 | Clay | Florida | 12019 | 17875 | 331 |
1222673 | 1222673 | 2021-04-15 | Clay | Florida | 12019 | 17801 | 331 |
1219425 | 1219425 | 2021-04-14 | Clay | Florida | 12019 | 17769 | 331 |
1216177 | 1216177 | 2021-04-13 | Clay | Florida | 12019 | 17725 | 331 |
1212930 | 1212930 | 2021-04-12 | Clay | Florida | 12019 | 17676 | 331 |
1209682 | 1209682 | 2021-04-11 | Clay | Florida | 12019 | 17663 | 331 |
1206433 | 1206433 | 2021-04-10 | Clay | Florida | 12019 | 17642 | 331 |
1203185 | 1203185 | 2021-04-09 | Clay | Florida | 12019 | 17611 | 331 |
1199937 | 1199937 | 2021-04-08 | Clay | Florida | 12019 | 17575 | 331 |
1196688 | 1196688 | 2021-04-07 | Clay | Florida | 12019 | 17534 | 329 |
1193440 | 1193440 | 2021-04-06 | Clay | Florida | 12019 | 17496 | 329 |
1190190 | 1190190 | 2021-04-05 | Clay | Florida | 12019 | 17480 | 329 |
1186943 | 1186943 | 2021-04-04 | Clay | Florida | 12019 | 17462 | 329 |
1183696 | 1183696 | 2021-04-03 | Clay | Florida | 12019 | 17447 | 329 |
1180449 | 1180449 | 2021-04-02 | Clay | Florida | 12019 | 17414 | 329 |
1177202 | 1177202 | 2021-04-01 | Clay | Florida | 12019 | 17390 | 329 |
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);