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 deaths = 7, fips = 20177 and state = "Kansas" sorted by date descending

✎ View and edit SQL

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

Suggested facets: cases, date (date)

state 1

  • Kansas · 15 ✖

fips 1

  • 20177 · 15 ✖

county 1

Link rowid date ▲ county state fips cases deaths
222465 222465 2020-06-09 Shawnee Kansas 20177 394 7
219370 219370 2020-06-08 Shawnee Kansas 20177 384 7
216278 216278 2020-06-07 Shawnee Kansas 20177 372 7
213191 213191 2020-06-06 Shawnee Kansas 20177 372 7
210106 210106 2020-06-05 Shawnee Kansas 20177 369 7
207025 207025 2020-06-04 Shawnee Kansas 20177 348 7
203944 203944 2020-06-03 Shawnee Kansas 20177 336 7
200867 200867 2020-06-02 Shawnee Kansas 20177 328 7
197795 197795 2020-06-01 Shawnee Kansas 20177 328 7
194725 194725 2020-05-31 Shawnee Kansas 20177 300 7
191657 191657 2020-05-30 Shawnee Kansas 20177 300 7
188593 188593 2020-05-29 Shawnee Kansas 20177 294 7
185535 185535 2020-05-28 Shawnee Kansas 20177 272 7
182481 182481 2020-05-27 Shawnee Kansas 20177 272 7
179436 179436 2020-05-26 Shawnee Kansas 20177 269 7

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