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 = 30, fips = 51071 and state = "Virginia" sorted by date descending

✎ View and edit SQL

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

Suggested facets: cases, date (date)

state 1

  • Virginia · 10 ✖

fips 1

  • 51071 · 10 ✖

county 1

Link rowid date ▲ county state fips cases deaths
1858580 1858580 2021-10-27 Giles Virginia 51071 2263 30
1855331 1855331 2021-10-26 Giles Virginia 51071 2253 30
1852082 1852082 2021-10-25 Giles Virginia 51071 2253 30
1848832 1848832 2021-10-24 Giles Virginia 51071 2240 30
1845582 1845582 2021-10-23 Giles Virginia 51071 2240 30
1842332 1842332 2021-10-22 Giles Virginia 51071 2240 30
1839083 1839083 2021-10-21 Giles Virginia 51071 2229 30
1835834 1835834 2021-10-20 Giles Virginia 51071 2220 30
1832585 1832585 2021-10-19 Giles Virginia 51071 2213 30
1829336 1829336 2021-10-18 Giles Virginia 51071 2211 30

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