ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 4009 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174294 | 2174294 | 2022-02-02 | Graham | Arizona | 4009 | 11235 | 164 |
2171042 | 2171042 | 2022-02-01 | Graham | Arizona | 4009 | 11153 | 164 |
2167789 | 2167789 | 2022-01-31 | Graham | Arizona | 4009 | 11112 | 164 |
2164534 | 2164534 | 2022-01-30 | Graham | Arizona | 4009 | 11061 | 164 |
2161279 | 2161279 | 2022-01-29 | Graham | Arizona | 4009 | 11007 | 164 |
2158023 | 2158023 | 2022-01-28 | Graham | Arizona | 4009 | 10945 | 163 |
2154770 | 2154770 | 2022-01-27 | Graham | Arizona | 4009 | 10830 | 163 |
2151517 | 2151517 | 2022-01-26 | Graham | Arizona | 4009 | 10732 | 163 |
2148265 | 2148265 | 2022-01-25 | Graham | Arizona | 4009 | 10539 | 162 |
2145013 | 2145013 | 2022-01-24 | Graham | Arizona | 4009 | 10511 | 162 |
2141758 | 2141758 | 2022-01-23 | Graham | Arizona | 4009 | 10485 | 162 |
2138502 | 2138502 | 2022-01-22 | Graham | Arizona | 4009 | 10373 | 161 |
2135247 | 2135247 | 2022-01-21 | Graham | Arizona | 4009 | 10157 | 161 |
2131995 | 2131995 | 2022-01-20 | Graham | Arizona | 4009 | 10026 | 161 |
2128741 | 2128741 | 2022-01-19 | Graham | Arizona | 4009 | 9873 | 161 |
2125488 | 2125488 | 2022-01-18 | Graham | Arizona | 4009 | 9815 | 161 |
2122236 | 2122236 | 2022-01-17 | Graham | Arizona | 4009 | 9741 | 160 |
2118984 | 2118984 | 2022-01-16 | Graham | Arizona | 4009 | 9693 | 160 |
2115732 | 2115732 | 2022-01-15 | Graham | Arizona | 4009 | 9615 | 160 |
2112480 | 2112480 | 2022-01-14 | Graham | Arizona | 4009 | 9532 | 159 |
2109228 | 2109228 | 2022-01-13 | Graham | Arizona | 4009 | 9449 | 159 |
2105977 | 2105977 | 2022-01-12 | Graham | Arizona | 4009 | 9396 | 159 |
2102726 | 2102726 | 2022-01-11 | Graham | Arizona | 4009 | 9304 | 159 |
2099475 | 2099475 | 2022-01-10 | Graham | Arizona | 4009 | 9276 | 159 |
2096224 | 2096224 | 2022-01-09 | Graham | Arizona | 4009 | 9264 | 159 |
2092972 | 2092972 | 2022-01-08 | Graham | Arizona | 4009 | 9211 | 159 |
2089720 | 2089720 | 2022-01-07 | Graham | Arizona | 4009 | 9132 | 159 |
2086469 | 2086469 | 2022-01-06 | Graham | Arizona | 4009 | 9060 | 159 |
2083217 | 2083217 | 2022-01-05 | Graham | Arizona | 4009 | 9031 | 159 |
2079965 | 2079965 | 2022-01-04 | Graham | Arizona | 4009 | 8998 | 159 |
2076713 | 2076713 | 2022-01-03 | Graham | Arizona | 4009 | 8989 | 159 |
2073462 | 2073462 | 2022-01-02 | Graham | Arizona | 4009 | 8980 | 159 |
2070211 | 2070211 | 2022-01-01 | Graham | Arizona | 4009 | 8980 | 158 |
2066960 | 2066960 | 2021-12-31 | Graham | Arizona | 4009 | 8971 | 157 |
2063710 | 2063710 | 2021-12-30 | Graham | Arizona | 4009 | 8955 | 157 |
2060460 | 2060460 | 2021-12-29 | Graham | Arizona | 4009 | 8943 | 157 |
2057211 | 2057211 | 2021-12-28 | Graham | Arizona | 4009 | 8939 | 156 |
2053962 | 2053962 | 2021-12-27 | Graham | Arizona | 4009 | 8936 | 156 |
2050712 | 2050712 | 2021-12-26 | Graham | Arizona | 4009 | 8930 | 156 |
2047462 | 2047462 | 2021-12-25 | Graham | Arizona | 4009 | 8929 | 156 |
2044212 | 2044212 | 2021-12-24 | Graham | Arizona | 4009 | 8923 | 156 |
2040963 | 2040963 | 2021-12-23 | Graham | Arizona | 4009 | 8912 | 153 |
2037713 | 2037713 | 2021-12-22 | Graham | Arizona | 4009 | 8894 | 153 |
2034463 | 2034463 | 2021-12-21 | Graham | Arizona | 4009 | 8871 | 150 |
2031213 | 2031213 | 2021-12-20 | Graham | Arizona | 4009 | 8867 | 149 |
2027962 | 2027962 | 2021-12-19 | Graham | Arizona | 4009 | 8868 | 149 |
2024711 | 2024711 | 2021-12-18 | Graham | Arizona | 4009 | 8856 | 147 |
2021460 | 2021460 | 2021-12-17 | Graham | Arizona | 4009 | 8854 | 146 |
2018209 | 2018209 | 2021-12-16 | Graham | Arizona | 4009 | 8831 | 145 |
2014959 | 2014959 | 2021-12-15 | Graham | Arizona | 4009 | 8818 | 144 |
2011708 | 2011708 | 2021-12-14 | Graham | Arizona | 4009 | 8799 | 143 |
2008457 | 2008457 | 2021-12-13 | Graham | Arizona | 4009 | 8793 | 143 |
2005206 | 2005206 | 2021-12-12 | Graham | Arizona | 4009 | 8785 | 143 |
2001955 | 2001955 | 2021-12-11 | Graham | Arizona | 4009 | 8769 | 142 |
1998705 | 1998705 | 2021-12-10 | Graham | Arizona | 4009 | 8749 | 141 |
1995454 | 1995454 | 2021-12-09 | Graham | Arizona | 4009 | 8724 | 141 |
1992203 | 1992203 | 2021-12-08 | Graham | Arizona | 4009 | 8699 | 139 |
1988952 | 1988952 | 2021-12-07 | Graham | Arizona | 4009 | 8680 | 139 |
1985702 | 1985702 | 2021-12-06 | Graham | Arizona | 4009 | 8667 | 137 |
1982452 | 1982452 | 2021-12-05 | Graham | Arizona | 4009 | 8662 | 137 |
1979202 | 1979202 | 2021-12-04 | Graham | Arizona | 4009 | 8645 | 136 |
1975952 | 1975952 | 2021-12-03 | Graham | Arizona | 4009 | 8603 | 135 |
1972703 | 1972703 | 2021-12-02 | Graham | Arizona | 4009 | 8582 | 135 |
1969453 | 1969453 | 2021-12-01 | Graham | Arizona | 4009 | 8555 | 133 |
1966203 | 1966203 | 2021-11-30 | Graham | Arizona | 4009 | 8501 | 132 |
1962951 | 1962951 | 2021-11-29 | Graham | Arizona | 4009 | 8489 | 132 |
1959700 | 1959700 | 2021-11-28 | Graham | Arizona | 4009 | 8478 | 131 |
1956449 | 1956449 | 2021-11-27 | Graham | Arizona | 4009 | 8451 | 130 |
1953198 | 1953198 | 2021-11-26 | Graham | Arizona | 4009 | 8435 | 130 |
1949947 | 1949947 | 2021-11-25 | Graham | Arizona | 4009 | 8423 | 130 |
1946696 | 1946696 | 2021-11-24 | Graham | Arizona | 4009 | 8382 | 129 |
1943445 | 1943445 | 2021-11-23 | Graham | Arizona | 4009 | 8344 | 126 |
1940195 | 1940195 | 2021-11-22 | Graham | Arizona | 4009 | 8334 | 126 |
1936945 | 1936945 | 2021-11-21 | Graham | Arizona | 4009 | 8305 | 124 |
1933695 | 1933695 | 2021-11-20 | Graham | Arizona | 4009 | 8277 | 124 |
1930443 | 1930443 | 2021-11-19 | Graham | Arizona | 4009 | 8232 | 123 |
1927193 | 1927193 | 2021-11-18 | Graham | Arizona | 4009 | 8193 | 122 |
1923943 | 1923943 | 2021-11-17 | Graham | Arizona | 4009 | 8137 | 122 |
1920694 | 1920694 | 2021-11-16 | Graham | Arizona | 4009 | 8096 | 121 |
1917444 | 1917444 | 2021-11-15 | Graham | Arizona | 4009 | 8093 | 121 |
1914194 | 1914194 | 2021-11-14 | Graham | Arizona | 4009 | 8057 | 121 |
1910944 | 1910944 | 2021-11-13 | Graham | Arizona | 4009 | 8047 | 121 |
1907695 | 1907695 | 2021-11-12 | Graham | Arizona | 4009 | 8008 | 121 |
1904446 | 1904446 | 2021-11-11 | Graham | Arizona | 4009 | 7981 | 121 |
1901196 | 1901196 | 2021-11-10 | Graham | Arizona | 4009 | 7937 | 121 |
1897946 | 1897946 | 2021-11-09 | Graham | Arizona | 4009 | 7885 | 120 |
1894696 | 1894696 | 2021-11-08 | Graham | Arizona | 4009 | 7879 | 119 |
1891446 | 1891446 | 2021-11-07 | Graham | Arizona | 4009 | 7862 | 119 |
1888196 | 1888196 | 2021-11-06 | Graham | Arizona | 4009 | 7825 | 119 |
1884946 | 1884946 | 2021-11-05 | Graham | Arizona | 4009 | 7816 | 119 |
1881697 | 1881697 | 2021-11-04 | Graham | Arizona | 4009 | 7787 | 119 |
1878448 | 1878448 | 2021-11-03 | Graham | Arizona | 4009 | 7740 | 119 |
1875199 | 1875199 | 2021-11-02 | Graham | Arizona | 4009 | 7714 | 119 |
1871950 | 1871950 | 2021-11-01 | Graham | Arizona | 4009 | 7712 | 119 |
1868701 | 1868701 | 2021-10-31 | Graham | Arizona | 4009 | 7698 | 119 |
1865452 | 1865452 | 2021-10-30 | Graham | Arizona | 4009 | 7680 | 119 |
1862203 | 1862203 | 2021-10-29 | Graham | Arizona | 4009 | 7630 | 119 |
1858954 | 1858954 | 2021-10-28 | Graham | Arizona | 4009 | 7619 | 118 |
1855705 | 1855705 | 2021-10-27 | Graham | Arizona | 4009 | 7560 | 117 |
1852456 | 1852456 | 2021-10-26 | Graham | Arizona | 4009 | 7521 | 117 |
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);