ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
147 rows where deaths = 50 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Monroe 23
- Nassau 16
- Washington 16
- Franklin 14
- Putnam 14
- Columbia 7
- Okeechobee 6
- Gadsden 5
- Okaloosa 4
- St. Johns 3
- St. Lucie 3
- Sumter 3
- Walton 3
- Brevard 2
- Clay 2
- DeSoto 2
- Flagler 2
- Indian River 2
- Levy 2
- Santa Rosa 2
- Suwannee 2
- Bradford 1
- Citrus 1
- Duval 1
- Hendry 1
- Hernando 1
- Highlands 1
- Lake 1
- Marion 1
- Miami-Dade 1
- …
state 1
- Florida · 147 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2470641 | 2470641 | 2022-05-04 | Unknown | Florida | 47000 | 50 | |
2307864 | 2307864 | 2022-03-15 | Franklin | Florida | 12037 | 3070 | 50 |
2304613 | 2304613 | 2022-03-14 | Franklin | Florida | 12037 | 3070 | 50 |
2301361 | 2301361 | 2022-03-13 | Franklin | Florida | 12037 | 3070 | 50 |
2298109 | 2298109 | 2022-03-12 | Franklin | Florida | 12037 | 3070 | 50 |
2294857 | 2294857 | 2022-03-11 | Franklin | Florida | 12037 | 3070 | 50 |
2291605 | 2291605 | 2022-03-10 | Franklin | Florida | 12037 | 3067 | 50 |
2288353 | 2288353 | 2022-03-09 | Franklin | Florida | 12037 | 3067 | 50 |
2285102 | 2285102 | 2022-03-08 | Franklin | Florida | 12037 | 3067 | 50 |
2281850 | 2281850 | 2022-03-07 | Franklin | Florida | 12037 | 3067 | 50 |
2278597 | 2278597 | 2022-03-06 | Franklin | Florida | 12037 | 3067 | 50 |
2275344 | 2275344 | 2022-03-05 | Franklin | Florida | 12037 | 3067 | 50 |
2272091 | 2272091 | 2022-03-04 | Franklin | Florida | 12037 | 3067 | 50 |
2268839 | 2268839 | 2022-03-03 | Franklin | Florida | 12037 | 3067 | 50 |
2265586 | 2265586 | 2022-03-02 | Franklin | Florida | 12037 | 3067 | 50 |
1372059 | 1372059 | 2021-05-31 | Monroe | Florida | 12087 | 7091 | 50 |
1368814 | 1368814 | 2021-05-30 | Monroe | Florida | 12087 | 7091 | 50 |
1365568 | 1365568 | 2021-05-29 | Monroe | Florida | 12087 | 7091 | 50 |
1362322 | 1362322 | 2021-05-28 | Monroe | Florida | 12087 | 7091 | 50 |
1359075 | 1359075 | 2021-05-27 | Monroe | Florida | 12087 | 7085 | 50 |
1355829 | 1355829 | 2021-05-26 | Monroe | Florida | 12087 | 7083 | 50 |
1352583 | 1352583 | 2021-05-25 | Monroe | Florida | 12087 | 7081 | 50 |
1349337 | 1349337 | 2021-05-24 | Monroe | Florida | 12087 | 7080 | 50 |
1346090 | 1346090 | 2021-05-23 | Monroe | Florida | 12087 | 7076 | 50 |
1342842 | 1342842 | 2021-05-22 | Monroe | Florida | 12087 | 7067 | 50 |
1339594 | 1339594 | 2021-05-21 | Monroe | Florida | 12087 | 7058 | 50 |
1251926 | 1251926 | 2021-04-24 | Levy | Florida | 12075 | 3362 | 50 |
1248679 | 1248679 | 2021-04-23 | Levy | Florida | 12075 | 3353 | 50 |
1242192 | 1242192 | 2021-04-21 | Monroe | Florida | 12087 | 6778 | 50 |
1238945 | 1238945 | 2021-04-20 | Monroe | Florida | 12087 | 6757 | 50 |
1235698 | 1235698 | 2021-04-19 | Monroe | Florida | 12087 | 6752 | 50 |
1232451 | 1232451 | 2021-04-18 | Monroe | Florida | 12087 | 6742 | 50 |
1229202 | 1229202 | 2021-04-17 | Monroe | Florida | 12087 | 6731 | 50 |
1225954 | 1225954 | 2021-04-16 | Monroe | Florida | 12087 | 6711 | 50 |
1222707 | 1222707 | 2021-04-15 | Monroe | Florida | 12087 | 6695 | 50 |
1219459 | 1219459 | 2021-04-14 | Monroe | Florida | 12087 | 6674 | 50 |
1216211 | 1216211 | 2021-04-13 | Monroe | Florida | 12087 | 6662 | 50 |
1216235 | 1216235 | 2021-04-13 | Washington | Florida | 12133 | 2695 | 50 |
1212964 | 1212964 | 2021-04-12 | Monroe | Florida | 12087 | 6642 | 50 |
1212988 | 1212988 | 2021-04-12 | Washington | Florida | 12133 | 2694 | 50 |
1209716 | 1209716 | 2021-04-11 | Monroe | Florida | 12087 | 6642 | 50 |
1209740 | 1209740 | 2021-04-11 | Washington | Florida | 12133 | 2693 | 50 |
1206467 | 1206467 | 2021-04-10 | Monroe | Florida | 12087 | 6630 | 50 |
1206491 | 1206491 | 2021-04-10 | Washington | Florida | 12133 | 2692 | 50 |
1203243 | 1203243 | 2021-04-09 | Washington | Florida | 12133 | 2689 | 50 |
1199995 | 1199995 | 2021-04-08 | Washington | Florida | 12133 | 2685 | 50 |
1196746 | 1196746 | 2021-04-07 | Washington | Florida | 12133 | 2681 | 50 |
1193498 | 1193498 | 2021-04-06 | Washington | Florida | 12133 | 2678 | 50 |
1190248 | 1190248 | 2021-04-05 | Washington | Florida | 12133 | 2678 | 50 |
1187001 | 1187001 | 2021-04-04 | Washington | Florida | 12133 | 2678 | 50 |
1183754 | 1183754 | 2021-04-03 | Washington | Florida | 12133 | 2678 | 50 |
1180507 | 1180507 | 2021-04-02 | Washington | Florida | 12133 | 2678 | 50 |
1177260 | 1177260 | 2021-04-01 | Washington | Florida | 12133 | 2673 | 50 |
1174013 | 1174013 | 2021-03-31 | Washington | Florida | 12133 | 2673 | 50 |
1170766 | 1170766 | 2021-03-30 | Washington | Florida | 12133 | 2670 | 50 |
1167518 | 1167518 | 2021-03-29 | Washington | Florida | 12133 | 2670 | 50 |
1053831 | 1053831 | 2021-02-22 | Bradford | Florida | 12007 | 2814 | 50 |
911041 | 911041 | 2021-01-09 | Flagler | Florida | 12035 | 4279 | 50 |
907796 | 907796 | 2021-01-08 | Flagler | Florida | 12035 | 4220 | 50 |
898068 | 898068 | 2021-01-05 | Hendry | Florida | 12051 | 3457 | 50 |
898110 | 898110 | 2021-01-05 | Walton | Florida | 12131 | 5171 | 50 |
894865 | 894865 | 2021-01-04 | Walton | Florida | 12131 | 5113 | 50 |
891618 | 891618 | 2021-01-03 | Walton | Florida | 12131 | 5072 | 50 |
862391 | 862391 | 2020-12-25 | Okeechobee | Florida | 12093 | 2308 | 50 |
859146 | 859146 | 2020-12-24 | Okeechobee | Florida | 12093 | 2308 | 50 |
855901 | 855901 | 2020-12-23 | Okeechobee | Florida | 12093 | 2298 | 50 |
852656 | 852656 | 2020-12-22 | Okeechobee | Florida | 12093 | 2285 | 50 |
849411 | 849411 | 2020-12-21 | Okeechobee | Florida | 12093 | 2261 | 50 |
846166 | 846166 | 2020-12-20 | Okeechobee | Florida | 12093 | 2252 | 50 |
842886 | 842886 | 2020-12-19 | DeSoto | Florida | 12027 | 2719 | 50 |
839641 | 839641 | 2020-12-18 | DeSoto | Florida | 12027 | 2707 | 50 |
693658 | 693658 | 2020-11-03 | Putnam | Florida | 12107 | 2426 | 50 |
690415 | 690415 | 2020-11-02 | Putnam | Florida | 12107 | 2416 | 50 |
687170 | 687170 | 2020-11-01 | Putnam | Florida | 12107 | 2412 | 50 |
683926 | 683926 | 2020-10-31 | Putnam | Florida | 12107 | 2402 | 50 |
680683 | 680683 | 2020-10-30 | Putnam | Florida | 12107 | 2398 | 50 |
677440 | 677440 | 2020-10-29 | Putnam | Florida | 12107 | 2386 | 50 |
674197 | 674197 | 2020-10-28 | Putnam | Florida | 12107 | 2374 | 50 |
670955 | 670955 | 2020-10-27 | Putnam | Florida | 12107 | 2362 | 50 |
667703 | 667703 | 2020-10-26 | Nassau | Florida | 12089 | 2441 | 50 |
667712 | 667712 | 2020-10-26 | Putnam | Florida | 12107 | 2355 | 50 |
664458 | 664458 | 2020-10-25 | Nassau | Florida | 12089 | 2429 | 50 |
664467 | 664467 | 2020-10-25 | Putnam | Florida | 12107 | 2355 | 50 |
661214 | 661214 | 2020-10-24 | Nassau | Florida | 12089 | 2419 | 50 |
661223 | 661223 | 2020-10-24 | Putnam | Florida | 12107 | 2348 | 50 |
657970 | 657970 | 2020-10-23 | Nassau | Florida | 12089 | 2401 | 50 |
657979 | 657979 | 2020-10-23 | Putnam | Florida | 12107 | 2337 | 50 |
654725 | 654725 | 2020-10-22 | Nassau | Florida | 12089 | 2387 | 50 |
654734 | 654734 | 2020-10-22 | Putnam | Florida | 12107 | 2323 | 50 |
651480 | 651480 | 2020-10-21 | Nassau | Florida | 12089 | 2360 | 50 |
651489 | 651489 | 2020-10-21 | Putnam | Florida | 12107 | 2294 | 50 |
648236 | 648236 | 2020-10-20 | Nassau | Florida | 12089 | 2351 | 50 |
644991 | 644991 | 2020-10-19 | Nassau | Florida | 12089 | 2343 | 50 |
641743 | 641743 | 2020-10-18 | Nassau | Florida | 12089 | 2342 | 50 |
638496 | 638496 | 2020-10-17 | Nassau | Florida | 12089 | 2335 | 50 |
635251 | 635251 | 2020-10-16 | Nassau | Florida | 12089 | 2319 | 50 |
632005 | 632005 | 2020-10-15 | Nassau | Florida | 12089 | 2309 | 50 |
628761 | 628761 | 2020-10-14 | Nassau | Florida | 12089 | 2297 | 50 |
625492 | 625492 | 2020-10-13 | Gadsden | Florida | 12039 | 2990 | 50 |
625518 | 625518 | 2020-10-13 | Nassau | Florida | 12089 | 2282 | 50 |
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);