ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64 rows where "date" is on date 2021-08-24 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1647925 | 1647925 | 2021-08-24 | Adams | Colorado | 8001 | 66377 | 783 |
1647926 | 1647926 | 2021-08-24 | Alamosa | Colorado | 8003 | 1870 | 39 |
1647927 | 1647927 | 2021-08-24 | Arapahoe | Colorado | 8005 | 68888 | 849 |
1647928 | 1647928 | 2021-08-24 | Archuleta | Colorado | 8007 | 1233 | 2 |
1647929 | 1647929 | 2021-08-24 | Baca | Colorado | 8009 | 352 | 4 |
1647930 | 1647930 | 2021-08-24 | Bent | Colorado | 8011 | 1556 | 22 |
1647931 | 1647931 | 2021-08-24 | Boulder | Colorado | 8013 | 26032 | 264 |
1647932 | 1647932 | 2021-08-24 | Broomfield | Colorado | 8014 | 5515 | 77 |
1647933 | 1647933 | 2021-08-24 | Chaffee | Colorado | 8015 | 1919 | 25 |
1647934 | 1647934 | 2021-08-24 | Cheyenne | Colorado | 8017 | 145 | 7 |
1647935 | 1647935 | 2021-08-24 | Clear Creek | Colorado | 8019 | 550 | 3 |
1647936 | 1647936 | 2021-08-24 | Conejos | Colorado | 8021 | 780 | 27 |
1647937 | 1647937 | 2021-08-24 | Costilla | Colorado | 8023 | 265 | 5 |
1647938 | 1647938 | 2021-08-24 | Crowley | Colorado | 8025 | 2224 | 18 |
1647939 | 1647939 | 2021-08-24 | Custer | Colorado | 8027 | 252 | 6 |
1647940 | 1647940 | 2021-08-24 | Delta | Colorado | 8029 | 3219 | 77 |
1647941 | 1647941 | 2021-08-24 | Denver | Colorado | 8031 | 79592 | 866 |
1647942 | 1647942 | 2021-08-24 | Dolores | Colorado | 8033 | 145 | 1 |
1647943 | 1647943 | 2021-08-24 | Douglas | Colorado | 8035 | 33854 | 276 |
1647944 | 1647944 | 2021-08-24 | Eagle | Colorado | 8037 | 7030 | 26 |
1647945 | 1647945 | 2021-08-24 | El Paso | Colorado | 8041 | 80680 | 932 |
1647946 | 1647946 | 2021-08-24 | Elbert | Colorado | 8039 | 2038 | 16 |
1647947 | 1647947 | 2021-08-24 | Fremont | Colorado | 8043 | 6798 | 68 |
1647948 | 1647948 | 2021-08-24 | Garfield | Colorado | 8045 | 6668 | 56 |
1647949 | 1647949 | 2021-08-24 | Gilpin | Colorado | 8047 | 316 | 3 |
1647950 | 1647950 | 2021-08-24 | Grand | Colorado | 8049 | 1621 | 7 |
1647951 | 1647951 | 2021-08-24 | Gunnison | Colorado | 8051 | 1511 | 7 |
1647952 | 1647952 | 2021-08-24 | Hinsdale | Colorado | 8053 | 43 | 0 |
1647953 | 1647953 | 2021-08-24 | Huerfano | Colorado | 8055 | 480 | 18 |
1647954 | 1647954 | 2021-08-24 | Jackson | Colorado | 8057 | 69 | 0 |
1647955 | 1647955 | 2021-08-24 | Jefferson | Colorado | 8059 | 52725 | 828 |
1647956 | 1647956 | 2021-08-24 | Kiowa | Colorado | 8061 | 108 | 3 |
1647957 | 1647957 | 2021-08-24 | Kit Carson | Colorado | 8063 | 713 | 14 |
1647958 | 1647958 | 2021-08-24 | La Plata | Colorado | 8067 | 4635 | 45 |
1647959 | 1647959 | 2021-08-24 | Lake | Colorado | 8065 | 897 | 1 |
1647960 | 1647960 | 2021-08-24 | Larimer | Colorado | 8069 | 30814 | 252 |
1647961 | 1647961 | 2021-08-24 | Las Animas | Colorado | 8071 | 1413 | 15 |
1647962 | 1647962 | 2021-08-24 | Lincoln | Colorado | 8073 | 1079 | 4 |
1647963 | 1647963 | 2021-08-24 | Logan | Colorado | 8075 | 4145 | 69 |
1647964 | 1647964 | 2021-08-24 | Mesa | Colorado | 8077 | 19001 | 278 |
1647965 | 1647965 | 2021-08-24 | Mineral | Colorado | 8079 | 100 | 1 |
1647966 | 1647966 | 2021-08-24 | Moffat | Colorado | 8081 | 1268 | 30 |
1647967 | 1647967 | 2021-08-24 | Montezuma | Colorado | 8083 | 2312 | 28 |
1647968 | 1647968 | 2021-08-24 | Montrose | Colorado | 8085 | 4227 | 72 |
1647969 | 1647969 | 2021-08-24 | Morgan | Colorado | 8087 | 2855 | 96 |
1647970 | 1647970 | 2021-08-24 | Otero | Colorado | 8089 | 2132 | 68 |
1647971 | 1647971 | 2021-08-24 | Ouray | Colorado | 8091 | 343 | 5 |
1647972 | 1647972 | 2021-08-24 | Park | Colorado | 8093 | 971 | 6 |
1647973 | 1647973 | 2021-08-24 | Phillips | Colorado | 8095 | 416 | 13 |
1647974 | 1647974 | 2021-08-24 | Pitkin | Colorado | 8097 | 2786 | 5 |
1647975 | 1647975 | 2021-08-24 | Prowers | Colorado | 8099 | 1339 | 24 |
1647976 | 1647976 | 2021-08-24 | Pueblo | Colorado | 8101 | 20574 | 432 |
1647977 | 1647977 | 2021-08-24 | Rio Blanco | Colorado | 8103 | 731 | 5 |
1647978 | 1647978 | 2021-08-24 | Rio Grande | Colorado | 8105 | 1009 | 20 |
1647979 | 1647979 | 2021-08-24 | Routt | Colorado | 8107 | 2605 | 21 |
1647980 | 1647980 | 2021-08-24 | Saguache | Colorado | 8109 | 489 | 8 |
1647981 | 1647981 | 2021-08-24 | San Juan | Colorado | 8111 | 85 | 0 |
1647982 | 1647982 | 2021-08-24 | San Miguel | Colorado | 8113 | 994 | 1 |
1647983 | 1647983 | 2021-08-24 | Sedgwick | Colorado | 8115 | 258 | 3 |
1647984 | 1647984 | 2021-08-24 | Summit | Colorado | 8117 | 4231 | 8 |
1647985 | 1647985 | 2021-08-24 | Teller | Colorado | 8119 | 2059 | 19 |
1647986 | 1647986 | 2021-08-24 | Washington | Colorado | 8121 | 483 | 13 |
1647987 | 1647987 | 2021-08-24 | Weld | Colorado | 8123 | 36684 | 360 |
1647988 | 1647988 | 2021-08-24 | Yuma | Colorado | 8125 | 999 | 18 |
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);