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

28 rows where county = "Shelby", deaths = 181 and fips = 18145 sorted by date descending

✎ View and edit SQL

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

Suggested facets: cases, date (date)

state 1

fips 1

  • 18145 · 28 ✖

county 1

  • Shelby · 28 ✖
Link rowid date ▲ county state fips cases deaths
2383125 2383125 2022-04-07 Shelby Indiana 18145 13589 181
2379870 2379870 2022-04-06 Shelby Indiana 18145 13589 181
2376616 2376616 2022-04-05 Shelby Indiana 18145 13584 181
2373364 2373364 2022-04-04 Shelby Indiana 18145 13584 181
2370111 2370111 2022-04-03 Shelby Indiana 18145 13582 181
2366858 2366858 2022-04-02 Shelby Indiana 18145 13582 181
2363605 2363605 2022-04-01 Shelby Indiana 18145 13582 181
2360351 2360351 2022-03-31 Shelby Indiana 18145 13576 181
2357097 2357097 2022-03-30 Shelby Indiana 18145 13576 181
2353844 2353844 2022-03-29 Shelby Indiana 18145 14677 181
2350592 2350592 2022-03-28 Shelby Indiana 18145 14674 181
2347339 2347339 2022-03-27 Shelby Indiana 18145 14674 181
2344086 2344086 2022-03-26 Shelby Indiana 18145 14674 181
2340833 2340833 2022-03-25 Shelby Indiana 18145 14674 181
2337580 2337580 2022-03-24 Shelby Indiana 18145 14673 181
2334326 2334326 2022-03-23 Shelby Indiana 18145 14669 181
2331072 2331072 2022-03-22 Shelby Indiana 18145 14667 181
2327820 2327820 2022-03-21 Shelby Indiana 18145 14665 181
2324567 2324567 2022-03-20 Shelby Indiana 18145 14662 181
2321313 2321313 2022-03-19 Shelby Indiana 18145 14662 181
2318059 2318059 2022-03-18 Shelby Indiana 18145 14662 181
2314806 2314806 2022-03-17 Shelby Indiana 18145 14662 181
2311553 2311553 2022-03-16 Shelby Indiana 18145 14662 181
2308300 2308300 2022-03-15 Shelby Indiana 18145 14660 181
2305049 2305049 2022-03-14 Shelby Indiana 18145 14656 181
2301797 2301797 2022-03-13 Shelby Indiana 18145 14653 181
2298545 2298545 2022-03-12 Shelby Indiana 18145 14653 181
2295293 2295293 2022-03-11 Shelby Indiana 18145 14653 181

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