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-07-08 and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1497257 | 1497257 | 2021-07-08 | Baker | Oregon | 41001 | 1042 | 15 |
1497258 | 1497258 | 2021-07-08 | Benton | Oregon | 41003 | 3299 | 22 |
1497259 | 1497259 | 2021-07-08 | Clackamas | Oregon | 41005 | 19222 | 240 |
1497260 | 1497260 | 2021-07-08 | Clatsop | Oregon | 41007 | 1086 | 9 |
1497261 | 1497261 | 2021-07-08 | Columbia | Oregon | 41009 | 1971 | 30 |
1497262 | 1497262 | 2021-07-08 | Coos | Oregon | 41011 | 2202 | 39 |
1497263 | 1497263 | 2021-07-08 | Crook | Oregon | 41013 | 1317 | 23 |
1497264 | 1497264 | 2021-07-08 | Curry | Oregon | 41015 | 746 | 12 |
1497265 | 1497265 | 2021-07-08 | Deschutes | Oregon | 41017 | 10167 | 82 |
1497266 | 1497266 | 2021-07-08 | Douglas | Oregon | 41019 | 4030 | 84 |
1497267 | 1497267 | 2021-07-08 | Gilliam | Oregon | 41021 | 82 | 1 |
1497268 | 1497268 | 2021-07-08 | Grant | Oregon | 41023 | 553 | 7 |
1497269 | 1497269 | 2021-07-08 | Harney | Oregon | 41025 | 440 | 11 |
1497270 | 1497270 | 2021-07-08 | Hood River | Oregon | 41027 | 1234 | 34 |
1497271 | 1497271 | 2021-07-08 | Jackson | Oregon | 41029 | 11724 | 148 |
1497272 | 1497272 | 2021-07-08 | Jefferson | Oregon | 41031 | 2403 | 42 |
1497273 | 1497273 | 2021-07-08 | Josephine | Oregon | 41033 | 3710 | 73 |
1497274 | 1497274 | 2021-07-08 | Klamath | Oregon | 41035 | 4831 | 79 |
1497275 | 1497275 | 2021-07-08 | Lake | Oregon | 41037 | 473 | 8 |
1497276 | 1497276 | 2021-07-08 | Lane | Oregon | 41039 | 14132 | 169 |
1497277 | 1497277 | 2021-07-08 | Lincoln | Oregon | 41041 | 1467 | 22 |
1497278 | 1497278 | 2021-07-08 | Linn | Oregon | 41043 | 5827 | 81 |
1497279 | 1497279 | 2021-07-08 | Malheur | Oregon | 41045 | 3624 | 64 |
1497280 | 1497280 | 2021-07-08 | Marion | Oregon | 41047 | 23746 | 327 |
1497281 | 1497281 | 2021-07-08 | Morrow | Oregon | 41049 | 1170 | 16 |
1497282 | 1497282 | 2021-07-08 | Multnomah | Oregon | 41051 | 40798 | 639 |
1497283 | 1497283 | 2021-07-08 | Polk | Oregon | 41053 | 4093 | 56 |
1497284 | 1497284 | 2021-07-08 | Sherman | Oregon | 41055 | 71 | 1 |
1497285 | 1497285 | 2021-07-08 | Tillamook | Oregon | 41057 | 691 | 4 |
1497286 | 1497286 | 2021-07-08 | Umatilla | Oregon | 41059 | 8760 | 88 |
1497287 | 1497287 | 2021-07-08 | Union | Oregon | 41061 | 1532 | 24 |
1497288 | 1497288 | 2021-07-08 | Wallowa | Oregon | 41063 | 197 | 5 |
1497289 | 1497289 | 2021-07-08 | Wasco | Oregon | 41065 | 1468 | 30 |
1497290 | 1497290 | 2021-07-08 | Washington | Oregon | 41067 | 27038 | 253 |
1497291 | 1497291 | 2021-07-08 | Wheeler | Oregon | 41069 | 35 | 1 |
1497292 | 1497292 | 2021-07-08 | Yamhill | Oregon | 41071 | 4861 | 80 |
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);