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

31 rows where county = "Washington" and date = "2021-11-06" sorted by date descending

✎ View and edit SQL

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

Suggested facets: deaths, date (date)

fips >30

county 1

  • Washington · 31 ✖
Link rowid date ▲ county state fips cases deaths
1888160 1888160 2021-11-06 Washington Alabama 1129 2548 52
1888279 1888279 2021-11-06 Washington Arkansas 5143 44818 488
1888402 1888402 2021-11-06 Washington Colorado 8121 700 20
1888486 1888486 2021-11-06 Washington Florida 12133 4553 66
1888637 1888637 2021-11-06 Washington Georgia 13303 3224 120
1888697 1888697 2021-11-06 Washington Idaho 16087 1892 47
1888793 1888793 2021-11-06 Washington Illinois 17189 2154 35
1888888 1888888 2021-11-06 Washington Indiana 18175 3655 55
1888985 1888985 2021-11-06 Washington Iowa 19183 3756 59
1889093 1889093 2021-11-06 Washington Kansas 20201 840 17
1889212 1889212 2021-11-06 Washington Kentucky 21229 2349 47
1889277 1889277 2021-11-06 Washington Louisiana 22117 7983 215
1889298 1889298 2021-11-06 Washington Maine 23029 2058 23
1889322 1889322 2021-11-06 Washington Maryland 24043 20062 409
1889506 1889506 2021-11-06 Washington Minnesota 27163 35500 341
1889587 1889587 2021-11-06 Washington Mississippi 28151 7522 165
1889706 1889706 2021-11-06 Washington Missouri 29221 3968 68
1889856 1889856 2021-11-06 Washington Nebraska 31177 2823 29
1889997 1889997 2021-11-06 Washington New York 36115 5149 71
1890095 1890095 2021-11-06 Washington North Carolina 37187 1606 37
1890243 1890243 2021-11-06 Washington Ohio 39167 8250 151
1890322 1890322 2021-11-06 Washington Oklahoma 40147 8488 200
1890359 1890359 2021-11-06 Washington Oregon 41067 40121 342
1890424 1890424 2021-11-06 Washington Pennsylvania 42125 26443 403
1890513 1890513 2021-11-06 Washington Rhode Island 44009 14239 178
1890716 1890716 2021-11-06 Washington Tennessee 47179 21851 331
1890960 1890960 2021-11-06 Washington Texas 48477 5767 130
1891003 1891003 2021-11-06 Washington Utah 49053 29364 297
1891018 1891018 2021-11-06 Washington Vermont 50023 3696 27
1891149 1891149 2021-11-06 Washington Virginia 51191 7708 148
1891317 1891317 2021-11-06 Washington Wisconsin 55131 23239 227

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