ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64 rows where date = "2022-02-23" 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 |
---|---|---|---|---|---|---|---|
2242734 | 2242734 | 2022-02-23 | Adams | Colorado | 8001 | 130534 | 1296 |
2242735 | 2242735 | 2022-02-23 | Alamosa | Colorado | 8003 | 4371 | 60 |
2242736 | 2242736 | 2022-02-23 | Arapahoe | Colorado | 8005 | 148665 | 1225 |
2242737 | 2242737 | 2022-02-23 | Archuleta | Colorado | 8007 | 2814 | 13 |
2242738 | 2242738 | 2022-02-23 | Baca | Colorado | 8009 | 806 | 8 |
2242739 | 2242739 | 2022-02-23 | Bent | Colorado | 8011 | 2473 | 47 |
2242740 | 2242740 | 2022-02-23 | Boulder | Colorado | 8013 | 60977 | 380 |
2242741 | 2242741 | 2022-02-23 | Broomfield | Colorado | 8014 | 12868 | 111 |
2242742 | 2242742 | 2022-02-23 | Chaffee | Colorado | 8015 | 4270 | 42 |
2242743 | 2242743 | 2022-02-23 | Cheyenne | Colorado | 8017 | 315 | 9 |
2242744 | 2242744 | 2022-02-23 | Clear Creek | Colorado | 8019 | 1491 | 11 |
2242745 | 2242745 | 2022-02-23 | Conejos | Colorado | 8021 | 1677 | 52 |
2242746 | 2242746 | 2022-02-23 | Costilla | Colorado | 8023 | 649 | 15 |
2242747 | 2242747 | 2022-02-23 | Crowley | Colorado | 8025 | 3099 | 28 |
2242748 | 2242748 | 2022-02-23 | Custer | Colorado | 8027 | 624 | 18 |
2242749 | 2242749 | 2022-02-23 | Delta | Colorado | 8029 | 5865 | 129 |
2242750 | 2242750 | 2022-02-23 | Denver | Colorado | 8031 | 164032 | 1265 |
2242751 | 2242751 | 2022-02-23 | Dolores | Colorado | 8033 | 347 | 7 |
2242752 | 2242752 | 2022-02-23 | Douglas | Colorado | 8035 | 76054 | 422 |
2242753 | 2242753 | 2022-02-23 | Eagle | Colorado | 8037 | 15593 | 35 |
2242754 | 2242754 | 2022-02-23 | El Paso | Colorado | 8041 | 177990 | 1584 |
2242755 | 2242755 | 2022-02-23 | Elbert | Colorado | 8039 | 4639 | 37 |
2242756 | 2242756 | 2022-02-23 | Fremont | Colorado | 8043 | 14350 | 177 |
2242757 | 2242757 | 2022-02-23 | Garfield | Colorado | 8045 | 14093 | 87 |
2242758 | 2242758 | 2022-02-23 | Gilpin | Colorado | 8047 | 918 | 4 |
2242759 | 2242759 | 2022-02-23 | Grand | Colorado | 8049 | 3402 | 23 |
2242760 | 2242760 | 2022-02-23 | Gunnison | Colorado | 8051 | 3189 | 14 |
2242761 | 2242761 | 2022-02-23 | Hinsdale | Colorado | 8053 | 120 | 0 |
2242762 | 2242762 | 2022-02-23 | Huerfano | Colorado | 8055 | 1396 | 30 |
2242763 | 2242763 | 2022-02-23 | Jackson | Colorado | 8057 | 162 | 0 |
2242764 | 2242764 | 2022-02-23 | Jefferson | Colorado | 8059 | 117685 | 1294 |
2242765 | 2242765 | 2022-02-23 | Kiowa | Colorado | 8061 | 326 | 6 |
2242766 | 2242766 | 2022-02-23 | Kit Carson | Colorado | 8063 | 1569 | 29 |
2242767 | 2242767 | 2022-02-23 | La Plata | Colorado | 8067 | 12337 | 80 |
2242768 | 2242768 | 2022-02-23 | Lake | Colorado | 8065 | 1770 | 2 |
2242769 | 2242769 | 2022-02-23 | Larimer | Colorado | 8069 | 73297 | 459 |
2242770 | 2242770 | 2022-02-23 | Las Animas | Colorado | 8071 | 3402 | 39 |
2242771 | 2242771 | 2022-02-23 | Lincoln | Colorado | 8073 | 2025 | 9 |
2242772 | 2242772 | 2022-02-23 | Logan | Colorado | 8075 | 7016 | 106 |
2242773 | 2242773 | 2022-02-23 | Mesa | Colorado | 8077 | 40976 | 524 |
2242774 | 2242774 | 2022-02-23 | Mineral | Colorado | 8079 | 219 | 1 |
2242775 | 2242775 | 2022-02-23 | Moffat | Colorado | 8081 | 2910 | 51 |
2242776 | 2242776 | 2022-02-23 | Montezuma | Colorado | 8083 | 5932 | 67 |
2242777 | 2242777 | 2022-02-23 | Montrose | Colorado | 8085 | 9008 | 156 |
2242778 | 2242778 | 2022-02-23 | Morgan | Colorado | 8087 | 5459 | 132 |
2242779 | 2242779 | 2022-02-23 | Otero | Colorado | 8089 | 4171 | 125 |
2242780 | 2242780 | 2022-02-23 | Ouray | Colorado | 8091 | 835 | 6 |
2242781 | 2242781 | 2022-02-23 | Park | Colorado | 8093 | 2725 | 20 |
2242782 | 2242782 | 2022-02-23 | Phillips | Colorado | 8095 | 858 | 17 |
2242783 | 2242783 | 2022-02-23 | Pitkin | Colorado | 8097 | 6179 | 6 |
2242784 | 2242784 | 2022-02-23 | Prowers | Colorado | 8099 | 2560 | 47 |
2242785 | 2242785 | 2022-02-23 | Pueblo | Colorado | 8101 | 43801 | 762 |
2242786 | 2242786 | 2022-02-23 | Rio Blanco | Colorado | 8103 | 1631 | 13 |
2242787 | 2242787 | 2022-02-23 | Rio Grande | Colorado | 8105 | 2702 | 44 |
2242788 | 2242788 | 2022-02-23 | Routt | Colorado | 8107 | 6128 | 24 |
2242789 | 2242789 | 2022-02-23 | Saguache | Colorado | 8109 | 1132 | 12 |
2242790 | 2242790 | 2022-02-23 | San Juan | Colorado | 8111 | 197 | 0 |
2242791 | 2242791 | 2022-02-23 | San Miguel | Colorado | 8113 | 2214 | 7 |
2242792 | 2242792 | 2022-02-23 | Sedgwick | Colorado | 8115 | 469 | 8 |
2242793 | 2242793 | 2022-02-23 | Summit | Colorado | 8117 | 9497 | 14 |
2242794 | 2242794 | 2022-02-23 | Teller | Colorado | 8119 | 4655 | 55 |
2242795 | 2242795 | 2022-02-23 | Washington | Colorado | 8121 | 1026 | 26 |
2242796 | 2242796 | 2022-02-23 | Weld | Colorado | 8123 | 80308 | 671 |
2242797 | 2242797 | 2022-02-23 | Yuma | Colorado | 8125 | 1836 | 23 |
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);