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

9,273 rows where county = "Washington" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state

fips

county

  • Washington · 9,273 ✖
Link rowid date ▲ county state fips cases deaths
933563 933563 2021-01-16 Washington Alabama 1129 1370 26
933681 933681 2021-01-16 Washington Arkansas 5143 25591 245
933804 933804 2021-01-16 Washington Colorado 8121 360 11
933888 933888 2021-01-16 Washington Florida 12133 2261 30
934039 934039 2021-01-16 Washington Georgia 13303 1758 47
934098 934098 2021-01-16 Washington Idaho 16087 1080 17
934193 934193 2021-01-16 Washington Illinois 17189 1440 25
934288 934288 2021-01-16 Washington Indiana 18175 1750 18
934385 934385 2021-01-16 Washington Iowa 19183 2143 31
934494 934494 2021-01-16 Washington Kansas 20201 472 8
934613 934613 2021-01-16 Washington Kentucky 21229 1024 16
934678 934678 2021-01-16 Washington Louisiana 22117 3598 99
934699 934699 2021-01-16 Washington Maine 23029 492 7
934723 934723 2021-01-16 Washington Maryland 24043 10421 181
934907 934907 2021-01-16 Washington Minnesota 27163 20004 225
934988 934988 2021-01-16 Washington Mississippi 28151 4770 123
935107 935107 2021-01-16 Washington Missouri 29221 1979 41
935256 935256 2021-01-16 Washington Nebraska 31177 1782 17
935397 935397 2021-01-16 Washington New York 36115 1424 21
935495 935495 2021-01-16 Washington North Carolina 37187 636 19
935641 935641 2021-01-16 Washington Ohio 39167 3679 40
935720 935720 2021-01-16 Washington Oklahoma 40147 3811 67
935757 935757 2021-01-16 Washington Oregon 41067 18512 171
935822 935822 2021-01-16 Washington Pennsylvania 42125 11260 168
935911 935911 2021-01-16 Washington Rhode Island 44009 5521 125
936114 936114 2021-01-16 Washington Tennessee 47179 11818 191
936358 936358 2021-01-16 Washington Texas 48477 1665 69
936401 936401 2021-01-16 Washington Utah 49053 17240 147
936416 936416 2021-01-16 Washington Vermont 50023 1002 11
936547 936547 2021-01-16 Washington Virginia 51191 3596 60
936715 936715 2021-01-16 Washington Wisconsin 55131 14394 113
930318 930318 2021-01-15 Washington Alabama 1129 1365 26
930436 930436 2021-01-15 Washington Arkansas 5143 25360 245
930559 930559 2021-01-15 Washington Colorado 8121 357 11
930643 930643 2021-01-15 Washington Florida 12133 2244 30
930794 930794 2021-01-15 Washington Georgia 13303 1747 47
930853 930853 2021-01-15 Washington Idaho 16087 1079 17
930948 930948 2021-01-15 Washington Illinois 17189 1432 25
931043 931043 2021-01-15 Washington Indiana 18175 1730 16
931140 931140 2021-01-15 Washington Iowa 19183 2139 31
931249 931249 2021-01-15 Washington Kansas 20201 472 8
931368 931368 2021-01-15 Washington Kentucky 21229 1014 16
931433 931433 2021-01-15 Washington Louisiana 22117 3598 99
931454 931454 2021-01-15 Washington Maine 23029 484 7
931478 931478 2021-01-15 Washington Maryland 24043 10309 180
931662 931662 2021-01-15 Washington Minnesota 27163 19904 223
931743 931743 2021-01-15 Washington Mississippi 28151 4734 122
931862 931862 2021-01-15 Washington Missouri 29221 1967 41
932011 932011 2021-01-15 Washington Nebraska 31177 1782 17
932152 932152 2021-01-15 Washington New York 36115 1381 21
932250 932250 2021-01-15 Washington North Carolina 37187 629 19
932396 932396 2021-01-15 Washington Ohio 39167 3609 40
932475 932475 2021-01-15 Washington Oklahoma 40147 3762 67
932512 932512 2021-01-15 Washington Oregon 41067 18386 166
932577 932577 2021-01-15 Washington Pennsylvania 42125 11148 168
932666 932666 2021-01-15 Washington Rhode Island 44009 5521 125
932869 932869 2021-01-15 Washington Tennessee 47179 11757 191
933113 933113 2021-01-15 Washington Texas 48477 1641 69
933156 933156 2021-01-15 Washington Utah 49053 17129 144
933171 933171 2021-01-15 Washington Vermont 50023 991 11
933302 933302 2021-01-15 Washington Virginia 51191 3567 60
933470 933470 2021-01-15 Washington Wisconsin 55131 14317 113
927073 927073 2021-01-14 Washington Alabama 1129 1354 26
927191 927191 2021-01-14 Washington Arkansas 5143 25124 245
927314 927314 2021-01-14 Washington Colorado 8121 356 11
927398 927398 2021-01-14 Washington Florida 12133 2226 30
927549 927549 2021-01-14 Washington Georgia 13303 1715 47
927608 927608 2021-01-14 Washington Idaho 16087 1074 17
927703 927703 2021-01-14 Washington Illinois 17189 1423 25
927798 927798 2021-01-14 Washington Indiana 18175 1702 16
927895 927895 2021-01-14 Washington Iowa 19183 2136 31
928004 928004 2021-01-14 Washington Kansas 20201 463 8
928123 928123 2021-01-14 Washington Kentucky 21229 1002 14
928188 928188 2021-01-14 Washington Louisiana 22117 3541 99
928209 928209 2021-01-14 Washington Maine 23029 466 5
928233 928233 2021-01-14 Washington Maryland 24043 10125 180
928417 928417 2021-01-14 Washington Minnesota 27163 19827 221
928498 928498 2021-01-14 Washington Mississippi 28151 4700 122
928617 928617 2021-01-14 Washington Missouri 29221 1955 41
928766 928766 2021-01-14 Washington Nebraska 31177 1765 17
928907 928907 2021-01-14 Washington New York 36115 1332 20
929005 929005 2021-01-14 Washington North Carolina 37187 611 19
929151 929151 2021-01-14 Washington Ohio 39167 3570 39
929230 929230 2021-01-14 Washington Oklahoma 40147 3705 67
929267 929267 2021-01-14 Washington Oregon 41067 18245 166
929332 929332 2021-01-14 Washington Pennsylvania 42125 11028 166
929421 929421 2021-01-14 Washington Rhode Island 44009 5521 125
929624 929624 2021-01-14 Washington Tennessee 47179 11674 191
929868 929868 2021-01-14 Washington Texas 48477 1631 69
929911 929911 2021-01-14 Washington Utah 49053 17000 143
929926 929926 2021-01-14 Washington Vermont 50023 974 11
930057 930057 2021-01-14 Washington Virginia 51191 3537 59
930225 930225 2021-01-14 Washington Wisconsin 55131 14272 111
923827 923827 2021-01-13 Washington Alabama 1129 1342 26
923945 923945 2021-01-13 Washington Arkansas 5143 24907 243
924068 924068 2021-01-13 Washington Colorado 8121 356 11
924152 924152 2021-01-13 Washington Florida 12133 2197 30
924303 924303 2021-01-13 Washington Georgia 13303 1700 47
924362 924362 2021-01-13 Washington Idaho 16087 1066 16
924457 924457 2021-01-13 Washington Illinois 17189 1412 25

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