ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
22 rows where deaths = 400 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
county 10
state 1
- Florida · 22 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2467333 | 2467333 | 2022-05-03 | Columbia | Florida | 12023 | 21166 | 400 |
2464078 | 2464078 | 2022-05-02 | Columbia | Florida | 12023 | 21166 | 400 |
2460822 | 2460822 | 2022-05-01 | Columbia | Florida | 12023 | 21166 | 400 |
2457566 | 2457566 | 2022-04-30 | Columbia | Florida | 12023 | 21166 | 400 |
2454310 | 2454310 | 2022-04-29 | Columbia | Florida | 12023 | 21166 | 400 |
2451054 | 2451054 | 2022-04-28 | Columbia | Florida | 12023 | 21166 | 400 |
2447798 | 2447798 | 2022-04-27 | Columbia | Florida | 12023 | 21166 | 400 |
2288399 | 2288399 | 2022-03-09 | Unknown | Florida | 7318 | 400 | |
1222671 | 1222671 | 2021-04-15 | Charlotte | Florida | 12015 | 12227 | 400 |
1219423 | 1219423 | 2021-04-14 | Charlotte | Florida | 12015 | 12178 | 400 |
1216175 | 1216175 | 2021-04-13 | Charlotte | Florida | 12015 | 12138 | 400 |
1027909 | 1027909 | 2021-02-14 | Osceola | Florida | 12097 | 35394 | 400 |
1024664 | 1024664 | 2021-02-13 | Osceola | Florida | 12097 | 35276 | 400 |
1021419 | 1021419 | 2021-02-12 | Osceola | Florida | 12097 | 35150 | 400 |
904549 | 904549 | 2021-01-07 | Escambia | Florida | 12033 | 24530 | 400 |
839693 | 839693 | 2020-12-18 | Volusia | Florida | 12127 | 19569 | 400 |
836423 | 836423 | 2020-12-17 | Manatee | Florida | 12081 | 19612 | 400 |
833177 | 833177 | 2020-12-16 | Manatee | Florida | 12081 | 19389 | 400 |
722799 | 722799 | 2020-11-12 | Brevard | Florida | 12009 | 13167 | 400 |
719556 | 719556 | 2020-11-11 | Brevard | Florida | 12009 | 13092 | 400 |
518610 | 518610 | 2020-09-10 | Orange | Florida | 12095 | 37472 | 400 |
379876 | 379876 | 2020-07-29 | Pinellas | Florida | 12103 | 15800 | 400 |
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);