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

22 rows where cases = 27, county = "Hockley" and state = "Texas" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Texas · 22 ✖

fips 1

county 1

  • Hockley · 22 ✖
Link rowid date ▲ county state fips cases deaths
227219 227219 2020-06-10 Hockley Texas 48219 27 1
224119 224119 2020-06-09 Hockley Texas 48219 27 1
221024 221024 2020-06-08 Hockley Texas 48219 27 1
217932 217932 2020-06-07 Hockley Texas 48219 27 1
214842 214842 2020-06-06 Hockley Texas 48219 27 1
211755 211755 2020-06-05 Hockley Texas 48219 27 1
208671 208671 2020-06-04 Hockley Texas 48219 27 1
205589 205589 2020-06-03 Hockley Texas 48219 27 1
202510 202510 2020-06-02 Hockley Texas 48219 27 1
199435 199435 2020-06-01 Hockley Texas 48219 27 1
196362 196362 2020-05-31 Hockley Texas 48219 27 1
193292 193292 2020-05-30 Hockley Texas 48219 27 1
190227 190227 2020-05-29 Hockley Texas 48219 27 1
187163 187163 2020-05-28 Hockley Texas 48219 27 1
184106 184106 2020-05-27 Hockley Texas 48219 27 1
181056 181056 2020-05-26 Hockley Texas 48219 27 1
178013 178013 2020-05-25 Hockley Texas 48219 27 1
174969 174969 2020-05-24 Hockley Texas 48219 27 1
171926 171926 2020-05-23 Hockley Texas 48219 27 1
168886 168886 2020-05-22 Hockley Texas 48219 27 1
165850 165850 2020-05-21 Hockley Texas 48219 27 1
162821 162821 2020-05-20 Hockley Texas 48219 27 1

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