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-01-09 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
910947 | 910947 | 2021-01-09 | Adams | Colorado | 8001 | 43090 | 556 |
910948 | 910948 | 2021-01-09 | Alamosa | Colorado | 8003 | 1001 | 25 |
910949 | 910949 | 2021-01-09 | Arapahoe | Colorado | 8005 | 41493 | 625 |
910950 | 910950 | 2021-01-09 | Archuleta | Colorado | 8007 | 536 | 0 |
910951 | 910951 | 2021-01-09 | Baca | Colorado | 8009 | 206 | 1 |
910952 | 910952 | 2021-01-09 | Bent | Colorado | 8011 | 1224 | 17 |
910953 | 910953 | 2021-01-09 | Boulder | Colorado | 8013 | 15762 | 198 |
910954 | 910954 | 2021-01-09 | Broomfield | Colorado | 8014 | 3010 | 68 |
910955 | 910955 | 2021-01-09 | Chaffee | Colorado | 8015 | 1165 | 21 |
910956 | 910956 | 2021-01-09 | Cheyenne | Colorado | 8017 | 105 | 5 |
910957 | 910957 | 2021-01-09 | Clear Creek | Colorado | 8019 | 312 | 2 |
910958 | 910958 | 2021-01-09 | Conejos | Colorado | 8021 | 339 | 3 |
910959 | 910959 | 2021-01-09 | Costilla | Colorado | 8023 | 170 | 2 |
910960 | 910960 | 2021-01-09 | Crowley | Colorado | 8025 | 1684 | 14 |
910961 | 910961 | 2021-01-09 | Custer | Colorado | 8027 | 154 | 0 |
910962 | 910962 | 2021-01-09 | Delta | Colorado | 8029 | 1886 | 32 |
910963 | 910963 | 2021-01-09 | Denver | Colorado | 8031 | 51355 | 706 |
910964 | 910964 | 2021-01-09 | Dolores | Colorado | 8033 | 54 | 0 |
910965 | 910965 | 2021-01-09 | Douglas | Colorado | 8035 | 17264 | 211 |
910966 | 910966 | 2021-01-09 | Eagle | Colorado | 8037 | 3665 | 16 |
910967 | 910967 | 2021-01-09 | El Paso | Colorado | 8041 | 44086 | 627 |
910968 | 910968 | 2021-01-09 | Elbert | Colorado | 8039 | 1055 | 11 |
910969 | 910969 | 2021-01-09 | Fremont | Colorado | 8043 | 4887 | 25 |
910970 | 910970 | 2021-01-09 | Garfield | Colorado | 8045 | 4270 | 34 |
910971 | 910971 | 2021-01-09 | Gilpin | Colorado | 8047 | 133 | 2 |
910972 | 910972 | 2021-01-09 | Grand | Colorado | 8049 | 748 | 4 |
910973 | 910973 | 2021-01-09 | Gunnison | Colorado | 8051 | 771 | 6 |
910974 | 910974 | 2021-01-09 | Hinsdale | Colorado | 8053 | 15 | 0 |
910975 | 910975 | 2021-01-09 | Huerfano | Colorado | 8055 | 283 | 17 |
910976 | 910976 | 2021-01-09 | Jackson | Colorado | 8057 | 42 | 0 |
910977 | 910977 | 2021-01-09 | Jefferson | Colorado | 8059 | 31516 | 646 |
910978 | 910978 | 2021-01-09 | Kiowa | Colorado | 8061 | 77 | 2 |
910979 | 910979 | 2021-01-09 | Kit Carson | Colorado | 8063 | 456 | 10 |
910980 | 910980 | 2021-01-09 | La Plata | Colorado | 8067 | 2418 | 29 |
910981 | 910981 | 2021-01-09 | Lake | Colorado | 8065 | 461 | 0 |
910982 | 910982 | 2021-01-09 | Larimer | Colorado | 8069 | 16146 | 167 |
910983 | 910983 | 2021-01-09 | Las Animas | Colorado | 8071 | 811 | 7 |
910984 | 910984 | 2021-01-09 | Lincoln | Colorado | 8073 | 800 | 3 |
910985 | 910985 | 2021-01-09 | Logan | Colorado | 8075 | 3379 | 55 |
910986 | 910986 | 2021-01-09 | Mesa | Colorado | 8077 | 10052 | 152 |
910987 | 910987 | 2021-01-09 | Mineral | Colorado | 8079 | 48 | 1 |
910988 | 910988 | 2021-01-09 | Moffat | Colorado | 8081 | 565 | 21 |
910989 | 910989 | 2021-01-09 | Montezuma | Colorado | 8083 | 1374 | 19 |
910990 | 910990 | 2021-01-09 | Montrose | Colorado | 8085 | 2383 | 36 |
910991 | 910991 | 2021-01-09 | Morgan | Colorado | 8087 | 2237 | 84 |
910992 | 910992 | 2021-01-09 | Otero | Colorado | 8089 | 1710 | 54 |
910993 | 910993 | 2021-01-09 | Ouray | Colorado | 8091 | 166 | 3 |
910994 | 910994 | 2021-01-09 | Park | Colorado | 8093 | 428 | 5 |
910995 | 910995 | 2021-01-09 | Phillips | Colorado | 8095 | 299 | 8 |
910996 | 910996 | 2021-01-09 | Pitkin | Colorado | 8097 | 1395 | 4 |
910997 | 910997 | 2021-01-09 | Prowers | Colorado | 8099 | 1051 | 20 |
910998 | 910998 | 2021-01-09 | Pueblo | Colorado | 8101 | 13763 | 335 |
910999 | 910999 | 2021-01-09 | Rio Blanco | Colorado | 8103 | 288 | 3 |
911000 | 911000 | 2021-01-09 | Rio Grande | Colorado | 8105 | 498 | 8 |
911001 | 911001 | 2021-01-09 | Routt | Colorado | 8107 | 1159 | 18 |
911002 | 911002 | 2021-01-09 | Saguache | Colorado | 8109 | 270 | 4 |
911003 | 911003 | 2021-01-09 | San Juan | Colorado | 8111 | 31 | 0 |
911004 | 911004 | 2021-01-09 | San Miguel | Colorado | 8113 | 417 | 0 |
911005 | 911005 | 2021-01-09 | Sedgwick | Colorado | 8115 | 160 | 2 |
911006 | 911006 | 2021-01-09 | Summit | Colorado | 8117 | 2265 | 5 |
911007 | 911007 | 2021-01-09 | Teller | Colorado | 8119 | 1058 | 10 |
911008 | 911008 | 2021-01-09 | Washington | Colorado | 8121 | 351 | 11 |
911009 | 911009 | 2021-01-09 | Weld | Colorado | 8123 | 21471 | 298 |
911010 | 911010 | 2021-01-09 | Yuma | Colorado | 8125 | 589 | 14 |
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);