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

17 rows where county = "Pitt", deaths = 11 and state = "North Carolina" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • North Carolina · 17 ✖

fips 1

county 1

  • Pitt · 17 ✖
Link rowid date ▲ county state fips cases deaths
429748 429748 2020-08-13 Pitt North Carolina 37147 2161 11
426523 426523 2020-08-12 Pitt North Carolina 37147 2105 11
423300 423300 2020-08-11 Pitt North Carolina 37147 2054 11
420077 420077 2020-08-10 Pitt North Carolina 37147 2036 11
416857 416857 2020-08-09 Pitt North Carolina 37147 2020 11
413636 413636 2020-08-08 Pitt North Carolina 37147 1962 11
410416 410416 2020-08-07 Pitt North Carolina 37147 1899 11
407196 407196 2020-08-06 Pitt North Carolina 37147 1875 11
403977 403977 2020-08-05 Pitt North Carolina 37147 1833 11
400759 400759 2020-08-04 Pitt North Carolina 37147 1802 11
397544 397544 2020-08-03 Pitt North Carolina 37147 1795 11
394327 394327 2020-08-02 Pitt North Carolina 37147 1766 11
391111 391111 2020-08-01 Pitt North Carolina 37147 1739 11
387894 387894 2020-07-31 Pitt North Carolina 37147 1699 11
384677 384677 2020-07-30 Pitt North Carolina 37147 1639 11
381459 381459 2020-07-29 Pitt North Carolina 37147 1579 11
378242 378242 2020-07-28 Pitt North Carolina 37147 1548 11

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