ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where fips = 53053 and state = "Washington" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2177284 | 2177284 | 2022-02-02 | Pierce | Washington | 53053 | 176828 | 1176 |
2174031 | 2174031 | 2022-02-01 | Pierce | Washington | 53053 | 175305 | 1161 |
2170779 | 2170779 | 2022-01-31 | Pierce | Washington | 53053 | 175305 | 1161 |
2167526 | 2167526 | 2022-01-30 | Pierce | Washington | 53053 | 171400 | 1144 |
2164271 | 2164271 | 2022-01-29 | Pierce | Washington | 53053 | 171400 | 1144 |
2161016 | 2161016 | 2022-01-28 | Pierce | Washington | 53053 | 171400 | 1144 |
2157760 | 2157760 | 2022-01-27 | Pierce | Washington | 53053 | 167380 | 1123 |
2154507 | 2154507 | 2022-01-26 | Pierce | Washington | 53053 | 167380 | 1123 |
2151254 | 2151254 | 2022-01-25 | Pierce | Washington | 53053 | 160394 | 1103 |
2148002 | 2148002 | 2022-01-24 | Pierce | Washington | 53053 | 160394 | 1103 |
2144750 | 2144750 | 2022-01-23 | Pierce | Washington | 53053 | 153902 | 1094 |
2141495 | 2141495 | 2022-01-22 | Pierce | Washington | 53053 | 153896 | 1094 |
2138239 | 2138239 | 2022-01-21 | Pierce | Washington | 53053 | 153896 | 1094 |
2134984 | 2134984 | 2022-01-20 | Pierce | Washington | 53053 | 151420 | 1082 |
2131732 | 2131732 | 2022-01-19 | Pierce | Washington | 53053 | 149334 | 1063 |
2128478 | 2128478 | 2022-01-18 | Pierce | Washington | 53053 | 147731 | 1063 |
2125225 | 2125225 | 2022-01-17 | Pierce | Washington | 53053 | 138758 | 1061 |
2121973 | 2121973 | 2022-01-16 | Pierce | Washington | 53053 | 138758 | 1061 |
2118721 | 2118721 | 2022-01-15 | Pierce | Washington | 53053 | 138758 | 1061 |
2115469 | 2115469 | 2022-01-14 | Pierce | Washington | 53053 | 138758 | 1061 |
2112217 | 2112217 | 2022-01-13 | Pierce | Washington | 53053 | 137177 | 1051 |
2108965 | 2108965 | 2022-01-12 | Pierce | Washington | 53053 | 135523 | 1047 |
2105714 | 2105714 | 2022-01-11 | Pierce | Washington | 53053 | 133208 | 1034 |
2102463 | 2102463 | 2022-01-10 | Pierce | Washington | 53053 | 131637 | 1034 |
2099212 | 2099212 | 2022-01-09 | Pierce | Washington | 53053 | 125310 | 1033 |
2095961 | 2095961 | 2022-01-08 | Pierce | Washington | 53053 | 125310 | 1033 |
2092709 | 2092709 | 2022-01-07 | Pierce | Washington | 53053 | 125310 | 1033 |
2089457 | 2089457 | 2022-01-06 | Pierce | Washington | 53053 | 122313 | 1027 |
2086206 | 2086206 | 2022-01-05 | Pierce | Washington | 53053 | 119948 | 1017 |
2082954 | 2082954 | 2022-01-04 | Pierce | Washington | 53053 | 118123 | 1017 |
2079702 | 2079702 | 2022-01-03 | Pierce | Washington | 53053 | 117028 | 1011 |
2076450 | 2076450 | 2022-01-02 | Pierce | Washington | 53053 | 111273 | 1011 |
2073199 | 2073199 | 2022-01-01 | Pierce | Washington | 53053 | 111273 | 1011 |
2069948 | 2069948 | 2021-12-31 | Pierce | Washington | 53053 | 111273 | 1011 |
2066697 | 2066697 | 2021-12-30 | Pierce | Washington | 53053 | 111273 | 1011 |
2063447 | 2063447 | 2021-12-29 | Pierce | Washington | 53053 | 110255 | 1011 |
2060197 | 2060197 | 2021-12-28 | Pierce | Washington | 53053 | 109466 | 1009 |
2056948 | 2056948 | 2021-12-27 | Pierce | Washington | 53053 | 108938 | 1007 |
2053699 | 2053699 | 2021-12-26 | Pierce | Washington | 53053 | 105004 | 1006 |
2050449 | 2050449 | 2021-12-25 | Pierce | Washington | 53053 | 105004 | 1006 |
2047199 | 2047199 | 2021-12-24 | Pierce | Washington | 53053 | 105004 | 1006 |
2043949 | 2043949 | 2021-12-23 | Pierce | Washington | 53053 | 105004 | 1006 |
2040700 | 2040700 | 2021-12-22 | Pierce | Washington | 53053 | 104191 | 1003 |
2037450 | 2037450 | 2021-12-21 | Pierce | Washington | 53053 | 103837 | 1000 |
2034200 | 2034200 | 2021-12-20 | Pierce | Washington | 53053 | 103589 | 998 |
2030950 | 2030950 | 2021-12-19 | Pierce | Washington | 53053 | 102723 | 994 |
2027699 | 2027699 | 2021-12-18 | Pierce | Washington | 53053 | 102723 | 994 |
2024448 | 2024448 | 2021-12-17 | Pierce | Washington | 53053 | 102723 | 994 |
2021197 | 2021197 | 2021-12-16 | Pierce | Washington | 53053 | 102399 | 992 |
2017946 | 2017946 | 2021-12-15 | Pierce | Washington | 53053 | 102163 | 992 |
2014696 | 2014696 | 2021-12-14 | Pierce | Washington | 53053 | 101930 | 990 |
2011445 | 2011445 | 2021-12-13 | Pierce | Washington | 53053 | 101771 | 986 |
2008194 | 2008194 | 2021-12-12 | Pierce | Washington | 53053 | 101192 | 987 |
2004943 | 2004943 | 2021-12-11 | Pierce | Washington | 53053 | 101192 | 987 |
2001692 | 2001692 | 2021-12-10 | Pierce | Washington | 53053 | 101192 | 987 |
1998442 | 1998442 | 2021-12-09 | Pierce | Washington | 53053 | 101006 | 985 |
1995191 | 1995191 | 2021-12-08 | Pierce | Washington | 53053 | 100720 | 981 |
1991940 | 1991940 | 2021-12-07 | Pierce | Washington | 53053 | 100572 | 980 |
1988689 | 1988689 | 2021-12-06 | Pierce | Washington | 53053 | 100251 | 976 |
1985439 | 1985439 | 2021-12-05 | Pierce | Washington | 53053 | 99761 | 977 |
1982189 | 1982189 | 2021-12-04 | Pierce | Washington | 53053 | 99761 | 977 |
1978939 | 1978939 | 2021-12-03 | Pierce | Washington | 53053 | 99761 | 977 |
1975689 | 1975689 | 2021-12-02 | Pierce | Washington | 53053 | 99611 | 974 |
1972440 | 1972440 | 2021-12-01 | Pierce | Washington | 53053 | 98828 | 964 |
1969190 | 1969190 | 2021-11-30 | Pierce | Washington | 53053 | 98828 | 964 |
1965940 | 1965940 | 2021-11-29 | Pierce | Washington | 53053 | 98700 | 956 |
1962688 | 1962688 | 2021-11-28 | Pierce | Washington | 53053 | 98039 | 955 |
1959437 | 1959437 | 2021-11-27 | Pierce | Washington | 53053 | 98039 | 955 |
1956186 | 1956186 | 2021-11-26 | Pierce | Washington | 53053 | 98039 | 955 |
1952935 | 1952935 | 2021-11-25 | Pierce | Washington | 53053 | 98039 | 955 |
1949684 | 1949684 | 2021-11-24 | Pierce | Washington | 53053 | 98039 | 955 |
1946433 | 1946433 | 2021-11-23 | Pierce | Washington | 53053 | 97874 | 950 |
1943182 | 1943182 | 2021-11-22 | Pierce | Washington | 53053 | 97765 | 949 |
1939932 | 1939932 | 2021-11-21 | Pierce | Washington | 53053 | 97233 | 944 |
1936682 | 1936682 | 2021-11-20 | Pierce | Washington | 53053 | 97233 | 944 |
1933432 | 1933432 | 2021-11-19 | Pierce | Washington | 53053 | 97233 | 944 |
1930180 | 1930180 | 2021-11-18 | Pierce | Washington | 53053 | 97061 | 938 |
1926930 | 1926930 | 2021-11-17 | Pierce | Washington | 53053 | 96814 | 931 |
1923680 | 1923680 | 2021-11-16 | Pierce | Washington | 53053 | 96593 | 926 |
1920431 | 1920431 | 2021-11-15 | Pierce | Washington | 53053 | 96507 | 920 |
1917181 | 1917181 | 2021-11-14 | Pierce | Washington | 53053 | 95930 | 916 |
1913931 | 1913931 | 2021-11-13 | Pierce | Washington | 53053 | 95930 | 916 |
1910681 | 1910681 | 2021-11-12 | Pierce | Washington | 53053 | 95930 | 916 |
1907432 | 1907432 | 2021-11-11 | Pierce | Washington | 53053 | 95364 | 902 |
1904183 | 1904183 | 2021-11-10 | Pierce | Washington | 53053 | 95364 | 902 |
1900933 | 1900933 | 2021-11-09 | Pierce | Washington | 53053 | 95089 | 902 |
1897683 | 1897683 | 2021-11-08 | Pierce | Washington | 53053 | 94857 | 901 |
1894433 | 1894433 | 2021-11-07 | Pierce | Washington | 53053 | 94013 | 898 |
1891183 | 1891183 | 2021-11-06 | Pierce | Washington | 53053 | 94013 | 898 |
1887933 | 1887933 | 2021-11-05 | Pierce | Washington | 53053 | 94013 | 898 |
1884683 | 1884683 | 2021-11-04 | Pierce | Washington | 53053 | 93844 | 895 |
1881434 | 1881434 | 2021-11-03 | Pierce | Washington | 53053 | 93522 | 892 |
1878185 | 1878185 | 2021-11-02 | Pierce | Washington | 53053 | 93337 | 888 |
1874936 | 1874936 | 2021-11-01 | Pierce | Washington | 53053 | 93117 | 880 |
1871687 | 1871687 | 2021-10-31 | Pierce | Washington | 53053 | 92539 | 877 |
1868438 | 1868438 | 2021-10-30 | Pierce | Washington | 53053 | 92539 | 877 |
1865189 | 1865189 | 2021-10-29 | Pierce | Washington | 53053 | 92539 | 877 |
1861940 | 1861940 | 2021-10-28 | Pierce | Washington | 53053 | 92247 | 873 |
1858691 | 1858691 | 2021-10-27 | Pierce | Washington | 53053 | 91876 | 867 |
1855442 | 1855442 | 2021-10-26 | Pierce | Washington | 53053 | 91714 | 865 |
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);