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-12-20 and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2033343 | 2033343 | 2021-12-20 | Baker | Oregon | 41001 | 2273 | 36 |
2033344 | 2033344 | 2021-12-20 | Benton | Oregon | 41003 | 6429 | 42 |
2033345 | 2033345 | 2021-12-20 | Clackamas | Oregon | 41005 | 34186 | 415 |
2033346 | 2033346 | 2021-12-20 | Clatsop | Oregon | 41007 | 2766 | 35 |
2033347 | 2033347 | 2021-12-20 | Columbia | Oregon | 41009 | 4695 | 60 |
2033348 | 2033348 | 2021-12-20 | Coos | Oregon | 41011 | 6138 | 115 |
2033349 | 2033349 | 2021-12-20 | Crook | Oregon | 41013 | 3542 | 60 |
2033350 | 2033350 | 2021-12-20 | Curry | Oregon | 41015 | 1970 | 39 |
2033351 | 2033351 | 2021-12-20 | Deschutes | Oregon | 41017 | 24694 | 207 |
2033352 | 2033352 | 2021-12-20 | Douglas | Oregon | 41019 | 14013 | 310 |
2033353 | 2033353 | 2021-12-20 | Gilliam | Oregon | 41021 | 191 | 4 |
2033354 | 2033354 | 2021-12-20 | Grant | Oregon | 41023 | 1109 | 17 |
2033355 | 2033355 | 2021-12-20 | Harney | Oregon | 41025 | 1238 | 33 |
2033356 | 2033356 | 2021-12-20 | Hood River | Oregon | 41027 | 2227 | 38 |
2033357 | 2033357 | 2021-12-20 | Jackson | Oregon | 41029 | 25828 | 378 |
2033358 | 2033358 | 2021-12-20 | Jefferson | Oregon | 41031 | 4343 | 69 |
2033359 | 2033359 | 2021-12-20 | Josephine | Oregon | 41033 | 10678 | 259 |
2033360 | 2033360 | 2021-12-20 | Klamath | Oregon | 41035 | 9243 | 163 |
2033361 | 2033361 | 2021-12-20 | Lake | Oregon | 41037 | 1071 | 21 |
2033362 | 2033362 | 2021-12-20 | Lane | Oregon | 41039 | 31236 | 376 |
2033363 | 2033363 | 2021-12-20 | Lincoln | Oregon | 41041 | 3800 | 58 |
2033364 | 2033364 | 2021-12-20 | Linn | Oregon | 41043 | 15508 | 200 |
2033365 | 2033365 | 2021-12-20 | Malheur | Oregon | 41045 | 5967 | 94 |
2033366 | 2033366 | 2021-12-20 | Marion | Oregon | 41047 | 41153 | 540 |
2033367 | 2033367 | 2021-12-20 | Morrow | Oregon | 41049 | 2009 | 25 |
2033368 | 2033368 | 2021-12-20 | Multnomah | Oregon | 41051 | 62698 | 891 |
2033369 | 2033369 | 2021-12-20 | Polk | Oregon | 41053 | 8608 | 109 |
2033370 | 2033370 | 2021-12-20 | Sherman | Oregon | 41055 | 196 | 3 |
2033371 | 2033371 | 2021-12-20 | Tillamook | Oregon | 41057 | 2332 | 48 |
2033372 | 2033372 | 2021-12-20 | Umatilla | Oregon | 41059 | 15287 | 186 |
2033373 | 2033373 | 2021-12-20 | Union | Oregon | 41061 | 3470 | 59 |
2033374 | 2033374 | 2021-12-20 | Wallowa | Oregon | 41063 | 771 | 13 |
2033375 | 2033375 | 2021-12-20 | Wasco | Oregon | 41065 | 3257 | 48 |
2033376 | 2033376 | 2021-12-20 | Washington | Oregon | 41067 | 43875 | 429 |
2033377 | 2033377 | 2021-12-20 | Wheeler | Oregon | 41069 | 138 | 1 |
2033378 | 2033378 | 2021-12-20 | Yamhill | Oregon | 41071 | 10214 | 153 |
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);