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

9 rows where county = "Logan", deaths = 76 and state = "West Virginia" sorted by date descending

✎ View and edit SQL

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

state 1

  • West Virginia · 9 ✖

fips 1

county 1

  • Logan · 9 ✖
Link rowid date ▲ county state fips cases deaths
1089079 1089079 2021-03-04 Logan West Virginia 54045 2711 76
1085834 1085834 2021-03-03 Logan West Virginia 54045 2707 76
1082588 1082588 2021-03-02 Logan West Virginia 54045 2704 76
1079342 1079342 2021-03-01 Logan West Virginia 54045 2701 76
1076097 1076097 2021-02-28 Logan West Virginia 54045 2699 76
1072851 1072851 2021-02-27 Logan West Virginia 54045 2695 76
1069605 1069605 2021-02-26 Logan West Virginia 54045 2686 76
1066360 1066360 2021-02-25 Logan West Virginia 54045 2680 76
1063115 1063115 2021-02-24 Logan West Virginia 54045 2668 76

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