ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
540 rows where deaths = 21 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499834 | 2499834 | 2022-05-13 | Custer | Colorado | 8027 | 656 | 21 |
2496576 | 2496576 | 2022-05-12 | Custer | Colorado | 8027 | 656 | 21 |
2493318 | 2493318 | 2022-05-11 | Custer | Colorado | 8027 | 656 | 21 |
2490060 | 2490060 | 2022-05-10 | Custer | Colorado | 8027 | 655 | 21 |
2486803 | 2486803 | 2022-05-09 | Custer | Colorado | 8027 | 655 | 21 |
2483545 | 2483545 | 2022-05-08 | Custer | Colorado | 8027 | 655 | 21 |
2480287 | 2480287 | 2022-05-07 | Custer | Colorado | 8027 | 655 | 21 |
2477029 | 2477029 | 2022-05-06 | Custer | Colorado | 8027 | 655 | 21 |
2473771 | 2473771 | 2022-05-05 | Custer | Colorado | 8027 | 655 | 21 |
2470514 | 2470514 | 2022-05-04 | Custer | Colorado | 8027 | 655 | 21 |
2467258 | 2467258 | 2022-05-03 | Custer | Colorado | 8027 | 655 | 21 |
2464003 | 2464003 | 2022-05-02 | Custer | Colorado | 8027 | 654 | 21 |
2460747 | 2460747 | 2022-05-01 | Custer | Colorado | 8027 | 653 | 21 |
2457491 | 2457491 | 2022-04-30 | Custer | Colorado | 8027 | 653 | 21 |
2454235 | 2454235 | 2022-04-29 | Custer | Colorado | 8027 | 653 | 21 |
2450979 | 2450979 | 2022-04-28 | Custer | Colorado | 8027 | 653 | 21 |
2447723 | 2447723 | 2022-04-27 | Custer | Colorado | 8027 | 653 | 21 |
2444467 | 2444467 | 2022-04-26 | Custer | Colorado | 8027 | 652 | 21 |
2441211 | 2441211 | 2022-04-25 | Custer | Colorado | 8027 | 651 | 21 |
2437955 | 2437955 | 2022-04-24 | Custer | Colorado | 8027 | 650 | 21 |
2434699 | 2434699 | 2022-04-23 | Custer | Colorado | 8027 | 650 | 21 |
2431443 | 2431443 | 2022-04-22 | Custer | Colorado | 8027 | 650 | 21 |
2428187 | 2428187 | 2022-04-21 | Custer | Colorado | 8027 | 650 | 21 |
2063918 | 2063918 | 2021-12-30 | Yuma | Colorado | 8125 | 1478 | 21 |
2060668 | 2060668 | 2021-12-29 | Yuma | Colorado | 8125 | 1476 | 21 |
2057419 | 2057419 | 2021-12-28 | Yuma | Colorado | 8125 | 1469 | 21 |
2054170 | 2054170 | 2021-12-27 | Yuma | Colorado | 8125 | 1463 | 21 |
2050920 | 2050920 | 2021-12-26 | Yuma | Colorado | 8125 | 1458 | 21 |
2047670 | 2047670 | 2021-12-25 | Yuma | Colorado | 8125 | 1458 | 21 |
2044420 | 2044420 | 2021-12-24 | Yuma | Colorado | 8125 | 1458 | 21 |
2041171 | 2041171 | 2021-12-23 | Yuma | Colorado | 8125 | 1456 | 21 |
2037921 | 2037921 | 2021-12-22 | Yuma | Colorado | 8125 | 1456 | 21 |
2034671 | 2034671 | 2021-12-21 | Yuma | Colorado | 8125 | 1451 | 21 |
1972876 | 1972876 | 2021-12-02 | Huerfano | Colorado | 8055 | 845 | 21 |
1969626 | 1969626 | 2021-12-01 | Huerfano | Colorado | 8055 | 839 | 21 |
1966376 | 1966376 | 2021-11-30 | Huerfano | Colorado | 8055 | 835 | 21 |
1966380 | 1966380 | 2021-11-30 | Kit Carson | Colorado | 8063 | 1131 | 21 |
1963124 | 1963124 | 2021-11-29 | Huerfano | Colorado | 8055 | 826 | 21 |
1963128 | 1963128 | 2021-11-29 | Kit Carson | Colorado | 8063 | 1120 | 21 |
1959873 | 1959873 | 2021-11-28 | Huerfano | Colorado | 8055 | 817 | 21 |
1959877 | 1959877 | 2021-11-28 | Kit Carson | Colorado | 8063 | 1118 | 21 |
1956622 | 1956622 | 2021-11-27 | Huerfano | Colorado | 8055 | 815 | 21 |
1956626 | 1956626 | 2021-11-27 | Kit Carson | Colorado | 8063 | 1118 | 21 |
1953371 | 1953371 | 2021-11-26 | Huerfano | Colorado | 8055 | 815 | 21 |
1953375 | 1953375 | 2021-11-26 | Kit Carson | Colorado | 8063 | 1118 | 21 |
1950120 | 1950120 | 2021-11-25 | Huerfano | Colorado | 8055 | 815 | 21 |
1950124 | 1950124 | 2021-11-25 | Kit Carson | Colorado | 8063 | 1118 | 21 |
1946869 | 1946869 | 2021-11-24 | Huerfano | Colorado | 8055 | 794 | 21 |
1946873 | 1946873 | 2021-11-24 | Kit Carson | Colorado | 8063 | 1115 | 21 |
1943618 | 1943618 | 2021-11-23 | Huerfano | Colorado | 8055 | 791 | 21 |
1940368 | 1940368 | 2021-11-22 | Huerfano | Colorado | 8055 | 783 | 21 |
1937118 | 1937118 | 2021-11-21 | Huerfano | Colorado | 8055 | 780 | 21 |
1933868 | 1933868 | 2021-11-20 | Huerfano | Colorado | 8055 | 780 | 21 |
1930616 | 1930616 | 2021-11-19 | Huerfano | Colorado | 8055 | 780 | 21 |
1927366 | 1927366 | 2021-11-18 | Huerfano | Colorado | 8055 | 773 | 21 |
1924116 | 1924116 | 2021-11-17 | Huerfano | Colorado | 8055 | 755 | 21 |
1920867 | 1920867 | 2021-11-16 | Huerfano | Colorado | 8055 | 747 | 21 |
1917617 | 1917617 | 2021-11-15 | Huerfano | Colorado | 8055 | 745 | 21 |
1904652 | 1904652 | 2021-11-11 | Washington | Colorado | 8121 | 719 | 21 |
1901402 | 1901402 | 2021-11-10 | Washington | Colorado | 8121 | 712 | 21 |
1836406 | 1836406 | 2021-10-21 | Rio Grande | Colorado | 8105 | 1468 | 21 |
1833157 | 1833157 | 2021-10-20 | Rio Grande | Colorado | 8105 | 1463 | 21 |
1829891 | 1829891 | 2021-10-19 | Las Animas | Colorado | 8071 | 1755 | 21 |
1829908 | 1829908 | 2021-10-19 | Rio Grande | Colorado | 8105 | 1457 | 21 |
1826642 | 1826642 | 2021-10-18 | Las Animas | Colorado | 8071 | 1747 | 21 |
1826659 | 1826659 | 2021-10-18 | Rio Grande | Colorado | 8105 | 1445 | 21 |
1823393 | 1823393 | 2021-10-17 | Las Animas | Colorado | 8071 | 1730 | 21 |
1823410 | 1823410 | 2021-10-17 | Rio Grande | Colorado | 8105 | 1437 | 21 |
1820144 | 1820144 | 2021-10-16 | Las Animas | Colorado | 8071 | 1730 | 21 |
1820161 | 1820161 | 2021-10-16 | Rio Grande | Colorado | 8105 | 1437 | 21 |
1816895 | 1816895 | 2021-10-15 | Las Animas | Colorado | 8071 | 1730 | 21 |
1816912 | 1816912 | 2021-10-15 | Rio Grande | Colorado | 8105 | 1437 | 21 |
1813647 | 1813647 | 2021-10-14 | Las Animas | Colorado | 8071 | 1723 | 21 |
1813664 | 1813664 | 2021-10-14 | Rio Grande | Colorado | 8105 | 1404 | 21 |
1810398 | 1810398 | 2021-10-13 | Las Animas | Colorado | 8071 | 1715 | 21 |
1810415 | 1810415 | 2021-10-13 | Rio Grande | Colorado | 8105 | 1395 | 21 |
1807126 | 1807126 | 2021-10-12 | Crowley | Colorado | 8025 | 2333 | 21 |
1807134 | 1807134 | 2021-10-12 | Elbert | Colorado | 8039 | 2555 | 21 |
1807149 | 1807149 | 2021-10-12 | Las Animas | Colorado | 8071 | 1708 | 21 |
1807166 | 1807166 | 2021-10-12 | Rio Grande | Colorado | 8105 | 1384 | 21 |
1803883 | 1803883 | 2021-10-11 | Elbert | Colorado | 8039 | 2546 | 21 |
1803898 | 1803898 | 2021-10-11 | Las Animas | Colorado | 8071 | 1705 | 21 |
1803915 | 1803915 | 2021-10-11 | Rio Grande | Colorado | 8105 | 1368 | 21 |
1800634 | 1800634 | 2021-10-10 | Elbert | Colorado | 8039 | 2516 | 21 |
1800649 | 1800649 | 2021-10-10 | Las Animas | Colorado | 8071 | 1693 | 21 |
1800666 | 1800666 | 2021-10-10 | Rio Grande | Colorado | 8105 | 1341 | 21 |
1797385 | 1797385 | 2021-10-09 | Elbert | Colorado | 8039 | 2516 | 21 |
1797400 | 1797400 | 2021-10-09 | Las Animas | Colorado | 8071 | 1693 | 21 |
1797417 | 1797417 | 2021-10-09 | Rio Grande | Colorado | 8105 | 1341 | 21 |
1794136 | 1794136 | 2021-10-08 | Elbert | Colorado | 8039 | 2516 | 21 |
1794151 | 1794151 | 2021-10-08 | Las Animas | Colorado | 8071 | 1693 | 21 |
1794168 | 1794168 | 2021-10-08 | Rio Grande | Colorado | 8105 | 1341 | 21 |
1790903 | 1790903 | 2021-10-07 | Las Animas | Colorado | 8071 | 1686 | 21 |
1790920 | 1790920 | 2021-10-07 | Rio Grande | Colorado | 8105 | 1304 | 21 |
1787654 | 1787654 | 2021-10-06 | Las Animas | Colorado | 8071 | 1685 | 21 |
1745433 | 1745433 | 2021-09-23 | Rio Grande | Colorado | 8105 | 1148 | 21 |
1742184 | 1742184 | 2021-09-22 | Rio Grande | Colorado | 8105 | 1143 | 21 |
1738935 | 1738935 | 2021-09-21 | Rio Grande | Colorado | 8105 | 1138 | 21 |
1722694 | 1722694 | 2021-09-16 | Teller | Colorado | 8119 | 2257 | 21 |
1719445 | 1719445 | 2021-09-15 | Teller | Colorado | 8119 | 2249 | 21 |
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);