ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64 rows where date = "2021-08-16" 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 |
---|---|---|---|---|---|---|---|
1621937 | 1621937 | 2021-08-16 | Adams | Colorado | 8001 | 65139 | 777 |
1621938 | 1621938 | 2021-08-16 | Alamosa | Colorado | 8003 | 1854 | 39 |
1621939 | 1621939 | 2021-08-16 | Arapahoe | Colorado | 8005 | 67613 | 847 |
1621940 | 1621940 | 2021-08-16 | Archuleta | Colorado | 8007 | 1202 | 2 |
1621941 | 1621941 | 2021-08-16 | Baca | Colorado | 8009 | 341 | 4 |
1621942 | 1621942 | 2021-08-16 | Bent | Colorado | 8011 | 1554 | 22 |
1621943 | 1621943 | 2021-08-16 | Boulder | Colorado | 8013 | 25563 | 263 |
1621944 | 1621944 | 2021-08-16 | Broomfield | Colorado | 8014 | 5385 | 77 |
1621945 | 1621945 | 2021-08-16 | Chaffee | Colorado | 8015 | 1879 | 25 |
1621946 | 1621946 | 2021-08-16 | Cheyenne | Colorado | 8017 | 142 | 7 |
1621947 | 1621947 | 2021-08-16 | Clear Creek | Colorado | 8019 | 530 | 3 |
1621948 | 1621948 | 2021-08-16 | Conejos | Colorado | 8021 | 775 | 27 |
1621949 | 1621949 | 2021-08-16 | Costilla | Colorado | 8023 | 263 | 5 |
1621950 | 1621950 | 2021-08-16 | Crowley | Colorado | 8025 | 2223 | 18 |
1621951 | 1621951 | 2021-08-16 | Custer | Colorado | 8027 | 243 | 5 |
1621952 | 1621952 | 2021-08-16 | Delta | Colorado | 8029 | 3175 | 75 |
1621953 | 1621953 | 2021-08-16 | Denver | Colorado | 8031 | 78203 | 859 |
1621954 | 1621954 | 2021-08-16 | Dolores | Colorado | 8033 | 136 | 1 |
1621955 | 1621955 | 2021-08-16 | Douglas | Colorado | 8035 | 33081 | 276 |
1621956 | 1621956 | 2021-08-16 | Eagle | Colorado | 8037 | 6816 | 26 |
1621957 | 1621957 | 2021-08-16 | El Paso | Colorado | 8041 | 79060 | 926 |
1621958 | 1621958 | 2021-08-16 | Elbert | Colorado | 8039 | 1999 | 15 |
1621959 | 1621959 | 2021-08-16 | Fremont | Colorado | 8043 | 6739 | 66 |
1621960 | 1621960 | 2021-08-16 | Garfield | Colorado | 8045 | 6606 | 56 |
1621961 | 1621961 | 2021-08-16 | Gilpin | Colorado | 8047 | 305 | 3 |
1621962 | 1621962 | 2021-08-16 | Grand | Colorado | 8049 | 1575 | 7 |
1621963 | 1621963 | 2021-08-16 | Gunnison | Colorado | 8051 | 1469 | 7 |
1621964 | 1621964 | 2021-08-16 | Hinsdale | Colorado | 8053 | 38 | 0 |
1621965 | 1621965 | 2021-08-16 | Huerfano | Colorado | 8055 | 471 | 18 |
1621966 | 1621966 | 2021-08-16 | Jackson | Colorado | 8057 | 69 | 0 |
1621967 | 1621967 | 2021-08-16 | Jefferson | Colorado | 8059 | 51698 | 818 |
1621968 | 1621968 | 2021-08-16 | Kiowa | Colorado | 8061 | 99 | 3 |
1621969 | 1621969 | 2021-08-16 | Kit Carson | Colorado | 8063 | 689 | 13 |
1621970 | 1621970 | 2021-08-16 | La Plata | Colorado | 8067 | 4504 | 45 |
1621971 | 1621971 | 2021-08-16 | Lake | Colorado | 8065 | 874 | 1 |
1621972 | 1621972 | 2021-08-16 | Larimer | Colorado | 8069 | 29926 | 250 |
1621973 | 1621973 | 2021-08-16 | Las Animas | Colorado | 8071 | 1348 | 14 |
1621974 | 1621974 | 2021-08-16 | Lincoln | Colorado | 8073 | 1055 | 4 |
1621975 | 1621975 | 2021-08-16 | Logan | Colorado | 8075 | 4105 | 69 |
1621976 | 1621976 | 2021-08-16 | Mesa | Colorado | 8077 | 18658 | 277 |
1621977 | 1621977 | 2021-08-16 | Mineral | Colorado | 8079 | 99 | 1 |
1621978 | 1621978 | 2021-08-16 | Moffat | Colorado | 8081 | 1249 | 29 |
1621979 | 1621979 | 2021-08-16 | Montezuma | Colorado | 8083 | 2238 | 28 |
1621980 | 1621980 | 2021-08-16 | Montrose | Colorado | 8085 | 4155 | 72 |
1621981 | 1621981 | 2021-08-16 | Morgan | Colorado | 8087 | 2813 | 96 |
1621982 | 1621982 | 2021-08-16 | Otero | Colorado | 8089 | 2117 | 68 |
1621983 | 1621983 | 2021-08-16 | Ouray | Colorado | 8091 | 329 | 5 |
1621984 | 1621984 | 2021-08-16 | Park | Colorado | 8093 | 945 | 5 |
1621985 | 1621985 | 2021-08-16 | Phillips | Colorado | 8095 | 410 | 13 |
1621986 | 1621986 | 2021-08-16 | Pitkin | Colorado | 8097 | 2743 | 4 |
1621987 | 1621987 | 2021-08-16 | Prowers | Colorado | 8099 | 1324 | 24 |
1621988 | 1621988 | 2021-08-16 | Pueblo | Colorado | 8101 | 20313 | 428 |
1621989 | 1621989 | 2021-08-16 | Rio Blanco | Colorado | 8103 | 718 | 5 |
1621990 | 1621990 | 2021-08-16 | Rio Grande | Colorado | 8105 | 985 | 20 |
1621991 | 1621991 | 2021-08-16 | Routt | Colorado | 8107 | 2531 | 21 |
1621992 | 1621992 | 2021-08-16 | Saguache | Colorado | 8109 | 483 | 8 |
1621993 | 1621993 | 2021-08-16 | San Juan | Colorado | 8111 | 76 | 0 |
1621994 | 1621994 | 2021-08-16 | San Miguel | Colorado | 8113 | 982 | 1 |
1621995 | 1621995 | 2021-08-16 | Sedgwick | Colorado | 8115 | 245 | 3 |
1621996 | 1621996 | 2021-08-16 | Summit | Colorado | 8117 | 4146 | 8 |
1621997 | 1621997 | 2021-08-16 | Teller | Colorado | 8119 | 2025 | 19 |
1621998 | 1621998 | 2021-08-16 | Washington | Colorado | 8121 | 481 | 13 |
1621999 | 1621999 | 2021-08-16 | Weld | Colorado | 8123 | 35653 | 359 |
1622000 | 1622000 | 2021-08-16 | Yuma | Colorado | 8125 | 991 | 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);