ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
717 rows where county = "Lake" and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637128 | 637128 | 2020-10-16 | Lake | Oregon | 41037 | 35 | 0 |
633882 | 633882 | 2020-10-15 | Lake | Oregon | 41037 | 35 | 0 |
630637 | 630637 | 2020-10-14 | Lake | Oregon | 41037 | 35 | 0 |
627393 | 627393 | 2020-10-13 | Lake | Oregon | 41037 | 35 | 0 |
624151 | 624151 | 2020-10-12 | Lake | Oregon | 41037 | 34 | 0 |
620908 | 620908 | 2020-10-11 | Lake | Oregon | 41037 | 34 | 0 |
617666 | 617666 | 2020-10-10 | Lake | Oregon | 41037 | 34 | 0 |
614424 | 614424 | 2020-10-09 | Lake | Oregon | 41037 | 34 | 0 |
611183 | 611183 | 2020-10-08 | Lake | Oregon | 41037 | 34 | 0 |
607941 | 607941 | 2020-10-07 | Lake | Oregon | 41037 | 34 | 0 |
604698 | 604698 | 2020-10-06 | Lake | Oregon | 41037 | 33 | 0 |
601456 | 601456 | 2020-10-05 | Lake | Oregon | 41037 | 33 | 0 |
598213 | 598213 | 2020-10-04 | Lake | Oregon | 41037 | 33 | 0 |
594970 | 594970 | 2020-10-03 | Lake | Oregon | 41037 | 33 | 0 |
591729 | 591729 | 2020-10-02 | Lake | Oregon | 41037 | 33 | 0 |
588488 | 588488 | 2020-10-01 | Lake | Oregon | 41037 | 33 | 0 |
585248 | 585248 | 2020-09-30 | Lake | Oregon | 41037 | 34 | 0 |
582008 | 582008 | 2020-09-29 | Lake | Oregon | 41037 | 33 | 0 |
578768 | 578768 | 2020-09-28 | Lake | Oregon | 41037 | 33 | 0 |
575527 | 575527 | 2020-09-27 | Lake | Oregon | 41037 | 33 | 0 |
572283 | 572283 | 2020-09-26 | Lake | Oregon | 41037 | 32 | 0 |
569041 | 569041 | 2020-09-25 | Lake | Oregon | 41037 | 32 | 0 |
565800 | 565800 | 2020-09-24 | Lake | Oregon | 41037 | 29 | 0 |
562559 | 562559 | 2020-09-23 | Lake | Oregon | 41037 | 28 | 0 |
559322 | 559322 | 2020-09-22 | Lake | Oregon | 41037 | 28 | 0 |
556085 | 556085 | 2020-09-21 | Lake | Oregon | 41037 | 28 | 0 |
552848 | 552848 | 2020-09-20 | Lake | Oregon | 41037 | 29 | 0 |
549609 | 549609 | 2020-09-19 | Lake | Oregon | 41037 | 29 | 0 |
546370 | 546370 | 2020-09-18 | Lake | Oregon | 41037 | 29 | 0 |
543133 | 543133 | 2020-09-17 | Lake | Oregon | 41037 | 29 | 0 |
539897 | 539897 | 2020-09-16 | Lake | Oregon | 41037 | 29 | 0 |
536660 | 536660 | 2020-09-15 | Lake | Oregon | 41037 | 29 | 0 |
533424 | 533424 | 2020-09-14 | Lake | Oregon | 41037 | 29 | 0 |
530189 | 530189 | 2020-09-13 | Lake | Oregon | 41037 | 29 | 0 |
526952 | 526952 | 2020-09-12 | Lake | Oregon | 41037 | 29 | 0 |
523716 | 523716 | 2020-09-11 | Lake | Oregon | 41037 | 29 | 0 |
520480 | 520480 | 2020-09-10 | Lake | Oregon | 41037 | 30 | 0 |
517244 | 517244 | 2020-09-09 | Lake | Oregon | 41037 | 30 | 0 |
514009 | 514009 | 2020-09-08 | Lake | Oregon | 41037 | 30 | 0 |
510776 | 510776 | 2020-09-07 | Lake | Oregon | 41037 | 31 | 0 |
507543 | 507543 | 2020-09-06 | Lake | Oregon | 41037 | 31 | 0 |
504311 | 504311 | 2020-09-05 | Lake | Oregon | 41037 | 31 | 0 |
501077 | 501077 | 2020-09-04 | Lake | Oregon | 41037 | 31 | 0 |
497843 | 497843 | 2020-09-03 | Lake | Oregon | 41037 | 29 | 0 |
494610 | 494610 | 2020-09-02 | Lake | Oregon | 41037 | 29 | 0 |
491376 | 491376 | 2020-09-01 | Lake | Oregon | 41037 | 30 | 0 |
488143 | 488143 | 2020-08-31 | Lake | Oregon | 41037 | 30 | 0 |
484910 | 484910 | 2020-08-30 | Lake | Oregon | 41037 | 30 | 0 |
481675 | 481675 | 2020-08-29 | Lake | Oregon | 41037 | 30 | 0 |
478441 | 478441 | 2020-08-28 | Lake | Oregon | 41037 | 30 | 0 |
475208 | 475208 | 2020-08-27 | Lake | Oregon | 41037 | 30 | 0 |
471974 | 471974 | 2020-08-26 | Lake | Oregon | 41037 | 30 | 0 |
468742 | 468742 | 2020-08-25 | Lake | Oregon | 41037 | 32 | 0 |
465514 | 465514 | 2020-08-24 | Lake | Oregon | 41037 | 32 | 0 |
462285 | 462285 | 2020-08-23 | Lake | Oregon | 41037 | 32 | 0 |
459057 | 459057 | 2020-08-22 | Lake | Oregon | 41037 | 32 | 0 |
455829 | 455829 | 2020-08-21 | Lake | Oregon | 41037 | 32 | 0 |
452601 | 452601 | 2020-08-20 | Lake | Oregon | 41037 | 32 | 0 |
449373 | 449373 | 2020-08-19 | Lake | Oregon | 41037 | 32 | 0 |
446145 | 446145 | 2020-08-18 | Lake | Oregon | 41037 | 32 | 0 |
442919 | 442919 | 2020-08-17 | Lake | Oregon | 41037 | 32 | 0 |
439692 | 439692 | 2020-08-16 | Lake | Oregon | 41037 | 32 | 0 |
436467 | 436467 | 2020-08-15 | Lake | Oregon | 41037 | 32 | 0 |
433240 | 433240 | 2020-08-14 | Lake | Oregon | 41037 | 32 | 0 |
430014 | 430014 | 2020-08-13 | Lake | Oregon | 41037 | 32 | 0 |
426789 | 426789 | 2020-08-12 | Lake | Oregon | 41037 | 32 | 0 |
423566 | 423566 | 2020-08-11 | Lake | Oregon | 41037 | 32 | 0 |
420343 | 420343 | 2020-08-10 | Lake | Oregon | 41037 | 32 | 0 |
417123 | 417123 | 2020-08-09 | Lake | Oregon | 41037 | 32 | 0 |
413902 | 413902 | 2020-08-08 | Lake | Oregon | 41037 | 32 | 0 |
410682 | 410682 | 2020-08-07 | Lake | Oregon | 41037 | 32 | 0 |
407462 | 407462 | 2020-08-06 | Lake | Oregon | 41037 | 32 | 0 |
404243 | 404243 | 2020-08-05 | Lake | Oregon | 41037 | 32 | 0 |
401025 | 401025 | 2020-08-04 | Lake | Oregon | 41037 | 32 | 0 |
397810 | 397810 | 2020-08-03 | Lake | Oregon | 41037 | 32 | 0 |
394593 | 394593 | 2020-08-02 | Lake | Oregon | 41037 | 32 | 0 |
391377 | 391377 | 2020-08-01 | Lake | Oregon | 41037 | 32 | 0 |
388160 | 388160 | 2020-07-31 | Lake | Oregon | 41037 | 32 | 0 |
384943 | 384943 | 2020-07-30 | Lake | Oregon | 41037 | 32 | 0 |
381725 | 381725 | 2020-07-29 | Lake | Oregon | 41037 | 31 | 0 |
378508 | 378508 | 2020-07-28 | Lake | Oregon | 41037 | 31 | 0 |
375292 | 375292 | 2020-07-27 | Lake | Oregon | 41037 | 31 | 0 |
372079 | 372079 | 2020-07-26 | Lake | Oregon | 41037 | 31 | 0 |
368867 | 368867 | 2020-07-25 | Lake | Oregon | 41037 | 31 | 0 |
365658 | 365658 | 2020-07-24 | Lake | Oregon | 41037 | 31 | 0 |
362452 | 362452 | 2020-07-23 | Lake | Oregon | 41037 | 31 | 0 |
359246 | 359246 | 2020-07-22 | Lake | Oregon | 41037 | 30 | 0 |
356042 | 356042 | 2020-07-21 | Lake | Oregon | 41037 | 30 | 0 |
352839 | 352839 | 2020-07-20 | Lake | Oregon | 41037 | 29 | 0 |
349636 | 349636 | 2020-07-19 | Lake | Oregon | 41037 | 28 | 0 |
346436 | 346436 | 2020-07-18 | Lake | Oregon | 41037 | 27 | 0 |
343236 | 343236 | 2020-07-17 | Lake | Oregon | 41037 | 24 | 0 |
340038 | 340038 | 2020-07-16 | Lake | Oregon | 41037 | 24 | 0 |
336841 | 336841 | 2020-07-15 | Lake | Oregon | 41037 | 24 | 0 |
333647 | 333647 | 2020-07-14 | Lake | Oregon | 41037 | 24 | 0 |
330455 | 330455 | 2020-07-13 | Lake | Oregon | 41037 | 24 | 0 |
327269 | 327269 | 2020-07-12 | Lake | Oregon | 41037 | 24 | 0 |
324084 | 324084 | 2020-07-11 | Lake | Oregon | 41037 | 24 | 0 |
320904 | 320904 | 2020-07-10 | Lake | Oregon | 41037 | 24 | 0 |
317726 | 317726 | 2020-07-09 | Lake | Oregon | 41037 | 24 | 0 |
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);