ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
24 rows where deaths = 188 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1060377 | 1060377 | 2021-02-24 | St. Johns | Florida | 12109 | 19945 | 188 |
1057131 | 1057131 | 2021-02-23 | St. Johns | Florida | 12109 | 19905 | 188 |
1053885 | 1053885 | 2021-02-22 | St. Johns | Florida | 12109 | 19860 | 188 |
920795 | 920795 | 2021-01-12 | Leon | Florida | 12073 | 22530 | 188 |
894808 | 894808 | 2021-01-04 | Clay | Florida | 12019 | 11886 | 188 |
891561 | 891561 | 2021-01-03 | Clay | Florida | 12019 | 11798 | 188 |
888314 | 888314 | 2021-01-02 | Clay | Florida | 12019 | 11639 | 188 |
839655 | 839655 | 2020-12-18 | Highlands | Florida | 12055 | 4494 | 188 |
836425 | 836425 | 2020-12-17 | Martin | Florida | 12085 | 7072 | 188 |
833140 | 833140 | 2020-12-16 | Bay | Florida | 12005 | 10104 | 188 |
833179 | 833179 | 2020-12-16 | Martin | Florida | 12085 | 6967 | 188 |
829932 | 829932 | 2020-12-15 | Martin | Florida | 12085 | 6909 | 188 |
813668 | 813668 | 2020-12-10 | Citrus | Florida | 12017 | 5350 | 188 |
810424 | 810424 | 2020-12-09 | Citrus | Florida | 12017 | 5304 | 188 |
567155 | 567155 | 2020-09-25 | Lake | Florida | 12069 | 7420 | 188 |
518573 | 518573 | 2020-09-10 | Collier | Florida | 12021 | 12096 | 188 |
489477 | 489477 | 2020-09-01 | Escambia | Florida | 12033 | 11256 | 188 |
428164 | 428164 | 2020-08-13 | St. Lucie | Florida | 12111 | 6040 | 188 |
415233 | 415233 | 2020-08-09 | Duval | Florida | 12031 | 23437 | 188 |
412013 | 412013 | 2020-08-08 | Duval | Florida | 12031 | 23166 | 188 |
402381 | 402381 | 2020-08-05 | Manatee | Florida | 12081 | 8938 | 188 |
328603 | 328603 | 2020-07-13 | Hillsborough | Florida | 12057 | 19828 | 188 |
328610 | 328610 | 2020-07-13 | Lee | Florida | 12071 | 10343 | 188 |
325417 | 325417 | 2020-07-12 | Hillsborough | Florida | 12057 | 19150 | 188 |
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);