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-04-14 and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2407372 | 2407372 | 2022-04-14 | Baker | Oregon | 41001 | 3210 | 48 |
2407373 | 2407373 | 2022-04-14 | Benton | Oregon | 41003 | 15330 | 69 |
2407374 | 2407374 | 2022-04-14 | Clackamas | Oregon | 41005 | 60450 | 616 |
2407375 | 2407375 | 2022-04-14 | Clatsop | Oregon | 41007 | 4622 | 49 |
2407376 | 2407376 | 2022-04-14 | Columbia | Oregon | 41009 | 7599 | 93 |
2407377 | 2407377 | 2022-04-14 | Coos | Oregon | 41011 | 10693 | 152 |
2407378 | 2407378 | 2022-04-14 | Crook | Oregon | 41013 | 6046 | 79 |
2407379 | 2407379 | 2022-04-14 | Curry | Oregon | 41015 | 3353 | 54 |
2407380 | 2407380 | 2022-04-14 | Deschutes | Oregon | 41017 | 46091 | 283 |
2407381 | 2407381 | 2022-04-14 | Douglas | Oregon | 41019 | 19760 | 387 |
2407382 | 2407382 | 2022-04-14 | Gilliam | Oregon | 41021 | 283 | 5 |
2407383 | 2407383 | 2022-04-14 | Grant | Oregon | 41023 | 1687 | 22 |
2407384 | 2407384 | 2022-04-14 | Harney | Oregon | 41025 | 1603 | 38 |
2407385 | 2407385 | 2022-04-14 | Hood River | Oregon | 41027 | 3567 | 43 |
2407386 | 2407386 | 2022-04-14 | Jackson | Oregon | 41029 | 42764 | 526 |
2407387 | 2407387 | 2022-04-14 | Jefferson | Oregon | 41031 | 7230 | 90 |
2407388 | 2407388 | 2022-04-14 | Josephine | Oregon | 41033 | 16360 | 333 |
2407389 | 2407389 | 2022-04-14 | Klamath | Oregon | 41035 | 14136 | 219 |
2407390 | 2407390 | 2022-04-14 | Lake | Oregon | 41037 | 1408 | 27 |
2407391 | 2407391 | 2022-04-14 | Lane | Oregon | 41039 | 57524 | 529 |
2407392 | 2407392 | 2022-04-14 | Lincoln | Oregon | 41041 | 7034 | 84 |
2407393 | 2407393 | 2022-04-14 | Linn | Oregon | 41043 | 26533 | 267 |
2407394 | 2407394 | 2022-04-14 | Malheur | Oregon | 41045 | 8213 | 108 |
2407395 | 2407395 | 2022-04-14 | Marion | Oregon | 41047 | 69047 | 710 |
2407396 | 2407396 | 2022-04-14 | Morrow | Oregon | 41049 | 2953 | 34 |
2407397 | 2407397 | 2022-04-14 | Multnomah | Oregon | 41051 | 114782 | 1189 |
2407398 | 2407398 | 2022-04-14 | Polk | Oregon | 41053 | 15302 | 130 |
2407399 | 2407399 | 2022-04-14 | Sherman | Oregon | 41055 | 318 | 6 |
2407400 | 2407400 | 2022-04-14 | Tillamook | Oregon | 41057 | 3681 | 64 |
2407401 | 2407401 | 2022-04-14 | Umatilla | Oregon | 41059 | 22366 | 214 |
2407402 | 2407402 | 2022-04-14 | Union | Oregon | 41061 | 5022 | 77 |
2407403 | 2407403 | 2022-04-14 | Wallowa | Oregon | 41063 | 1253 | 16 |
2407404 | 2407404 | 2022-04-14 | Wasco | Oregon | 41065 | 5136 | 60 |
2407405 | 2407405 | 2022-04-14 | Washington | Oregon | 41067 | 85756 | 585 |
2407406 | 2407406 | 2022-04-14 | Wheeler | Oregon | 41069 | 242 | 3 |
2407407 | 2407407 | 2022-04-14 | Yamhill | Oregon | 41071 | 17771 | 218 |
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);