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-05-03 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 |
---|---|---|---|---|---|---|---|
1281113 | 1281113 | 2021-05-03 | Alachua | Florida | 12001 | 24717 | 275 |
1281114 | 1281114 | 2021-05-03 | Baker | Florida | 12003 | 3491 | 60 |
1281115 | 1281115 | 2021-05-03 | Bay | Florida | 12005 | 20054 | 386 |
1281116 | 1281116 | 2021-05-03 | Bradford | Florida | 12007 | 3005 | 56 |
1281117 | 1281117 | 2021-05-03 | Brevard | Florida | 12009 | 41183 | 862 |
1281118 | 1281118 | 2021-05-03 | Broward | Florida | 12011 | 237510 | 2905 |
1281119 | 1281119 | 2021-05-03 | Calhoun | Florida | 12013 | 1688 | 43 |
1281120 | 1281120 | 2021-05-03 | Charlotte | Florida | 12015 | 12795 | 418 |
1281121 | 1281121 | 2021-05-03 | Citrus | Florida | 12017 | 11036 | 445 |
1281122 | 1281122 | 2021-05-03 | Clay | Florida | 12019 | 18509 | 340 |
1281123 | 1281123 | 2021-05-03 | Collier | Florida | 12021 | 35575 | 528 |
1281124 | 1281124 | 2021-05-03 | Columbia | Florida | 12023 | 8098 | 169 |
1281125 | 1281125 | 2021-05-03 | DeSoto | Florida | 12027 | 4310 | 93 |
1281126 | 1281126 | 2021-05-03 | Dixie | Florida | 12029 | 1606 | 24 |
1281127 | 1281127 | 2021-05-03 | Duval | Florida | 12031 | 97719 | 1402 |
1281128 | 1281128 | 2021-05-03 | Escambia | Florida | 12033 | 36015 | 680 |
1281129 | 1281129 | 2021-05-03 | Flagler | Florida | 12035 | 7245 | 111 |
1281130 | 1281130 | 2021-05-03 | Franklin | Florida | 12037 | 1316 | 17 |
1281131 | 1281131 | 2021-05-03 | Gadsden | Florida | 12039 | 5653 | 94 |
1281132 | 1281132 | 2021-05-03 | Gilchrist | Florida | 12041 | 1605 | 43 |
1281133 | 1281133 | 2021-05-03 | Glades | Florida | 12043 | 952 | 19 |
1281134 | 1281134 | 2021-05-03 | Gulf | Florida | 12045 | 1958 | 42 |
1281135 | 1281135 | 2021-05-03 | Hamilton | Florida | 12047 | 1625 | 25 |
1281136 | 1281136 | 2021-05-03 | Hardee | Florida | 12049 | 3123 | 43 |
1281137 | 1281137 | 2021-05-03 | Hendry | Florida | 12051 | 4709 | 82 |
1281138 | 1281138 | 2021-05-03 | Hernando | Florida | 12053 | 13844 | 459 |
1281139 | 1281139 | 2021-05-03 | Highlands | Florida | 12055 | 8482 | 351 |
1281140 | 1281140 | 2021-05-03 | Hillsborough | Florida | 12057 | 136217 | 1713 |
1281141 | 1281141 | 2021-05-03 | Holmes | Florida | 12059 | 2242 | 49 |
1281142 | 1281142 | 2021-05-03 | Indian River | Florida | 12061 | 12457 | 299 |
1281143 | 1281143 | 2021-05-03 | Jackson | Florida | 12063 | 6183 | 156 |
1281144 | 1281144 | 2021-05-03 | Jefferson | Florida | 12065 | 1490 | 27 |
1281145 | 1281145 | 2021-05-03 | Lafayette | Florida | 12067 | 1617 | 26 |
1281146 | 1281146 | 2021-05-03 | Lake | Florida | 12069 | 29468 | 633 |
1281147 | 1281147 | 2021-05-03 | Lee | Florida | 12071 | 69973 | 959 |
1281148 | 1281148 | 2021-05-03 | Leon | Florida | 12073 | 31707 | 317 |
1281149 | 1281149 | 2021-05-03 | Levy | Florida | 12075 | 3416 | 54 |
1281150 | 1281150 | 2021-05-03 | Liberty | Florida | 12077 | 1074 | 16 |
1281151 | 1281151 | 2021-05-03 | Madison | Florida | 12079 | 2053 | 45 |
1281152 | 1281152 | 2021-05-03 | Manatee | Florida | 12081 | 38355 | 668 |
1281153 | 1281153 | 2021-05-03 | Marion | Florida | 12083 | 30949 | 958 |
1281154 | 1281154 | 2021-05-03 | Martin | Florida | 12085 | 12236 | 320 |
1281155 | 1281155 | 2021-05-03 | Miami-Dade | Florida | 12086 | 486024 | 6186 |
1281156 | 1281156 | 2021-05-03 | Monroe | Florida | 12087 | 6931 | 49 |
1281157 | 1281157 | 2021-05-03 | Nassau | Florida | 12089 | 8341 | 124 |
1281158 | 1281158 | 2021-05-03 | Okaloosa | Florida | 12091 | 20478 | 361 |
1281159 | 1281159 | 2021-05-03 | Okeechobee | Florida | 12093 | 3988 | 88 |
1281160 | 1281160 | 2021-05-03 | Orange | Florida | 12095 | 137156 | 1251 |
1281161 | 1281161 | 2021-05-03 | Osceola | Florida | 12097 | 44381 | 502 |
1281162 | 1281162 | 2021-05-03 | Palm Beach | Florida | 12099 | 143902 | 2774 |
1281163 | 1281163 | 2021-05-03 | Pasco | Florida | 12101 | 40984 | 743 |
1281164 | 1281164 | 2021-05-03 | Pinellas | Florida | 12103 | 79146 | 1613 |
1281165 | 1281165 | 2021-05-03 | Polk | Florida | 12105 | 68114 | 1310 |
1281166 | 1281166 | 2021-05-03 | Putnam | Florida | 12107 | 6457 | 148 |
1281167 | 1281167 | 2021-05-03 | Santa Rosa | Florida | 12113 | 18168 | 285 |
1281168 | 1281168 | 2021-05-03 | Sarasota | Florida | 12115 | 32576 | 812 |
1281169 | 1281169 | 2021-05-03 | Seminole | Florida | 12117 | 33885 | 493 |
1281170 | 1281170 | 2021-05-03 | St. Johns | Florida | 12109 | 22493 | 209 |
1281171 | 1281171 | 2021-05-03 | St. Lucie | Florida | 12111 | 26197 | 626 |
1281172 | 1281172 | 2021-05-03 | Sumter | Florida | 12119 | 9294 | 275 |
1281173 | 1281173 | 2021-05-03 | Suwannee | Florida | 12121 | 5326 | 138 |
1281174 | 1281174 | 2021-05-03 | Taylor | Florida | 12123 | 2722 | 46 |
1281175 | 1281175 | 2021-05-03 | Union | Florida | 12125 | 1819 | 72 |
1281176 | 1281176 | 2021-05-03 | Unknown | Florida | 3336 | 0 | |
1281177 | 1281177 | 2021-05-03 | Volusia | Florida | 12127 | 42960 | 796 |
1281178 | 1281178 | 2021-05-03 | Wakulla | Florida | 12129 | 3423 | 55 |
1281179 | 1281179 | 2021-05-03 | Walton | Florida | 12131 | 7759 | 87 |
1281180 | 1281180 | 2021-05-03 | Washington | Florida | 12133 | 2725 | 51 |
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);