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 2020-10-14 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 |
---|---|---|---|---|---|---|---|
628717 | 628717 | 2020-10-14 | Alachua | Florida | 12001 | 9133 | 70 |
628718 | 628718 | 2020-10-14 | Baker | Florida | 12003 | 1642 | 16 |
628719 | 628719 | 2020-10-14 | Bay | Florida | 12005 | 6366 | 122 |
628720 | 628720 | 2020-10-14 | Bradford | Florida | 12007 | 1187 | 11 |
628721 | 628721 | 2020-10-14 | Brevard | Florida | 12009 | 10110 | 331 |
628722 | 628722 | 2020-10-14 | Broward | Florida | 12011 | 79876 | 1484 |
628723 | 628723 | 2020-10-14 | Calhoun | Florida | 12013 | 653 | 14 |
628724 | 628724 | 2020-10-14 | Charlotte | Florida | 12015 | 3287 | 150 |
628725 | 628725 | 2020-10-14 | Citrus | Florida | 12017 | 2983 | 124 |
628726 | 628726 | 2020-10-14 | Clay | Florida | 12019 | 5556 | 111 |
628727 | 628727 | 2020-10-14 | Collier | Florida | 12021 | 13382 | 239 |
628728 | 628728 | 2020-10-14 | Columbia | Florida | 12023 | 4034 | 68 |
628729 | 628729 | 2020-10-14 | DeSoto | Florida | 12027 | 1609 | 27 |
628730 | 628730 | 2020-10-14 | Dixie | Florida | 12029 | 860 | 11 |
628731 | 628731 | 2020-10-14 | Duval | Florida | 12031 | 32311 | 494 |
628732 | 628732 | 2020-10-14 | Escambia | Florida | 12033 | 12737 | 264 |
628733 | 628733 | 2020-10-14 | Flagler | Florida | 12035 | 1892 | 33 |
628734 | 628734 | 2020-10-14 | Franklin | Florida | 12037 | 676 | 4 |
628735 | 628735 | 2020-10-14 | Gadsden | Florida | 12039 | 2991 | 51 |
628736 | 628736 | 2020-10-14 | Gilchrist | Florida | 12041 | 531 | 17 |
628737 | 628737 | 2020-10-14 | Glades | Florida | 12043 | 581 | 6 |
628738 | 628738 | 2020-10-14 | Gulf | Florida | 12045 | 911 | 15 |
628739 | 628739 | 2020-10-14 | Hamilton | Florida | 12047 | 889 | 9 |
628740 | 628740 | 2020-10-14 | Hardee | Florida | 12049 | 1479 | 11 |
628741 | 628741 | 2020-10-14 | Hendry | Florida | 12051 | 2128 | 43 |
628742 | 628742 | 2020-10-14 | Hernando | Florida | 12053 | 3324 | 149 |
628743 | 628743 | 2020-10-14 | Highlands | Florida | 12055 | 2398 | 100 |
628744 | 628744 | 2020-10-14 | Hillsborough | Florida | 12057 | 44652 | 720 |
628745 | 628745 | 2020-10-14 | Holmes | Florida | 12059 | 803 | 10 |
628746 | 628746 | 2020-10-14 | Indian River | Florida | 12061 | 3458 | 119 |
628747 | 628747 | 2020-10-14 | Jackson | Florida | 12063 | 2986 | 83 |
628748 | 628748 | 2020-10-14 | Jefferson | Florida | 12065 | 603 | 9 |
628749 | 628749 | 2020-10-14 | Lafayette | Florida | 12067 | 1253 | 15 |
628750 | 628750 | 2020-10-14 | Lake | Florida | 12069 | 8012 | 211 |
628751 | 628751 | 2020-10-14 | Lee | Florida | 12071 | 21488 | 485 |
628752 | 628752 | 2020-10-14 | Leon | Florida | 12073 | 11412 | 93 |
628753 | 628753 | 2020-10-14 | Levy | Florida | 12075 | 1089 | 10 |
628754 | 628754 | 2020-10-14 | Liberty | Florida | 12077 | 520 | 10 |
628755 | 628755 | 2020-10-14 | Madison | Florida | 12079 | 1047 | 24 |
628756 | 628756 | 2020-10-14 | Manatee | Florida | 12081 | 12270 | 310 |
628757 | 628757 | 2020-10-14 | Marion | Florida | 12083 | 10258 | 330 |
628758 | 628758 | 2020-10-14 | Martin | Florida | 12085 | 5102 | 151 |
628759 | 628759 | 2020-10-14 | Miami-Dade | Florida | 12086 | 176270 | 3485 |
628760 | 628760 | 2020-10-14 | Monroe | Florida | 12087 | 1979 | 24 |
628761 | 628761 | 2020-10-14 | Nassau | Florida | 12089 | 2297 | 50 |
628762 | 628762 | 2020-10-14 | Okaloosa | Florida | 12091 | 5490 | 125 |
628763 | 628763 | 2020-10-14 | Okeechobee | Florida | 12093 | 1650 | 35 |
628764 | 628764 | 2020-10-14 | Orange | Florida | 12095 | 42571 | 522 |
628765 | 628765 | 2020-10-14 | Osceola | Florida | 12097 | 13250 | 174 |
628766 | 628766 | 2020-10-14 | Palm Beach | Florida | 12099 | 48335 | 1465 |
628767 | 628767 | 2020-10-14 | Pasco | Florida | 12101 | 9989 | 219 |
628768 | 628768 | 2020-10-14 | Pinellas | Florida | 12103 | 23510 | 788 |
628769 | 628769 | 2020-10-14 | Polk | Florida | 12105 | 21354 | 563 |
628770 | 628770 | 2020-10-14 | Putnam | Florida | 12107 | 2229 | 46 |
628771 | 628771 | 2020-10-14 | Santa Rosa | Florida | 12113 | 5616 | 84 |
628772 | 628772 | 2020-10-14 | Sarasota | Florida | 12115 | 8786 | 291 |
628773 | 628773 | 2020-10-14 | Seminole | Florida | 12117 | 9524 | 231 |
628774 | 628774 | 2020-10-14 | St. Johns | Florida | 12109 | 5814 | 77 |
628775 | 628775 | 2020-10-14 | St. Lucie | Florida | 12111 | 8443 | 310 |
628776 | 628776 | 2020-10-14 | Sumter | Florida | 12119 | 2700 | 77 |
628777 | 628777 | 2020-10-14 | Suwannee | Florida | 12121 | 2861 | 75 |
628778 | 628778 | 2020-10-14 | Taylor | Florida | 12123 | 1406 | 14 |
628779 | 628779 | 2020-10-14 | Union | Florida | 12125 | 1041 | 25 |
628780 | 628780 | 2020-10-14 | Unknown | Florida | 1906 | 0 | |
628781 | 628781 | 2020-10-14 | Volusia | Florida | 12127 | 11649 | 296 |
628782 | 628782 | 2020-10-14 | Wakulla | Florida | 12129 | 1209 | 11 |
628783 | 628783 | 2020-10-14 | Walton | Florida | 12131 | 2142 | 29 |
628784 | 628784 | 2020-10-14 | Washington | Florida | 12133 | 1124 | 24 |
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);