ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
41 rows where deaths = 278 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 11
- Santa Rosa 11
- Sumter 11
- Flagler 7
- Indian River 4
- Hernando 2
- Alachua 1
- Broward 1
- Hillsborough 1
- Manatee 1
- Pinellas 1
- Sarasota 1
state 1
- Florida · 41 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2080205 | 2080205 | 2022-01-04 | Flagler | Florida | 12035 | 15519 | 278 |
2076953 | 2076953 | 2022-01-03 | Flagler | Florida | 12035 | 15519 | 278 |
2073702 | 2073702 | 2022-01-02 | Flagler | Florida | 12035 | 15519 | 278 |
2070451 | 2070451 | 2022-01-01 | Flagler | Florida | 12035 | 15519 | 278 |
2067200 | 2067200 | 2021-12-31 | Flagler | Florida | 12035 | 15519 | 278 |
2063949 | 2063949 | 2021-12-30 | Flagler | Florida | 12035 | 14948 | 278 |
2060699 | 2060699 | 2021-12-29 | Flagler | Florida | 12035 | 14948 | 278 |
1336363 | 1336363 | 2021-05-20 | Sumter | Florida | 12119 | 9422 | 278 |
1333116 | 1333116 | 2021-05-19 | Sumter | Florida | 12119 | 9413 | 278 |
1329869 | 1329869 | 2021-05-18 | Sumter | Florida | 12119 | 9406 | 278 |
1326622 | 1326622 | 2021-05-17 | Sumter | Florida | 12119 | 9391 | 278 |
1323376 | 1323376 | 2021-05-16 | Sumter | Florida | 12119 | 9386 | 278 |
1320130 | 1320130 | 2021-05-15 | Sumter | Florida | 12119 | 9381 | 278 |
1316883 | 1316883 | 2021-05-14 | Sumter | Florida | 12119 | 9378 | 278 |
1313636 | 1313636 | 2021-05-13 | Sumter | Florida | 12119 | 9374 | 278 |
1310389 | 1310389 | 2021-05-12 | Sumter | Florida | 12119 | 9369 | 278 |
1307084 | 1307084 | 2021-05-11 | Alachua | Florida | 12001 | 24942 | 278 |
1307143 | 1307143 | 2021-05-11 | Sumter | Florida | 12119 | 9364 | 278 |
1300650 | 1300650 | 2021-05-09 | Sumter | Florida | 12119 | 9352 | 278 |
1193485 | 1193485 | 2021-04-06 | Santa Rosa | Florida | 12113 | 17830 | 278 |
1190235 | 1190235 | 2021-04-05 | Santa Rosa | Florida | 12113 | 17824 | 278 |
1186988 | 1186988 | 2021-04-04 | Santa Rosa | Florida | 12113 | 17809 | 278 |
1183741 | 1183741 | 2021-04-03 | Santa Rosa | Florida | 12113 | 17805 | 278 |
1180494 | 1180494 | 2021-04-02 | Santa Rosa | Florida | 12113 | 17781 | 278 |
1177247 | 1177247 | 2021-04-01 | Santa Rosa | Florida | 12113 | 17763 | 278 |
1174000 | 1174000 | 2021-03-31 | Santa Rosa | Florida | 12113 | 17744 | 278 |
1170753 | 1170753 | 2021-03-30 | Santa Rosa | Florida | 12113 | 17725 | 278 |
1167505 | 1167505 | 2021-03-29 | Santa Rosa | Florida | 12113 | 17709 | 278 |
1164257 | 1164257 | 2021-03-28 | Santa Rosa | Florida | 12113 | 17702 | 278 |
1161009 | 1161009 | 2021-03-27 | Santa Rosa | Florida | 12113 | 17693 | 278 |
1157736 | 1157736 | 2021-03-26 | Indian River | Florida | 12061 | 11629 | 278 |
1154489 | 1154489 | 2021-03-25 | Indian River | Florida | 12061 | 11604 | 278 |
1151242 | 1151242 | 2021-03-24 | Indian River | Florida | 12061 | 11573 | 278 |
1147995 | 1147995 | 2021-03-23 | Indian River | Florida | 12061 | 11543 | 278 |
885085 | 885085 | 2021-01-01 | Hernando | Florida | 12053 | 7336 | 278 |
881840 | 881840 | 2020-12-31 | Hernando | Florida | 12053 | 7336 | 278 |
609318 | 609318 | 2020-10-08 | Sarasota | Florida | 12115 | 8518 | 278 |
557445 | 557445 | 2020-09-22 | Manatee | Florida | 12081 | 11279 | 278 |
360585 | 360585 | 2020-07-23 | Hillsborough | Florida | 12057 | 25432 | 278 |
335007 | 335007 | 2020-07-15 | Pinellas | Florida | 12103 | 12080 | 278 |
148519 | 148519 | 2020-05-16 | Broward | Florida | 12011 | 6201 | 278 |
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);