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

16 rows where "date" is on date 2020-09-26 and state = "Nevada" sorted by date descending

✎ View and edit SQL

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

Suggested facets: cases, deaths

fips 16

state 1

  • Nevada · 16 ✖
Link rowid date ▲ county state fips cases deaths
571802 571802 2020-09-26 Carson City Nevada 32510 539 8
571803 571803 2020-09-26 Churchill Nevada 32001 141 3
571804 571804 2020-09-26 Clark Nevada 32003 66009 1377
571805 571805 2020-09-26 Douglas Nevada 32005 300 1
571806 571806 2020-09-26 Elko Nevada 32007 949 10
571807 571807 2020-09-26 Eureka Nevada 32011 10 0
571808 571808 2020-09-26 Humboldt Nevada 32013 121 4
571809 571809 2020-09-26 Lander Nevada 32015 70 1
571810 571810 2020-09-26 Lincoln Nevada 32017 7 0
571811 571811 2020-09-26 Lyon Nevada 32019 435 7
571812 571812 2020-09-26 Mineral Nevada 32021 13 0
571813 571813 2020-09-26 Nye Nevada 32023 510 15
571814 571814 2020-09-26 Pershing Nevada 32027 21 0
571815 571815 2020-09-26 Storey Nevada 32029 10 0
571816 571816 2020-09-26 Washoe Nevada 32031 9268 156
571817 571817 2020-09-26 White Pine Nevada 32033 61 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);