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

23 rows where county = "Lincoln" and "date" is on date 2020-05-08 sorted by date descending

✎ View and edit SQL

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

fips 23

county 1

  • Lincoln · 23 ✖
Link rowid date ▲ county state fips cases deaths
124403 124403 2020-05-08 Lincoln Arkansas 5079 907 6
124526 124526 2020-05-08 Lincoln Colorado 8073 3 0
124723 124723 2020-05-08 Lincoln Georgia 13181 12 0
124821 124821 2020-05-08 Lincoln Idaho 16063 29 0
125263 125263 2020-05-08 Lincoln Kentucky 21137 5 1
125343 125343 2020-05-08 Lincoln Louisiana 22061 103 11
125385 125385 2020-05-08 Lincoln Maine 23015 15 0
125552 125552 2020-05-08 Lincoln Minnesota 27081 3 0
125640 125640 2020-05-08 Lincoln Mississippi 28085 179 12
125729 125729 2020-05-08 Lincoln Missouri 29113 54 1
125795 125795 2020-05-08 Lincoln Montana 30053 7 1
125849 125849 2020-05-08 Lincoln Nebraska 31111 39 2
125883 125883 2020-05-08 Lincoln Nevada 32017 1 0
125935 125935 2020-05-08 Lincoln New Mexico 35027 2 0
126064 126064 2020-05-08 Lincoln North Carolina 37109 39 0
126274 126274 2020-05-08 Lincoln Oklahoma 40081 17 2
126327 126327 2020-05-08 Lincoln Oregon 41041 6 0
126564 126564 2020-05-08 Lincoln South Dakota 46083 180 0
126636 126636 2020-05-08 Lincoln Tennessee 47103 16 0
127093 127093 2020-05-08 Lincoln Washington 53043 2 0
127131 127131 2020-05-08 Lincoln West Virginia 54043 4 0
127196 127196 2020-05-08 Lincoln Wisconsin 55069 1 0
127243 127243 2020-05-08 Lincoln Wyoming 56023 10 0

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