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 2020-04-10 and state = "Florida" sorted by rowid
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 |
---|---|---|---|---|---|---|---|
46085 | 46085 | 2020-04-10 | Alachua | Florida | 12001 | 167 | 0 |
46086 | 46086 | 2020-04-10 | Baker | Florida | 12003 | 16 | 2 |
46087 | 46087 | 2020-04-10 | Bay | Florida | 12005 | 36 | 1 |
46088 | 46088 | 2020-04-10 | Bradford | Florida | 12007 | 22 | 0 |
46089 | 46089 | 2020-04-10 | Brevard | Florida | 12009 | 121 | 2 |
46090 | 46090 | 2020-04-10 | Broward | Florida | 12011 | 2679 | 72 |
46091 | 46091 | 2020-04-10 | Calhoun | Florida | 12013 | 5 | 0 |
46092 | 46092 | 2020-04-10 | Charlotte | Florida | 12015 | 104 | 5 |
46093 | 46093 | 2020-04-10 | Citrus | Florida | 12017 | 64 | 6 |
46094 | 46094 | 2020-04-10 | Clay | Florida | 12019 | 144 | 8 |
46095 | 46095 | 2020-04-10 | Collier | Florida | 12021 | 327 | 3 |
46096 | 46096 | 2020-04-10 | Columbia | Florida | 12023 | 23 | 0 |
46097 | 46097 | 2020-04-10 | DeSoto | Florida | 12027 | 20 | 3 |
46098 | 46098 | 2020-04-10 | Dixie | Florida | 12029 | 1 | 0 |
46099 | 46099 | 2020-04-10 | Duval | Florida | 12031 | 618 | 11 |
46100 | 46100 | 2020-04-10 | Escambia | Florida | 12033 | 204 | 3 |
46101 | 46101 | 2020-04-10 | Flagler | Florida | 12035 | 44 | 1 |
46102 | 46102 | 2020-04-10 | Franklin | Florida | 12037 | 2 | 0 |
46103 | 46103 | 2020-04-10 | Gadsden | Florida | 12039 | 13 | 0 |
46104 | 46104 | 2020-04-10 | Gilchrist | Florida | 12041 | 4 | 0 |
46105 | 46105 | 2020-04-10 | Glades | Florida | 12043 | 4 | 1 |
46106 | 46106 | 2020-04-10 | Gulf | Florida | 12045 | 1 | 0 |
46107 | 46107 | 2020-04-10 | Hamilton | Florida | 12047 | 2 | 0 |
46108 | 46108 | 2020-04-10 | Hardee | Florida | 12049 | 3 | 0 |
46109 | 46109 | 2020-04-10 | Hendry | Florida | 12051 | 15 | 0 |
46110 | 46110 | 2020-04-10 | Hernando | Florida | 12053 | 64 | 2 |
46111 | 46111 | 2020-04-10 | Highlands | Florida | 12055 | 47 | 4 |
46112 | 46112 | 2020-04-10 | Hillsborough | Florida | 12057 | 676 | 12 |
46113 | 46113 | 2020-04-10 | Holmes | Florida | 12059 | 2 | 0 |
46114 | 46114 | 2020-04-10 | Indian River | Florida | 12061 | 70 | 1 |
46115 | 46115 | 2020-04-10 | Jackson | Florida | 12063 | 5 | 0 |
46116 | 46116 | 2020-04-10 | Jefferson | Florida | 12065 | 9 | 0 |
46117 | 46117 | 2020-04-10 | Lafayette | Florida | 12067 | 1 | 0 |
46118 | 46118 | 2020-04-10 | Lake | Florida | 12069 | 149 | 3 |
46119 | 46119 | 2020-04-10 | Lee | Florida | 12071 | 571 | 16 |
46120 | 46120 | 2020-04-10 | Leon | Florida | 12073 | 90 | 0 |
46121 | 46121 | 2020-04-10 | Levy | Florida | 12075 | 6 | 0 |
46122 | 46122 | 2020-04-10 | Liberty | Florida | 12077 | 1 | 0 |
46123 | 46123 | 2020-04-10 | Madison | Florida | 12079 | 14 | 0 |
46124 | 46124 | 2020-04-10 | Manatee | Florida | 12081 | 200 | 13 |
46125 | 46125 | 2020-04-10 | Marion | Florida | 12083 | 83 | 2 |
46126 | 46126 | 2020-04-10 | Martin | Florida | 12085 | 115 | 3 |
46127 | 46127 | 2020-04-10 | Miami-Dade | Florida | 12086 | 6299 | 84 |
46128 | 46128 | 2020-04-10 | Monroe | Florida | 12087 | 55 | 3 |
46129 | 46129 | 2020-04-10 | Nassau | Florida | 12089 | 33 | 0 |
46130 | 46130 | 2020-04-10 | Okaloosa | Florida | 12091 | 84 | 1 |
46131 | 46131 | 2020-04-10 | Okeechobee | Florida | 12093 | 5 | 0 |
46132 | 46132 | 2020-04-10 | Orange | Florida | 12095 | 901 | 11 |
46133 | 46133 | 2020-04-10 | Osceola | Florida | 12097 | 305 | 5 |
46134 | 46134 | 2020-04-10 | Palm Beach | Florida | 12099 | 1429 | 79 |
46135 | 46135 | 2020-04-10 | Pasco | Florida | 12101 | 143 | 2 |
46136 | 46136 | 2020-04-10 | Pinellas | Florida | 12103 | 431 | 12 |
46137 | 46137 | 2020-04-10 | Polk | Florida | 12105 | 241 | 8 |
46138 | 46138 | 2020-04-10 | Putnam | Florida | 12107 | 29 | 1 |
46139 | 46139 | 2020-04-10 | Santa Rosa | Florida | 12113 | 105 | 3 |
46140 | 46140 | 2020-04-10 | Sarasota | Florida | 12115 | 211 | 10 |
46141 | 46141 | 2020-04-10 | Seminole | Florida | 12117 | 238 | 2 |
46142 | 46142 | 2020-04-10 | St. Johns | Florida | 12109 | 165 | 2 |
46143 | 46143 | 2020-04-10 | St. Lucie | Florida | 12111 | 146 | 6 |
46144 | 46144 | 2020-04-10 | Sumter | Florida | 12119 | 107 | 9 |
46145 | 46145 | 2020-04-10 | Suwannee | Florida | 12121 | 59 | 0 |
46146 | 46146 | 2020-04-10 | Taylor | Florida | 12123 | 1 | 0 |
46147 | 46147 | 2020-04-10 | Union | Florida | 12125 | 2 | 0 |
46148 | 46148 | 2020-04-10 | Unknown | Florida | 2 | 0 | |
46149 | 46149 | 2020-04-10 | Volusia | Florida | 12127 | 190 | 6 |
46150 | 46150 | 2020-04-10 | Wakulla | Florida | 12129 | 7 | 0 |
46151 | 46151 | 2020-04-10 | Walton | Florida | 12131 | 27 | 0 |
46152 | 46152 | 2020-04-10 | Washington | Florida | 12133 | 3 | 0 |
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);