ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64 rows where date = "2022-03-03" 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 |
---|---|---|---|---|---|---|---|
2268744 | 2268744 | 2022-03-03 | Adams | Colorado | 8001 | 131051 | 1305 |
2268745 | 2268745 | 2022-03-03 | Alamosa | Colorado | 8003 | 4407 | 60 |
2268746 | 2268746 | 2022-03-03 | Arapahoe | Colorado | 8005 | 149520 | 1232 |
2268747 | 2268747 | 2022-03-03 | Archuleta | Colorado | 8007 | 2820 | 14 |
2268748 | 2268748 | 2022-03-03 | Baca | Colorado | 8009 | 816 | 8 |
2268749 | 2268749 | 2022-03-03 | Bent | Colorado | 8011 | 2475 | 47 |
2268750 | 2268750 | 2022-03-03 | Boulder | Colorado | 8013 | 61390 | 382 |
2268751 | 2268751 | 2022-03-03 | Broomfield | Colorado | 8014 | 12935 | 111 |
2268752 | 2268752 | 2022-03-03 | Chaffee | Colorado | 8015 | 4305 | 42 |
2268753 | 2268753 | 2022-03-03 | Cheyenne | Colorado | 8017 | 318 | 9 |
2268754 | 2268754 | 2022-03-03 | Clear Creek | Colorado | 8019 | 1496 | 11 |
2268755 | 2268755 | 2022-03-03 | Conejos | Colorado | 8021 | 1694 | 52 |
2268756 | 2268756 | 2022-03-03 | Costilla | Colorado | 8023 | 656 | 15 |
2268757 | 2268757 | 2022-03-03 | Crowley | Colorado | 8025 | 3125 | 28 |
2268758 | 2268758 | 2022-03-03 | Custer | Colorado | 8027 | 628 | 18 |
2268759 | 2268759 | 2022-03-03 | Delta | Colorado | 8029 | 5900 | 130 |
2268760 | 2268760 | 2022-03-03 | Denver | Colorado | 8031 | 164817 | 1273 |
2268761 | 2268761 | 2022-03-03 | Dolores | Colorado | 8033 | 348 | 8 |
2268762 | 2268762 | 2022-03-03 | Douglas | Colorado | 8035 | 76495 | 428 |
2268763 | 2268763 | 2022-03-03 | Eagle | Colorado | 8037 | 15635 | 35 |
2268764 | 2268764 | 2022-03-03 | El Paso | Colorado | 8041 | 179169 | 1589 |
2268765 | 2268765 | 2022-03-03 | Elbert | Colorado | 8039 | 4658 | 37 |
2268766 | 2268766 | 2022-03-03 | Fremont | Colorado | 8043 | 14573 | 177 |
2268767 | 2268767 | 2022-03-03 | Garfield | Colorado | 8045 | 14200 | 88 |
2268768 | 2268768 | 2022-03-03 | Gilpin | Colorado | 8047 | 925 | 4 |
2268769 | 2268769 | 2022-03-03 | Grand | Colorado | 8049 | 3416 | 23 |
2268770 | 2268770 | 2022-03-03 | Gunnison | Colorado | 8051 | 3272 | 14 |
2268771 | 2268771 | 2022-03-03 | Hinsdale | Colorado | 8053 | 121 | 0 |
2268772 | 2268772 | 2022-03-03 | Huerfano | Colorado | 8055 | 1404 | 31 |
2268773 | 2268773 | 2022-03-03 | Jackson | Colorado | 8057 | 164 | 0 |
2268774 | 2268774 | 2022-03-03 | Jefferson | Colorado | 8059 | 118346 | 1303 |
2268775 | 2268775 | 2022-03-03 | Kiowa | Colorado | 8061 | 328 | 6 |
2268776 | 2268776 | 2022-03-03 | Kit Carson | Colorado | 8063 | 1571 | 30 |
2268777 | 2268777 | 2022-03-03 | La Plata | Colorado | 8067 | 12387 | 80 |
2268778 | 2268778 | 2022-03-03 | Lake | Colorado | 8065 | 1772 | 2 |
2268779 | 2268779 | 2022-03-03 | Larimer | Colorado | 8069 | 74011 | 459 |
2268780 | 2268780 | 2022-03-03 | Las Animas | Colorado | 8071 | 3424 | 39 |
2268781 | 2268781 | 2022-03-03 | Lincoln | Colorado | 8073 | 2045 | 9 |
2268782 | 2268782 | 2022-03-03 | Logan | Colorado | 8075 | 7100 | 106 |
2268783 | 2268783 | 2022-03-03 | Mesa | Colorado | 8077 | 41379 | 527 |
2268784 | 2268784 | 2022-03-03 | Mineral | Colorado | 8079 | 219 | 1 |
2268785 | 2268785 | 2022-03-03 | Moffat | Colorado | 8081 | 2934 | 51 |
2268786 | 2268786 | 2022-03-03 | Montezuma | Colorado | 8083 | 5963 | 67 |
2268787 | 2268787 | 2022-03-03 | Montrose | Colorado | 8085 | 9068 | 158 |
2268788 | 2268788 | 2022-03-03 | Morgan | Colorado | 8087 | 5470 | 134 |
2268789 | 2268789 | 2022-03-03 | Otero | Colorado | 8089 | 4193 | 125 |
2268790 | 2268790 | 2022-03-03 | Ouray | Colorado | 8091 | 837 | 6 |
2268791 | 2268791 | 2022-03-03 | Park | Colorado | 8093 | 2739 | 20 |
2268792 | 2268792 | 2022-03-03 | Phillips | Colorado | 8095 | 861 | 18 |
2268793 | 2268793 | 2022-03-03 | Pitkin | Colorado | 8097 | 6220 | 6 |
2268794 | 2268794 | 2022-03-03 | Prowers | Colorado | 8099 | 2575 | 48 |
2268795 | 2268795 | 2022-03-03 | Pueblo | Colorado | 8101 | 44155 | 769 |
2268796 | 2268796 | 2022-03-03 | Rio Blanco | Colorado | 8103 | 1647 | 13 |
2268797 | 2268797 | 2022-03-03 | Rio Grande | Colorado | 8105 | 2730 | 46 |
2268798 | 2268798 | 2022-03-03 | Routt | Colorado | 8107 | 6184 | 24 |
2268799 | 2268799 | 2022-03-03 | Saguache | Colorado | 8109 | 1144 | 12 |
2268800 | 2268800 | 2022-03-03 | San Juan | Colorado | 8111 | 184 | 0 |
2268801 | 2268801 | 2022-03-03 | San Miguel | Colorado | 8113 | 2220 | 8 |
2268802 | 2268802 | 2022-03-03 | Sedgwick | Colorado | 8115 | 471 | 8 |
2268803 | 2268803 | 2022-03-03 | Summit | Colorado | 8117 | 9558 | 14 |
2268804 | 2268804 | 2022-03-03 | Teller | Colorado | 8119 | 4682 | 56 |
2268805 | 2268805 | 2022-03-03 | Washington | Colorado | 8121 | 1033 | 26 |
2268806 | 2268806 | 2022-03-03 | Weld | Colorado | 8123 | 80824 | 682 |
2268807 | 2268807 | 2022-03-03 | Yuma | Colorado | 8125 | 1844 | 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);