ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 8039 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174461 | 2174461 | 2022-02-02 | Elbert | Colorado | 8039 | 4476 | 33 |
2171208 | 2171208 | 2022-02-01 | Elbert | Colorado | 8039 | 4460 | 33 |
2167955 | 2167955 | 2022-01-31 | Elbert | Colorado | 8039 | 4453 | 33 |
2164700 | 2164700 | 2022-01-30 | Elbert | Colorado | 8039 | 4413 | 33 |
2161445 | 2161445 | 2022-01-29 | Elbert | Colorado | 8039 | 4397 | 33 |
2158189 | 2158189 | 2022-01-28 | Elbert | Colorado | 8039 | 4413 | 33 |
2154936 | 2154936 | 2022-01-27 | Elbert | Colorado | 8039 | 4397 | 33 |
2151683 | 2151683 | 2022-01-26 | Elbert | Colorado | 8039 | 4353 | 33 |
2148431 | 2148431 | 2022-01-25 | Elbert | Colorado | 8039 | 4314 | 33 |
2145179 | 2145179 | 2022-01-24 | Elbert | Colorado | 8039 | 4290 | 32 |
2141924 | 2141924 | 2022-01-23 | Elbert | Colorado | 8039 | 4199 | 32 |
2138669 | 2138669 | 2022-01-22 | Elbert | Colorado | 8039 | 4199 | 32 |
2135413 | 2135413 | 2022-01-21 | Elbert | Colorado | 8039 | 4199 | 32 |
2132161 | 2132161 | 2022-01-20 | Elbert | Colorado | 8039 | 4153 | 32 |
2128908 | 2128908 | 2022-01-19 | Elbert | Colorado | 8039 | 4110 | 32 |
2125654 | 2125654 | 2022-01-18 | Elbert | Colorado | 8039 | 4065 | 31 |
2122402 | 2122402 | 2022-01-17 | Elbert | Colorado | 8039 | 4027 | 31 |
2119150 | 2119150 | 2022-01-16 | Elbert | Colorado | 8039 | 3916 | 31 |
2115898 | 2115898 | 2022-01-15 | Elbert | Colorado | 8039 | 3916 | 31 |
2112647 | 2112647 | 2022-01-14 | Elbert | Colorado | 8039 | 3916 | 31 |
2109395 | 2109395 | 2022-01-13 | Elbert | Colorado | 8039 | 3861 | 31 |
2106144 | 2106144 | 2022-01-12 | Elbert | Colorado | 8039 | 3815 | 31 |
2102893 | 2102893 | 2022-01-11 | Elbert | Colorado | 8039 | 3780 | 31 |
2099642 | 2099642 | 2022-01-10 | Elbert | Colorado | 8039 | 3692 | 31 |
2096391 | 2096391 | 2022-01-09 | Elbert | Colorado | 8039 | 3557 | 31 |
2093139 | 2093139 | 2022-01-08 | Elbert | Colorado | 8039 | 3557 | 31 |
2089887 | 2089887 | 2022-01-07 | Elbert | Colorado | 8039 | 3557 | 31 |
2086636 | 2086636 | 2022-01-06 | Elbert | Colorado | 8039 | 3519 | 31 |
2083384 | 2083384 | 2022-01-05 | Elbert | Colorado | 8039 | 3477 | 31 |
2080132 | 2080132 | 2022-01-04 | Elbert | Colorado | 8039 | 3439 | 31 |
2076880 | 2076880 | 2022-01-03 | Elbert | Colorado | 8039 | 3419 | 31 |
2073629 | 2073629 | 2022-01-02 | Elbert | Colorado | 8039 | 3330 | 31 |
2070378 | 2070378 | 2022-01-01 | Elbert | Colorado | 8039 | 3330 | 31 |
2067127 | 2067127 | 2021-12-31 | Elbert | Colorado | 8039 | 3330 | 31 |
2063876 | 2063876 | 2021-12-30 | Elbert | Colorado | 8039 | 3303 | 31 |
2060626 | 2060626 | 2021-12-29 | Elbert | Colorado | 8039 | 3276 | 30 |
2057377 | 2057377 | 2021-12-28 | Elbert | Colorado | 8039 | 3254 | 30 |
2054128 | 2054128 | 2021-12-27 | Elbert | Colorado | 8039 | 3227 | 30 |
2050878 | 2050878 | 2021-12-26 | Elbert | Colorado | 8039 | 3205 | 30 |
2047628 | 2047628 | 2021-12-25 | Elbert | Colorado | 8039 | 3205 | 30 |
2044378 | 2044378 | 2021-12-24 | Elbert | Colorado | 8039 | 3205 | 30 |
2041129 | 2041129 | 2021-12-23 | Elbert | Colorado | 8039 | 3190 | 30 |
2037879 | 2037879 | 2021-12-22 | Elbert | Colorado | 8039 | 3180 | 30 |
2034629 | 2034629 | 2021-12-21 | Elbert | Colorado | 8039 | 3168 | 30 |
2031379 | 2031379 | 2021-12-20 | Elbert | Colorado | 8039 | 3157 | 30 |
2028128 | 2028128 | 2021-12-19 | Elbert | Colorado | 8039 | 3142 | 30 |
2024877 | 2024877 | 2021-12-18 | Elbert | Colorado | 8039 | 3142 | 30 |
2021626 | 2021626 | 2021-12-17 | Elbert | Colorado | 8039 | 3142 | 30 |
2018375 | 2018375 | 2021-12-16 | Elbert | Colorado | 8039 | 3133 | 30 |
2015125 | 2015125 | 2021-12-15 | Elbert | Colorado | 8039 | 3125 | 29 |
2011874 | 2011874 | 2021-12-14 | Elbert | Colorado | 8039 | 3117 | 29 |
2008623 | 2008623 | 2021-12-13 | Elbert | Colorado | 8039 | 3113 | 29 |
2005372 | 2005372 | 2021-12-12 | Elbert | Colorado | 8039 | 3099 | 29 |
2002121 | 2002121 | 2021-12-11 | Elbert | Colorado | 8039 | 3099 | 29 |
1998871 | 1998871 | 2021-12-10 | Elbert | Colorado | 8039 | 3099 | 29 |
1995620 | 1995620 | 2021-12-09 | Elbert | Colorado | 8039 | 3094 | 29 |
1992369 | 1992369 | 2021-12-08 | Elbert | Colorado | 8039 | 3084 | 28 |
1989118 | 1989118 | 2021-12-07 | Elbert | Colorado | 8039 | 3074 | 27 |
1985868 | 1985868 | 2021-12-06 | Elbert | Colorado | 8039 | 3063 | 26 |
1982618 | 1982618 | 2021-12-05 | Elbert | Colorado | 8039 | 3049 | 26 |
1979368 | 1979368 | 2021-12-04 | Elbert | Colorado | 8039 | 3049 | 26 |
1976118 | 1976118 | 2021-12-03 | Elbert | Colorado | 8039 | 3049 | 26 |
1972869 | 1972869 | 2021-12-02 | Elbert | Colorado | 8039 | 3036 | 26 |
1969619 | 1969619 | 2021-12-01 | Elbert | Colorado | 8039 | 3023 | 26 |
1966369 | 1966369 | 2021-11-30 | Elbert | Colorado | 8039 | 3014 | 26 |
1963117 | 1963117 | 2021-11-29 | Elbert | Colorado | 8039 | 3001 | 26 |
1959866 | 1959866 | 2021-11-28 | Elbert | Colorado | 8039 | 2984 | 26 |
1956615 | 1956615 | 2021-11-27 | Elbert | Colorado | 8039 | 2981 | 26 |
1953364 | 1953364 | 2021-11-26 | Elbert | Colorado | 8039 | 2981 | 26 |
1950113 | 1950113 | 2021-11-25 | Elbert | Colorado | 8039 | 2981 | 26 |
1946862 | 1946862 | 2021-11-24 | Elbert | Colorado | 8039 | 2969 | 26 |
1943611 | 1943611 | 2021-11-23 | Elbert | Colorado | 8039 | 2957 | 26 |
1940361 | 1940361 | 2021-11-22 | Elbert | Colorado | 8039 | 2946 | 26 |
1937111 | 1937111 | 2021-11-21 | Elbert | Colorado | 8039 | 2925 | 26 |
1933861 | 1933861 | 2021-11-20 | Elbert | Colorado | 8039 | 2925 | 26 |
1930609 | 1930609 | 2021-11-19 | Elbert | Colorado | 8039 | 2925 | 26 |
1927359 | 1927359 | 2021-11-18 | Elbert | Colorado | 8039 | 2917 | 26 |
1924109 | 1924109 | 2021-11-17 | Elbert | Colorado | 8039 | 2912 | 26 |
1920860 | 1920860 | 2021-11-16 | Elbert | Colorado | 8039 | 2894 | 25 |
1917610 | 1917610 | 2021-11-15 | Elbert | Colorado | 8039 | 2889 | 25 |
1914360 | 1914360 | 2021-11-14 | Elbert | Colorado | 8039 | 2870 | 23 |
1911110 | 1911110 | 2021-11-13 | Elbert | Colorado | 8039 | 2870 | 23 |
1907861 | 1907861 | 2021-11-12 | Elbert | Colorado | 8039 | 2870 | 23 |
1904612 | 1904612 | 2021-11-11 | Elbert | Colorado | 8039 | 2864 | 23 |
1901362 | 1901362 | 2021-11-10 | Elbert | Colorado | 8039 | 2851 | 23 |
1898112 | 1898112 | 2021-11-09 | Elbert | Colorado | 8039 | 2841 | 23 |
1894862 | 1894862 | 2021-11-08 | Elbert | Colorado | 8039 | 2832 | 23 |
1891612 | 1891612 | 2021-11-07 | Elbert | Colorado | 8039 | 2814 | 23 |
1888362 | 1888362 | 2021-11-06 | Elbert | Colorado | 8039 | 2814 | 23 |
1885112 | 1885112 | 2021-11-05 | Elbert | Colorado | 8039 | 2814 | 23 |
1881863 | 1881863 | 2021-11-04 | Elbert | Colorado | 8039 | 2810 | 23 |
1878614 | 1878614 | 2021-11-03 | Elbert | Colorado | 8039 | 2797 | 23 |
1875365 | 1875365 | 2021-11-02 | Elbert | Colorado | 8039 | 2787 | 23 |
1872116 | 1872116 | 2021-11-01 | Elbert | Colorado | 8039 | 2778 | 23 |
1868867 | 1868867 | 2021-10-31 | Elbert | Colorado | 8039 | 2759 | 23 |
1865618 | 1865618 | 2021-10-30 | Elbert | Colorado | 8039 | 2759 | 23 |
1862369 | 1862369 | 2021-10-29 | Elbert | Colorado | 8039 | 2759 | 23 |
1859120 | 1859120 | 2021-10-28 | Elbert | Colorado | 8039 | 2740 | 23 |
1855871 | 1855871 | 2021-10-27 | Elbert | Colorado | 8039 | 2729 | 24 |
1852622 | 1852622 | 2021-10-26 | Elbert | Colorado | 8039 | 2720 | 24 |
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);