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

25 rows where deaths = 5, fips = 18177 and state = "Indiana" sorted by date descending

✎ View and edit SQL

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

Suggested facets: cases, date (date)

state 1

  • Indiana · 25 ✖

fips 1

  • 18177 · 25 ✖

county 1

Link rowid date ▲ county state fips cases deaths
203765 203765 2020-06-03 Wayne Indiana 18177 238 5
200689 200689 2020-06-02 Wayne Indiana 18177 237 5
197616 197616 2020-06-01 Wayne Indiana 18177 235 5
194546 194546 2020-05-31 Wayne Indiana 18177 232 5
191479 191479 2020-05-30 Wayne Indiana 18177 228 5
182302 182302 2020-05-27 Wayne Indiana 18177 221 5
179258 179258 2020-05-26 Wayne Indiana 18177 211 5
176214 176214 2020-05-25 Wayne Indiana 18177 209 5
173170 173170 2020-05-24 Wayne Indiana 18177 209 5
170129 170129 2020-05-23 Wayne Indiana 18177 206 5
167092 167092 2020-05-22 Wayne Indiana 18177 195 5
164059 164059 2020-05-21 Wayne Indiana 18177 189 5
161031 161031 2020-05-20 Wayne Indiana 18177 188 5
158005 158005 2020-05-19 Wayne Indiana 18177 188 5
154989 154989 2020-05-18 Wayne Indiana 18177 170 5
151977 151977 2020-05-17 Wayne Indiana 18177 170 5
148968 148968 2020-05-16 Wayne Indiana 18177 167 5
145964 145964 2020-05-15 Wayne Indiana 18177 166 5
142964 142964 2020-05-14 Wayne Indiana 18177 159 5
139968 139968 2020-05-13 Wayne Indiana 18177 157 5
136976 136976 2020-05-12 Wayne Indiana 18177 154 5
133987 133987 2020-05-11 Wayne Indiana 18177 150 5
130997 130997 2020-05-10 Wayne Indiana 18177 150 5
128006 128006 2020-05-09 Wayne Indiana 18177 149 5
125019 125019 2020-05-08 Wayne Indiana 18177 138 5

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