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 2021-01-17 and state = "Florida" sorted by date descending
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 |
---|---|---|---|---|---|---|---|
936986 | 936986 | 2021-01-17 | Alachua | Florida | 12001 | 18777 | 146 |
936987 | 936987 | 2021-01-17 | Baker | Florida | 12003 | 2826 | 41 |
936988 | 936988 | 2021-01-17 | Bay | Florida | 12005 | 14036 | 255 |
936989 | 936989 | 2021-01-17 | Bradford | Florida | 12007 | 2498 | 26 |
936990 | 936990 | 2021-01-17 | Brevard | Florida | 12009 | 26081 | 582 |
936991 | 936991 | 2021-01-17 | Broward | Florida | 12011 | 158762 | 1969 |
936992 | 936992 | 2021-01-17 | Calhoun | Florida | 12013 | 1439 | 32 |
936993 | 936993 | 2021-01-17 | Charlotte | Florida | 12015 | 8965 | 263 |
936994 | 936994 | 2021-01-17 | Citrus | Florida | 12017 | 7905 | 308 |
936995 | 936995 | 2021-01-17 | Clay | Florida | 12019 | 14000 | 221 |
936996 | 936996 | 2021-01-17 | Collier | Florida | 12021 | 25782 | 376 |
936997 | 936997 | 2021-01-17 | Columbia | Florida | 12023 | 6834 | 131 |
936998 | 936998 | 2021-01-17 | DeSoto | Florida | 12027 | 3210 | 67 |
936999 | 936999 | 2021-01-17 | Dixie | Florida | 12029 | 1316 | 12 |
937000 | 937000 | 2021-01-17 | Duval | Florida | 12031 | 74910 | 806 |
937001 | 937001 | 2021-01-17 | Escambia | Florida | 12033 | 27455 | 448 |
937002 | 937002 | 2021-01-17 | Flagler | Florida | 12035 | 4710 | 53 |
937003 | 937003 | 2021-01-17 | Franklin | Florida | 12037 | 1120 | 4 |
937004 | 937004 | 2021-01-17 | Gadsden | Florida | 12039 | 4772 | 64 |
937005 | 937005 | 2021-01-17 | Gilchrist | Florida | 12041 | 1130 | 28 |
937006 | 937006 | 2021-01-17 | Glades | Florida | 12043 | 837 | 12 |
937007 | 937007 | 2021-01-17 | Gulf | Florida | 12045 | 1549 | 31 |
937008 | 937008 | 2021-01-17 | Hamilton | Florida | 12047 | 1416 | 15 |
937009 | 937009 | 2021-01-17 | Hardee | Florida | 12049 | 2403 | 22 |
937010 | 937010 | 2021-01-17 | Hendry | Florida | 12051 | 3813 | 53 |
937011 | 937011 | 2021-01-17 | Hernando | Florida | 12053 | 8963 | 312 |
937012 | 937012 | 2021-01-17 | Highlands | Florida | 12055 | 5864 | 232 |
937013 | 937013 | 2021-01-17 | Hillsborough | Florida | 12057 | 92438 | 1175 |
937014 | 937014 | 2021-01-17 | Holmes | Florida | 12059 | 1967 | 32 |
937015 | 937015 | 2021-01-17 | Indian River | Florida | 12061 | 8768 | 194 |
937016 | 937016 | 2021-01-17 | Jackson | Florida | 12063 | 5328 | 122 |
937017 | 937017 | 2021-01-17 | Jefferson | Florida | 12065 | 1191 | 18 |
937018 | 937018 | 2021-01-17 | Lafayette | Florida | 12067 | 1495 | 23 |
937019 | 937019 | 2021-01-17 | Lake | Florida | 12069 | 19387 | 377 |
937020 | 937020 | 2021-01-17 | Lee | Florida | 12071 | 48144 | 728 |
937021 | 937021 | 2021-01-17 | Leon | Florida | 12073 | 23628 | 202 |
937022 | 937022 | 2021-01-17 | Levy | Florida | 12075 | 2329 | 22 |
937023 | 937023 | 2021-01-17 | Liberty | Florida | 12077 | 931 | 14 |
937024 | 937024 | 2021-01-17 | Madison | Florida | 12079 | 1708 | 34 |
937025 | 937025 | 2021-01-17 | Manatee | Florida | 12081 | 26102 | 457 |
937026 | 937026 | 2021-01-17 | Marion | Florida | 12083 | 22141 | 541 |
937027 | 937027 | 2021-01-17 | Martin | Florida | 12085 | 9006 | 228 |
937028 | 937028 | 2021-01-17 | Miami-Dade | Florida | 12086 | 344245 | 4595 |
937029 | 937029 | 2021-01-17 | Monroe | Florida | 12087 | 4941 | 37 |
937030 | 937030 | 2021-01-17 | Nassau | Florida | 12089 | 6243 | 73 |
937031 | 937031 | 2021-01-17 | Okaloosa | Florida | 12091 | 15165 | 263 |
937032 | 937032 | 2021-01-17 | Okeechobee | Florida | 12093 | 2990 | 56 |
937033 | 937033 | 2021-01-17 | Orange | Florida | 12095 | 93179 | 845 |
937034 | 937034 | 2021-01-17 | Osceola | Florida | 12097 | 30579 | 330 |
937035 | 937035 | 2021-01-17 | Palm Beach | Florida | 12099 | 97540 | 2036 |
937036 | 937036 | 2021-01-17 | Pasco | Florida | 12101 | 26798 | 453 |
937037 | 937037 | 2021-01-17 | Pinellas | Florida | 12103 | 54212 | 1175 |
937038 | 937038 | 2021-01-17 | Polk | Florida | 12105 | 45550 | 891 |
937039 | 937039 | 2021-01-17 | Putnam | Florida | 12107 | 5033 | 89 |
937040 | 937040 | 2021-01-17 | Santa Rosa | Florida | 12113 | 13803 | 177 |
937041 | 937041 | 2021-01-17 | Sarasota | Florida | 12115 | 22609 | 563 |
937042 | 937042 | 2021-01-17 | Seminole | Florida | 12117 | 21923 | 335 |
937043 | 937043 | 2021-01-17 | St. Johns | Florida | 12109 | 16555 | 138 |
937044 | 937044 | 2021-01-17 | St. Lucie | Florida | 12111 | 17617 | 454 |
937045 | 937045 | 2021-01-17 | Sumter | Florida | 12119 | 6422 | 157 |
937046 | 937046 | 2021-01-17 | Suwannee | Florida | 12121 | 4593 | 100 |
937047 | 937047 | 2021-01-17 | Taylor | Florida | 12123 | 2274 | 30 |
937048 | 937048 | 2021-01-17 | Union | Florida | 12125 | 1610 | 69 |
937049 | 937049 | 2021-01-17 | Unknown | Florida | 3293 | 0 | |
937050 | 937050 | 2021-01-17 | Volusia | Florida | 12127 | 27386 | 473 |
937051 | 937051 | 2021-01-17 | Wakulla | Florida | 12129 | 2670 | 32 |
937052 | 937052 | 2021-01-17 | Walton | Florida | 12131 | 5842 | 59 |
937053 | 937053 | 2021-01-17 | Washington | Florida | 12133 | 2263 | 30 |
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);