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

15 rows where county = "Rowan", deaths = 28 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 · 15 ✖

fips 1

county 1

  • Rowan · 15 ✖
Link rowid date ▲ county state fips cases deaths
1872954 1872954 2021-11-01 Rowan Kentucky 21205 3710 28
1869705 1869705 2021-10-31 Rowan Kentucky 21205 3676 28
1866456 1866456 2021-10-30 Rowan Kentucky 21205 3676 28
1863207 1863207 2021-10-29 Rowan Kentucky 21205 3676 28
1859958 1859958 2021-10-28 Rowan Kentucky 21205 3661 28
1856709 1856709 2021-10-27 Rowan Kentucky 21205 3644 28
1853460 1853460 2021-10-26 Rowan Kentucky 21205 3615 28
1850211 1850211 2021-10-25 Rowan Kentucky 21205 3591 28
1846961 1846961 2021-10-24 Rowan Kentucky 21205 3563 28
1843711 1843711 2021-10-23 Rowan Kentucky 21205 3563 28
1840461 1840461 2021-10-22 Rowan Kentucky 21205 3563 28
1837212 1837212 2021-10-21 Rowan Kentucky 21205 3520 28
1833963 1833963 2021-10-20 Rowan Kentucky 21205 3504 28
1830714 1830714 2021-10-19 Rowan Kentucky 21205 3490 28
1827465 1827465 2021-10-18 Rowan Kentucky 21205 3468 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);