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-12-27 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 |
---|---|---|---|---|---|---|---|
868835 | 868835 | 2020-12-27 | Alachua | Florida | 12001 | 15420 | 124 |
868836 | 868836 | 2020-12-27 | Baker | Florida | 12003 | 2397 | 36 |
868837 | 868837 | 2020-12-27 | Bay | Florida | 12005 | 11358 | 202 |
868838 | 868838 | 2020-12-27 | Bradford | Florida | 12007 | 2103 | 23 |
868839 | 868839 | 2020-12-27 | Brevard | Florida | 12009 | 20145 | 513 |
868840 | 868840 | 2020-12-27 | Broward | Florida | 12011 | 132897 | 1817 |
868841 | 868841 | 2020-12-27 | Calhoun | Florida | 12013 | 1159 | 27 |
868842 | 868842 | 2020-12-27 | Charlotte | Florida | 12015 | 7065 | 230 |
868843 | 868843 | 2020-12-27 | Citrus | Florida | 12017 | 6417 | 251 |
868844 | 868844 | 2020-12-27 | Clay | Florida | 12019 | 10794 | 183 |
868845 | 868845 | 2020-12-27 | Collier | Florida | 12021 | 21683 | 326 |
868846 | 868846 | 2020-12-27 | Columbia | Florida | 12023 | 5816 | 116 |
868847 | 868847 | 2020-12-27 | DeSoto | Florida | 12027 | 2839 | 52 |
868848 | 868848 | 2020-12-27 | Dixie | Florida | 12029 | 1083 | 11 |
868849 | 868849 | 2020-12-27 | Duval | Florida | 12031 | 58296 | 717 |
868850 | 868850 | 2020-12-27 | Escambia | Florida | 12033 | 21408 | 359 |
868851 | 868851 | 2020-12-27 | Flagler | Florida | 12035 | 3542 | 48 |
868852 | 868852 | 2020-12-27 | Franklin | Florida | 12037 | 877 | 4 |
868853 | 868853 | 2020-12-27 | Gadsden | Florida | 12039 | 3830 | 59 |
868854 | 868854 | 2020-12-27 | Gilchrist | Florida | 12041 | 977 | 22 |
868855 | 868855 | 2020-12-27 | Glades | Florida | 12043 | 761 | 11 |
868856 | 868856 | 2020-12-27 | Gulf | Florida | 12045 | 1268 | 27 |
868857 | 868857 | 2020-12-27 | Hamilton | Florida | 12047 | 1220 | 12 |
868858 | 868858 | 2020-12-27 | Hardee | Florida | 12049 | 2056 | 20 |
868859 | 868859 | 2020-12-27 | Hendry | Florida | 12051 | 3214 | 49 |
868860 | 868860 | 2020-12-27 | Hernando | Florida | 12053 | 7028 | 264 |
868861 | 868861 | 2020-12-27 | Highlands | Florida | 12055 | 4803 | 199 |
868862 | 868862 | 2020-12-27 | Hillsborough | Florida | 12057 | 74368 | 1058 |
868863 | 868863 | 2020-12-27 | Holmes | Florida | 12059 | 1590 | 23 |
868864 | 868864 | 2020-12-27 | Indian River | Florida | 12061 | 6468 | 155 |
868865 | 868865 | 2020-12-27 | Jackson | Florida | 12063 | 4492 | 113 |
868866 | 868866 | 2020-12-27 | Jefferson | Florida | 12065 | 955 | 16 |
868867 | 868867 | 2020-12-27 | Lafayette | Florida | 12067 | 1413 | 21 |
868868 | 868868 | 2020-12-27 | Lake | Florida | 12069 | 14723 | 290 |
868869 | 868869 | 2020-12-27 | Lee | Florida | 12071 | 39002 | 652 |
868870 | 868870 | 2020-12-27 | Leon | Florida | 12073 | 18705 | 173 |
868871 | 868871 | 2020-12-27 | Levy | Florida | 12075 | 1791 | 19 |
868872 | 868872 | 2020-12-27 | Liberty | Florida | 12077 | 714 | 14 |
868873 | 868873 | 2020-12-27 | Madison | Florida | 12079 | 1514 | 33 |
868874 | 868874 | 2020-12-27 | Manatee | Florida | 12081 | 21406 | 410 |
868875 | 868875 | 2020-12-27 | Marion | Florida | 12083 | 17030 | 454 |
868876 | 868876 | 2020-12-27 | Martin | Florida | 12085 | 7625 | 207 |
868877 | 868877 | 2020-12-27 | Miami-Dade | Florida | 12086 | 288305 | 4150 |
868878 | 868878 | 2020-12-27 | Monroe | Florida | 12087 | 4153 | 34 |
868879 | 868879 | 2020-12-27 | Nassau | Florida | 12089 | 4488 | 66 |
868880 | 868880 | 2020-12-27 | Okaloosa | Florida | 12091 | 12324 | 224 |
868881 | 868881 | 2020-12-27 | Okeechobee | Florida | 12093 | 2345 | 51 |
868882 | 868882 | 2020-12-27 | Orange | Florida | 12095 | 73049 | 727 |
868883 | 868883 | 2020-12-27 | Osceola | Florida | 12097 | 24290 | 286 |
868884 | 868884 | 2020-12-27 | Palm Beach | Florida | 12099 | 80237 | 1860 |
868885 | 868885 | 2020-12-27 | Pasco | Florida | 12101 | 21036 | 353 |
868886 | 868886 | 2020-12-27 | Pinellas | Florida | 12103 | 43210 | 1029 |
868887 | 868887 | 2020-12-27 | Polk | Florida | 12105 | 35656 | 767 |
868888 | 868888 | 2020-12-27 | Putnam | Florida | 12107 | 3799 | 69 |
868889 | 868889 | 2020-12-27 | Santa Rosa | Florida | 12113 | 10486 | 121 |
868890 | 868890 | 2020-12-27 | Sarasota | Florida | 12115 | 17834 | 500 |
868891 | 868891 | 2020-12-27 | Seminole | Florida | 12117 | 17341 | 309 |
868892 | 868892 | 2020-12-27 | St. Johns | Florida | 12109 | 12407 | 112 |
868893 | 868893 | 2020-12-27 | St. Lucie | Florida | 12111 | 13779 | 393 |
868894 | 868894 | 2020-12-27 | Sumter | Florida | 12119 | 4783 | 118 |
868895 | 868895 | 2020-12-27 | Suwannee | Florida | 12121 | 3903 | 94 |
868896 | 868896 | 2020-12-27 | Taylor | Florida | 12123 | 1910 | 25 |
868897 | 868897 | 2020-12-27 | Union | Florida | 12125 | 1414 | 65 |
868898 | 868898 | 2020-12-27 | Unknown | Florida | 3080 | 0 | |
868899 | 868899 | 2020-12-27 | Volusia | Florida | 12127 | 21275 | 424 |
868900 | 868900 | 2020-12-27 | Wakulla | Florida | 12129 | 2027 | 21 |
868901 | 868901 | 2020-12-27 | Walton | Florida | 12131 | 4681 | 43 |
868902 | 868902 | 2020-12-27 | Washington | Florida | 12133 | 1907 | 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);