ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64 rows where date = "2021-03-11" 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 |
---|---|---|---|---|---|---|---|
1108929 | 1108929 | 2021-03-11 | Adams | Colorado | 8001 | 50389 | 636 |
1108930 | 1108930 | 2021-03-11 | Alamosa | Colorado | 8003 | 1320 | 29 |
1108931 | 1108931 | 2021-03-11 | Arapahoe | Colorado | 8005 | 50614 | 702 |
1108932 | 1108932 | 2021-03-11 | Archuleta | Colorado | 8007 | 694 | 1 |
1108933 | 1108933 | 2021-03-11 | Baca | Colorado | 8009 | 274 | 4 |
1108934 | 1108934 | 2021-03-11 | Bent | Colorado | 8011 | 1483 | 21 |
1108935 | 1108935 | 2021-03-11 | Boulder | Colorado | 8013 | 19445 | 248 |
1108936 | 1108936 | 2021-03-11 | Broomfield | Colorado | 8014 | 3921 | 74 |
1108937 | 1108937 | 2021-03-11 | Chaffee | Colorado | 8015 | 1473 | 24 |
1108938 | 1108938 | 2021-03-11 | Cheyenne | Colorado | 8017 | 125 | 5 |
1108939 | 1108939 | 2021-03-11 | Clear Creek | Colorado | 8019 | 374 | 2 |
1108940 | 1108940 | 2021-03-11 | Conejos | Colorado | 8021 | 449 | 9 |
1108941 | 1108941 | 2021-03-11 | Costilla | Colorado | 8023 | 195 | 2 |
1108942 | 1108942 | 2021-03-11 | Crowley | Colorado | 8025 | 2073 | 14 |
1108943 | 1108943 | 2021-03-11 | Custer | Colorado | 8027 | 164 | 1 |
1108944 | 1108944 | 2021-03-11 | Delta | Colorado | 8029 | 2493 | 60 |
1108945 | 1108945 | 2021-03-11 | Denver | Colorado | 8031 | 61275 | 771 |
1108946 | 1108946 | 2021-03-11 | Dolores | Colorado | 8033 | 69 | 0 |
1108947 | 1108947 | 2021-03-11 | Douglas | Colorado | 8035 | 22713 | 233 |
1108948 | 1108948 | 2021-03-11 | Eagle | Colorado | 8037 | 5323 | 22 |
1108949 | 1108949 | 2021-03-11 | El Paso | Colorado | 8041 | 53484 | 753 |
1108950 | 1108950 | 2021-03-11 | Elbert | Colorado | 8039 | 1318 | 12 |
1108951 | 1108951 | 2021-03-11 | Fremont | Colorado | 8043 | 5534 | 52 |
1108952 | 1108952 | 2021-03-11 | Garfield | Colorado | 8045 | 5169 | 38 |
1108953 | 1108953 | 2021-03-11 | Gilpin | Colorado | 8047 | 174 | 3 |
1108954 | 1108954 | 2021-03-11 | Grand | Colorado | 8049 | 1296 | 6 |
1108955 | 1108955 | 2021-03-11 | Gunnison | Colorado | 8051 | 1218 | 6 |
1108956 | 1108956 | 2021-03-11 | Hinsdale | Colorado | 8053 | 16 | 0 |
1108957 | 1108957 | 2021-03-11 | Huerfano | Colorado | 8055 | 319 | 16 |
1108958 | 1108958 | 2021-03-11 | Jackson | Colorado | 8057 | 52 | 0 |
1108959 | 1108959 | 2021-03-11 | Jefferson | Colorado | 8059 | 38359 | 730 |
1108960 | 1108960 | 2021-03-11 | Kiowa | Colorado | 8061 | 91 | 3 |
1108961 | 1108961 | 2021-03-11 | Kit Carson | Colorado | 8063 | 551 | 10 |
1108962 | 1108962 | 2021-03-11 | La Plata | Colorado | 8067 | 3103 | 37 |
1108963 | 1108963 | 2021-03-11 | Lake | Colorado | 8065 | 670 | 0 |
1108964 | 1108964 | 2021-03-11 | Larimer | Colorado | 8069 | 20798 | 227 |
1108965 | 1108965 | 2021-03-11 | Las Animas | Colorado | 8071 | 1013 | 11 |
1108966 | 1108966 | 2021-03-11 | Lincoln | Colorado | 8073 | 1000 | 3 |
1108967 | 1108967 | 2021-03-11 | Logan | Colorado | 8075 | 3768 | 65 |
1108968 | 1108968 | 2021-03-11 | Mesa | Colorado | 8077 | 13520 | 204 |
1108969 | 1108969 | 2021-03-11 | Mineral | Colorado | 8079 | 73 | 1 |
1108970 | 1108970 | 2021-03-11 | Moffat | Colorado | 8081 | 686 | 22 |
1108971 | 1108971 | 2021-03-11 | Montezuma | Colorado | 8083 | 1745 | 22 |
1108972 | 1108972 | 2021-03-11 | Montrose | Colorado | 8085 | 3279 | 54 |
1108973 | 1108973 | 2021-03-11 | Morgan | Colorado | 8087 | 2466 | 90 |
1108974 | 1108974 | 2021-03-11 | Otero | Colorado | 8089 | 1870 | 63 |
1108975 | 1108975 | 2021-03-11 | Ouray | Colorado | 8091 | 263 | 3 |
1108976 | 1108976 | 2021-03-11 | Park | Colorado | 8093 | 571 | 5 |
1108977 | 1108977 | 2021-03-11 | Phillips | Colorado | 8095 | 344 | 13 |
1108978 | 1108978 | 2021-03-11 | Pitkin | Colorado | 8097 | 2123 | 4 |
1108979 | 1108979 | 2021-03-11 | Prowers | Colorado | 8099 | 1162 | 21 |
1108980 | 1108980 | 2021-03-11 | Pueblo | Colorado | 8101 | 15279 | 366 |
1108981 | 1108981 | 2021-03-11 | Rio Blanco | Colorado | 8103 | 491 | 3 |
1108982 | 1108982 | 2021-03-11 | Rio Grande | Colorado | 8105 | 730 | 13 |
1108983 | 1108983 | 2021-03-11 | Routt | Colorado | 8107 | 1961 | 19 |
1108984 | 1108984 | 2021-03-11 | Saguache | Colorado | 8109 | 327 | 4 |
1108985 | 1108985 | 2021-03-11 | San Juan | Colorado | 8111 | 42 | 0 |
1108986 | 1108986 | 2021-03-11 | San Miguel | Colorado | 8113 | 833 | 0 |
1108987 | 1108987 | 2021-03-11 | Sedgwick | Colorado | 8115 | 194 | 2 |
1108988 | 1108988 | 2021-03-11 | Summit | Colorado | 8117 | 3111 | 7 |
1108989 | 1108989 | 2021-03-11 | Teller | Colorado | 8119 | 1314 | 14 |
1108990 | 1108990 | 2021-03-11 | Washington | Colorado | 8121 | 406 | 12 |
1108991 | 1108991 | 2021-03-11 | Weld | Colorado | 8123 | 26260 | 319 |
1108992 | 1108992 | 2021-03-11 | Yuma | Colorado | 8125 | 750 | 17 |
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);