ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
89 rows where county = "Washington" and deaths = 58 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2327108 | 2327108 | 2022-03-21 | Washington | Alabama | 1129 | 3722 | 58 |
2323855 | 2323855 | 2022-03-20 | Washington | Alabama | 1129 | 3722 | 58 |
2320601 | 2320601 | 2022-03-19 | Washington | Alabama | 1129 | 3722 | 58 |
2317347 | 2317347 | 2022-03-18 | Washington | Alabama | 1129 | 3722 | 58 |
2314094 | 2314094 | 2022-03-17 | Washington | Alabama | 1129 | 3721 | 58 |
2310841 | 2310841 | 2022-03-16 | Washington | Alabama | 1129 | 3721 | 58 |
2307588 | 2307588 | 2022-03-15 | Washington | Alabama | 1129 | 3721 | 58 |
2304337 | 2304337 | 2022-03-14 | Washington | Alabama | 1129 | 3721 | 58 |
2301085 | 2301085 | 2022-03-13 | Washington | Alabama | 1129 | 3720 | 58 |
2297833 | 2297833 | 2022-03-12 | Washington | Alabama | 1129 | 3720 | 58 |
2294581 | 2294581 | 2022-03-11 | Washington | Alabama | 1129 | 3720 | 58 |
2054654 | 2054654 | 2021-12-27 | Washington | Indiana | 18175 | 4181 | 58 |
2051404 | 2051404 | 2021-12-26 | Washington | Indiana | 18175 | 4122 | 58 |
2048154 | 2048154 | 2021-12-25 | Washington | Indiana | 18175 | 4122 | 58 |
2044904 | 2044904 | 2021-12-24 | Washington | Indiana | 18175 | 4122 | 58 |
2041655 | 2041655 | 2021-12-23 | Washington | Indiana | 18175 | 4122 | 58 |
2038405 | 2038405 | 2021-12-22 | Washington | Indiana | 18175 | 4122 | 58 |
2035155 | 2035155 | 2021-12-21 | Washington | Indiana | 18175 | 4116 | 58 |
2031905 | 2031905 | 2021-12-20 | Washington | Indiana | 18175 | 4107 | 58 |
2028654 | 2028654 | 2021-12-19 | Washington | Indiana | 18175 | 4081 | 58 |
2025403 | 2025403 | 2021-12-18 | Washington | Indiana | 18175 | 4081 | 58 |
2022152 | 2022152 | 2021-12-17 | Washington | Indiana | 18175 | 4081 | 58 |
2018901 | 2018901 | 2021-12-16 | Washington | Indiana | 18175 | 4073 | 58 |
2015651 | 2015651 | 2021-12-15 | Washington | Indiana | 18175 | 4059 | 58 |
2012400 | 2012400 | 2021-12-14 | Washington | Indiana | 18175 | 4051 | 58 |
1746745 | 1746745 | 2021-09-23 | Washington | Missouri | 29221 | 3742 | 58 |
1743496 | 1743496 | 2021-09-22 | Washington | Missouri | 29221 | 3733 | 58 |
1740247 | 1740247 | 2021-09-21 | Washington | Missouri | 29221 | 3722 | 58 |
1726028 | 1726028 | 2021-09-17 | Washington | Florida | 12133 | 4403 | 58 |
1722779 | 1722779 | 2021-09-16 | Washington | Florida | 12133 | 4304 | 58 |
1719530 | 1719530 | 2021-09-15 | Washington | Florida | 12133 | 4304 | 58 |
1716282 | 1716282 | 2021-09-14 | Washington | Florida | 12133 | 4304 | 58 |
1695058 | 1695058 | 2021-09-07 | Washington | New York | 36115 | 3572 | 58 |
1691810 | 1691810 | 2021-09-06 | Washington | New York | 36115 | 3559 | 58 |
1688560 | 1688560 | 2021-09-05 | Washington | New York | 36115 | 3543 | 58 |
1685310 | 1685310 | 2021-09-04 | Washington | New York | 36115 | 3527 | 58 |
1682059 | 1682059 | 2021-09-03 | Washington | New York | 36115 | 3512 | 58 |
1678810 | 1678810 | 2021-09-02 | Washington | New York | 36115 | 3486 | 58 |
1675562 | 1675562 | 2021-09-01 | Washington | New York | 36115 | 3471 | 58 |
1672315 | 1672315 | 2021-08-31 | Washington | New York | 36115 | 3462 | 58 |
1669067 | 1669067 | 2021-08-30 | Washington | New York | 36115 | 3450 | 58 |
1665820 | 1665820 | 2021-08-29 | Washington | New York | 36115 | 3440 | 58 |
1662572 | 1662572 | 2021-08-28 | Washington | New York | 36115 | 3434 | 58 |
1659324 | 1659324 | 2021-08-27 | Washington | New York | 36115 | 3419 | 58 |
1656075 | 1656075 | 2021-08-26 | Washington | New York | 36115 | 3404 | 58 |
1652828 | 1652828 | 2021-08-25 | Washington | New York | 36115 | 3388 | 58 |
1649580 | 1649580 | 2021-08-24 | Washington | New York | 36115 | 3382 | 58 |
998870 | 998870 | 2021-02-05 | Washington | Georgia | 13303 | 1953 | 58 |
926732 | 926732 | 2021-01-13 | Washington | Virginia | 51191 | 3509 | 58 |
923486 | 923486 | 2021-01-12 | Washington | Virginia | 51191 | 3457 | 58 |
920241 | 920241 | 2021-01-11 | Washington | Virginia | 51191 | 3447 | 58 |
916996 | 916996 | 2021-01-10 | Washington | Virginia | 51191 | 3414 | 58 |
913751 | 913751 | 2021-01-09 | Washington | Virginia | 51191 | 3373 | 58 |
877224 | 877224 | 2020-12-29 | Washington | Oklahoma | 40147 | 3072 | 58 |
873979 | 873979 | 2020-12-28 | Washington | Oklahoma | 40147 | 3063 | 58 |
858392 | 858392 | 2020-12-23 | Washington | Texas | 48477 | 1362 | 58 |
855147 | 855147 | 2020-12-22 | Washington | Texas | 48477 | 1349 | 58 |
752903 | 752903 | 2020-11-21 | Washington | Maryland | 24043 | 3509 | 58 |
750757 | 750757 | 2020-11-20 | Washington | Pennsylvania | 42125 | 3596 | 58 |
738350 | 738350 | 2020-11-16 | Washington | Utah | 49053 | 7134 | 58 |
728930 | 728930 | 2020-11-13 | Washington | Wisconsin | 55131 | 7465 | 58 |
682921 | 682921 | 2020-10-30 | Washington | Tennessee | 47179 | 3877 | 58 |
600621 | 600621 | 2020-10-05 | Washington | Minnesota | 27163 | 4180 | 58 |
597378 | 597378 | 2020-10-04 | Washington | Minnesota | 27163 | 4132 | 58 |
559337 | 559337 | 2020-09-22 | Washington | Oregon | 41067 | 4355 | 58 |
556100 | 556100 | 2020-09-21 | Washington | Oregon | 41067 | 4315 | 58 |
552863 | 552863 | 2020-09-20 | Washington | Oregon | 41067 | 4289 | 58 |
549624 | 549624 | 2020-09-19 | Washington | Oregon | 41067 | 4264 | 58 |
546385 | 546385 | 2020-09-18 | Washington | Oregon | 41067 | 4241 | 58 |
543148 | 543148 | 2020-09-17 | Washington | Oregon | 41067 | 4208 | 58 |
539912 | 539912 | 2020-09-16 | Washington | Oregon | 41067 | 4180 | 58 |
479621 | 479621 | 2020-08-29 | Washington | Arkansas | 5143 | 6850 | 58 |
435413 | 435413 | 2020-08-15 | Washington | Louisiana | 22117 | 1320 | 58 |
432188 | 432188 | 2020-08-14 | Washington | Louisiana | 22117 | 1320 | 58 |
428960 | 428960 | 2020-08-13 | Washington | Louisiana | 22117 | 1312 | 58 |
425736 | 425736 | 2020-08-12 | Washington | Louisiana | 22117 | 1298 | 58 |
422515 | 422515 | 2020-08-11 | Washington | Louisiana | 22117 | 1293 | 58 |
419293 | 419293 | 2020-08-10 | Washington | Louisiana | 22117 | 1281 | 58 |
416072 | 416072 | 2020-08-09 | Washington | Louisiana | 22117 | 1265 | 58 |
412852 | 412852 | 2020-08-08 | Washington | Louisiana | 22117 | 1247 | 58 |
409632 | 409632 | 2020-08-07 | Washington | Louisiana | 22117 | 1247 | 58 |
406412 | 406412 | 2020-08-06 | Washington | Louisiana | 22117 | 1235 | 58 |
403194 | 403194 | 2020-08-05 | Washington | Louisiana | 22117 | 1220 | 58 |
399977 | 399977 | 2020-08-04 | Washington | Louisiana | 22117 | 1211 | 58 |
396762 | 396762 | 2020-08-03 | Washington | Louisiana | 22117 | 1199 | 58 |
393546 | 393546 | 2020-08-02 | Washington | Louisiana | 22117 | 1193 | 58 |
390329 | 390329 | 2020-08-01 | Washington | Louisiana | 22117 | 1166 | 58 |
387112 | 387112 | 2020-07-31 | Washington | Louisiana | 22117 | 1166 | 58 |
383894 | 383894 | 2020-07-30 | Washington | Louisiana | 22117 | 1151 | 58 |
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);