ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
68 rows where date = "2021-04-27" 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 |
---|---|---|---|---|---|---|---|
1261631 | 1261631 | 2021-04-27 | Alachua | Florida | 12001 | 24518 | 273 |
1261632 | 1261632 | 2021-04-27 | Baker | Florida | 12003 | 3471 | 60 |
1261633 | 1261633 | 2021-04-27 | Bay | Florida | 12005 | 19939 | 382 |
1261634 | 1261634 | 2021-04-27 | Bradford | Florida | 12007 | 2986 | 56 |
1261635 | 1261635 | 2021-04-27 | Brevard | Florida | 12009 | 40538 | 854 |
1261636 | 1261636 | 2021-04-27 | Broward | Florida | 12011 | 234243 | 2877 |
1261637 | 1261637 | 2021-04-27 | Calhoun | Florida | 12013 | 1686 | 43 |
1261638 | 1261638 | 2021-04-27 | Charlotte | Florida | 12015 | 12624 | 413 |
1261639 | 1261639 | 2021-04-27 | Citrus | Florida | 12017 | 10918 | 438 |
1261640 | 1261640 | 2021-04-27 | Clay | Florida | 12019 | 18318 | 336 |
1261641 | 1261641 | 2021-04-27 | Collier | Florida | 12021 | 35037 | 522 |
1261642 | 1261642 | 2021-04-27 | Columbia | Florida | 12023 | 8063 | 168 |
1261643 | 1261643 | 2021-04-27 | DeSoto | Florida | 12027 | 4270 | 92 |
1261644 | 1261644 | 2021-04-27 | Dixie | Florida | 12029 | 1595 | 24 |
1261645 | 1261645 | 2021-04-27 | Duval | Florida | 12031 | 96749 | 1375 |
1261646 | 1261646 | 2021-04-27 | Escambia | Florida | 12033 | 35790 | 677 |
1261647 | 1261647 | 2021-04-27 | Flagler | Florida | 12035 | 7161 | 109 |
1261648 | 1261648 | 2021-04-27 | Franklin | Florida | 12037 | 1309 | 17 |
1261649 | 1261649 | 2021-04-27 | Gadsden | Florida | 12039 | 5626 | 93 |
1261650 | 1261650 | 2021-04-27 | Gilchrist | Florida | 12041 | 1592 | 43 |
1261651 | 1261651 | 2021-04-27 | Glades | Florida | 12043 | 948 | 19 |
1261652 | 1261652 | 2021-04-27 | Gulf | Florida | 12045 | 1949 | 42 |
1261653 | 1261653 | 2021-04-27 | Hamilton | Florida | 12047 | 1621 | 25 |
1261654 | 1261654 | 2021-04-27 | Hardee | Florida | 12049 | 3083 | 42 |
1261655 | 1261655 | 2021-04-27 | Hendry | Florida | 12051 | 4664 | 81 |
1261656 | 1261656 | 2021-04-27 | Hernando | Florida | 12053 | 13598 | 460 |
1261657 | 1261657 | 2021-04-27 | Highlands | Florida | 12055 | 8377 | 343 |
1261658 | 1261658 | 2021-04-27 | Hillsborough | Florida | 12057 | 133855 | 1682 |
1261659 | 1261659 | 2021-04-27 | Holmes | Florida | 12059 | 2235 | 49 |
1261660 | 1261660 | 2021-04-27 | Indian River | Florida | 12061 | 12355 | 294 |
1261661 | 1261661 | 2021-04-27 | Jackson | Florida | 12063 | 6151 | 156 |
1261662 | 1261662 | 2021-04-27 | Jefferson | Florida | 12065 | 1478 | 27 |
1261663 | 1261663 | 2021-04-27 | Lafayette | Florida | 12067 | 1614 | 26 |
1261664 | 1261664 | 2021-04-27 | Lake | Florida | 12069 | 29027 | 621 |
1261665 | 1261665 | 2021-04-27 | Lee | Florida | 12071 | 68620 | 956 |
1261666 | 1261666 | 2021-04-27 | Leon | Florida | 12073 | 31347 | 312 |
1261667 | 1261667 | 2021-04-27 | Levy | Florida | 12075 | 3381 | 51 |
1261668 | 1261668 | 2021-04-27 | Liberty | Florida | 12077 | 1065 | 16 |
1261669 | 1261669 | 2021-04-27 | Madison | Florida | 12079 | 2048 | 45 |
1261670 | 1261670 | 2021-04-27 | Manatee | Florida | 12081 | 37798 | 660 |
1261671 | 1261671 | 2021-04-27 | Marion | Florida | 12083 | 30538 | 947 |
1261672 | 1261672 | 2021-04-27 | Martin | Florida | 12085 | 12128 | 313 |
1261673 | 1261673 | 2021-04-27 | Miami-Dade | Florida | 12086 | 480482 | 6130 |
1261674 | 1261674 | 2021-04-27 | Monroe | Florida | 12087 | 6852 | 49 |
1261675 | 1261675 | 2021-04-27 | Nassau | Florida | 12089 | 8269 | 124 |
1261676 | 1261676 | 2021-04-27 | Okaloosa | Florida | 12091 | 20326 | 361 |
1261677 | 1261677 | 2021-04-27 | Okeechobee | Florida | 12093 | 3945 | 88 |
1261678 | 1261678 | 2021-04-27 | Orange | Florida | 12095 | 135127 | 1238 |
1261679 | 1261679 | 2021-04-27 | Osceola | Florida | 12097 | 43628 | 498 |
1261680 | 1261680 | 2021-04-27 | Palm Beach | Florida | 12099 | 142051 | 2755 |
1261681 | 1261681 | 2021-04-27 | Pasco | Florida | 12101 | 40308 | 738 |
1261682 | 1261682 | 2021-04-27 | Pinellas | Florida | 12103 | 78241 | 1596 |
1261683 | 1261683 | 2021-04-27 | Polk | Florida | 12105 | 66922 | 1301 |
1261684 | 1261684 | 2021-04-27 | Putnam | Florida | 12107 | 6395 | 144 |
1261685 | 1261685 | 2021-04-27 | Santa Rosa | Florida | 12113 | 18095 | 284 |
1261686 | 1261686 | 2021-04-27 | Sarasota | Florida | 12115 | 32191 | 809 |
1261687 | 1261687 | 2021-04-27 | Seminole | Florida | 12117 | 33365 | 486 |
1261688 | 1261688 | 2021-04-27 | St. Johns | Florida | 12109 | 22294 | 207 |
1261689 | 1261689 | 2021-04-27 | St. Lucie | Florida | 12111 | 25805 | 621 |
1261690 | 1261690 | 2021-04-27 | Sumter | Florida | 12119 | 9220 | 275 |
1261691 | 1261691 | 2021-04-27 | Suwannee | Florida | 12121 | 5316 | 138 |
1261692 | 1261692 | 2021-04-27 | Taylor | Florida | 12123 | 2712 | 45 |
1261693 | 1261693 | 2021-04-27 | Union | Florida | 12125 | 1812 | 72 |
1261694 | 1261694 | 2021-04-27 | Unknown | Florida | 3492 | 0 | |
1261695 | 1261695 | 2021-04-27 | Volusia | Florida | 12127 | 42377 | 786 |
1261696 | 1261696 | 2021-04-27 | Wakulla | Florida | 12129 | 3394 | 54 |
1261697 | 1261697 | 2021-04-27 | Walton | Florida | 12131 | 7712 | 88 |
1261698 | 1261698 | 2021-04-27 | Washington | Florida | 12133 | 2716 | 51 |
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);