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,705 rows where county = "Washington" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state

fips

county

  • Washington · 17,705 ✖
Link rowid date ▲ county state fips cases deaths
1816678 1816678 2021-10-15 Washington Alabama 1129 2508 51
1816797 1816797 2021-10-15 Washington Arkansas 5143 44127 468
1816920 1816920 2021-10-15 Washington Colorado 8121 601 15
1817004 1817004 2021-10-15 Washington Florida 12133 4531 62
1817155 1817155 2021-10-15 Washington Georgia 13303 3197 112
1817215 1817215 2021-10-15 Washington Idaho 16087 1793 41
1817311 1817311 2021-10-15 Washington Illinois 17189 2114 34
1817406 1817406 2021-10-15 Washington Indiana 18175 3521 50
1817503 1817503 2021-10-15 Washington Iowa 19183 3624 55
1817611 1817611 2021-10-15 Washington Kansas 20201 771 15
1817730 1817730 2021-10-15 Washington Kentucky 21229 2291 44
1817795 1817795 2021-10-15 Washington Louisiana 22117 7908 209
1817816 1817816 2021-10-15 Washington Maine 23029 1681 20
1817840 1817840 2021-10-15 Washington Maryland 24043 18888 377
1818024 1818024 2021-10-15 Washington Minnesota 27163 33145 327
1818105 1818105 2021-10-15 Washington Mississippi 28151 7365 156
1818224 1818224 2021-10-15 Washington Missouri 29221 3887 65
1818374 1818374 2021-10-15 Washington Nebraska 31177 2721 29
1818515 1818515 2021-10-15 Washington New York 36115 4490 65
1818613 1818613 2021-10-15 Washington North Carolina 37187 1560 37
1818760 1818760 2021-10-15 Washington Ohio 39167 7995 137
1818839 1818839 2021-10-15 Washington Oklahoma 40147 8310 183
1818876 1818876 2021-10-15 Washington Oregon 41067 37988 313
1818941 1818941 2021-10-15 Washington Pennsylvania 42125 24466 378
1819030 1819030 2021-10-15 Washington Rhode Island 44009 13746 176
1819233 1819233 2021-10-15 Washington Tennessee 47179 21354 322
1819477 1819477 2021-10-15 Washington Texas 48477 5681 124
1819520 1819520 2021-10-15 Washington Utah 49053 28101 272
1819535 1819535 2021-10-15 Washington Vermont 50023 3306 20
1819666 1819666 2021-10-15 Washington Virginia 51191 7355 140
1819834 1819834 2021-10-15 Washington Wisconsin 55131 21806 219
1813430 1813430 2021-10-14 Washington Alabama 1129 2508 50
1813549 1813549 2021-10-14 Washington Arkansas 5143 44086 467
1813672 1813672 2021-10-14 Washington Colorado 8121 595 15
1813756 1813756 2021-10-14 Washington Florida 12133 4520 62
1813907 1813907 2021-10-14 Washington Georgia 13303 3193 112
1813967 1813967 2021-10-14 Washington Idaho 16087 1782 41
1814063 1814063 2021-10-14 Washington Illinois 17189 2113 34
1814158 1814158 2021-10-14 Washington Indiana 18175 3511 49
1814255 1814255 2021-10-14 Washington Iowa 19183 3624 55
1814363 1814363 2021-10-14 Washington Kansas 20201 760 15
1814482 1814482 2021-10-14 Washington Kentucky 21229 2285 44
1814547 1814547 2021-10-14 Washington Louisiana 22117 7905 207
1814567 1814567 2021-10-14 Washington Maine 23029 1660 20
1814591 1814591 2021-10-14 Washington Maryland 24043 18794 374
1814775 1814775 2021-10-14 Washington Minnesota 27163 33051 325
1814856 1814856 2021-10-14 Washington Mississippi 28151 7361 156
1814975 1814975 2021-10-14 Washington Missouri 29221 3881 65
1815125 1815125 2021-10-14 Washington Nebraska 31177 2713 29
1815266 1815266 2021-10-14 Washington New York 36115 4455 65
1815364 1815364 2021-10-14 Washington North Carolina 37187 1559 37
1815511 1815511 2021-10-14 Washington Ohio 39167 7980 136
1815590 1815590 2021-10-14 Washington Oklahoma 40147 8310 183
1815627 1815627 2021-10-14 Washington Oregon 41067 37902 312
1815692 1815692 2021-10-14 Washington Pennsylvania 42125 24317 377
1815781 1815781 2021-10-14 Washington Rhode Island 44009 13746 176
1815984 1815984 2021-10-14 Washington Tennessee 47179 21309 321
1816228 1816228 2021-10-14 Washington Texas 48477 5673 124
1816271 1816271 2021-10-14 Washington Utah 49053 28045 271
1816286 1816286 2021-10-14 Washington Vermont 50023 3280 20
1816417 1816417 2021-10-14 Washington Virginia 51191 7333 139
1816585 1816585 2021-10-14 Washington Wisconsin 55131 21806 219
1810181 1810181 2021-10-13 Washington Alabama 1129 2507 50
1810300 1810300 2021-10-13 Washington Arkansas 5143 44004 465
1810423 1810423 2021-10-13 Washington Colorado 8121 589 15
1810507 1810507 2021-10-13 Washington Florida 12133 4520 62
1810658 1810658 2021-10-13 Washington Georgia 13303 3189 112
1810718 1810718 2021-10-13 Washington Idaho 16087 1769 41
1810814 1810814 2021-10-13 Washington Illinois 17189 2111 34
1810909 1810909 2021-10-13 Washington Indiana 18175 3499 49
1811006 1811006 2021-10-13 Washington Iowa 19183 3624 55
1811114 1811114 2021-10-13 Washington Kansas 20201 760 15
1811233 1811233 2021-10-13 Washington Kentucky 21229 2278 44
1811298 1811298 2021-10-13 Washington Louisiana 22117 7895 206
1811319 1811319 2021-10-13 Washington Maine 23029 1630 20
1811343 1811343 2021-10-13 Washington Maryland 24043 18713 373
1811527 1811527 2021-10-13 Washington Minnesota 27163 32937 325
1811608 1811608 2021-10-13 Washington Mississippi 28151 7353 156
1811727 1811727 2021-10-13 Washington Missouri 29221 3875 65
1811877 1811877 2021-10-13 Washington Nebraska 31177 2707 29
1812018 1812018 2021-10-13 Washington New York 36115 4427 65
1812116 1812116 2021-10-13 Washington North Carolina 37187 1553 37
1812263 1812263 2021-10-13 Washington Ohio 39167 7955 136
1812342 1812342 2021-10-13 Washington Oklahoma 40147 8310 183
1812379 1812379 2021-10-13 Washington Oregon 41067 37818 312
1812444 1812444 2021-10-13 Washington Pennsylvania 42125 24195 375
1812533 1812533 2021-10-13 Washington Rhode Island 44009 13746 176
1812736 1812736 2021-10-13 Washington Tennessee 47179 21270 321
1812980 1812980 2021-10-13 Washington Texas 48477 5661 124
1813023 1813023 2021-10-13 Washington Utah 49053 27999 271
1813038 1813038 2021-10-13 Washington Vermont 50023 3263 19
1813169 1813169 2021-10-13 Washington Virginia 51191 7297 139
1813337 1813337 2021-10-13 Washington Wisconsin 55131 21726 218
1806932 1806932 2021-10-12 Washington Alabama 1129 2506 50
1807051 1807051 2021-10-12 Washington Arkansas 5143 43942 464
1807174 1807174 2021-10-12 Washington Colorado 8121 587 15
1807258 1807258 2021-10-12 Washington Florida 12133 4520 62
1807409 1807409 2021-10-12 Washington Georgia 13303 3185 112
1807469 1807469 2021-10-12 Washington Idaho 16087 1753 41
1807565 1807565 2021-10-12 Washington Illinois 17189 2111 34

Next page

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