ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
24 rows where deaths = 195 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 9
- Walton 7
- Pasco 5
- Brevard 4
- Santa Rosa 3
- Alachua 1
- Miami-Dade 1
- Palm Beach 1
- St. Johns 1
- St. Lucie 1
state 1
- Florida · 24 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2239627 | 2239627 | 2022-02-22 | Walton | Florida | 12131 | 16379 | 195 |
2236376 | 2236376 | 2022-02-21 | Walton | Florida | 12131 | 16379 | 195 |
2233125 | 2233125 | 2022-02-20 | Walton | Florida | 12131 | 16379 | 195 |
2229874 | 2229874 | 2022-02-19 | Walton | Florida | 12131 | 16379 | 195 |
2226623 | 2226623 | 2022-02-18 | Walton | Florida | 12131 | 16379 | 195 |
2223372 | 2223372 | 2022-02-17 | Walton | Florida | 12131 | 16278 | 195 |
2220121 | 2220121 | 2022-02-16 | Walton | Florida | 12131 | 16278 | 195 |
1070112 | 1070112 | 2021-02-27 | St. Johns | Florida | 12109 | 20048 | 195 |
1027861 | 1027861 | 2021-02-14 | Alachua | Florida | 12001 | 21791 | 195 |
963004 | 963004 | 2021-01-25 | Santa Rosa | Florida | 12113 | 14796 | 195 |
959759 | 959759 | 2021-01-24 | Santa Rosa | Florida | 12113 | 14711 | 195 |
956513 | 956513 | 2021-01-23 | Santa Rosa | Florida | 12113 | 14611 | 195 |
534794 | 534794 | 2020-09-15 | Pasco | Florida | 12101 | 8600 | 195 |
531559 | 531559 | 2020-09-14 | Pasco | Florida | 12101 | 8551 | 195 |
528322 | 528322 | 2020-09-13 | Pasco | Florida | 12101 | 8527 | 195 |
525086 | 525086 | 2020-09-12 | Pasco | Florida | 12101 | 8507 | 195 |
521850 | 521850 | 2020-09-11 | Pasco | Florida | 12101 | 8464 | 195 |
466837 | 466837 | 2020-08-25 | Brevard | Florida | 12009 | 6972 | 195 |
463608 | 463608 | 2020-08-24 | Brevard | Florida | 12009 | 6946 | 195 |
460379 | 460379 | 2020-08-23 | Brevard | Florida | 12009 | 6912 | 195 |
457152 | 457152 | 2020-08-22 | Brevard | Florida | 12009 | 6889 | 195 |
431392 | 431392 | 2020-08-14 | St. Lucie | Florida | 12111 | 6125 | 195 |
107080 | 107080 | 2020-05-02 | Palm Beach | Florida | 12099 | 3078 | 195 |
64950 | 64950 | 2020-04-17 | Miami-Dade | Florida | 12086 | 8823 | 195 |
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);