ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
24 rows where deaths = 254 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
county 11
state 1
- Florida · 24 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1725972 | 1725972 | 2021-09-17 | Columbia | Florida | 12023 | 14398 | 254 |
1722723 | 1722723 | 2021-09-16 | Columbia | Florida | 12023 | 14045 | 254 |
1719474 | 1719474 | 2021-09-15 | Columbia | Florida | 12023 | 14045 | 254 |
1716226 | 1716226 | 2021-09-14 | Columbia | Florida | 12023 | 14045 | 254 |
927296 | 927296 | 2021-01-14 | Okaloosa | Florida | 12091 | 14811 | 254 |
917522 | 917522 | 2021-01-11 | Charlotte | Florida | 12015 | 8522 | 254 |
849390 | 849390 | 2020-12-21 | Hernando | Florida | 12053 | 6615 | 254 |
846145 | 846145 | 2020-12-20 | Hernando | Florida | 12053 | 6512 | 254 |
842899 | 842899 | 2020-12-19 | Hernando | Florida | 12053 | 6477 | 254 |
839654 | 839654 | 2020-12-18 | Hernando | Florida | 12053 | 6374 | 254 |
777999 | 777999 | 2020-11-29 | Lake | Florida | 12069 | 10623 | 254 |
774754 | 774754 | 2020-11-28 | Lake | Florida | 12069 | 10531 | 254 |
609278 | 609278 | 2020-10-08 | Escambia | Florida | 12033 | 12588 | 254 |
576904 | 576904 | 2020-09-28 | Sarasota | Florida | 12115 | 8147 | 254 |
573661 | 573661 | 2020-09-27 | Sarasota | Florida | 12115 | 8142 | 254 |
570419 | 570419 | 2020-09-26 | Sarasota | Florida | 12115 | 8107 | 254 |
567177 | 567177 | 2020-09-25 | Sarasota | Florida | 12115 | 8065 | 254 |
528276 | 528276 | 2020-09-13 | Brevard | Florida | 12009 | 7960 | 254 |
525040 | 525040 | 2020-09-12 | Brevard | Florida | 12009 | 7926 | 254 |
486243 | 486243 | 2020-08-31 | Duval | Florida | 12031 | 26460 | 254 |
483008 | 483008 | 2020-08-30 | Duval | Florida | 12031 | 26391 | 254 |
479774 | 479774 | 2020-08-29 | Duval | Florida | 12031 | 26284 | 254 |
473333 | 473333 | 2020-08-27 | Manatee | Florida | 12081 | 10310 | 254 |
139564 | 139564 | 2020-05-13 | Palm Beach | Florida | 12099 | 4174 | 254 |
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);