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 date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 41067 328
- 41029 320
- 41035 320
- 41019 319
- 41047 319
- 41051 317
- 41017 316
- 41043 316
- 41053 316
- 41059 316
- 41005 315
- 41071 312
- 41003 311
- 41039 310
- 41023 307
- 41061 307
- 41033 306
- 41027 304
- 41007 303
- 41041 302
- 41057 301
- 41065 301
- 41009 300
- 41049 300
- 41045 296
- 41063 296
- 41013 293
- 41055 291
- 41015 290
- 41011 285
- …
county >30
- Washington 328
- Jackson 320
- Klamath 320
- Douglas 319
- Marion 319
- Multnomah 317
- Deschutes 316
- Linn 316
- Polk 316
- Umatilla 316
- Clackamas 315
- Yamhill 312
- Benton 311
- Lane 310
- Grant 307
- Union 307
- Josephine 306
- Hood River 304
- Clatsop 303
- Lincoln 302
- Tillamook 301
- Wasco 301
- Columbia 300
- Morrow 300
- Malheur 296
- Wallowa 296
- Crook 293
- Sherman 291
- Curry 290
- Coos 285
- …
state 1
- Oregon · 10,570 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
948627 | 948627 | 2021-01-20 | Baker | Oregon | 41001 | 576 | 5 |
948628 | 948628 | 2021-01-20 | Benton | Oregon | 41003 | 1743 | 14 |
948629 | 948629 | 2021-01-20 | Clackamas | Oregon | 41005 | 11789 | 142 |
948630 | 948630 | 2021-01-20 | Clatsop | Oregon | 41007 | 692 | 5 |
948631 | 948631 | 2021-01-20 | Columbia | Oregon | 41009 | 1054 | 18 |
948632 | 948632 | 2021-01-20 | Coos | Oregon | 41011 | 952 | 15 |
948633 | 948633 | 2021-01-20 | Crook | Oregon | 41013 | 629 | 11 |
948634 | 948634 | 2021-01-20 | Curry | Oregon | 41015 | 324 | 5 |
948635 | 948635 | 2021-01-20 | Deschutes | Oregon | 41017 | 5073 | 39 |
948636 | 948636 | 2021-01-20 | Douglas | Oregon | 41019 | 1709 | 43 |
948637 | 948637 | 2021-01-20 | Gilliam | Oregon | 41021 | 51 | 1 |
948638 | 948638 | 2021-01-20 | Grant | Oregon | 41023 | 213 | 1 |
948639 | 948639 | 2021-01-20 | Harney | Oregon | 41025 | 178 | 4 |
948640 | 948640 | 2021-01-20 | Hood River | Oregon | 41027 | 961 | 21 |
948641 | 948641 | 2021-01-20 | Jackson | Oregon | 41029 | 7004 | 85 |
948642 | 948642 | 2021-01-20 | Jefferson | Oregon | 41031 | 1712 | 25 |
948643 | 948643 | 2021-01-20 | Josephine | Oregon | 41033 | 1785 | 35 |
948644 | 948644 | 2021-01-20 | Klamath | Oregon | 41035 | 2469 | 44 |
948645 | 948645 | 2021-01-20 | Lake | Oregon | 41037 | 236 | 5 |
948646 | 948646 | 2021-01-20 | Lane | Oregon | 41039 | 8467 | 110 |
948647 | 948647 | 2021-01-20 | Lincoln | Oregon | 41041 | 1004 | 17 |
948648 | 948648 | 2021-01-20 | Linn | Oregon | 41043 | 3149 | 49 |
948649 | 948649 | 2021-01-20 | Malheur | Oregon | 41045 | 3164 | 53 |
948650 | 948650 | 2021-01-20 | Marion | Oregon | 41047 | 16394 | 242 |
948651 | 948651 | 2021-01-20 | Morrow | Oregon | 41049 | 945 | 10 |
948652 | 948652 | 2021-01-20 | Multnomah | Oregon | 41051 | 28678 | 464 |
948653 | 948653 | 2021-01-20 | Polk | Oregon | 41053 | 2492 | 40 |
948654 | 948654 | 2021-01-20 | Sherman | Oregon | 41055 | 47 | 0 |
948655 | 948655 | 2021-01-20 | Tillamook | Oregon | 41057 | 369 | 2 |
948656 | 948656 | 2021-01-20 | Umatilla | Oregon | 41059 | 6856 | 71 |
948657 | 948657 | 2021-01-20 | Union | Oregon | 41061 | 1125 | 16 |
948658 | 948658 | 2021-01-20 | Wallowa | Oregon | 41063 | 97 | 3 |
948659 | 948659 | 2021-01-20 | Wasco | Oregon | 41065 | 1091 | 23 |
948660 | 948660 | 2021-01-20 | Washington | Oregon | 41067 | 18867 | 175 |
948661 | 948661 | 2021-01-20 | Wheeler | Oregon | 41069 | 20 | 1 |
948662 | 948662 | 2021-01-20 | Yamhill | Oregon | 41071 | 3228 | 47 |
945381 | 945381 | 2021-01-19 | Baker | Oregon | 41001 | 573 | 5 |
945382 | 945382 | 2021-01-19 | Benton | Oregon | 41003 | 1720 | 14 |
945383 | 945383 | 2021-01-19 | Clackamas | Oregon | 41005 | 11760 | 141 |
945384 | 945384 | 2021-01-19 | Clatsop | Oregon | 41007 | 687 | 5 |
945385 | 945385 | 2021-01-19 | Columbia | Oregon | 41009 | 1054 | 18 |
945386 | 945386 | 2021-01-19 | Coos | Oregon | 41011 | 941 | 15 |
945387 | 945387 | 2021-01-19 | Crook | Oregon | 41013 | 623 | 10 |
945388 | 945388 | 2021-01-19 | Curry | Oregon | 41015 | 324 | 5 |
945389 | 945389 | 2021-01-19 | Deschutes | Oregon | 41017 | 5036 | 37 |
945390 | 945390 | 2021-01-19 | Douglas | Oregon | 41019 | 1692 | 43 |
945391 | 945391 | 2021-01-19 | Gilliam | Oregon | 41021 | 51 | 1 |
945392 | 945392 | 2021-01-19 | Grant | Oregon | 41023 | 213 | 1 |
945393 | 945393 | 2021-01-19 | Harney | Oregon | 41025 | 175 | 4 |
945394 | 945394 | 2021-01-19 | Hood River | Oregon | 41027 | 955 | 21 |
945395 | 945395 | 2021-01-19 | Jackson | Oregon | 41029 | 6970 | 85 |
945396 | 945396 | 2021-01-19 | Jefferson | Oregon | 41031 | 1707 | 25 |
945397 | 945397 | 2021-01-19 | Josephine | Oregon | 41033 | 1770 | 34 |
945398 | 945398 | 2021-01-19 | Klamath | Oregon | 41035 | 2453 | 38 |
945399 | 945399 | 2021-01-19 | Lake | Oregon | 41037 | 232 | 5 |
945400 | 945400 | 2021-01-19 | Lane | Oregon | 41039 | 8418 | 110 |
945401 | 945401 | 2021-01-19 | Lincoln | Oregon | 41041 | 1001 | 17 |
945402 | 945402 | 2021-01-19 | Linn | Oregon | 41043 | 3123 | 46 |
945403 | 945403 | 2021-01-19 | Malheur | Oregon | 41045 | 3135 | 52 |
945404 | 945404 | 2021-01-19 | Marion | Oregon | 41047 | 16312 | 239 |
945405 | 945405 | 2021-01-19 | Morrow | Oregon | 41049 | 942 | 10 |
945406 | 945406 | 2021-01-19 | Multnomah | Oregon | 41051 | 28586 | 463 |
945407 | 945407 | 2021-01-19 | Polk | Oregon | 41053 | 2469 | 40 |
945408 | 945408 | 2021-01-19 | Sherman | Oregon | 41055 | 47 | 0 |
945409 | 945409 | 2021-01-19 | Tillamook | Oregon | 41057 | 367 | 2 |
945410 | 945410 | 2021-01-19 | Umatilla | Oregon | 41059 | 6803 | 68 |
945411 | 945411 | 2021-01-19 | Union | Oregon | 41061 | 1118 | 16 |
945412 | 945412 | 2021-01-19 | Wallowa | Oregon | 41063 | 96 | 3 |
945413 | 945413 | 2021-01-19 | Wasco | Oregon | 41065 | 1085 | 23 |
945414 | 945414 | 2021-01-19 | Washington | Oregon | 41067 | 18808 | 173 |
945415 | 945415 | 2021-01-19 | Wheeler | Oregon | 41069 | 20 | 1 |
945416 | 945416 | 2021-01-19 | Yamhill | Oregon | 41071 | 3202 | 46 |
942134 | 942134 | 2021-01-18 | Baker | Oregon | 41001 | 568 | 5 |
942135 | 942135 | 2021-01-18 | Benton | Oregon | 41003 | 1705 | 14 |
942136 | 942136 | 2021-01-18 | Clackamas | Oregon | 41005 | 11698 | 141 |
942137 | 942137 | 2021-01-18 | Clatsop | Oregon | 41007 | 686 | 5 |
942138 | 942138 | 2021-01-18 | Columbia | Oregon | 41009 | 1049 | 18 |
942139 | 942139 | 2021-01-18 | Coos | Oregon | 41011 | 938 | 15 |
942140 | 942140 | 2021-01-18 | Crook | Oregon | 41013 | 621 | 10 |
942141 | 942141 | 2021-01-18 | Curry | Oregon | 41015 | 324 | 5 |
942142 | 942142 | 2021-01-18 | Deschutes | Oregon | 41017 | 4999 | 36 |
942143 | 942143 | 2021-01-18 | Douglas | Oregon | 41019 | 1687 | 43 |
942144 | 942144 | 2021-01-18 | Gilliam | Oregon | 41021 | 51 | 1 |
942145 | 942145 | 2021-01-18 | Grant | Oregon | 41023 | 213 | 1 |
942146 | 942146 | 2021-01-18 | Harney | Oregon | 41025 | 175 | 4 |
942147 | 942147 | 2021-01-18 | Hood River | Oregon | 41027 | 954 | 21 |
942148 | 942148 | 2021-01-18 | Jackson | Oregon | 41029 | 6930 | 85 |
942149 | 942149 | 2021-01-18 | Jefferson | Oregon | 41031 | 1705 | 25 |
942150 | 942150 | 2021-01-18 | Josephine | Oregon | 41033 | 1743 | 33 |
942151 | 942151 | 2021-01-18 | Klamath | Oregon | 41035 | 2428 | 38 |
942152 | 942152 | 2021-01-18 | Lake | Oregon | 41037 | 230 | 5 |
942153 | 942153 | 2021-01-18 | Lane | Oregon | 41039 | 8353 | 109 |
942154 | 942154 | 2021-01-18 | Lincoln | Oregon | 41041 | 996 | 17 |
942155 | 942155 | 2021-01-18 | Linn | Oregon | 41043 | 3116 | 46 |
942156 | 942156 | 2021-01-18 | Malheur | Oregon | 41045 | 3135 | 52 |
942157 | 942157 | 2021-01-18 | Marion | Oregon | 41047 | 16247 | 239 |
942158 | 942158 | 2021-01-18 | Morrow | Oregon | 41049 | 938 | 10 |
942159 | 942159 | 2021-01-18 | Multnomah | Oregon | 41051 | 28467 | 463 |
942160 | 942160 | 2021-01-18 | Polk | Oregon | 41053 | 2455 | 40 |
942161 | 942161 | 2021-01-18 | Sherman | Oregon | 41055 | 47 | 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);