ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
24,215 rows where county = "Washington" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state >30
- Oregon 229
- Utah 222
- Pennsylvania 215
- Vermont 214
- Minnesota 213
- Louisiana 211
- Iowa 210
- New York 210
- Wisconsin 210
- Arkansas 209
- Illinois 209
- Oklahoma 209
- Tennessee 209
- Alabama 207
- Maryland 207
- Mississippi 207
- Indiana 206
- Nebraska 205
- Ohio 205
- Georgia 204
- Rhode Island 203
- Virginia 202
- Colorado 201
- Florida 201
- Kentucky 200
- Texas 200
- North Carolina 199
- Idaho 194
- Maine 194
- Missouri 189
- …
fips >30
county 1
- Washington · 6,320 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
626038 | 626038 | 2020-10-13 | Washington | Iowa | 19183 | 570 | 11 |
626146 | 626146 | 2020-10-13 | Washington | Kansas | 20201 | 27 | 0 |
626265 | 626265 | 2020-10-13 | Washington | Kentucky | 21229 | 175 | 1 |
626330 | 626330 | 2020-10-13 | Washington | Louisiana | 22117 | 1699 | 68 |
626350 | 626350 | 2020-10-13 | Washington | Maine | 23029 | 20 | 0 |
626374 | 626374 | 2020-10-13 | Washington | Maryland | 24043 | 2008 | 41 |
626558 | 626558 | 2020-10-13 | Washington | Minnesota | 27163 | 4723 | 62 |
626639 | 626639 | 2020-10-13 | Washington | Mississippi | 28151 | 2422 | 91 |
626758 | 626758 | 2020-10-13 | Washington | Missouri | 29221 | 544 | 12 |
626908 | 626908 | 2020-10-13 | Washington | Nebraska | 31177 | 373 | 6 |
627048 | 627048 | 2020-10-13 | Washington | New York | 36115 | 319 | 14 |
627146 | 627146 | 2020-10-13 | Washington | North Carolina | 37187 | 228 | 8 |
627292 | 627292 | 2020-10-13 | Washington | Ohio | 39167 | 300 | 23 |
627371 | 627371 | 2020-10-13 | Washington | Oklahoma | 40147 | 1139 | 41 |
627408 | 627408 | 2020-10-13 | Washington | Oregon | 41067 | 5146 | 67 |
627473 | 627473 | 2020-10-13 | Washington | Pennsylvania | 42125 | 1556 | 31 |
627562 | 627562 | 2020-10-13 | Washington | Rhode Island | 44009 | 955 | 74 |
627765 | 627765 | 2020-10-13 | Washington | Tennessee | 47179 | 2783 | 42 |
628008 | 628008 | 2020-10-13 | Washington | Texas | 48477 | 664 | 48 |
628051 | 628051 | 2020-10-13 | Washington | Utah | 49053 | 3932 | 38 |
628066 | 628066 | 2020-10-13 | Washington | Vermont | 50023 | 89 | 2 |
628197 | 628197 | 2020-10-13 | Washington | Virginia | 51191 | 742 | 21 |
628367 | 628367 | 2020-10-13 | Washington | Wisconsin | 55131 | 3536 | 40 |
621974 | 621974 | 2020-10-12 | Washington | Alabama | 1129 | 606 | 12 |
622091 | 622091 | 2020-10-12 | Washington | Arkansas | 5143 | 10442 | 127 |
622214 | 622214 | 2020-10-12 | Washington | Colorado | 8121 | 73 | 0 |
622298 | 622298 | 2020-10-12 | Washington | Florida | 12133 | 1119 | 24 |
622449 | 622449 | 2020-10-12 | Washington | Georgia | 13303 | 776 | 10 |
622508 | 622508 | 2020-10-12 | Washington | Idaho | 16087 | 400 | 7 |
622604 | 622604 | 2020-10-12 | Washington | Illinois | 17189 | 259 | 1 |
622699 | 622699 | 2020-10-12 | Washington | Indiana | 18175 | 310 | 2 |
622796 | 622796 | 2020-10-12 | Washington | Iowa | 19183 | 561 | 11 |
622904 | 622904 | 2020-10-12 | Washington | Kansas | 20201 | 27 | 0 |
623023 | 623023 | 2020-10-12 | Washington | Kentucky | 21229 | 175 | 1 |
623088 | 623088 | 2020-10-12 | Washington | Louisiana | 22117 | 1691 | 68 |
623108 | 623108 | 2020-10-12 | Washington | Maine | 23029 | 20 | 0 |
623132 | 623132 | 2020-10-12 | Washington | Maryland | 24043 | 1993 | 41 |
623316 | 623316 | 2020-10-12 | Washington | Minnesota | 27163 | 4660 | 62 |
623397 | 623397 | 2020-10-12 | Washington | Mississippi | 28151 | 2402 | 88 |
623516 | 623516 | 2020-10-12 | Washington | Missouri | 29221 | 544 | 12 |
623666 | 623666 | 2020-10-12 | Washington | Nebraska | 31177 | 365 | 6 |
623806 | 623806 | 2020-10-12 | Washington | New York | 36115 | 318 | 14 |
623904 | 623904 | 2020-10-12 | Washington | North Carolina | 37187 | 227 | 8 |
624050 | 624050 | 2020-10-12 | Washington | Ohio | 39167 | 293 | 23 |
624129 | 624129 | 2020-10-12 | Washington | Oklahoma | 40147 | 1120 | 41 |
624166 | 624166 | 2020-10-12 | Washington | Oregon | 41067 | 5100 | 67 |
624231 | 624231 | 2020-10-12 | Washington | Pennsylvania | 42125 | 1538 | 31 |
624320 | 624320 | 2020-10-12 | Washington | Rhode Island | 44009 | 955 | 74 |
624523 | 624523 | 2020-10-12 | Washington | Tennessee | 47179 | 2761 | 41 |
624765 | 624765 | 2020-10-12 | Washington | Texas | 48477 | 657 | 48 |
624808 | 624808 | 2020-10-12 | Washington | Utah | 49053 | 3878 | 38 |
624823 | 624823 | 2020-10-12 | Washington | Vermont | 50023 | 86 | 2 |
624954 | 624954 | 2020-10-12 | Washington | Virginia | 51191 | 735 | 21 |
625124 | 625124 | 2020-10-12 | Washington | Wisconsin | 55131 | 3437 | 38 |
618731 | 618731 | 2020-10-11 | Washington | Alabama | 1129 | 605 | 12 |
618848 | 618848 | 2020-10-11 | Washington | Arkansas | 5143 | 10380 | 126 |
618971 | 618971 | 2020-10-11 | Washington | Colorado | 8121 | 73 | 0 |
619055 | 619055 | 2020-10-11 | Washington | Florida | 12133 | 1116 | 24 |
619206 | 619206 | 2020-10-11 | Washington | Georgia | 13303 | 775 | 10 |
619264 | 619264 | 2020-10-11 | Washington | Idaho | 16087 | 400 | 7 |
619360 | 619360 | 2020-10-11 | Washington | Illinois | 17189 | 254 | 1 |
619455 | 619455 | 2020-10-11 | Washington | Indiana | 18175 | 308 | 2 |
619552 | 619552 | 2020-10-11 | Washington | Iowa | 19183 | 555 | 11 |
619660 | 619660 | 2020-10-11 | Washington | Kansas | 20201 | 26 | 0 |
619779 | 619779 | 2020-10-11 | Washington | Kentucky | 21229 | 172 | 1 |
619844 | 619844 | 2020-10-11 | Washington | Louisiana | 22117 | 1692 | 67 |
619865 | 619865 | 2020-10-11 | Washington | Maine | 23029 | 20 | 0 |
619889 | 619889 | 2020-10-11 | Washington | Maryland | 24043 | 1986 | 41 |
620073 | 620073 | 2020-10-11 | Washington | Minnesota | 27163 | 4521 | 62 |
620154 | 620154 | 2020-10-11 | Washington | Mississippi | 28151 | 2400 | 88 |
620273 | 620273 | 2020-10-11 | Washington | Missouri | 29221 | 544 | 12 |
620423 | 620423 | 2020-10-11 | Washington | Nebraska | 31177 | 356 | 5 |
620563 | 620563 | 2020-10-11 | Washington | New York | 36115 | 317 | 14 |
620661 | 620661 | 2020-10-11 | Washington | North Carolina | 37187 | 227 | 8 |
620807 | 620807 | 2020-10-11 | Washington | Ohio | 39167 | 284 | 23 |
620886 | 620886 | 2020-10-11 | Washington | Oklahoma | 40147 | 1118 | 41 |
620923 | 620923 | 2020-10-11 | Washington | Oregon | 41067 | 5066 | 67 |
620988 | 620988 | 2020-10-11 | Washington | Pennsylvania | 42125 | 1520 | 30 |
621077 | 621077 | 2020-10-11 | Washington | Rhode Island | 44009 | 955 | 74 |
621280 | 621280 | 2020-10-11 | Washington | Tennessee | 47179 | 2709 | 40 |
621522 | 621522 | 2020-10-11 | Washington | Texas | 48477 | 657 | 48 |
621565 | 621565 | 2020-10-11 | Washington | Utah | 49053 | 3791 | 35 |
621580 | 621580 | 2020-10-11 | Washington | Vermont | 50023 | 82 | 2 |
621711 | 621711 | 2020-10-11 | Washington | Virginia | 51191 | 725 | 21 |
621881 | 621881 | 2020-10-11 | Washington | Wisconsin | 55131 | 3425 | 37 |
615489 | 615489 | 2020-10-10 | Washington | Alabama | 1129 | 599 | 12 |
615606 | 615606 | 2020-10-10 | Washington | Arkansas | 5143 | 10353 | 123 |
615729 | 615729 | 2020-10-10 | Washington | Colorado | 8121 | 72 | 0 |
615813 | 615813 | 2020-10-10 | Washington | Florida | 12133 | 1107 | 24 |
615964 | 615964 | 2020-10-10 | Washington | Georgia | 13303 | 774 | 10 |
616022 | 616022 | 2020-10-10 | Washington | Idaho | 16087 | 400 | 7 |
616118 | 616118 | 2020-10-10 | Washington | Illinois | 17189 | 254 | 1 |
616213 | 616213 | 2020-10-10 | Washington | Indiana | 18175 | 305 | 2 |
616310 | 616310 | 2020-10-10 | Washington | Iowa | 19183 | 555 | 11 |
616418 | 616418 | 2020-10-10 | Washington | Kansas | 20201 | 26 | 0 |
616537 | 616537 | 2020-10-10 | Washington | Kentucky | 21229 | 168 | 1 |
616602 | 616602 | 2020-10-10 | Washington | Louisiana | 22117 | 1683 | 67 |
616623 | 616623 | 2020-10-10 | Washington | Maine | 23029 | 20 | 0 |
616647 | 616647 | 2020-10-10 | Washington | Maryland | 24043 | 1972 | 41 |
616831 | 616831 | 2020-10-10 | Washington | Minnesota | 27163 | 4447 | 62 |
Advanced export
JSON shape: default, array, newline-delimited
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);