ny_times_us_counties

⚠️ 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

3,414 rows where county = "Washington" sorted by date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date (date)

state

fips

county

  • Washington · 3,414 ✖
Link rowid date ▲ county state fips cases deaths
316511 316511 2020-07-11 Washington Alabama 1129 144 8
316628 316628 2020-07-11 Washington Arkansas 5143 4456 36
316747 316747 2020-07-11 Washington Colorado 8121 46 0
316831 316831 2020-07-11 Washington Florida 12133 151 13
316982 316982 2020-07-11 Washington Georgia 13303 183 1
317037 317037 2020-07-11 Washington Idaho 16087 131 2
317133 317133 2020-07-11 Washington Illinois 17189 25 0
317228 317228 2020-07-11 Washington Indiana 18175 68 1
317325 317325 2020-07-11 Washington Iowa 19183 251 9
317429 317429 2020-07-11 Washington Kansas 20201 1 0
317547 317547 2020-07-11 Washington Kentucky 21229 30 0
317612 317612 2020-07-11 Washington Louisiana 22117 824 49
317633 317633 2020-07-11 Washington Maine 23029 5 0
317657 317657 2020-07-11 Washington Maryland 24043 720 29
317840 317840 2020-07-11 Washington Minnesota 27163 1255 41
317921 317921 2020-07-11 Washington Mississippi 28151 722 13
318040 318040 2020-07-11 Washington Missouri 29221 26 1
318161 318161 2020-07-11 Washington Nebraska 31177 58 1
318300 318300 2020-07-11 Washington New York 36115 249 11
318398 318398 2020-07-11 Washington North Carolina 37187 46 3
318539 318539 2020-07-11 Washington Ohio 39167 146 20
318617 318617 2020-07-11 Washington Oklahoma 40147 448 39
318654 318654 2020-07-11 Washington Oregon 41067 1815 20
318718 318718 2020-07-11 Washington Pennsylvania 42125 430 6
318729 318729 2020-07-11 Washington Rhode Island 44009 538 63
318930 318930 2020-07-11 Washington Tennessee 47179 261 0
319167 319167 2020-07-11 Washington Texas 48477 351 33
319209 319209 2020-07-11 Washington Utah 49053 1588 0
319223 319223 2020-07-11 Washington Vermont 50023 43 1
319352 319352 2020-07-11 Washington Virginia 51191 80 4
319519 319519 2020-07-11 Washington Wisconsin 55131 482 19
313413 313413 2020-07-10 Washington Alabama 1129 139 7
313530 313530 2020-07-10 Washington Arkansas 5143 4344 36
313649 313649 2020-07-10 Washington Colorado 8121 46 0
313733 313733 2020-07-10 Washington Florida 12133 147 13
313884 313884 2020-07-10 Washington Georgia 13303 177 1
313939 313939 2020-07-10 Washington Idaho 16087 130 2
314035 314035 2020-07-10 Washington Illinois 17189 25 0
314130 314130 2020-07-10 Washington Indiana 18175 68 1
314227 314227 2020-07-10 Washington Iowa 19183 249 9
314331 314331 2020-07-10 Washington Kansas 20201 1 0
314449 314449 2020-07-10 Washington Kentucky 21229 30 0
314514 314514 2020-07-10 Washington Louisiana 22117 812 49
314535 314535 2020-07-10 Washington Maine 23029 5 0
314559 314559 2020-07-10 Washington Maryland 24043 710 29
314742 314742 2020-07-10 Washington Minnesota 27163 1228 40
314823 314823 2020-07-10 Washington Mississippi 28151 700 10
314942 314942 2020-07-10 Washington Missouri 29221 26 1
315062 315062 2020-07-10 Washington Nebraska 31177 56 1
315200 315200 2020-07-10 Washington New York 36115 249 11
315298 315298 2020-07-10 Washington North Carolina 37187 42 3
315439 315439 2020-07-10 Washington Ohio 39167 144 20
315517 315517 2020-07-10 Washington Oklahoma 40147 445 39
315554 315554 2020-07-10 Washington Oregon 41067 1764 20
315618 315618 2020-07-10 Washington Pennsylvania 42125 410 6
315629 315629 2020-07-10 Washington Rhode Island 44009 538 63
315829 315829 2020-07-10 Washington Tennessee 47179 235 0
316066 316066 2020-07-10 Washington Texas 48477 349 32
316108 316108 2020-07-10 Washington Utah 49053 1545 0
316122 316122 2020-07-10 Washington Vermont 50023 42 1
316251 316251 2020-07-10 Washington Virginia 51191 76 4
316418 316418 2020-07-10 Washington Wisconsin 55131 480 19
310321 310321 2020-07-09 Washington Alabama 1129 130 7
310438 310438 2020-07-09 Washington Arkansas 5143 4309 35
310557 310557 2020-07-09 Washington Colorado 8121 46 0
310641 310641 2020-07-09 Washington Florida 12133 140 13
310792 310792 2020-07-09 Washington Georgia 13303 163 1
310847 310847 2020-07-09 Washington Idaho 16087 129 2
310943 310943 2020-07-09 Washington Illinois 17189 25 0
311038 311038 2020-07-09 Washington Indiana 18175 67 1
311135 311135 2020-07-09 Washington Iowa 19183 248 9
311237 311237 2020-07-09 Washington Kansas 20201 1 0
311355 311355 2020-07-09 Washington Kentucky 21229 28 0
311420 311420 2020-07-09 Washington Louisiana 22117 778 48
311441 311441 2020-07-09 Washington Maine 23029 5 0
311465 311465 2020-07-09 Washington Maryland 24043 702 29
311648 311648 2020-07-09 Washington Minnesota 27163 1190 40
311729 311729 2020-07-09 Washington Mississippi 28151 643 10
311848 311848 2020-07-09 Washington Missouri 29221 26 1
311967 311967 2020-07-09 Washington Nebraska 31177 55 1
312104 312104 2020-07-09 Washington New York 36115 248 11
312202 312202 2020-07-09 Washington North Carolina 37187 41 3
312343 312343 2020-07-09 Washington Ohio 39167 142 20
312420 312420 2020-07-09 Washington Oklahoma 40147 440 39
312457 312457 2020-07-09 Washington Oregon 41067 1720 20
312521 312521 2020-07-09 Washington Pennsylvania 42125 366 6
312532 312532 2020-07-09 Washington Rhode Island 44009 538 63
312732 312732 2020-07-09 Washington Tennessee 47179 212 0
312968 312968 2020-07-09 Washington Texas 48477 337 32
313010 313010 2020-07-09 Washington Utah 49053 1494 0
313024 313024 2020-07-09 Washington Vermont 50023 42 1
313153 313153 2020-07-09 Washington Virginia 51191 74 4
313320 313320 2020-07-09 Washington Wisconsin 55131 470 19
307226 307226 2020-07-08 Washington Alabama 1129 124 7
307343 307343 2020-07-08 Washington Arkansas 5143 4266 35
307462 307462 2020-07-08 Washington Colorado 8121 46 0
307546 307546 2020-07-08 Washington Florida 12133 136 13
307697 307697 2020-07-08 Washington Georgia 13303 159 1
307753 307753 2020-07-08 Washington Idaho 16087 124 2
307849 307849 2020-07-08 Washington Illinois 17189 25 0

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
);
Powered by Datasette · Query took 1037.511ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette