ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

27,784 rows where state = "Oregon" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips >30

county >30

state 1

  • Oregon · 27,784 ✖
Link rowid date ▲ county state fips cases deaths
2501811 2501811 2022-05-13 Baker Oregon 41001 3231 48
2501812 2501812 2022-05-13 Benton Oregon 41003 16301 71
2501813 2501813 2022-05-13 Clackamas Oregon 41005 63827 632
2501814 2501814 2022-05-13 Clatsop Oregon 41007 4810 50
2501815 2501815 2022-05-13 Columbia Oregon 41009 7987 95
2501816 2501816 2022-05-13 Coos Oregon 41011 10849 153
2501817 2501817 2022-05-13 Crook Oregon 41013 6158 79
2501818 2501818 2022-05-13 Curry Oregon 41015 3385 54
2501819 2501819 2022-05-13 Deschutes Oregon 41017 47906 286
2501820 2501820 2022-05-13 Douglas Oregon 41019 20020 396
2501821 2501821 2022-05-13 Gilliam Oregon 41021 284 5
2501822 2501822 2022-05-13 Grant Oregon 41023 1704 21
2501823 2501823 2022-05-13 Harney Oregon 41025 1617 38
2501824 2501824 2022-05-13 Hood River Oregon 41027 3698 44
2501825 2501825 2022-05-13 Jackson Oregon 41029 43552 535
2501826 2501826 2022-05-13 Jefferson Oregon 41031 7319 92
2501827 2501827 2022-05-13 Josephine Oregon 41033 16627 339
2501828 2501828 2022-05-13 Klamath Oregon 41035 14285 222
2501829 2501829 2022-05-13 Lake Oregon 41037 1429 29
2501830 2501830 2022-05-13 Lane Oregon 41039 59853 541
2501831 2501831 2022-05-13 Lincoln Oregon 41041 7223 85
2501832 2501832 2022-05-13 Linn Oregon 41043 27257 268
2501833 2501833 2022-05-13 Malheur Oregon 41045 8251 108
2501834 2501834 2022-05-13 Marion Oregon 41047 70744 721
2501835 2501835 2022-05-13 Morrow Oregon 41049 2980 34
2501836 2501836 2022-05-13 Multnomah Oregon 41051 123906 1207
2501837 2501837 2022-05-13 Polk Oregon 41053 15778 134
2501838 2501838 2022-05-13 Sherman Oregon 41055 321 6
2501839 2501839 2022-05-13 Tillamook Oregon 41057 3827 64
2501840 2501840 2022-05-13 Umatilla Oregon 41059 22545 225
2501841 2501841 2022-05-13 Union Oregon 41061 5068 80
2501842 2501842 2022-05-13 Wallowa Oregon 41063 1267 16
2501843 2501843 2022-05-13 Wasco Oregon 41065 5218 63
2501844 2501844 2022-05-13 Washington Oregon 41067 91092 594
2501845 2501845 2022-05-13 Wheeler Oregon 41069 246 3
2501846 2501846 2022-05-13 Yamhill Oregon 41071 18265 222
2498553 2498553 2022-05-12 Baker Oregon 41001 3230 48
2498554 2498554 2022-05-12 Benton Oregon 41003 16234 71
2498555 2498555 2022-05-12 Clackamas Oregon 41005 63625 632
2498556 2498556 2022-05-12 Clatsop Oregon 41007 4799 50
2498557 2498557 2022-05-12 Columbia Oregon 41009 7967 95
2498558 2498558 2022-05-12 Coos Oregon 41011 10837 153
2498559 2498559 2022-05-12 Crook Oregon 41013 6153 79
2498560 2498560 2022-05-12 Curry Oregon 41015 3385 54
2498561 2498561 2022-05-12 Deschutes Oregon 41017 47807 286
2498562 2498562 2022-05-12 Douglas Oregon 41019 19991 396
2498563 2498563 2022-05-12 Gilliam Oregon 41021 284 5
2498564 2498564 2022-05-12 Grant Oregon 41023 1704 21
2498565 2498565 2022-05-12 Harney Oregon 41025 1615 38
2498566 2498566 2022-05-12 Hood River Oregon 41027 3683 43
2498567 2498567 2022-05-12 Jackson Oregon 41029 43516 534
2498568 2498568 2022-05-12 Jefferson Oregon 41031 7315 92
2498569 2498569 2022-05-12 Josephine Oregon 41033 16613 339
2498570 2498570 2022-05-12 Klamath Oregon 41035 14283 222
2498571 2498571 2022-05-12 Lake Oregon 41037 1428 29
2498572 2498572 2022-05-12 Lane Oregon 41039 59691 540
2498573 2498573 2022-05-12 Lincoln Oregon 41041 7211 85
2498574 2498574 2022-05-12 Linn Oregon 41043 27219 268
2498575 2498575 2022-05-12 Malheur Oregon 41045 8251 108
2498576 2498576 2022-05-12 Marion Oregon 41047 70656 721
2498577 2498577 2022-05-12 Morrow Oregon 41049 2980 34
2498578 2498578 2022-05-12 Multnomah Oregon 41051 123448 1206
2498579 2498579 2022-05-12 Polk Oregon 41053 15749 134
2498580 2498580 2022-05-12 Sherman Oregon 41055 321 6
2498581 2498581 2022-05-12 Tillamook Oregon 41057 3819 64
2498582 2498582 2022-05-12 Umatilla Oregon 41059 22532 225
2498583 2498583 2022-05-12 Union Oregon 41061 5063 80
2498584 2498584 2022-05-12 Wallowa Oregon 41063 1267 16
2498585 2498585 2022-05-12 Wasco Oregon 41065 5212 63
2498586 2498586 2022-05-12 Washington Oregon 41067 90808 594
2498587 2498587 2022-05-12 Wheeler Oregon 41069 246 3
2498588 2498588 2022-05-12 Yamhill Oregon 41071 18244 222
2495295 2495295 2022-05-11 Baker Oregon 41001 3226 48
2495296 2495296 2022-05-11 Benton Oregon 41003 16183 71
2495297 2495297 2022-05-11 Clackamas Oregon 41005 63447 632
2495298 2495298 2022-05-11 Clatsop Oregon 41007 4787 50
2495299 2495299 2022-05-11 Columbia Oregon 41009 7940 95
2495300 2495300 2022-05-11 Coos Oregon 41011 10820 153
2495301 2495301 2022-05-11 Crook Oregon 41013 6146 79
2495302 2495302 2022-05-11 Curry Oregon 41015 3382 54
2495303 2495303 2022-05-11 Deschutes Oregon 41017 47703 286
2495304 2495304 2022-05-11 Douglas Oregon 41019 19977 393
2495305 2495305 2022-05-11 Gilliam Oregon 41021 284 5
2495306 2495306 2022-05-11 Grant Oregon 41023 1702 21
2495307 2495307 2022-05-11 Harney Oregon 41025 1615 38
2495308 2495308 2022-05-11 Hood River Oregon 41027 3677 43
2495309 2495309 2022-05-11 Jackson Oregon 41029 43463 533
2495310 2495310 2022-05-11 Jefferson Oregon 41031 7311 92
2495311 2495311 2022-05-11 Josephine Oregon 41033 16605 339
2495312 2495312 2022-05-11 Klamath Oregon 41035 14276 222
2495313 2495313 2022-05-11 Lake Oregon 41037 1426 29
2495314 2495314 2022-05-11 Lane Oregon 41039 59524 540
2495315 2495315 2022-05-11 Lincoln Oregon 41041 7196 85
2495316 2495316 2022-05-11 Linn Oregon 41043 27174 268
2495317 2495317 2022-05-11 Malheur Oregon 41045 8250 108
2495318 2495318 2022-05-11 Marion Oregon 41047 70564 720
2495319 2495319 2022-05-11 Morrow Oregon 41049 2980 34
2495320 2495320 2022-05-11 Multnomah Oregon 41051 123025 1203
2495321 2495321 2022-05-11 Polk Oregon 41053 15719 134
2495322 2495322 2022-05-11 Sherman Oregon 41055 321 6

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);