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-09-03 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 |
---|---|---|---|---|---|---|---|
495929 | 495929 | 2020-09-03 | Alachua | Florida | 12001 | 5345 | 33 |
495930 | 495930 | 2020-09-03 | Baker | Florida | 12003 | 1231 | 6 |
495931 | 495931 | 2020-09-03 | Bay | Florida | 12005 | 5455 | 84 |
495932 | 495932 | 2020-09-03 | Bradford | Florida | 12007 | 797 | 5 |
495933 | 495933 | 2020-09-03 | Brevard | Florida | 12009 | 7464 | 223 |
495934 | 495934 | 2020-09-03 | Broward | Florida | 12011 | 72634 | 1206 |
495935 | 495935 | 2020-09-03 | Calhoun | Florida | 12013 | 575 | 10 |
495936 | 495936 | 2020-09-03 | Charlotte | Florida | 12015 | 2744 | 114 |
495937 | 495937 | 2020-09-03 | Citrus | Florida | 12017 | 2166 | 61 |
495938 | 495938 | 2020-09-03 | Clay | Florida | 12019 | 4179 | 79 |
495939 | 495939 | 2020-09-03 | Collier | Florida | 12021 | 11853 | 180 |
495940 | 495940 | 2020-09-03 | Columbia | Florida | 12023 | 3387 | 38 |
495941 | 495941 | 2020-09-03 | DeSoto | Florida | 12027 | 1503 | 22 |
495942 | 495942 | 2020-09-03 | Dixie | Florida | 12029 | 749 | 4 |
495943 | 495943 | 2020-09-03 | Duval | Florida | 12031 | 27241 | 267 |
495944 | 495944 | 2020-09-03 | Escambia | Florida | 12033 | 11360 | 190 |
495945 | 495945 | 2020-09-03 | Flagler | Florida | 12035 | 1340 | 15 |
495946 | 495946 | 2020-09-03 | Franklin | Florida | 12037 | 560 | 3 |
495947 | 495947 | 2020-09-03 | Gadsden | Florida | 12039 | 2386 | 31 |
495948 | 495948 | 2020-09-03 | Gilchrist | Florida | 12041 | 472 | 10 |
495949 | 495949 | 2020-09-03 | Glades | Florida | 12043 | 458 | 4 |
495950 | 495950 | 2020-09-03 | Gulf | Florida | 12045 | 834 | 13 |
495951 | 495951 | 2020-09-03 | Hamilton | Florida | 12047 | 707 | 6 |
495952 | 495952 | 2020-09-03 | Hardee | Florida | 12049 | 1121 | 9 |
495953 | 495953 | 2020-09-03 | Hendry | Florida | 12051 | 1983 | 39 |
495954 | 495954 | 2020-09-03 | Hernando | Florida | 12053 | 2721 | 93 |
495955 | 495955 | 2020-09-03 | Highlands | Florida | 12055 | 1854 | 69 |
495956 | 495956 | 2020-09-03 | Hillsborough | Florida | 12057 | 37821 | 558 |
495957 | 495957 | 2020-09-03 | Holmes | Florida | 12059 | 662 | 5 |
495958 | 495958 | 2020-09-03 | Indian River | Florida | 12061 | 2871 | 103 |
495959 | 495959 | 2020-09-03 | Jackson | Florida | 12063 | 2428 | 66 |
495960 | 495960 | 2020-09-03 | Jefferson | Florida | 12065 | 506 | 6 |
495961 | 495961 | 2020-09-03 | Lafayette | Florida | 12067 | 1207 | 10 |
495962 | 495962 | 2020-09-03 | Lake | Florida | 12069 | 6622 | 126 |
495963 | 495963 | 2020-09-03 | Lee | Florida | 12071 | 18959 | 435 |
495964 | 495964 | 2020-09-03 | Leon | Florida | 12073 | 6874 | 38 |
495965 | 495965 | 2020-09-03 | Levy | Florida | 12075 | 927 | 6 |
495966 | 495966 | 2020-09-03 | Liberty | Florida | 12077 | 436 | 7 |
495967 | 495967 | 2020-09-03 | Madison | Florida | 12079 | 887 | 16 |
495968 | 495968 | 2020-09-03 | Manatee | Florida | 12081 | 10557 | 265 |
495969 | 495969 | 2020-09-03 | Marion | Florida | 12083 | 8675 | 200 |
495970 | 495970 | 2020-09-03 | Martin | Florida | 12085 | 4514 | 119 |
495971 | 495971 | 2020-09-03 | Miami-Dade | Florida | 12086 | 159977 | 2600 |
495972 | 495972 | 2020-09-03 | Monroe | Florida | 12087 | 1753 | 16 |
495973 | 495973 | 2020-09-03 | Nassau | Florida | 12089 | 1765 | 22 |
495974 | 495974 | 2020-09-03 | Okaloosa | Florida | 12091 | 4277 | 80 |
495975 | 495975 | 2020-09-03 | Okeechobee | Florida | 12093 | 1267 | 19 |
495976 | 495976 | 2020-09-03 | Orange | Florida | 12095 | 36667 | 385 |
495977 | 495977 | 2020-09-03 | Osceola | Florida | 12097 | 11342 | 132 |
495978 | 495978 | 2020-09-03 | Palm Beach | Florida | 12099 | 42641 | 1150 |
495979 | 495979 | 2020-09-03 | Pasco | Florida | 12101 | 8198 | 183 |
495980 | 495980 | 2020-09-03 | Pinellas | Florida | 12103 | 20177 | 669 |
495981 | 495981 | 2020-09-03 | Polk | Florida | 12105 | 17418 | 461 |
495982 | 495982 | 2020-09-03 | Putnam | Florida | 12107 | 1818 | 38 |
495983 | 495983 | 2020-09-03 | Santa Rosa | Florida | 12113 | 4812 | 58 |
495984 | 495984 | 2020-09-03 | Sarasota | Florida | 12115 | 7305 | 212 |
495985 | 495985 | 2020-09-03 | Seminole | Florida | 12117 | 8240 | 175 |
495986 | 495986 | 2020-09-03 | St. Johns | Florida | 12109 | 4485 | 60 |
495987 | 495987 | 2020-09-03 | St. Lucie | Florida | 12111 | 7193 | 243 |
495988 | 495988 | 2020-09-03 | Sumter | Florida | 12119 | 1957 | 55 |
495989 | 495989 | 2020-09-03 | Suwannee | Florida | 12121 | 2471 | 63 |
495990 | 495990 | 2020-09-03 | Taylor | Florida | 12123 | 1215 | 10 |
495991 | 495991 | 2020-09-03 | Union | Florida | 12125 | 636 | 5 |
495992 | 495992 | 2020-09-03 | Unknown | Florida | 1083 | 0 | |
495993 | 495993 | 2020-09-03 | Volusia | Florida | 12127 | 9589 | 196 |
495994 | 495994 | 2020-09-03 | Wakulla | Florida | 12129 | 937 | 7 |
495995 | 495995 | 2020-09-03 | Walton | Florida | 12131 | 1694 | 20 |
495996 | 495996 | 2020-09-03 | Washington | Florida | 12133 | 1023 | 16 |
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);