ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where county = "Hempstead" and state = "Arkansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174334 | 2174334 | 2022-02-02 | Hempstead | Arkansas | 5057 | 4272 | 52 |
2171081 | 2171081 | 2022-02-01 | Hempstead | Arkansas | 5057 | 4253 | 52 |
2167828 | 2167828 | 2022-01-31 | Hempstead | Arkansas | 5057 | 4231 | 52 |
2164573 | 2164573 | 2022-01-30 | Hempstead | Arkansas | 5057 | 4198 | 52 |
2161318 | 2161318 | 2022-01-29 | Hempstead | Arkansas | 5057 | 4198 | 52 |
2158062 | 2158062 | 2022-01-28 | Hempstead | Arkansas | 5057 | 4198 | 52 |
2154809 | 2154809 | 2022-01-27 | Hempstead | Arkansas | 5057 | 4169 | 51 |
2151556 | 2151556 | 2022-01-26 | Hempstead | Arkansas | 5057 | 4148 | 51 |
2148304 | 2148304 | 2022-01-25 | Hempstead | Arkansas | 5057 | 4136 | 51 |
2145052 | 2145052 | 2022-01-24 | Hempstead | Arkansas | 5057 | 4100 | 51 |
2141797 | 2141797 | 2022-01-23 | Hempstead | Arkansas | 5057 | 4088 | 51 |
2138542 | 2138542 | 2022-01-22 | Hempstead | Arkansas | 5057 | 4072 | 51 |
2135286 | 2135286 | 2022-01-21 | Hempstead | Arkansas | 5057 | 4031 | 51 |
2132034 | 2132034 | 2022-01-20 | Hempstead | Arkansas | 5057 | 3975 | 51 |
2128781 | 2128781 | 2022-01-19 | Hempstead | Arkansas | 5057 | 3888 | 51 |
2125527 | 2125527 | 2022-01-18 | Hempstead | Arkansas | 5057 | 3820 | 51 |
2122275 | 2122275 | 2022-01-17 | Hempstead | Arkansas | 5057 | 3817 | 51 |
2119023 | 2119023 | 2022-01-16 | Hempstead | Arkansas | 5057 | 3796 | 51 |
2115771 | 2115771 | 2022-01-15 | Hempstead | Arkansas | 5057 | 3768 | 51 |
2112520 | 2112520 | 2022-01-14 | Hempstead | Arkansas | 5057 | 3720 | 51 |
2109268 | 2109268 | 2022-01-13 | Hempstead | Arkansas | 5057 | 3668 | 51 |
2106017 | 2106017 | 2022-01-12 | Hempstead | Arkansas | 5057 | 3602 | 51 |
2102766 | 2102766 | 2022-01-11 | Hempstead | Arkansas | 5057 | 3546 | 51 |
2099515 | 2099515 | 2022-01-10 | Hempstead | Arkansas | 5057 | 3510 | 51 |
2096264 | 2096264 | 2022-01-09 | Hempstead | Arkansas | 5057 | 3466 | 50 |
2093012 | 2093012 | 2022-01-08 | Hempstead | Arkansas | 5057 | 3466 | 50 |
2089760 | 2089760 | 2022-01-07 | Hempstead | Arkansas | 5057 | 3418 | 49 |
2086509 | 2086509 | 2022-01-06 | Hempstead | Arkansas | 5057 | 3362 | 49 |
2083257 | 2083257 | 2022-01-05 | Hempstead | Arkansas | 5057 | 3320 | 49 |
2080005 | 2080005 | 2022-01-04 | Hempstead | Arkansas | 5057 | 3277 | 49 |
2076753 | 2076753 | 2022-01-03 | Hempstead | Arkansas | 5057 | 3255 | 49 |
2073502 | 2073502 | 2022-01-02 | Hempstead | Arkansas | 5057 | 3250 | 49 |
2070251 | 2070251 | 2022-01-01 | Hempstead | Arkansas | 5057 | 3243 | 49 |
2067000 | 2067000 | 2021-12-31 | Hempstead | Arkansas | 5057 | 3233 | 49 |
2063749 | 2063749 | 2021-12-30 | Hempstead | Arkansas | 5057 | 3205 | 49 |
2060499 | 2060499 | 2021-12-29 | Hempstead | Arkansas | 5057 | 3186 | 49 |
2057250 | 2057250 | 2021-12-28 | Hempstead | Arkansas | 5057 | 3178 | 48 |
2054001 | 2054001 | 2021-12-27 | Hempstead | Arkansas | 5057 | 3166 | 47 |
2050751 | 2050751 | 2021-12-26 | Hempstead | Arkansas | 5057 | 3163 | 47 |
2047501 | 2047501 | 2021-12-25 | Hempstead | Arkansas | 5057 | 3159 | 46 |
2044251 | 2044251 | 2021-12-24 | Hempstead | Arkansas | 5057 | 3156 | 46 |
2041002 | 2041002 | 2021-12-23 | Hempstead | Arkansas | 5057 | 3146 | 46 |
2037752 | 2037752 | 2021-12-22 | Hempstead | Arkansas | 5057 | 3140 | 46 |
2034502 | 2034502 | 2021-12-21 | Hempstead | Arkansas | 5057 | 3132 | 46 |
2031252 | 2031252 | 2021-12-20 | Hempstead | Arkansas | 5057 | 3126 | 46 |
2028001 | 2028001 | 2021-12-19 | Hempstead | Arkansas | 5057 | 3124 | 44 |
2024750 | 2024750 | 2021-12-18 | Hempstead | Arkansas | 5057 | 3123 | 44 |
2021499 | 2021499 | 2021-12-17 | Hempstead | Arkansas | 5057 | 3118 | 44 |
2018248 | 2018248 | 2021-12-16 | Hempstead | Arkansas | 5057 | 3113 | 44 |
2014998 | 2014998 | 2021-12-15 | Hempstead | Arkansas | 5057 | 3108 | 44 |
2011747 | 2011747 | 2021-12-14 | Hempstead | Arkansas | 5057 | 3099 | 44 |
2008496 | 2008496 | 2021-12-13 | Hempstead | Arkansas | 5057 | 3095 | 44 |
2005245 | 2005245 | 2021-12-12 | Hempstead | Arkansas | 5057 | 3093 | 44 |
2001994 | 2001994 | 2021-12-11 | Hempstead | Arkansas | 5057 | 3092 | 44 |
1998744 | 1998744 | 2021-12-10 | Hempstead | Arkansas | 5057 | 3075 | 44 |
1995493 | 1995493 | 2021-12-09 | Hempstead | Arkansas | 5057 | 3069 | 44 |
1992242 | 1992242 | 2021-12-08 | Hempstead | Arkansas | 5057 | 3066 | 44 |
1988991 | 1988991 | 2021-12-07 | Hempstead | Arkansas | 5057 | 3063 | 44 |
1985741 | 1985741 | 2021-12-06 | Hempstead | Arkansas | 5057 | 3059 | 44 |
1982491 | 1982491 | 2021-12-05 | Hempstead | Arkansas | 5057 | 3058 | 43 |
1979241 | 1979241 | 2021-12-04 | Hempstead | Arkansas | 5057 | 3043 | 41 |
1975991 | 1975991 | 2021-12-03 | Hempstead | Arkansas | 5057 | 3040 | 41 |
1972742 | 1972742 | 2021-12-02 | Hempstead | Arkansas | 5057 | 3034 | 41 |
1969492 | 1969492 | 2021-12-01 | Hempstead | Arkansas | 5057 | 3025 | 41 |
1966242 | 1966242 | 2021-11-30 | Hempstead | Arkansas | 5057 | 3020 | 41 |
1962990 | 1962990 | 2021-11-29 | Hempstead | Arkansas | 5057 | 3007 | 41 |
1959739 | 1959739 | 2021-11-28 | Hempstead | Arkansas | 5057 | 3008 | 41 |
1956488 | 1956488 | 2021-11-27 | Hempstead | Arkansas | 5057 | 3006 | 41 |
1953237 | 1953237 | 2021-11-26 | Hempstead | Arkansas | 5057 | 3006 | 41 |
1949986 | 1949986 | 2021-11-25 | Hempstead | Arkansas | 5057 | 3005 | 41 |
1946735 | 1946735 | 2021-11-24 | Hempstead | Arkansas | 5057 | 3003 | 41 |
1943484 | 1943484 | 2021-11-23 | Hempstead | Arkansas | 5057 | 3003 | 41 |
1940234 | 1940234 | 2021-11-22 | Hempstead | Arkansas | 5057 | 2998 | 41 |
1936984 | 1936984 | 2021-11-21 | Hempstead | Arkansas | 5057 | 2997 | 41 |
1933734 | 1933734 | 2021-11-20 | Hempstead | Arkansas | 5057 | 2997 | 41 |
1930482 | 1930482 | 2021-11-19 | Hempstead | Arkansas | 5057 | 2990 | 41 |
1927232 | 1927232 | 2021-11-18 | Hempstead | Arkansas | 5057 | 2988 | 41 |
1923982 | 1923982 | 2021-11-17 | Hempstead | Arkansas | 5057 | 2989 | 41 |
1920733 | 1920733 | 2021-11-16 | Hempstead | Arkansas | 5057 | 2985 | 41 |
1917483 | 1917483 | 2021-11-15 | Hempstead | Arkansas | 5057 | 2981 | 41 |
1914233 | 1914233 | 2021-11-14 | Hempstead | Arkansas | 5057 | 2981 | 41 |
1910983 | 1910983 | 2021-11-13 | Hempstead | Arkansas | 5057 | 2981 | 41 |
1907734 | 1907734 | 2021-11-12 | Hempstead | Arkansas | 5057 | 2978 | 41 |
1904485 | 1904485 | 2021-11-11 | Hempstead | Arkansas | 5057 | 2976 | 41 |
1901235 | 1901235 | 2021-11-10 | Hempstead | Arkansas | 5057 | 2973 | 41 |
1897985 | 1897985 | 2021-11-09 | Hempstead | Arkansas | 5057 | 2971 | 41 |
1894735 | 1894735 | 2021-11-08 | Hempstead | Arkansas | 5057 | 2968 | 41 |
1891485 | 1891485 | 2021-11-07 | Hempstead | Arkansas | 5057 | 2968 | 41 |
1888235 | 1888235 | 2021-11-06 | Hempstead | Arkansas | 5057 | 2968 | 40 |
1884985 | 1884985 | 2021-11-05 | Hempstead | Arkansas | 5057 | 2967 | 40 |
1881736 | 1881736 | 2021-11-04 | Hempstead | Arkansas | 5057 | 2967 | 39 |
1878487 | 1878487 | 2021-11-03 | Hempstead | Arkansas | 5057 | 2965 | 39 |
1875238 | 1875238 | 2021-11-02 | Hempstead | Arkansas | 5057 | 2962 | 39 |
1871989 | 1871989 | 2021-11-01 | Hempstead | Arkansas | 5057 | 2956 | 39 |
1868740 | 1868740 | 2021-10-31 | Hempstead | Arkansas | 5057 | 2955 | 39 |
1865491 | 1865491 | 2021-10-30 | Hempstead | Arkansas | 5057 | 2952 | 39 |
1862242 | 1862242 | 2021-10-29 | Hempstead | Arkansas | 5057 | 2948 | 38 |
1858993 | 1858993 | 2021-10-28 | Hempstead | Arkansas | 5057 | 2945 | 38 |
1855744 | 1855744 | 2021-10-27 | Hempstead | Arkansas | 5057 | 2941 | 38 |
1852495 | 1852495 | 2021-10-26 | Hempstead | Arkansas | 5057 | 2940 | 38 |
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);