ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 8014 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174447 | 2174447 | 2022-02-02 | Broomfield | Colorado | 8014 | 12396 | 104 |
2171194 | 2171194 | 2022-02-01 | Broomfield | Colorado | 8014 | 12365 | 104 |
2167941 | 2167941 | 2022-01-31 | Broomfield | Colorado | 8014 | 12346 | 104 |
2164686 | 2164686 | 2022-01-30 | Broomfield | Colorado | 8014 | 12181 | 104 |
2161431 | 2161431 | 2022-01-29 | Broomfield | Colorado | 8014 | 12099 | 104 |
2158175 | 2158175 | 2022-01-28 | Broomfield | Colorado | 8014 | 12181 | 104 |
2154922 | 2154922 | 2022-01-27 | Broomfield | Colorado | 8014 | 12099 | 104 |
2151669 | 2151669 | 2022-01-26 | Broomfield | Colorado | 8014 | 11975 | 104 |
2148417 | 2148417 | 2022-01-25 | Broomfield | Colorado | 8014 | 11928 | 104 |
2145165 | 2145165 | 2022-01-24 | Broomfield | Colorado | 8014 | 11857 | 102 |
2141910 | 2141910 | 2022-01-23 | Broomfield | Colorado | 8014 | 11612 | 102 |
2138655 | 2138655 | 2022-01-22 | Broomfield | Colorado | 8014 | 11612 | 102 |
2135399 | 2135399 | 2022-01-21 | Broomfield | Colorado | 8014 | 11612 | 102 |
2132147 | 2132147 | 2022-01-20 | Broomfield | Colorado | 8014 | 11450 | 102 |
2128894 | 2128894 | 2022-01-19 | Broomfield | Colorado | 8014 | 11269 | 102 |
2125640 | 2125640 | 2022-01-18 | Broomfield | Colorado | 8014 | 11178 | 100 |
2122388 | 2122388 | 2022-01-17 | Broomfield | Colorado | 8014 | 11038 | 100 |
2119136 | 2119136 | 2022-01-16 | Broomfield | Colorado | 8014 | 10645 | 99 |
2115884 | 2115884 | 2022-01-15 | Broomfield | Colorado | 8014 | 10645 | 99 |
2112633 | 2112633 | 2022-01-14 | Broomfield | Colorado | 8014 | 10645 | 99 |
2109381 | 2109381 | 2022-01-13 | Broomfield | Colorado | 8014 | 10493 | 99 |
2106130 | 2106130 | 2022-01-12 | Broomfield | Colorado | 8014 | 10366 | 99 |
2102879 | 2102879 | 2022-01-11 | Broomfield | Colorado | 8014 | 10213 | 98 |
2099628 | 2099628 | 2022-01-10 | Broomfield | Colorado | 8014 | 9931 | 98 |
2096377 | 2096377 | 2022-01-09 | Broomfield | Colorado | 8014 | 9422 | 98 |
2093125 | 2093125 | 2022-01-08 | Broomfield | Colorado | 8014 | 9422 | 98 |
2089873 | 2089873 | 2022-01-07 | Broomfield | Colorado | 8014 | 9422 | 98 |
2086622 | 2086622 | 2022-01-06 | Broomfield | Colorado | 8014 | 9306 | 98 |
2083370 | 2083370 | 2022-01-05 | Broomfield | Colorado | 8014 | 9201 | 98 |
2080118 | 2080118 | 2022-01-04 | Broomfield | Colorado | 8014 | 9129 | 98 |
2076866 | 2076866 | 2022-01-03 | Broomfield | Colorado | 8014 | 9041 | 97 |
2073615 | 2073615 | 2022-01-02 | Broomfield | Colorado | 8014 | 8767 | 97 |
2070364 | 2070364 | 2022-01-01 | Broomfield | Colorado | 8014 | 8767 | 97 |
2067113 | 2067113 | 2021-12-31 | Broomfield | Colorado | 8014 | 8767 | 97 |
2063862 | 2063862 | 2021-12-30 | Broomfield | Colorado | 8014 | 8634 | 97 |
2060612 | 2060612 | 2021-12-29 | Broomfield | Colorado | 8014 | 8490 | 96 |
2057363 | 2057363 | 2021-12-28 | Broomfield | Colorado | 8014 | 8419 | 95 |
2054114 | 2054114 | 2021-12-27 | Broomfield | Colorado | 8014 | 8356 | 94 |
2050864 | 2050864 | 2021-12-26 | Broomfield | Colorado | 8014 | 8188 | 94 |
2047614 | 2047614 | 2021-12-25 | Broomfield | Colorado | 8014 | 8188 | 94 |
2044364 | 2044364 | 2021-12-24 | Broomfield | Colorado | 8014 | 8188 | 94 |
2041115 | 2041115 | 2021-12-23 | Broomfield | Colorado | 8014 | 8142 | 95 |
2037865 | 2037865 | 2021-12-22 | Broomfield | Colorado | 8014 | 8108 | 95 |
2034615 | 2034615 | 2021-12-21 | Broomfield | Colorado | 8014 | 8062 | 95 |
2031365 | 2031365 | 2021-12-20 | Broomfield | Colorado | 8014 | 8028 | 94 |
2028114 | 2028114 | 2021-12-19 | Broomfield | Colorado | 8014 | 7980 | 93 |
2024863 | 2024863 | 2021-12-18 | Broomfield | Colorado | 8014 | 7980 | 93 |
2021612 | 2021612 | 2021-12-17 | Broomfield | Colorado | 8014 | 7980 | 93 |
2018361 | 2018361 | 2021-12-16 | Broomfield | Colorado | 8014 | 7960 | 93 |
2015111 | 2015111 | 2021-12-15 | Broomfield | Colorado | 8014 | 7932 | 92 |
2011860 | 2011860 | 2021-12-14 | Broomfield | Colorado | 8014 | 7907 | 91 |
2008609 | 2008609 | 2021-12-13 | Broomfield | Colorado | 8014 | 7892 | 90 |
2005358 | 2005358 | 2021-12-12 | Broomfield | Colorado | 8014 | 7847 | 89 |
2002107 | 2002107 | 2021-12-11 | Broomfield | Colorado | 8014 | 7847 | 89 |
1998857 | 1998857 | 2021-12-10 | Broomfield | Colorado | 8014 | 7847 | 89 |
1995606 | 1995606 | 2021-12-09 | Broomfield | Colorado | 8014 | 7824 | 89 |
1992355 | 1992355 | 2021-12-08 | Broomfield | Colorado | 8014 | 7785 | 88 |
1989104 | 1989104 | 2021-12-07 | Broomfield | Colorado | 8014 | 7762 | 88 |
1985854 | 1985854 | 2021-12-06 | Broomfield | Colorado | 8014 | 7728 | 87 |
1982604 | 1982604 | 2021-12-05 | Broomfield | Colorado | 8014 | 7675 | 87 |
1979354 | 1979354 | 2021-12-04 | Broomfield | Colorado | 8014 | 7675 | 87 |
1976104 | 1976104 | 2021-12-03 | Broomfield | Colorado | 8014 | 7675 | 87 |
1972855 | 1972855 | 2021-12-02 | Broomfield | Colorado | 8014 | 7653 | 86 |
1969605 | 1969605 | 2021-12-01 | Broomfield | Colorado | 8014 | 7630 | 86 |
1966355 | 1966355 | 2021-11-30 | Broomfield | Colorado | 8014 | 7601 | 85 |
1963103 | 1963103 | 2021-11-29 | Broomfield | Colorado | 8014 | 7570 | 85 |
1959852 | 1959852 | 2021-11-28 | Broomfield | Colorado | 8014 | 7514 | 84 |
1956601 | 1956601 | 2021-11-27 | Broomfield | Colorado | 8014 | 7499 | 84 |
1953350 | 1953350 | 2021-11-26 | Broomfield | Colorado | 8014 | 7499 | 84 |
1950099 | 1950099 | 2021-11-25 | Broomfield | Colorado | 8014 | 7499 | 84 |
1946848 | 1946848 | 2021-11-24 | Broomfield | Colorado | 8014 | 7475 | 84 |
1943597 | 1943597 | 2021-11-23 | Broomfield | Colorado | 8014 | 7448 | 84 |
1940347 | 1940347 | 2021-11-22 | Broomfield | Colorado | 8014 | 7428 | 84 |
1937097 | 1937097 | 2021-11-21 | Broomfield | Colorado | 8014 | 7369 | 84 |
1933847 | 1933847 | 2021-11-20 | Broomfield | Colorado | 8014 | 7369 | 84 |
1930595 | 1930595 | 2021-11-19 | Broomfield | Colorado | 8014 | 7369 | 84 |
1927345 | 1927345 | 2021-11-18 | Broomfield | Colorado | 8014 | 7339 | 84 |
1924095 | 1924095 | 2021-11-17 | Broomfield | Colorado | 8014 | 7299 | 84 |
1920846 | 1920846 | 2021-11-16 | Broomfield | Colorado | 8014 | 7288 | 84 |
1917596 | 1917596 | 2021-11-15 | Broomfield | Colorado | 8014 | 7233 | 84 |
1914346 | 1914346 | 2021-11-14 | Broomfield | Colorado | 8014 | 7135 | 84 |
1911096 | 1911096 | 2021-11-13 | Broomfield | Colorado | 8014 | 7135 | 84 |
1907847 | 1907847 | 2021-11-12 | Broomfield | Colorado | 8014 | 7135 | 84 |
1904598 | 1904598 | 2021-11-11 | Broomfield | Colorado | 8014 | 7091 | 84 |
1901348 | 1901348 | 2021-11-10 | Broomfield | Colorado | 8014 | 7066 | 84 |
1898098 | 1898098 | 2021-11-09 | Broomfield | Colorado | 8014 | 7033 | 84 |
1894848 | 1894848 | 2021-11-08 | Broomfield | Colorado | 8014 | 7008 | 83 |
1891598 | 1891598 | 2021-11-07 | Broomfield | Colorado | 8014 | 6928 | 83 |
1888348 | 1888348 | 2021-11-06 | Broomfield | Colorado | 8014 | 6928 | 83 |
1885098 | 1885098 | 2021-11-05 | Broomfield | Colorado | 8014 | 6928 | 83 |
1881849 | 1881849 | 2021-11-04 | Broomfield | Colorado | 8014 | 6890 | 83 |
1878600 | 1878600 | 2021-11-03 | Broomfield | Colorado | 8014 | 6846 | 83 |
1875351 | 1875351 | 2021-11-02 | Broomfield | Colorado | 8014 | 6831 | 83 |
1872102 | 1872102 | 2021-11-01 | Broomfield | Colorado | 8014 | 6809 | 82 |
1868853 | 1868853 | 2021-10-31 | Broomfield | Colorado | 8014 | 6753 | 82 |
1865604 | 1865604 | 2021-10-30 | Broomfield | Colorado | 8014 | 6753 | 82 |
1862355 | 1862355 | 2021-10-29 | Broomfield | Colorado | 8014 | 6753 | 82 |
1859106 | 1859106 | 2021-10-28 | Broomfield | Colorado | 8014 | 6727 | 82 |
1855857 | 1855857 | 2021-10-27 | Broomfield | Colorado | 8014 | 6693 | 81 |
1852608 | 1852608 | 2021-10-26 | Broomfield | Colorado | 8014 | 6658 | 81 |
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);