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-06-16 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 |
---|---|---|---|---|---|---|---|
243559 | 243559 | 2020-06-16 | Alachua | Florida | 12001 | 564 | 10 |
243560 | 243560 | 2020-06-16 | Baker | Florida | 12003 | 34 | 4 |
243561 | 243561 | 2020-06-16 | Bay | Florida | 12005 | 157 | 4 |
243562 | 243562 | 2020-06-16 | Bradford | Florida | 12007 | 53 | 2 |
243563 | 243563 | 2020-06-16 | Brevard | Florida | 12009 | 608 | 16 |
243564 | 243564 | 2020-06-16 | Broward | Florida | 12011 | 9498 | 358 |
243565 | 243565 | 2020-06-16 | Calhoun | Florida | 12013 | 66 | 5 |
243566 | 243566 | 2020-06-16 | Charlotte | Florida | 12015 | 543 | 73 |
243567 | 243567 | 2020-06-16 | Citrus | Florida | 12017 | 152 | 12 |
243568 | 243568 | 2020-06-16 | Clay | Florida | 12019 | 443 | 32 |
243569 | 243569 | 2020-06-16 | Collier | Florida | 12021 | 2729 | 60 |
243570 | 243570 | 2020-06-16 | Columbia | Florida | 12023 | 187 | 2 |
243571 | 243571 | 2020-06-16 | DeSoto | Florida | 12027 | 402 | 10 |
243572 | 243572 | 2020-06-16 | Dixie | Florida | 12029 | 60 | 3 |
243573 | 243573 | 2020-06-16 | Duval | Florida | 12031 | 2112 | 59 |
243574 | 243574 | 2020-06-16 | Escambia | Florida | 12033 | 1020 | 38 |
243575 | 243575 | 2020-06-16 | Flagler | Florida | 12035 | 208 | 5 |
243576 | 243576 | 2020-06-16 | Franklin | Florida | 12037 | 2 | 0 |
243577 | 243577 | 2020-06-16 | Gadsden | Florida | 12039 | 308 | 5 |
243578 | 243578 | 2020-06-16 | Gilchrist | Florida | 12041 | 73 | 0 |
243579 | 243579 | 2020-06-16 | Glades | Florida | 12043 | 118 | 1 |
243580 | 243580 | 2020-06-16 | Gulf | Florida | 12045 | 11 | 0 |
243581 | 243581 | 2020-06-16 | Hamilton | Florida | 12047 | 277 | 2 |
243582 | 243582 | 2020-06-16 | Hardee | Florida | 12049 | 213 | 1 |
243583 | 243583 | 2020-06-16 | Hendry | Florida | 12051 | 659 | 20 |
243584 | 243584 | 2020-06-16 | Hernando | Florida | 12053 | 146 | 5 |
243585 | 243585 | 2020-06-16 | Highlands | Florida | 12055 | 192 | 9 |
243586 | 243586 | 2020-06-16 | Hillsborough | Florida | 12057 | 4029 | 103 |
243587 | 243587 | 2020-06-16 | Holmes | Florida | 12059 | 31 | 0 |
243588 | 243588 | 2020-06-16 | Indian River | Florida | 12061 | 234 | 12 |
243589 | 243589 | 2020-06-16 | Jackson | Florida | 12063 | 326 | 1 |
243590 | 243590 | 2020-06-16 | Jefferson | Florida | 12065 | 33 | 4 |
243591 | 243591 | 2020-06-16 | Lafayette | Florida | 12067 | 15 | 0 |
243592 | 243592 | 2020-06-16 | Lake | Florida | 12069 | 498 | 16 |
243593 | 243593 | 2020-06-16 | Lee | Florida | 12071 | 3014 | 136 |
243594 | 243594 | 2020-06-16 | Leon | Florida | 12073 | 482 | 8 |
243595 | 243595 | 2020-06-16 | Levy | Florida | 12075 | 127 | 1 |
243596 | 243596 | 2020-06-16 | Liberty | Florida | 12077 | 220 | 1 |
243597 | 243597 | 2020-06-16 | Madison | Florida | 12079 | 84 | 3 |
243598 | 243598 | 2020-06-16 | Manatee | Florida | 12081 | 1483 | 116 |
243599 | 243599 | 2020-06-16 | Marion | Florida | 12083 | 325 | 8 |
243600 | 243600 | 2020-06-16 | Martin | Florida | 12085 | 1296 | 18 |
243601 | 243601 | 2020-06-16 | Miami-Dade | Florida | 12086 | 22740 | 847 |
243602 | 243602 | 2020-06-16 | Monroe | Florida | 12087 | 131 | 4 |
243603 | 243603 | 2020-06-16 | Nassau | Florida | 12089 | 94 | 1 |
243604 | 243604 | 2020-06-16 | Okaloosa | Florida | 12091 | 343 | 6 |
243605 | 243605 | 2020-06-16 | Okeechobee | Florida | 12093 | 195 | 0 |
243606 | 243606 | 2020-06-16 | Orange | Florida | 12095 | 3436 | 46 |
243607 | 243607 | 2020-06-16 | Osceola | Florida | 12097 | 866 | 21 |
243608 | 243608 | 2020-06-16 | Palm Beach | Florida | 12099 | 9260 | 438 |
243609 | 243609 | 2020-06-16 | Pasco | Florida | 12101 | 560 | 16 |
243610 | 243610 | 2020-06-16 | Pinellas | Florida | 12103 | 2523 | 107 |
243611 | 243611 | 2020-06-16 | Polk | Florida | 12105 | 1566 | 75 |
243612 | 243612 | 2020-06-16 | Putnam | Florida | 12107 | 198 | 6 |
243613 | 243613 | 2020-06-16 | Santa Rosa | Florida | 12113 | 297 | 9 |
243614 | 243614 | 2020-06-16 | Sarasota | Florida | 12115 | 789 | 92 |
243615 | 243615 | 2020-06-16 | Seminole | Florida | 12117 | 836 | 13 |
243616 | 243616 | 2020-06-16 | St. Johns | Florida | 12109 | 333 | 6 |
243617 | 243617 | 2020-06-16 | St. Lucie | Florida | 12111 | 981 | 38 |
243618 | 243618 | 2020-06-16 | Sumter | Florida | 12119 | 268 | 17 |
243619 | 243619 | 2020-06-16 | Suwannee | Florida | 12121 | 208 | 18 |
243620 | 243620 | 2020-06-16 | Taylor | Florida | 12123 | 60 | 0 |
243621 | 243621 | 2020-06-16 | Union | Florida | 12125 | 38 | 1 |
243622 | 243622 | 2020-06-16 | Unknown | Florida | 97 | 0 | |
243623 | 243623 | 2020-06-16 | Volusia | Florida | 12127 | 969 | 49 |
243624 | 243624 | 2020-06-16 | Wakulla | Florida | 12129 | 35 | 1 |
243625 | 243625 | 2020-06-16 | Walton | Florida | 12131 | 152 | 9 |
243626 | 243626 | 2020-06-16 | Washington | Florida | 12133 | 94 | 9 |
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);