ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
216 rows where deaths = 17 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Sumter 49
- Franklin 46
- Hardee 11
- Brevard 10
- Pasco 10
- Baker 7
- Citrus 7
- Gilchrist 7
- Holmes 6
- Washington 6
- Dixie 4
- Hamilton 4
- Indian River 4
- Osceola 4
- Duval 3
- Hendry 3
- Jefferson 3
- Lafayette 3
- Suwannee 3
- Gulf 2
- Jackson 2
- Madison 2
- Sarasota 2
- Seminole 2
- St. Johns 2
- Union 2
- Broward 1
- Collier 1
- Gadsden 1
- Levy 1
- …
state 1
- Florida · 216 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1310347 | 1310347 | 2021-05-12 | Franklin | Florida | 12037 | 1332 | 17 |
1307101 | 1307101 | 2021-05-11 | Franklin | Florida | 12037 | 1330 | 17 |
1303855 | 1303855 | 2021-05-10 | Franklin | Florida | 12037 | 1329 | 17 |
1300608 | 1300608 | 2021-05-09 | Franklin | Florida | 12037 | 1328 | 17 |
1297361 | 1297361 | 2021-05-08 | Franklin | Florida | 12037 | 1324 | 17 |
1294115 | 1294115 | 2021-05-07 | Franklin | Florida | 12037 | 1322 | 17 |
1290869 | 1290869 | 2021-05-06 | Franklin | Florida | 12037 | 1319 | 17 |
1287623 | 1287623 | 2021-05-05 | Franklin | Florida | 12037 | 1317 | 17 |
1284377 | 1284377 | 2021-05-04 | Franklin | Florida | 12037 | 1316 | 17 |
1281130 | 1281130 | 2021-05-03 | Franklin | Florida | 12037 | 1316 | 17 |
1277883 | 1277883 | 2021-05-02 | Franklin | Florida | 12037 | 1315 | 17 |
1274636 | 1274636 | 2021-05-01 | Franklin | Florida | 12037 | 1315 | 17 |
1271389 | 1271389 | 2021-04-30 | Franklin | Florida | 12037 | 1315 | 17 |
1268142 | 1268142 | 2021-04-29 | Franklin | Florida | 12037 | 1315 | 17 |
1264895 | 1264895 | 2021-04-28 | Franklin | Florida | 12037 | 1314 | 17 |
1261648 | 1261648 | 2021-04-27 | Franklin | Florida | 12037 | 1309 | 17 |
1258401 | 1258401 | 2021-04-26 | Franklin | Florida | 12037 | 1309 | 17 |
1255154 | 1255154 | 2021-04-25 | Franklin | Florida | 12037 | 1309 | 17 |
1251907 | 1251907 | 2021-04-24 | Franklin | Florida | 12037 | 1309 | 17 |
1248660 | 1248660 | 2021-04-23 | Franklin | Florida | 12037 | 1309 | 17 |
1245413 | 1245413 | 2021-04-22 | Franklin | Florida | 12037 | 1309 | 17 |
1242166 | 1242166 | 2021-04-21 | Franklin | Florida | 12037 | 1308 | 17 |
1238919 | 1238919 | 2021-04-20 | Franklin | Florida | 12037 | 1307 | 17 |
1235672 | 1235672 | 2021-04-19 | Franklin | Florida | 12037 | 1308 | 17 |
1232425 | 1232425 | 2021-04-18 | Franklin | Florida | 12037 | 1307 | 17 |
1229176 | 1229176 | 2021-04-17 | Franklin | Florida | 12037 | 1307 | 17 |
1225928 | 1225928 | 2021-04-16 | Franklin | Florida | 12037 | 1305 | 17 |
1222681 | 1222681 | 2021-04-15 | Franklin | Florida | 12037 | 1304 | 17 |
1219433 | 1219433 | 2021-04-14 | Franklin | Florida | 12037 | 1305 | 17 |
1216185 | 1216185 | 2021-04-13 | Franklin | Florida | 12037 | 1303 | 17 |
1190198 | 1190198 | 2021-04-05 | Franklin | Florida | 12037 | 1296 | 17 |
1186951 | 1186951 | 2021-04-04 | Franklin | Florida | 12037 | 1296 | 17 |
1183704 | 1183704 | 2021-04-03 | Franklin | Florida | 12037 | 1296 | 17 |
1180457 | 1180457 | 2021-04-02 | Franklin | Florida | 12037 | 1296 | 17 |
1177210 | 1177210 | 2021-04-01 | Franklin | Florida | 12037 | 1296 | 17 |
1173963 | 1173963 | 2021-03-31 | Franklin | Florida | 12037 | 1295 | 17 |
1170716 | 1170716 | 2021-03-30 | Franklin | Florida | 12037 | 1295 | 17 |
1131770 | 1131770 | 2021-03-18 | Liberty | Florida | 12077 | 1051 | 17 |
1099286 | 1099286 | 2021-03-08 | Franklin | Florida | 12037 | 1279 | 17 |
1096038 | 1096038 | 2021-03-07 | Franklin | Florida | 12037 | 1279 | 17 |
1092792 | 1092792 | 2021-03-06 | Franklin | Florida | 12037 | 1279 | 17 |
1089546 | 1089546 | 2021-03-05 | Franklin | Florida | 12037 | 1279 | 17 |
1086301 | 1086301 | 2021-03-04 | Franklin | Florida | 12037 | 1279 | 17 |
1083055 | 1083055 | 2021-03-03 | Franklin | Florida | 12037 | 1279 | 17 |
1079809 | 1079809 | 2021-03-02 | Franklin | Florida | 12037 | 1279 | 17 |
1076564 | 1076564 | 2021-03-01 | Franklin | Florida | 12037 | 1279 | 17 |
1073318 | 1073318 | 2021-02-28 | Franklin | Florida | 12037 | 1279 | 17 |
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 |
988936 | 988936 | 2021-02-02 | Hamilton | Florida | 12047 | 1508 | 17 |
985689 | 985689 | 2021-02-01 | Hamilton | Florida | 12047 | 1502 | 17 |
982442 | 982442 | 2021-01-31 | Hamilton | Florida | 12047 | 1501 | 17 |
979196 | 979196 | 2021-01-30 | Hamilton | Florida | 12047 | 1497 | 17 |
894830 | 894830 | 2021-01-04 | Jefferson | Florida | 12065 | 1040 | 17 |
891583 | 891583 | 2021-01-03 | Jefferson | Florida | 12065 | 1036 | 17 |
888336 | 888336 | 2021-01-02 | Jefferson | Florida | 12065 | 1032 | 17 |
826681 | 826681 | 2020-12-14 | Levy | Florida | 12075 | 1588 | 17 |
823426 | 823426 | 2020-12-13 | Holmes | Florida | 12059 | 1315 | 17 |
820180 | 820180 | 2020-12-12 | Holmes | Florida | 12059 | 1314 | 17 |
816934 | 816934 | 2020-12-11 | Holmes | Florida | 12059 | 1305 | 17 |
813688 | 813688 | 2020-12-10 | Holmes | Florida | 12059 | 1293 | 17 |
810444 | 810444 | 2020-12-09 | Holmes | Florida | 12059 | 1276 | 17 |
807199 | 807199 | 2020-12-08 | Holmes | Florida | 12059 | 1266 | 17 |
729302 | 729302 | 2020-11-14 | Gulf | Florida | 12045 | 1013 | 17 |
726059 | 726059 | 2020-11-13 | Gulf | Florida | 12045 | 1012 | 17 |
722818 | 722818 | 2020-11-12 | Hardee | Florida | 12049 | 1678 | 17 |
719575 | 719575 | 2020-11-11 | Hardee | Florida | 12049 | 1669 | 17 |
716332 | 716332 | 2020-11-10 | Hardee | Florida | 12049 | 1662 | 17 |
713088 | 713088 | 2020-11-09 | Hardee | Florida | 12049 | 1658 | 17 |
713097 | 713097 | 2020-11-09 | Lafayette | Florida | 12067 | 1293 | 17 |
709844 | 709844 | 2020-11-08 | Hardee | Florida | 12049 | 1654 | 17 |
709853 | 709853 | 2020-11-08 | Lafayette | Florida | 12067 | 1291 | 17 |
706600 | 706600 | 2020-11-07 | Hardee | Florida | 12049 | 1645 | 17 |
706609 | 706609 | 2020-11-07 | Lafayette | Florida | 12067 | 1290 | 17 |
703357 | 703357 | 2020-11-06 | Hardee | Florida | 12049 | 1641 | 17 |
700114 | 700114 | 2020-11-05 | Hardee | Florida | 12049 | 1640 | 17 |
696870 | 696870 | 2020-11-04 | Hardee | Florida | 12049 | 1633 | 17 |
693628 | 693628 | 2020-11-03 | Hardee | Florida | 12049 | 1630 | 17 |
690385 | 690385 | 2020-11-02 | Hardee | Florida | 12049 | 1627 | 17 |
651437 | 651437 | 2020-10-21 | Baker | Florida | 12003 | 1709 | 17 |
648193 | 648193 | 2020-10-20 | Baker | Florida | 12003 | 1697 | 17 |
644948 | 644948 | 2020-10-19 | Baker | Florida | 12003 | 1691 | 17 |
641700 | 641700 | 2020-10-18 | Baker | Florida | 12003 | 1685 | 17 |
641718 | 641718 | 2020-10-18 | Gilchrist | Florida | 12041 | 540 | 17 |
638453 | 638453 | 2020-10-17 | Baker | Florida | 12003 | 1681 | 17 |
638471 | 638471 | 2020-10-17 | Gilchrist | Florida | 12041 | 540 | 17 |
635208 | 635208 | 2020-10-16 | Baker | Florida | 12003 | 1672 | 17 |
635226 | 635226 | 2020-10-16 | Gilchrist | Florida | 12041 | 540 | 17 |
631962 | 631962 | 2020-10-15 | Baker | Florida | 12003 | 1655 | 17 |
631980 | 631980 | 2020-10-15 | Gilchrist | Florida | 12041 | 538 | 17 |
628736 | 628736 | 2020-10-14 | Gilchrist | Florida | 12041 | 531 | 17 |
625493 | 625493 | 2020-10-13 | Gilchrist | Florida | 12041 | 528 | 17 |
622250 | 622250 | 2020-10-12 | Gilchrist | Florida | 12041 | 527 | 17 |
593112 | 593112 | 2020-10-03 | Union | Florida | 12125 | 989 | 17 |
589872 | 589872 | 2020-10-02 | Union | Florida | 12125 | 986 | 17 |
538018 | 538018 | 2020-09-16 | Madison | Florida | 12079 | 993 | 17 |
515395 | 515395 | 2020-09-09 | Washington | Florida | 12133 | 1031 | 17 |
512162 | 512162 | 2020-09-08 | Washington | Florida | 12133 | 1031 | 17 |
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);