ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "Lake" and fips = 12069 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386293 | 386293 | 2020-07-31 | Lake | Florida | 12069 | 4516 | 51 |
383075 | 383075 | 2020-07-30 | Lake | Florida | 12069 | 4408 | 51 |
379858 | 379858 | 2020-07-29 | Lake | Florida | 12069 | 4326 | 50 |
376641 | 376641 | 2020-07-28 | Lake | Florida | 12069 | 4259 | 49 |
373427 | 373427 | 2020-07-27 | Lake | Florida | 12069 | 4169 | 48 |
370215 | 370215 | 2020-07-26 | Lake | Florida | 12069 | 4090 | 39 |
367005 | 367005 | 2020-07-25 | Lake | Florida | 12069 | 3988 | 38 |
363798 | 363798 | 2020-07-24 | Lake | Florida | 12069 | 3890 | 38 |
360591 | 360591 | 2020-07-23 | Lake | Florida | 12069 | 3757 | 37 |
357386 | 357386 | 2020-07-22 | Lake | Florida | 12069 | 3594 | 36 |
354183 | 354183 | 2020-07-21 | Lake | Florida | 12069 | 3473 | 36 |
350981 | 350981 | 2020-07-20 | Lake | Florida | 12069 | 3391 | 36 |
347780 | 347780 | 2020-07-19 | Lake | Florida | 12069 | 3343 | 35 |
344580 | 344580 | 2020-07-18 | Lake | Florida | 12069 | 3206 | 35 |
341381 | 341381 | 2020-07-17 | Lake | Florida | 12069 | 3139 | 36 |
338184 | 338184 | 2020-07-16 | Lake | Florida | 12069 | 3009 | 34 |
334989 | 334989 | 2020-07-15 | Lake | Florida | 12069 | 2882 | 28 |
331796 | 331796 | 2020-07-14 | Lake | Florida | 12069 | 2783 | 27 |
328609 | 328609 | 2020-07-13 | Lake | Florida | 12069 | 2645 | 27 |
325423 | 325423 | 2020-07-12 | Lake | Florida | 12069 | 2517 | 27 |
322242 | 322242 | 2020-07-11 | Lake | Florida | 12069 | 2394 | 27 |
319063 | 319063 | 2020-07-10 | Lake | Florida | 12069 | 2298 | 26 |
315890 | 315890 | 2020-07-09 | Lake | Florida | 12069 | 2181 | 26 |
312715 | 312715 | 2020-07-08 | Lake | Florida | 12069 | 2087 | 25 |
309545 | 309545 | 2020-07-07 | Lake | Florida | 12069 | 1998 | 25 |
306377 | 306377 | 2020-07-06 | Lake | Florida | 12069 | 1890 | 23 |
303213 | 303213 | 2020-07-05 | Lake | Florida | 12069 | 1845 | 23 |
300049 | 300049 | 2020-07-04 | Lake | Florida | 12069 | 1694 | 23 |
296887 | 296887 | 2020-07-03 | Lake | Florida | 12069 | 1603 | 23 |
293731 | 293731 | 2020-07-02 | Lake | Florida | 12069 | 1508 | 23 |
290577 | 290577 | 2020-07-01 | Lake | Florida | 12069 | 1410 | 22 |
287426 | 287426 | 2020-06-30 | Lake | Florida | 12069 | 1302 | 22 |
284280 | 284280 | 2020-06-29 | Lake | Florida | 12069 | 1252 | 22 |
281134 | 281134 | 2020-06-28 | Lake | Florida | 12069 | 1192 | 22 |
277987 | 277987 | 2020-06-27 | Lake | Florida | 12069 | 1098 | 22 |
274839 | 274839 | 2020-06-26 | Lake | Florida | 12069 | 975 | 22 |
271699 | 271699 | 2020-06-25 | Lake | Florida | 12069 | 881 | 21 |
268563 | 268563 | 2020-06-24 | Lake | Florida | 12069 | 838 | 21 |
265433 | 265433 | 2020-06-23 | Lake | Florida | 12069 | 795 | 21 |
262305 | 262305 | 2020-06-22 | Lake | Florida | 12069 | 763 | 20 |
259178 | 259178 | 2020-06-21 | Lake | Florida | 12069 | 733 | 19 |
256051 | 256051 | 2020-06-20 | Lake | Florida | 12069 | 671 | 19 |
252932 | 252932 | 2020-06-19 | Lake | Florida | 12069 | 646 | 19 |
249817 | 249817 | 2020-06-18 | Lake | Florida | 12069 | 583 | 19 |
246705 | 246705 | 2020-06-17 | Lake | Florida | 12069 | 552 | 16 |
243592 | 243592 | 2020-06-16 | Lake | Florida | 12069 | 498 | 16 |
240481 | 240481 | 2020-06-15 | Lake | Florida | 12069 | 482 | 16 |
237373 | 237373 | 2020-06-14 | Lake | Florida | 12069 | 464 | 16 |
234266 | 234266 | 2020-06-13 | Lake | Florida | 12069 | 452 | 16 |
231160 | 231160 | 2020-06-12 | Lake | Florida | 12069 | 383 | 15 |
228057 | 228057 | 2020-06-11 | Lake | Florida | 12069 | 355 | 15 |
224955 | 224955 | 2020-06-10 | Lake | Florida | 12069 | 342 | 15 |
221860 | 221860 | 2020-06-09 | Lake | Florida | 12069 | 339 | 15 |
218765 | 218765 | 2020-06-08 | Lake | Florida | 12069 | 337 | 15 |
215674 | 215674 | 2020-06-07 | Lake | Florida | 12069 | 329 | 15 |
212587 | 212587 | 2020-06-06 | Lake | Florida | 12069 | 321 | 15 |
209502 | 209502 | 2020-06-05 | Lake | Florida | 12069 | 317 | 15 |
206421 | 206421 | 2020-06-04 | Lake | Florida | 12069 | 313 | 15 |
203341 | 203341 | 2020-06-03 | Lake | Florida | 12069 | 309 | 15 |
200265 | 200265 | 2020-06-02 | Lake | Florida | 12069 | 306 | 15 |
197192 | 197192 | 2020-06-01 | Lake | Florida | 12069 | 304 | 15 |
194122 | 194122 | 2020-05-31 | Lake | Florida | 12069 | 301 | 15 |
191055 | 191055 | 2020-05-30 | Lake | Florida | 12069 | 298 | 15 |
187990 | 187990 | 2020-05-29 | Lake | Florida | 12069 | 291 | 15 |
184934 | 184934 | 2020-05-28 | Lake | Florida | 12069 | 280 | 15 |
181880 | 181880 | 2020-05-27 | Lake | Florida | 12069 | 279 | 15 |
178836 | 178836 | 2020-05-26 | Lake | Florida | 12069 | 277 | 15 |
175792 | 175792 | 2020-05-25 | Lake | Florida | 12069 | 275 | 15 |
172749 | 172749 | 2020-05-24 | Lake | Florida | 12069 | 273 | 15 |
169708 | 169708 | 2020-05-23 | Lake | Florida | 12069 | 271 | 15 |
166671 | 166671 | 2020-05-22 | Lake | Florida | 12069 | 266 | 15 |
163638 | 163638 | 2020-05-21 | Lake | Florida | 12069 | 264 | 14 |
160610 | 160610 | 2020-05-20 | Lake | Florida | 12069 | 260 | 14 |
157584 | 157584 | 2020-05-19 | Lake | Florida | 12069 | 257 | 14 |
154568 | 154568 | 2020-05-18 | Lake | Florida | 12069 | 254 | 14 |
151556 | 151556 | 2020-05-17 | Lake | Florida | 12069 | 252 | 14 |
148547 | 148547 | 2020-05-16 | Lake | Florida | 12069 | 250 | 14 |
145544 | 145544 | 2020-05-15 | Lake | Florida | 12069 | 249 | 14 |
142544 | 142544 | 2020-05-14 | Lake | Florida | 12069 | 248 | 14 |
139548 | 139548 | 2020-05-13 | Lake | Florida | 12069 | 247 | 14 |
136557 | 136557 | 2020-05-12 | Lake | Florida | 12069 | 246 | 14 |
133568 | 133568 | 2020-05-11 | Lake | Florida | 12069 | 243 | 14 |
130577 | 130577 | 2020-05-10 | Lake | Florida | 12069 | 242 | 14 |
127586 | 127586 | 2020-05-09 | Lake | Florida | 12069 | 240 | 14 |
124599 | 124599 | 2020-05-08 | Lake | Florida | 12069 | 237 | 14 |
121620 | 121620 | 2020-05-07 | Lake | Florida | 12069 | 237 | 14 |
118651 | 118651 | 2020-05-06 | Lake | Florida | 12069 | 236 | 14 |
115691 | 115691 | 2020-05-05 | Lake | Florida | 12069 | 235 | 14 |
112808 | 112808 | 2020-05-04 | Lake | Florida | 12069 | 235 | 13 |
109933 | 109933 | 2020-05-03 | Lake | Florida | 12069 | 234 | 13 |
107064 | 107064 | 2020-05-02 | Lake | Florida | 12069 | 234 | 13 |
104199 | 104199 | 2020-05-01 | Lake | Florida | 12069 | 233 | 13 |
101344 | 101344 | 2020-04-30 | Lake | Florida | 12069 | 227 | 12 |
98494 | 98494 | 2020-04-29 | Lake | Florida | 12069 | 227 | 11 |
95649 | 95649 | 2020-04-28 | Lake | Florida | 12069 | 226 | 10 |
92817 | 92817 | 2020-04-27 | Lake | Florida | 12069 | 223 | 10 |
89999 | 89999 | 2020-04-26 | Lake | Florida | 12069 | 222 | 10 |
87182 | 87182 | 2020-04-25 | Lake | Florida | 12069 | 221 | 10 |
84374 | 84374 | 2020-04-24 | Lake | Florida | 12069 | 219 | 10 |
81574 | 81574 | 2020-04-23 | Lake | Florida | 12069 | 217 | 9 |
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);