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-03-18 and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2319517 | 2319517 | 2022-03-18 | Baker | Oregon | 41001 | 3204 | 46 |
2319518 | 2319518 | 2022-03-18 | Benton | Oregon | 41003 | 14976 | 65 |
2319519 | 2319519 | 2022-03-18 | Clackamas | Oregon | 41005 | 59674 | 565 |
2319520 | 2319520 | 2022-03-18 | Clatsop | Oregon | 41007 | 4564 | 41 |
2319521 | 2319521 | 2022-03-18 | Columbia | Oregon | 41009 | 7526 | 78 |
2319522 | 2319522 | 2022-03-18 | Coos | Oregon | 41011 | 10596 | 146 |
2319523 | 2319523 | 2022-03-18 | Crook | Oregon | 41013 | 6029 | 77 |
2319524 | 2319524 | 2022-03-18 | Curry | Oregon | 41015 | 3320 | 46 |
2319525 | 2319525 | 2022-03-18 | Deschutes | Oregon | 41017 | 45682 | 260 |
2319526 | 2319526 | 2022-03-18 | Douglas | Oregon | 41019 | 19656 | 378 |
2319527 | 2319527 | 2022-03-18 | Gilliam | Oregon | 41021 | 283 | 5 |
2319528 | 2319528 | 2022-03-18 | Grant | Oregon | 41023 | 1647 | 18 |
2319529 | 2319529 | 2022-03-18 | Harney | Oregon | 41025 | 1599 | 37 |
2319530 | 2319530 | 2022-03-18 | Hood River | Oregon | 41027 | 3521 | 42 |
2319531 | 2319531 | 2022-03-18 | Jackson | Oregon | 41029 | 42462 | 503 |
2319532 | 2319532 | 2022-03-18 | Jefferson | Oregon | 41031 | 7189 | 86 |
2319533 | 2319533 | 2022-03-18 | Josephine | Oregon | 41033 | 16250 | 318 |
2319534 | 2319534 | 2022-03-18 | Klamath | Oregon | 41035 | 14054 | 206 |
2319535 | 2319535 | 2022-03-18 | Lake | Oregon | 41037 | 1396 | 25 |
2319536 | 2319536 | 2022-03-18 | Lane | Oregon | 41039 | 56882 | 490 |
2319537 | 2319537 | 2022-03-18 | Lincoln | Oregon | 41041 | 6984 | 79 |
2319538 | 2319538 | 2022-03-18 | Linn | Oregon | 41043 | 26314 | 243 |
2319539 | 2319539 | 2022-03-18 | Malheur | Oregon | 41045 | 8194 | 105 |
2319540 | 2319540 | 2022-03-18 | Marion | Oregon | 41047 | 68572 | 685 |
2319541 | 2319541 | 2022-03-18 | Morrow | Oregon | 41049 | 2950 | 32 |
2319542 | 2319542 | 2022-03-18 | Multnomah | Oregon | 41051 | 112182 | 1108 |
2319543 | 2319543 | 2022-03-18 | Polk | Oregon | 41053 | 15198 | 127 |
2319544 | 2319544 | 2022-03-18 | Sherman | Oregon | 41055 | 317 | 4 |
2319545 | 2319545 | 2022-03-18 | Tillamook | Oregon | 41057 | 3622 | 59 |
2319546 | 2319546 | 2022-03-18 | Umatilla | Oregon | 41059 | 22289 | 206 |
2319547 | 2319547 | 2022-03-18 | Union | Oregon | 41061 | 5009 | 74 |
2319548 | 2319548 | 2022-03-18 | Wallowa | Oregon | 41063 | 1249 | 15 |
2319549 | 2319549 | 2022-03-18 | Wasco | Oregon | 41065 | 5102 | 58 |
2319550 | 2319550 | 2022-03-18 | Washington | Oregon | 41067 | 84800 | 538 |
2319551 | 2319551 | 2022-03-18 | Wheeler | Oregon | 41069 | 243 | 3 |
2319552 | 2319552 | 2022-03-18 | Yamhill | Oregon | 41071 | 17663 | 203 |
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);