ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
53,362 rows where state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 12057 229
- 12081 229
- 12113 225
- 12011 224
- 12071 224
- 12015 223
- 12091 223
- 12127 223
- 12001 220
- 12021 220
- 12089 220
- 12101 220
- 12103 220
- 12086 219
- 12109 219
- 12019 218
- 12031 218
- 12099 218
- 12115 218
- 12117 218
- 12095 217
- 12097 217
- 12003 215
- 12017 215
- 12033 214
- 12069 214
- 12009 213
- 12105 213
- 12073 212
- 12119 212
- …
county >30
- Hillsborough 229
- Manatee 229
- Santa Rosa 225
- Broward 224
- Lee 224
- Charlotte 223
- Okaloosa 223
- Volusia 223
- Alachua 220
- Collier 220
- Nassau 220
- Pasco 220
- Pinellas 220
- Miami-Dade 219
- St. Johns 219
- Clay 218
- Duval 218
- Palm Beach 218
- Sarasota 218
- Seminole 218
- Orange 217
- Osceola 217
- Baker 215
- Citrus 215
- Escambia 214
- Lake 214
- Brevard 213
- Polk 213
- Leon 212
- Sumter 212
- …
state 1
- Florida · 14,262 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
631961 | 631961 | 2020-10-15 | Alachua | Florida | 12001 | 9190 | 70 |
631962 | 631962 | 2020-10-15 | Baker | Florida | 12003 | 1655 | 17 |
631963 | 631963 | 2020-10-15 | Bay | Florida | 12005 | 6394 | 125 |
631964 | 631964 | 2020-10-15 | Bradford | Florida | 12007 | 1194 | 11 |
631965 | 631965 | 2020-10-15 | Brevard | Florida | 12009 | 10183 | 337 |
631966 | 631966 | 2020-10-15 | Broward | Florida | 12011 | 80112 | 1492 |
631967 | 631967 | 2020-10-15 | Calhoun | Florida | 12013 | 658 | 14 |
631968 | 631968 | 2020-10-15 | Charlotte | Florida | 12015 | 3316 | 151 |
631969 | 631969 | 2020-10-15 | Citrus | Florida | 12017 | 2988 | 124 |
631970 | 631970 | 2020-10-15 | Clay | Florida | 12019 | 5596 | 113 |
631971 | 631971 | 2020-10-15 | Collier | Florida | 12021 | 13432 | 242 |
631972 | 631972 | 2020-10-15 | Columbia | Florida | 12023 | 4051 | 70 |
631973 | 631973 | 2020-10-15 | DeSoto | Florida | 12027 | 1609 | 27 |
631974 | 631974 | 2020-10-15 | Dixie | Florida | 12029 | 862 | 11 |
631975 | 631975 | 2020-10-15 | Duval | Florida | 12031 | 32489 | 500 |
631976 | 631976 | 2020-10-15 | Escambia | Florida | 12033 | 12837 | 267 |
631977 | 631977 | 2020-10-15 | Flagler | Florida | 12035 | 1904 | 33 |
631978 | 631978 | 2020-10-15 | Franklin | Florida | 12037 | 686 | 4 |
631979 | 631979 | 2020-10-15 | Gadsden | Florida | 12039 | 3004 | 51 |
631980 | 631980 | 2020-10-15 | Gilchrist | Florida | 12041 | 538 | 17 |
631981 | 631981 | 2020-10-15 | Glades | Florida | 12043 | 584 | 6 |
631982 | 631982 | 2020-10-15 | Gulf | Florida | 12045 | 917 | 15 |
631983 | 631983 | 2020-10-15 | Hamilton | Florida | 12047 | 888 | 9 |
631984 | 631984 | 2020-10-15 | Hardee | Florida | 12049 | 1504 | 11 |
631985 | 631985 | 2020-10-15 | Hendry | Florida | 12051 | 2137 | 43 |
631986 | 631986 | 2020-10-15 | Hernando | Florida | 12053 | 3359 | 151 |
631987 | 631987 | 2020-10-15 | Highlands | Florida | 12055 | 2406 | 100 |
631988 | 631988 | 2020-10-15 | Hillsborough | Florida | 12057 | 44811 | 734 |
631989 | 631989 | 2020-10-15 | Holmes | Florida | 12059 | 812 | 10 |
631990 | 631990 | 2020-10-15 | Indian River | Florida | 12061 | 3476 | 121 |
631991 | 631991 | 2020-10-15 | Jackson | Florida | 12063 | 3000 | 83 |
631992 | 631992 | 2020-10-15 | Jefferson | Florida | 12065 | 608 | 9 |
631993 | 631993 | 2020-10-15 | Lafayette | Florida | 12067 | 1254 | 16 |
631994 | 631994 | 2020-10-15 | Lake | Florida | 12069 | 8047 | 211 |
631995 | 631995 | 2020-10-15 | Lee | Florida | 12071 | 21612 | 489 |
631996 | 631996 | 2020-10-15 | Leon | Florida | 12073 | 11482 | 96 |
631997 | 631997 | 2020-10-15 | Levy | Florida | 12075 | 1092 | 10 |
631998 | 631998 | 2020-10-15 | Liberty | Florida | 12077 | 520 | 10 |
631999 | 631999 | 2020-10-15 | Madison | Florida | 12079 | 1049 | 24 |
632000 | 632000 | 2020-10-15 | Manatee | Florida | 12081 | 12304 | 316 |
632001 | 632001 | 2020-10-15 | Marion | Florida | 12083 | 10301 | 334 |
632002 | 632002 | 2020-10-15 | Martin | Florida | 12085 | 5115 | 153 |
632003 | 632003 | 2020-10-15 | Miami-Dade | Florida | 12086 | 176808 | 3501 |
632004 | 632004 | 2020-10-15 | Monroe | Florida | 12087 | 2002 | 24 |
632005 | 632005 | 2020-10-15 | Nassau | Florida | 12089 | 2309 | 50 |
632006 | 632006 | 2020-10-15 | Okaloosa | Florida | 12091 | 5644 | 127 |
632007 | 632007 | 2020-10-15 | Okeechobee | Florida | 12093 | 1658 | 37 |
632008 | 632008 | 2020-10-15 | Orange | Florida | 12095 | 42777 | 527 |
632009 | 632009 | 2020-10-15 | Osceola | Florida | 12097 | 13313 | 178 |
632010 | 632010 | 2020-10-15 | Palm Beach | Florida | 12099 | 48494 | 1472 |
632011 | 632011 | 2020-10-15 | Pasco | Florida | 12101 | 10054 | 221 |
632012 | 632012 | 2020-10-15 | Pinellas | Florida | 12103 | 23623 | 792 |
632013 | 632013 | 2020-10-15 | Polk | Florida | 12105 | 21456 | 569 |
632014 | 632014 | 2020-10-15 | Putnam | Florida | 12107 | 2240 | 46 |
632015 | 632015 | 2020-10-15 | Santa Rosa | Florida | 12113 | 5639 | 84 |
632016 | 632016 | 2020-10-15 | Sarasota | Florida | 12115 | 8841 | 301 |
632017 | 632017 | 2020-10-15 | Seminole | Florida | 12117 | 9561 | 233 |
632018 | 632018 | 2020-10-15 | St. Johns | Florida | 12109 | 5862 | 78 |
632019 | 632019 | 2020-10-15 | St. Lucie | Florida | 12111 | 8486 | 311 |
632020 | 632020 | 2020-10-15 | Sumter | Florida | 12119 | 2716 | 78 |
632021 | 632021 | 2020-10-15 | Suwannee | Florida | 12121 | 2871 | 76 |
632022 | 632022 | 2020-10-15 | Taylor | Florida | 12123 | 1408 | 14 |
632023 | 632023 | 2020-10-15 | Union | Florida | 12125 | 1058 | 26 |
632024 | 632024 | 2020-10-15 | Unknown | Florida | 1927 | 0 | |
632025 | 632025 | 2020-10-15 | Volusia | Florida | 12127 | 11739 | 299 |
632026 | 632026 | 2020-10-15 | Wakulla | Florida | 12129 | 1219 | 11 |
632027 | 632027 | 2020-10-15 | Walton | Florida | 12131 | 2165 | 29 |
632028 | 632028 | 2020-10-15 | Washington | Florida | 12133 | 1134 | 24 |
628717 | 628717 | 2020-10-14 | Alachua | Florida | 12001 | 9133 | 70 |
628718 | 628718 | 2020-10-14 | Baker | Florida | 12003 | 1642 | 16 |
628719 | 628719 | 2020-10-14 | Bay | Florida | 12005 | 6366 | 122 |
628720 | 628720 | 2020-10-14 | Bradford | Florida | 12007 | 1187 | 11 |
628721 | 628721 | 2020-10-14 | Brevard | Florida | 12009 | 10110 | 331 |
628722 | 628722 | 2020-10-14 | Broward | Florida | 12011 | 79876 | 1484 |
628723 | 628723 | 2020-10-14 | Calhoun | Florida | 12013 | 653 | 14 |
628724 | 628724 | 2020-10-14 | Charlotte | Florida | 12015 | 3287 | 150 |
628725 | 628725 | 2020-10-14 | Citrus | Florida | 12017 | 2983 | 124 |
628726 | 628726 | 2020-10-14 | Clay | Florida | 12019 | 5556 | 111 |
628727 | 628727 | 2020-10-14 | Collier | Florida | 12021 | 13382 | 239 |
628728 | 628728 | 2020-10-14 | Columbia | Florida | 12023 | 4034 | 68 |
628729 | 628729 | 2020-10-14 | DeSoto | Florida | 12027 | 1609 | 27 |
628730 | 628730 | 2020-10-14 | Dixie | Florida | 12029 | 860 | 11 |
628731 | 628731 | 2020-10-14 | Duval | Florida | 12031 | 32311 | 494 |
628732 | 628732 | 2020-10-14 | Escambia | Florida | 12033 | 12737 | 264 |
628733 | 628733 | 2020-10-14 | Flagler | Florida | 12035 | 1892 | 33 |
628734 | 628734 | 2020-10-14 | Franklin | Florida | 12037 | 676 | 4 |
628735 | 628735 | 2020-10-14 | Gadsden | Florida | 12039 | 2991 | 51 |
628736 | 628736 | 2020-10-14 | Gilchrist | Florida | 12041 | 531 | 17 |
628737 | 628737 | 2020-10-14 | Glades | Florida | 12043 | 581 | 6 |
628738 | 628738 | 2020-10-14 | Gulf | Florida | 12045 | 911 | 15 |
628739 | 628739 | 2020-10-14 | Hamilton | Florida | 12047 | 889 | 9 |
628740 | 628740 | 2020-10-14 | Hardee | Florida | 12049 | 1479 | 11 |
628741 | 628741 | 2020-10-14 | Hendry | Florida | 12051 | 2128 | 43 |
628742 | 628742 | 2020-10-14 | Hernando | Florida | 12053 | 3324 | 149 |
628743 | 628743 | 2020-10-14 | Highlands | Florida | 12055 | 2398 | 100 |
628744 | 628744 | 2020-10-14 | Hillsborough | Florida | 12057 | 44652 | 720 |
628745 | 628745 | 2020-10-14 | Holmes | Florida | 12059 | 803 | 10 |
628746 | 628746 | 2020-10-14 | Indian River | Florida | 12061 | 3458 | 119 |
628747 | 628747 | 2020-10-14 | Jackson | Florida | 12063 | 2986 | 83 |
628748 | 628748 | 2020-10-14 | Jefferson | Florida | 12065 | 603 | 9 |
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);