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

21 rows where county = "Pike", deaths = 28 and state = "Missouri" sorted by date descending

✎ View and edit SQL

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

state 1

  • Missouri · 21 ✖

fips 1

county 1

  • Pike · 21 ✖
Link rowid date ▲ county state fips cases deaths
1623271 1623271 2021-08-16 Pike Missouri 29163 2106 28
1620024 1620024 2021-08-15 Pike Missouri 29163 2102 28
1616776 1616776 2021-08-14 Pike Missouri 29163 2100 28
1613528 1613528 2021-08-13 Pike Missouri 29163 2096 28
1610279 1610279 2021-08-12 Pike Missouri 29163 2082 28
1607031 1607031 2021-08-11 Pike Missouri 29163 2068 28
1603782 1603782 2021-08-10 Pike Missouri 29163 2056 28
1600533 1600533 2021-08-09 Pike Missouri 29163 2037 28
1597285 1597285 2021-08-08 Pike Missouri 29163 2036 28
1594036 1594036 2021-08-07 Pike Missouri 29163 2034 28
1590787 1590787 2021-08-06 Pike Missouri 29163 2017 28
1587538 1587538 2021-08-05 Pike Missouri 29163 2009 28
1584287 1584287 2021-08-04 Pike Missouri 29163 1987 28
1581038 1581038 2021-08-03 Pike Missouri 29163 1982 28
1577789 1577789 2021-08-02 Pike Missouri 29163 1981 28
1574541 1574541 2021-08-01 Pike Missouri 29163 1980 28
1571293 1571293 2021-07-31 Pike Missouri 29163 1970 28
1568045 1568045 2021-07-30 Pike Missouri 29163 1955 28
1564797 1564797 2021-07-29 Pike Missouri 29163 1944 28
1561549 1561549 2021-07-28 Pike Missouri 29163 1926 28
1558301 1558301 2021-07-27 Pike Missouri 29163 1924 28

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