ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
16 rows where deaths = 300 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
state 1
- Florida · 16 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2129028 | 2129028 | 2022-01-19 | Unknown | Florida | 204454 | 300 | |
1914480 | 1914480 | 2021-11-14 | Unknown | Florida | 1413 | 300 | |
1911230 | 1911230 | 2021-11-13 | Unknown | Florida | 1413 | 300 | |
1157748 | 1157748 | 2021-03-26 | Martin | Florida | 12085 | 11236 | 300 |
1151254 | 1151254 | 2021-03-24 | Martin | Florida | 12085 | 11181 | 300 |
998654 | 998654 | 2021-02-05 | Bay | Florida | 12005 | 17365 | 300 |
826701 | 826701 | 2020-12-14 | Seminole | Florida | 12117 | 15400 | 300 |
635271 | 635271 | 2020-10-16 | Volusia | Florida | 12127 | 11819 | 300 |
615785 | 615785 | 2020-10-10 | Manatee | Florida | 12081 | 11999 | 300 |
612544 | 612544 | 2020-10-09 | Manatee | Florida | 12081 | 11999 | 300 |
609302 | 609302 | 2020-10-08 | Manatee | Florida | 12081 | 11943 | 300 |
395944 | 395944 | 2020-08-03 | Lee | Florida | 12071 | 15798 | 300 |
392728 | 392728 | 2020-08-02 | Lee | Florida | 12071 | 15673 | 300 |
389511 | 389511 | 2020-08-01 | Lee | Florida | 12071 | 15550 | 300 |
341399 | 341399 | 2020-07-17 | Pinellas | Florida | 12103 | 12714 | 300 |
178808 | 178808 | 2020-05-26 | Broward | Florida | 12011 | 6799 | 300 |
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);