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-07-07 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1492028 | 1492028 | 2021-07-07 | Adams | Colorado | 8001 | 62282 | 759 |
1492029 | 1492029 | 2021-07-07 | Alamosa | Colorado | 8003 | 1736 | 37 |
1492030 | 1492030 | 2021-07-07 | Arapahoe | Colorado | 8005 | 64311 | 831 |
1492031 | 1492031 | 2021-07-07 | Archuleta | Colorado | 8007 | 1063 | 3 |
1492032 | 1492032 | 2021-07-07 | Baca | Colorado | 8009 | 325 | 4 |
1492033 | 1492033 | 2021-07-07 | Bent | Colorado | 8011 | 1545 | 22 |
1492034 | 1492034 | 2021-07-07 | Boulder | Colorado | 8013 | 24197 | 261 |
1492035 | 1492035 | 2021-07-07 | Broomfield | Colorado | 8014 | 5020 | 76 |
1492036 | 1492036 | 2021-07-07 | Chaffee | Colorado | 8015 | 1779 | 25 |
1492037 | 1492037 | 2021-07-07 | Cheyenne | Colorado | 8017 | 130 | 6 |
1492038 | 1492038 | 2021-07-07 | Clear Creek | Colorado | 8019 | 480 | 3 |
1492039 | 1492039 | 2021-07-07 | Conejos | Colorado | 8021 | 742 | 22 |
1492040 | 1492040 | 2021-07-07 | Costilla | Colorado | 8023 | 251 | 5 |
1492041 | 1492041 | 2021-07-07 | Crowley | Colorado | 8025 | 2216 | 17 |
1492042 | 1492042 | 2021-07-07 | Custer | Colorado | 8027 | 229 | 2 |
1492043 | 1492043 | 2021-07-07 | Delta | Colorado | 8029 | 2962 | 66 |
1492044 | 1492044 | 2021-07-07 | Denver | Colorado | 8031 | 74555 | 845 |
1492045 | 1492045 | 2021-07-07 | Dolores | Colorado | 8033 | 130 | 1 |
1492046 | 1492046 | 2021-07-07 | Douglas | Colorado | 8035 | 31281 | 266 |
1492047 | 1492047 | 2021-07-07 | Eagle | Colorado | 8037 | 6372 | 23 |
1492048 | 1492048 | 2021-07-07 | El Paso | Colorado | 8041 | 73813 | 882 |
1492049 | 1492049 | 2021-07-07 | Elbert | Colorado | 8039 | 1895 | 14 |
1492050 | 1492050 | 2021-07-07 | Fremont | Colorado | 8043 | 6560 | 63 |
1492051 | 1492051 | 2021-07-07 | Garfield | Colorado | 8045 | 6224 | 50 |
1492052 | 1492052 | 2021-07-07 | Gilpin | Colorado | 8047 | 285 | 3 |
1492053 | 1492053 | 2021-07-07 | Grand | Colorado | 8049 | 1507 | 7 |
1492054 | 1492054 | 2021-07-07 | Gunnison | Colorado | 8051 | 1401 | 6 |
1492055 | 1492055 | 2021-07-07 | Hinsdale | Colorado | 8053 | 20 | 0 |
1492056 | 1492056 | 2021-07-07 | Huerfano | Colorado | 8055 | 440 | 18 |
1492057 | 1492057 | 2021-07-07 | Jackson | Colorado | 8057 | 67 | 0 |
1492058 | 1492058 | 2021-07-07 | Jefferson | Colorado | 8059 | 49055 | 806 |
1492059 | 1492059 | 2021-07-07 | Kiowa | Colorado | 8061 | 95 | 3 |
1492060 | 1492060 | 2021-07-07 | Kit Carson | Colorado | 8063 | 648 | 12 |
1492061 | 1492061 | 2021-07-07 | La Plata | Colorado | 8067 | 4182 | 41 |
1492062 | 1492062 | 2021-07-07 | Lake | Colorado | 8065 | 836 | 0 |
1492063 | 1492063 | 2021-07-07 | Larimer | Colorado | 8069 | 27872 | 248 |
1492064 | 1492064 | 2021-07-07 | Las Animas | Colorado | 8071 | 1190 | 14 |
1492065 | 1492065 | 2021-07-07 | Lincoln | Colorado | 8073 | 1036 | 4 |
1492066 | 1492066 | 2021-07-07 | Logan | Colorado | 8075 | 4067 | 69 |
1492067 | 1492067 | 2021-07-07 | Mesa | Colorado | 8077 | 17464 | 253 |
1492068 | 1492068 | 2021-07-07 | Mineral | Colorado | 8079 | 94 | 1 |
1492069 | 1492069 | 2021-07-07 | Moffat | Colorado | 8081 | 1062 | 26 |
1492070 | 1492070 | 2021-07-07 | Montezuma | Colorado | 8083 | 2108 | 25 |
1492071 | 1492071 | 2021-07-07 | Montrose | Colorado | 8085 | 3769 | 66 |
1492072 | 1492072 | 2021-07-07 | Morgan | Colorado | 8087 | 2757 | 96 |
1492073 | 1492073 | 2021-07-07 | Otero | Colorado | 8089 | 2090 | 67 |
1492074 | 1492074 | 2021-07-07 | Ouray | Colorado | 8091 | 301 | 3 |
1492075 | 1492075 | 2021-07-07 | Park | Colorado | 8093 | 834 | 5 |
1492076 | 1492076 | 2021-07-07 | Phillips | Colorado | 8095 | 400 | 13 |
1492077 | 1492077 | 2021-07-07 | Pitkin | Colorado | 8097 | 2624 | 4 |
1492078 | 1492078 | 2021-07-07 | Prowers | Colorado | 8099 | 1280 | 22 |
1492079 | 1492079 | 2021-07-07 | Pueblo | Colorado | 8101 | 19648 | 422 |
1492080 | 1492080 | 2021-07-07 | Rio Blanco | Colorado | 8103 | 637 | 5 |
1492081 | 1492081 | 2021-07-07 | Rio Grande | Colorado | 8105 | 915 | 16 |
1492082 | 1492082 | 2021-07-07 | Routt | Colorado | 8107 | 2314 | 21 |
1492083 | 1492083 | 2021-07-07 | Saguache | Colorado | 8109 | 460 | 5 |
1492084 | 1492084 | 2021-07-07 | San Juan | Colorado | 8111 | 47 | 0 |
1492085 | 1492085 | 2021-07-07 | San Miguel | Colorado | 8113 | 929 | 1 |
1492086 | 1492086 | 2021-07-07 | Sedgwick | Colorado | 8115 | 236 | 3 |
1492087 | 1492087 | 2021-07-07 | Summit | Colorado | 8117 | 3778 | 8 |
1492088 | 1492088 | 2021-07-07 | Teller | Colorado | 8119 | 1928 | 18 |
1492089 | 1492089 | 2021-07-07 | Washington | Colorado | 8121 | 474 | 13 |
1492090 | 1492090 | 2021-07-07 | Weld | Colorado | 8123 | 33637 | 352 |
1492091 | 1492091 | 2021-07-07 | Yuma | Colorado | 8125 | 970 | 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);