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

26 rows where cases = 8 and county = "Hamilton" sorted by date descending

✎ View and edit SQL

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

fips 8

county 1

  • Hamilton · 26 ✖
Link rowid date ▲ county state fips cases deaths
436088 436088 2020-08-15 Hamilton New York 36041 8 1
432862 432862 2020-08-14 Hamilton New York 36041 8 1
429636 429636 2020-08-13 Hamilton New York 36041 8 1
426411 426411 2020-08-12 Hamilton New York 36041 8 1
423188 423188 2020-08-11 Hamilton New York 36041 8 1
419965 419965 2020-08-10 Hamilton New York 36041 8 1
416745 416745 2020-08-09 Hamilton New York 36041 8 1
413524 413524 2020-08-08 Hamilton New York 36041 8 1
410304 410304 2020-08-07 Hamilton New York 36041 8 1
407084 407084 2020-08-06 Hamilton New York 36041 8 1
344854 344854 2020-07-18 Hamilton Illinois 17065 8 0
341654 341654 2020-07-17 Hamilton Illinois 17065 8 0
338458 338458 2020-07-16 Hamilton Illinois 17065 8 0
205576 205576 2020-06-03 Hamilton Texas 48193 8 1
202497 202497 2020-06-02 Hamilton Texas 48193 8 1
199422 199422 2020-06-01 Hamilton Texas 48193 8 1
196349 196349 2020-05-31 Hamilton Texas 48193 8 1
193279 193279 2020-05-30 Hamilton Texas 48193 8 1
127575 127575 2020-05-09 Hamilton Florida 12047 8 0
124588 124588 2020-05-08 Hamilton Florida 12047 8 0
125147 125147 2020-05-08 Hamilton Kansas 20075 8 0
44618 44618 2020-04-09 Hamilton Nebraska 31081 8 0
10602 10602 2020-03-24 Hamilton Tennessee 47065 8 0
9272 9272 2020-03-23 Hamilton Tennessee 47065 8 0
8054 8054 2020-03-22 Hamilton Tennessee 47065 8 0
6799 6799 2020-03-21 Hamilton Ohio 39061 8 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);