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-12-28 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 |
---|---|---|---|---|---|---|---|
872080 | 872080 | 2020-12-28 | Alachua | Florida | 12001 | 15473 | 128 |
872081 | 872081 | 2020-12-28 | Baker | Florida | 12003 | 2414 | 36 |
872082 | 872082 | 2020-12-28 | Bay | Florida | 12005 | 11403 | 203 |
872083 | 872083 | 2020-12-28 | Bradford | Florida | 12007 | 2118 | 23 |
872084 | 872084 | 2020-12-28 | Brevard | Florida | 12009 | 20355 | 513 |
872085 | 872085 | 2020-12-28 | Broward | Florida | 12011 | 133480 | 1828 |
872086 | 872086 | 2020-12-28 | Calhoun | Florida | 12013 | 1169 | 28 |
872087 | 872087 | 2020-12-28 | Charlotte | Florida | 12015 | 7128 | 231 |
872088 | 872088 | 2020-12-28 | Citrus | Florida | 12017 | 6467 | 260 |
872089 | 872089 | 2020-12-28 | Clay | Florida | 12019 | 10829 | 183 |
872090 | 872090 | 2020-12-28 | Collier | Florida | 12021 | 22004 | 328 |
872091 | 872091 | 2020-12-28 | Columbia | Florida | 12023 | 5837 | 117 |
872092 | 872092 | 2020-12-28 | DeSoto | Florida | 12027 | 2843 | 52 |
872093 | 872093 | 2020-12-28 | Dixie | Florida | 12029 | 1088 | 11 |
872094 | 872094 | 2020-12-28 | Duval | Florida | 12031 | 58491 | 722 |
872095 | 872095 | 2020-12-28 | Escambia | Florida | 12033 | 21507 | 360 |
872096 | 872096 | 2020-12-28 | Flagler | Florida | 12035 | 3565 | 48 |
872097 | 872097 | 2020-12-28 | Franklin | Florida | 12037 | 878 | 4 |
872098 | 872098 | 2020-12-28 | Gadsden | Florida | 12039 | 3835 | 59 |
872099 | 872099 | 2020-12-28 | Gilchrist | Florida | 12041 | 984 | 23 |
872100 | 872100 | 2020-12-28 | Glades | Florida | 12043 | 762 | 11 |
872101 | 872101 | 2020-12-28 | Gulf | Florida | 12045 | 1273 | 27 |
872102 | 872102 | 2020-12-28 | Hamilton | Florida | 12047 | 1224 | 12 |
872103 | 872103 | 2020-12-28 | Hardee | Florida | 12049 | 2057 | 20 |
872104 | 872104 | 2020-12-28 | Hendry | Florida | 12051 | 3235 | 49 |
872105 | 872105 | 2020-12-28 | Hernando | Florida | 12053 | 7074 | 264 |
872106 | 872106 | 2020-12-28 | Highlands | Florida | 12055 | 4822 | 199 |
872107 | 872107 | 2020-12-28 | Hillsborough | Florida | 12057 | 74788 | 1064 |
872108 | 872108 | 2020-12-28 | Holmes | Florida | 12059 | 1603 | 24 |
872109 | 872109 | 2020-12-28 | Indian River | Florida | 12061 | 6553 | 156 |
872110 | 872110 | 2020-12-28 | Jackson | Florida | 12063 | 4502 | 115 |
872111 | 872111 | 2020-12-28 | Jefferson | Florida | 12065 | 957 | 16 |
872112 | 872112 | 2020-12-28 | Lafayette | Florida | 12067 | 1414 | 21 |
872113 | 872113 | 2020-12-28 | Lake | Florida | 12069 | 14841 | 293 |
872114 | 872114 | 2020-12-28 | Lee | Florida | 12071 | 39331 | 652 |
872115 | 872115 | 2020-12-28 | Leon | Florida | 12073 | 18741 | 173 |
872116 | 872116 | 2020-12-28 | Levy | Florida | 12075 | 1798 | 19 |
872117 | 872117 | 2020-12-28 | Liberty | Florida | 12077 | 716 | 14 |
872118 | 872118 | 2020-12-28 | Madison | Florida | 12079 | 1516 | 33 |
872119 | 872119 | 2020-12-28 | Manatee | Florida | 12081 | 21539 | 412 |
872120 | 872120 | 2020-12-28 | Marion | Florida | 12083 | 17125 | 456 |
872121 | 872121 | 2020-12-28 | Martin | Florida | 12085 | 7656 | 207 |
872122 | 872122 | 2020-12-28 | Miami-Dade | Florida | 12086 | 290362 | 4155 |
872123 | 872123 | 2020-12-28 | Monroe | Florida | 12087 | 4168 | 35 |
872124 | 872124 | 2020-12-28 | Nassau | Florida | 12089 | 4521 | 66 |
872125 | 872125 | 2020-12-28 | Okaloosa | Florida | 12091 | 12406 | 224 |
872126 | 872126 | 2020-12-28 | Okeechobee | Florida | 12093 | 2347 | 51 |
872127 | 872127 | 2020-12-28 | Orange | Florida | 12095 | 73690 | 731 |
872128 | 872128 | 2020-12-28 | Osceola | Florida | 12097 | 24512 | 286 |
872129 | 872129 | 2020-12-28 | Palm Beach | Florida | 12099 | 80863 | 1866 |
872130 | 872130 | 2020-12-28 | Pasco | Florida | 12101 | 21222 | 360 |
872131 | 872131 | 2020-12-28 | Pinellas | Florida | 12103 | 43480 | 1035 |
872132 | 872132 | 2020-12-28 | Polk | Florida | 12105 | 35942 | 767 |
872133 | 872133 | 2020-12-28 | Putnam | Florida | 12107 | 3819 | 71 |
872134 | 872134 | 2020-12-28 | Santa Rosa | Florida | 12113 | 10575 | 122 |
872135 | 872135 | 2020-12-28 | Sarasota | Florida | 12115 | 17916 | 502 |
872136 | 872136 | 2020-12-28 | Seminole | Florida | 12117 | 17445 | 311 |
872137 | 872137 | 2020-12-28 | St. Johns | Florida | 12109 | 12481 | 112 |
872138 | 872138 | 2020-12-28 | St. Lucie | Florida | 12111 | 13864 | 393 |
872139 | 872139 | 2020-12-28 | Sumter | Florida | 12119 | 4819 | 118 |
872140 | 872140 | 2020-12-28 | Suwannee | Florida | 12121 | 3913 | 94 |
872141 | 872141 | 2020-12-28 | Taylor | Florida | 12123 | 1914 | 25 |
872142 | 872142 | 2020-12-28 | Union | Florida | 12125 | 1416 | 65 |
872143 | 872143 | 2020-12-28 | Unknown | Florida | 3088 | 0 | |
872144 | 872144 | 2020-12-28 | Volusia | Florida | 12127 | 21365 | 430 |
872145 | 872145 | 2020-12-28 | Wakulla | Florida | 12129 | 2032 | 21 |
872146 | 872146 | 2020-12-28 | Walton | Florida | 12131 | 4707 | 43 |
872147 | 872147 | 2020-12-28 | Washington | Florida | 12133 | 1907 | 30 |
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);