ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
36 rows where "date" is on date 2021-11-23 and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1945575 | 1945575 | 2021-11-23 | Baker | Oregon | 41001 | 2165 | 31 |
1945576 | 1945576 | 2021-11-23 | Benton | Oregon | 41003 | 6040 | 37 |
1945577 | 1945577 | 2021-11-23 | Clackamas | Oregon | 41005 | 32354 | 369 |
1945578 | 1945578 | 2021-11-23 | Clatsop | Oregon | 41007 | 2572 | 35 |
1945579 | 1945579 | 2021-11-23 | Columbia | Oregon | 41009 | 4224 | 53 |
1945580 | 1945580 | 2021-11-23 | Coos | Oregon | 41011 | 5560 | 104 |
1945581 | 1945581 | 2021-11-23 | Crook | Oregon | 41013 | 3294 | 56 |
1945582 | 1945582 | 2021-11-23 | Curry | Oregon | 41015 | 1894 | 35 |
1945583 | 1945583 | 2021-11-23 | Deschutes | Oregon | 41017 | 23095 | 178 |
1945584 | 1945584 | 2021-11-23 | Douglas | Oregon | 41019 | 13199 | 285 |
1945585 | 1945585 | 2021-11-23 | Gilliam | Oregon | 41021 | 184 | 4 |
1945586 | 1945586 | 2021-11-23 | Grant | Oregon | 41023 | 1083 | 14 |
1945587 | 1945587 | 2021-11-23 | Harney | Oregon | 41025 | 1192 | 31 |
1945588 | 1945588 | 2021-11-23 | Hood River | Oregon | 41027 | 2105 | 37 |
1945589 | 1945589 | 2021-11-23 | Jackson | Oregon | 41029 | 24605 | 349 |
1945590 | 1945590 | 2021-11-23 | Jefferson | Oregon | 41031 | 4166 | 65 |
1945591 | 1945591 | 2021-11-23 | Josephine | Oregon | 41033 | 10046 | 237 |
1945592 | 1945592 | 2021-11-23 | Klamath | Oregon | 41035 | 8958 | 144 |
1945593 | 1945593 | 2021-11-23 | Lake | Oregon | 41037 | 1040 | 16 |
1945594 | 1945594 | 2021-11-23 | Lane | Oregon | 41039 | 29790 | 351 |
1945595 | 1945595 | 2021-11-23 | Lincoln | Oregon | 41041 | 3557 | 51 |
1945596 | 1945596 | 2021-11-23 | Linn | Oregon | 41043 | 14438 | 174 |
1945597 | 1945597 | 2021-11-23 | Malheur | Oregon | 41045 | 5908 | 86 |
1945598 | 1945598 | 2021-11-23 | Marion | Oregon | 41047 | 39524 | 500 |
1945599 | 1945599 | 2021-11-23 | Morrow | Oregon | 41049 | 1969 | 25 |
1945600 | 1945600 | 2021-11-23 | Multnomah | Oregon | 41051 | 59683 | 833 |
1945601 | 1945601 | 2021-11-23 | Polk | Oregon | 41053 | 8113 | 98 |
1945602 | 1945602 | 2021-11-23 | Sherman | Oregon | 41055 | 190 | 3 |
1945603 | 1945603 | 2021-11-23 | Tillamook | Oregon | 41057 | 2139 | 43 |
1945604 | 1945604 | 2021-11-23 | Umatilla | Oregon | 41059 | 15072 | 179 |
1945605 | 1945605 | 2021-11-23 | Union | Oregon | 41061 | 3363 | 54 |
1945606 | 1945606 | 2021-11-23 | Wallowa | Oregon | 41063 | 742 | 13 |
1945607 | 1945607 | 2021-11-23 | Wasco | Oregon | 41065 | 3145 | 45 |
1945608 | 1945608 | 2021-11-23 | Washington | Oregon | 41067 | 41476 | 389 |
1945609 | 1945609 | 2021-11-23 | Wheeler | Oregon | 41069 | 114 | 1 |
1945610 | 1945610 | 2021-11-23 | Yamhill | Oregon | 41071 | 9635 | 141 |
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);