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 404
- Utah 397
- Pennsylvania 390
- Vermont 389
- Minnesota 388
- Louisiana 386
- Wisconsin 386
- Arkansas 385
- Illinois 385
- Iowa 385
- New York 385
- Oklahoma 384
- Tennessee 384
- Alabama 383
- Indiana 382
- Maryland 382
- Mississippi 382
- Georgia 380
- Nebraska 380
- Ohio 380
- Rhode Island 378
- Colorado 377
- Florida 377
- Virginia 377
- Kentucky 375
- Texas 375
- North Carolina 374
- Idaho 370
- Maine 369
- Missouri 364
- …
fips >30
county 1
- Washington · 11,754 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1199577 | 1199577 | 2021-04-07 | Washington | Wisconsin | 55131 | 16149 | 152 |
1193173 | 1193173 | 2021-04-06 | Washington | Alabama | 1129 | 1640 | 38 |
1193291 | 1193291 | 2021-04-06 | Washington | Arkansas | 5143 | 30302 | 344 |
1193414 | 1193414 | 2021-04-06 | Washington | Colorado | 8121 | 437 | 12 |
1193498 | 1193498 | 2021-04-06 | Washington | Florida | 12133 | 2678 | 50 |
1193649 | 1193649 | 2021-04-06 | Washington | Georgia | 13303 | 2094 | 80 |
1193708 | 1193708 | 2021-04-06 | Washington | Idaho | 16087 | 1204 | 21 |
1193804 | 1193804 | 2021-04-06 | Washington | Illinois | 17189 | 1617 | 31 |
1193899 | 1193899 | 2021-04-06 | Washington | Indiana | 18175 | 2252 | 29 |
1193996 | 1193996 | 2021-04-06 | Washington | Iowa | 19183 | 2466 | 49 |
1194105 | 1194105 | 2021-04-06 | Washington | Kansas | 20201 | 532 | 9 |
1194224 | 1194224 | 2021-04-06 | Washington | Kentucky | 21229 | 1396 | 36 |
1194289 | 1194289 | 2021-04-06 | Washington | Louisiana | 22117 | 4291 | 127 |
1194309 | 1194309 | 2021-04-06 | Washington | Maine | 23029 | 785 | 15 |
1194333 | 1194333 | 2021-04-06 | Washington | Maryland | 24043 | 13447 | 264 |
1194517 | 1194517 | 2021-04-06 | Washington | Minnesota | 27163 | 23804 | 272 |
1194598 | 1194598 | 2021-04-06 | Washington | Mississippi | 28151 | 5270 | 132 |
1194717 | 1194717 | 2021-04-06 | Washington | Missouri | 29221 | 2731 | 49 |
1194867 | 1194867 | 2021-04-06 | Washington | Nebraska | 31177 | 2102 | 22 |
1195008 | 1195008 | 2021-04-06 | Washington | New York | 36115 | 2739 | 55 |
1195106 | 1195106 | 2021-04-06 | Washington | North Carolina | 37187 | 1025 | 31 |
1195253 | 1195253 | 2021-04-06 | Washington | Ohio | 39167 | 5009 | 105 |
1195332 | 1195332 | 2021-04-06 | Washington | Oklahoma | 40147 | 5047 | 95 |
1195369 | 1195369 | 2021-04-06 | Washington | Oregon | 41067 | 22625 | 228 |
1195434 | 1195434 | 2021-04-06 | Washington | Pennsylvania | 42125 | 15502 | 276 |
1195523 | 1195523 | 2021-04-06 | Washington | Rhode Island | 44009 | 9102 | 166 |
1195726 | 1195726 | 2021-04-06 | Washington | Tennessee | 47179 | 13695 | 239 |
1195970 | 1195970 | 2021-04-06 | Washington | Texas | 48477 | 3872 | 89 |
1196013 | 1196013 | 2021-04-06 | Washington | Utah | 49053 | 20600 | 204 |
1196028 | 1196028 | 2021-04-06 | Washington | Vermont | 50023 | 1649 | 15 |
1196160 | 1196160 | 2021-04-06 | Washington | Virginia | 51191 | 4531 | 101 |
1196328 | 1196328 | 2021-04-06 | Washington | Wisconsin | 55131 | 16112 | 151 |
1189923 | 1189923 | 2021-04-05 | Washington | Alabama | 1129 | 1639 | 38 |
1190041 | 1190041 | 2021-04-05 | Washington | Arkansas | 5143 | 30271 | 344 |
1190164 | 1190164 | 2021-04-05 | Washington | Colorado | 8121 | 437 | 12 |
1190248 | 1190248 | 2021-04-05 | Washington | Florida | 12133 | 2678 | 50 |
1190399 | 1190399 | 2021-04-05 | Washington | Georgia | 13303 | 2092 | 79 |
1190458 | 1190458 | 2021-04-05 | Washington | Idaho | 16087 | 1204 | 21 |
1190554 | 1190554 | 2021-04-05 | Washington | Illinois | 17189 | 1616 | 31 |
1190649 | 1190649 | 2021-04-05 | Washington | Indiana | 18175 | 2249 | 29 |
1190746 | 1190746 | 2021-04-05 | Washington | Iowa | 19183 | 2457 | 49 |
1190855 | 1190855 | 2021-04-05 | Washington | Kansas | 20201 | 532 | 9 |
1190974 | 1190974 | 2021-04-05 | Washington | Kentucky | 21229 | 1396 | 36 |
1191039 | 1191039 | 2021-04-05 | Washington | Louisiana | 22117 | 4287 | 127 |
1191060 | 1191060 | 2021-04-05 | Washington | Maine | 23029 | 783 | 15 |
1191084 | 1191084 | 2021-04-05 | Washington | Maryland | 24043 | 13428 | 263 |
1191268 | 1191268 | 2021-04-05 | Washington | Minnesota | 27163 | 23674 | 272 |
1191349 | 1191349 | 2021-04-05 | Washington | Mississippi | 28151 | 5265 | 132 |
1191468 | 1191468 | 2021-04-05 | Washington | Missouri | 29221 | 2731 | 49 |
1191618 | 1191618 | 2021-04-05 | Washington | Nebraska | 31177 | 2099 | 22 |
1191760 | 1191760 | 2021-04-05 | Washington | New York | 36115 | 2733 | 55 |
1191858 | 1191858 | 2021-04-05 | Washington | North Carolina | 37187 | 1025 | 31 |
1192005 | 1192005 | 2021-04-05 | Washington | Ohio | 39167 | 5006 | 105 |
1192084 | 1192084 | 2021-04-05 | Washington | Oklahoma | 40147 | 5047 | 95 |
1192121 | 1192121 | 2021-04-05 | Washington | Oregon | 41067 | 22526 | 226 |
1192186 | 1192186 | 2021-04-05 | Washington | Pennsylvania | 42125 | 15390 | 276 |
1192275 | 1192275 | 2021-04-05 | Washington | Rhode Island | 44009 | 9102 | 166 |
1192478 | 1192478 | 2021-04-05 | Washington | Tennessee | 47179 | 13660 | 239 |
1192722 | 1192722 | 2021-04-05 | Washington | Texas | 48477 | 3868 | 89 |
1192765 | 1192765 | 2021-04-05 | Washington | Utah | 49053 | 20592 | 204 |
1192780 | 1192780 | 2021-04-05 | Washington | Vermont | 50023 | 1644 | 15 |
1192912 | 1192912 | 2021-04-05 | Washington | Virginia | 51191 | 4515 | 101 |
1193080 | 1193080 | 2021-04-05 | Washington | Wisconsin | 55131 | 16087 | 151 |
1186676 | 1186676 | 2021-04-04 | Washington | Alabama | 1129 | 1639 | 38 |
1186794 | 1186794 | 2021-04-04 | Washington | Arkansas | 5143 | 30267 | 344 |
1186917 | 1186917 | 2021-04-04 | Washington | Colorado | 8121 | 437 | 12 |
1187001 | 1187001 | 2021-04-04 | Washington | Florida | 12133 | 2678 | 50 |
1187152 | 1187152 | 2021-04-04 | Washington | Georgia | 13303 | 2116 | 79 |
1187211 | 1187211 | 2021-04-04 | Washington | Idaho | 16087 | 1203 | 21 |
1187307 | 1187307 | 2021-04-04 | Washington | Illinois | 17189 | 1616 | 31 |
1187402 | 1187402 | 2021-04-04 | Washington | Indiana | 18175 | 2247 | 29 |
1187499 | 1187499 | 2021-04-04 | Washington | Iowa | 19183 | 2451 | 49 |
1187608 | 1187608 | 2021-04-04 | Washington | Kansas | 20201 | 531 | 9 |
1187727 | 1187727 | 2021-04-04 | Washington | Kentucky | 21229 | 1396 | 36 |
1187792 | 1187792 | 2021-04-04 | Washington | Louisiana | 22117 | 4283 | 127 |
1187812 | 1187812 | 2021-04-04 | Washington | Maine | 23029 | 782 | 15 |
1187836 | 1187836 | 2021-04-04 | Washington | Maryland | 24043 | 13412 | 263 |
1188020 | 1188020 | 2021-04-04 | Washington | Minnesota | 27163 | 23618 | 272 |
1188101 | 1188101 | 2021-04-04 | Washington | Mississippi | 28151 | 5264 | 132 |
1188220 | 1188220 | 2021-04-04 | Washington | Missouri | 29221 | 2729 | 49 |
1188370 | 1188370 | 2021-04-04 | Washington | Nebraska | 31177 | 2099 | 22 |
1188511 | 1188511 | 2021-04-04 | Washington | New York | 36115 | 2725 | 55 |
1188609 | 1188609 | 2021-04-04 | Washington | North Carolina | 37187 | 1022 | 31 |
1188756 | 1188756 | 2021-04-04 | Washington | Ohio | 39167 | 4994 | 105 |
1188835 | 1188835 | 2021-04-04 | Washington | Oklahoma | 40147 | 5047 | 95 |
1188872 | 1188872 | 2021-04-04 | Washington | Oregon | 41067 | 22526 | 225 |
1188937 | 1188937 | 2021-04-04 | Washington | Pennsylvania | 42125 | 15368 | 276 |
1189026 | 1189026 | 2021-04-04 | Washington | Rhode Island | 44009 | 9102 | 166 |
1189229 | 1189229 | 2021-04-04 | Washington | Tennessee | 47179 | 13533 | 239 |
1189473 | 1189473 | 2021-04-04 | Washington | Texas | 48477 | 3860 | 89 |
1189516 | 1189516 | 2021-04-04 | Washington | Utah | 49053 | 20592 | 204 |
1189531 | 1189531 | 2021-04-04 | Washington | Vermont | 50023 | 1639 | 15 |
1189662 | 1189662 | 2021-04-04 | Washington | Virginia | 51191 | 4509 | 101 |
1189830 | 1189830 | 2021-04-04 | Washington | Wisconsin | 55131 | 16087 | 151 |
1183429 | 1183429 | 2021-04-03 | Washington | Alabama | 1129 | 1639 | 38 |
1183547 | 1183547 | 2021-04-03 | Washington | Arkansas | 5143 | 30258 | 344 |
1183670 | 1183670 | 2021-04-03 | Washington | Colorado | 8121 | 436 | 12 |
1183754 | 1183754 | 2021-04-03 | Washington | Florida | 12133 | 2678 | 50 |
1183905 | 1183905 | 2021-04-03 | Washington | Georgia | 13303 | 2115 | 79 |
1183964 | 1183964 | 2021-04-03 | Washington | Idaho | 16087 | 1203 | 21 |
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);