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-06-29 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1466058 | 1466058 | 2021-06-29 | Adams | Colorado | 8001 | 62007 | 755 |
1466059 | 1466059 | 2021-06-29 | Alamosa | Colorado | 8003 | 1724 | 37 |
1466060 | 1466060 | 2021-06-29 | Arapahoe | Colorado | 8005 | 64008 | 826 |
1466061 | 1466061 | 2021-06-29 | Archuleta | Colorado | 8007 | 1028 | 2 |
1466062 | 1466062 | 2021-06-29 | Baca | Colorado | 8009 | 323 | 4 |
1466063 | 1466063 | 2021-06-29 | Bent | Colorado | 8011 | 1547 | 22 |
1466064 | 1466064 | 2021-06-29 | Boulder | Colorado | 8013 | 24081 | 261 |
1466065 | 1466065 | 2021-06-29 | Broomfield | Colorado | 8014 | 4998 | 76 |
1466066 | 1466066 | 2021-06-29 | Chaffee | Colorado | 8015 | 1770 | 25 |
1466067 | 1466067 | 2021-06-29 | Cheyenne | Colorado | 8017 | 130 | 6 |
1466068 | 1466068 | 2021-06-29 | Clear Creek | Colorado | 8019 | 477 | 3 |
1466069 | 1466069 | 2021-06-29 | Conejos | Colorado | 8021 | 737 | 21 |
1466070 | 1466070 | 2021-06-29 | Costilla | Colorado | 8023 | 250 | 5 |
1466071 | 1466071 | 2021-06-29 | Crowley | Colorado | 8025 | 2212 | 16 |
1466072 | 1466072 | 2021-06-29 | Custer | Colorado | 8027 | 227 | 2 |
1466073 | 1466073 | 2021-06-29 | Delta | Colorado | 8029 | 2931 | 67 |
1466074 | 1466074 | 2021-06-29 | Denver | Colorado | 8031 | 74315 | 843 |
1466075 | 1466075 | 2021-06-29 | Dolores | Colorado | 8033 | 129 | 1 |
1466076 | 1466076 | 2021-06-29 | Douglas | Colorado | 8035 | 31118 | 266 |
1466077 | 1466077 | 2021-06-29 | Eagle | Colorado | 8037 | 6354 | 23 |
1466078 | 1466078 | 2021-06-29 | El Paso | Colorado | 8041 | 73296 | 873 |
1466079 | 1466079 | 2021-06-29 | Elbert | Colorado | 8039 | 1888 | 14 |
1466080 | 1466080 | 2021-06-29 | Fremont | Colorado | 8043 | 6544 | 63 |
1466081 | 1466081 | 2021-06-29 | Garfield | Colorado | 8045 | 6167 | 49 |
1466082 | 1466082 | 2021-06-29 | Gilpin | Colorado | 8047 | 284 | 3 |
1466083 | 1466083 | 2021-06-29 | Grand | Colorado | 8049 | 1505 | 7 |
1466084 | 1466084 | 2021-06-29 | Gunnison | Colorado | 8051 | 1392 | 6 |
1466085 | 1466085 | 2021-06-29 | Hinsdale | Colorado | 8053 | 20 | 0 |
1466086 | 1466086 | 2021-06-29 | Huerfano | Colorado | 8055 | 433 | 17 |
1466087 | 1466087 | 2021-06-29 | Jackson | Colorado | 8057 | 67 | 0 |
1466088 | 1466088 | 2021-06-29 | Jefferson | Colorado | 8059 | 48892 | 803 |
1466089 | 1466089 | 2021-06-29 | Kiowa | Colorado | 8061 | 95 | 3 |
1466090 | 1466090 | 2021-06-29 | Kit Carson | Colorado | 8063 | 646 | 11 |
1466091 | 1466091 | 2021-06-29 | La Plata | Colorado | 8067 | 4136 | 41 |
1466092 | 1466092 | 2021-06-29 | Lake | Colorado | 8065 | 835 | 0 |
1466093 | 1466093 | 2021-06-29 | Larimer | Colorado | 8069 | 27676 | 249 |
1466094 | 1466094 | 2021-06-29 | Las Animas | Colorado | 8071 | 1167 | 14 |
1466095 | 1466095 | 2021-06-29 | Lincoln | Colorado | 8073 | 1035 | 4 |
1466096 | 1466096 | 2021-06-29 | Logan | Colorado | 8075 | 4055 | 69 |
1466097 | 1466097 | 2021-06-29 | Mesa | Colorado | 8077 | 17116 | 249 |
1466098 | 1466098 | 2021-06-29 | Mineral | Colorado | 8079 | 93 | 1 |
1466099 | 1466099 | 2021-06-29 | Moffat | Colorado | 8081 | 1009 | 26 |
1466100 | 1466100 | 2021-06-29 | Montezuma | Colorado | 8083 | 2085 | 25 |
1466101 | 1466101 | 2021-06-29 | Montrose | Colorado | 8085 | 3727 | 65 |
1466102 | 1466102 | 2021-06-29 | Morgan | Colorado | 8087 | 2747 | 96 |
1466103 | 1466103 | 2021-06-29 | Otero | Colorado | 8089 | 2085 | 68 |
1466104 | 1466104 | 2021-06-29 | Ouray | Colorado | 8091 | 294 | 3 |
1466105 | 1466105 | 2021-06-29 | Park | Colorado | 8093 | 831 | 5 |
1466106 | 1466106 | 2021-06-29 | Phillips | Colorado | 8095 | 398 | 13 |
1466107 | 1466107 | 2021-06-29 | Pitkin | Colorado | 8097 | 2614 | 4 |
1466108 | 1466108 | 2021-06-29 | Prowers | Colorado | 8099 | 1277 | 22 |
1466109 | 1466109 | 2021-06-29 | Pueblo | Colorado | 8101 | 19581 | 418 |
1466110 | 1466110 | 2021-06-29 | Rio Blanco | Colorado | 8103 | 615 | 5 |
1466111 | 1466111 | 2021-06-29 | Rio Grande | Colorado | 8105 | 903 | 16 |
1466112 | 1466112 | 2021-06-29 | Routt | Colorado | 8107 | 2286 | 21 |
1466113 | 1466113 | 2021-06-29 | Saguache | Colorado | 8109 | 448 | 5 |
1466114 | 1466114 | 2021-06-29 | San Juan | Colorado | 8111 | 47 | 0 |
1466115 | 1466115 | 2021-06-29 | San Miguel | Colorado | 8113 | 921 | 1 |
1466116 | 1466116 | 2021-06-29 | Sedgwick | Colorado | 8115 | 236 | 3 |
1466117 | 1466117 | 2021-06-29 | Summit | Colorado | 8117 | 3769 | 8 |
1466118 | 1466118 | 2021-06-29 | Teller | Colorado | 8119 | 1921 | 18 |
1466119 | 1466119 | 2021-06-29 | Washington | Colorado | 8121 | 473 | 13 |
1466120 | 1466120 | 2021-06-29 | Weld | Colorado | 8123 | 33463 | 351 |
1466121 | 1466121 | 2021-06-29 | Yuma | Colorado | 8125 | 969 | 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);