ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
68 rows where date = "2021-03-23" 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 |
---|---|---|---|---|---|---|---|
1147966 | 1147966 | 2021-03-23 | Alachua | Florida | 12001 | 23068 | 252 |
1147967 | 1147967 | 2021-03-23 | Baker | Florida | 12003 | 3340 | 59 |
1147968 | 1147968 | 2021-03-23 | Bay | Florida | 12005 | 19435 | 369 |
1147969 | 1147969 | 2021-03-23 | Bradford | Florida | 12007 | 2907 | 54 |
1147970 | 1147970 | 2021-03-23 | Brevard | Florida | 12009 | 36438 | 790 |
1147971 | 1147971 | 2021-03-23 | Broward | Florida | 12011 | 209170 | 2603 |
1147972 | 1147972 | 2021-03-23 | Calhoun | Florida | 12013 | 1647 | 42 |
1147973 | 1147973 | 2021-03-23 | Charlotte | Florida | 12015 | 11241 | 389 |
1147974 | 1147974 | 2021-03-23 | Citrus | Florida | 12017 | 10170 | 420 |
1147975 | 1147975 | 2021-03-23 | Clay | Florida | 12019 | 17192 | 325 |
1147976 | 1147976 | 2021-03-23 | Collier | Florida | 12021 | 31857 | 490 |
1147977 | 1147977 | 2021-03-23 | Columbia | Florida | 12023 | 7784 | 162 |
1147978 | 1147978 | 2021-03-23 | DeSoto | Florida | 12027 | 3997 | 80 |
1147979 | 1147979 | 2021-03-23 | Dixie | Florida | 12029 | 1542 | 23 |
1147980 | 1147980 | 2021-03-23 | Duval | Florida | 12031 | 91651 | 1283 |
1147981 | 1147981 | 2021-03-23 | Escambia | Florida | 12033 | 34590 | 658 |
1147982 | 1147982 | 2021-03-23 | Flagler | Florida | 12035 | 6466 | 93 |
1147983 | 1147983 | 2021-03-23 | Franklin | Florida | 12037 | 1293 | 16 |
1147984 | 1147984 | 2021-03-23 | Gadsden | Florida | 12039 | 5515 | 89 |
1147985 | 1147985 | 2021-03-23 | Gilchrist | Florida | 12041 | 1472 | 37 |
1147986 | 1147986 | 2021-03-23 | Glades | Florida | 12043 | 921 | 19 |
1147987 | 1147987 | 2021-03-23 | Gulf | Florida | 12045 | 1900 | 41 |
1147988 | 1147988 | 2021-03-23 | Hamilton | Florida | 12047 | 1581 | 23 |
1147989 | 1147989 | 2021-03-23 | Hardee | Florida | 12049 | 2876 | 37 |
1147990 | 1147990 | 2021-03-23 | Hendry | Florida | 12051 | 4435 | 77 |
1147991 | 1147991 | 2021-03-23 | Hernando | Florida | 12053 | 12111 | 434 |
1147992 | 1147992 | 2021-03-23 | Highlands | Florida | 12055 | 7531 | 313 |
1147993 | 1147993 | 2021-03-23 | Hillsborough | Florida | 12057 | 118558 | 1582 |
1147994 | 1147994 | 2021-03-23 | Holmes | Florida | 12059 | 2207 | 46 |
1147995 | 1147995 | 2021-03-23 | Indian River | Florida | 12061 | 11543 | 278 |
1147996 | 1147996 | 2021-03-23 | Jackson | Florida | 12063 | 6031 | 154 |
1147997 | 1147997 | 2021-03-23 | Jefferson | Florida | 12065 | 1418 | 24 |
1147998 | 1147998 | 2021-03-23 | Lafayette | Florida | 12067 | 1604 | 25 |
1147999 | 1147999 | 2021-03-23 | Lake | Florida | 12069 | 26092 | 592 |
1148000 | 1148000 | 2021-03-23 | Lee | Florida | 12071 | 61201 | 907 |
1148001 | 1148001 | 2021-03-23 | Leon | Florida | 12073 | 30040 | 301 |
1148002 | 1148002 | 2021-03-23 | Levy | Florida | 12075 | 3042 | 43 |
1148003 | 1148003 | 2021-03-23 | Liberty | Florida | 12077 | 1051 | 16 |
1148004 | 1148004 | 2021-03-23 | Madison | Florida | 12079 | 2029 | 43 |
1148005 | 1148005 | 2021-03-23 | Manatee | Florida | 12081 | 34036 | 629 |
1148006 | 1148006 | 2021-03-23 | Marion | Florida | 12083 | 28677 | 911 |
1148007 | 1148007 | 2021-03-23 | Martin | Florida | 12085 | 11163 | 299 |
1148008 | 1148008 | 2021-03-23 | Miami-Dade | Florida | 12086 | 436393 | 5742 |
1148009 | 1148009 | 2021-03-23 | Monroe | Florida | 12087 | 6264 | 48 |
1148010 | 1148010 | 2021-03-23 | Nassau | Florida | 12089 | 7927 | 118 |
1148011 | 1148011 | 2021-03-23 | Okaloosa | Florida | 12091 | 19622 | 344 |
1148012 | 1148012 | 2021-03-23 | Okeechobee | Florida | 12093 | 3677 | 85 |
1148013 | 1148013 | 2021-03-23 | Orange | Florida | 12095 | 120794 | 1169 |
1148014 | 1148014 | 2021-03-23 | Osceola | Florida | 12097 | 38843 | 473 |
1148015 | 1148015 | 2021-03-23 | Palm Beach | Florida | 12099 | 128618 | 2602 |
1148016 | 1148016 | 2021-03-23 | Pasco | Florida | 12101 | 35492 | 680 |
1148017 | 1148017 | 2021-03-23 | Pinellas | Florida | 12103 | 70580 | 1529 |
1148018 | 1148018 | 2021-03-23 | Polk | Florida | 12105 | 59991 | 1221 |
1148019 | 1148019 | 2021-03-23 | Putnam | Florida | 12107 | 5974 | 133 |
1148020 | 1148020 | 2021-03-23 | Santa Rosa | Florida | 12113 | 17616 | 276 |
1148021 | 1148021 | 2021-03-23 | Sarasota | Florida | 12115 | 28592 | 776 |
1148022 | 1148022 | 2021-03-23 | Seminole | Florida | 12117 | 29165 | 449 |
1148023 | 1148023 | 2021-03-23 | St. Johns | Florida | 12109 | 20829 | 201 |
1148024 | 1148024 | 2021-03-23 | St. Lucie | Florida | 12111 | 23528 | 571 |
1148025 | 1148025 | 2021-03-23 | Sumter | Florida | 12119 | 8562 | 243 |
1148026 | 1148026 | 2021-03-23 | Suwannee | Florida | 12121 | 5202 | 135 |
1148027 | 1148027 | 2021-03-23 | Taylor | Florida | 12123 | 2692 | 45 |
1148028 | 1148028 | 2021-03-23 | Union | Florida | 12125 | 1770 | 71 |
1148029 | 1148029 | 2021-03-23 | Unknown | Florida | 3518 | 0 | |
1148030 | 1148030 | 2021-03-23 | Volusia | Florida | 12127 | 36887 | 698 |
1148031 | 1148031 | 2021-03-23 | Wakulla | Florida | 12129 | 3228 | 53 |
1148032 | 1148032 | 2021-03-23 | Walton | Florida | 12131 | 7262 | 81 |
1148033 | 1148033 | 2021-03-23 | Washington | Florida | 12133 | 2657 | 48 |
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);