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-05-08 and state = "Florida" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
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 |
---|---|---|---|---|---|---|---|
124566 | 124566 | 2020-05-08 | Alachua | Florida | 12001 | 306 | 5 |
124567 | 124567 | 2020-05-08 | Baker | Florida | 12003 | 24 | 3 |
124568 | 124568 | 2020-05-08 | Bay | Florida | 12005 | 76 | 3 |
124569 | 124569 | 2020-05-08 | Bradford | Florida | 12007 | 48 | 2 |
124570 | 124570 | 2020-05-08 | Brevard | Florida | 12009 | 326 | 9 |
124571 | 124571 | 2020-05-08 | Broward | Florida | 12011 | 5688 | 248 |
124572 | 124572 | 2020-05-08 | Calhoun | Florida | 12013 | 24 | 0 |
124573 | 124573 | 2020-05-08 | Charlotte | Florida | 12015 | 312 | 31 |
124574 | 124574 | 2020-05-08 | Citrus | Florida | 12017 | 102 | 11 |
124575 | 124575 | 2020-05-08 | Clay | Florida | 12019 | 293 | 19 |
124576 | 124576 | 2020-05-08 | Collier | Florida | 12021 | 712 | 27 |
124577 | 124577 | 2020-05-08 | Columbia | Florida | 12023 | 102 | 2 |
124578 | 124578 | 2020-05-08 | DeSoto | Florida | 12027 | 42 | 5 |
124579 | 124579 | 2020-05-08 | Dixie | Florida | 12029 | 12 | 0 |
124580 | 124580 | 2020-05-08 | Duval | Florida | 12031 | 1088 | 29 |
124581 | 124581 | 2020-05-08 | Escambia | Florida | 12033 | 618 | 18 |
124582 | 124582 | 2020-05-08 | Flagler | Florida | 12035 | 147 | 3 |
124583 | 124583 | 2020-05-08 | Franklin | Florida | 12037 | 2 | 0 |
124584 | 124584 | 2020-05-08 | Gadsden | Florida | 12039 | 122 | 0 |
124585 | 124585 | 2020-05-08 | Gilchrist | Florida | 12041 | 6 | 0 |
124586 | 124586 | 2020-05-08 | Glades | Florida | 12043 | 6 | 1 |
124587 | 124587 | 2020-05-08 | Gulf | Florida | 12045 | 1 | 0 |
124588 | 124588 | 2020-05-08 | Hamilton | Florida | 12047 | 8 | 0 |
124589 | 124589 | 2020-05-08 | Hardee | Florida | 12049 | 35 | 0 |
124590 | 124590 | 2020-05-08 | Hendry | Florida | 12051 | 133 | 5 |
124591 | 124591 | 2020-05-08 | Hernando | Florida | 12053 | 98 | 5 |
124592 | 124592 | 2020-05-08 | Highlands | Florida | 12055 | 93 | 8 |
124593 | 124593 | 2020-05-08 | Hillsborough | Florida | 12057 | 1371 | 37 |
124594 | 124594 | 2020-05-08 | Holmes | Florida | 12059 | 10 | 0 |
124595 | 124595 | 2020-05-08 | Indian River | Florida | 12061 | 100 | 8 |
124596 | 124596 | 2020-05-08 | Jackson | Florida | 12063 | 74 | 0 |
124597 | 124597 | 2020-05-08 | Jefferson | Florida | 12065 | 28 | 2 |
124598 | 124598 | 2020-05-08 | Lafayette | Florida | 12067 | 3 | 0 |
124599 | 124599 | 2020-05-08 | Lake | Florida | 12069 | 237 | 14 |
124600 | 124600 | 2020-05-08 | Lee | Florida | 12071 | 1218 | 62 |
124601 | 124601 | 2020-05-08 | Leon | Florida | 12073 | 248 | 6 |
124602 | 124602 | 2020-05-08 | Levy | Florida | 12075 | 20 | 0 |
124603 | 124603 | 2020-05-08 | Liberty | Florida | 12077 | 196 | 0 |
124604 | 124604 | 2020-05-08 | Madison | Florida | 12079 | 61 | 3 |
124605 | 124605 | 2020-05-08 | Manatee | Florida | 12081 | 742 | 72 |
124606 | 124606 | 2020-05-08 | Marion | Florida | 12083 | 202 | 5 |
124607 | 124607 | 2020-05-08 | Martin | Florida | 12085 | 243 | 6 |
124608 | 124608 | 2020-05-08 | Miami-Dade | Florida | 12086 | 13663 | 468 |
124609 | 124609 | 2020-05-08 | Monroe | Florida | 12087 | 80 | 3 |
124610 | 124610 | 2020-05-08 | Nassau | Florida | 12089 | 60 | 1 |
124611 | 124611 | 2020-05-08 | Okaloosa | Florida | 12091 | 164 | 5 |
124612 | 124612 | 2020-05-08 | Okeechobee | Florida | 12093 | 23 | 0 |
124613 | 124613 | 2020-05-08 | Orange | Florida | 12095 | 1477 | 34 |
124614 | 124614 | 2020-05-08 | Osceola | Florida | 12097 | 554 | 12 |
124615 | 124615 | 2020-05-08 | Palm Beach | Florida | 12099 | 3613 | 229 |
124616 | 124616 | 2020-05-08 | Pasco | Florida | 12101 | 291 | 9 |
124617 | 124617 | 2020-05-08 | Pinellas | Florida | 12103 | 828 | 59 |
124618 | 124618 | 2020-05-08 | Polk | Florida | 12105 | 601 | 31 |
124619 | 124619 | 2020-05-08 | Putnam | Florida | 12107 | 120 | 4 |
124623 | 124623 | 2020-05-08 | St. Johns | Florida | 12109 | 223 | 4 |
124624 | 124624 | 2020-05-08 | St. Lucie | Florida | 12111 | 275 | 25 |
124620 | 124620 | 2020-05-08 | Santa Rosa | Florida | 12113 | 162 | 9 |
124621 | 124621 | 2020-05-08 | Sarasota | Florida | 12115 | 416 | 54 |
124622 | 124622 | 2020-05-08 | Seminole | Florida | 12117 | 410 | 10 |
124625 | 124625 | 2020-05-08 | Sumter | Florida | 12119 | 239 | 14 |
124626 | 124626 | 2020-05-08 | Suwannee | Florida | 12121 | 145 | 18 |
124627 | 124627 | 2020-05-08 | Taylor | Florida | 12123 | 3 | 0 |
124628 | 124628 | 2020-05-08 | Union | Florida | 12125 | 5 | 0 |
124630 | 124630 | 2020-05-08 | Volusia | Florida | 12127 | 537 | 28 |
124631 | 124631 | 2020-05-08 | Wakulla | Florida | 12129 | 29 | 1 |
124632 | 124632 | 2020-05-08 | Walton | Florida | 12131 | 51 | 1 |
124633 | 124633 | 2020-05-08 | Washington | Florida | 12133 | 12 | 0 |
124629 | 124629 | 2020-05-08 | Unknown | Florida | 33 | 0 |
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);