ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

24 rows where date = "2020-03-27" and state = "Oregon" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: cases, deaths, date (date)

fips 24

state 1

  • Oregon · 24 ✖
Link rowid date ▲ county state fips cases deaths
15294 15294 2020-03-27 Benton Oregon 41003 6 0
15295 15295 2020-03-27 Clackamas Oregon 41005 31 2
15296 15296 2020-03-27 Clatsop Oregon 41007 2 0
15297 15297 2020-03-27 Columbia Oregon 41009 1 0
15298 15298 2020-03-27 Deschutes Oregon 41017 18 0
15299 15299 2020-03-27 Douglas Oregon 41019 4 0
15300 15300 2020-03-27 Grant Oregon 41023 1 0
15301 15301 2020-03-27 Hood River Oregon 41027 1 0
15302 15302 2020-03-27 Jackson Oregon 41029 6 0
15303 15303 2020-03-27 Josephine Oregon 41033 4 0
15304 15304 2020-03-27 Klamath Oregon 41035 2 0
15305 15305 2020-03-27 Lane Oregon 41039 9 1
15306 15306 2020-03-27 Lincoln Oregon 41041 1 0
15307 15307 2020-03-27 Linn Oregon 41043 28 1
15308 15308 2020-03-27 Marion Oregon 41047 83 3
15309 15309 2020-03-27 Morrow Oregon 41049 1 0
15310 15310 2020-03-27 Multnomah Oregon 41051 67 2
15311 15311 2020-03-27 Polk Oregon 41053 10 0
15312 15312 2020-03-27 Tillamook Oregon 41057 1 0
15313 15313 2020-03-27 Umatilla Oregon 41059 3 0
15314 15314 2020-03-27 Union Oregon 41061 1 0
15315 15315 2020-03-27 Wasco Oregon 41065 2 0
15316 15316 2020-03-27 Washington Oregon 41067 122 3
15317 15317 2020-03-27 Yamhill Oregon 41071 11 0

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);