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-21 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1738882 | 1738882 | 2021-09-21 | Adams | Colorado | 8001 | 70897 | 831 |
1738883 | 1738883 | 2021-09-21 | Alamosa | Colorado | 8003 | 2048 | 42 |
1738884 | 1738884 | 2021-09-21 | Arapahoe | Colorado | 8005 | 74025 | 877 |
1738885 | 1738885 | 2021-09-21 | Archuleta | Colorado | 8007 | 1331 | 3 |
1738886 | 1738886 | 2021-09-21 | Baca | Colorado | 8009 | 383 | 5 |
1738887 | 1738887 | 2021-09-21 | Bent | Colorado | 8011 | 1594 | 23 |
1738888 | 1738888 | 2021-09-21 | Boulder | Colorado | 8013 | 28099 | 268 |
1738889 | 1738889 | 2021-09-21 | Broomfield | Colorado | 8014 | 6032 | 78 |
1738890 | 1738890 | 2021-09-21 | Chaffee | Colorado | 8015 | 2044 | 27 |
1738891 | 1738891 | 2021-09-21 | Cheyenne | Colorado | 8017 | 155 | 7 |
1738892 | 1738892 | 2021-09-21 | Clear Creek | Colorado | 8019 | 676 | 4 |
1738893 | 1738893 | 2021-09-21 | Conejos | Colorado | 8021 | 835 | 29 |
1738894 | 1738894 | 2021-09-21 | Costilla | Colorado | 8023 | 318 | 6 |
1738895 | 1738895 | 2021-09-21 | Crowley | Colorado | 8025 | 2267 | 18 |
1738896 | 1738896 | 2021-09-21 | Custer | Colorado | 8027 | 289 | 6 |
1738897 | 1738897 | 2021-09-21 | Delta | Colorado | 8029 | 3386 | 79 |
1738898 | 1738898 | 2021-09-21 | Denver | Colorado | 8031 | 84340 | 895 |
1738899 | 1738899 | 2021-09-21 | Dolores | Colorado | 8033 | 165 | 1 |
1738900 | 1738900 | 2021-09-21 | Douglas | Colorado | 8035 | 37110 | 284 |
1738901 | 1738901 | 2021-09-21 | Eagle | Colorado | 8037 | 7769 | 30 |
1738902 | 1738902 | 2021-09-21 | El Paso | Colorado | 8041 | 89034 | 983 |
1738903 | 1738903 | 2021-09-21 | Elbert | Colorado | 8039 | 2327 | 18 |
1738904 | 1738904 | 2021-09-21 | Fremont | Colorado | 8043 | 7243 | 72 |
1738905 | 1738905 | 2021-09-21 | Garfield | Colorado | 8045 | 7109 | 59 |
1738906 | 1738906 | 2021-09-21 | Gilpin | Colorado | 8047 | 382 | 3 |
1738907 | 1738907 | 2021-09-21 | Grand | Colorado | 8049 | 1889 | 8 |
1738908 | 1738908 | 2021-09-21 | Gunnison | Colorado | 8051 | 1694 | 8 |
1738909 | 1738909 | 2021-09-21 | Hinsdale | Colorado | 8053 | 52 | 0 |
1738910 | 1738910 | 2021-09-21 | Huerfano | Colorado | 8055 | 541 | 17 |
1738911 | 1738911 | 2021-09-21 | Jackson | Colorado | 8057 | 81 | 0 |
1738912 | 1738912 | 2021-09-21 | Jefferson | Colorado | 8059 | 56937 | 860 |
1738913 | 1738913 | 2021-09-21 | Kiowa | Colorado | 8061 | 114 | 3 |
1738914 | 1738914 | 2021-09-21 | Kit Carson | Colorado | 8063 | 825 | 14 |
1738915 | 1738915 | 2021-09-21 | La Plata | Colorado | 8067 | 5043 | 49 |
1738916 | 1738916 | 2021-09-21 | Lake | Colorado | 8065 | 948 | 1 |
1738917 | 1738917 | 2021-09-21 | Larimer | Colorado | 8069 | 34177 | 277 |
1738918 | 1738918 | 2021-09-21 | Las Animas | Colorado | 8071 | 1601 | 20 |
1738919 | 1738919 | 2021-09-21 | Lincoln | Colorado | 8073 | 1189 | 6 |
1738920 | 1738920 | 2021-09-21 | Logan | Colorado | 8075 | 4355 | 72 |
1738921 | 1738921 | 2021-09-21 | Mesa | Colorado | 8077 | 20805 | 288 |
1738922 | 1738922 | 2021-09-21 | Mineral | Colorado | 8079 | 107 | 1 |
1738923 | 1738923 | 2021-09-21 | Moffat | Colorado | 8081 | 1588 | 31 |
1738924 | 1738924 | 2021-09-21 | Montezuma | Colorado | 8083 | 2511 | 33 |
1738925 | 1738925 | 2021-09-21 | Montrose | Colorado | 8085 | 4534 | 76 |
1738926 | 1738926 | 2021-09-21 | Morgan | Colorado | 8087 | 3080 | 98 |
1738927 | 1738927 | 2021-09-21 | Otero | Colorado | 8089 | 2291 | 71 |
1738928 | 1738928 | 2021-09-21 | Ouray | Colorado | 8091 | 375 | 5 |
1738929 | 1738929 | 2021-09-21 | Park | Colorado | 8093 | 1130 | 7 |
1738930 | 1738930 | 2021-09-21 | Phillips | Colorado | 8095 | 457 | 14 |
1738931 | 1738931 | 2021-09-21 | Pitkin | Colorado | 8097 | 2954 | 5 |
1738932 | 1738932 | 2021-09-21 | Prowers | Colorado | 8099 | 1444 | 25 |
1738933 | 1738933 | 2021-09-21 | Pueblo | Colorado | 8101 | 22041 | 450 |
1738934 | 1738934 | 2021-09-21 | Rio Blanco | Colorado | 8103 | 824 | 8 |
1738935 | 1738935 | 2021-09-21 | Rio Grande | Colorado | 8105 | 1138 | 21 |
1738936 | 1738936 | 2021-09-21 | Routt | Colorado | 8107 | 2989 | 22 |
1738937 | 1738937 | 2021-09-21 | Saguache | Colorado | 8109 | 540 | 8 |
1738938 | 1738938 | 2021-09-21 | San Juan | Colorado | 8111 | 87 | 1 |
1738939 | 1738939 | 2021-09-21 | San Miguel | Colorado | 8113 | 1099 | 3 |
1738940 | 1738940 | 2021-09-21 | Sedgwick | Colorado | 8115 | 272 | 4 |
1738941 | 1738941 | 2021-09-21 | Summit | Colorado | 8117 | 4471 | 9 |
1738942 | 1738942 | 2021-09-21 | Teller | Colorado | 8119 | 2303 | 23 |
1738943 | 1738943 | 2021-09-21 | Washington | Colorado | 8121 | 514 | 14 |
1738944 | 1738944 | 2021-09-21 | Weld | Colorado | 8123 | 40802 | 387 |
1738945 | 1738945 | 2021-09-21 | Yuma | Colorado | 8125 | 1052 | 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);