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-02-11 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 |
---|---|---|---|---|---|---|---|
1018126 | 1018126 | 2021-02-11 | Alachua | Florida | 12001 | 21649 | 189 |
1018127 | 1018127 | 2021-02-11 | Baker | Florida | 12003 | 3199 | 54 |
1018128 | 1018128 | 2021-02-11 | Bay | Florida | 12005 | 17721 | 314 |
1018129 | 1018129 | 2021-02-11 | Bradford | Florida | 12007 | 2765 | 48 |
1018130 | 1018130 | 2021-02-11 | Brevard | Florida | 12009 | 31581 | 690 |
1018131 | 1018131 | 2021-02-11 | Broward | Florida | 12011 | 182419 | 2218 |
1018132 | 1018132 | 2021-02-11 | Calhoun | Florida | 12013 | 1574 | 36 |
1018133 | 1018133 | 2021-02-11 | Charlotte | Florida | 12015 | 10150 | 320 |
1018134 | 1018134 | 2021-02-11 | Citrus | Florida | 12017 | 9210 | 362 |
1018135 | 1018135 | 2021-02-11 | Clay | Florida | 12019 | 16080 | 283 |
1018136 | 1018136 | 2021-02-11 | Collier | Florida | 12021 | 28883 | 426 |
1018137 | 1018137 | 2021-02-11 | Columbia | Florida | 12023 | 7440 | 148 |
1018138 | 1018138 | 2021-02-11 | DeSoto | Florida | 12027 | 3511 | 69 |
1018139 | 1018139 | 2021-02-11 | Dixie | Florida | 12029 | 1427 | 15 |
1018140 | 1018140 | 2021-02-11 | Duval | Florida | 12031 | 85430 | 1002 |
1018141 | 1018141 | 2021-02-11 | Escambia | Florida | 12033 | 32484 | 582 |
1018142 | 1018142 | 2021-02-11 | Flagler | Florida | 12035 | 5573 | 76 |
1018143 | 1018143 | 2021-02-11 | Franklin | Florida | 12037 | 1265 | 11 |
1018144 | 1018144 | 2021-02-11 | Gadsden | Florida | 12039 | 5284 | 76 |
1018145 | 1018145 | 2021-02-11 | Gilchrist | Florida | 12041 | 1283 | 28 |
1018146 | 1018146 | 2021-02-11 | Glades | Florida | 12043 | 872 | 14 |
1018147 | 1018147 | 2021-02-11 | Gulf | Florida | 12045 | 1784 | 35 |
1018148 | 1018148 | 2021-02-11 | Hamilton | Florida | 12047 | 1539 | 21 |
1018149 | 1018149 | 2021-02-11 | Hardee | Florida | 12049 | 2688 | 24 |
1018150 | 1018150 | 2021-02-11 | Hendry | Florida | 12051 | 4166 | 62 |
1018151 | 1018151 | 2021-02-11 | Hernando | Florida | 12053 | 10515 | 368 |
1018152 | 1018152 | 2021-02-11 | Highlands | Florida | 12055 | 6846 | 282 |
1018153 | 1018153 | 2021-02-11 | Hillsborough | Florida | 12057 | 105142 | 1387 |
1018154 | 1018154 | 2021-02-11 | Holmes | Florida | 12059 | 2139 | 41 |
1018155 | 1018155 | 2021-02-11 | Indian River | Florida | 12061 | 10324 | 248 |
1018156 | 1018156 | 2021-02-11 | Jackson | Florida | 12063 | 5791 | 138 |
1018157 | 1018157 | 2021-02-11 | Jefferson | Florida | 12065 | 1362 | 22 |
1018158 | 1018158 | 2021-02-11 | Lafayette | Florida | 12067 | 1543 | 24 |
1018159 | 1018159 | 2021-02-11 | Lake | Florida | 12069 | 23099 | 494 |
1018160 | 1018160 | 2021-02-11 | Lee | Florida | 12071 | 55000 | 848 |
1018161 | 1018161 | 2021-02-11 | Leon | Florida | 12073 | 27806 | 258 |
1018162 | 1018162 | 2021-02-11 | Levy | Florida | 12075 | 2704 | 24 |
1018163 | 1018163 | 2021-02-11 | Liberty | Florida | 12077 | 1019 | 14 |
1018164 | 1018164 | 2021-02-11 | Madison | Florida | 12079 | 1901 | 39 |
1018165 | 1018165 | 2021-02-11 | Manatee | Florida | 12081 | 29972 | 513 |
1018166 | 1018166 | 2021-02-11 | Marion | Florida | 12083 | 25948 | 672 |
1018167 | 1018167 | 2021-02-11 | Martin | Florida | 12085 | 9994 | 262 |
1018168 | 1018168 | 2021-02-11 | Miami-Dade | Florida | 12086 | 389518 | 5081 |
1018169 | 1018169 | 2021-02-11 | Monroe | Florida | 12087 | 5528 | 42 |
1018170 | 1018170 | 2021-02-11 | Nassau | Florida | 12089 | 7381 | 105 |
1018171 | 1018171 | 2021-02-11 | Okaloosa | Florida | 12091 | 17756 | 301 |
1018172 | 1018172 | 2021-02-11 | Okeechobee | Florida | 12093 | 3396 | 69 |
1018173 | 1018173 | 2021-02-11 | Orange | Florida | 12095 | 108208 | 1014 |
1018174 | 1018174 | 2021-02-11 | Osceola | Florida | 12097 | 35033 | 399 |
1018175 | 1018175 | 2021-02-11 | Palm Beach | Florida | 12099 | 112962 | 2302 |
1018176 | 1018176 | 2021-02-11 | Pasco | Florida | 12101 | 31188 | 595 |
1018177 | 1018177 | 2021-02-11 | Pinellas | Florida | 12103 | 62499 | 1372 |
1018178 | 1018178 | 2021-02-11 | Polk | Florida | 12105 | 53651 | 1050 |
1018179 | 1018179 | 2021-02-11 | Putnam | Florida | 12107 | 5666 | 109 |
1018180 | 1018180 | 2021-02-11 | Santa Rosa | Florida | 12113 | 16308 | 237 |
1018181 | 1018181 | 2021-02-11 | Sarasota | Florida | 12115 | 25801 | 676 |
1018182 | 1018182 | 2021-02-11 | Seminole | Florida | 12117 | 25455 | 396 |
1018183 | 1018183 | 2021-02-11 | St. Johns | Florida | 12109 | 19343 | 180 |
1018184 | 1018184 | 2021-02-11 | St. Lucie | Florida | 12111 | 20665 | 521 |
1018185 | 1018185 | 2021-02-11 | Sumter | Florida | 12119 | 7522 | 215 |
1018186 | 1018186 | 2021-02-11 | Suwannee | Florida | 12121 | 4962 | 119 |
1018187 | 1018187 | 2021-02-11 | Taylor | Florida | 12123 | 2568 | 37 |
1018188 | 1018188 | 2021-02-11 | Union | Florida | 12125 | 1702 | 70 |
1018189 | 1018189 | 2021-02-11 | Unknown | Florida | 3384 | 0 | |
1018190 | 1018190 | 2021-02-11 | Volusia | Florida | 12127 | 32839 | 596 |
1018191 | 1018191 | 2021-02-11 | Wakulla | Florida | 12129 | 3080 | 44 |
1018192 | 1018192 | 2021-02-11 | Walton | Florida | 12131 | 6746 | 76 |
1018193 | 1018193 | 2021-02-11 | Washington | Florida | 12133 | 2554 | 38 |
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);