ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
35 rows where "date" is on date 2020-07-10 and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
320886 | 320886 | 2020-07-10 | Baker | Oregon | 41001 | 9 | 0 |
320887 | 320887 | 2020-07-10 | Benton | Oregon | 41003 | 105 | 6 |
320888 | 320888 | 2020-07-10 | Clackamas | Oregon | 41005 | 925 | 27 |
320889 | 320889 | 2020-07-10 | Clatsop | Oregon | 41007 | 55 | 0 |
320890 | 320890 | 2020-07-10 | Columbia | Oregon | 41009 | 47 | 0 |
320891 | 320891 | 2020-07-10 | Coos | Oregon | 41011 | 52 | 0 |
320892 | 320892 | 2020-07-10 | Crook | Oregon | 41013 | 18 | 1 |
320893 | 320893 | 2020-07-10 | Curry | Oregon | 41015 | 9 | 0 |
320894 | 320894 | 2020-07-10 | Deschutes | Oregon | 41017 | 237 | 0 |
320895 | 320895 | 2020-07-10 | Douglas | Oregon | 41019 | 58 | 0 |
320896 | 320896 | 2020-07-10 | Gilliam | Oregon | 41021 | 1 | 0 |
320897 | 320897 | 2020-07-10 | Grant | Oregon | 41023 | 1 | 0 |
320898 | 320898 | 2020-07-10 | Harney | Oregon | 41025 | 2 | 0 |
320899 | 320899 | 2020-07-10 | Hood River | Oregon | 41027 | 103 | 0 |
320900 | 320900 | 2020-07-10 | Jackson | Oregon | 41029 | 173 | 0 |
320901 | 320901 | 2020-07-10 | Jefferson | Oregon | 41031 | 160 | 0 |
320902 | 320902 | 2020-07-10 | Josephine | Oregon | 41033 | 55 | 1 |
320903 | 320903 | 2020-07-10 | Klamath | Oregon | 41035 | 131 | 1 |
320904 | 320904 | 2020-07-10 | Lake | Oregon | 41037 | 24 | 0 |
320905 | 320905 | 2020-07-10 | Lane | Oregon | 41039 | 281 | 3 |
320906 | 320906 | 2020-07-10 | Lincoln | Oregon | 41041 | 362 | 5 |
320907 | 320907 | 2020-07-10 | Linn | Oregon | 41043 | 172 | 10 |
320908 | 320908 | 2020-07-10 | Malheur | Oregon | 41045 | 286 | 1 |
320909 | 320909 | 2020-07-10 | Marion | Oregon | 41047 | 1770 | 53 |
320910 | 320910 | 2020-07-10 | Morrow | Oregon | 41049 | 131 | 1 |
320911 | 320911 | 2020-07-10 | Multnomah | Oregon | 41051 | 2730 | 75 |
320912 | 320912 | 2020-07-10 | Polk | Oregon | 41053 | 171 | 12 |
320913 | 320913 | 2020-07-10 | Sherman | Oregon | 41055 | 3 | 0 |
320914 | 320914 | 2020-07-10 | Tillamook | Oregon | 41057 | 16 | 0 |
320915 | 320915 | 2020-07-10 | Umatilla | Oregon | 41059 | 984 | 7 |
320916 | 320916 | 2020-07-10 | Union | Oregon | 41061 | 368 | 2 |
320917 | 320917 | 2020-07-10 | Wallowa | Oregon | 41063 | 13 | 0 |
320918 | 320918 | 2020-07-10 | Wasco | Oregon | 41065 | 106 | 1 |
320919 | 320919 | 2020-07-10 | Washington | Oregon | 41067 | 1764 | 20 |
320920 | 320920 | 2020-07-10 | Yamhill | Oregon | 41071 | 179 | 9 |
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);