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-09-25 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1751879 | 1751879 | 2021-09-25 | Adams | Colorado | 8001 | 71307 | 835 |
1751880 | 1751880 | 2021-09-25 | Alamosa | Colorado | 8003 | 2077 | 42 |
1751881 | 1751881 | 2021-09-25 | Arapahoe | Colorado | 8005 | 74487 | 878 |
1751882 | 1751882 | 2021-09-25 | Archuleta | Colorado | 8007 | 1347 | 3 |
1751883 | 1751883 | 2021-09-25 | Baca | Colorado | 8009 | 387 | 5 |
1751884 | 1751884 | 2021-09-25 | Bent | Colorado | 8011 | 1602 | 23 |
1751885 | 1751885 | 2021-09-25 | Boulder | Colorado | 8013 | 28359 | 269 |
1751886 | 1751886 | 2021-09-25 | Broomfield | Colorado | 8014 | 6076 | 78 |
1751887 | 1751887 | 2021-09-25 | Chaffee | Colorado | 8015 | 2056 | 28 |
1751888 | 1751888 | 2021-09-25 | Cheyenne | Colorado | 8017 | 155 | 7 |
1751889 | 1751889 | 2021-09-25 | Clear Creek | Colorado | 8019 | 686 | 4 |
1751890 | 1751890 | 2021-09-25 | Conejos | Colorado | 8021 | 848 | 29 |
1751891 | 1751891 | 2021-09-25 | Costilla | Colorado | 8023 | 326 | 6 |
1751892 | 1751892 | 2021-09-25 | Crowley | Colorado | 8025 | 2282 | 18 |
1751893 | 1751893 | 2021-09-25 | Custer | Colorado | 8027 | 295 | 6 |
1751894 | 1751894 | 2021-09-25 | Delta | Colorado | 8029 | 3413 | 79 |
1751895 | 1751895 | 2021-09-25 | Denver | Colorado | 8031 | 84843 | 899 |
1751896 | 1751896 | 2021-09-25 | Dolores | Colorado | 8033 | 175 | 1 |
1751897 | 1751897 | 2021-09-25 | Douglas | Colorado | 8035 | 37396 | 285 |
1751898 | 1751898 | 2021-09-25 | Eagle | Colorado | 8037 | 7825 | 31 |
1751899 | 1751899 | 2021-09-25 | El Paso | Colorado | 8041 | 89984 | 991 |
1751900 | 1751900 | 2021-09-25 | Elbert | Colorado | 8039 | 2357 | 19 |
1751901 | 1751901 | 2021-09-25 | Fremont | Colorado | 8043 | 7318 | 72 |
1751902 | 1751902 | 2021-09-25 | Garfield | Colorado | 8045 | 7155 | 59 |
1751903 | 1751903 | 2021-09-25 | Gilpin | Colorado | 8047 | 389 | 3 |
1751904 | 1751904 | 2021-09-25 | Grand | Colorado | 8049 | 1939 | 10 |
1751905 | 1751905 | 2021-09-25 | Gunnison | Colorado | 8051 | 1716 | 8 |
1751906 | 1751906 | 2021-09-25 | Hinsdale | Colorado | 8053 | 53 | 0 |
1751907 | 1751907 | 2021-09-25 | Huerfano | Colorado | 8055 | 548 | 17 |
1751908 | 1751908 | 2021-09-25 | Jackson | Colorado | 8057 | 84 | 0 |
1751909 | 1751909 | 2021-09-25 | Jefferson | Colorado | 8059 | 57362 | 866 |
1751910 | 1751910 | 2021-09-25 | Kiowa | Colorado | 8061 | 119 | 4 |
1751911 | 1751911 | 2021-09-25 | Kit Carson | Colorado | 8063 | 830 | 14 |
1751912 | 1751912 | 2021-09-25 | La Plata | Colorado | 8067 | 5165 | 50 |
1751913 | 1751913 | 2021-09-25 | Lake | Colorado | 8065 | 953 | 1 |
1751914 | 1751914 | 2021-09-25 | Larimer | Colorado | 8069 | 34582 | 277 |
1751915 | 1751915 | 2021-09-25 | Las Animas | Colorado | 8071 | 1618 | 20 |
1751916 | 1751916 | 2021-09-25 | Lincoln | Colorado | 8073 | 1194 | 6 |
1751917 | 1751917 | 2021-09-25 | Logan | Colorado | 8075 | 4366 | 73 |
1751918 | 1751918 | 2021-09-25 | Mesa | Colorado | 8077 | 21057 | 291 |
1751919 | 1751919 | 2021-09-25 | Mineral | Colorado | 8079 | 109 | 1 |
1751920 | 1751920 | 2021-09-25 | Moffat | Colorado | 8081 | 1618 | 32 |
1751921 | 1751921 | 2021-09-25 | Montezuma | Colorado | 8083 | 2567 | 33 |
1751922 | 1751922 | 2021-09-25 | Montrose | Colorado | 8085 | 4579 | 76 |
1751923 | 1751923 | 2021-09-25 | Morgan | Colorado | 8087 | 3097 | 98 |
1751924 | 1751924 | 2021-09-25 | Otero | Colorado | 8089 | 2310 | 72 |
1751925 | 1751925 | 2021-09-25 | Ouray | Colorado | 8091 | 377 | 5 |
1751926 | 1751926 | 2021-09-25 | Park | Colorado | 8093 | 1157 | 7 |
1751927 | 1751927 | 2021-09-25 | Phillips | Colorado | 8095 | 466 | 14 |
1751928 | 1751928 | 2021-09-25 | Pitkin | Colorado | 8097 | 2975 | 5 |
1751929 | 1751929 | 2021-09-25 | Prowers | Colorado | 8099 | 1466 | 25 |
1751930 | 1751930 | 2021-09-25 | Pueblo | Colorado | 8101 | 22255 | 453 |
1751931 | 1751931 | 2021-09-25 | Rio Blanco | Colorado | 8103 | 835 | 8 |
1751932 | 1751932 | 2021-09-25 | Rio Grande | Colorado | 8105 | 1160 | 20 |
1751933 | 1751933 | 2021-09-25 | Routt | Colorado | 8107 | 3031 | 22 |
1751934 | 1751934 | 2021-09-25 | Saguache | Colorado | 8109 | 554 | 8 |
1751935 | 1751935 | 2021-09-25 | San Juan | Colorado | 8111 | 87 | 1 |
1751936 | 1751936 | 2021-09-25 | San Miguel | Colorado | 8113 | 1110 | 3 |
1751937 | 1751937 | 2021-09-25 | Sedgwick | Colorado | 8115 | 274 | 4 |
1751938 | 1751938 | 2021-09-25 | Summit | Colorado | 8117 | 4487 | 10 |
1751939 | 1751939 | 2021-09-25 | Teller | Colorado | 8119 | 2357 | 23 |
1751940 | 1751940 | 2021-09-25 | Washington | Colorado | 8121 | 520 | 14 |
1751941 | 1751941 | 2021-09-25 | Weld | Colorado | 8123 | 41211 | 390 |
1751942 | 1751942 | 2021-09-25 | Yuma | Colorado | 8125 | 1063 | 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);