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-29 and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1965082 | 1965082 | 2021-11-29 | Baker | Oregon | 41001 | 2191 | 33 |
1965083 | 1965083 | 2021-11-29 | Benton | Oregon | 41003 | 6083 | 38 |
1965084 | 1965084 | 2021-11-29 | Clackamas | Oregon | 41005 | 32722 | 377 |
1965085 | 1965085 | 2021-11-29 | Clatsop | Oregon | 41007 | 2612 | 35 |
1965086 | 1965086 | 2021-11-29 | Columbia | Oregon | 41009 | 4292 | 55 |
1965087 | 1965087 | 2021-11-29 | Coos | Oregon | 41011 | 5600 | 106 |
1965088 | 1965088 | 2021-11-29 | Crook | Oregon | 41013 | 3323 | 56 |
1965089 | 1965089 | 2021-11-29 | Curry | Oregon | 41015 | 1910 | 39 |
1965090 | 1965090 | 2021-11-29 | Deschutes | Oregon | 41017 | 23460 | 185 |
1965091 | 1965091 | 2021-11-29 | Douglas | Oregon | 41019 | 13323 | 287 |
1965092 | 1965092 | 2021-11-29 | Gilliam | Oregon | 41021 | 185 | 4 |
1965093 | 1965093 | 2021-11-29 | Grant | Oregon | 41023 | 1085 | 15 |
1965094 | 1965094 | 2021-11-29 | Harney | Oregon | 41025 | 1195 | 32 |
1965095 | 1965095 | 2021-11-29 | Hood River | Oregon | 41027 | 2119 | 37 |
1965096 | 1965096 | 2021-11-29 | Jackson | Oregon | 41029 | 24808 | 357 |
1965097 | 1965097 | 2021-11-29 | Jefferson | Oregon | 41031 | 4193 | 66 |
1965098 | 1965098 | 2021-11-29 | Josephine | Oregon | 41033 | 10134 | 242 |
1965099 | 1965099 | 2021-11-29 | Klamath | Oregon | 41035 | 9002 | 145 |
1965100 | 1965100 | 2021-11-29 | Lake | Oregon | 41037 | 1042 | 16 |
1965101 | 1965101 | 2021-11-29 | Lane | Oregon | 41039 | 30033 | 354 |
1965102 | 1965102 | 2021-11-29 | Lincoln | Oregon | 41041 | 3607 | 52 |
1965103 | 1965103 | 2021-11-29 | Linn | Oregon | 41043 | 14610 | 179 |
1965104 | 1965104 | 2021-11-29 | Malheur | Oregon | 41045 | 5920 | 86 |
1965105 | 1965105 | 2021-11-29 | Marion | Oregon | 41047 | 39824 | 506 |
1965106 | 1965106 | 2021-11-29 | Morrow | Oregon | 41049 | 1971 | 25 |
1965107 | 1965107 | 2021-11-29 | Multnomah | Oregon | 41051 | 60179 | 836 |
1965108 | 1965108 | 2021-11-29 | Polk | Oregon | 41053 | 8162 | 100 |
1965109 | 1965109 | 2021-11-29 | Sherman | Oregon | 41055 | 190 | 3 |
1965110 | 1965110 | 2021-11-29 | Tillamook | Oregon | 41057 | 2163 | 45 |
1965111 | 1965111 | 2021-11-29 | Umatilla | Oregon | 41059 | 15098 | 180 |
1965112 | 1965112 | 2021-11-29 | Union | Oregon | 41061 | 3386 | 54 |
1965113 | 1965113 | 2021-11-29 | Wallowa | Oregon | 41063 | 754 | 13 |
1965114 | 1965114 | 2021-11-29 | Wasco | Oregon | 41065 | 3149 | 46 |
1965115 | 1965115 | 2021-11-29 | Washington | Oregon | 41067 | 41910 | 395 |
1965116 | 1965116 | 2021-11-29 | Wheeler | Oregon | 41069 | 114 | 1 |
1965117 | 1965117 | 2021-11-29 | Yamhill | Oregon | 41071 | 9717 | 142 |
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);