ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
21 rows where cases = 49 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, deaths
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
315889 | 315889 | 2020-07-09 | Lafayette | Florida | 12067 | 49 | 0 |
287424 | 287424 | 2020-06-30 | Jefferson | Florida | 12065 | 49 | 4 |
191035 | 191035 | 2020-05-30 | Dixie | Florida | 12029 | 49 | 2 |
187970 | 187970 | 2020-05-29 | Dixie | Florida | 12029 | 49 | 2 |
160580 | 160580 | 2020-05-20 | Bradford | Florida | 12007 | 49 | 2 |
160623 | 160623 | 2020-05-20 | Okeechobee | Florida | 12093 | 49 | 0 |
157554 | 157554 | 2020-05-19 | Bradford | Florida | 12007 | 49 | 2 |
154538 | 154538 | 2020-05-18 | Bradford | Florida | 12007 | 49 | 2 |
151526 | 151526 | 2020-05-17 | Bradford | Florida | 12007 | 49 | 2 |
148517 | 148517 | 2020-05-16 | Bradford | Florida | 12007 | 49 | 2 |
145514 | 145514 | 2020-05-15 | Bradford | Florida | 12007 | 49 | 2 |
142514 | 142514 | 2020-05-14 | Bradford | Florida | 12007 | 49 | 2 |
127616 | 127616 | 2020-05-09 | Unknown | Florida | 49 | 0 | |
109966 | 109966 | 2020-05-03 | Walton | Florida | 12131 | 49 | 0 |
98499 | 98499 | 2020-04-29 | Madison | Florida | 12079 | 49 | 2 |
95654 | 95654 | 2020-04-28 | Madison | Florida | 12079 | 49 | 2 |
89977 | 89977 | 2020-04-26 | Columbia | Florida | 12023 | 49 | 0 |
84385 | 84385 | 2020-04-24 | Nassau | Florida | 12089 | 49 | 0 |
62228 | 62228 | 2020-04-16 | Putnam | Florida | 12107 | 49 | 1 |
38408 | 38408 | 2020-04-07 | Monroe | Florida | 12087 | 49 | 2 |
26370 | 26370 | 2020-04-02 | Brevard | Florida | 12009 | 49 | 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);