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 2021-03-05 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 |
---|---|---|---|---|---|---|---|
1089529 | 1089529 | 2021-03-05 | Alachua | Florida | 12001 | 22555 | 235 |
1089530 | 1089530 | 2021-03-05 | Baker | Florida | 12003 | 3312 | 56 |
1089531 | 1089531 | 2021-03-05 | Bay | Florida | 12005 | 18998 | 351 |
1089532 | 1089532 | 2021-03-05 | Bradford | Florida | 12007 | 2862 | 52 |
1089533 | 1089533 | 2021-03-05 | Brevard | Florida | 12009 | 34549 | 761 |
1089534 | 1089534 | 2021-03-05 | Broward | Florida | 12011 | 198387 | 2438 |
1089535 | 1089535 | 2021-03-05 | Calhoun | Florida | 12013 | 1622 | 46 |
1089536 | 1089536 | 2021-03-05 | Charlotte | Florida | 12015 | 10801 | 373 |
1089537 | 1089537 | 2021-03-05 | Citrus | Florida | 12017 | 9850 | 411 |
1089538 | 1089538 | 2021-03-05 | Clay | Florida | 12019 | 16818 | 315 |
1089539 | 1089539 | 2021-03-05 | Collier | Florida | 12021 | 30640 | 464 |
1089540 | 1089540 | 2021-03-05 | Columbia | Florida | 12023 | 7713 | 161 |
1089541 | 1089541 | 2021-03-05 | DeSoto | Florida | 12027 | 3850 | 75 |
1089542 | 1089542 | 2021-03-05 | Dixie | Florida | 12029 | 1507 | 21 |
1089543 | 1089543 | 2021-03-05 | Duval | Florida | 12031 | 89491 | 1193 |
1089544 | 1089544 | 2021-03-05 | Escambia | Florida | 12033 | 34019 | 638 |
1089545 | 1089545 | 2021-03-05 | Flagler | Florida | 12035 | 6094 | 92 |
1089546 | 1089546 | 2021-03-05 | Franklin | Florida | 12037 | 1279 | 17 |
1089547 | 1089547 | 2021-03-05 | Gadsden | Florida | 12039 | 5475 | 87 |
1089548 | 1089548 | 2021-03-05 | Gilchrist | Florida | 12041 | 1427 | 36 |
1089549 | 1089549 | 2021-03-05 | Glades | Florida | 12043 | 906 | 15 |
1089550 | 1089550 | 2021-03-05 | Gulf | Florida | 12045 | 1878 | 41 |
1089551 | 1089551 | 2021-03-05 | Hamilton | Florida | 12047 | 1572 | 22 |
1089552 | 1089552 | 2021-03-05 | Hardee | Florida | 12049 | 2813 | 31 |
1089553 | 1089553 | 2021-03-05 | Hendry | Florida | 12051 | 4340 | 73 |
1089554 | 1089554 | 2021-03-05 | Hernando | Florida | 12053 | 11521 | 403 |
1089555 | 1089555 | 2021-03-05 | Highlands | Florida | 12055 | 7326 | 308 |
1089556 | 1089556 | 2021-03-05 | Hillsborough | Florida | 12057 | 113045 | 1533 |
1089557 | 1089557 | 2021-03-05 | Holmes | Florida | 12059 | 2193 | 46 |
1089558 | 1089558 | 2021-03-05 | Indian River | Florida | 12061 | 11157 | 267 |
1089559 | 1089559 | 2021-03-05 | Jackson | Florida | 12063 | 5954 | 152 |
1089560 | 1089560 | 2021-03-05 | Jefferson | Florida | 12065 | 1409 | 24 |
1089561 | 1089561 | 2021-03-05 | Lafayette | Florida | 12067 | 1594 | 24 |
1089562 | 1089562 | 2021-03-05 | Lake | Florida | 12069 | 25010 | 577 |
1089563 | 1089563 | 2021-03-05 | Lee | Florida | 12071 | 58528 | 886 |
1089564 | 1089564 | 2021-03-05 | Leon | Florida | 12073 | 29423 | 293 |
1089565 | 1089565 | 2021-03-05 | Levy | Florida | 12075 | 2914 | 40 |
1089566 | 1089566 | 2021-03-05 | Liberty | Florida | 12077 | 1046 | 16 |
1089567 | 1089567 | 2021-03-05 | Madison | Florida | 12079 | 2011 | 43 |
1089568 | 1089568 | 2021-03-05 | Manatee | Florida | 12081 | 32443 | 609 |
1089569 | 1089569 | 2021-03-05 | Marion | Florida | 12083 | 27957 | 844 |
1089570 | 1089570 | 2021-03-05 | Martin | Florida | 12085 | 10766 | 294 |
1089571 | 1089571 | 2021-03-05 | Miami-Dade | Florida | 12086 | 417446 | 5530 |
1089572 | 1089572 | 2021-03-05 | Monroe | Florida | 12087 | 5958 | 46 |
1089573 | 1089573 | 2021-03-05 | Nassau | Florida | 12089 | 7781 | 114 |
1089574 | 1089574 | 2021-03-05 | Okaloosa | Florida | 12091 | 19173 | 331 |
1089575 | 1089575 | 2021-03-05 | Okeechobee | Florida | 12093 | 3591 | 82 |
1089576 | 1089576 | 2021-03-05 | Orange | Florida | 12095 | 115817 | 1116 |
1089577 | 1089577 | 2021-03-05 | Osceola | Florida | 12097 | 37291 | 453 |
1089578 | 1089578 | 2021-03-05 | Palm Beach | Florida | 12099 | 122707 | 2510 |
1089579 | 1089579 | 2021-03-05 | Pasco | Florida | 12101 | 33888 | 664 |
1089580 | 1089580 | 2021-03-05 | Pinellas | Florida | 12103 | 67554 | 1472 |
1089581 | 1089581 | 2021-03-05 | Polk | Florida | 12105 | 57852 | 1164 |
1089582 | 1089582 | 2021-03-05 | Putnam | Florida | 12107 | 5880 | 128 |
1089583 | 1089583 | 2021-03-05 | Santa Rosa | Florida | 12113 | 17276 | 267 |
1089584 | 1089584 | 2021-03-05 | Sarasota | Florida | 12115 | 27376 | 749 |
1089585 | 1089585 | 2021-03-05 | Seminole | Florida | 12117 | 27640 | 438 |
1089586 | 1089586 | 2021-03-05 | St. Johns | Florida | 12109 | 20278 | 199 |
1089587 | 1089587 | 2021-03-05 | St. Lucie | Florida | 12111 | 22520 | 551 |
1089588 | 1089588 | 2021-03-05 | Sumter | Florida | 12119 | 8147 | 243 |
1089589 | 1089589 | 2021-03-05 | Suwannee | Florida | 12121 | 5137 | 133 |
1089590 | 1089590 | 2021-03-05 | Taylor | Florida | 12123 | 2653 | 42 |
1089591 | 1089591 | 2021-03-05 | Union | Florida | 12125 | 1744 | 70 |
1089592 | 1089592 | 2021-03-05 | Unknown | Florida | 3491 | 0 | |
1089593 | 1089593 | 2021-03-05 | Volusia | Florida | 12127 | 34993 | 675 |
1089594 | 1089594 | 2021-03-05 | Wakulla | Florida | 12129 | 3186 | 52 |
1089595 | 1089595 | 2021-03-05 | Walton | Florida | 12131 | 7129 | 81 |
1089596 | 1089596 | 2021-03-05 | Washington | Florida | 12133 | 2636 | 48 |
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);