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 230
- 12081 230
- 12113 226
- 12011 225
- 12071 225
- 12015 224
- 12091 224
- 12127 224
- 12001 221
- 12021 221
- 12089 221
- 12101 221
- 12103 221
- 12086 220
- 12109 220
- 12019 219
- 12031 219
- 12099 219
- 12115 219
- 12117 219
- 12095 218
- 12097 218
- 12003 216
- 12017 216
- 12033 215
- 12069 215
- 12009 214
- 12105 214
- 12073 213
- 12119 213
- …
county >30
- Hillsborough 230
- Manatee 230
- Santa Rosa 226
- Broward 225
- Lee 225
- Charlotte 224
- Okaloosa 224
- Volusia 224
- Alachua 221
- Collier 221
- Nassau 221
- Pasco 221
- Pinellas 221
- Miami-Dade 220
- St. Johns 220
- Clay 219
- Duval 219
- Palm Beach 219
- Sarasota 219
- Seminole 219
- Orange 218
- Osceola 218
- Baker 216
- Citrus 216
- Escambia 215
- Lake 215
- Brevard 214
- Polk 214
- Leon 213
- Sumter 213
- …
state 1
- Florida · 14,330 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635207 | 635207 | 2020-10-16 | Alachua | Florida | 12001 | 9307 | 70 |
635208 | 635208 | 2020-10-16 | Baker | Florida | 12003 | 1672 | 17 |
635209 | 635209 | 2020-10-16 | Bay | Florida | 12005 | 6408 | 125 |
635210 | 635210 | 2020-10-16 | Bradford | Florida | 12007 | 1197 | 11 |
635211 | 635211 | 2020-10-16 | Brevard | Florida | 12009 | 10268 | 342 |
635212 | 635212 | 2020-10-16 | Broward | Florida | 12011 | 80443 | 1500 |
635213 | 635213 | 2020-10-16 | Calhoun | Florida | 12013 | 663 | 14 |
635214 | 635214 | 2020-10-16 | Charlotte | Florida | 12015 | 3332 | 152 |
635215 | 635215 | 2020-10-16 | Citrus | Florida | 12017 | 3000 | 125 |
635216 | 635216 | 2020-10-16 | Clay | Florida | 12019 | 5627 | 114 |
635217 | 635217 | 2020-10-16 | Collier | Florida | 12021 | 13492 | 243 |
635218 | 635218 | 2020-10-16 | Columbia | Florida | 12023 | 4083 | 70 |
635219 | 635219 | 2020-10-16 | DeSoto | Florida | 12027 | 1612 | 27 |
635220 | 635220 | 2020-10-16 | Dixie | Florida | 12029 | 863 | 11 |
635221 | 635221 | 2020-10-16 | Duval | Florida | 12031 | 32625 | 505 |
635222 | 635222 | 2020-10-16 | Escambia | Florida | 12033 | 12883 | 268 |
635223 | 635223 | 2020-10-16 | Flagler | Florida | 12035 | 1927 | 35 |
635224 | 635224 | 2020-10-16 | Franklin | Florida | 12037 | 687 | 4 |
635225 | 635225 | 2020-10-16 | Gadsden | Florida | 12039 | 3014 | 51 |
635226 | 635226 | 2020-10-16 | Gilchrist | Florida | 12041 | 540 | 17 |
635227 | 635227 | 2020-10-16 | Glades | Florida | 12043 | 587 | 6 |
635228 | 635228 | 2020-10-16 | Gulf | Florida | 12045 | 920 | 15 |
635229 | 635229 | 2020-10-16 | Hamilton | Florida | 12047 | 888 | 9 |
635230 | 635230 | 2020-10-16 | Hardee | Florida | 12049 | 1519 | 11 |
635231 | 635231 | 2020-10-16 | Hendry | Florida | 12051 | 2143 | 43 |
635232 | 635232 | 2020-10-16 | Hernando | Florida | 12053 | 3385 | 153 |
635233 | 635233 | 2020-10-16 | Highlands | Florida | 12055 | 2416 | 101 |
635234 | 635234 | 2020-10-16 | Hillsborough | Florida | 12057 | 44999 | 738 |
635235 | 635235 | 2020-10-16 | Holmes | Florida | 12059 | 818 | 10 |
635236 | 635236 | 2020-10-16 | Indian River | Florida | 12061 | 3495 | 122 |
635237 | 635237 | 2020-10-16 | Jackson | Florida | 12063 | 3018 | 83 |
635238 | 635238 | 2020-10-16 | Jefferson | Florida | 12065 | 611 | 9 |
635239 | 635239 | 2020-10-16 | Lafayette | Florida | 12067 | 1258 | 15 |
635240 | 635240 | 2020-10-16 | Lake | Florida | 12069 | 8083 | 214 |
635241 | 635241 | 2020-10-16 | Lee | Florida | 12071 | 21752 | 492 |
635242 | 635242 | 2020-10-16 | Leon | Florida | 12073 | 11563 | 97 |
635243 | 635243 | 2020-10-16 | Levy | Florida | 12075 | 1096 | 10 |
635244 | 635244 | 2020-10-16 | Liberty | Florida | 12077 | 521 | 10 |
635245 | 635245 | 2020-10-16 | Madison | Florida | 12079 | 1052 | 24 |
635246 | 635246 | 2020-10-16 | Manatee | Florida | 12081 | 12365 | 317 |
635247 | 635247 | 2020-10-16 | Marion | Florida | 12083 | 10345 | 335 |
635248 | 635248 | 2020-10-16 | Martin | Florida | 12085 | 5137 | 153 |
635249 | 635249 | 2020-10-16 | Miami-Dade | Florida | 12086 | 177338 | 3520 |
635250 | 635250 | 2020-10-16 | Monroe | Florida | 12087 | 2022 | 24 |
635251 | 635251 | 2020-10-16 | Nassau | Florida | 12089 | 2319 | 50 |
635252 | 635252 | 2020-10-16 | Okaloosa | Florida | 12091 | 5705 | 127 |
635253 | 635253 | 2020-10-16 | Okeechobee | Florida | 12093 | 1660 | 37 |
635254 | 635254 | 2020-10-16 | Orange | Florida | 12095 | 43043 | 527 |
635255 | 635255 | 2020-10-16 | Osceola | Florida | 12097 | 13356 | 178 |
635256 | 635256 | 2020-10-16 | Palm Beach | Florida | 12099 | 48672 | 1478 |
635257 | 635257 | 2020-10-16 | Pasco | Florida | 12101 | 10089 | 222 |
635258 | 635258 | 2020-10-16 | Pinellas | Florida | 12103 | 23746 | 793 |
635259 | 635259 | 2020-10-16 | Polk | Florida | 12105 | 21572 | 578 |
635260 | 635260 | 2020-10-16 | Putnam | Florida | 12107 | 2253 | 47 |
635261 | 635261 | 2020-10-16 | Santa Rosa | Florida | 12113 | 5667 | 85 |
635262 | 635262 | 2020-10-16 | Sarasota | Florida | 12115 | 8908 | 307 |
635263 | 635263 | 2020-10-16 | Seminole | Florida | 12117 | 9605 | 234 |
635264 | 635264 | 2020-10-16 | St. Johns | Florida | 12109 | 5900 | 78 |
635265 | 635265 | 2020-10-16 | St. Lucie | Florida | 12111 | 8521 | 315 |
635266 | 635266 | 2020-10-16 | Sumter | Florida | 12119 | 2731 | 79 |
635267 | 635267 | 2020-10-16 | Suwannee | Florida | 12121 | 2895 | 76 |
635268 | 635268 | 2020-10-16 | Taylor | Florida | 12123 | 1414 | 15 |
635269 | 635269 | 2020-10-16 | Union | Florida | 12125 | 1066 | 27 |
635270 | 635270 | 2020-10-16 | Unknown | Florida | 1948 | 0 | |
635271 | 635271 | 2020-10-16 | Volusia | Florida | 12127 | 11819 | 300 |
635272 | 635272 | 2020-10-16 | Wakulla | Florida | 12129 | 1233 | 11 |
635273 | 635273 | 2020-10-16 | Walton | Florida | 12131 | 2182 | 29 |
635274 | 635274 | 2020-10-16 | Washington | Florida | 12133 | 1151 | 24 |
631961 | 631961 | 2020-10-15 | Alachua | Florida | 12001 | 9190 | 70 |
631962 | 631962 | 2020-10-15 | Baker | Florida | 12003 | 1655 | 17 |
631963 | 631963 | 2020-10-15 | Bay | Florida | 12005 | 6394 | 125 |
631964 | 631964 | 2020-10-15 | Bradford | Florida | 12007 | 1194 | 11 |
631965 | 631965 | 2020-10-15 | Brevard | Florida | 12009 | 10183 | 337 |
631966 | 631966 | 2020-10-15 | Broward | Florida | 12011 | 80112 | 1492 |
631967 | 631967 | 2020-10-15 | Calhoun | Florida | 12013 | 658 | 14 |
631968 | 631968 | 2020-10-15 | Charlotte | Florida | 12015 | 3316 | 151 |
631969 | 631969 | 2020-10-15 | Citrus | Florida | 12017 | 2988 | 124 |
631970 | 631970 | 2020-10-15 | Clay | Florida | 12019 | 5596 | 113 |
631971 | 631971 | 2020-10-15 | Collier | Florida | 12021 | 13432 | 242 |
631972 | 631972 | 2020-10-15 | Columbia | Florida | 12023 | 4051 | 70 |
631973 | 631973 | 2020-10-15 | DeSoto | Florida | 12027 | 1609 | 27 |
631974 | 631974 | 2020-10-15 | Dixie | Florida | 12029 | 862 | 11 |
631975 | 631975 | 2020-10-15 | Duval | Florida | 12031 | 32489 | 500 |
631976 | 631976 | 2020-10-15 | Escambia | Florida | 12033 | 12837 | 267 |
631977 | 631977 | 2020-10-15 | Flagler | Florida | 12035 | 1904 | 33 |
631978 | 631978 | 2020-10-15 | Franklin | Florida | 12037 | 686 | 4 |
631979 | 631979 | 2020-10-15 | Gadsden | Florida | 12039 | 3004 | 51 |
631980 | 631980 | 2020-10-15 | Gilchrist | Florida | 12041 | 538 | 17 |
631981 | 631981 | 2020-10-15 | Glades | Florida | 12043 | 584 | 6 |
631982 | 631982 | 2020-10-15 | Gulf | Florida | 12045 | 917 | 15 |
631983 | 631983 | 2020-10-15 | Hamilton | Florida | 12047 | 888 | 9 |
631984 | 631984 | 2020-10-15 | Hardee | Florida | 12049 | 1504 | 11 |
631985 | 631985 | 2020-10-15 | Hendry | Florida | 12051 | 2137 | 43 |
631986 | 631986 | 2020-10-15 | Hernando | Florida | 12053 | 3359 | 151 |
631987 | 631987 | 2020-10-15 | Highlands | Florida | 12055 | 2406 | 100 |
631988 | 631988 | 2020-10-15 | Hillsborough | Florida | 12057 | 44811 | 734 |
631989 | 631989 | 2020-10-15 | Holmes | Florida | 12059 | 812 | 10 |
631990 | 631990 | 2020-10-15 | Indian River | Florida | 12061 | 3476 | 121 |
631991 | 631991 | 2020-10-15 | Jackson | Florida | 12063 | 3000 | 83 |
631992 | 631992 | 2020-10-15 | Jefferson | Florida | 12065 | 608 | 9 |
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);