ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
117 rows where county = "Washington" and deaths = 54 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2396574 | 2396574 | 2022-04-11 | Washington | Maine | 23029 | 4379 | 54 |
2393319 | 2393319 | 2022-04-10 | Washington | Maine | 23029 | 4379 | 54 |
2390063 | 2390063 | 2022-04-09 | Washington | Maine | 23029 | 4379 | 54 |
2386807 | 2386807 | 2022-04-08 | Washington | Maine | 23029 | 4372 | 54 |
2383552 | 2383552 | 2022-04-07 | Washington | Maine | 23029 | 4368 | 54 |
2245804 | 2245804 | 2022-02-24 | Washington | Alabama | 1129 | 3667 | 54 |
2242553 | 2242553 | 2022-02-23 | Washington | Alabama | 1129 | 3663 | 54 |
2223584 | 2223584 | 2022-02-17 | Washington | Idaho | 16087 | 2270 | 54 |
2220333 | 2220333 | 2022-02-16 | Washington | Idaho | 16087 | 2251 | 54 |
2217082 | 2217082 | 2022-02-15 | Washington | Idaho | 16087 | 2239 | 54 |
2217597 | 2217597 | 2022-02-15 | Washington | Kentucky | 21229 | 3737 | 54 |
2213831 | 2213831 | 2022-02-14 | Washington | Idaho | 16087 | 2233 | 54 |
2214346 | 2214346 | 2022-02-14 | Washington | Kentucky | 21229 | 3729 | 54 |
2211094 | 2211094 | 2022-02-13 | Washington | Kentucky | 21229 | 3680 | 54 |
2207841 | 2207841 | 2022-02-12 | Washington | Kentucky | 21229 | 3680 | 54 |
2204588 | 2204588 | 2022-02-11 | Washington | Kentucky | 21229 | 3680 | 54 |
2201335 | 2201335 | 2022-02-10 | Washington | Kentucky | 21229 | 3664 | 54 |
2198081 | 2198081 | 2022-02-09 | Washington | Kentucky | 21229 | 3643 | 54 |
2194827 | 2194827 | 2022-02-08 | Washington | Kentucky | 21229 | 3625 | 54 |
2191573 | 2191573 | 2022-02-07 | Washington | Kentucky | 21229 | 3606 | 54 |
2188320 | 2188320 | 2022-02-06 | Washington | Kentucky | 21229 | 3587 | 54 |
2185067 | 2185067 | 2022-02-05 | Washington | Kentucky | 21229 | 3587 | 54 |
2181815 | 2181815 | 2022-02-04 | Washington | Kentucky | 21229 | 3587 | 54 |
2178564 | 2178564 | 2022-02-03 | Washington | Kentucky | 21229 | 3570 | 54 |
2175311 | 2175311 | 2022-02-02 | Washington | Kentucky | 21229 | 3534 | 54 |
2172058 | 2172058 | 2022-02-01 | Washington | Kentucky | 21229 | 3492 | 54 |
2168805 | 2168805 | 2022-01-31 | Washington | Kentucky | 21229 | 3465 | 54 |
2165550 | 2165550 | 2022-01-30 | Washington | Kentucky | 21229 | 3396 | 54 |
2162295 | 2162295 | 2022-01-29 | Washington | Kentucky | 21229 | 3396 | 54 |
2159040 | 2159040 | 2022-01-28 | Washington | Kentucky | 21229 | 3396 | 54 |
2155786 | 2155786 | 2022-01-27 | Washington | Kentucky | 21229 | 3334 | 54 |
2152533 | 2152533 | 2022-01-26 | Washington | Kentucky | 21229 | 3295 | 54 |
2149281 | 2149281 | 2022-01-25 | Washington | Kentucky | 21229 | 3253 | 54 |
2146029 | 2146029 | 2022-01-24 | Washington | Kentucky | 21229 | 3213 | 54 |
1785013 | 1785013 | 2021-10-05 | Washington | Iowa | 19183 | 3451 | 54 |
1781764 | 1781764 | 2021-10-04 | Washington | Iowa | 19183 | 3451 | 54 |
1778514 | 1778514 | 2021-10-03 | Washington | Iowa | 19183 | 3451 | 54 |
1775264 | 1775264 | 2021-10-02 | Washington | Iowa | 19183 | 3451 | 54 |
1772014 | 1772014 | 2021-10-01 | Washington | Iowa | 19183 | 3451 | 54 |
1768765 | 1768765 | 2021-09-30 | Washington | Iowa | 19183 | 3451 | 54 |
1765516 | 1765516 | 2021-09-29 | Washington | Iowa | 19183 | 3451 | 54 |
1762267 | 1762267 | 2021-09-28 | Washington | Iowa | 19183 | 3310 | 54 |
1759019 | 1759019 | 2021-09-27 | Washington | Iowa | 19183 | 3310 | 54 |
1755771 | 1755771 | 2021-09-26 | Washington | Iowa | 19183 | 3310 | 54 |
1752523 | 1752523 | 2021-09-25 | Washington | Iowa | 19183 | 3310 | 54 |
1749274 | 1749274 | 2021-09-24 | Washington | Iowa | 19183 | 3310 | 54 |
1746024 | 1746024 | 2021-09-23 | Washington | Iowa | 19183 | 3310 | 54 |
1742775 | 1742775 | 2021-09-22 | Washington | Iowa | 19183 | 3310 | 54 |
1739526 | 1739526 | 2021-09-21 | Washington | Iowa | 19183 | 3161 | 54 |
1736277 | 1736277 | 2021-09-20 | Washington | Iowa | 19183 | 3161 | 54 |
1733027 | 1733027 | 2021-09-19 | Washington | Iowa | 19183 | 3161 | 54 |
1729777 | 1729777 | 2021-09-18 | Washington | Iowa | 19183 | 3161 | 54 |
1726527 | 1726527 | 2021-09-17 | Washington | Iowa | 19183 | 3161 | 54 |
1723278 | 1723278 | 2021-09-16 | Washington | Iowa | 19183 | 3161 | 54 |
1720029 | 1720029 | 2021-09-15 | Washington | Iowa | 19183 | 3161 | 54 |
1716781 | 1716781 | 2021-09-14 | Washington | Iowa | 19183 | 2974 | 54 |
1713535 | 1713535 | 2021-09-13 | Washington | Iowa | 19183 | 2974 | 54 |
1710288 | 1710288 | 2021-09-12 | Washington | Iowa | 19183 | 2974 | 54 |
1707041 | 1707041 | 2021-09-11 | Washington | Iowa | 19183 | 2974 | 54 |
1703793 | 1703793 | 2021-09-10 | Washington | Iowa | 19183 | 2974 | 54 |
1700543 | 1700543 | 2021-09-09 | Washington | Iowa | 19183 | 2974 | 54 |
1697294 | 1697294 | 2021-09-08 | Washington | Iowa | 19183 | 2974 | 54 |
1655784 | 1655784 | 2021-08-26 | Washington | Missouri | 29221 | 3254 | 54 |
1652537 | 1652537 | 2021-08-25 | Washington | Missouri | 29221 | 3231 | 54 |
1649289 | 1649289 | 2021-08-24 | Washington | Missouri | 29221 | 3208 | 54 |
1646040 | 1646040 | 2021-08-23 | Washington | Missouri | 29221 | 3197 | 54 |
1642791 | 1642791 | 2021-08-22 | Washington | Missouri | 29221 | 3191 | 54 |
1639541 | 1639541 | 2021-08-21 | Washington | Missouri | 29221 | 3186 | 54 |
1159284 | 1159284 | 2021-03-26 | Washington | New York | 36115 | 2590 | 54 |
1156037 | 1156037 | 2021-03-25 | Washington | New York | 36115 | 2582 | 54 |
1152790 | 1152790 | 2021-03-24 | Washington | New York | 36115 | 2569 | 54 |
1149543 | 1149543 | 2021-03-23 | Washington | New York | 36115 | 2557 | 54 |
1146296 | 1146296 | 2021-03-22 | Washington | New York | 36115 | 2538 | 54 |
1143049 | 1143049 | 2021-03-21 | Washington | New York | 36115 | 2531 | 54 |
1139802 | 1139802 | 2021-03-20 | Washington | New York | 36115 | 2515 | 54 |
1136556 | 1136556 | 2021-03-19 | Washington | New York | 36115 | 2507 | 54 |
1133310 | 1133310 | 2021-03-18 | Washington | New York | 36115 | 2501 | 54 |
1130062 | 1130062 | 2021-03-17 | Washington | New York | 36115 | 2493 | 54 |
1126815 | 1126815 | 2021-03-16 | Washington | New York | 36115 | 2482 | 54 |
1123569 | 1123569 | 2021-03-15 | Washington | New York | 36115 | 2471 | 54 |
1120323 | 1120323 | 2021-03-14 | Washington | New York | 36115 | 2464 | 54 |
1117076 | 1117076 | 2021-03-13 | Washington | New York | 36115 | 2460 | 54 |
1113829 | 1113829 | 2021-03-12 | Washington | New York | 36115 | 2448 | 54 |
1110583 | 1110583 | 2021-03-11 | Washington | New York | 36115 | 2435 | 54 |
1107337 | 1107337 | 2021-03-10 | Washington | New York | 36115 | 2426 | 54 |
1104091 | 1104091 | 2021-03-09 | Washington | New York | 36115 | 2418 | 54 |
1100845 | 1100845 | 2021-03-08 | Washington | New York | 36115 | 2412 | 54 |
1097599 | 1097599 | 2021-03-07 | Washington | New York | 36115 | 2406 | 54 |
1094351 | 1094351 | 2021-03-06 | Washington | New York | 36115 | 2397 | 54 |
1091105 | 1091105 | 2021-03-05 | Washington | New York | 36115 | 2380 | 54 |
985885 | 985885 | 2021-02-01 | Washington | Georgia | 13303 | 1919 | 54 |
982638 | 982638 | 2021-01-31 | Washington | Georgia | 13303 | 1904 | 54 |
979392 | 979392 | 2021-01-30 | Washington | Georgia | 13303 | 1903 | 54 |
900770 | 900770 | 2021-01-05 | Washington | Virginia | 51191 | 3169 | 54 |
857754 | 857754 | 2020-12-23 | Washington | Oklahoma | 40147 | 2935 | 54 |
812951 | 812951 | 2020-12-09 | Washington | Texas | 48477 | 1028 | 54 |
809707 | 809707 | 2020-12-08 | Washington | Texas | 48477 | 1014 | 54 |
806462 | 806462 | 2020-12-07 | Washington | Texas | 48477 | 998 | 54 |
803217 | 803217 | 2020-12-06 | Washington | Texas | 48477 | 998 | 54 |
799972 | 799972 | 2020-12-05 | Washington | Texas | 48477 | 989 | 54 |
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);