ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 8013 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174446 | 2174446 | 2022-02-02 | Boulder | Colorado | 8013 | 58046 | 351 |
2171193 | 2171193 | 2022-02-01 | Boulder | Colorado | 8013 | 58046 | 351 |
2167940 | 2167940 | 2022-01-31 | Boulder | Colorado | 8013 | 57838 | 348 |
2164685 | 2164685 | 2022-01-30 | Boulder | Colorado | 8013 | 57181 | 347 |
2161430 | 2161430 | 2022-01-29 | Boulder | Colorado | 8013 | 57181 | 347 |
2158174 | 2158174 | 2022-01-28 | Boulder | Colorado | 8013 | 57181 | 347 |
2154921 | 2154921 | 2022-01-27 | Boulder | Colorado | 8013 | 56759 | 344 |
2151668 | 2151668 | 2022-01-26 | Boulder | Colorado | 8013 | 56155 | 344 |
2148416 | 2148416 | 2022-01-25 | Boulder | Colorado | 8013 | 55878 | 344 |
2145164 | 2145164 | 2022-01-24 | Boulder | Colorado | 8013 | 55422 | 344 |
2141909 | 2141909 | 2022-01-23 | Boulder | Colorado | 8013 | 54219 | 341 |
2138654 | 2138654 | 2022-01-22 | Boulder | Colorado | 8013 | 54219 | 341 |
2135398 | 2135398 | 2022-01-21 | Boulder | Colorado | 8013 | 54219 | 341 |
2132146 | 2132146 | 2022-01-20 | Boulder | Colorado | 8013 | 53052 | 339 |
2128893 | 2128893 | 2022-01-19 | Boulder | Colorado | 8013 | 52395 | 339 |
2125639 | 2125639 | 2022-01-18 | Boulder | Colorado | 8013 | 51911 | 339 |
2122387 | 2122387 | 2022-01-17 | Boulder | Colorado | 8013 | 50594 | 336 |
2119135 | 2119135 | 2022-01-16 | Boulder | Colorado | 8013 | 49376 | 336 |
2115883 | 2115883 | 2022-01-15 | Boulder | Colorado | 8013 | 49376 | 336 |
2112632 | 2112632 | 2022-01-14 | Boulder | Colorado | 8013 | 49376 | 336 |
2109380 | 2109380 | 2022-01-13 | Boulder | Colorado | 8013 | 48602 | 333 |
2106129 | 2106129 | 2022-01-12 | Boulder | Colorado | 8013 | 47784 | 333 |
2102878 | 2102878 | 2022-01-11 | Boulder | Colorado | 8013 | 47098 | 333 |
2099627 | 2099627 | 2022-01-10 | Boulder | Colorado | 8013 | 45621 | 332 |
2096376 | 2096376 | 2022-01-09 | Boulder | Colorado | 8013 | 43263 | 328 |
2093124 | 2093124 | 2022-01-08 | Boulder | Colorado | 8013 | 43263 | 328 |
2089872 | 2089872 | 2022-01-07 | Boulder | Colorado | 8013 | 43263 | 328 |
2086621 | 2086621 | 2022-01-06 | Boulder | Colorado | 8013 | 42490 | 327 |
2083369 | 2083369 | 2022-01-05 | Boulder | Colorado | 8013 | 42050 | 327 |
2080117 | 2080117 | 2022-01-04 | Boulder | Colorado | 8013 | 41702 | 327 |
2076865 | 2076865 | 2022-01-03 | Boulder | Colorado | 8013 | 41453 | 327 |
2073614 | 2073614 | 2022-01-02 | Boulder | Colorado | 8013 | 39792 | 327 |
2070363 | 2070363 | 2022-01-01 | Boulder | Colorado | 8013 | 39792 | 327 |
2067112 | 2067112 | 2021-12-31 | Boulder | Colorado | 8013 | 39792 | 327 |
2063861 | 2063861 | 2021-12-30 | Boulder | Colorado | 8013 | 39792 | 327 |
2060611 | 2060611 | 2021-12-29 | Boulder | Colorado | 8013 | 39320 | 327 |
2057362 | 2057362 | 2021-12-28 | Boulder | Colorado | 8013 | 38785 | 326 |
2054113 | 2054113 | 2021-12-27 | Boulder | Colorado | 8013 | 38349 | 324 |
2050863 | 2050863 | 2021-12-26 | Boulder | Colorado | 8013 | 37292 | 323 |
2047613 | 2047613 | 2021-12-25 | Boulder | Colorado | 8013 | 37292 | 323 |
2044363 | 2044363 | 2021-12-24 | Boulder | Colorado | 8013 | 37292 | 323 |
2041114 | 2041114 | 2021-12-23 | Boulder | Colorado | 8013 | 37196 | 323 |
2037864 | 2037864 | 2021-12-22 | Boulder | Colorado | 8013 | 37196 | 323 |
2034614 | 2034614 | 2021-12-21 | Boulder | Colorado | 8013 | 36968 | 323 |
2031364 | 2031364 | 2021-12-20 | Boulder | Colorado | 8013 | 36754 | 323 |
2028113 | 2028113 | 2021-12-19 | Boulder | Colorado | 8013 | 36531 | 322 |
2024862 | 2024862 | 2021-12-18 | Boulder | Colorado | 8013 | 36531 | 322 |
2021611 | 2021611 | 2021-12-17 | Boulder | Colorado | 8013 | 36531 | 322 |
2018360 | 2018360 | 2021-12-16 | Boulder | Colorado | 8013 | 36406 | 320 |
2015110 | 2015110 | 2021-12-15 | Boulder | Colorado | 8013 | 36303 | 320 |
2011859 | 2011859 | 2021-12-14 | Boulder | Colorado | 8013 | 36203 | 320 |
2008608 | 2008608 | 2021-12-13 | Boulder | Colorado | 8013 | 36135 | 318 |
2005357 | 2005357 | 2021-12-12 | Boulder | Colorado | 8013 | 35905 | 318 |
2002106 | 2002106 | 2021-12-11 | Boulder | Colorado | 8013 | 35905 | 318 |
1998856 | 1998856 | 2021-12-10 | Boulder | Colorado | 8013 | 35905 | 318 |
1995605 | 1995605 | 2021-12-09 | Boulder | Colorado | 8013 | 35833 | 317 |
1992354 | 1992354 | 2021-12-08 | Boulder | Colorado | 8013 | 35726 | 317 |
1989103 | 1989103 | 2021-12-07 | Boulder | Colorado | 8013 | 35621 | 317 |
1985853 | 1985853 | 2021-12-06 | Boulder | Colorado | 8013 | 35511 | 313 |
1982603 | 1982603 | 2021-12-05 | Boulder | Colorado | 8013 | 35256 | 313 |
1979353 | 1979353 | 2021-12-04 | Boulder | Colorado | 8013 | 35256 | 313 |
1976103 | 1976103 | 2021-12-03 | Boulder | Colorado | 8013 | 35256 | 313 |
1972854 | 1972854 | 2021-12-02 | Boulder | Colorado | 8013 | 35157 | 312 |
1969604 | 1969604 | 2021-12-01 | Boulder | Colorado | 8013 | 35035 | 312 |
1966354 | 1966354 | 2021-11-30 | Boulder | Colorado | 8013 | 34915 | 310 |
1963102 | 1963102 | 2021-11-29 | Boulder | Colorado | 8013 | 34810 | 308 |
1959851 | 1959851 | 2021-11-28 | Boulder | Colorado | 8013 | 34465 | 307 |
1956600 | 1956600 | 2021-11-27 | Boulder | Colorado | 8013 | 34465 | 307 |
1953349 | 1953349 | 2021-11-26 | Boulder | Colorado | 8013 | 34465 | 307 |
1950098 | 1950098 | 2021-11-25 | Boulder | Colorado | 8013 | 34465 | 307 |
1946847 | 1946847 | 2021-11-24 | Boulder | Colorado | 8013 | 34465 | 307 |
1943596 | 1943596 | 2021-11-23 | Boulder | Colorado | 8013 | 34289 | 306 |
1940346 | 1940346 | 2021-11-22 | Boulder | Colorado | 8013 | 34208 | 306 |
1937096 | 1937096 | 2021-11-21 | Boulder | Colorado | 8013 | 33951 | 299 |
1933846 | 1933846 | 2021-11-20 | Boulder | Colorado | 8013 | 33951 | 299 |
1930594 | 1930594 | 2021-11-19 | Boulder | Colorado | 8013 | 33951 | 299 |
1927344 | 1927344 | 2021-11-18 | Boulder | Colorado | 8013 | 33784 | 297 |
1924094 | 1924094 | 2021-11-17 | Boulder | Colorado | 8013 | 33621 | 297 |
1920845 | 1920845 | 2021-11-16 | Boulder | Colorado | 8013 | 33445 | 296 |
1917595 | 1917595 | 2021-11-15 | Boulder | Colorado | 8013 | 33307 | 296 |
1914345 | 1914345 | 2021-11-14 | Boulder | Colorado | 8013 | 33011 | 294 |
1911095 | 1911095 | 2021-11-13 | Boulder | Colorado | 8013 | 33011 | 294 |
1907846 | 1907846 | 2021-11-12 | Boulder | Colorado | 8013 | 33011 | 294 |
1904597 | 1904597 | 2021-11-11 | Boulder | Colorado | 8013 | 32738 | 292 |
1901347 | 1901347 | 2021-11-10 | Boulder | Colorado | 8013 | 32738 | 292 |
1898097 | 1898097 | 2021-11-09 | Boulder | Colorado | 8013 | 32624 | 292 |
1894847 | 1894847 | 2021-11-08 | Boulder | Colorado | 8013 | 32487 | 292 |
1891597 | 1891597 | 2021-11-07 | Boulder | Colorado | 8013 | 32123 | 287 |
1888347 | 1888347 | 2021-11-06 | Boulder | Colorado | 8013 | 32123 | 287 |
1885097 | 1885097 | 2021-11-05 | Boulder | Colorado | 8013 | 32123 | 287 |
1881848 | 1881848 | 2021-11-04 | Boulder | Colorado | 8013 | 31972 | 286 |
1878599 | 1878599 | 2021-11-03 | Boulder | Colorado | 8013 | 31842 | 286 |
1875350 | 1875350 | 2021-11-02 | Boulder | Colorado | 8013 | 31674 | 286 |
1872101 | 1872101 | 2021-11-01 | Boulder | Colorado | 8013 | 31582 | 286 |
1868852 | 1868852 | 2021-10-31 | Boulder | Colorado | 8013 | 31388 | 286 |
1865603 | 1865603 | 2021-10-30 | Boulder | Colorado | 8013 | 31175 | 286 |
1862354 | 1862354 | 2021-10-29 | Boulder | Colorado | 8013 | 31175 | 286 |
1859105 | 1859105 | 2021-10-28 | Boulder | Colorado | 8013 | 31175 | 286 |
1855856 | 1855856 | 2021-10-27 | Boulder | Colorado | 8013 | 31036 | 281 |
1852607 | 1852607 | 2021-10-26 | Boulder | Colorado | 8013 | 30888 | 281 |
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);