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 155
- Utah 148
- Pennsylvania 141
- Vermont 140
- Minnesota 139
- Louisiana 137
- Arkansas 136
- Illinois 136
- Iowa 136
- New York 136
- Wisconsin 136
- Oklahoma 135
- Tennessee 135
- Alabama 133
- Indiana 133
- Maryland 133
- Mississippi 133
- Georgia 131
- Nebraska 131
- Ohio 131
- Rhode Island 129
- Colorado 128
- Florida 128
- Virginia 128
- Kentucky 126
- Texas 126
- North Carolina 125
- Idaho 121
- Maine 120
- Missouri 115
- …
fips >30
county 1
- Washington · 4,033 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386121 | 386121 | 2020-07-31 | Washington | Arkansas | 5143 | 5896 | 45 |
386243 | 386243 | 2020-07-31 | Washington | Colorado | 8121 | 47 | 0 |
386327 | 386327 | 2020-07-31 | Washington | Florida | 12133 | 495 | 14 |
386478 | 386478 | 2020-07-31 | Washington | Georgia | 13303 | 400 | 2 |
386534 | 386534 | 2020-07-31 | Washington | Idaho | 16087 | 183 | 2 |
386630 | 386630 | 2020-07-31 | Washington | Illinois | 17189 | 56 | 0 |
386725 | 386725 | 2020-07-31 | Washington | Indiana | 18175 | 104 | 1 |
386822 | 386822 | 2020-07-31 | Washington | Iowa | 19183 | 284 | 10 |
386928 | 386928 | 2020-07-31 | Washington | Kansas | 20201 | 2 | 0 |
387047 | 387047 | 2020-07-31 | Washington | Kentucky | 21229 | 55 | 0 |
387112 | 387112 | 2020-07-31 | Washington | Louisiana | 22117 | 1166 | 58 |
387133 | 387133 | 2020-07-31 | Washington | Maine | 23029 | 7 | 0 |
387157 | 387157 | 2020-07-31 | Washington | Maryland | 24043 | 952 | 30 |
387341 | 387341 | 2020-07-31 | Washington | Minnesota | 27163 | 1817 | 43 |
387422 | 387422 | 2020-07-31 | Washington | Mississippi | 28151 | 1419 | 32 |
387541 | 387541 | 2020-07-31 | Washington | Missouri | 29221 | 55 | 1 |
387678 | 387678 | 2020-07-31 | Washington | Nebraska | 31177 | 101 | 1 |
387816 | 387816 | 2020-07-31 | Washington | New York | 36115 | 254 | 11 |
387914 | 387914 | 2020-07-31 | Washington | North Carolina | 37187 | 114 | 3 |
388060 | 388060 | 2020-07-31 | Washington | Ohio | 39167 | 192 | 21 |
388138 | 388138 | 2020-07-31 | Washington | Oklahoma | 40147 | 557 | 39 |
388175 | 388175 | 2020-07-31 | Washington | Oregon | 41067 | 2740 | 22 |
388239 | 388239 | 2020-07-31 | Washington | Pennsylvania | 42125 | 740 | 11 |
388328 | 388328 | 2020-07-31 | Washington | Rhode Island | 44009 | 590 | 64 |
388530 | 388530 | 2020-07-31 | Washington | Tennessee | 47179 | 943 | 2 |
388770 | 388770 | 2020-07-31 | Washington | Texas | 48477 | 465 | 38 |
388812 | 388812 | 2020-07-31 | Washington | Utah | 49053 | 2274 | 20 |
388827 | 388827 | 2020-07-31 | Washington | Vermont | 50023 | 47 | 2 |
388958 | 388958 | 2020-07-31 | Washington | Virginia | 51191 | 170 | 4 |
389128 | 389128 | 2020-07-31 | Washington | Wisconsin | 55131 | 854 | 23 |
382786 | 382786 | 2020-07-30 | Washington | Alabama | 1129 | 301 | 10 |
382903 | 382903 | 2020-07-30 | Washington | Arkansas | 5143 | 5855 | 43 |
383025 | 383025 | 2020-07-30 | Washington | Colorado | 8121 | 46 | 0 |
383109 | 383109 | 2020-07-30 | Washington | Florida | 12133 | 488 | 13 |
383260 | 383260 | 2020-07-30 | Washington | Georgia | 13303 | 387 | 1 |
383316 | 383316 | 2020-07-30 | Washington | Idaho | 16087 | 181 | 2 |
383412 | 383412 | 2020-07-30 | Washington | Illinois | 17189 | 53 | 0 |
383507 | 383507 | 2020-07-30 | Washington | Indiana | 18175 | 99 | 1 |
383604 | 383604 | 2020-07-30 | Washington | Iowa | 19183 | 284 | 10 |
383710 | 383710 | 2020-07-30 | Washington | Kansas | 20201 | 2 | 0 |
383829 | 383829 | 2020-07-30 | Washington | Kentucky | 21229 | 54 | 0 |
383894 | 383894 | 2020-07-30 | Washington | Louisiana | 22117 | 1151 | 58 |
383915 | 383915 | 2020-07-30 | Washington | Maine | 23029 | 7 | 0 |
383939 | 383939 | 2020-07-30 | Washington | Maryland | 24043 | 936 | 30 |
384123 | 384123 | 2020-07-30 | Washington | Minnesota | 27163 | 1792 | 43 |
384204 | 384204 | 2020-07-30 | Washington | Mississippi | 28151 | 1389 | 28 |
384323 | 384323 | 2020-07-30 | Washington | Missouri | 29221 | 54 | 1 |
384460 | 384460 | 2020-07-30 | Washington | Nebraska | 31177 | 99 | 1 |
384599 | 384599 | 2020-07-30 | Washington | New York | 36115 | 254 | 11 |
384697 | 384697 | 2020-07-30 | Washington | North Carolina | 37187 | 113 | 3 |
384843 | 384843 | 2020-07-30 | Washington | Ohio | 39167 | 191 | 21 |
384921 | 384921 | 2020-07-30 | Washington | Oklahoma | 40147 | 556 | 39 |
384958 | 384958 | 2020-07-30 | Washington | Oregon | 41067 | 2700 | 22 |
385022 | 385022 | 2020-07-30 | Washington | Pennsylvania | 42125 | 723 | 11 |
385111 | 385111 | 2020-07-30 | Washington | Rhode Island | 44009 | 590 | 64 |
385313 | 385313 | 2020-07-30 | Washington | Tennessee | 47179 | 870 | 2 |
385553 | 385553 | 2020-07-30 | Washington | Texas | 48477 | 452 | 37 |
385595 | 385595 | 2020-07-30 | Washington | Utah | 49053 | 2233 | 20 |
385610 | 385610 | 2020-07-30 | Washington | Vermont | 50023 | 47 | 2 |
385741 | 385741 | 2020-07-30 | Washington | Virginia | 51191 | 164 | 4 |
385911 | 385911 | 2020-07-30 | Washington | Wisconsin | 55131 | 804 | 23 |
379569 | 379569 | 2020-07-29 | Washington | Alabama | 1129 | 299 | 10 |
379686 | 379686 | 2020-07-29 | Washington | Arkansas | 5143 | 5812 | 43 |
379808 | 379808 | 2020-07-29 | Washington | Colorado | 8121 | 46 | 0 |
379892 | 379892 | 2020-07-29 | Washington | Florida | 12133 | 469 | 13 |
380043 | 380043 | 2020-07-29 | Washington | Georgia | 13303 | 376 | 1 |
380099 | 380099 | 2020-07-29 | Washington | Idaho | 16087 | 177 | 2 |
380195 | 380195 | 2020-07-29 | Washington | Illinois | 17189 | 52 | 0 |
380290 | 380290 | 2020-07-29 | Washington | Indiana | 18175 | 96 | 1 |
380387 | 380387 | 2020-07-29 | Washington | Iowa | 19183 | 281 | 10 |
380493 | 380493 | 2020-07-29 | Washington | Kansas | 20201 | 2 | 0 |
380612 | 380612 | 2020-07-29 | Washington | Kentucky | 21229 | 53 | 0 |
380677 | 380677 | 2020-07-29 | Washington | Louisiana | 22117 | 1133 | 56 |
380698 | 380698 | 2020-07-29 | Washington | Maine | 23029 | 7 | 0 |
380722 | 380722 | 2020-07-29 | Washington | Maryland | 24043 | 931 | 30 |
380906 | 380906 | 2020-07-29 | Washington | Minnesota | 27163 | 1760 | 43 |
380988 | 380988 | 2020-07-29 | Washington | Mississippi | 28151 | 1322 | 26 |
381107 | 381107 | 2020-07-29 | Washington | Missouri | 29221 | 50 | 1 |
381243 | 381243 | 2020-07-29 | Washington | Nebraska | 31177 | 95 | 1 |
381381 | 381381 | 2020-07-29 | Washington | New York | 36115 | 254 | 11 |
381479 | 381479 | 2020-07-29 | Washington | North Carolina | 37187 | 110 | 3 |
381625 | 381625 | 2020-07-29 | Washington | Ohio | 39167 | 190 | 21 |
381703 | 381703 | 2020-07-29 | Washington | Oklahoma | 40147 | 547 | 39 |
381740 | 381740 | 2020-07-29 | Washington | Oregon | 41067 | 2638 | 22 |
381804 | 381804 | 2020-07-29 | Washington | Pennsylvania | 42125 | 710 | 10 |
381893 | 381893 | 2020-07-29 | Washington | Rhode Island | 44009 | 590 | 64 |
382095 | 382095 | 2020-07-29 | Washington | Tennessee | 47179 | 840 | 2 |
382335 | 382335 | 2020-07-29 | Washington | Texas | 48477 | 452 | 38 |
382377 | 382377 | 2020-07-29 | Washington | Utah | 49053 | 2215 | 20 |
382392 | 382392 | 2020-07-29 | Washington | Vermont | 50023 | 47 | 1 |
382523 | 382523 | 2020-07-29 | Washington | Virginia | 51191 | 157 | 4 |
382693 | 382693 | 2020-07-29 | Washington | Wisconsin | 55131 | 789 | 23 |
376353 | 376353 | 2020-07-28 | Washington | Alabama | 1129 | 291 | 10 |
376470 | 376470 | 2020-07-28 | Washington | Arkansas | 5143 | 5783 | 42 |
376591 | 376591 | 2020-07-28 | Washington | Colorado | 8121 | 46 | 0 |
376675 | 376675 | 2020-07-28 | Washington | Florida | 12133 | 460 | 13 |
376826 | 376826 | 2020-07-28 | Washington | Georgia | 13303 | 365 | 1 |
376882 | 376882 | 2020-07-28 | Washington | Idaho | 16087 | 171 | 2 |
376978 | 376978 | 2020-07-28 | Washington | Illinois | 17189 | 50 | 0 |
377073 | 377073 | 2020-07-28 | Washington | Indiana | 18175 | 91 | 1 |
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);