ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
68 rows where date = "2021-02-17" 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 |
---|---|---|---|---|---|---|---|
1037599 | 1037599 | 2021-02-17 | Alachua | Florida | 12001 | 21960 | 203 |
1037600 | 1037600 | 2021-02-17 | Baker | Florida | 12003 | 3239 | 54 |
1037601 | 1037601 | 2021-02-17 | Bay | Florida | 12005 | 18048 | 321 |
1037602 | 1037602 | 2021-02-17 | Bradford | Florida | 12007 | 2791 | 49 |
1037603 | 1037603 | 2021-02-17 | Brevard | Florida | 12009 | 32445 | 710 |
1037604 | 1037604 | 2021-02-17 | Broward | Florida | 12011 | 186831 | 2283 |
1037605 | 1037605 | 2021-02-17 | Calhoun | Florida | 12013 | 1592 | 38 |
1037606 | 1037606 | 2021-02-17 | Charlotte | Florida | 12015 | 10393 | 338 |
1037607 | 1037607 | 2021-02-17 | Citrus | Florida | 12017 | 9433 | 373 |
1037608 | 1037608 | 2021-02-17 | Clay | Florida | 12019 | 16375 | 283 |
1037609 | 1037609 | 2021-02-17 | Collier | Florida | 12021 | 29347 | 434 |
1037610 | 1037610 | 2021-02-17 | Columbia | Florida | 12023 | 7548 | 149 |
1037611 | 1037611 | 2021-02-17 | DeSoto | Florida | 12027 | 3612 | 71 |
1037612 | 1037612 | 2021-02-17 | Dixie | Florida | 12029 | 1448 | 17 |
1037613 | 1037613 | 2021-02-17 | Duval | Florida | 12031 | 86872 | 1062 |
1037614 | 1037614 | 2021-02-17 | Escambia | Florida | 12033 | 32958 | 598 |
1037615 | 1037615 | 2021-02-17 | Flagler | Florida | 12035 | 5689 | 86 |
1037616 | 1037616 | 2021-02-17 | Franklin | Florida | 12037 | 1272 | 12 |
1037617 | 1037617 | 2021-02-17 | Gadsden | Florida | 12039 | 5342 | 79 |
1037618 | 1037618 | 2021-02-17 | Gilchrist | Florida | 12041 | 1377 | 31 |
1037619 | 1037619 | 2021-02-17 | Glades | Florida | 12043 | 888 | 15 |
1037620 | 1037620 | 2021-02-17 | Gulf | Florida | 12045 | 1829 | 35 |
1037621 | 1037621 | 2021-02-17 | Hamilton | Florida | 12047 | 1550 | 21 |
1037622 | 1037622 | 2021-02-17 | Hardee | Florida | 12049 | 2734 | 26 |
1037623 | 1037623 | 2021-02-17 | Hendry | Florida | 12051 | 4227 | 65 |
1037624 | 1037624 | 2021-02-17 | Hernando | Florida | 12053 | 10807 | 379 |
1037625 | 1037625 | 2021-02-17 | Highlands | Florida | 12055 | 6997 | 291 |
1037626 | 1037626 | 2021-02-17 | Hillsborough | Florida | 12057 | 107513 | 1427 |
1037627 | 1037627 | 2021-02-17 | Holmes | Florida | 12059 | 2154 | 42 |
1037628 | 1037628 | 2021-02-17 | Indian River | Florida | 12061 | 10618 | 252 |
1037629 | 1037629 | 2021-02-17 | Jackson | Florida | 12063 | 5836 | 140 |
1037630 | 1037630 | 2021-02-17 | Jefferson | Florida | 12065 | 1380 | 22 |
1037631 | 1037631 | 2021-02-17 | Lafayette | Florida | 12067 | 1567 | 24 |
1037632 | 1037632 | 2021-02-17 | Lake | Florida | 12069 | 23655 | 525 |
1037633 | 1037633 | 2021-02-17 | Lee | Florida | 12071 | 56005 | 861 |
1037634 | 1037634 | 2021-02-17 | Leon | Florida | 12073 | 28290 | 266 |
1037635 | 1037635 | 2021-02-17 | Levy | Florida | 12075 | 2776 | 30 |
1037636 | 1037636 | 2021-02-17 | Liberty | Florida | 12077 | 1030 | 14 |
1037637 | 1037637 | 2021-02-17 | Madison | Florida | 12079 | 1938 | 39 |
1037638 | 1037638 | 2021-02-17 | Manatee | Florida | 12081 | 30737 | 564 |
1037639 | 1037639 | 2021-02-17 | Marion | Florida | 12083 | 26616 | 700 |
1037640 | 1037640 | 2021-02-17 | Martin | Florida | 12085 | 10188 | 269 |
1037641 | 1037641 | 2021-02-17 | Miami-Dade | Florida | 12086 | 397225 | 5229 |
1037642 | 1037642 | 2021-02-17 | Monroe | Florida | 12087 | 5626 | 44 |
1037643 | 1037643 | 2021-02-17 | Nassau | Florida | 12089 | 7505 | 107 |
1037644 | 1037644 | 2021-02-17 | Okaloosa | Florida | 12091 | 18062 | 312 |
1037645 | 1037645 | 2021-02-17 | Okeechobee | Florida | 12093 | 3457 | 69 |
1037646 | 1037646 | 2021-02-17 | Orange | Florida | 12095 | 110517 | 1059 |
1037647 | 1037647 | 2021-02-17 | Osceola | Florida | 12097 | 35689 | 414 |
1037648 | 1037648 | 2021-02-17 | Palm Beach | Florida | 12099 | 115792 | 2362 |
1037649 | 1037649 | 2021-02-17 | Pasco | Florida | 12101 | 32036 | 619 |
1037650 | 1037650 | 2021-02-17 | Pinellas | Florida | 12103 | 63871 | 1385 |
1037651 | 1037651 | 2021-02-17 | Polk | Florida | 12105 | 55058 | 1087 |
1037652 | 1037652 | 2021-02-17 | Putnam | Florida | 12107 | 5744 | 119 |
1037653 | 1037653 | 2021-02-17 | Santa Rosa | Florida | 12113 | 16616 | 246 |
1037654 | 1037654 | 2021-02-17 | Sarasota | Florida | 12115 | 26193 | 700 |
1037655 | 1037655 | 2021-02-17 | Seminole | Florida | 12117 | 26142 | 405 |
1037656 | 1037656 | 2021-02-17 | St. Johns | Florida | 12109 | 19660 | 182 |
1037657 | 1037657 | 2021-02-17 | St. Lucie | Florida | 12111 | 21234 | 523 |
1037658 | 1037658 | 2021-02-17 | Sumter | Florida | 12119 | 7668 | 224 |
1037659 | 1037659 | 2021-02-17 | Suwannee | Florida | 12121 | 5059 | 125 |
1037660 | 1037660 | 2021-02-17 | Taylor | Florida | 12123 | 2597 | 39 |
1037661 | 1037661 | 2021-02-17 | Union | Florida | 12125 | 1719 | 70 |
1037662 | 1037662 | 2021-02-17 | Unknown | Florida | 3403 | 0 | |
1037663 | 1037663 | 2021-02-17 | Volusia | Florida | 12127 | 33295 | 622 |
1037664 | 1037664 | 2021-02-17 | Wakulla | Florida | 12129 | 3119 | 51 |
1037665 | 1037665 | 2021-02-17 | Walton | Florida | 12131 | 6840 | 79 |
1037666 | 1037666 | 2021-02-17 | Washington | Florida | 12133 | 2585 | 40 |
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);