ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Pueblo" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174491 | 2174491 | 2022-02-02 | Pueblo | Colorado | 8101 | 42073 | 732 |
2171238 | 2171238 | 2022-02-01 | Pueblo | Colorado | 8101 | 41915 | 731 |
2167985 | 2167985 | 2022-01-31 | Pueblo | Colorado | 8101 | 41721 | 727 |
2164730 | 2164730 | 2022-01-30 | Pueblo | Colorado | 8101 | 41282 | 724 |
2161475 | 2161475 | 2022-01-29 | Pueblo | Colorado | 8101 | 40989 | 720 |
2158219 | 2158219 | 2022-01-28 | Pueblo | Colorado | 8101 | 41282 | 724 |
2154966 | 2154966 | 2022-01-27 | Pueblo | Colorado | 8101 | 40989 | 720 |
2151713 | 2151713 | 2022-01-26 | Pueblo | Colorado | 8101 | 40640 | 720 |
2148461 | 2148461 | 2022-01-25 | Pueblo | Colorado | 8101 | 40442 | 719 |
2145209 | 2145209 | 2022-01-24 | Pueblo | Colorado | 8101 | 40270 | 710 |
2141954 | 2141954 | 2022-01-23 | Pueblo | Colorado | 8101 | 39121 | 708 |
2138699 | 2138699 | 2022-01-22 | Pueblo | Colorado | 8101 | 39121 | 708 |
2135443 | 2135443 | 2022-01-21 | Pueblo | Colorado | 8101 | 39121 | 708 |
2132191 | 2132191 | 2022-01-20 | Pueblo | Colorado | 8101 | 38733 | 708 |
2128938 | 2128938 | 2022-01-19 | Pueblo | Colorado | 8101 | 38120 | 705 |
2125684 | 2125684 | 2022-01-18 | Pueblo | Colorado | 8101 | 37800 | 700 |
2122432 | 2122432 | 2022-01-17 | Pueblo | Colorado | 8101 | 37341 | 700 |
2119180 | 2119180 | 2022-01-16 | Pueblo | Colorado | 8101 | 36164 | 699 |
2115928 | 2115928 | 2022-01-15 | Pueblo | Colorado | 8101 | 36164 | 699 |
2112677 | 2112677 | 2022-01-14 | Pueblo | Colorado | 8101 | 36164 | 699 |
2109425 | 2109425 | 2022-01-13 | Pueblo | Colorado | 8101 | 35565 | 695 |
2106174 | 2106174 | 2022-01-12 | Pueblo | Colorado | 8101 | 35077 | 691 |
2102923 | 2102923 | 2022-01-11 | Pueblo | Colorado | 8101 | 34724 | 691 |
2099672 | 2099672 | 2022-01-10 | Pueblo | Colorado | 8101 | 34155 | 680 |
2096421 | 2096421 | 2022-01-09 | Pueblo | Colorado | 8101 | 32885 | 680 |
2093169 | 2093169 | 2022-01-08 | Pueblo | Colorado | 8101 | 32885 | 680 |
2089917 | 2089917 | 2022-01-07 | Pueblo | Colorado | 8101 | 32885 | 680 |
2086666 | 2086666 | 2022-01-06 | Pueblo | Colorado | 8101 | 32646 | 680 |
2083414 | 2083414 | 2022-01-05 | Pueblo | Colorado | 8101 | 32484 | 678 |
2080162 | 2080162 | 2022-01-04 | Pueblo | Colorado | 8101 | 32354 | 677 |
2076910 | 2076910 | 2022-01-03 | Pueblo | Colorado | 8101 | 32142 | 672 |
2073659 | 2073659 | 2022-01-02 | Pueblo | Colorado | 8101 | 31666 | 669 |
2070408 | 2070408 | 2022-01-01 | Pueblo | Colorado | 8101 | 31666 | 669 |
2067157 | 2067157 | 2021-12-31 | Pueblo | Colorado | 8101 | 31666 | 669 |
2063906 | 2063906 | 2021-12-30 | Pueblo | Colorado | 8101 | 31496 | 666 |
2060656 | 2060656 | 2021-12-29 | Pueblo | Colorado | 8101 | 31340 | 664 |
2057407 | 2057407 | 2021-12-28 | Pueblo | Colorado | 8101 | 31211 | 660 |
2054158 | 2054158 | 2021-12-27 | Pueblo | Colorado | 8101 | 31139 | 653 |
2050908 | 2050908 | 2021-12-26 | Pueblo | Colorado | 8101 | 30980 | 652 |
2047658 | 2047658 | 2021-12-25 | Pueblo | Colorado | 8101 | 30980 | 652 |
2044408 | 2044408 | 2021-12-24 | Pueblo | Colorado | 8101 | 30980 | 652 |
2041159 | 2041159 | 2021-12-23 | Pueblo | Colorado | 8101 | 30920 | 650 |
2037909 | 2037909 | 2021-12-22 | Pueblo | Colorado | 8101 | 30863 | 649 |
2034659 | 2034659 | 2021-12-21 | Pueblo | Colorado | 8101 | 30793 | 647 |
2031409 | 2031409 | 2021-12-20 | Pueblo | Colorado | 8101 | 30739 | 643 |
2028158 | 2028158 | 2021-12-19 | Pueblo | Colorado | 8101 | 30667 | 639 |
2024907 | 2024907 | 2021-12-18 | Pueblo | Colorado | 8101 | 30667 | 639 |
2021656 | 2021656 | 2021-12-17 | Pueblo | Colorado | 8101 | 30667 | 639 |
2018405 | 2018405 | 2021-12-16 | Pueblo | Colorado | 8101 | 30615 | 637 |
2015155 | 2015155 | 2021-12-15 | Pueblo | Colorado | 8101 | 30545 | 633 |
2011904 | 2011904 | 2021-12-14 | Pueblo | Colorado | 8101 | 30460 | 629 |
2008653 | 2008653 | 2021-12-13 | Pueblo | Colorado | 8101 | 30421 | 625 |
2005402 | 2005402 | 2021-12-12 | Pueblo | Colorado | 8101 | 30308 | 619 |
2002151 | 2002151 | 2021-12-11 | Pueblo | Colorado | 8101 | 30308 | 619 |
1998901 | 1998901 | 2021-12-10 | Pueblo | Colorado | 8101 | 30308 | 619 |
1995650 | 1995650 | 2021-12-09 | Pueblo | Colorado | 8101 | 30254 | 618 |
1992399 | 1992399 | 2021-12-08 | Pueblo | Colorado | 8101 | 30160 | 610 |
1989148 | 1989148 | 2021-12-07 | Pueblo | Colorado | 8101 | 30071 | 604 |
1985898 | 1985898 | 2021-12-06 | Pueblo | Colorado | 8101 | 29969 | 596 |
1982648 | 1982648 | 2021-12-05 | Pueblo | Colorado | 8101 | 29805 | 594 |
1979398 | 1979398 | 2021-12-04 | Pueblo | Colorado | 8101 | 29805 | 594 |
1976148 | 1976148 | 2021-12-03 | Pueblo | Colorado | 8101 | 29805 | 594 |
1972899 | 1972899 | 2021-12-02 | Pueblo | Colorado | 8101 | 29695 | 593 |
1969649 | 1969649 | 2021-12-01 | Pueblo | Colorado | 8101 | 29596 | 589 |
1966399 | 1966399 | 2021-11-30 | Pueblo | Colorado | 8101 | 29441 | 587 |
1963147 | 1963147 | 2021-11-29 | Pueblo | Colorado | 8101 | 29383 | 582 |
1959896 | 1959896 | 2021-11-28 | Pueblo | Colorado | 8101 | 29234 | 581 |
1956645 | 1956645 | 2021-11-27 | Pueblo | Colorado | 8101 | 29192 | 576 |
1953394 | 1953394 | 2021-11-26 | Pueblo | Colorado | 8101 | 29192 | 576 |
1950143 | 1950143 | 2021-11-25 | Pueblo | Colorado | 8101 | 29192 | 576 |
1946892 | 1946892 | 2021-11-24 | Pueblo | Colorado | 8101 | 29085 | 576 |
1943641 | 1943641 | 2021-11-23 | Pueblo | Colorado | 8101 | 28954 | 569 |
1940391 | 1940391 | 2021-11-22 | Pueblo | Colorado | 8101 | 28867 | 560 |
1937141 | 1937141 | 2021-11-21 | Pueblo | Colorado | 8101 | 28613 | 553 |
1933891 | 1933891 | 2021-11-20 | Pueblo | Colorado | 8101 | 28613 | 553 |
1930639 | 1930639 | 2021-11-19 | Pueblo | Colorado | 8101 | 28613 | 553 |
1927389 | 1927389 | 2021-11-18 | Pueblo | Colorado | 8101 | 28484 | 551 |
1924139 | 1924139 | 2021-11-17 | Pueblo | Colorado | 8101 | 28340 | 545 |
1920890 | 1920890 | 2021-11-16 | Pueblo | Colorado | 8101 | 28175 | 542 |
1917640 | 1917640 | 2021-11-15 | Pueblo | Colorado | 8101 | 28076 | 535 |
1914390 | 1914390 | 2021-11-14 | Pueblo | Colorado | 8101 | 27743 | 525 |
1911140 | 1911140 | 2021-11-13 | Pueblo | Colorado | 8101 | 27743 | 525 |
1907891 | 1907891 | 2021-11-12 | Pueblo | Colorado | 8101 | 27743 | 525 |
1904642 | 1904642 | 2021-11-11 | Pueblo | Colorado | 8101 | 27607 | 525 |
1901392 | 1901392 | 2021-11-10 | Pueblo | Colorado | 8101 | 27434 | 523 |
1898142 | 1898142 | 2021-11-09 | Pueblo | Colorado | 8101 | 27212 | 519 |
1894892 | 1894892 | 2021-11-08 | Pueblo | Colorado | 8101 | 27084 | 518 |
1891642 | 1891642 | 2021-11-07 | Pueblo | Colorado | 8101 | 26736 | 512 |
1888392 | 1888392 | 2021-11-06 | Pueblo | Colorado | 8101 | 26736 | 512 |
1885142 | 1885142 | 2021-11-05 | Pueblo | Colorado | 8101 | 26736 | 512 |
1881893 | 1881893 | 2021-11-04 | Pueblo | Colorado | 8101 | 26555 | 507 |
1878644 | 1878644 | 2021-11-03 | Pueblo | Colorado | 8101 | 26336 | 504 |
1875395 | 1875395 | 2021-11-02 | Pueblo | Colorado | 8101 | 26175 | 504 |
1872146 | 1872146 | 2021-11-01 | Pueblo | Colorado | 8101 | 26086 | 500 |
1868897 | 1868897 | 2021-10-31 | Pueblo | Colorado | 8101 | 25691 | 495 |
1865648 | 1865648 | 2021-10-30 | Pueblo | Colorado | 8101 | 25691 | 495 |
1862399 | 1862399 | 2021-10-29 | Pueblo | Colorado | 8101 | 25691 | 495 |
1859150 | 1859150 | 2021-10-28 | Pueblo | Colorado | 8101 | 25521 | 494 |
1855901 | 1855901 | 2021-10-27 | Pueblo | Colorado | 8101 | 25324 | 491 |
1852652 | 1852652 | 2021-10-26 | Pueblo | Colorado | 8101 | 25140 | 487 |
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);