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

10 rows where deaths = 18, fips = 21175 and state = "Kentucky" sorted by date descending

✎ View and edit SQL

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

Suggested facets: cases, date (date)

state 1

  • Kentucky · 10 ✖

fips 1

  • 21175 · 10 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2302110 2302110 2022-03-13 Morgan Kentucky 21175 4692 18
2298858 2298858 2022-03-12 Morgan Kentucky 21175 4692 18
2295606 2295606 2022-03-11 Morgan Kentucky 21175 4692 18
2292354 2292354 2022-03-10 Morgan Kentucky 21175 4692 18
2289102 2289102 2022-03-09 Morgan Kentucky 21175 4692 18
2285851 2285851 2022-03-08 Morgan Kentucky 21175 4692 18
2282599 2282599 2022-03-07 Morgan Kentucky 21175 4692 18
2279346 2279346 2022-03-06 Morgan Kentucky 21175 4659 18
2276093 2276093 2022-03-05 Morgan Kentucky 21175 4659 18
2272840 2272840 2022-03-04 Morgan Kentucky 21175 4659 18

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