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 2022-02-01 and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2173173 | 2173173 | 2022-02-01 | Baker | Oregon | 41001 | 2962 | 42 |
2173174 | 2173174 | 2022-02-01 | Benton | Oregon | 41003 | 13116 | 53 |
2173175 | 2173175 | 2022-02-01 | Clackamas | Oregon | 41005 | 54975 | 482 |
2173176 | 2173176 | 2022-02-01 | Clatsop | Oregon | 41007 | 4116 | 37 |
2173177 | 2173177 | 2022-02-01 | Columbia | Oregon | 41009 | 6722 | 69 |
2173178 | 2173178 | 2022-02-01 | Coos | Oregon | 41011 | 9522 | 132 |
2173179 | 2173179 | 2022-02-01 | Crook | Oregon | 41013 | 5411 | 64 |
2173180 | 2173180 | 2022-02-01 | Curry | Oregon | 41015 | 2887 | 41 |
2173181 | 2173181 | 2022-02-01 | Deschutes | Oregon | 41017 | 42026 | 232 |
2173182 | 2173182 | 2022-02-01 | Douglas | Oregon | 41019 | 17851 | 333 |
2173183 | 2173183 | 2022-02-01 | Gilliam | Oregon | 41021 | 259 | 4 |
2173184 | 2173184 | 2022-02-01 | Grant | Oregon | 41023 | 1479 | 18 |
2173185 | 2173185 | 2022-02-01 | Harney | Oregon | 41025 | 1437 | 35 |
2173186 | 2173186 | 2022-02-01 | Hood River | Oregon | 41027 | 3203 | 40 |
2173187 | 2173187 | 2022-02-01 | Jackson | Oregon | 41029 | 38494 | 437 |
2173188 | 2173188 | 2022-02-01 | Jefferson | Oregon | 41031 | 6575 | 72 |
2173189 | 2173189 | 2022-02-01 | Josephine | Oregon | 41033 | 14529 | 302 |
2173190 | 2173190 | 2022-02-01 | Klamath | Oregon | 41035 | 12797 | 182 |
2173191 | 2173191 | 2022-02-01 | Lake | Oregon | 41037 | 1254 | 23 |
2173192 | 2173192 | 2022-02-01 | Lane | Oregon | 41039 | 50618 | 412 |
2173193 | 2173193 | 2022-02-01 | Lincoln | Oregon | 41041 | 6036 | 65 |
2173194 | 2173194 | 2022-02-01 | Linn | Oregon | 41043 | 23412 | 223 |
2173195 | 2173195 | 2022-02-01 | Malheur | Oregon | 41045 | 7746 | 98 |
2173196 | 2173196 | 2022-02-01 | Marion | Oregon | 41047 | 63006 | 582 |
2173197 | 2173197 | 2022-02-01 | Morrow | Oregon | 41049 | 2850 | 26 |
2173198 | 2173198 | 2022-02-01 | Multnomah | Oregon | 41051 | 103280 | 964 |
2173199 | 2173199 | 2022-02-01 | Polk | Oregon | 41053 | 13630 | 117 |
2173200 | 2173200 | 2022-02-01 | Sherman | Oregon | 41055 | 290 | 3 |
2173201 | 2173201 | 2022-02-01 | Tillamook | Oregon | 41057 | 3264 | 54 |
2173202 | 2173202 | 2022-02-01 | Umatilla | Oregon | 41059 | 21164 | 194 |
2173203 | 2173203 | 2022-02-01 | Union | Oregon | 41061 | 4647 | 66 |
2173204 | 2173204 | 2022-02-01 | Wallowa | Oregon | 41063 | 1133 | 14 |
2173205 | 2173205 | 2022-02-01 | Wasco | Oregon | 41065 | 4654 | 53 |
2173206 | 2173206 | 2022-02-01 | Washington | Oregon | 41067 | 77335 | 475 |
2173207 | 2173207 | 2022-02-01 | Wheeler | Oregon | 41069 | 207 | 3 |
2173208 | 2173208 | 2022-02-01 | Yamhill | Oregon | 41071 | 15936 | 177 |
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);