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

17 rows where "date" is on date 2021-09-17 and state = "Nevada" sorted by date descending

✎ View and edit SQL

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

Suggested facets: deaths

fips 17

state 1

  • Nevada · 17 ✖
Link rowid date ▲ county state fips cases deaths
1727403 1727403 2021-09-17 Carson City Nevada 32510 8042 137
1727404 1727404 2021-09-17 Churchill Nevada 32001 3031 54
1727405 1727405 2021-09-17 Clark Nevada 32003 314282 5446
1727406 1727406 2021-09-17 Douglas Nevada 32005 4222 45
1727407 1727407 2021-09-17 Elko Nevada 32007 6458 78
1727408 1727408 2021-09-17 Esmeralda Nevada 32009 46 0
1727409 1727409 2021-09-17 Eureka Nevada 32011 108 0
1727410 1727410 2021-09-17 Humboldt Nevada 32013 1679 17
1727411 1727411 2021-09-17 Lander Nevada 32015 622 14
1727412 1727412 2021-09-17 Lincoln Nevada 32017 479 4
1727413 1727413 2021-09-17 Lyon Nevada 32019 5564 81
1727414 1727414 2021-09-17 Mineral Nevada 32021 496 10
1727415 1727415 2021-09-17 Nye Nevada 32023 3944 125
1727416 1727416 2021-09-17 Pershing Nevada 32027 1046 21
1727417 1727417 2021-09-17 Storey Nevada 32029 169 4
1727418 1727418 2021-09-17 Washoe Nevada 32031 59005 799
1727419 1727419 2021-09-17 White Pine Nevada 32033 911 10

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