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-01-03 and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2078844 | 2078844 | 2022-01-03 | Baker | Oregon | 41001 | 2326 | 36 |
2078845 | 2078845 | 2022-01-03 | Benton | Oregon | 41003 | 7018 | 43 |
2078846 | 2078846 | 2022-01-03 | Clackamas | Oregon | 41005 | 36536 | 429 |
2078847 | 2078847 | 2022-01-03 | Clatsop | Oregon | 41007 | 2880 | 36 |
2078848 | 2078848 | 2022-01-03 | Columbia | Oregon | 41009 | 4809 | 61 |
2078849 | 2078849 | 2022-01-03 | Coos | Oregon | 41011 | 6439 | 122 |
2078850 | 2078850 | 2022-01-03 | Crook | Oregon | 41013 | 3672 | 60 |
2078851 | 2078851 | 2022-01-03 | Curry | Oregon | 41015 | 2032 | 40 |
2078852 | 2078852 | 2022-01-03 | Deschutes | Oregon | 41017 | 26946 | 215 |
2078853 | 2078853 | 2022-01-03 | Douglas | Oregon | 41019 | 14389 | 315 |
2078854 | 2078854 | 2022-01-03 | Gilliam | Oregon | 41021 | 202 | 4 |
2078855 | 2078855 | 2022-01-03 | Grant | Oregon | 41023 | 1177 | 17 |
2078856 | 2078856 | 2022-01-03 | Harney | Oregon | 41025 | 1261 | 34 |
2078857 | 2078857 | 2022-01-03 | Hood River | Oregon | 41027 | 2311 | 38 |
2078858 | 2078858 | 2022-01-03 | Jackson | Oregon | 41029 | 27213 | 394 |
2078859 | 2078859 | 2022-01-03 | Jefferson | Oregon | 41031 | 4507 | 69 |
2078860 | 2078860 | 2022-01-03 | Josephine | Oregon | 41033 | 11154 | 267 |
2078861 | 2078861 | 2022-01-03 | Klamath | Oregon | 41035 | 9421 | 168 |
2078862 | 2078862 | 2022-01-03 | Lake | Oregon | 41037 | 1081 | 21 |
2078863 | 2078863 | 2022-01-03 | Lane | Oregon | 41039 | 32964 | 383 |
2078864 | 2078864 | 2022-01-03 | Lincoln | Oregon | 41041 | 4008 | 58 |
2078865 | 2078865 | 2022-01-03 | Linn | Oregon | 41043 | 16238 | 206 |
2078866 | 2078866 | 2022-01-03 | Malheur | Oregon | 41045 | 6051 | 94 |
2078867 | 2078867 | 2022-01-03 | Marion | Oregon | 41047 | 42357 | 547 |
2078868 | 2078868 | 2022-01-03 | Morrow | Oregon | 41049 | 2065 | 25 |
2078869 | 2078869 | 2022-01-03 | Multnomah | Oregon | 41051 | 68383 | 905 |
2078870 | 2078870 | 2022-01-03 | Polk | Oregon | 41053 | 8924 | 111 |
2078871 | 2078871 | 2022-01-03 | Sherman | Oregon | 41055 | 201 | 3 |
2078872 | 2078872 | 2022-01-03 | Tillamook | Oregon | 41057 | 2451 | 49 |
2078873 | 2078873 | 2022-01-03 | Umatilla | Oregon | 41059 | 15725 | 187 |
2078874 | 2078874 | 2022-01-03 | Union | Oregon | 41061 | 3569 | 64 |
2078875 | 2078875 | 2022-01-03 | Wallowa | Oregon | 41063 | 794 | 13 |
2078876 | 2078876 | 2022-01-03 | Wasco | Oregon | 41065 | 3343 | 48 |
2078877 | 2078877 | 2022-01-03 | Washington | Oregon | 41067 | 47745 | 443 |
2078878 | 2078878 | 2022-01-03 | Wheeler | Oregon | 41069 | 141 | 2 |
2078879 | 2078879 | 2022-01-03 | Yamhill | Oregon | 41071 | 10598 | 159 |
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);