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-09-13 and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1714873 | 1714873 | 2021-09-13 | Baker | Oregon | 41001 | 1614 | 19 |
1714874 | 1714874 | 2021-09-13 | Benton | Oregon | 41003 | 4426 | 23 |
1714875 | 1714875 | 2021-09-13 | Clackamas | Oregon | 41005 | 25729 | 266 |
1714876 | 1714876 | 2021-09-13 | Clatsop | Oregon | 41007 | 1989 | 24 |
1714877 | 1714877 | 2021-09-13 | Columbia | Oregon | 41009 | 3108 | 37 |
1714878 | 1714878 | 2021-09-13 | Coos | Oregon | 41011 | 3854 | 63 |
1714879 | 1714879 | 2021-09-13 | Crook | Oregon | 41013 | 2014 | 33 |
1714880 | 1714880 | 2021-09-13 | Curry | Oregon | 41015 | 1626 | 16 |
1714881 | 1714881 | 2021-09-13 | Deschutes | Oregon | 41017 | 15803 | 98 |
1714882 | 1714882 | 2021-09-13 | Douglas | Oregon | 41019 | 10242 | 173 |
1714883 | 1714883 | 2021-09-13 | Gilliam | Oregon | 41021 | 131 | 4 |
1714884 | 1714884 | 2021-09-13 | Grant | Oregon | 41023 | 726 | 8 |
1714885 | 1714885 | 2021-09-13 | Harney | Oregon | 41025 | 709 | 13 |
1714886 | 1714886 | 2021-09-13 | Hood River | Oregon | 41027 | 1564 | 35 |
1714887 | 1714887 | 2021-09-13 | Jackson | Oregon | 41029 | 20235 | 237 |
1714888 | 1714888 | 2021-09-13 | Jefferson | Oregon | 41031 | 3043 | 45 |
1714889 | 1714889 | 2021-09-13 | Josephine | Oregon | 41033 | 8318 | 156 |
1714890 | 1714890 | 2021-09-13 | Klamath | Oregon | 41035 | 6125 | 88 |
1714891 | 1714891 | 2021-09-13 | Lake | Oregon | 41037 | 597 | 8 |
1714892 | 1714892 | 2021-09-13 | Lane | Oregon | 41039 | 22982 | 231 |
1714893 | 1714893 | 2021-09-13 | Lincoln | Oregon | 41041 | 2638 | 29 |
1714894 | 1714894 | 2021-09-13 | Linn | Oregon | 41043 | 9845 | 85 |
1714895 | 1714895 | 2021-09-13 | Malheur | Oregon | 41045 | 4510 | 67 |
1714896 | 1714896 | 2021-09-13 | Marion | Oregon | 41047 | 31417 | 375 |
1714897 | 1714897 | 2021-09-13 | Morrow | Oregon | 41049 | 1635 | 20 |
1714898 | 1714898 | 2021-09-13 | Multnomah | Oregon | 41051 | 50080 | 642 |
1714899 | 1714899 | 2021-09-13 | Polk | Oregon | 41053 | 5963 | 68 |
1714900 | 1714900 | 2021-09-13 | Sherman | Oregon | 41055 | 121 | 2 |
1714901 | 1714901 | 2021-09-13 | Tillamook | Oregon | 41057 | 1736 | 20 |
1714902 | 1714902 | 2021-09-13 | Umatilla | Oregon | 41059 | 12289 | 120 |
1714903 | 1714903 | 2021-09-13 | Union | Oregon | 41061 | 2578 | 36 |
1714904 | 1714904 | 2021-09-13 | Wallowa | Oregon | 41063 | 481 | 6 |
1714905 | 1714905 | 2021-09-13 | Wasco | Oregon | 41065 | 2281 | 38 |
1714906 | 1714906 | 2021-09-13 | Washington | Oregon | 41067 | 33973 | 271 |
1714907 | 1714907 | 2021-09-13 | Wheeler | Oregon | 41069 | 62 | 1 |
1714908 | 1714908 | 2021-09-13 | Yamhill | Oregon | 41071 | 7060 | 94 |
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);