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

19 rows where deaths = 28, fips = 26101 and state = "Michigan" sorted by date descending

✎ View and edit SQL

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

Suggested facets: cases, date (date)

state 1

  • Michigan · 19 ✖

fips 1

  • 26101 · 19 ✖

county 1

Link rowid date ▲ county state fips cases deaths
1694451 1694451 2021-09-07 Manistee Michigan 26101 2160 28
1691202 1691202 2021-09-06 Manistee Michigan 26101 2147 28
1687952 1687952 2021-09-05 Manistee Michigan 26101 2147 28
1684702 1684702 2021-09-04 Manistee Michigan 26101 2147 28
1681451 1681451 2021-09-03 Manistee Michigan 26101 2147 28
1678203 1678203 2021-09-02 Manistee Michigan 26101 2133 28
1674955 1674955 2021-09-01 Manistee Michigan 26101 2133 28
1671707 1671707 2021-08-31 Manistee Michigan 26101 2118 28
1668460 1668460 2021-08-30 Manistee Michigan 26101 2118 28
1665213 1665213 2021-08-29 Manistee Michigan 26101 2114 28
1661965 1661965 2021-08-28 Manistee Michigan 26101 2114 28
1658717 1658717 2021-08-27 Manistee Michigan 26101 2114 28
1655468 1655468 2021-08-26 Manistee Michigan 26101 2093 28
1652221 1652221 2021-08-25 Manistee Michigan 26101 2093 28
1648973 1648973 2021-08-24 Manistee Michigan 26101 2083 28
1645724 1645724 2021-08-23 Manistee Michigan 26101 2083 28
1642475 1642475 2021-08-22 Manistee Michigan 26101 2066 28
1639225 1639225 2021-08-21 Manistee Michigan 26101 2066 28
1635975 1635975 2021-08-20 Manistee Michigan 26101 2066 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);