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 132
- Utah 125
- Pennsylvania 118
- Vermont 117
- Minnesota 116
- Louisiana 114
- Arkansas 113
- Illinois 113
- Iowa 113
- New York 113
- Wisconsin 113
- Oklahoma 112
- Tennessee 112
- Alabama 111
- Indiana 110
- Maryland 110
- Mississippi 110
- Georgia 108
- Nebraska 108
- Ohio 108
- Rhode Island 106
- Colorado 105
- Florida 105
- Virginia 105
- Kentucky 103
- Texas 103
- North Carolina 102
- Idaho 98
- Maine 97
- Missouri 92
- …
fips >30
county 1
- Washington · 3,321 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
312430 | 312430 | 2020-07-08 | Washington | Alabama | 1129 | 124 | 7 |
312546 | 312546 | 2020-07-08 | Washington | Arkansas | 5143 | 4266 | 35 |
312665 | 312665 | 2020-07-08 | Washington | Colorado | 8121 | 46 | 0 |
312749 | 312749 | 2020-07-08 | Washington | Florida | 12133 | 136 | 13 |
312900 | 312900 | 2020-07-08 | Washington | Georgia | 13303 | 159 | 1 |
312956 | 312956 | 2020-07-08 | Washington | Idaho | 16087 | 124 | 2 |
313052 | 313052 | 2020-07-08 | Washington | Illinois | 17189 | 25 | 0 |
313147 | 313147 | 2020-07-08 | Washington | Indiana | 18175 | 67 | 1 |
313244 | 313244 | 2020-07-08 | Washington | Iowa | 19183 | 247 | 9 |
313346 | 313346 | 2020-07-08 | Washington | Kansas | 20201 | 1 | 0 |
313464 | 313464 | 2020-07-08 | Washington | Kentucky | 21229 | 28 | 0 |
313529 | 313529 | 2020-07-08 | Washington | Louisiana | 22117 | 765 | 48 |
313550 | 313550 | 2020-07-08 | Washington | Maine | 23029 | 5 | 0 |
313574 | 313574 | 2020-07-08 | Washington | Maryland | 24043 | 694 | 29 |
313757 | 313757 | 2020-07-08 | Washington | Minnesota | 27163 | 1163 | 40 |
313838 | 313838 | 2020-07-08 | Washington | Mississippi | 28151 | 626 | 10 |
313957 | 313957 | 2020-07-08 | Washington | Missouri | 29221 | 26 | 1 |
314076 | 314076 | 2020-07-08 | Washington | Nebraska | 31177 | 53 | 1 |
314213 | 314213 | 2020-07-08 | Washington | New York | 36115 | 247 | 11 |
314311 | 314311 | 2020-07-08 | Washington | North Carolina | 37187 | 43 | 3 |
314454 | 314454 | 2020-07-08 | Washington | Ohio | 39167 | 140 | 20 |
314531 | 314531 | 2020-07-08 | Washington | Oklahoma | 40147 | 437 | 39 |
314568 | 314568 | 2020-07-08 | Washington | Oregon | 41067 | 1676 | 20 |
314632 | 314632 | 2020-07-08 | Washington | Pennsylvania | 42125 | 356 | 6 |
314721 | 314721 | 2020-07-08 | Washington | Rhode Island | 44009 | 538 | 63 |
314921 | 314921 | 2020-07-08 | Washington | Tennessee | 47179 | 197 | 0 |
315157 | 315157 | 2020-07-08 | Washington | Texas | 48477 | 335 | 32 |
315199 | 315199 | 2020-07-08 | Washington | Utah | 49053 | 1460 | 0 |
315213 | 315213 | 2020-07-08 | Washington | Vermont | 50023 | 42 | 1 |
315345 | 315345 | 2020-07-08 | Washington | Virginia | 51191 | 70 | 4 |
315512 | 315512 | 2020-07-08 | Washington | Wisconsin | 55131 | 461 | 19 |
309261 | 309261 | 2020-07-07 | Washington | Alabama | 1129 | 121 | 7 |
309376 | 309376 | 2020-07-07 | Washington | Arkansas | 5143 | 4171 | 34 |
309495 | 309495 | 2020-07-07 | Washington | Colorado | 8121 | 46 | 0 |
309579 | 309579 | 2020-07-07 | Washington | Florida | 12133 | 131 | 13 |
309730 | 309730 | 2020-07-07 | Washington | Georgia | 13303 | 148 | 1 |
309786 | 309786 | 2020-07-07 | Washington | Idaho | 16087 | 120 | 1 |
309882 | 309882 | 2020-07-07 | Washington | Illinois | 17189 | 24 | 0 |
309977 | 309977 | 2020-07-07 | Washington | Indiana | 18175 | 67 | 1 |
310074 | 310074 | 2020-07-07 | Washington | Iowa | 19183 | 245 | 9 |
310176 | 310176 | 2020-07-07 | Washington | Kansas | 20201 | 1 | 0 |
310294 | 310294 | 2020-07-07 | Washington | Kentucky | 21229 | 27 | 0 |
310359 | 310359 | 2020-07-07 | Washington | Louisiana | 22117 | 754 | 47 |
310380 | 310380 | 2020-07-07 | Washington | Maine | 23029 | 4 | 0 |
310404 | 310404 | 2020-07-07 | Washington | Maryland | 24043 | 691 | 29 |
310587 | 310587 | 2020-07-07 | Washington | Minnesota | 27163 | 1137 | 40 |
310668 | 310668 | 2020-07-07 | Washington | Mississippi | 28151 | 617 | 10 |
310786 | 310786 | 2020-07-07 | Washington | Missouri | 29221 | 25 | 1 |
310905 | 310905 | 2020-07-07 | Washington | Nebraska | 31177 | 50 | 1 |
311042 | 311042 | 2020-07-07 | Washington | New York | 36115 | 247 | 11 |
311140 | 311140 | 2020-07-07 | Washington | North Carolina | 37187 | 41 | 3 |
311282 | 311282 | 2020-07-07 | Washington | Ohio | 39167 | 135 | 20 |
311359 | 311359 | 2020-07-07 | Washington | Oklahoma | 40147 | 431 | 39 |
311396 | 311396 | 2020-07-07 | Washington | Oregon | 41067 | 1645 | 20 |
311460 | 311460 | 2020-07-07 | Washington | Pennsylvania | 42125 | 339 | 6 |
311549 | 311549 | 2020-07-07 | Washington | Rhode Island | 44009 | 538 | 63 |
311747 | 311747 | 2020-07-07 | Washington | Tennessee | 47179 | 182 | 0 |
311983 | 311983 | 2020-07-07 | Washington | Texas | 48477 | 318 | 31 |
312025 | 312025 | 2020-07-07 | Washington | Utah | 49053 | 1428 | 0 |
312039 | 312039 | 2020-07-07 | Washington | Vermont | 50023 | 42 | 1 |
312170 | 312170 | 2020-07-07 | Washington | Virginia | 51191 | 68 | 4 |
312337 | 312337 | 2020-07-07 | Washington | Wisconsin | 55131 | 449 | 19 |
306092 | 306092 | 2020-07-06 | Washington | Alabama | 1129 | 114 | 7 |
306208 | 306208 | 2020-07-06 | Washington | Arkansas | 5143 | 4137 | 33 |
306327 | 306327 | 2020-07-06 | Washington | Colorado | 8121 | 46 | 0 |
306411 | 306411 | 2020-07-06 | Washington | Florida | 12133 | 121 | 13 |
306562 | 306562 | 2020-07-06 | Washington | Georgia | 13303 | 136 | 1 |
306618 | 306618 | 2020-07-06 | Washington | Idaho | 16087 | 118 | 1 |
306714 | 306714 | 2020-07-06 | Washington | Illinois | 17189 | 21 | 0 |
306809 | 306809 | 2020-07-06 | Washington | Indiana | 18175 | 67 | 1 |
306906 | 306906 | 2020-07-06 | Washington | Iowa | 19183 | 243 | 9 |
307008 | 307008 | 2020-07-06 | Washington | Kansas | 20201 | 1 | 0 |
307126 | 307126 | 2020-07-06 | Washington | Kentucky | 21229 | 27 | 0 |
307191 | 307191 | 2020-07-06 | Washington | Louisiana | 22117 | 726 | 47 |
307212 | 307212 | 2020-07-06 | Washington | Maine | 23029 | 3 | 0 |
307236 | 307236 | 2020-07-06 | Washington | Maryland | 24043 | 696 | 29 |
307419 | 307419 | 2020-07-06 | Washington | Minnesota | 27163 | 1114 | 40 |
307500 | 307500 | 2020-07-06 | Washington | Mississippi | 28151 | 591 | 9 |
307618 | 307618 | 2020-07-06 | Washington | Missouri | 29221 | 25 | 1 |
307737 | 307737 | 2020-07-06 | Washington | Nebraska | 31177 | 50 | 1 |
307874 | 307874 | 2020-07-06 | Washington | New York | 36115 | 247 | 11 |
307972 | 307972 | 2020-07-06 | Washington | North Carolina | 37187 | 40 | 3 |
308113 | 308113 | 2020-07-06 | Washington | Ohio | 39167 | 135 | 20 |
308190 | 308190 | 2020-07-06 | Washington | Oklahoma | 40147 | 410 | 39 |
308227 | 308227 | 2020-07-06 | Washington | Oregon | 41067 | 1620 | 20 |
308291 | 308291 | 2020-07-06 | Washington | Pennsylvania | 42125 | 318 | 6 |
308380 | 308380 | 2020-07-06 | Washington | Rhode Island | 44009 | 538 | 63 |
308578 | 308578 | 2020-07-06 | Washington | Tennessee | 47179 | 174 | 0 |
308814 | 308814 | 2020-07-06 | Washington | Texas | 48477 | 318 | 31 |
308856 | 308856 | 2020-07-06 | Washington | Utah | 49053 | 1361 | 0 |
308870 | 308870 | 2020-07-06 | Washington | Vermont | 50023 | 42 | 1 |
309001 | 309001 | 2020-07-06 | Washington | Virginia | 51191 | 67 | 4 |
309168 | 309168 | 2020-07-06 | Washington | Wisconsin | 55131 | 440 | 17 |
302928 | 302928 | 2020-07-05 | Washington | Alabama | 1129 | 112 | 7 |
303044 | 303044 | 2020-07-05 | Washington | Arkansas | 5143 | 4050 | 32 |
303163 | 303163 | 2020-07-05 | Washington | Colorado | 8121 | 46 | 0 |
303247 | 303247 | 2020-07-05 | Washington | Florida | 12133 | 121 | 13 |
303398 | 303398 | 2020-07-05 | Washington | Georgia | 13303 | 134 | 1 |
303453 | 303453 | 2020-07-05 | Washington | Idaho | 16087 | 118 | 1 |
303549 | 303549 | 2020-07-05 | Washington | Illinois | 17189 | 21 | 0 |
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);