ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
68 rows where date = "2020-05-29" 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 |
---|---|---|---|---|---|---|---|
187957 | 187957 | 2020-05-29 | Alachua | Florida | 12001 | 378 | 7 |
187958 | 187958 | 2020-05-29 | Baker | Florida | 12003 | 28 | 3 |
187959 | 187959 | 2020-05-29 | Bay | Florida | 12005 | 98 | 3 |
187960 | 187960 | 2020-05-29 | Bradford | Florida | 12007 | 51 | 2 |
187961 | 187961 | 2020-05-29 | Brevard | Florida | 12009 | 409 | 12 |
187962 | 187962 | 2020-05-29 | Broward | Florida | 12011 | 6975 | 308 |
187963 | 187963 | 2020-05-29 | Calhoun | Florida | 12013 | 53 | 4 |
187964 | 187964 | 2020-05-29 | Charlotte | Florida | 12015 | 446 | 62 |
187965 | 187965 | 2020-05-29 | Citrus | Florida | 12017 | 120 | 12 |
187966 | 187966 | 2020-05-29 | Clay | Florida | 12019 | 374 | 28 |
187967 | 187967 | 2020-05-29 | Collier | Florida | 12021 | 1454 | 49 |
187968 | 187968 | 2020-05-29 | Columbia | Florida | 12023 | 140 | 2 |
187969 | 187969 | 2020-05-29 | DeSoto | Florida | 12027 | 171 | 8 |
187970 | 187970 | 2020-05-29 | Dixie | Florida | 12029 | 49 | 2 |
187971 | 187971 | 2020-05-29 | Duval | Florida | 12031 | 1561 | 47 |
187972 | 187972 | 2020-05-29 | Escambia | Florida | 12033 | 791 | 33 |
187973 | 187973 | 2020-05-29 | Flagler | Florida | 12035 | 182 | 4 |
187974 | 187974 | 2020-05-29 | Franklin | Florida | 12037 | 2 | 0 |
187975 | 187975 | 2020-05-29 | Gadsden | Florida | 12039 | 268 | 2 |
187976 | 187976 | 2020-05-29 | Gilchrist | Florida | 12041 | 12 | 0 |
187977 | 187977 | 2020-05-29 | Glades | Florida | 12043 | 27 | 1 |
187978 | 187978 | 2020-05-29 | Gulf | Florida | 12045 | 1 | 0 |
187979 | 187979 | 2020-05-29 | Hamilton | Florida | 12047 | 221 | 0 |
187980 | 187980 | 2020-05-29 | Hardee | Florida | 12049 | 91 | 0 |
187981 | 187981 | 2020-05-29 | Hendry | Florida | 12051 | 387 | 14 |
187982 | 187982 | 2020-05-29 | Hernando | Florida | 12053 | 113 | 5 |
187983 | 187983 | 2020-05-29 | Highlands | Florida | 12055 | 120 | 9 |
187984 | 187984 | 2020-05-29 | Hillsborough | Florida | 12057 | 2069 | 79 |
187985 | 187985 | 2020-05-29 | Holmes | Florida | 12059 | 19 | 0 |
187986 | 187986 | 2020-05-29 | Indian River | Florida | 12061 | 122 | 9 |
187987 | 187987 | 2020-05-29 | Jackson | Florida | 12063 | 248 | 1 |
187988 | 187988 | 2020-05-29 | Jefferson | Florida | 12065 | 29 | 3 |
187989 | 187989 | 2020-05-29 | Lafayette | Florida | 12067 | 8 | 0 |
187990 | 187990 | 2020-05-29 | Lake | Florida | 12069 | 291 | 15 |
187991 | 187991 | 2020-05-29 | Lee | Florida | 12071 | 1846 | 101 |
187992 | 187992 | 2020-05-29 | Leon | Florida | 12073 | 400 | 6 |
187993 | 187993 | 2020-05-29 | Levy | Florida | 12075 | 31 | 0 |
187994 | 187994 | 2020-05-29 | Liberty | Florida | 12077 | 213 | 0 |
187995 | 187995 | 2020-05-29 | Madison | Florida | 12079 | 69 | 4 |
187996 | 187996 | 2020-05-29 | Manatee | Florida | 12081 | 1022 | 96 |
187997 | 187997 | 2020-05-29 | Marion | Florida | 12083 | 243 | 6 |
187998 | 187998 | 2020-05-29 | Martin | Florida | 12085 | 601 | 9 |
187999 | 187999 | 2020-05-29 | Miami-Dade | Florida | 12086 | 17640 | 685 |
188000 | 188000 | 2020-05-29 | Monroe | Florida | 12087 | 108 | 4 |
188001 | 188001 | 2020-05-29 | Nassau | Florida | 12089 | 74 | 1 |
188002 | 188002 | 2020-05-29 | Okaloosa | Florida | 12091 | 206 | 6 |
188003 | 188003 | 2020-05-29 | Okeechobee | Florida | 12093 | 70 | 0 |
188004 | 188004 | 2020-05-29 | Orange | Florida | 12095 | 1944 | 40 |
188005 | 188005 | 2020-05-29 | Osceola | Florida | 12097 | 688 | 19 |
188006 | 188006 | 2020-05-29 | Palm Beach | Florida | 12099 | 5763 | 335 |
188007 | 188007 | 2020-05-29 | Pasco | Florida | 12101 | 377 | 13 |
188008 | 188008 | 2020-05-29 | Pinellas | Florida | 12103 | 1238 | 82 |
188009 | 188009 | 2020-05-29 | Polk | Florida | 12105 | 977 | 55 |
188010 | 188010 | 2020-05-29 | Putnam | Florida | 12107 | 149 | 5 |
188011 | 188011 | 2020-05-29 | Santa Rosa | Florida | 12113 | 240 | 9 |
188012 | 188012 | 2020-05-29 | Sarasota | Florida | 12115 | 622 | 77 |
188013 | 188013 | 2020-05-29 | Seminole | Florida | 12117 | 481 | 12 |
188014 | 188014 | 2020-05-29 | St. Johns | Florida | 12109 | 252 | 6 |
188015 | 188015 | 2020-05-29 | St. Lucie | Florida | 12111 | 449 | 30 |
188016 | 188016 | 2020-05-29 | Sumter | Florida | 12119 | 253 | 17 |
188017 | 188017 | 2020-05-29 | Suwannee | Florida | 12121 | 166 | 18 |
188018 | 188018 | 2020-05-29 | Taylor | Florida | 12123 | 19 | 0 |
188019 | 188019 | 2020-05-29 | Union | Florida | 12125 | 31 | 1 |
188020 | 188020 | 2020-05-29 | Unknown | Florida | 83 | 0 | |
188021 | 188021 | 2020-05-29 | Volusia | Florida | 12127 | 725 | 37 |
188022 | 188022 | 2020-05-29 | Wakulla | Florida | 12129 | 33 | 1 |
188023 | 188023 | 2020-05-29 | Walton | Florida | 12131 | 114 | 9 |
188024 | 188024 | 2020-05-29 | Washington | Florida | 12133 | 54 | 4 |
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);