ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
796 rows where fips = 8005 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174442 | 2174442 | 2022-02-02 | Arapahoe | Colorado | 8005 | 144567 | 1181 |
2171189 | 2171189 | 2022-02-01 | Arapahoe | Colorado | 8005 | 144255 | 1172 |
2167936 | 2167936 | 2022-01-31 | Arapahoe | Colorado | 8005 | 143854 | 1172 |
2164681 | 2164681 | 2022-01-30 | Arapahoe | Colorado | 8005 | 142057 | 1155 |
2161426 | 2161426 | 2022-01-29 | Arapahoe | Colorado | 8005 | 142057 | 1155 |
2158170 | 2158170 | 2022-01-28 | Arapahoe | Colorado | 8005 | 142057 | 1155 |
2154917 | 2154917 | 2022-01-27 | Arapahoe | Colorado | 8005 | 140511 | 1153 |
2151664 | 2151664 | 2022-01-26 | Arapahoe | Colorado | 8005 | 140511 | 1153 |
2148412 | 2148412 | 2022-01-25 | Arapahoe | Colorado | 8005 | 139765 | 1145 |
2145160 | 2145160 | 2022-01-24 | Arapahoe | Colorado | 8005 | 139127 | 1142 |
2141905 | 2141905 | 2022-01-23 | Arapahoe | Colorado | 8005 | 134793 | 1122 |
2138650 | 2138650 | 2022-01-22 | Arapahoe | Colorado | 8005 | 134793 | 1122 |
2135394 | 2135394 | 2022-01-21 | Arapahoe | Colorado | 8005 | 134793 | 1122 |
2132142 | 2132142 | 2022-01-20 | Arapahoe | Colorado | 8005 | 133508 | 1122 |
2128889 | 2128889 | 2022-01-19 | Arapahoe | Colorado | 8005 | 131868 | 1120 |
2125635 | 2125635 | 2022-01-18 | Arapahoe | Colorado | 8005 | 131272 | 1120 |
2122383 | 2122383 | 2022-01-17 | Arapahoe | Colorado | 8005 | 130518 | 1118 |
2119131 | 2119131 | 2022-01-16 | Arapahoe | Colorado | 8005 | 128732 | 1116 |
2115879 | 2115879 | 2022-01-15 | Arapahoe | Colorado | 8005 | 126947 | 1111 |
2112628 | 2112628 | 2022-01-14 | Arapahoe | Colorado | 8005 | 126947 | 1111 |
2109376 | 2109376 | 2022-01-13 | Arapahoe | Colorado | 8005 | 125573 | 1107 |
2106125 | 2106125 | 2022-01-12 | Arapahoe | Colorado | 8005 | 123482 | 1102 |
2102874 | 2102874 | 2022-01-11 | Arapahoe | Colorado | 8005 | 121248 | 1094 |
2099623 | 2099623 | 2022-01-10 | Arapahoe | Colorado | 8005 | 117543 | 1090 |
2096372 | 2096372 | 2022-01-09 | Arapahoe | Colorado | 8005 | 114566 | 1090 |
2093120 | 2093120 | 2022-01-08 | Arapahoe | Colorado | 8005 | 113440 | 1090 |
2089868 | 2089868 | 2022-01-07 | Arapahoe | Colorado | 8005 | 112299 | 1089 |
2086617 | 2086617 | 2022-01-06 | Arapahoe | Colorado | 8005 | 111022 | 1086 |
2083365 | 2083365 | 2022-01-05 | Arapahoe | Colorado | 8005 | 109758 | 1083 |
2080113 | 2080113 | 2022-01-04 | Arapahoe | Colorado | 8005 | 108785 | 1081 |
2076861 | 2076861 | 2022-01-03 | Arapahoe | Colorado | 8005 | 107561 | 1079 |
2073610 | 2073610 | 2022-01-02 | Arapahoe | Colorado | 8005 | 105113 | 1078 |
2070359 | 2070359 | 2022-01-01 | Arapahoe | Colorado | 8005 | 103551 | 1075 |
2067108 | 2067108 | 2021-12-31 | Arapahoe | Colorado | 8005 | 103551 | 1075 |
2063857 | 2063857 | 2021-12-30 | Arapahoe | Colorado | 8005 | 102105 | 1067 |
2060607 | 2060607 | 2021-12-29 | Arapahoe | Colorado | 8005 | 100933 | 1067 |
2057358 | 2057358 | 2021-12-28 | Arapahoe | Colorado | 8005 | 99363 | 1060 |
2054109 | 2054109 | 2021-12-27 | Arapahoe | Colorado | 8005 | 99363 | 1060 |
2050859 | 2050859 | 2021-12-26 | Arapahoe | Colorado | 8005 | 98378 | 1060 |
2047609 | 2047609 | 2021-12-25 | Arapahoe | Colorado | 8005 | 97697 | 1058 |
2044359 | 2044359 | 2021-12-24 | Arapahoe | Colorado | 8005 | 97089 | 1058 |
2041110 | 2041110 | 2021-12-23 | Arapahoe | Colorado | 8005 | 96497 | 1058 |
2037860 | 2037860 | 2021-12-22 | Arapahoe | Colorado | 8005 | 96497 | 1058 |
2034610 | 2034610 | 2021-12-21 | Arapahoe | Colorado | 8005 | 96084 | 1048 |
2031360 | 2031360 | 2021-12-20 | Arapahoe | Colorado | 8005 | 95769 | 1046 |
2028109 | 2028109 | 2021-12-19 | Arapahoe | Colorado | 8005 | 95419 | 1046 |
2024858 | 2024858 | 2021-12-18 | Arapahoe | Colorado | 8005 | 95132 | 1043 |
2021607 | 2021607 | 2021-12-17 | Arapahoe | Colorado | 8005 | 94895 | 1038 |
2018356 | 2018356 | 2021-12-16 | Arapahoe | Colorado | 8005 | 94895 | 1038 |
2015106 | 2015106 | 2021-12-15 | Arapahoe | Colorado | 8005 | 94654 | 1038 |
2011855 | 2011855 | 2021-12-14 | Arapahoe | Colorado | 8005 | 94483 | 1033 |
2008604 | 2008604 | 2021-12-13 | Arapahoe | Colorado | 8005 | 94331 | 1032 |
2005353 | 2005353 | 2021-12-12 | Arapahoe | Colorado | 8005 | 93942 | 1031 |
2002102 | 2002102 | 2021-12-11 | Arapahoe | Colorado | 8005 | 93807 | 1024 |
1998852 | 1998852 | 2021-12-10 | Arapahoe | Colorado | 8005 | 93807 | 1024 |
1995601 | 1995601 | 2021-12-09 | Arapahoe | Colorado | 8005 | 93492 | 1020 |
1992350 | 1992350 | 2021-12-08 | Arapahoe | Colorado | 8005 | 93186 | 1019 |
1989099 | 1989099 | 2021-12-07 | Arapahoe | Colorado | 8005 | 93000 | 1009 |
1985849 | 1985849 | 2021-12-06 | Arapahoe | Colorado | 8005 | 92483 | 1007 |
1982599 | 1982599 | 2021-12-05 | Arapahoe | Colorado | 8005 | 92262 | 1007 |
1979349 | 1979349 | 2021-12-04 | Arapahoe | Colorado | 8005 | 91926 | 1006 |
1976099 | 1976099 | 2021-12-03 | Arapahoe | Colorado | 8005 | 91926 | 1006 |
1972850 | 1972850 | 2021-12-02 | Arapahoe | Colorado | 8005 | 91706 | 1003 |
1969600 | 1969600 | 2021-12-01 | Arapahoe | Colorado | 8005 | 90970 | 997 |
1966350 | 1966350 | 2021-11-30 | Arapahoe | Colorado | 8005 | 90970 | 997 |
1963098 | 1963098 | 2021-11-29 | Arapahoe | Colorado | 8005 | 90685 | 996 |
1959847 | 1959847 | 2021-11-28 | Arapahoe | Colorado | 8005 | 90295 | 991 |
1956596 | 1956596 | 2021-11-27 | Arapahoe | Colorado | 8005 | 90295 | 991 |
1953345 | 1953345 | 2021-11-26 | Arapahoe | Colorado | 8005 | 90107 | 989 |
1950094 | 1950094 | 2021-11-25 | Arapahoe | Colorado | 8005 | 89610 | 986 |
1946843 | 1946843 | 2021-11-24 | Arapahoe | Colorado | 8005 | 89610 | 986 |
1943592 | 1943592 | 2021-11-23 | Arapahoe | Colorado | 8005 | 88981 | 983 |
1940342 | 1940342 | 2021-11-22 | Arapahoe | Colorado | 8005 | 88980 | 983 |
1937092 | 1937092 | 2021-11-21 | Arapahoe | Colorado | 8005 | 88566 | 981 |
1933842 | 1933842 | 2021-11-20 | Arapahoe | Colorado | 8005 | 87698 | 972 |
1930590 | 1930590 | 2021-11-19 | Arapahoe | Colorado | 8005 | 87698 | 972 |
1927340 | 1927340 | 2021-11-18 | Arapahoe | Colorado | 8005 | 87697 | 972 |
1924090 | 1924090 | 2021-11-17 | Arapahoe | Colorado | 8005 | 87131 | 972 |
1920841 | 1920841 | 2021-11-16 | Arapahoe | Colorado | 8005 | 86832 | 971 |
1917591 | 1917591 | 2021-11-15 | Arapahoe | Colorado | 8005 | 86556 | 967 |
1914341 | 1914341 | 2021-11-14 | Arapahoe | Colorado | 8005 | 86362 | 967 |
1911091 | 1911091 | 2021-11-13 | Arapahoe | Colorado | 8005 | 86127 | 965 |
1907842 | 1907842 | 2021-11-12 | Arapahoe | Colorado | 8005 | 85787 | 965 |
1904593 | 1904593 | 2021-11-11 | Arapahoe | Colorado | 8005 | 85496 | 963 |
1901343 | 1901343 | 2021-11-10 | Arapahoe | Colorado | 8005 | 85101 | 958 |
1898093 | 1898093 | 2021-11-09 | Arapahoe | Colorado | 8005 | 84774 | 957 |
1894843 | 1894843 | 2021-11-08 | Arapahoe | Colorado | 8005 | 84524 | 956 |
1891593 | 1891593 | 2021-11-07 | Arapahoe | Colorado | 8005 | 84029 | 952 |
1888343 | 1888343 | 2021-11-06 | Arapahoe | Colorado | 8005 | 84030 | 952 |
1885093 | 1885093 | 2021-11-05 | Arapahoe | Colorado | 8005 | 83712 | 950 |
1881844 | 1881844 | 2021-11-04 | Arapahoe | Colorado | 8005 | 83043 | 949 |
1878595 | 1878595 | 2021-11-03 | Arapahoe | Colorado | 8005 | 82858 | 948 |
1875346 | 1875346 | 2021-11-02 | Arapahoe | Colorado | 8005 | 82858 | 948 |
1872097 | 1872097 | 2021-11-01 | Arapahoe | Colorado | 8005 | 82184 | 939 |
1868848 | 1868848 | 2021-10-31 | Arapahoe | Colorado | 8005 | 82184 | 939 |
1865599 | 1865599 | 2021-10-30 | Arapahoe | Colorado | 8005 | 81884 | 937 |
1862350 | 1862350 | 2021-10-29 | Arapahoe | Colorado | 8005 | 81884 | 937 |
1859101 | 1859101 | 2021-10-28 | Arapahoe | Colorado | 8005 | 81608 | 932 |
1855852 | 1855852 | 2021-10-27 | Arapahoe | Colorado | 8005 | 81062 | 931 |
1852603 | 1852603 | 2021-10-26 | Arapahoe | Colorado | 8005 | 81064 | 931 |
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);