ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
770 rows where fips = 12029 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193444 | 1193444 | 2021-04-06 | Dixie | Florida | 12029 | 1557 | 22 |
1190194 | 1190194 | 2021-04-05 | Dixie | Florida | 12029 | 1556 | 22 |
1186947 | 1186947 | 2021-04-04 | Dixie | Florida | 12029 | 1556 | 22 |
1183700 | 1183700 | 2021-04-03 | Dixie | Florida | 12029 | 1556 | 22 |
1180453 | 1180453 | 2021-04-02 | Dixie | Florida | 12029 | 1556 | 22 |
1177206 | 1177206 | 2021-04-01 | Dixie | Florida | 12029 | 1555 | 22 |
1173959 | 1173959 | 2021-03-31 | Dixie | Florida | 12029 | 1553 | 22 |
1170712 | 1170712 | 2021-03-30 | Dixie | Florida | 12029 | 1553 | 22 |
1167464 | 1167464 | 2021-03-29 | Dixie | Florida | 12029 | 1550 | 23 |
1164216 | 1164216 | 2021-03-28 | Dixie | Florida | 12029 | 1549 | 23 |
1160968 | 1160968 | 2021-03-27 | Dixie | Florida | 12029 | 1548 | 23 |
1157720 | 1157720 | 2021-03-26 | Dixie | Florida | 12029 | 1549 | 23 |
1154473 | 1154473 | 2021-03-25 | Dixie | Florida | 12029 | 1545 | 23 |
1151226 | 1151226 | 2021-03-24 | Dixie | Florida | 12029 | 1543 | 23 |
1147979 | 1147979 | 2021-03-23 | Dixie | Florida | 12029 | 1542 | 23 |
1144732 | 1144732 | 2021-03-22 | Dixie | Florida | 12029 | 1538 | 23 |
1141485 | 1141485 | 2021-03-21 | Dixie | Florida | 12029 | 1537 | 22 |
1138239 | 1138239 | 2021-03-20 | Dixie | Florida | 12029 | 1537 | 22 |
1134993 | 1134993 | 2021-03-19 | Dixie | Florida | 12029 | 1536 | 22 |
1131746 | 1131746 | 2021-03-18 | Dixie | Florida | 12029 | 1536 | 22 |
1128498 | 1128498 | 2021-03-17 | Dixie | Florida | 12029 | 1534 | 22 |
1125252 | 1125252 | 2021-03-16 | Dixie | Florida | 12029 | 1531 | 22 |
1122006 | 1122006 | 2021-03-15 | Dixie | Florida | 12029 | 1529 | 22 |
1118759 | 1118759 | 2021-03-14 | Dixie | Florida | 12029 | 1528 | 22 |
1115512 | 1115512 | 2021-03-13 | Dixie | Florida | 12029 | 1527 | 22 |
1112266 | 1112266 | 2021-03-12 | Dixie | Florida | 12029 | 1522 | 22 |
1109020 | 1109020 | 2021-03-11 | Dixie | Florida | 12029 | 1520 | 22 |
1105774 | 1105774 | 2021-03-10 | Dixie | Florida | 12029 | 1519 | 22 |
1102528 | 1102528 | 2021-03-09 | Dixie | Florida | 12029 | 1518 | 22 |
1099282 | 1099282 | 2021-03-08 | Dixie | Florida | 12029 | 1514 | 22 |
1096034 | 1096034 | 2021-03-07 | Dixie | Florida | 12029 | 1513 | 22 |
1092788 | 1092788 | 2021-03-06 | Dixie | Florida | 12029 | 1511 | 21 |
1089542 | 1089542 | 2021-03-05 | Dixie | Florida | 12029 | 1507 | 21 |
1086297 | 1086297 | 2021-03-04 | Dixie | Florida | 12029 | 1504 | 21 |
1083051 | 1083051 | 2021-03-03 | Dixie | Florida | 12029 | 1495 | 21 |
1079805 | 1079805 | 2021-03-02 | Dixie | Florida | 12029 | 1495 | 21 |
1076560 | 1076560 | 2021-03-01 | Dixie | Florida | 12029 | 1493 | 21 |
1073314 | 1073314 | 2021-02-28 | Dixie | Florida | 12029 | 1492 | 19 |
1070068 | 1070068 | 2021-02-27 | Dixie | Florida | 12029 | 1491 | 19 |
1066823 | 1066823 | 2021-02-26 | Dixie | Florida | 12029 | 1484 | 19 |
1063578 | 1063578 | 2021-02-25 | Dixie | Florida | 12029 | 1483 | 19 |
1060333 | 1060333 | 2021-02-24 | Dixie | Florida | 12029 | 1468 | 19 |
1057087 | 1057087 | 2021-02-23 | Dixie | Florida | 12029 | 1463 | 19 |
1053841 | 1053841 | 2021-02-22 | Dixie | Florida | 12029 | 1462 | 19 |
1050594 | 1050594 | 2021-02-21 | Dixie | Florida | 12029 | 1460 | 19 |
1047347 | 1047347 | 2021-02-20 | Dixie | Florida | 12029 | 1457 | 19 |
1044102 | 1044102 | 2021-02-19 | Dixie | Florida | 12029 | 1454 | 18 |
1040857 | 1040857 | 2021-02-18 | Dixie | Florida | 12029 | 1451 | 17 |
1037612 | 1037612 | 2021-02-17 | Dixie | Florida | 12029 | 1448 | 17 |
1034367 | 1034367 | 2021-02-16 | Dixie | Florida | 12029 | 1439 | 17 |
1031121 | 1031121 | 2021-02-15 | Dixie | Florida | 12029 | 1435 | 17 |
1027874 | 1027874 | 2021-02-14 | Dixie | Florida | 12029 | 1435 | 16 |
1024629 | 1024629 | 2021-02-13 | Dixie | Florida | 12029 | 1429 | 15 |
1021384 | 1021384 | 2021-02-12 | Dixie | Florida | 12029 | 1428 | 15 |
1018139 | 1018139 | 2021-02-11 | Dixie | Florida | 12029 | 1427 | 15 |
1014894 | 1014894 | 2021-02-10 | Dixie | Florida | 12029 | 1424 | 14 |
1011649 | 1011649 | 2021-02-09 | Dixie | Florida | 12029 | 1418 | 14 |
1008403 | 1008403 | 2021-02-08 | Dixie | Florida | 12029 | 1412 | 14 |
1005157 | 1005157 | 2021-02-07 | Dixie | Florida | 12029 | 1410 | 14 |
1001911 | 1001911 | 2021-02-06 | Dixie | Florida | 12029 | 1410 | 14 |
998665 | 998665 | 2021-02-05 | Dixie | Florida | 12029 | 1405 | 13 |
995419 | 995419 | 2021-02-04 | Dixie | Florida | 12029 | 1400 | 13 |
992173 | 992173 | 2021-02-03 | Dixie | Florida | 12029 | 1398 | 13 |
988927 | 988927 | 2021-02-02 | Dixie | Florida | 12029 | 1397 | 13 |
985680 | 985680 | 2021-02-01 | Dixie | Florida | 12029 | 1395 | 13 |
982433 | 982433 | 2021-01-31 | Dixie | Florida | 12029 | 1394 | 13 |
979187 | 979187 | 2021-01-30 | Dixie | Florida | 12029 | 1390 | 13 |
975942 | 975942 | 2021-01-29 | Dixie | Florida | 12029 | 1385 | 13 |
972697 | 972697 | 2021-01-28 | Dixie | Florida | 12029 | 1381 | 13 |
969452 | 969452 | 2021-01-27 | Dixie | Florida | 12029 | 1374 | 13 |
966208 | 966208 | 2021-01-26 | Dixie | Florida | 12029 | 1368 | 13 |
962963 | 962963 | 2021-01-25 | Dixie | Florida | 12029 | 1366 | 13 |
959718 | 959718 | 2021-01-24 | Dixie | Florida | 12029 | 1364 | 13 |
956472 | 956472 | 2021-01-23 | Dixie | Florida | 12029 | 1357 | 12 |
953227 | 953227 | 2021-01-22 | Dixie | Florida | 12029 | 1340 | 12 |
949982 | 949982 | 2021-01-21 | Dixie | Florida | 12029 | 1332 | 12 |
946736 | 946736 | 2021-01-20 | Dixie | Florida | 12029 | 1328 | 12 |
943489 | 943489 | 2021-01-19 | Dixie | Florida | 12029 | 1322 | 12 |
940244 | 940244 | 2021-01-18 | Dixie | Florida | 12029 | 1321 | 12 |
936999 | 936999 | 2021-01-17 | Dixie | Florida | 12029 | 1316 | 12 |
933754 | 933754 | 2021-01-16 | Dixie | Florida | 12029 | 1310 | 11 |
930509 | 930509 | 2021-01-15 | Dixie | Florida | 12029 | 1300 | 11 |
927264 | 927264 | 2021-01-14 | Dixie | Florida | 12029 | 1281 | 11 |
924018 | 924018 | 2021-01-13 | Dixie | Florida | 12029 | 1259 | 11 |
920773 | 920773 | 2021-01-12 | Dixie | Florida | 12029 | 1250 | 11 |
917528 | 917528 | 2021-01-11 | Dixie | Florida | 12029 | 1238 | 11 |
914283 | 914283 | 2021-01-10 | Dixie | Florida | 12029 | 1226 | 11 |
911038 | 911038 | 2021-01-09 | Dixie | Florida | 12029 | 1211 | 11 |
907793 | 907793 | 2021-01-08 | Dixie | Florida | 12029 | 1208 | 11 |
904547 | 904547 | 2021-01-07 | Dixie | Florida | 12029 | 1193 | 11 |
901302 | 901302 | 2021-01-06 | Dixie | Florida | 12029 | 1175 | 11 |
898057 | 898057 | 2021-01-05 | Dixie | Florida | 12029 | 1163 | 11 |
894812 | 894812 | 2021-01-04 | Dixie | Florida | 12029 | 1158 | 11 |
891565 | 891565 | 2021-01-03 | Dixie | Florida | 12029 | 1154 | 11 |
888318 | 888318 | 2021-01-02 | Dixie | Florida | 12029 | 1152 | 11 |
885073 | 885073 | 2021-01-01 | Dixie | Florida | 12029 | 1115 | 11 |
881828 | 881828 | 2020-12-31 | Dixie | Florida | 12029 | 1115 | 11 |
878583 | 878583 | 2020-12-30 | Dixie | Florida | 12029 | 1099 | 11 |
875338 | 875338 | 2020-12-29 | Dixie | Florida | 12029 | 1094 | 11 |
872093 | 872093 | 2020-12-28 | Dixie | Florida | 12029 | 1088 | 11 |
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);