ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
53,362 rows where state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 12057 684
- 12081 684
- 12113 680
- 12011 679
- 12071 679
- 12015 678
- 12091 678
- 12127 678
- 12001 675
- 12021 675
- 12089 675
- 12101 675
- 12103 675
- 12086 674
- 12109 674
- 12019 673
- 12031 673
- 12099 673
- 12115 673
- 12117 673
- 12095 672
- 12097 672
- 12003 670
- 12017 670
- 12033 669
- 12069 669
- 12009 668
- 12105 668
- 12073 667
- 12119 667
- …
county >30
- Hillsborough 684
- Manatee 684
- Santa Rosa 680
- Broward 679
- Lee 679
- Charlotte 678
- Okaloosa 678
- Volusia 678
- Alachua 675
- Collier 675
- Nassau 675
- Pasco 675
- Pinellas 675
- Miami-Dade 674
- St. Johns 674
- Clay 673
- Duval 673
- Palm Beach 673
- Sarasota 673
- Seminole 673
- Orange 672
- Osceola 672
- Baker 670
- Citrus 670
- Escambia 669
- Lake 669
- Brevard 668
- Polk 668
- Leon 667
- Sumter 667
- …
state 1
- Florida · 45,202 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2109452 | 2109452 | 2022-01-13 | Alachua | Florida | 12001 | 47057 | 539 |
2109453 | 2109453 | 2022-01-13 | Baker | Florida | 12003 | 6347 | 122 |
2109454 | 2109454 | 2022-01-13 | Bay | Florida | 12005 | 34467 | 708 |
2109455 | 2109455 | 2022-01-13 | Bradford | Florida | 12007 | 5660 | 128 |
2109456 | 2109456 | 2022-01-13 | Brevard | Florida | 12009 | 96835 | 1796 |
2109457 | 2109457 | 2022-01-13 | Broward | Florida | 12011 | 490229 | 5006 |
2109458 | 2109458 | 2022-01-13 | Calhoun | Florida | 12013 | 3217 | 85 |
2109459 | 2109459 | 2022-01-13 | Charlotte | Florida | 12015 | 26377 | 677 |
2109460 | 2109460 | 2022-01-13 | Citrus | Florida | 12017 | 22267 | 846 |
2109461 | 2109461 | 2022-01-13 | Clay | Florida | 12019 | 38296 | 707 |
2109462 | 2109462 | 2022-01-13 | Collier | Florida | 12021 | 66928 | 889 |
2109463 | 2109463 | 2022-01-13 | Columbia | Florida | 12023 | 15973 | 324 |
2109464 | 2109464 | 2022-01-13 | DeSoto | Florida | 12027 | 7324 | 138 |
2109465 | 2109465 | 2022-01-13 | Dixie | Florida | 12029 | 3094 | 53 |
2109466 | 2109466 | 2022-01-13 | Duval | Florida | 12031 | 191216 | 2897 |
2109467 | 2109467 | 2022-01-13 | Escambia | Florida | 12033 | 60828 | 1112 |
2109468 | 2109468 | 2022-01-13 | Flagler | Florida | 12035 | 16687 | 282 |
2109469 | 2109469 | 2022-01-13 | Franklin | Florida | 12037 | 2351 | 46 |
2109470 | 2109470 | 2022-01-13 | Gadsden | Florida | 12039 | 10365 | 164 |
2109471 | 2109471 | 2022-01-13 | Gilchrist | Florida | 12041 | 3340 | 70 |
2109472 | 2109472 | 2022-01-13 | Glades | Florida | 12043 | 1579 | 34 |
2109473 | 2109473 | 2022-01-13 | Gulf | Florida | 12045 | 3186 | 65 |
2109474 | 2109474 | 2022-01-13 | Hamilton | Florida | 12047 | 2994 | 49 |
2109475 | 2109475 | 2022-01-13 | Hardee | Florida | 12049 | 6659 | 104 |
2109476 | 2109476 | 2022-01-13 | Hendry | Florida | 12051 | 9137 | 143 |
2109477 | 2109477 | 2022-01-13 | Hernando | Florida | 12053 | 31703 | 936 |
2109478 | 2109478 | 2022-01-13 | Highlands | Florida | 12055 | 17923 | 571 |
2109479 | 2109479 | 2022-01-13 | Hillsborough | Florida | 12057 | 290614 | 3145 |
2109480 | 2109480 | 2022-01-13 | Holmes | Florida | 12059 | 4075 | 74 |
2109481 | 2109481 | 2022-01-13 | Indian River | Florida | 12061 | 24748 | 571 |
2109482 | 2109482 | 2022-01-13 | Jackson | Florida | 12063 | 10983 | 243 |
2109483 | 2109483 | 2022-01-13 | Jefferson | Florida | 12065 | 2815 | 36 |
2109484 | 2109484 | 2022-01-13 | Lafayette | Florida | 12067 | 2274 | 51 |
2109485 | 2109485 | 2022-01-13 | Lake | Florida | 12069 | 63681 | 1257 |
2109486 | 2109486 | 2022-01-13 | Lee | Florida | 12071 | 145973 | 1869 |
2109487 | 2109487 | 2022-01-13 | Leon | Florida | 12073 | 62276 | 531 |
2109488 | 2109488 | 2022-01-13 | Levy | Florida | 12075 | 7549 | 114 |
2109489 | 2109489 | 2022-01-13 | Liberty | Florida | 12077 | 1950 | 25 |
2109490 | 2109490 | 2022-01-13 | Madison | Florida | 12079 | 4015 | 69 |
2109491 | 2109491 | 2022-01-13 | Manatee | Florida | 12081 | 74266 | 1230 |
2109492 | 2109492 | 2022-01-13 | Marion | Florida | 12083 | 62790 | 1810 |
2109493 | 2109493 | 2022-01-13 | Martin | Florida | 12085 | 24602 | 524 |
2109494 | 2109494 | 2022-01-13 | Miami-Dade | Florida | 12086 | 958187 | 9314 |
2109495 | 2109495 | 2022-01-13 | Monroe | Florida | 12087 | 14093 | 101 |
2109496 | 2109496 | 2022-01-13 | Nassau | Florida | 12089 | 16676 | 250 |
2109497 | 2109497 | 2022-01-13 | Okaloosa | Florida | 12091 | 38073 | 585 |
2109498 | 2109498 | 2022-01-13 | Okeechobee | Florida | 12093 | 8281 | 163 |
2109499 | 2109499 | 2022-01-13 | Orange | Florida | 12095 | 289041 | 2315 |
2109500 | 2109500 | 2022-01-13 | Osceola | Florida | 12097 | 89228 | 942 |
2109501 | 2109501 | 2022-01-13 | Palm Beach | Florida | 12099 | 297389 | 4338 |
2109502 | 2109502 | 2022-01-13 | Pasco | Florida | 12101 | 91476 | 1635 |
2109503 | 2109503 | 2022-01-13 | Pinellas | Florida | 12103 | 157061 | 2793 |
2109504 | 2109504 | 2022-01-13 | Polk | Florida | 12105 | 152919 | 2547 |
2109505 | 2109505 | 2022-01-13 | Putnam | Florida | 12107 | 13491 | 386 |
2109506 | 2109506 | 2022-01-13 | Santa Rosa | Florida | 12113 | 35949 | 531 |
2109507 | 2109507 | 2022-01-13 | Sarasota | Florida | 12115 | 65438 | 1358 |
2109508 | 2109508 | 2022-01-13 | Seminole | Florida | 12117 | 78133 | 904 |
2109509 | 2109509 | 2022-01-13 | St. Johns | Florida | 12109 | 47136 | 478 |
2109510 | 2109510 | 2022-01-13 | St. Lucie | Florida | 12111 | 56900 | 1052 |
2109511 | 2109511 | 2022-01-13 | Sumter | Florida | 12119 | 16228 | 477 |
2109512 | 2109512 | 2022-01-13 | Suwannee | Florida | 12121 | 9851 | 271 |
2109513 | 2109513 | 2022-01-13 | Taylor | Florida | 12123 | 4927 | 84 |
2109514 | 2109514 | 2022-01-13 | Union | Florida | 12125 | 3264 | 100 |
2109515 | 2109515 | 2022-01-13 | Unknown | Florida | 370566 | 393 | |
2109516 | 2109516 | 2022-01-13 | Volusia | Florida | 12127 | 89401 | 1655 |
2109517 | 2109517 | 2022-01-13 | Wakulla | Florida | 12129 | 7237 | 106 |
2109518 | 2109518 | 2022-01-13 | Walton | Florida | 12131 | 13037 | 176 |
2109519 | 2109519 | 2022-01-13 | Washington | Florida | 12133 | 4886 | 87 |
2106201 | 2106201 | 2022-01-12 | Alachua | Florida | 12001 | 47057 | 539 |
2106202 | 2106202 | 2022-01-12 | Baker | Florida | 12003 | 6347 | 122 |
2106203 | 2106203 | 2022-01-12 | Bay | Florida | 12005 | 34467 | 708 |
2106204 | 2106204 | 2022-01-12 | Bradford | Florida | 12007 | 5660 | 128 |
2106205 | 2106205 | 2022-01-12 | Brevard | Florida | 12009 | 96835 | 1796 |
2106206 | 2106206 | 2022-01-12 | Broward | Florida | 12011 | 490229 | 5006 |
2106207 | 2106207 | 2022-01-12 | Calhoun | Florida | 12013 | 3217 | 85 |
2106208 | 2106208 | 2022-01-12 | Charlotte | Florida | 12015 | 26377 | 677 |
2106209 | 2106209 | 2022-01-12 | Citrus | Florida | 12017 | 22267 | 846 |
2106210 | 2106210 | 2022-01-12 | Clay | Florida | 12019 | 38296 | 707 |
2106211 | 2106211 | 2022-01-12 | Collier | Florida | 12021 | 66928 | 889 |
2106212 | 2106212 | 2022-01-12 | Columbia | Florida | 12023 | 15973 | 324 |
2106213 | 2106213 | 2022-01-12 | DeSoto | Florida | 12027 | 7324 | 138 |
2106214 | 2106214 | 2022-01-12 | Dixie | Florida | 12029 | 3094 | 53 |
2106215 | 2106215 | 2022-01-12 | Duval | Florida | 12031 | 191216 | 2897 |
2106216 | 2106216 | 2022-01-12 | Escambia | Florida | 12033 | 60828 | 1112 |
2106217 | 2106217 | 2022-01-12 | Flagler | Florida | 12035 | 16687 | 282 |
2106218 | 2106218 | 2022-01-12 | Franklin | Florida | 12037 | 2351 | 46 |
2106219 | 2106219 | 2022-01-12 | Gadsden | Florida | 12039 | 10365 | 164 |
2106220 | 2106220 | 2022-01-12 | Gilchrist | Florida | 12041 | 3340 | 70 |
2106221 | 2106221 | 2022-01-12 | Glades | Florida | 12043 | 1579 | 34 |
2106222 | 2106222 | 2022-01-12 | Gulf | Florida | 12045 | 3186 | 65 |
2106223 | 2106223 | 2022-01-12 | Hamilton | Florida | 12047 | 2994 | 49 |
2106224 | 2106224 | 2022-01-12 | Hardee | Florida | 12049 | 6659 | 104 |
2106225 | 2106225 | 2022-01-12 | Hendry | Florida | 12051 | 9137 | 143 |
2106226 | 2106226 | 2022-01-12 | Hernando | Florida | 12053 | 31703 | 936 |
2106227 | 2106227 | 2022-01-12 | Highlands | Florida | 12055 | 17923 | 571 |
2106228 | 2106228 | 2022-01-12 | Hillsborough | Florida | 12057 | 290614 | 3145 |
2106229 | 2106229 | 2022-01-12 | Holmes | Florida | 12059 | 4075 | 74 |
2106230 | 2106230 | 2022-01-12 | Indian River | Florida | 12061 | 24748 | 571 |
2106231 | 2106231 | 2022-01-12 | Jackson | Florida | 12063 | 10983 | 243 |
2106232 | 2106232 | 2022-01-12 | Jefferson | Florida | 12065 | 2815 | 36 |
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);