ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
68 rows where "date" is on date 2021-05-01 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Alachua 1
- Baker 1
- Bay 1
- Bradford 1
- Brevard 1
- Broward 1
- Calhoun 1
- Charlotte 1
- Citrus 1
- Clay 1
- Collier 1
- Columbia 1
- DeSoto 1
- Dixie 1
- Duval 1
- Escambia 1
- Flagler 1
- Franklin 1
- Gadsden 1
- Gilchrist 1
- Glades 1
- Gulf 1
- Hamilton 1
- Hardee 1
- Hendry 1
- Hernando 1
- Highlands 1
- Hillsborough 1
- Holmes 1
- Indian River 1
- …
state 1
- Florida · 68 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1274619 | 1274619 | 2021-05-01 | Alachua | Florida | 12001 | 24678 | 275 |
1274620 | 1274620 | 2021-05-01 | Baker | Florida | 12003 | 3484 | 60 |
1274621 | 1274621 | 2021-05-01 | Bay | Florida | 12005 | 20028 | 386 |
1274622 | 1274622 | 2021-05-01 | Bradford | Florida | 12007 | 2999 | 56 |
1274623 | 1274623 | 2021-05-01 | Brevard | Florida | 12009 | 41041 | 861 |
1274624 | 1274624 | 2021-05-01 | Broward | Florida | 12011 | 236592 | 2902 |
1274625 | 1274625 | 2021-05-01 | Calhoun | Florida | 12013 | 1688 | 43 |
1274626 | 1274626 | 2021-05-01 | Charlotte | Florida | 12015 | 12750 | 416 |
1274627 | 1274627 | 2021-05-01 | Citrus | Florida | 12017 | 11007 | 444 |
1274628 | 1274628 | 2021-05-01 | Clay | Florida | 12019 | 18467 | 340 |
1274629 | 1274629 | 2021-05-01 | Collier | Florida | 12021 | 35451 | 528 |
1274630 | 1274630 | 2021-05-01 | Columbia | Florida | 12023 | 8093 | 169 |
1274631 | 1274631 | 2021-05-01 | DeSoto | Florida | 12027 | 4301 | 93 |
1274632 | 1274632 | 2021-05-01 | Dixie | Florida | 12029 | 1605 | 24 |
1274633 | 1274633 | 2021-05-01 | Duval | Florida | 12031 | 97495 | 1391 |
1274634 | 1274634 | 2021-05-01 | Escambia | Florida | 12033 | 35962 | 679 |
1274635 | 1274635 | 2021-05-01 | Flagler | Florida | 12035 | 7220 | 111 |
1274636 | 1274636 | 2021-05-01 | Franklin | Florida | 12037 | 1315 | 17 |
1274637 | 1274637 | 2021-05-01 | Gadsden | Florida | 12039 | 5646 | 94 |
1274638 | 1274638 | 2021-05-01 | Gilchrist | Florida | 12041 | 1604 | 43 |
1274639 | 1274639 | 2021-05-01 | Glades | Florida | 12043 | 952 | 19 |
1274640 | 1274640 | 2021-05-01 | Gulf | Florida | 12045 | 1954 | 42 |
1274641 | 1274641 | 2021-05-01 | Hamilton | Florida | 12047 | 1624 | 25 |
1274642 | 1274642 | 2021-05-01 | Hardee | Florida | 12049 | 3117 | 43 |
1274643 | 1274643 | 2021-05-01 | Hendry | Florida | 12051 | 4703 | 82 |
1274644 | 1274644 | 2021-05-01 | Hernando | Florida | 12053 | 13768 | 459 |
1274645 | 1274645 | 2021-05-01 | Highlands | Florida | 12055 | 8457 | 351 |
1274646 | 1274646 | 2021-05-01 | Hillsborough | Florida | 12057 | 135705 | 1711 |
1274647 | 1274647 | 2021-05-01 | Holmes | Florida | 12059 | 2241 | 49 |
1274648 | 1274648 | 2021-05-01 | Indian River | Florida | 12061 | 12438 | 299 |
1274649 | 1274649 | 2021-05-01 | Jackson | Florida | 12063 | 6180 | 156 |
1274650 | 1274650 | 2021-05-01 | Jefferson | Florida | 12065 | 1485 | 27 |
1274651 | 1274651 | 2021-05-01 | Lafayette | Florida | 12067 | 1616 | 26 |
1274652 | 1274652 | 2021-05-01 | Lake | Florida | 12069 | 29369 | 633 |
1274653 | 1274653 | 2021-05-01 | Lee | Florida | 12071 | 69650 | 959 |
1274654 | 1274654 | 2021-05-01 | Leon | Florida | 12073 | 31655 | 314 |
1274655 | 1274655 | 2021-05-01 | Levy | Florida | 12075 | 3410 | 53 |
1274656 | 1274656 | 2021-05-01 | Liberty | Florida | 12077 | 1071 | 16 |
1274657 | 1274657 | 2021-05-01 | Madison | Florida | 12079 | 2050 | 45 |
1274658 | 1274658 | 2021-05-01 | Manatee | Florida | 12081 | 38237 | 664 |
1274659 | 1274659 | 2021-05-01 | Marion | Florida | 12083 | 30845 | 955 |
1274660 | 1274660 | 2021-05-01 | Martin | Florida | 12085 | 12215 | 320 |
1274661 | 1274661 | 2021-05-01 | Miami-Dade | Florida | 12086 | 484513 | 6175 |
1274662 | 1274662 | 2021-05-01 | Monroe | Florida | 12087 | 6916 | 49 |
1274663 | 1274663 | 2021-05-01 | Nassau | Florida | 12089 | 8329 | 124 |
1274664 | 1274664 | 2021-05-01 | Okaloosa | Florida | 12091 | 20447 | 361 |
1274665 | 1274665 | 2021-05-01 | Okeechobee | Florida | 12093 | 3977 | 88 |
1274666 | 1274666 | 2021-05-01 | Orange | Florida | 12095 | 136672 | 1248 |
1274667 | 1274667 | 2021-05-01 | Osceola | Florida | 12097 | 44174 | 500 |
1274668 | 1274668 | 2021-05-01 | Palm Beach | Florida | 12099 | 143469 | 2770 |
1274669 | 1274669 | 2021-05-01 | Pasco | Florida | 12101 | 40808 | 743 |
1274670 | 1274670 | 2021-05-01 | Pinellas | Florida | 12103 | 78971 | 1609 |
1274671 | 1274671 | 2021-05-01 | Polk | Florida | 12105 | 67819 | 1310 |
1274672 | 1274672 | 2021-05-01 | Putnam | Florida | 12107 | 6444 | 145 |
1274673 | 1274673 | 2021-05-01 | Santa Rosa | Florida | 12113 | 18159 | 285 |
1274674 | 1274674 | 2021-05-01 | Sarasota | Florida | 12115 | 32479 | 812 |
1274675 | 1274675 | 2021-05-01 | Seminole | Florida | 12117 | 33775 | 488 |
1274676 | 1274676 | 2021-05-01 | St. Johns | Florida | 12109 | 22434 | 209 |
1274677 | 1274677 | 2021-05-01 | St. Lucie | Florida | 12111 | 26094 | 626 |
1274678 | 1274678 | 2021-05-01 | Sumter | Florida | 12119 | 9270 | 275 |
1274679 | 1274679 | 2021-05-01 | Suwannee | Florida | 12121 | 5321 | 138 |
1274680 | 1274680 | 2021-05-01 | Taylor | Florida | 12123 | 2720 | 46 |
1274681 | 1274681 | 2021-05-01 | Union | Florida | 12125 | 1817 | 72 |
1274682 | 1274682 | 2021-05-01 | Unknown | Florida | 3454 | 0 | |
1274683 | 1274683 | 2021-05-01 | Volusia | Florida | 12127 | 42824 | 792 |
1274684 | 1274684 | 2021-05-01 | Wakulla | Florida | 12129 | 3414 | 55 |
1274685 | 1274685 | 2021-05-01 | Walton | Florida | 12131 | 7739 | 87 |
1274686 | 1274686 | 2021-05-01 | Washington | Florida | 12133 | 2722 | 51 |
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);