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

11 rows where county = "Fayette" and date = "2021-05-28" sorted by date descending

✎ View and edit SQL

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

Suggested facets: deaths, date (date)

fips 11

county 1

  • Fayette · 11 ✖
Link rowid date ▲ county state fips cases deaths
1361984 1361984 2021-05-28 Fayette Alabama 1057 2147 62
1362402 1362402 2021-05-28 Fayette Georgia 13113 9069 174
1362582 1362582 2021-05-28 Fayette Illinois 17051 3198 58
1362680 1362680 2021-05-28 Fayette Indiana 18041 2974 65
1362784 1362784 2021-05-28 Fayette Iowa 19065 1854 42
1362990 1362990 2021-05-28 Fayette Kentucky 21067 36143 316
1364038 1364038 2021-05-28 Fayette Ohio 39047 2845 50
1364243 1364243 2021-05-28 Fayette Pennsylvania 42051 13177 322
1364505 1364505 2021-05-28 Fayette Tennessee 47047 5157 83
1364652 1364652 2021-05-28 Fayette Texas 48149 2738 65
1365061 1365061 2021-05-28 Fayette West Virginia 54019 3510 79

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