ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
68 rows where date = "2020-10-29" and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
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 |
---|---|---|---|---|---|---|---|
677387 | 677387 | 2020-10-29 | Alachua | Florida | 12001 | 10385 | 75 |
677388 | 677388 | 2020-10-29 | Baker | Florida | 12003 | 1783 | 23 |
677389 | 677389 | 2020-10-29 | Bay | Florida | 12005 | 6801 | 134 |
677390 | 677390 | 2020-10-29 | Bradford | Florida | 12007 | 1238 | 15 |
677391 | 677391 | 2020-10-29 | Brevard | Florida | 12009 | 11502 | 370 |
677392 | 677392 | 2020-10-29 | Broward | Florida | 12011 | 85449 | 1522 |
677393 | 677393 | 2020-10-29 | Calhoun | Florida | 12013 | 718 | 14 |
677394 | 677394 | 2020-10-29 | Charlotte | Florida | 12015 | 3638 | 157 |
677395 | 677395 | 2020-10-29 | Citrus | Florida | 12017 | 3224 | 134 |
677396 | 677396 | 2020-10-29 | Clay | Florida | 12019 | 6083 | 127 |
677397 | 677397 | 2020-10-29 | Collier | Florida | 12021 | 14404 | 255 |
677398 | 677398 | 2020-10-29 | Columbia | Florida | 12023 | 4255 | 78 |
677399 | 677399 | 2020-10-29 | DeSoto | Florida | 12027 | 1670 | 29 |
677400 | 677400 | 2020-10-29 | Dixie | Florida | 12029 | 901 | 11 |
677401 | 677401 | 2020-10-29 | Duval | Florida | 12031 | 34963 | 515 |
677402 | 677402 | 2020-10-29 | Escambia | Florida | 12033 | 13517 | 269 |
677403 | 677403 | 2020-10-29 | Flagler | Florida | 12035 | 2117 | 38 |
677404 | 677404 | 2020-10-29 | Franklin | Florida | 12037 | 771 | 4 |
677405 | 677405 | 2020-10-29 | Gadsden | Florida | 12039 | 3063 | 56 |
677406 | 677406 | 2020-10-29 | Gilchrist | Florida | 12041 | 607 | 18 |
677407 | 677407 | 2020-10-29 | Glades | Florida | 12043 | 606 | 6 |
677408 | 677408 | 2020-10-29 | Gulf | Florida | 12045 | 939 | 15 |
677409 | 677409 | 2020-10-29 | Hamilton | Florida | 12047 | 904 | 10 |
677410 | 677410 | 2020-10-29 | Hardee | Florida | 12049 | 1606 | 16 |
677411 | 677411 | 2020-10-29 | Hendry | Florida | 12051 | 2223 | 44 |
677412 | 677412 | 2020-10-29 | Hernando | Florida | 12053 | 3715 | 173 |
677413 | 677413 | 2020-10-29 | Highlands | Florida | 12055 | 2652 | 114 |
677414 | 677414 | 2020-10-29 | Hillsborough | Florida | 12057 | 47800 | 798 |
677415 | 677415 | 2020-10-29 | Holmes | Florida | 12059 | 914 | 12 |
677416 | 677416 | 2020-10-29 | Indian River | Florida | 12061 | 3847 | 125 |
677417 | 677417 | 2020-10-29 | Jackson | Florida | 12063 | 3124 | 84 |
677418 | 677418 | 2020-10-29 | Jefferson | Florida | 12065 | 672 | 9 |
677419 | 677419 | 2020-10-29 | Lafayette | Florida | 12067 | 1278 | 16 |
677420 | 677420 | 2020-10-29 | Lake | Florida | 12069 | 8613 | 228 |
677421 | 677421 | 2020-10-29 | Lee | Florida | 12071 | 23334 | 513 |
677422 | 677422 | 2020-10-29 | Leon | Florida | 12073 | 12315 | 115 |
677423 | 677423 | 2020-10-29 | Levy | Florida | 12075 | 1139 | 12 |
677424 | 677424 | 2020-10-29 | Liberty | Florida | 12077 | 534 | 11 |
677425 | 677425 | 2020-10-29 | Madison | Florida | 12079 | 1078 | 25 |
677426 | 677426 | 2020-10-29 | Manatee | Florida | 12081 | 13258 | 330 |
677427 | 677427 | 2020-10-29 | Marion | Florida | 12083 | 10819 | 347 |
677428 | 677428 | 2020-10-29 | Martin | Florida | 12085 | 5368 | 165 |
677429 | 677429 | 2020-10-29 | Miami-Dade | Florida | 12086 | 184668 | 3634 |
677430 | 677430 | 2020-10-29 | Monroe | Florida | 12087 | 2269 | 25 |
677431 | 677431 | 2020-10-29 | Nassau | Florida | 12089 | 2480 | 51 |
677432 | 677432 | 2020-10-29 | Okaloosa | Florida | 12091 | 6372 | 130 |
677433 | 677433 | 2020-10-29 | Okeechobee | Florida | 12093 | 1736 | 38 |
677434 | 677434 | 2020-10-29 | Orange | Florida | 12095 | 45940 | 558 |
677435 | 677435 | 2020-10-29 | Osceola | Florida | 12097 | 14203 | 202 |
677436 | 677436 | 2020-10-29 | Palm Beach | Florida | 12099 | 51777 | 1580 |
677437 | 677437 | 2020-10-29 | Pasco | Florida | 12101 | 10826 | 243 |
677438 | 677438 | 2020-10-29 | Pinellas | Florida | 12103 | 25674 | 819 |
677439 | 677439 | 2020-10-29 | Polk | Florida | 12105 | 22960 | 615 |
677440 | 677440 | 2020-10-29 | Putnam | Florida | 12107 | 2386 | 50 |
677441 | 677441 | 2020-10-29 | Santa Rosa | Florida | 12113 | 5941 | 87 |
677442 | 677442 | 2020-10-29 | Sarasota | Florida | 12115 | 9657 | 340 |
677443 | 677443 | 2020-10-29 | Seminole | Florida | 12117 | 10239 | 241 |
677444 | 677444 | 2020-10-29 | St. Johns | Florida | 12109 | 6506 | 80 |
677445 | 677445 | 2020-10-29 | St. Lucie | Florida | 12111 | 9061 | 334 |
677446 | 677446 | 2020-10-29 | Sumter | Florida | 12119 | 2891 | 86 |
677447 | 677447 | 2020-10-29 | Suwannee | Florida | 12121 | 2999 | 77 |
677448 | 677448 | 2020-10-29 | Taylor | Florida | 12123 | 1476 | 18 |
677449 | 677449 | 2020-10-29 | Union | Florida | 12125 | 1133 | 44 |
677450 | 677450 | 2020-10-29 | Unknown | Florida | 1827 | 0 | |
677451 | 677451 | 2020-10-29 | Volusia | Florida | 12127 | 12755 | 318 |
677452 | 677452 | 2020-10-29 | Wakulla | Florida | 12129 | 1319 | 11 |
677453 | 677453 | 2020-10-29 | Walton | Florida | 12131 | 2458 | 30 |
677454 | 677454 | 2020-10-29 | Washington | Florida | 12133 | 1236 | 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);