ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
68 rows where date = "2021-11-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 |
---|---|---|---|---|---|---|---|
1898169 | 1898169 | 2021-11-09 | Alachua | Florida | 12001 | 39644 | 536 |
1898170 | 1898170 | 2021-11-09 | Baker | Florida | 12003 | 5983 | 121 |
1898171 | 1898171 | 2021-11-09 | Bay | Florida | 12005 | 31825 | 687 |
1898172 | 1898172 | 2021-11-09 | Bradford | Florida | 12007 | 5336 | 119 |
1898173 | 1898173 | 2021-11-09 | Brevard | Florida | 12009 | 80892 | 1754 |
1898174 | 1898174 | 2021-11-09 | Broward | Florida | 12011 | 357796 | 4845 |
1898175 | 1898175 | 2021-11-09 | Calhoun | Florida | 12013 | 3005 | 85 |
1898176 | 1898176 | 2021-11-09 | Charlotte | Florida | 12015 | 23314 | 671 |
1898177 | 1898177 | 2021-11-09 | Citrus | Florida | 12017 | 20464 | 820 |
1898178 | 1898178 | 2021-11-09 | Clay | Florida | 12019 | 33858 | 698 |
1898179 | 1898179 | 2021-11-09 | Collier | Florida | 12021 | 56863 | 862 |
1898180 | 1898180 | 2021-11-09 | Columbia | Florida | 12023 | 14911 | 315 |
1898181 | 1898181 | 2021-11-09 | DeSoto | Florida | 12027 | 6914 | 134 |
1898182 | 1898182 | 2021-11-09 | Dixie | Florida | 12029 | 2953 | 34 |
1898183 | 1898183 | 2021-11-09 | Duval | Florida | 12031 | 164754 | 2829 |
1898184 | 1898184 | 2021-11-09 | Escambia | Florida | 12033 | 53752 | 1081 |
1898185 | 1898185 | 2021-11-09 | Flagler | Florida | 12035 | 14409 | 275 |
1898186 | 1898186 | 2021-11-09 | Franklin | Florida | 12037 | 2228 | 45 |
1898187 | 1898187 | 2021-11-09 | Gadsden | Florida | 12039 | 8658 | 124 |
1898188 | 1898188 | 2021-11-09 | Gilchrist | Florida | 12041 | 3164 | 58 |
1898189 | 1898189 | 2021-11-09 | Glades | Florida | 12043 | 1452 | 33 |
1898190 | 1898190 | 2021-11-09 | Gulf | Florida | 12045 | 2976 | 64 |
1898191 | 1898191 | 2021-11-09 | Hamilton | Florida | 12047 | 2745 | 49 |
1898192 | 1898192 | 2021-11-09 | Hardee | Florida | 12049 | 6075 | 102 |
1898193 | 1898193 | 2021-11-09 | Hendry | Florida | 12051 | 7985 | 153 |
1898194 | 1898194 | 2021-11-09 | Hernando | Florida | 12053 | 28593 | 918 |
1898195 | 1898195 | 2021-11-09 | Highlands | Florida | 12055 | 15971 | 558 |
1898196 | 1898196 | 2021-11-09 | Hillsborough | Florida | 12057 | 242349 | 3020 |
1898197 | 1898197 | 2021-11-09 | Holmes | Florida | 12059 | 3845 | 73 |
1898198 | 1898198 | 2021-11-09 | Indian River | Florida | 12061 | 22188 | 561 |
1898199 | 1898199 | 2021-11-09 | Jackson | Florida | 12063 | 10121 | 274 |
1898200 | 1898200 | 2021-11-09 | Jefferson | Florida | 12065 | 2478 | 36 |
1898201 | 1898201 | 2021-11-09 | Lafayette | Florida | 12067 | 2219 | 51 |
1898202 | 1898202 | 2021-11-09 | Lake | Florida | 12069 | 54697 | 1207 |
1898203 | 1898203 | 2021-11-09 | Lee | Florida | 12071 | 125270 | 1825 |
1898204 | 1898204 | 2021-11-09 | Leon | Florida | 12073 | 50786 | 514 |
1898205 | 1898205 | 2021-11-09 | Levy | Florida | 12075 | 6999 | 88 |
1898206 | 1898206 | 2021-11-09 | Liberty | Florida | 12077 | 1830 | 23 |
1898207 | 1898207 | 2021-11-09 | Madison | Florida | 12079 | 3588 | 58 |
1898208 | 1898208 | 2021-11-09 | Manatee | Florida | 12081 | 64975 | 1222 |
1898209 | 1898209 | 2021-11-09 | Marion | Florida | 12083 | 56915 | 1749 |
1898210 | 1898210 | 2021-11-09 | Martin | Florida | 12085 | 20197 | 511 |
1898211 | 1898211 | 2021-11-09 | Miami-Dade | Florida | 12086 | 673883 | 9019 |
1898212 | 1898212 | 2021-11-09 | Monroe | Florida | 12087 | 10589 | 95 |
1898213 | 1898213 | 2021-11-09 | Nassau | Florida | 12089 | 15090 | 245 |
1898214 | 1898214 | 2021-11-09 | Okaloosa | Florida | 12091 | 34527 | 562 |
1898215 | 1898215 | 2021-11-09 | Okeechobee | Florida | 12093 | 7390 | 173 |
1898216 | 1898216 | 2021-11-09 | Orange | Florida | 12095 | 228752 | 2238 |
1898217 | 1898217 | 2021-11-09 | Osceola | Florida | 12097 | 71800 | 893 |
1898218 | 1898218 | 2021-11-09 | Palm Beach | Florida | 12099 | 225725 | 4201 |
1898219 | 1898219 | 2021-11-09 | Pasco | Florida | 12101 | 79364 | 1570 |
1898220 | 1898220 | 2021-11-09 | Pinellas | Florida | 12103 | 134737 | 2702 |
1898221 | 1898221 | 2021-11-09 | Polk | Florida | 12105 | 128744 | 2464 |
1898222 | 1898222 | 2021-11-09 | Putnam | Florida | 12107 | 12801 | 376 |
1898223 | 1898223 | 2021-11-09 | Santa Rosa | Florida | 12113 | 32460 | 518 |
1898224 | 1898224 | 2021-11-09 | Sarasota | Florida | 12115 | 55386 | 1316 |
1898225 | 1898225 | 2021-11-09 | Seminole | Florida | 12117 | 62334 | 866 |
1898226 | 1898226 | 2021-11-09 | St. Johns | Florida | 12109 | 40809 | 465 |
1898227 | 1898227 | 2021-11-09 | St. Lucie | Florida | 12111 | 47878 | 1026 |
1898228 | 1898228 | 2021-11-09 | Sumter | Florida | 12119 | 14602 | 465 |
1898229 | 1898229 | 2021-11-09 | Suwannee | Florida | 12121 | 9221 | 177 |
1898230 | 1898230 | 2021-11-09 | Taylor | Florida | 12123 | 4596 | 80 |
1898231 | 1898231 | 2021-11-09 | Union | Florida | 12125 | 3067 | 96 |
1898232 | 1898232 | 2021-11-09 | Unknown | Florida | 5183 | 20 | |
1898233 | 1898233 | 2021-11-09 | Volusia | Florida | 12127 | 76090 | 1336 |
1898234 | 1898234 | 2021-11-09 | Wakulla | Florida | 12129 | 6430 | 104 |
1898235 | 1898235 | 2021-11-09 | Walton | Florida | 12131 | 11969 | 163 |
1898236 | 1898236 | 2021-11-09 | Washington | Florida | 12133 | 4553 | 66 |
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);