ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Weld" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174502 | 2174502 | 2022-02-02 | Weld | Colorado | 8123 | 77171 | 631 |
2171249 | 2171249 | 2022-02-01 | Weld | Colorado | 8123 | 77140 | 632 |
2167996 | 2167996 | 2022-01-31 | Weld | Colorado | 8123 | 76888 | 630 |
2164741 | 2164741 | 2022-01-30 | Weld | Colorado | 8123 | 75994 | 628 |
2161486 | 2161486 | 2022-01-29 | Weld | Colorado | 8123 | 75994 | 624 |
2158230 | 2158230 | 2022-01-28 | Weld | Colorado | 8123 | 75994 | 624 |
2154977 | 2154977 | 2022-01-27 | Weld | Colorado | 8123 | 75452 | 624 |
2151724 | 2151724 | 2022-01-26 | Weld | Colorado | 8123 | 75013 | 623 |
2148472 | 2148472 | 2022-01-25 | Weld | Colorado | 8123 | 74084 | 623 |
2145220 | 2145220 | 2022-01-24 | Weld | Colorado | 8123 | 73945 | 620 |
2141965 | 2141965 | 2022-01-23 | Weld | Colorado | 8123 | 72372 | 617 |
2138710 | 2138710 | 2022-01-22 | Weld | Colorado | 8123 | 72372 | 617 |
2135454 | 2135454 | 2022-01-21 | Weld | Colorado | 8123 | 72372 | 617 |
2132202 | 2132202 | 2022-01-20 | Weld | Colorado | 8123 | 71583 | 615 |
2128949 | 2128949 | 2022-01-19 | Weld | Colorado | 8123 | 70690 | 614 |
2125695 | 2125695 | 2022-01-18 | Weld | Colorado | 8123 | 69934 | 613 |
2122443 | 2122443 | 2022-01-17 | Weld | Colorado | 8123 | 69009 | 613 |
2119191 | 2119191 | 2022-01-16 | Weld | Colorado | 8123 | 67265 | 608 |
2115939 | 2115939 | 2022-01-15 | Weld | Colorado | 8123 | 67265 | 608 |
2112688 | 2112688 | 2022-01-14 | Weld | Colorado | 8123 | 67265 | 608 |
2109436 | 2109436 | 2022-01-13 | Weld | Colorado | 8123 | 66308 | 604 |
2106185 | 2106185 | 2022-01-12 | Weld | Colorado | 8123 | 65502 | 604 |
2102934 | 2102934 | 2022-01-11 | Weld | Colorado | 8123 | 64643 | 603 |
2099683 | 2099683 | 2022-01-10 | Weld | Colorado | 8123 | 63891 | 600 |
2096432 | 2096432 | 2022-01-09 | Weld | Colorado | 8123 | 60879 | 596 |
2093180 | 2093180 | 2022-01-08 | Weld | Colorado | 8123 | 60879 | 596 |
2089928 | 2089928 | 2022-01-07 | Weld | Colorado | 8123 | 60879 | 596 |
2086677 | 2086677 | 2022-01-06 | Weld | Colorado | 8123 | 60333 | 594 |
2083425 | 2083425 | 2022-01-05 | Weld | Colorado | 8123 | 59825 | 590 |
2080173 | 2080173 | 2022-01-04 | Weld | Colorado | 8123 | 59480 | 589 |
2076921 | 2076921 | 2022-01-03 | Weld | Colorado | 8123 | 59125 | 588 |
2073670 | 2073670 | 2022-01-02 | Weld | Colorado | 8123 | 57839 | 587 |
2070419 | 2070419 | 2022-01-01 | Weld | Colorado | 8123 | 57839 | 587 |
2067168 | 2067168 | 2021-12-31 | Weld | Colorado | 8123 | 57839 | 587 |
2063917 | 2063917 | 2021-12-30 | Weld | Colorado | 8123 | 57648 | 587 |
2060667 | 2060667 | 2021-12-29 | Weld | Colorado | 8123 | 57229 | 585 |
2057418 | 2057418 | 2021-12-28 | Weld | Colorado | 8123 | 56891 | 580 |
2054169 | 2054169 | 2021-12-27 | Weld | Colorado | 8123 | 56608 | 580 |
2050919 | 2050919 | 2021-12-26 | Weld | Colorado | 8123 | 56156 | 580 |
2047669 | 2047669 | 2021-12-25 | Weld | Colorado | 8123 | 56156 | 580 |
2044419 | 2044419 | 2021-12-24 | Weld | Colorado | 8123 | 56156 | 580 |
2041170 | 2041170 | 2021-12-23 | Weld | Colorado | 8123 | 55994 | 580 |
2037920 | 2037920 | 2021-12-22 | Weld | Colorado | 8123 | 55935 | 579 |
2034670 | 2034670 | 2021-12-21 | Weld | Colorado | 8123 | 55730 | 576 |
2031420 | 2031420 | 2021-12-20 | Weld | Colorado | 8123 | 55599 | 569 |
2028169 | 2028169 | 2021-12-19 | Weld | Colorado | 8123 | 55366 | 567 |
2024918 | 2024918 | 2021-12-18 | Weld | Colorado | 8123 | 55366 | 567 |
2021667 | 2021667 | 2021-12-17 | Weld | Colorado | 8123 | 55366 | 567 |
2018416 | 2018416 | 2021-12-16 | Weld | Colorado | 8123 | 55205 | 565 |
2015166 | 2015166 | 2021-12-15 | Weld | Colorado | 8123 | 55087 | 562 |
2011915 | 2011915 | 2021-12-14 | Weld | Colorado | 8123 | 54967 | 561 |
2008664 | 2008664 | 2021-12-13 | Weld | Colorado | 8123 | 54856 | 560 |
2005413 | 2005413 | 2021-12-12 | Weld | Colorado | 8123 | 54527 | 558 |
2002162 | 2002162 | 2021-12-11 | Weld | Colorado | 8123 | 54527 | 558 |
1998912 | 1998912 | 2021-12-10 | Weld | Colorado | 8123 | 54527 | 558 |
1995661 | 1995661 | 2021-12-09 | Weld | Colorado | 8123 | 54417 | 554 |
1992410 | 1992410 | 2021-12-08 | Weld | Colorado | 8123 | 54259 | 549 |
1989159 | 1989159 | 2021-12-07 | Weld | Colorado | 8123 | 54078 | 547 |
1985909 | 1985909 | 2021-12-06 | Weld | Colorado | 8123 | 53941 | 541 |
1982659 | 1982659 | 2021-12-05 | Weld | Colorado | 8123 | 53443 | 538 |
1979409 | 1979409 | 2021-12-04 | Weld | Colorado | 8123 | 53443 | 538 |
1976159 | 1976159 | 2021-12-03 | Weld | Colorado | 8123 | 53443 | 540 |
1972910 | 1972910 | 2021-12-02 | Weld | Colorado | 8123 | 53273 | 540 |
1969660 | 1969660 | 2021-12-01 | Weld | Colorado | 8123 | 53089 | 537 |
1966410 | 1966410 | 2021-11-30 | Weld | Colorado | 8123 | 52884 | 533 |
1963158 | 1963158 | 2021-11-29 | Weld | Colorado | 8123 | 52711 | 528 |
1959907 | 1959907 | 2021-11-28 | Weld | Colorado | 8123 | 52291 | 527 |
1956656 | 1956656 | 2021-11-27 | Weld | Colorado | 8123 | 52225 | 525 |
1953405 | 1953405 | 2021-11-26 | Weld | Colorado | 8123 | 52225 | 525 |
1950154 | 1950154 | 2021-11-25 | Weld | Colorado | 8123 | 52225 | 525 |
1946903 | 1946903 | 2021-11-24 | Weld | Colorado | 8123 | 52077 | 522 |
1943652 | 1943652 | 2021-11-23 | Weld | Colorado | 8123 | 51904 | 518 |
1940402 | 1940402 | 2021-11-22 | Weld | Colorado | 8123 | 51760 | 512 |
1937152 | 1937152 | 2021-11-21 | Weld | Colorado | 8123 | 51354 | 510 |
1933902 | 1933902 | 2021-11-20 | Weld | Colorado | 8123 | 51354 | 510 |
1930650 | 1930650 | 2021-11-19 | Weld | Colorado | 8123 | 51354 | 510 |
1927400 | 1927400 | 2021-11-18 | Weld | Colorado | 8123 | 51165 | 509 |
1924150 | 1924150 | 2021-11-17 | Weld | Colorado | 8123 | 50889 | 504 |
1920901 | 1920901 | 2021-11-16 | Weld | Colorado | 8123 | 50616 | 499 |
1917651 | 1917651 | 2021-11-15 | Weld | Colorado | 8123 | 50428 | 493 |
1914401 | 1914401 | 2021-11-14 | Weld | Colorado | 8123 | 49990 | 488 |
1911151 | 1911151 | 2021-11-13 | Weld | Colorado | 8123 | 49990 | 488 |
1907902 | 1907902 | 2021-11-12 | Weld | Colorado | 8123 | 49990 | 488 |
1904653 | 1904653 | 2021-11-11 | Weld | Colorado | 8123 | 49701 | 485 |
1901403 | 1901403 | 2021-11-10 | Weld | Colorado | 8123 | 49551 | 484 |
1898153 | 1898153 | 2021-11-09 | Weld | Colorado | 8123 | 49327 | 483 |
1894903 | 1894903 | 2021-11-08 | Weld | Colorado | 8123 | 49165 | 483 |
1891653 | 1891653 | 2021-11-07 | Weld | Colorado | 8123 | 48612 | 473 |
1888403 | 1888403 | 2021-11-06 | Weld | Colorado | 8123 | 48612 | 473 |
1885153 | 1885153 | 2021-11-05 | Weld | Colorado | 8123 | 48612 | 473 |
1881904 | 1881904 | 2021-11-04 | Weld | Colorado | 8123 | 48366 | 469 |
1878655 | 1878655 | 2021-11-03 | Weld | Colorado | 8123 | 48148 | 464 |
1875406 | 1875406 | 2021-11-02 | Weld | Colorado | 8123 | 47892 | 463 |
1872157 | 1872157 | 2021-11-01 | Weld | Colorado | 8123 | 47694 | 460 |
1868908 | 1868908 | 2021-10-31 | Weld | Colorado | 8123 | 47208 | 455 |
1865659 | 1865659 | 2021-10-30 | Weld | Colorado | 8123 | 47208 | 455 |
1862410 | 1862410 | 2021-10-29 | Weld | Colorado | 8123 | 47208 | 455 |
1859161 | 1859161 | 2021-10-28 | Weld | Colorado | 8123 | 46980 | 454 |
1855912 | 1855912 | 2021-10-27 | Weld | Colorado | 8123 | 46743 | 453 |
1852663 | 1852663 | 2021-10-26 | Weld | Colorado | 8123 | 46487 | 451 |
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);