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-11-22 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 |
---|---|---|---|---|---|---|---|
755248 | 755248 | 2020-11-22 | Alachua | Florida | 12001 | 12339 | 96 |
755249 | 755249 | 2020-11-22 | Baker | Florida | 12003 | 1958 | 29 |
755250 | 755250 | 2020-11-22 | Bay | Florida | 12005 | 8169 | 150 |
755251 | 755251 | 2020-11-22 | Bradford | Florida | 12007 | 1372 | 18 |
755252 | 755252 | 2020-11-22 | Brevard | Florida | 12009 | 14564 | 428 |
755253 | 755253 | 2020-11-22 | Broward | Florida | 12011 | 101059 | 1626 |
755254 | 755254 | 2020-11-22 | Calhoun | Florida | 12013 | 834 | 21 |
755255 | 755255 | 2020-11-22 | Charlotte | Florida | 12015 | 4672 | 181 |
755256 | 755256 | 2020-11-22 | Citrus | Florida | 12017 | 4330 | 157 |
755257 | 755257 | 2020-11-22 | Clay | Florida | 12019 | 7403 | 144 |
755258 | 755258 | 2020-11-22 | Collier | Florida | 12021 | 16864 | 276 |
755259 | 755259 | 2020-11-22 | Columbia | Florida | 12023 | 4612 | 90 |
755260 | 755260 | 2020-11-22 | DeSoto | Florida | 12027 | 2196 | 33 |
755261 | 755261 | 2020-11-22 | Dixie | Florida | 12029 | 954 | 11 |
755262 | 755262 | 2020-11-22 | Duval | Florida | 12031 | 40584 | 565 |
755263 | 755263 | 2020-11-22 | Escambia | Florida | 12033 | 15926 | 296 |
755264 | 755264 | 2020-11-22 | Flagler | Florida | 12035 | 2561 | 41 |
755265 | 755265 | 2020-11-22 | Franklin | Florida | 12037 | 826 | 4 |
755266 | 755266 | 2020-11-22 | Gadsden | Florida | 12039 | 3219 | 57 |
755267 | 755267 | 2020-11-22 | Gilchrist | Florida | 12041 | 727 | 19 |
755268 | 755268 | 2020-11-22 | Glades | Florida | 12043 | 654 | 8 |
755269 | 755269 | 2020-11-22 | Gulf | Florida | 12045 | 1043 | 18 |
755270 | 755270 | 2020-11-22 | Hamilton | Florida | 12047 | 957 | 11 |
755271 | 755271 | 2020-11-22 | Hardee | Florida | 12049 | 1730 | 18 |
755272 | 755272 | 2020-11-22 | Hendry | Florida | 12051 | 2431 | 45 |
755273 | 755273 | 2020-11-22 | Hernando | Florida | 12053 | 4596 | 197 |
755274 | 755274 | 2020-11-22 | Highlands | Florida | 12055 | 3507 | 143 |
755275 | 755275 | 2020-11-22 | Hillsborough | Florida | 12057 | 55482 | 885 |
755276 | 755276 | 2020-11-22 | Holmes | Florida | 12059 | 1103 | 14 |
755277 | 755277 | 2020-11-22 | Indian River | Florida | 12061 | 4743 | 131 |
755278 | 755278 | 2020-11-22 | Jackson | Florida | 12063 | 3712 | 89 |
755279 | 755279 | 2020-11-22 | Jefferson | Florida | 12065 | 736 | 11 |
755280 | 755280 | 2020-11-22 | Lafayette | Florida | 12067 | 1305 | 19 |
755281 | 755281 | 2020-11-22 | Lake | Florida | 12069 | 10084 | 244 |
755282 | 755282 | 2020-11-22 | Lee | Florida | 12071 | 28114 | 561 |
755283 | 755283 | 2020-11-22 | Leon | Florida | 12073 | 14284 | 128 |
755284 | 755284 | 2020-11-22 | Levy | Florida | 12075 | 1334 | 13 |
755285 | 755285 | 2020-11-22 | Liberty | Florida | 12077 | 567 | 14 |
755286 | 755286 | 2020-11-22 | Madison | Florida | 12079 | 1226 | 26 |
755287 | 755287 | 2020-11-22 | Manatee | Florida | 12081 | 15723 | 365 |
755288 | 755288 | 2020-11-22 | Marion | Florida | 12083 | 12401 | 374 |
755289 | 755289 | 2020-11-22 | Martin | Florida | 12085 | 5964 | 170 |
755290 | 755290 | 2020-11-22 | Miami-Dade | Florida | 12086 | 214942 | 3766 |
755291 | 755291 | 2020-11-22 | Monroe | Florida | 12087 | 3114 | 27 |
755292 | 755292 | 2020-11-22 | Nassau | Florida | 12089 | 2930 | 54 |
755293 | 755293 | 2020-11-22 | Okaloosa | Florida | 12091 | 8322 | 145 |
755294 | 755294 | 2020-11-22 | Okeechobee | Florida | 12093 | 1973 | 43 |
755295 | 755295 | 2020-11-22 | Orange | Florida | 12095 | 54635 | 624 |
755296 | 755296 | 2020-11-22 | Osceola | Florida | 12097 | 17137 | 236 |
755297 | 755297 | 2020-11-22 | Palm Beach | Florida | 12099 | 61774 | 1648 |
755298 | 755298 | 2020-11-22 | Pasco | Florida | 12101 | 13679 | 264 |
755299 | 755299 | 2020-11-22 | Pinellas | Florida | 12103 | 30878 | 867 |
755300 | 755300 | 2020-11-22 | Polk | Florida | 12105 | 26352 | 663 |
755301 | 755301 | 2020-11-22 | Putnam | Florida | 12107 | 2645 | 57 |
755302 | 755302 | 2020-11-22 | Santa Rosa | Florida | 12113 | 7014 | 97 |
755303 | 755303 | 2020-11-22 | Sarasota | Florida | 12115 | 12419 | 371 |
755304 | 755304 | 2020-11-22 | Seminole | Florida | 12117 | 12161 | 266 |
755305 | 755305 | 2020-11-22 | St. Johns | Florida | 12109 | 8030 | 91 |
755306 | 755306 | 2020-11-22 | St. Lucie | Florida | 12111 | 10248 | 360 |
755307 | 755307 | 2020-11-22 | Sumter | Florida | 12119 | 3292 | 92 |
755308 | 755308 | 2020-11-22 | Suwannee | Florida | 12121 | 3209 | 86 |
755309 | 755309 | 2020-11-22 | Taylor | Florida | 12123 | 1613 | 20 |
755310 | 755310 | 2020-11-22 | Union | Florida | 12125 | 1210 | 58 |
755311 | 755311 | 2020-11-22 | Unknown | Florida | 2361 | 0 | |
755312 | 755312 | 2020-11-22 | Volusia | Florida | 12127 | 15093 | 357 |
755313 | 755313 | 2020-11-22 | Wakulla | Florida | 12129 | 1555 | 13 |
755314 | 755314 | 2020-11-22 | Walton | Florida | 12131 | 3499 | 35 |
755315 | 755315 | 2020-11-22 | Washington | Florida | 12133 | 1456 | 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);