ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
34 rows where deaths = 235 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1823479 | 1823479 | 2021-10-17 | Nassau | Florida | 12089 | 14931 | 235 |
1820230 | 1820230 | 2021-10-16 | Nassau | Florida | 12089 | 14931 | 235 |
1816981 | 1816981 | 2021-10-15 | Nassau | Florida | 12089 | 14931 | 235 |
1092775 | 1092775 | 2021-03-06 | Alachua | Florida | 12001 | 22588 | 235 |
1089529 | 1089529 | 2021-03-05 | Alachua | Florida | 12001 | 22555 | 235 |
1086284 | 1086284 | 2021-03-04 | Alachua | Florida | 12001 | 22512 | 235 |
1083038 | 1083038 | 2021-03-03 | Alachua | Florida | 12001 | 22458 | 235 |
1079792 | 1079792 | 2021-03-02 | Alachua | Florida | 12001 | 22412 | 235 |
1063624 | 1063624 | 2021-02-25 | Sumter | Florida | 12119 | 7946 | 235 |
995435 | 995435 | 2021-02-04 | Indian River | Florida | 12061 | 9980 | 235 |
992189 | 992189 | 2021-02-03 | Indian River | Florida | 12061 | 9933 | 235 |
988949 | 988949 | 2021-02-02 | Leon | Florida | 12073 | 26722 | 235 |
985702 | 985702 | 2021-02-01 | Leon | Florida | 12073 | 26542 | 235 |
752050 | 752050 | 2020-11-21 | Osceola | Florida | 12097 | 16989 | 235 |
709854 | 709854 | 2020-11-08 | Lake | Florida | 12069 | 9195 | 235 |
706610 | 706610 | 2020-11-07 | Lake | Florida | 12069 | 9132 | 235 |
657982 | 657982 | 2020-10-23 | Seminole | Florida | 12117 | 9928 | 235 |
645003 | 645003 | 2020-10-19 | Seminole | Florida | 12117 | 9737 | 235 |
641755 | 641755 | 2020-10-18 | Seminole | Florida | 12117 | 9711 | 235 |
583344 | 583344 | 2020-09-30 | Escambia | Florida | 12033 | 12353 | 235 |
521840 | 521840 | 2020-09-11 | Marion | Florida | 12083 | 9043 | 235 |
518603 | 518603 | 2020-09-10 | Marion | Florida | 12083 | 8967 | 235 |
512099 | 512099 | 2020-09-08 | Brevard | Florida | 12009 | 7689 | 235 |
508866 | 508866 | 2020-09-07 | Brevard | Florida | 12009 | 7656 | 235 |
505634 | 505634 | 2020-09-06 | Brevard | Florida | 12009 | 7633 | 235 |
486287 | 486287 | 2020-08-31 | St. Lucie | Florida | 12111 | 6992 | 235 |
483052 | 483052 | 2020-08-30 | St. Lucie | Florida | 12111 | 6975 | 235 |
479818 | 479818 | 2020-08-29 | St. Lucie | Florida | 12111 | 6939 | 235 |
476585 | 476585 | 2020-08-28 | St. Lucie | Florida | 12111 | 6896 | 235 |
463618 | 463618 | 2020-08-24 | Duval | Florida | 12031 | 25658 | 235 |
460389 | 460389 | 2020-08-23 | Duval | Florida | 12031 | 25558 | 235 |
457162 | 457162 | 2020-08-22 | Duval | Florida | 12031 | 25454 | 235 |
453934 | 453934 | 2020-08-21 | Duval | Florida | 12031 | 25316 | 235 |
347774 | 347774 | 2020-07-19 | Hillsborough | Florida | 12057 | 23706 | 235 |
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);