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 |
---|---|---|---|---|---|---|---|
635240 | 635240 | 2020-10-16 | Lake | Florida | 12069 | 8083 | 214 |
631994 | 631994 | 2020-10-15 | Lake | Florida | 12069 | 8047 | 211 |
628750 | 628750 | 2020-10-14 | Lake | Florida | 12069 | 8012 | 211 |
625507 | 625507 | 2020-10-13 | Lake | Florida | 12069 | 7973 | 209 |
622264 | 622264 | 2020-10-12 | Lake | Florida | 12069 | 7939 | 206 |
619021 | 619021 | 2020-10-11 | Lake | Florida | 12069 | 7917 | 205 |
615779 | 615779 | 2020-10-10 | Lake | Florida | 12069 | 7862 | 202 |
612538 | 612538 | 2020-10-09 | Lake | Florida | 12069 | 7862 | 202 |
609296 | 609296 | 2020-10-08 | Lake | Florida | 12069 | 7818 | 202 |
606053 | 606053 | 2020-10-07 | Lake | Florida | 12069 | 7770 | 199 |
602811 | 602811 | 2020-10-06 | Lake | Florida | 12069 | 7729 | 196 |
599568 | 599568 | 2020-10-05 | Lake | Florida | 12069 | 7712 | 197 |
596325 | 596325 | 2020-10-04 | Lake | Florida | 12069 | 7693 | 197 |
593083 | 593083 | 2020-10-03 | Lake | Florida | 12069 | 7650 | 193 |
589843 | 589843 | 2020-10-02 | Lake | Florida | 12069 | 7606 | 194 |
586602 | 586602 | 2020-10-01 | Lake | Florida | 12069 | 7567 | 193 |
583362 | 583362 | 2020-09-30 | Lake | Florida | 12069 | 7542 | 193 |
580123 | 580123 | 2020-09-29 | Lake | Florida | 12069 | 7517 | 190 |
576882 | 576882 | 2020-09-28 | Lake | Florida | 12069 | 7475 | 190 |
573639 | 573639 | 2020-09-27 | Lake | Florida | 12069 | 7466 | 189 |
570397 | 570397 | 2020-09-26 | Lake | Florida | 12069 | 7444 | 189 |
567155 | 567155 | 2020-09-25 | Lake | Florida | 12069 | 7420 | 188 |
563915 | 563915 | 2020-09-24 | Lake | Florida | 12069 | 7394 | 184 |
560675 | 560675 | 2020-09-23 | Lake | Florida | 12069 | 7365 | 173 |
557439 | 557439 | 2020-09-22 | Lake | Florida | 12069 | 7339 | 172 |
554202 | 554202 | 2020-09-21 | Lake | Florida | 12069 | 7313 | 169 |
550963 | 550963 | 2020-09-20 | Lake | Florida | 12069 | 7293 | 169 |
547724 | 547724 | 2020-09-19 | Lake | Florida | 12069 | 7262 | 169 |
544486 | 544486 | 2020-09-18 | Lake | Florida | 12069 | 7220 | 169 |
541250 | 541250 | 2020-09-17 | Lake | Florida | 12069 | 7173 | 163 |
538013 | 538013 | 2020-09-16 | Lake | Florida | 12069 | 7137 | 158 |
534777 | 534777 | 2020-09-15 | Lake | Florida | 12069 | 7092 | 156 |
531542 | 531542 | 2020-09-14 | Lake | Florida | 12069 | 7063 | 147 |
528305 | 528305 | 2020-09-13 | Lake | Florida | 12069 | 7046 | 147 |
525069 | 525069 | 2020-09-12 | Lake | Florida | 12069 | 7021 | 147 |
521833 | 521833 | 2020-09-11 | Lake | Florida | 12069 | 6972 | 140 |
518596 | 518596 | 2020-09-10 | Lake | Florida | 12069 | 6921 | 136 |
515361 | 515361 | 2020-09-09 | Lake | Florida | 12069 | 6871 | 131 |
512128 | 512128 | 2020-09-08 | Lake | Florida | 12069 | 6841 | 128 |
508895 | 508895 | 2020-09-07 | Lake | Florida | 12069 | 6824 | 129 |
505663 | 505663 | 2020-09-06 | Lake | Florida | 12069 | 6787 | 129 |
502429 | 502429 | 2020-09-05 | Lake | Florida | 12069 | 6754 | 129 |
499195 | 499195 | 2020-09-04 | Lake | Florida | 12069 | 6683 | 128 |
495962 | 495962 | 2020-09-03 | Lake | Florida | 12069 | 6622 | 126 |
492728 | 492728 | 2020-09-02 | Lake | Florida | 12069 | 6581 | 121 |
489495 | 489495 | 2020-09-01 | Lake | Florida | 12069 | 6538 | 118 |
486262 | 486262 | 2020-08-31 | Lake | Florida | 12069 | 6396 | 117 |
483027 | 483027 | 2020-08-30 | Lake | Florida | 12069 | 6385 | 116 |
479793 | 479793 | 2020-08-29 | Lake | Florida | 12069 | 6345 | 116 |
476560 | 476560 | 2020-08-28 | Lake | Florida | 12069 | 6275 | 103 |
473327 | 473327 | 2020-08-27 | Lake | Florida | 12069 | 6213 | 99 |
470095 | 470095 | 2020-08-26 | Lake | Florida | 12069 | 6163 | 98 |
466866 | 466866 | 2020-08-25 | Lake | Florida | 12069 | 6122 | 96 |
463637 | 463637 | 2020-08-24 | Lake | Florida | 12069 | 6089 | 93 |
460408 | 460408 | 2020-08-23 | Lake | Florida | 12069 | 6046 | 93 |
457181 | 457181 | 2020-08-22 | Lake | Florida | 12069 | 6004 | 93 |
453953 | 453953 | 2020-08-21 | Lake | Florida | 12069 | 5947 | 91 |
450725 | 450725 | 2020-08-20 | Lake | Florida | 12069 | 5852 | 91 |
447497 | 447497 | 2020-08-19 | Lake | Florida | 12069 | 5756 | 91 |
444270 | 444270 | 2020-08-18 | Lake | Florida | 12069 | 5698 | 89 |
441044 | 441044 | 2020-08-17 | Lake | Florida | 12069 | 5650 | 86 |
437818 | 437818 | 2020-08-16 | Lake | Florida | 12069 | 5619 | 83 |
434592 | 434592 | 2020-08-15 | Lake | Florida | 12069 | 5587 | 82 |
431367 | 431367 | 2020-08-14 | Lake | Florida | 12069 | 5489 | 79 |
428139 | 428139 | 2020-08-13 | Lake | Florida | 12069 | 5391 | 75 |
424915 | 424915 | 2020-08-12 | Lake | Florida | 12069 | 5291 | 74 |
421694 | 421694 | 2020-08-11 | Lake | Florida | 12069 | 5229 | 68 |
418473 | 418473 | 2020-08-10 | Lake | Florida | 12069 | 5177 | 68 |
415252 | 415252 | 2020-08-09 | Lake | Florida | 12069 | 5161 | 68 |
412032 | 412032 | 2020-08-08 | Lake | Florida | 12069 | 5073 | 67 |
408813 | 408813 | 2020-08-07 | Lake | Florida | 12069 | 4958 | 61 |
405593 | 405593 | 2020-08-06 | Lake | Florida | 12069 | 4840 | 60 |
402375 | 402375 | 2020-08-05 | Lake | Florida | 12069 | 4794 | 59 |
399159 | 399159 | 2020-08-04 | Lake | Florida | 12069 | 4769 | 52 |
395943 | 395943 | 2020-08-03 | Lake | Florida | 12069 | 4708 | 51 |
392727 | 392727 | 2020-08-02 | Lake | Florida | 12069 | 4661 | 51 |
389510 | 389510 | 2020-08-01 | Lake | Florida | 12069 | 4612 | 51 |
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 |
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);