ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
41 rows where deaths = 1, fips = 12075 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 |
---|---|---|---|---|---|---|---|
315893 | 315893 | 2020-07-09 | Levy | Florida | 12075 | 235 | 1 |
312718 | 312718 | 2020-07-08 | Levy | Florida | 12075 | 225 | 1 |
309548 | 309548 | 2020-07-07 | Levy | Florida | 12075 | 218 | 1 |
306380 | 306380 | 2020-07-06 | Levy | Florida | 12075 | 211 | 1 |
303216 | 303216 | 2020-07-05 | Levy | Florida | 12075 | 210 | 1 |
300052 | 300052 | 2020-07-04 | Levy | Florida | 12075 | 202 | 1 |
296890 | 296890 | 2020-07-03 | Levy | Florida | 12075 | 192 | 1 |
293734 | 293734 | 2020-07-02 | Levy | Florida | 12075 | 182 | 1 |
290580 | 290580 | 2020-07-01 | Levy | Florida | 12075 | 181 | 1 |
287429 | 287429 | 2020-06-30 | Levy | Florida | 12075 | 174 | 1 |
284283 | 284283 | 2020-06-29 | Levy | Florida | 12075 | 173 | 1 |
281137 | 281137 | 2020-06-28 | Levy | Florida | 12075 | 171 | 1 |
277990 | 277990 | 2020-06-27 | Levy | Florida | 12075 | 168 | 1 |
274842 | 274842 | 2020-06-26 | Levy | Florida | 12075 | 165 | 1 |
271702 | 271702 | 2020-06-25 | Levy | Florida | 12075 | 157 | 1 |
268566 | 268566 | 2020-06-24 | Levy | Florida | 12075 | 154 | 1 |
265436 | 265436 | 2020-06-23 | Levy | Florida | 12075 | 151 | 1 |
262308 | 262308 | 2020-06-22 | Levy | Florida | 12075 | 147 | 1 |
259181 | 259181 | 2020-06-21 | Levy | Florida | 12075 | 139 | 1 |
256054 | 256054 | 2020-06-20 | Levy | Florida | 12075 | 137 | 1 |
252935 | 252935 | 2020-06-19 | Levy | Florida | 12075 | 137 | 1 |
249820 | 249820 | 2020-06-18 | Levy | Florida | 12075 | 132 | 1 |
246708 | 246708 | 2020-06-17 | Levy | Florida | 12075 | 131 | 1 |
243595 | 243595 | 2020-06-16 | Levy | Florida | 12075 | 127 | 1 |
240484 | 240484 | 2020-06-15 | Levy | Florida | 12075 | 101 | 1 |
237376 | 237376 | 2020-06-14 | Levy | Florida | 12075 | 100 | 1 |
234269 | 234269 | 2020-06-13 | Levy | Florida | 12075 | 100 | 1 |
231163 | 231163 | 2020-06-12 | Levy | Florida | 12075 | 98 | 1 |
228060 | 228060 | 2020-06-11 | Levy | Florida | 12075 | 95 | 1 |
224958 | 224958 | 2020-06-10 | Levy | Florida | 12075 | 90 | 1 |
221863 | 221863 | 2020-06-09 | Levy | Florida | 12075 | 90 | 1 |
218768 | 218768 | 2020-06-08 | Levy | Florida | 12075 | 73 | 1 |
215677 | 215677 | 2020-06-07 | Levy | Florida | 12075 | 60 | 1 |
212590 | 212590 | 2020-06-06 | Levy | Florida | 12075 | 58 | 1 |
209505 | 209505 | 2020-06-05 | Levy | Florida | 12075 | 55 | 1 |
206424 | 206424 | 2020-06-04 | Levy | Florida | 12075 | 38 | 1 |
203344 | 203344 | 2020-06-03 | Levy | Florida | 12075 | 35 | 1 |
200268 | 200268 | 2020-06-02 | Levy | Florida | 12075 | 35 | 1 |
197195 | 197195 | 2020-06-01 | Levy | Florida | 12075 | 34 | 1 |
194125 | 194125 | 2020-05-31 | Levy | Florida | 12075 | 32 | 1 |
191058 | 191058 | 2020-05-30 | Levy | Florida | 12075 | 31 | 1 |
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);