ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
27,784 rows where state = "Oregon" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 37
- 41067 806
- 41029 798
- 41035 798
- 41019 797
- 41047 797
- 41051 795
- 41017 794
- 41043 794
- 41053 794
- 41059 794
- 41005 793
- 41071 790
- 41003 789
- 41039 788
- 41023 785
- 41061 785
- 41033 784
- 41027 782
- 41007 781
- 41041 780
- 41057 779
- 41065 779
- 41009 778
- 41049 778
- 41045 774
- 41063 774
- 41013 771
- 41055 769
- 41015 768
- 41011 763
- 41031 760
- 41025 746
- 41037 717
- 41021 679
- 41001 638
- 41069 580
- - 7
county 37
- Washington 806
- Jackson 798
- Klamath 798
- Douglas 797
- Marion 797
- Multnomah 795
- Deschutes 794
- Linn 794
- Polk 794
- Umatilla 794
- Clackamas 793
- Yamhill 790
- Benton 789
- Lane 788
- Grant 785
- Union 785
- Josephine 784
- Hood River 782
- Clatsop 781
- Lincoln 780
- Tillamook 779
- Wasco 779
- Columbia 778
- Morrow 778
- Malheur 774
- Wallowa 774
- Crook 771
- Sherman 769
- Curry 768
- Coos 763
- Jefferson 760
- Harney 746
- Lake 717
- Gilliam 679
- Baker 638
- Wheeler 580
- Unknown 7
state 1
- Oregon · 27,684 ✖
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
433222 | 433222 | 2020-08-14 | Baker | Oregon | 41001 | 52 | 0 |
436449 | 436449 | 2020-08-15 | Baker | Oregon | 41001 | 53 | 0 |
439674 | 439674 | 2020-08-16 | Baker | Oregon | 41001 | 53 | 0 |
442901 | 442901 | 2020-08-17 | Baker | Oregon | 41001 | 53 | 0 |
446127 | 446127 | 2020-08-18 | Baker | Oregon | 41001 | 54 | 0 |
449355 | 449355 | 2020-08-19 | Baker | Oregon | 41001 | 55 | 0 |
452583 | 452583 | 2020-08-20 | Baker | Oregon | 41001 | 55 | 1 |
455811 | 455811 | 2020-08-21 | Baker | Oregon | 41001 | 55 | 1 |
459039 | 459039 | 2020-08-22 | Baker | Oregon | 41001 | 64 | 1 |
462267 | 462267 | 2020-08-23 | Baker | Oregon | 41001 | 64 | 1 |
465496 | 465496 | 2020-08-24 | Baker | Oregon | 41001 | 64 | 1 |
468724 | 468724 | 2020-08-25 | Baker | Oregon | 41001 | 67 | 1 |
471956 | 471956 | 2020-08-26 | Baker | Oregon | 41001 | 67 | 2 |
475190 | 475190 | 2020-08-27 | Baker | Oregon | 41001 | 67 | 2 |
478423 | 478423 | 2020-08-28 | Baker | Oregon | 41001 | 68 | 2 |
481657 | 481657 | 2020-08-29 | Baker | Oregon | 41001 | 70 | 2 |
484892 | 484892 | 2020-08-30 | Baker | Oregon | 41001 | 70 | 2 |
488125 | 488125 | 2020-08-31 | Baker | Oregon | 41001 | 70 | 2 |
491358 | 491358 | 2020-09-01 | Baker | Oregon | 41001 | 74 | 2 |
494592 | 494592 | 2020-09-02 | Baker | Oregon | 41001 | 75 | 2 |
497825 | 497825 | 2020-09-03 | Baker | Oregon | 41001 | 77 | 2 |
501059 | 501059 | 2020-09-04 | Baker | Oregon | 41001 | 77 | 2 |
504293 | 504293 | 2020-09-05 | Baker | Oregon | 41001 | 77 | 2 |
507525 | 507525 | 2020-09-06 | Baker | Oregon | 41001 | 77 | 2 |
510758 | 510758 | 2020-09-07 | Baker | Oregon | 41001 | 86 | 2 |
513991 | 513991 | 2020-09-08 | Baker | Oregon | 41001 | 86 | 2 |
517226 | 517226 | 2020-09-09 | Baker | Oregon | 41001 | 86 | 2 |
520462 | 520462 | 2020-09-10 | Baker | Oregon | 41001 | 86 | 2 |
523698 | 523698 | 2020-09-11 | Baker | Oregon | 41001 | 88 | 2 |
526934 | 526934 | 2020-09-12 | Baker | Oregon | 41001 | 90 | 2 |
530171 | 530171 | 2020-09-13 | Baker | Oregon | 41001 | 90 | 2 |
533406 | 533406 | 2020-09-14 | Baker | Oregon | 41001 | 90 | 2 |
536642 | 536642 | 2020-09-15 | Baker | Oregon | 41001 | 90 | 2 |
539879 | 539879 | 2020-09-16 | Baker | Oregon | 41001 | 89 | 2 |
543115 | 543115 | 2020-09-17 | Baker | Oregon | 41001 | 89 | 2 |
546352 | 546352 | 2020-09-18 | Baker | Oregon | 41001 | 90 | 2 |
549591 | 549591 | 2020-09-19 | Baker | Oregon | 41001 | 90 | 2 |
552830 | 552830 | 2020-09-20 | Baker | Oregon | 41001 | 90 | 2 |
556067 | 556067 | 2020-09-21 | Baker | Oregon | 41001 | 90 | 2 |
559304 | 559304 | 2020-09-22 | Baker | Oregon | 41001 | 90 | 2 |
562541 | 562541 | 2020-09-23 | Baker | Oregon | 41001 | 91 | 2 |
565782 | 565782 | 2020-09-24 | Baker | Oregon | 41001 | 92 | 2 |
569023 | 569023 | 2020-09-25 | Baker | Oregon | 41001 | 92 | 2 |
572265 | 572265 | 2020-09-26 | Baker | Oregon | 41001 | 94 | 2 |
575509 | 575509 | 2020-09-27 | Baker | Oregon | 41001 | 94 | 2 |
578750 | 578750 | 2020-09-28 | Baker | Oregon | 41001 | 94 | 2 |
581990 | 581990 | 2020-09-29 | Baker | Oregon | 41001 | 95 | 2 |
585230 | 585230 | 2020-09-30 | Baker | Oregon | 41001 | 98 | 2 |
588470 | 588470 | 2020-10-01 | Baker | Oregon | 41001 | 99 | 2 |
591711 | 591711 | 2020-10-02 | Baker | Oregon | 41001 | 100 | 2 |
594952 | 594952 | 2020-10-03 | Baker | Oregon | 41001 | 101 | 2 |
598195 | 598195 | 2020-10-04 | Baker | Oregon | 41001 | 101 | 2 |
601438 | 601438 | 2020-10-05 | Baker | Oregon | 41001 | 101 | 2 |
604680 | 604680 | 2020-10-06 | Baker | Oregon | 41001 | 102 | 2 |
607923 | 607923 | 2020-10-07 | Baker | Oregon | 41001 | 105 | 2 |
611165 | 611165 | 2020-10-08 | Baker | Oregon | 41001 | 106 | 2 |
614406 | 614406 | 2020-10-09 | Baker | Oregon | 41001 | 107 | 2 |
617648 | 617648 | 2020-10-10 | Baker | Oregon | 41001 | 111 | 2 |
620890 | 620890 | 2020-10-11 | Baker | Oregon | 41001 | 111 | 2 |
624133 | 624133 | 2020-10-12 | Baker | Oregon | 41001 | 111 | 2 |
627375 | 627375 | 2020-10-13 | Baker | Oregon | 41001 | 111 | 2 |
630619 | 630619 | 2020-10-14 | Baker | Oregon | 41001 | 111 | 2 |
633864 | 633864 | 2020-10-15 | Baker | Oregon | 41001 | 111 | 2 |
637110 | 637110 | 2020-10-16 | Baker | Oregon | 41001 | 111 | 2 |
640356 | 640356 | 2020-10-17 | Baker | Oregon | 41001 | 112 | 2 |
643604 | 643604 | 2020-10-18 | Baker | Oregon | 41001 | 112 | 2 |
646850 | 646850 | 2020-10-19 | Baker | Oregon | 41001 | 112 | 2 |
650094 | 650094 | 2020-10-20 | Baker | Oregon | 41001 | 112 | 2 |
653339 | 653339 | 2020-10-21 | Baker | Oregon | 41001 | 113 | 2 |
656584 | 656584 | 2020-10-22 | Baker | Oregon | 41001 | 113 | 3 |
659828 | 659828 | 2020-10-23 | Baker | Oregon | 41001 | 114 | 3 |
663072 | 663072 | 2020-10-24 | Baker | Oregon | 41001 | 114 | 3 |
666317 | 666317 | 2020-10-25 | Baker | Oregon | 41001 | 120 | 3 |
669561 | 669561 | 2020-10-26 | Baker | Oregon | 41001 | 120 | 3 |
672803 | 672803 | 2020-10-27 | Baker | Oregon | 41001 | 125 | 3 |
676046 | 676046 | 2020-10-28 | Baker | Oregon | 41001 | 133 | 3 |
679289 | 679289 | 2020-10-29 | Baker | Oregon | 41001 | 140 | 3 |
682532 | 682532 | 2020-10-30 | Baker | Oregon | 41001 | 143 | 3 |
685775 | 685775 | 2020-10-31 | Baker | Oregon | 41001 | 144 | 3 |
689020 | 689020 | 2020-11-01 | Baker | Oregon | 41001 | 144 | 3 |
692264 | 692264 | 2020-11-02 | Baker | Oregon | 41001 | 144 | 3 |
695506 | 695506 | 2020-11-03 | Baker | Oregon | 41001 | 152 | 3 |
698749 | 698749 | 2020-11-04 | Baker | Oregon | 41001 | 159 | 3 |
701993 | 701993 | 2020-11-05 | Baker | Oregon | 41001 | 172 | 3 |
705236 | 705236 | 2020-11-06 | Baker | Oregon | 41001 | 176 | 3 |
708479 | 708479 | 2020-11-07 | Baker | Oregon | 41001 | 181 | 3 |
711723 | 711723 | 2020-11-08 | Baker | Oregon | 41001 | 181 | 3 |
714967 | 714967 | 2020-11-09 | Baker | Oregon | 41001 | 182 | 3 |
718210 | 718210 | 2020-11-10 | Baker | Oregon | 41001 | 189 | 3 |
721453 | 721453 | 2020-11-11 | Baker | Oregon | 41001 | 197 | 3 |
724696 | 724696 | 2020-11-12 | Baker | Oregon | 41001 | 198 | 3 |
727940 | 727940 | 2020-11-13 | Baker | Oregon | 41001 | 204 | 3 |
731184 | 731184 | 2020-11-14 | Baker | Oregon | 41001 | 215 | 3 |
734430 | 734430 | 2020-11-15 | Baker | Oregon | 41001 | 215 | 3 |
737674 | 737674 | 2020-11-16 | Baker | Oregon | 41001 | 223 | 3 |
740920 | 740920 | 2020-11-17 | Baker | Oregon | 41001 | 227 | 3 |
744167 | 744167 | 2020-11-18 | Baker | Oregon | 41001 | 236 | 3 |
747413 | 747413 | 2020-11-19 | Baker | Oregon | 41001 | 240 | 3 |
750659 | 750659 | 2020-11-20 | Baker | Oregon | 41001 | 248 | 3 |
753905 | 753905 | 2020-11-21 | Baker | Oregon | 41001 | 257 | 3 |
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);