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-05-04 and state = "Florida" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
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 |
---|---|---|---|---|---|---|---|
112775 | 112775 | 2020-05-04 | Alachua | Florida | 12001 | 289 | 5 |
112776 | 112776 | 2020-05-04 | Baker | Florida | 12003 | 22 | 3 |
112777 | 112777 | 2020-05-04 | Bay | Florida | 12005 | 76 | 3 |
112778 | 112778 | 2020-05-04 | Bradford | Florida | 12007 | 48 | 2 |
112779 | 112779 | 2020-05-04 | Brevard | Florida | 12009 | 310 | 8 |
112780 | 112780 | 2020-05-04 | Broward | Florida | 12011 | 5383 | 208 |
112781 | 112781 | 2020-05-04 | Calhoun | Florida | 12013 | 15 | 0 |
112782 | 112782 | 2020-05-04 | Charlotte | Florida | 12015 | 257 | 25 |
112783 | 112783 | 2020-05-04 | Citrus | Florida | 12017 | 99 | 11 |
112784 | 112784 | 2020-05-04 | Clay | Florida | 12019 | 285 | 18 |
112785 | 112785 | 2020-05-04 | Collier | Florida | 12021 | 653 | 22 |
112786 | 112786 | 2020-05-04 | Columbia | Florida | 12023 | 96 | 2 |
112787 | 112787 | 2020-05-04 | DeSoto | Florida | 12027 | 39 | 4 |
112788 | 112788 | 2020-05-04 | Dixie | Florida | 12029 | 10 | 0 |
112789 | 112789 | 2020-05-04 | Duval | Florida | 12031 | 1072 | 26 |
112790 | 112790 | 2020-05-04 | Escambia | Florida | 12033 | 595 | 13 |
112791 | 112791 | 2020-05-04 | Flagler | Florida | 12035 | 140 | 3 |
112792 | 112792 | 2020-05-04 | Franklin | Florida | 12037 | 2 | 0 |
112793 | 112793 | 2020-05-04 | Gadsden | Florida | 12039 | 112 | 0 |
112794 | 112794 | 2020-05-04 | Gilchrist | Florida | 12041 | 6 | 0 |
112795 | 112795 | 2020-05-04 | Glades | Florida | 12043 | 6 | 1 |
112796 | 112796 | 2020-05-04 | Gulf | Florida | 12045 | 1 | 0 |
112797 | 112797 | 2020-05-04 | Hamilton | Florida | 12047 | 7 | 0 |
112798 | 112798 | 2020-05-04 | Hardee | Florida | 12049 | 33 | 0 |
112799 | 112799 | 2020-05-04 | Hendry | Florida | 12051 | 111 | 4 |
112800 | 112800 | 2020-05-04 | Hernando | Florida | 12053 | 96 | 5 |
112801 | 112801 | 2020-05-04 | Highlands | Florida | 12055 | 87 | 7 |
112802 | 112802 | 2020-05-04 | Hillsborough | Florida | 12057 | 1300 | 29 |
112803 | 112803 | 2020-05-04 | Holmes | Florida | 12059 | 10 | 0 |
112804 | 112804 | 2020-05-04 | Indian River | Florida | 12061 | 98 | 8 |
112805 | 112805 | 2020-05-04 | Jackson | Florida | 12063 | 15 | 0 |
112806 | 112806 | 2020-05-04 | Jefferson | Florida | 12065 | 28 | 2 |
112807 | 112807 | 2020-05-04 | Lafayette | Florida | 12067 | 2 | 0 |
112808 | 112808 | 2020-05-04 | Lake | Florida | 12069 | 235 | 13 |
112809 | 112809 | 2020-05-04 | Lee | Florida | 12071 | 1137 | 46 |
112810 | 112810 | 2020-05-04 | Leon | Florida | 12073 | 242 | 5 |
112811 | 112811 | 2020-05-04 | Levy | Florida | 12075 | 20 | 0 |
112812 | 112812 | 2020-05-04 | Liberty | Florida | 12077 | 60 | 0 |
112813 | 112813 | 2020-05-04 | Madison | Florida | 12079 | 61 | 2 |
112814 | 112814 | 2020-05-04 | Manatee | Florida | 12081 | 636 | 59 |
112815 | 112815 | 2020-05-04 | Marion | Florida | 12083 | 184 | 5 |
112816 | 112816 | 2020-05-04 | Martin | Florida | 12085 | 215 | 6 |
112817 | 112817 | 2020-05-04 | Miami-Dade | Florida | 12086 | 13091 | 378 |
112818 | 112818 | 2020-05-04 | Monroe | Florida | 12087 | 80 | 3 |
112819 | 112819 | 2020-05-04 | Nassau | Florida | 12089 | 59 | 1 |
112820 | 112820 | 2020-05-04 | Okaloosa | Florida | 12091 | 159 | 5 |
112821 | 112821 | 2020-05-04 | Okeechobee | Florida | 12093 | 18 | 0 |
112822 | 112822 | 2020-05-04 | Orange | Florida | 12095 | 1437 | 34 |
112823 | 112823 | 2020-05-04 | Osceola | Florida | 12097 | 516 | 8 |
112824 | 112824 | 2020-05-04 | Palm Beach | Florida | 12099 | 3309 | 196 |
112825 | 112825 | 2020-05-04 | Pasco | Florida | 12101 | 282 | 8 |
112826 | 112826 | 2020-05-04 | Pinellas | Florida | 12103 | 784 | 42 |
112827 | 112827 | 2020-05-04 | Polk | Florida | 12105 | 536 | 26 |
112828 | 112828 | 2020-05-04 | Putnam | Florida | 12107 | 121 | 2 |
112829 | 112829 | 2020-05-04 | Santa Rosa | Florida | 12113 | 158 | 8 |
112830 | 112830 | 2020-05-04 | Sarasota | Florida | 12115 | 385 | 47 |
112831 | 112831 | 2020-05-04 | Seminole | Florida | 12117 | 396 | 8 |
112832 | 112832 | 2020-05-04 | St. Johns | Florida | 12109 | 211 | 4 |
112833 | 112833 | 2020-05-04 | St. Lucie | Florida | 12111 | 260 | 25 |
112834 | 112834 | 2020-05-04 | Sumter | Florida | 12119 | 233 | 14 |
112835 | 112835 | 2020-05-04 | Suwannee | Florida | 12121 | 141 | 16 |
112836 | 112836 | 2020-05-04 | Taylor | Florida | 12123 | 3 | 0 |
112837 | 112837 | 2020-05-04 | Union | Florida | 12125 | 5 | 0 |
112838 | 112838 | 2020-05-04 | Unknown | Florida | 12 | 0 | |
112839 | 112839 | 2020-05-04 | Volusia | Florida | 12127 | 514 | 26 |
112840 | 112840 | 2020-05-04 | Wakulla | Florida | 12129 | 24 | 1 |
112841 | 112841 | 2020-05-04 | Walton | Florida | 12131 | 50 | 1 |
112842 | 112842 | 2020-05-04 | Washington | Florida | 12133 | 12 | 0 |
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);