ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
15 rows where cases = 1055 and state = "Oregon" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
state 1
- Oregon · 15 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1536220 | 1536220 | 2021-07-20 | Baker | Oregon | 41001 | 1055 | 17 |
1438836 | 1438836 | 2021-06-20 | Clatsop | Oregon | 41007 | 1055 | 9 |
1159636 | 1159636 | 2021-03-26 | Morrow | Oregon | 41049 | 1055 | 14 |
1156389 | 1156389 | 2021-03-25 | Morrow | Oregon | 41049 | 1055 | 14 |
1153142 | 1153142 | 2021-03-24 | Morrow | Oregon | 41049 | 1055 | 14 |
1149895 | 1149895 | 2021-03-23 | Morrow | Oregon | 41049 | 1055 | 14 |
1146648 | 1146648 | 2021-03-22 | Morrow | Oregon | 41049 | 1055 | 14 |
1143401 | 1143401 | 2021-03-21 | Morrow | Oregon | 41049 | 1055 | 14 |
1140154 | 1140154 | 2021-03-20 | Morrow | Oregon | 41049 | 1055 | 14 |
1136908 | 1136908 | 2021-03-19 | Morrow | Oregon | 41049 | 1055 | 14 |
1133662 | 1133662 | 2021-03-18 | Morrow | Oregon | 41049 | 1055 | 14 |
1130414 | 1130414 | 2021-03-17 | Morrow | Oregon | 41049 | 1055 | 14 |
974592 | 974592 | 2021-01-28 | Coos | Oregon | 41011 | 1055 | 16 |
951876 | 951876 | 2021-01-21 | Columbia | Oregon | 41009 | 1055 | 18 |
916203 | 916203 | 2021-01-10 | Union | Oregon | 41061 | 1055 | 16 |
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);