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

14 rows where county = "Pike", deaths = 11 and state = "Missouri" sorted by date descending

✎ View and edit SQL

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

state 1

  • Missouri · 14 ✖

fips 1

county 1

  • Pike · 14 ✖
Link rowid date ▲ county state fips cases deaths
850622 850622 2020-12-21 Pike Missouri 29163 1190 11
847377 847377 2020-12-20 Pike Missouri 29163 1178 11
844131 844131 2020-12-19 Pike Missouri 29163 1171 11
840886 840886 2020-12-18 Pike Missouri 29163 1159 11
837641 837641 2020-12-17 Pike Missouri 29163 1148 11
834395 834395 2020-12-16 Pike Missouri 29163 1138 11
831148 831148 2020-12-15 Pike Missouri 29163 1127 11
827902 827902 2020-12-14 Pike Missouri 29163 1119 11
824655 824655 2020-12-13 Pike Missouri 29163 1107 11
821409 821409 2020-12-12 Pike Missouri 29163 1104 11
818163 818163 2020-12-11 Pike Missouri 29163 1078 11
814917 814917 2020-12-10 Pike Missouri 29163 1078 11
811672 811672 2020-12-09 Pike Missouri 29163 1051 11
808427 808427 2020-12-08 Pike Missouri 29163 1042 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);