ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
63 rows where date = "2020-07-25" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
366895 | 366895 | 2020-07-25 | Adams | Colorado | 8001 | 5535 | 167 |
366896 | 366896 | 2020-07-25 | Alamosa | Colorado | 8003 | 219 | 7 |
366897 | 366897 | 2020-07-25 | Arapahoe | Colorado | 8005 | 6470 | 360 |
366898 | 366898 | 2020-07-25 | Archuleta | Colorado | 8007 | 25 | 0 |
366899 | 366899 | 2020-07-25 | Baca | Colorado | 8009 | 14 | 0 |
366900 | 366900 | 2020-07-25 | Bent | Colorado | 8011 | 5 | 0 |
366901 | 366901 | 2020-07-25 | Boulder | Colorado | 8013 | 1775 | 74 |
366902 | 366902 | 2020-07-25 | Broomfield | Colorado | 8014 | 378 | 32 |
366903 | 366903 | 2020-07-25 | Chaffee | Colorado | 8015 | 243 | 19 |
366904 | 366904 | 2020-07-25 | Cheyenne | Colorado | 8017 | 7 | 0 |
366905 | 366905 | 2020-07-25 | Clear Creek | Colorado | 8019 | 25 | 1 |
366906 | 366906 | 2020-07-25 | Conejos | Colorado | 8021 | 22 | 0 |
366907 | 366907 | 2020-07-25 | Costilla | Colorado | 8023 | 22 | 0 |
366908 | 366908 | 2020-07-25 | Crowley | Colorado | 8025 | 72 | 1 |
366909 | 366909 | 2020-07-25 | Custer | Colorado | 8027 | 10 | 0 |
366910 | 366910 | 2020-07-25 | Delta | Colorado | 8029 | 98 | 1 |
366911 | 366911 | 2020-07-25 | Denver | Colorado | 8031 | 9101 | 405 |
366912 | 366912 | 2020-07-25 | Dolores | Colorado | 8033 | 1 | 0 |
366913 | 366913 | 2020-07-25 | Douglas | Colorado | 8035 | 1494 | 56 |
366914 | 366914 | 2020-07-25 | Eagle | Colorado | 8037 | 944 | 9 |
366915 | 366915 | 2020-07-25 | El Paso | Colorado | 8041 | 4085 | 126 |
366916 | 366916 | 2020-07-25 | Elbert | Colorado | 8039 | 77 | 2 |
366917 | 366917 | 2020-07-25 | Fremont | Colorado | 8043 | 87 | 0 |
366918 | 366918 | 2020-07-25 | Garfield | Colorado | 8045 | 612 | 4 |
366919 | 366919 | 2020-07-25 | Gilpin | Colorado | 8047 | 13 | 0 |
366920 | 366920 | 2020-07-25 | Grand | Colorado | 8049 | 40 | 1 |
366921 | 366921 | 2020-07-25 | Gunnison | Colorado | 8051 | 216 | 6 |
366922 | 366922 | 2020-07-25 | Hinsdale | Colorado | 8053 | 3 | 0 |
366923 | 366923 | 2020-07-25 | Huerfano | Colorado | 8055 | 6 | 1 |
366924 | 366924 | 2020-07-25 | Jackson | Colorado | 8057 | 8 | 0 |
366925 | 366925 | 2020-07-25 | Jefferson | Colorado | 8059 | 3622 | 221 |
366926 | 366926 | 2020-07-25 | Kit Carson | Colorado | 8063 | 42 | 3 |
366927 | 366927 | 2020-07-25 | La Plata | Colorado | 8067 | 185 | 2 |
366928 | 366928 | 2020-07-25 | Lake | Colorado | 8065 | 61 | 0 |
366929 | 366929 | 2020-07-25 | Larimer | Colorado | 8069 | 1238 | 32 |
366930 | 366930 | 2020-07-25 | Las Animas | Colorado | 8071 | 13 | 0 |
366931 | 366931 | 2020-07-25 | Lincoln | Colorado | 8073 | 6 | 0 |
366932 | 366932 | 2020-07-25 | Logan | Colorado | 8075 | 645 | 5 |
366933 | 366933 | 2020-07-25 | Mesa | Colorado | 8077 | 227 | 1 |
366934 | 366934 | 2020-07-25 | Mineral | Colorado | 8079 | 18 | 0 |
366935 | 366935 | 2020-07-25 | Moffat | Colorado | 8081 | 23 | 1 |
366936 | 366936 | 2020-07-25 | Montezuma | Colorado | 8083 | 96 | 4 |
366937 | 366937 | 2020-07-25 | Montrose | Colorado | 8085 | 255 | 13 |
366938 | 366938 | 2020-07-25 | Morgan | Colorado | 8087 | 672 | 46 |
366939 | 366939 | 2020-07-25 | Otero | Colorado | 8089 | 36 | 3 |
366940 | 366940 | 2020-07-25 | Ouray | Colorado | 8091 | 12 | 1 |
366941 | 366941 | 2020-07-25 | Park | Colorado | 8093 | 39 | 1 |
366942 | 366942 | 2020-07-25 | Phillips | Colorado | 8095 | 20 | 0 |
366943 | 366943 | 2020-07-25 | Pitkin | Colorado | 8097 | 153 | 2 |
366944 | 366944 | 2020-07-25 | Prowers | Colorado | 8099 | 45 | 0 |
366945 | 366945 | 2020-07-25 | Pueblo | Colorado | 8101 | 552 | 33 |
366946 | 366946 | 2020-07-25 | Rio Blanco | Colorado | 8103 | 6 | 0 |
366947 | 366947 | 2020-07-25 | Rio Grande | Colorado | 8105 | 87 | 2 |
366948 | 366948 | 2020-07-25 | Routt | Colorado | 8107 | 94 | 6 |
366949 | 366949 | 2020-07-25 | Saguache | Colorado | 8109 | 107 | 2 |
366950 | 366950 | 2020-07-25 | San Juan | Colorado | 8111 | 2 | 0 |
366951 | 366951 | 2020-07-25 | San Miguel | Colorado | 8113 | 73 | 0 |
366952 | 366952 | 2020-07-25 | Sedgwick | Colorado | 8115 | 11 | 0 |
366953 | 366953 | 2020-07-25 | Summit | Colorado | 8117 | 315 | 4 |
366954 | 366954 | 2020-07-25 | Teller | Colorado | 8119 | 96 | 2 |
366955 | 366955 | 2020-07-25 | Washington | Colorado | 8121 | 46 | 0 |
366956 | 366956 | 2020-07-25 | Weld | Colorado | 8123 | 3386 | 139 |
366957 | 366957 | 2020-07-25 | Yuma | Colorado | 8125 | 57 | 0 |
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);