ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
37 rows where deaths = 203 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2421757 | 2421757 | 2022-04-19 | Gadsden | Florida | 12039 | 13433 | 203 |
2418501 | 2418501 | 2022-04-18 | Gadsden | Florida | 12039 | 13433 | 203 |
2415245 | 2415245 | 2022-04-17 | Gadsden | Florida | 12039 | 13433 | 203 |
2411989 | 2411989 | 2022-04-16 | Gadsden | Florida | 12039 | 13433 | 203 |
2408733 | 2408733 | 2022-04-15 | Gadsden | Florida | 12039 | 13433 | 203 |
2405477 | 2405477 | 2022-04-14 | Gadsden | Florida | 12039 | 13433 | 203 |
2402222 | 2402222 | 2022-04-13 | Gadsden | Florida | 12039 | 13433 | 203 |
1219473 | 1219473 | 2021-04-14 | St. Johns | Florida | 12109 | 21767 | 203 |
1216225 | 1216225 | 2021-04-13 | St. Johns | Florida | 12109 | 21719 | 203 |
1212978 | 1212978 | 2021-04-12 | St. Johns | Florida | 12109 | 21652 | 203 |
1209730 | 1209730 | 2021-04-11 | St. Johns | Florida | 12109 | 21643 | 203 |
1206481 | 1206481 | 2021-04-10 | St. Johns | Florida | 12109 | 21610 | 203 |
1203233 | 1203233 | 2021-04-09 | St. Johns | Florida | 12109 | 21550 | 203 |
1199985 | 1199985 | 2021-04-08 | St. Johns | Florida | 12109 | 21507 | 203 |
1196736 | 1196736 | 2021-04-07 | St. Johns | Florida | 12109 | 21431 | 203 |
1193488 | 1193488 | 2021-04-06 | St. Johns | Florida | 12109 | 21394 | 203 |
1190238 | 1190238 | 2021-04-05 | St. Johns | Florida | 12109 | 21362 | 203 |
1186991 | 1186991 | 2021-04-04 | St. Johns | Florida | 12109 | 21337 | 203 |
1183744 | 1183744 | 2021-04-03 | St. Johns | Florida | 12109 | 21294 | 203 |
1180497 | 1180497 | 2021-04-02 | St. Johns | Florida | 12109 | 21245 | 203 |
1177250 | 1177250 | 2021-04-01 | St. Johns | Florida | 12109 | 21217 | 203 |
1040844 | 1040844 | 2021-02-18 | Alachua | Florida | 12001 | 22004 | 203 |
1037599 | 1037599 | 2021-02-17 | Alachua | Florida | 12001 | 21960 | 203 |
943511 | 943511 | 2021-01-19 | Leon | Florida | 12073 | 23921 | 203 |
940266 | 940266 | 2021-01-18 | Leon | Florida | 12073 | 23661 | 203 |
875327 | 875327 | 2020-12-29 | Bay | Florida | 12005 | 11540 | 203 |
872082 | 872082 | 2020-12-28 | Bay | Florida | 12005 | 11403 | 203 |
842919 | 842919 | 2020-12-19 | Okaloosa | Florida | 12091 | 11379 | 203 |
816914 | 816914 | 2020-12-11 | Citrus | Florida | 12017 | 5427 | 203 |
807178 | 807178 | 2020-12-08 | Charlotte | Florida | 12015 | 5652 | 203 |
803933 | 803933 | 2020-12-07 | Charlotte | Florida | 12015 | 5593 | 203 |
528287 | 528287 | 2020-09-13 | Escambia | Florida | 12033 | 11867 | 203 |
525051 | 525051 | 2020-09-12 | Escambia | Florida | 12033 | 11818 | 203 |
521815 | 521815 | 2020-09-11 | Escambia | Florida | 12033 | 11766 | 203 |
518627 | 518627 | 2020-09-10 | Volusia | Florida | 12127 | 9931 | 203 |
360610 | 360610 | 2020-07-23 | Polk | Florida | 12105 | 10545 | 203 |
331797 | 331797 | 2020-07-14 | Lee | Florida | 12071 | 10630 | 203 |
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);