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-05 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 |
---|---|---|---|---|---|---|---|
797436 | 797436 | 2020-12-05 | Alachua | Florida | 12001 | 13314 | 103 |
797437 | 797437 | 2020-12-05 | Baker | Florida | 12003 | 2100 | 33 |
797438 | 797438 | 2020-12-05 | Bay | Florida | 12005 | 9045 | 170 |
797439 | 797439 | 2020-12-05 | Bradford | Florida | 12007 | 1467 | 19 |
797440 | 797440 | 2020-12-05 | Brevard | Florida | 12009 | 16529 | 456 |
797441 | 797441 | 2020-12-05 | Broward | Florida | 12011 | 112729 | 1694 |
797442 | 797442 | 2020-12-05 | Calhoun | Florida | 12013 | 920 | 22 |
797443 | 797443 | 2020-12-05 | Charlotte | Florida | 12015 | 5437 | 200 |
797444 | 797444 | 2020-12-05 | Citrus | Florida | 12017 | 5096 | 181 |
797445 | 797445 | 2020-12-05 | Clay | Florida | 12019 | 8485 | 154 |
797446 | 797446 | 2020-12-05 | Collier | Florida | 12021 | 18751 | 293 |
797447 | 797447 | 2020-12-05 | Columbia | Florida | 12023 | 4930 | 99 |
797448 | 797448 | 2020-12-05 | DeSoto | Florida | 12027 | 2492 | 37 |
797449 | 797449 | 2020-12-05 | Dixie | Florida | 12029 | 983 | 11 |
797450 | 797450 | 2020-12-05 | Duval | Florida | 12031 | 46606 | 637 |
797451 | 797451 | 2020-12-05 | Escambia | Florida | 12033 | 17514 | 315 |
797452 | 797452 | 2020-12-05 | Flagler | Florida | 12035 | 2867 | 43 |
797453 | 797453 | 2020-12-05 | Franklin | Florida | 12037 | 835 | 4 |
797454 | 797454 | 2020-12-05 | Gadsden | Florida | 12039 | 3399 | 57 |
797455 | 797455 | 2020-12-05 | Gilchrist | Florida | 12041 | 814 | 20 |
797456 | 797456 | 2020-12-05 | Glades | Florida | 12043 | 691 | 10 |
797457 | 797457 | 2020-12-05 | Gulf | Florida | 12045 | 1095 | 21 |
797458 | 797458 | 2020-12-05 | Hamilton | Florida | 12047 | 1019 | 11 |
797459 | 797459 | 2020-12-05 | Hardee | Florida | 12049 | 1807 | 19 |
797460 | 797460 | 2020-12-05 | Hendry | Florida | 12051 | 2594 | 45 |
797461 | 797461 | 2020-12-05 | Hernando | Florida | 12053 | 5342 | 229 |
797462 | 797462 | 2020-12-05 | Highlands | Florida | 12055 | 3994 | 160 |
797463 | 797463 | 2020-12-05 | Hillsborough | Florida | 12057 | 60761 | 959 |
797464 | 797464 | 2020-12-05 | Holmes | Florida | 12059 | 1247 | 16 |
797465 | 797465 | 2020-12-05 | Indian River | Florida | 12061 | 5205 | 141 |
797466 | 797466 | 2020-12-05 | Jackson | Florida | 12063 | 3994 | 97 |
797467 | 797467 | 2020-12-05 | Jefferson | Florida | 12065 | 802 | 12 |
797468 | 797468 | 2020-12-05 | Lafayette | Florida | 12067 | 1359 | 21 |
797469 | 797469 | 2020-12-05 | Lake | Florida | 12069 | 11091 | 258 |
797470 | 797470 | 2020-12-05 | Lee | Florida | 12071 | 31896 | 598 |
797471 | 797471 | 2020-12-05 | Leon | Florida | 12073 | 15761 | 150 |
797472 | 797472 | 2020-12-05 | Levy | Florida | 12075 | 1482 | 14 |
797473 | 797473 | 2020-12-05 | Liberty | Florida | 12077 | 623 | 14 |
797474 | 797474 | 2020-12-05 | Madison | Florida | 12079 | 1319 | 27 |
797475 | 797475 | 2020-12-05 | Manatee | Florida | 12081 | 17606 | 390 |
797476 | 797476 | 2020-12-05 | Marion | Florida | 12083 | 13810 | 393 |
797477 | 797477 | 2020-12-05 | Martin | Florida | 12085 | 6485 | 179 |
797478 | 797478 | 2020-12-05 | Miami-Dade | Florida | 12086 | 241050 | 3896 |
797479 | 797479 | 2020-12-05 | Monroe | Florida | 12087 | 3545 | 28 |
797480 | 797480 | 2020-12-05 | Nassau | Florida | 12089 | 3417 | 57 |
797481 | 797481 | 2020-12-05 | Okaloosa | Florida | 12091 | 9713 | 167 |
797482 | 797482 | 2020-12-05 | Okeechobee | Florida | 12093 | 2099 | 44 |
797483 | 797483 | 2020-12-05 | Orange | Florida | 12095 | 61029 | 655 |
797484 | 797484 | 2020-12-05 | Osceola | Florida | 12097 | 19487 | 245 |
797485 | 797485 | 2020-12-05 | Palm Beach | Florida | 12099 | 68379 | 1724 |
797486 | 797486 | 2020-12-05 | Pasco | Florida | 12101 | 15948 | 290 |
797487 | 797487 | 2020-12-05 | Pinellas | Florida | 12103 | 34603 | 924 |
797488 | 797488 | 2020-12-05 | Polk | Florida | 12105 | 28918 | 700 |
797489 | 797489 | 2020-12-05 | Putnam | Florida | 12107 | 2919 | 60 |
797490 | 797490 | 2020-12-05 | Santa Rosa | Florida | 12113 | 7995 | 104 |
797491 | 797491 | 2020-12-05 | Sarasota | Florida | 12115 | 14575 | 398 |
797492 | 797492 | 2020-12-05 | Seminole | Florida | 12117 | 13556 | 283 |
797493 | 797493 | 2020-12-05 | St. Johns | Florida | 12109 | 9433 | 99 |
797494 | 797494 | 2020-12-05 | St. Lucie | Florida | 12111 | 11248 | 372 |
797495 | 797495 | 2020-12-05 | Sumter | Florida | 12119 | 3701 | 101 |
797496 | 797496 | 2020-12-05 | Suwannee | Florida | 12121 | 3388 | 87 |
797497 | 797497 | 2020-12-05 | Taylor | Florida | 12123 | 1685 | 21 |
797498 | 797498 | 2020-12-05 | Union | Florida | 12125 | 1254 | 61 |
797499 | 797499 | 2020-12-05 | Unknown | Florida | 2931 | 0 | |
797500 | 797500 | 2020-12-05 | Volusia | Florida | 12127 | 17286 | 374 |
797501 | 797501 | 2020-12-05 | Wakulla | Florida | 12129 | 1714 | 16 |
797502 | 797502 | 2020-12-05 | Walton | Florida | 12131 | 3883 | 38 |
797503 | 797503 | 2020-12-05 | Washington | Florida | 12133 | 1578 | 27 |
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);