ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
41 rows where deaths = 200 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2421802 | 2421802 | 2022-04-19 | Unknown | Florida | 25450 | 200 | |
2418546 | 2418546 | 2022-04-18 | Unknown | Florida | 22404 | 200 | |
2376181 | 2376181 | 2022-04-05 | Gadsden | Florida | 12039 | 13414 | 200 |
2372929 | 2372929 | 2022-04-04 | Gadsden | Florida | 12039 | 13414 | 200 |
2369676 | 2369676 | 2022-04-03 | Gadsden | Florida | 12039 | 13414 | 200 |
2366423 | 2366423 | 2022-04-02 | Gadsden | Florida | 12039 | 13414 | 200 |
2363170 | 2363170 | 2022-04-01 | Gadsden | Florida | 12039 | 13414 | 200 |
2359916 | 2359916 | 2022-03-31 | Gadsden | Florida | 12039 | 13414 | 200 |
2356662 | 2356662 | 2022-03-30 | Gadsden | Florida | 12039 | 13414 | 200 |
2353409 | 2353409 | 2022-03-29 | Gadsden | Florida | 12039 | 13414 | 200 |
2350157 | 2350157 | 2022-03-28 | Gadsden | Florida | 12039 | 13414 | 200 |
2346904 | 2346904 | 2022-03-27 | Gadsden | Florida | 12039 | 13414 | 200 |
2343651 | 2343651 | 2022-03-26 | Gadsden | Florida | 12039 | 13414 | 200 |
2340398 | 2340398 | 2022-03-25 | Gadsden | Florida | 12039 | 13414 | 200 |
2337145 | 2337145 | 2022-03-24 | Gadsden | Florida | 12039 | 13396 | 200 |
2262384 | 2262384 | 2022-03-01 | Walton | Florida | 12131 | 16425 | 200 |
2259133 | 2259133 | 2022-02-28 | Walton | Florida | 12131 | 16425 | 200 |
2255882 | 2255882 | 2022-02-27 | Walton | Florida | 12131 | 16425 | 200 |
2252631 | 2252631 | 2022-02-26 | Walton | Florida | 12131 | 16425 | 200 |
2249380 | 2249380 | 2022-02-25 | Walton | Florida | 12131 | 16425 | 200 |
2246129 | 2246129 | 2022-02-24 | Walton | Florida | 12131 | 16379 | 200 |
2242878 | 2242878 | 2022-02-23 | Walton | Florida | 12131 | 16379 | 200 |
1144776 | 1144776 | 2021-03-22 | St. Johns | Florida | 12109 | 20788 | 200 |
1141529 | 1141529 | 2021-03-21 | St. Johns | Florida | 12109 | 20774 | 200 |
1138283 | 1138283 | 2021-03-20 | St. Johns | Florida | 12109 | 20752 | 200 |
1128542 | 1128542 | 2021-03-17 | St. Johns | Florida | 12109 | 20644 | 200 |
1096078 | 1096078 | 2021-03-07 | St. Johns | Florida | 12109 | 20334 | 200 |
1092832 | 1092832 | 2021-03-06 | St. Johns | Florida | 12109 | 20303 | 200 |
949998 | 949998 | 2021-01-21 | Indian River | Florida | 12061 | 9101 | 200 |
930531 | 930531 | 2021-01-15 | Leon | Florida | 12073 | 23232 | 200 |
855896 | 855896 | 2020-12-23 | Martin | Florida | 12085 | 7440 | 200 |
800688 | 800688 | 2020-12-06 | Charlotte | Florida | 12015 | 5527 | 200 |
797443 | 797443 | 2020-12-05 | Charlotte | Florida | 12015 | 5437 | 200 |
557462 | 557462 | 2020-09-22 | Seminole | Florida | 12117 | 8887 | 200 |
554225 | 554225 | 2020-09-21 | Seminole | Florida | 12117 | 8860 | 200 |
550986 | 550986 | 2020-09-20 | Seminole | Florida | 12117 | 8836 | 200 |
547747 | 547747 | 2020-09-19 | Seminole | Florida | 12117 | 8794 | 200 |
518578 | 518578 | 2020-09-10 | Escambia | Florida | 12033 | 11702 | 200 |
495969 | 495969 | 2020-09-03 | Marion | Florida | 12083 | 8675 | 200 |
470066 | 470066 | 2020-08-26 | Brevard | Florida | 12009 | 7040 | 200 |
357405 | 357405 | 2020-07-22 | Polk | Florida | 12105 | 10309 | 200 |
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);