ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
68 rows where date = "2021-05-09" 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 |
---|---|---|---|---|---|---|---|
1300591 | 1300591 | 2021-05-09 | Alachua | Florida | 12001 | 24892 | 276 |
1300592 | 1300592 | 2021-05-09 | Baker | Florida | 12003 | 3500 | 60 |
1300593 | 1300593 | 2021-05-09 | Bay | Florida | 12005 | 20250 | 388 |
1300594 | 1300594 | 2021-05-09 | Bradford | Florida | 12007 | 3018 | 56 |
1300595 | 1300595 | 2021-05-09 | Brevard | Florida | 12009 | 41704 | 876 |
1300596 | 1300596 | 2021-05-09 | Broward | Florida | 12011 | 239941 | 2964 |
1300597 | 1300597 | 2021-05-09 | Calhoun | Florida | 12013 | 1695 | 44 |
1300598 | 1300598 | 2021-05-09 | Charlotte | Florida | 12015 | 12957 | 421 |
1300599 | 1300599 | 2021-05-09 | Citrus | Florida | 12017 | 11154 | 445 |
1300600 | 1300600 | 2021-05-09 | Clay | Florida | 12019 | 18711 | 342 |
1300601 | 1300601 | 2021-05-09 | Collier | Florida | 12021 | 36010 | 533 |
1300602 | 1300602 | 2021-05-09 | Columbia | Florida | 12023 | 8142 | 169 |
1300603 | 1300603 | 2021-05-09 | DeSoto | Florida | 12027 | 4344 | 93 |
1300604 | 1300604 | 2021-05-09 | Dixie | Florida | 12029 | 1612 | 24 |
1300605 | 1300605 | 2021-05-09 | Duval | Florida | 12031 | 98524 | 1413 |
1300606 | 1300606 | 2021-05-09 | Escambia | Florida | 12033 | 36191 | 690 |
1300607 | 1300607 | 2021-05-09 | Flagler | Florida | 12035 | 7331 | 111 |
1300608 | 1300608 | 2021-05-09 | Franklin | Florida | 12037 | 1328 | 17 |
1300609 | 1300609 | 2021-05-09 | Gadsden | Florida | 12039 | 5691 | 98 |
1300610 | 1300610 | 2021-05-09 | Gilchrist | Florida | 12041 | 1613 | 44 |
1300611 | 1300611 | 2021-05-09 | Glades | Florida | 12043 | 958 | 19 |
1300612 | 1300612 | 2021-05-09 | Gulf | Florida | 12045 | 1967 | 44 |
1300613 | 1300613 | 2021-05-09 | Hamilton | Florida | 12047 | 1628 | 25 |
1300614 | 1300614 | 2021-05-09 | Hardee | Florida | 12049 | 3159 | 44 |
1300615 | 1300615 | 2021-05-09 | Hendry | Florida | 12051 | 4744 | 83 |
1300616 | 1300616 | 2021-05-09 | Hernando | Florida | 12053 | 14070 | 467 |
1300617 | 1300617 | 2021-05-09 | Highlands | Florida | 12055 | 8594 | 357 |
1300618 | 1300618 | 2021-05-09 | Hillsborough | Florida | 12057 | 138161 | 1745 |
1300619 | 1300619 | 2021-05-09 | Holmes | Florida | 12059 | 2260 | 49 |
1300620 | 1300620 | 2021-05-09 | Indian River | Florida | 12061 | 12567 | 302 |
1300621 | 1300621 | 2021-05-09 | Jackson | Florida | 12063 | 6228 | 157 |
1300622 | 1300622 | 2021-05-09 | Jefferson | Florida | 12065 | 1492 | 27 |
1300623 | 1300623 | 2021-05-09 | Lafayette | Florida | 12067 | 1619 | 26 |
1300624 | 1300624 | 2021-05-09 | Lake | Florida | 12069 | 29856 | 642 |
1300625 | 1300625 | 2021-05-09 | Lee | Florida | 12071 | 71110 | 973 |
1300626 | 1300626 | 2021-05-09 | Leon | Florida | 12073 | 32091 | 319 |
1300627 | 1300627 | 2021-05-09 | Levy | Florida | 12075 | 3455 | 54 |
1300628 | 1300628 | 2021-05-09 | Liberty | Florida | 12077 | 1074 | 16 |
1300629 | 1300629 | 2021-05-09 | Madison | Florida | 12079 | 2069 | 45 |
1300630 | 1300630 | 2021-05-09 | Manatee | Florida | 12081 | 38828 | 676 |
1300631 | 1300631 | 2021-05-09 | Marion | Florida | 12083 | 31251 | 966 |
1300632 | 1300632 | 2021-05-09 | Martin | Florida | 12085 | 12369 | 319 |
1300633 | 1300633 | 2021-05-09 | Miami-Dade | Florida | 12086 | 490498 | 6252 |
1300634 | 1300634 | 2021-05-09 | Monroe | Florida | 12087 | 6983 | 49 |
1300635 | 1300635 | 2021-05-09 | Nassau | Florida | 12089 | 8406 | 126 |
1300636 | 1300636 | 2021-05-09 | Okaloosa | Florida | 12091 | 20596 | 362 |
1300637 | 1300637 | 2021-05-09 | Okeechobee | Florida | 12093 | 4024 | 89 |
1300638 | 1300638 | 2021-05-09 | Orange | Florida | 12095 | 138988 | 1269 |
1300639 | 1300639 | 2021-05-09 | Osceola | Florida | 12097 | 44960 | 510 |
1300640 | 1300640 | 2021-05-09 | Palm Beach | Florida | 12099 | 145329 | 2788 |
1300641 | 1300641 | 2021-05-09 | Pasco | Florida | 12101 | 41638 | 765 |
1300642 | 1300642 | 2021-05-09 | Pinellas | Florida | 12103 | 79881 | 1629 |
1300643 | 1300643 | 2021-05-09 | Polk | Florida | 12105 | 69056 | 1331 |
1300644 | 1300644 | 2021-05-09 | Putnam | Florida | 12107 | 6530 | 148 |
1300645 | 1300645 | 2021-05-09 | Santa Rosa | Florida | 12113 | 18255 | 287 |
1300646 | 1300646 | 2021-05-09 | Sarasota | Florida | 12115 | 32922 | 822 |
1300647 | 1300647 | 2021-05-09 | Seminole | Florida | 12117 | 34274 | 499 |
1300648 | 1300648 | 2021-05-09 | St. Johns | Florida | 12109 | 22718 | 211 |
1300649 | 1300649 | 2021-05-09 | St. Lucie | Florida | 12111 | 26578 | 638 |
1300650 | 1300650 | 2021-05-09 | Sumter | Florida | 12119 | 9352 | 278 |
1300651 | 1300651 | 2021-05-09 | Suwannee | Florida | 12121 | 5337 | 139 |
1300652 | 1300652 | 2021-05-09 | Taylor | Florida | 12123 | 2735 | 47 |
1300653 | 1300653 | 2021-05-09 | Union | Florida | 12125 | 1828 | 73 |
1300654 | 1300654 | 2021-05-09 | Unknown | Florida | 3249 | 0 | |
1300655 | 1300655 | 2021-05-09 | Volusia | Florida | 12127 | 43499 | 804 |
1300656 | 1300656 | 2021-05-09 | Wakulla | Florida | 12129 | 3462 | 56 |
1300657 | 1300657 | 2021-05-09 | Walton | Florida | 12131 | 7808 | 87 |
1300658 | 1300658 | 2021-05-09 | Washington | Florida | 12133 | 2734 | 52 |
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);