ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
68 rows where date = "2020-06-21" 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 |
---|---|---|---|---|---|---|---|
259145 | 259145 | 2020-06-21 | Alachua | Florida | 12001 | 716 | 11 |
259146 | 259146 | 2020-06-21 | Baker | Florida | 12003 | 41 | 4 |
259147 | 259147 | 2020-06-21 | Bay | Florida | 12005 | 190 | 4 |
259148 | 259148 | 2020-06-21 | Bradford | Florida | 12007 | 61 | 2 |
259149 | 259149 | 2020-06-21 | Brevard | Florida | 12009 | 850 | 16 |
259150 | 259150 | 2020-06-21 | Broward | Florida | 12011 | 11155 | 373 |
259151 | 259151 | 2020-06-21 | Calhoun | Florida | 12013 | 69 | 6 |
259152 | 259152 | 2020-06-21 | Charlotte | Florida | 12015 | 587 | 75 |
259153 | 259153 | 2020-06-21 | Citrus | Florida | 12017 | 189 | 12 |
259154 | 259154 | 2020-06-21 | Clay | Florida | 12019 | 494 | 32 |
259155 | 259155 | 2020-06-21 | Collier | Florida | 12021 | 3159 | 64 |
259156 | 259156 | 2020-06-21 | Columbia | Florida | 12023 | 227 | 3 |
259157 | 259157 | 2020-06-21 | DeSoto | Florida | 12027 | 450 | 10 |
259158 | 259158 | 2020-06-21 | Dixie | Florida | 12029 | 61 | 3 |
259159 | 259159 | 2020-06-21 | Duval | Florida | 12031 | 2902 | 60 |
259160 | 259160 | 2020-06-21 | Escambia | Florida | 12033 | 1198 | 41 |
259161 | 259161 | 2020-06-21 | Flagler | Florida | 12035 | 226 | 5 |
259162 | 259162 | 2020-06-21 | Franklin | Florida | 12037 | 2 | 0 |
259163 | 259163 | 2020-06-21 | Gadsden | Florida | 12039 | 321 | 6 |
259164 | 259164 | 2020-06-21 | Gilchrist | Florida | 12041 | 75 | 0 |
259165 | 259165 | 2020-06-21 | Glades | Florida | 12043 | 142 | 1 |
259166 | 259166 | 2020-06-21 | Gulf | Florida | 12045 | 11 | 0 |
259167 | 259167 | 2020-06-21 | Hamilton | Florida | 12047 | 289 | 2 |
259168 | 259168 | 2020-06-21 | Hardee | Florida | 12049 | 289 | 1 |
259169 | 259169 | 2020-06-21 | Hendry | Florida | 12051 | 759 | 22 |
259170 | 259170 | 2020-06-21 | Hernando | Florida | 12053 | 185 | 5 |
259171 | 259171 | 2020-06-21 | Highlands | Florida | 12055 | 226 | 10 |
259172 | 259172 | 2020-06-21 | Hillsborough | Florida | 12057 | 5580 | 114 |
259173 | 259173 | 2020-06-21 | Holmes | Florida | 12059 | 47 | 0 |
259174 | 259174 | 2020-06-21 | Indian River | Florida | 12061 | 389 | 15 |
259175 | 259175 | 2020-06-21 | Jackson | Florida | 12063 | 333 | 2 |
259176 | 259176 | 2020-06-21 | Jefferson | Florida | 12065 | 36 | 4 |
259177 | 259177 | 2020-06-21 | Lafayette | Florida | 12067 | 19 | 0 |
259178 | 259178 | 2020-06-21 | Lake | Florida | 12069 | 733 | 19 |
259179 | 259179 | 2020-06-21 | Lee | Florida | 12071 | 3626 | 143 |
259180 | 259180 | 2020-06-21 | Leon | Florida | 12073 | 572 | 8 |
259181 | 259181 | 2020-06-21 | Levy | Florida | 12075 | 139 | 1 |
259182 | 259182 | 2020-06-21 | Liberty | Florida | 12077 | 221 | 1 |
259183 | 259183 | 2020-06-21 | Madison | Florida | 12079 | 123 | 3 |
259184 | 259184 | 2020-06-21 | Manatee | Florida | 12081 | 1890 | 126 |
259185 | 259185 | 2020-06-21 | Marion | Florida | 12083 | 395 | 10 |
259186 | 259186 | 2020-06-21 | Martin | Florida | 12085 | 1525 | 20 |
259187 | 259187 | 2020-06-21 | Miami-Dade | Florida | 12086 | 25789 | 884 |
259188 | 259188 | 2020-06-21 | Monroe | Florida | 12087 | 162 | 4 |
259189 | 259189 | 2020-06-21 | Nassau | Florida | 12089 | 115 | 1 |
259190 | 259190 | 2020-06-21 | Okaloosa | Florida | 12091 | 399 | 6 |
259191 | 259191 | 2020-06-21 | Okeechobee | Florida | 12093 | 245 | 0 |
259192 | 259192 | 2020-06-21 | Orange | Florida | 12095 | 4913 | 47 |
259193 | 259193 | 2020-06-21 | Osceola | Florida | 12097 | 1052 | 23 |
259194 | 259194 | 2020-06-21 | Palm Beach | Florida | 12099 | 10752 | 468 |
259195 | 259195 | 2020-06-21 | Pasco | Florida | 12101 | 809 | 17 |
259196 | 259196 | 2020-06-21 | Pinellas | Florida | 12103 | 3667 | 115 |
259197 | 259197 | 2020-06-21 | Polk | Florida | 12105 | 2042 | 78 |
259198 | 259198 | 2020-06-21 | Putnam | Florida | 12107 | 237 | 6 |
259199 | 259199 | 2020-06-21 | Santa Rosa | Florida | 12113 | 344 | 9 |
259200 | 259200 | 2020-06-21 | Sarasota | Florida | 12115 | 962 | 94 |
259201 | 259201 | 2020-06-21 | Seminole | Florida | 12117 | 1265 | 15 |
259202 | 259202 | 2020-06-21 | St. Johns | Florida | 12109 | 461 | 7 |
259203 | 259203 | 2020-06-21 | St. Lucie | Florida | 12111 | 1214 | 41 |
259204 | 259204 | 2020-06-21 | Sumter | Florida | 12119 | 284 | 17 |
259205 | 259205 | 2020-06-21 | Suwannee | Florida | 12121 | 310 | 18 |
259206 | 259206 | 2020-06-21 | Taylor | Florida | 12123 | 65 | 0 |
259207 | 259207 | 2020-06-21 | Union | Florida | 12125 | 41 | 2 |
259208 | 259208 | 2020-06-21 | Unknown | Florida | 118 | 0 | |
259209 | 259209 | 2020-06-21 | Volusia | Florida | 12127 | 1218 | 53 |
259210 | 259210 | 2020-06-21 | Wakulla | Florida | 12129 | 40 | 1 |
259211 | 259211 | 2020-06-21 | Walton | Florida | 12131 | 181 | 9 |
259212 | 259212 | 2020-06-21 | Washington | Florida | 12133 | 96 | 11 |
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);