ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
107 rows where deaths = 1, fips = 12129 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 |
---|---|---|---|---|---|---|---|
373459 | 373459 | 2020-07-27 | Wakulla | Florida | 12129 | 515 | 1 |
370247 | 370247 | 2020-07-26 | Wakulla | Florida | 12129 | 507 | 1 |
367037 | 367037 | 2020-07-25 | Wakulla | Florida | 12129 | 477 | 1 |
363830 | 363830 | 2020-07-24 | Wakulla | Florida | 12129 | 455 | 1 |
360623 | 360623 | 2020-07-23 | Wakulla | Florida | 12129 | 419 | 1 |
357418 | 357418 | 2020-07-22 | Wakulla | Florida | 12129 | 341 | 1 |
354215 | 354215 | 2020-07-21 | Wakulla | Florida | 12129 | 309 | 1 |
351013 | 351013 | 2020-07-20 | Wakulla | Florida | 12129 | 297 | 1 |
347812 | 347812 | 2020-07-19 | Wakulla | Florida | 12129 | 279 | 1 |
344612 | 344612 | 2020-07-18 | Wakulla | Florida | 12129 | 258 | 1 |
341413 | 341413 | 2020-07-17 | Wakulla | Florida | 12129 | 235 | 1 |
338216 | 338216 | 2020-07-16 | Wakulla | Florida | 12129 | 223 | 1 |
335021 | 335021 | 2020-07-15 | Wakulla | Florida | 12129 | 206 | 1 |
331828 | 331828 | 2020-07-14 | Wakulla | Florida | 12129 | 164 | 1 |
328641 | 328641 | 2020-07-13 | Wakulla | Florida | 12129 | 137 | 1 |
325455 | 325455 | 2020-07-12 | Wakulla | Florida | 12129 | 128 | 1 |
322274 | 322274 | 2020-07-11 | Wakulla | Florida | 12129 | 122 | 1 |
319095 | 319095 | 2020-07-10 | Wakulla | Florida | 12129 | 116 | 1 |
315922 | 315922 | 2020-07-09 | Wakulla | Florida | 12129 | 102 | 1 |
312747 | 312747 | 2020-07-08 | Wakulla | Florida | 12129 | 94 | 1 |
309577 | 309577 | 2020-07-07 | Wakulla | Florida | 12129 | 93 | 1 |
306409 | 306409 | 2020-07-06 | Wakulla | Florida | 12129 | 90 | 1 |
303245 | 303245 | 2020-07-05 | Wakulla | Florida | 12129 | 87 | 1 |
300081 | 300081 | 2020-07-04 | Wakulla | Florida | 12129 | 84 | 1 |
296919 | 296919 | 2020-07-03 | Wakulla | Florida | 12129 | 72 | 1 |
293763 | 293763 | 2020-07-02 | Wakulla | Florida | 12129 | 71 | 1 |
290609 | 290609 | 2020-07-01 | Wakulla | Florida | 12129 | 65 | 1 |
287458 | 287458 | 2020-06-30 | Wakulla | Florida | 12129 | 60 | 1 |
284312 | 284312 | 2020-06-29 | Wakulla | Florida | 12129 | 55 | 1 |
281166 | 281166 | 2020-06-28 | Wakulla | Florida | 12129 | 54 | 1 |
278019 | 278019 | 2020-06-27 | Wakulla | Florida | 12129 | 47 | 1 |
274871 | 274871 | 2020-06-26 | Wakulla | Florida | 12129 | 46 | 1 |
271731 | 271731 | 2020-06-25 | Wakulla | Florida | 12129 | 42 | 1 |
268595 | 268595 | 2020-06-24 | Wakulla | Florida | 12129 | 41 | 1 |
265465 | 265465 | 2020-06-23 | Wakulla | Florida | 12129 | 41 | 1 |
262337 | 262337 | 2020-06-22 | Wakulla | Florida | 12129 | 40 | 1 |
259210 | 259210 | 2020-06-21 | Wakulla | Florida | 12129 | 40 | 1 |
256083 | 256083 | 2020-06-20 | Wakulla | Florida | 12129 | 38 | 1 |
252964 | 252964 | 2020-06-19 | Wakulla | Florida | 12129 | 37 | 1 |
249849 | 249849 | 2020-06-18 | Wakulla | Florida | 12129 | 37 | 1 |
246737 | 246737 | 2020-06-17 | Wakulla | Florida | 12129 | 36 | 1 |
243624 | 243624 | 2020-06-16 | Wakulla | Florida | 12129 | 35 | 1 |
240513 | 240513 | 2020-06-15 | Wakulla | Florida | 12129 | 35 | 1 |
237405 | 237405 | 2020-06-14 | Wakulla | Florida | 12129 | 35 | 1 |
234298 | 234298 | 2020-06-13 | Wakulla | Florida | 12129 | 35 | 1 |
231192 | 231192 | 2020-06-12 | Wakulla | Florida | 12129 | 35 | 1 |
228089 | 228089 | 2020-06-11 | Wakulla | Florida | 12129 | 35 | 1 |
224987 | 224987 | 2020-06-10 | Wakulla | Florida | 12129 | 35 | 1 |
221892 | 221892 | 2020-06-09 | Wakulla | Florida | 12129 | 35 | 1 |
218797 | 218797 | 2020-06-08 | Wakulla | Florida | 12129 | 35 | 1 |
215706 | 215706 | 2020-06-07 | Wakulla | Florida | 12129 | 35 | 1 |
212619 | 212619 | 2020-06-06 | Wakulla | Florida | 12129 | 35 | 1 |
209534 | 209534 | 2020-06-05 | Wakulla | Florida | 12129 | 35 | 1 |
206453 | 206453 | 2020-06-04 | Wakulla | Florida | 12129 | 35 | 1 |
203373 | 203373 | 2020-06-03 | Wakulla | Florida | 12129 | 35 | 1 |
200297 | 200297 | 2020-06-02 | Wakulla | Florida | 12129 | 35 | 1 |
197224 | 197224 | 2020-06-01 | Wakulla | Florida | 12129 | 35 | 1 |
194154 | 194154 | 2020-05-31 | Wakulla | Florida | 12129 | 34 | 1 |
191087 | 191087 | 2020-05-30 | Wakulla | Florida | 12129 | 34 | 1 |
188022 | 188022 | 2020-05-29 | Wakulla | Florida | 12129 | 33 | 1 |
184966 | 184966 | 2020-05-28 | Wakulla | Florida | 12129 | 32 | 1 |
181912 | 181912 | 2020-05-27 | Wakulla | Florida | 12129 | 32 | 1 |
178868 | 178868 | 2020-05-26 | Wakulla | Florida | 12129 | 32 | 1 |
175824 | 175824 | 2020-05-25 | Wakulla | Florida | 12129 | 32 | 1 |
172781 | 172781 | 2020-05-24 | Wakulla | Florida | 12129 | 32 | 1 |
169740 | 169740 | 2020-05-23 | Wakulla | Florida | 12129 | 32 | 1 |
166703 | 166703 | 2020-05-22 | Wakulla | Florida | 12129 | 32 | 1 |
163670 | 163670 | 2020-05-21 | Wakulla | Florida | 12129 | 32 | 1 |
160642 | 160642 | 2020-05-20 | Wakulla | Florida | 12129 | 32 | 1 |
157616 | 157616 | 2020-05-19 | Wakulla | Florida | 12129 | 32 | 1 |
154600 | 154600 | 2020-05-18 | Wakulla | Florida | 12129 | 32 | 1 |
151588 | 151588 | 2020-05-17 | Wakulla | Florida | 12129 | 32 | 1 |
148579 | 148579 | 2020-05-16 | Wakulla | Florida | 12129 | 31 | 1 |
145576 | 145576 | 2020-05-15 | Wakulla | Florida | 12129 | 31 | 1 |
142576 | 142576 | 2020-05-14 | Wakulla | Florida | 12129 | 31 | 1 |
139580 | 139580 | 2020-05-13 | Wakulla | Florida | 12129 | 31 | 1 |
136589 | 136589 | 2020-05-12 | Wakulla | Florida | 12129 | 31 | 1 |
133600 | 133600 | 2020-05-11 | Wakulla | Florida | 12129 | 29 | 1 |
130609 | 130609 | 2020-05-10 | Wakulla | Florida | 12129 | 29 | 1 |
127618 | 127618 | 2020-05-09 | Wakulla | Florida | 12129 | 29 | 1 |
124631 | 124631 | 2020-05-08 | Wakulla | Florida | 12129 | 29 | 1 |
121652 | 121652 | 2020-05-07 | Wakulla | Florida | 12129 | 29 | 1 |
118683 | 118683 | 2020-05-06 | Wakulla | Florida | 12129 | 29 | 1 |
115723 | 115723 | 2020-05-05 | Wakulla | Florida | 12129 | 29 | 1 |
112840 | 112840 | 2020-05-04 | Wakulla | Florida | 12129 | 24 | 1 |
109965 | 109965 | 2020-05-03 | Wakulla | Florida | 12129 | 24 | 1 |
107096 | 107096 | 2020-05-02 | Wakulla | Florida | 12129 | 23 | 1 |
104231 | 104231 | 2020-05-01 | Wakulla | Florida | 12129 | 24 | 1 |
101376 | 101376 | 2020-04-30 | Wakulla | Florida | 12129 | 23 | 1 |
98526 | 98526 | 2020-04-29 | Wakulla | Florida | 12129 | 22 | 1 |
95681 | 95681 | 2020-04-28 | Wakulla | Florida | 12129 | 22 | 1 |
92849 | 92849 | 2020-04-27 | Wakulla | Florida | 12129 | 22 | 1 |
90030 | 90030 | 2020-04-26 | Wakulla | Florida | 12129 | 21 | 1 |
87214 | 87214 | 2020-04-25 | Wakulla | Florida | 12129 | 20 | 1 |
84405 | 84405 | 2020-04-24 | Wakulla | Florida | 12129 | 20 | 1 |
81605 | 81605 | 2020-04-23 | Wakulla | Florida | 12129 | 17 | 1 |
78812 | 78812 | 2020-04-22 | Wakulla | Florida | 12129 | 15 | 1 |
76028 | 76028 | 2020-04-21 | Wakulla | Florida | 12129 | 15 | 1 |
73252 | 73252 | 2020-04-20 | Wakulla | Florida | 12129 | 15 | 1 |
70483 | 70483 | 2020-04-19 | Wakulla | Florida | 12129 | 14 | 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);