ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
50 rows where date = "2020-03-28" and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
16028 | 16028 | 2020-03-28 | Alachua | Florida | 12001 | 68 | 0 |
16029 | 16029 | 2020-03-28 | Baker | Florida | 12003 | 7 | 0 |
16030 | 16030 | 2020-03-28 | Bay | Florida | 12005 | 5 | 0 |
16031 | 16031 | 2020-03-28 | Bradford | Florida | 12007 | 1 | 0 |
16032 | 16032 | 2020-03-28 | Brevard | Florida | 12009 | 27 | 0 |
16033 | 16033 | 2020-03-28 | Broward | Florida | 12011 | 820 | 11 |
16034 | 16034 | 2020-03-28 | Charlotte | Florida | 12015 | 16 | 0 |
16035 | 16035 | 2020-03-28 | Citrus | Florida | 12017 | 15 | 1 |
16036 | 16036 | 2020-03-28 | Clay | Florida | 12019 | 26 | 4 |
16037 | 16037 | 2020-03-28 | Collier | Florida | 12021 | 95 | 0 |
16038 | 16038 | 2020-03-28 | Columbia | Florida | 12023 | 3 | 0 |
16039 | 16039 | 2020-03-28 | DeSoto | Florida | 12027 | 7 | 0 |
16040 | 16040 | 2020-03-28 | Duval | Florida | 12031 | 120 | 3 |
16041 | 16041 | 2020-03-28 | Escambia | Florida | 12033 | 28 | 0 |
16042 | 16042 | 2020-03-28 | Flagler | Florida | 12035 | 13 | 0 |
16043 | 16043 | 2020-03-28 | Gadsden | Florida | 12039 | 1 | 0 |
16044 | 16044 | 2020-03-28 | Hendry | Florida | 12051 | 1 | 0 |
16045 | 16045 | 2020-03-28 | Hernando | Florida | 12053 | 14 | 0 |
16046 | 16046 | 2020-03-28 | Highlands | Florida | 12055 | 10 | 1 |
16047 | 16047 | 2020-03-28 | Hillsborough | Florida | 12057 | 206 | 2 |
16048 | 16048 | 2020-03-28 | Indian River | Florida | 12061 | 16 | 0 |
16049 | 16049 | 2020-03-28 | Jackson | Florida | 12063 | 1 | 0 |
16050 | 16050 | 2020-03-28 | Lake | Florida | 12069 | 38 | 0 |
16051 | 16051 | 2020-03-28 | Lee | Florida | 12071 | 119 | 6 |
16052 | 16052 | 2020-03-28 | Leon | Florida | 12073 | 17 | 0 |
16053 | 16053 | 2020-03-28 | Levy | Florida | 12075 | 1 | 0 |
16054 | 16054 | 2020-03-28 | Manatee | Florida | 12081 | 32 | 1 |
16055 | 16055 | 2020-03-28 | Marion | Florida | 12083 | 18 | 0 |
16056 | 16056 | 2020-03-28 | Martin | Florida | 12085 | 26 | 0 |
16057 | 16057 | 2020-03-28 | Miami-Dade | Florida | 12086 | 1121 | 3 |
16058 | 16058 | 2020-03-28 | Monroe | Florida | 12087 | 22 | 0 |
16059 | 16059 | 2020-03-28 | Nassau | Florida | 12089 | 7 | 0 |
16060 | 16060 | 2020-03-28 | Okaloosa | Florida | 12091 | 31 | 0 |
16061 | 16061 | 2020-03-28 | Orange | Florida | 12095 | 213 | 4 |
16062 | 16062 | 2020-03-28 | Osceola | Florida | 12097 | 74 | 0 |
16063 | 16063 | 2020-03-28 | Palm Beach | Florida | 12099 | 318 | 6 |
16064 | 16064 | 2020-03-28 | Pasco | Florida | 12101 | 34 | 2 |
16065 | 16065 | 2020-03-28 | Pinellas | Florida | 12103 | 111 | 4 |
16066 | 16066 | 2020-03-28 | Polk | Florida | 12105 | 37 | 0 |
16067 | 16067 | 2020-03-28 | Putnam | Florida | 12107 | 12 | 0 |
16068 | 16068 | 2020-03-28 | Santa Rosa | Florida | 12113 | 16 | 1 |
16069 | 16069 | 2020-03-28 | Sarasota | Florida | 12115 | 50 | 2 |
16070 | 16070 | 2020-03-28 | Seminole | Florida | 12117 | 68 | 0 |
16071 | 16071 | 2020-03-28 | St. Johns | Florida | 12109 | 50 | 2 |
16072 | 16072 | 2020-03-28 | St. Lucie | Florida | 12111 | 22 | 2 |
16073 | 16073 | 2020-03-28 | Sumter | Florida | 12119 | 40 | 0 |
16074 | 16074 | 2020-03-28 | Suwannee | Florida | 12121 | 1 | 0 |
16075 | 16075 | 2020-03-28 | Volusia | Florida | 12127 | 44 | 1 |
16076 | 16076 | 2020-03-28 | Walton | Florida | 12131 | 15 | 0 |
16077 | 16077 | 2020-03-28 | Washington | Florida | 12133 | 1 | 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);