ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 8117 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
331744 | 331744 | 2020-07-14 | Summit | Colorado | 8117 | 293 | 4 |
328557 | 328557 | 2020-07-13 | Summit | Colorado | 8117 | 293 | 4 |
325371 | 325371 | 2020-07-12 | Summit | Colorado | 8117 | 293 | 4 |
322190 | 322190 | 2020-07-11 | Summit | Colorado | 8117 | 293 | 4 |
319011 | 319011 | 2020-07-10 | Summit | Colorado | 8117 | 294 | 4 |
315838 | 315838 | 2020-07-09 | Summit | Colorado | 8117 | 289 | 4 |
312663 | 312663 | 2020-07-08 | Summit | Colorado | 8117 | 288 | 4 |
309493 | 309493 | 2020-07-07 | Summit | Colorado | 8117 | 286 | 4 |
306325 | 306325 | 2020-07-06 | Summit | Colorado | 8117 | 281 | 4 |
303161 | 303161 | 2020-07-05 | Summit | Colorado | 8117 | 281 | 4 |
299997 | 299997 | 2020-07-04 | Summit | Colorado | 8117 | 278 | 4 |
296835 | 296835 | 2020-07-03 | Summit | Colorado | 8117 | 277 | 4 |
293679 | 293679 | 2020-07-02 | Summit | Colorado | 8117 | 276 | 4 |
290525 | 290525 | 2020-07-01 | Summit | Colorado | 8117 | 274 | 3 |
287374 | 287374 | 2020-06-30 | Summit | Colorado | 8117 | 269 | 3 |
284228 | 284228 | 2020-06-29 | Summit | Colorado | 8117 | 269 | 3 |
281082 | 281082 | 2020-06-28 | Summit | Colorado | 8117 | 269 | 3 |
277935 | 277935 | 2020-06-27 | Summit | Colorado | 8117 | 267 | 3 |
274787 | 274787 | 2020-06-26 | Summit | Colorado | 8117 | 267 | 3 |
271647 | 271647 | 2020-06-25 | Summit | Colorado | 8117 | 265 | 3 |
268511 | 268511 | 2020-06-24 | Summit | Colorado | 8117 | 264 | 3 |
265381 | 265381 | 2020-06-23 | Summit | Colorado | 8117 | 264 | 3 |
262253 | 262253 | 2020-06-22 | Summit | Colorado | 8117 | 263 | 3 |
259126 | 259126 | 2020-06-21 | Summit | Colorado | 8117 | 262 | 3 |
255999 | 255999 | 2020-06-20 | Summit | Colorado | 8117 | 262 | 3 |
252880 | 252880 | 2020-06-19 | Summit | Colorado | 8117 | 262 | 3 |
249765 | 249765 | 2020-06-18 | Summit | Colorado | 8117 | 262 | 3 |
246653 | 246653 | 2020-06-17 | Summit | Colorado | 8117 | 262 | 3 |
243540 | 243540 | 2020-06-16 | Summit | Colorado | 8117 | 258 | 3 |
240429 | 240429 | 2020-06-15 | Summit | Colorado | 8117 | 257 | 2 |
237321 | 237321 | 2020-06-14 | Summit | Colorado | 8117 | 256 | 2 |
234214 | 234214 | 2020-06-13 | Summit | Colorado | 8117 | 256 | 2 |
231108 | 231108 | 2020-06-12 | Summit | Colorado | 8117 | 254 | 2 |
228005 | 228005 | 2020-06-11 | Summit | Colorado | 8117 | 253 | 2 |
224903 | 224903 | 2020-06-10 | Summit | Colorado | 8117 | 252 | 2 |
221808 | 221808 | 2020-06-09 | Summit | Colorado | 8117 | 248 | 2 |
218713 | 218713 | 2020-06-08 | Summit | Colorado | 8117 | 247 | 2 |
215622 | 215622 | 2020-06-07 | Summit | Colorado | 8117 | 248 | 2 |
212535 | 212535 | 2020-06-06 | Summit | Colorado | 8117 | 243 | 2 |
209450 | 209450 | 2020-06-05 | Summit | Colorado | 8117 | 239 | 2 |
206369 | 206369 | 2020-06-04 | Summit | Colorado | 8117 | 239 | 2 |
203289 | 203289 | 2020-06-03 | Summit | Colorado | 8117 | 237 | 2 |
200213 | 200213 | 2020-06-02 | Summit | Colorado | 8117 | 233 | 2 |
197140 | 197140 | 2020-06-01 | Summit | Colorado | 8117 | 231 | 2 |
194070 | 194070 | 2020-05-31 | Summit | Colorado | 8117 | 226 | 2 |
191003 | 191003 | 2020-05-30 | Summit | Colorado | 8117 | 224 | 2 |
187938 | 187938 | 2020-05-29 | Summit | Colorado | 8117 | 219 | 2 |
184882 | 184882 | 2020-05-28 | Summit | Colorado | 8117 | 213 | 2 |
181828 | 181828 | 2020-05-27 | Summit | Colorado | 8117 | 214 | 2 |
178784 | 178784 | 2020-05-26 | Summit | Colorado | 8117 | 212 | 2 |
175740 | 175740 | 2020-05-25 | Summit | Colorado | 8117 | 205 | 2 |
172696 | 172696 | 2020-05-24 | Summit | Colorado | 8117 | 207 | 2 |
169655 | 169655 | 2020-05-23 | Summit | Colorado | 8117 | 203 | 2 |
166618 | 166618 | 2020-05-22 | Summit | Colorado | 8117 | 197 | 2 |
163585 | 163585 | 2020-05-21 | Summit | Colorado | 8117 | 195 | 2 |
160557 | 160557 | 2020-05-20 | Summit | Colorado | 8117 | 194 | 2 |
157531 | 157531 | 2020-05-19 | Summit | Colorado | 8117 | 192 | 2 |
154515 | 154515 | 2020-05-18 | Summit | Colorado | 8117 | 186 | 2 |
151503 | 151503 | 2020-05-17 | Summit | Colorado | 8117 | 183 | 2 |
148494 | 148494 | 2020-05-16 | Summit | Colorado | 8117 | 182 | 2 |
145491 | 145491 | 2020-05-15 | Summit | Colorado | 8117 | 178 | 2 |
142491 | 142491 | 2020-05-14 | Summit | Colorado | 8117 | 175 | 2 |
139495 | 139495 | 2020-05-13 | Summit | Colorado | 8117 | 174 | 2 |
136504 | 136504 | 2020-05-12 | Summit | Colorado | 8117 | 171 | 2 |
133515 | 133515 | 2020-05-11 | Summit | Colorado | 8117 | 169 | 2 |
130524 | 130524 | 2020-05-10 | Summit | Colorado | 8117 | 165 | 2 |
127533 | 127533 | 2020-05-09 | Summit | Colorado | 8117 | 162 | 2 |
124547 | 124547 | 2020-05-08 | Summit | Colorado | 8117 | 156 | 2 |
121567 | 121567 | 2020-05-07 | Summit | Colorado | 8117 | 155 | 2 |
118598 | 118598 | 2020-05-06 | Summit | Colorado | 8117 | 155 | 2 |
115638 | 115638 | 2020-05-05 | Summit | Colorado | 8117 | 151 | 2 |
112755 | 112755 | 2020-05-04 | Summit | Colorado | 8117 | 144 | 2 |
109880 | 109880 | 2020-05-03 | Summit | Colorado | 8117 | 144 | 2 |
107011 | 107011 | 2020-05-02 | Summit | Colorado | 8117 | 136 | 2 |
104146 | 104146 | 2020-05-01 | Summit | Colorado | 8117 | 130 | 2 |
101291 | 101291 | 2020-04-30 | Summit | Colorado | 8117 | 128 | 2 |
98441 | 98441 | 2020-04-29 | Summit | Colorado | 8117 | 121 | 2 |
95596 | 95596 | 2020-04-28 | Summit | Colorado | 8117 | 119 | 2 |
92764 | 92764 | 2020-04-27 | Summit | Colorado | 8117 | 106 | 2 |
89946 | 89946 | 2020-04-26 | Summit | Colorado | 8117 | 105 | 2 |
87129 | 87129 | 2020-04-25 | Summit | Colorado | 8117 | 97 | 1 |
84321 | 84321 | 2020-04-24 | Summit | Colorado | 8117 | 97 | 1 |
81521 | 81521 | 2020-04-23 | Summit | Colorado | 8117 | 89 | 1 |
78727 | 78727 | 2020-04-22 | Summit | Colorado | 8117 | 88 | 1 |
75943 | 75943 | 2020-04-21 | Summit | Colorado | 8117 | 88 | 1 |
73167 | 73167 | 2020-04-20 | Summit | Colorado | 8117 | 88 | 1 |
70398 | 70398 | 2020-04-19 | Summit | Colorado | 8117 | 86 | 1 |
67636 | 67636 | 2020-04-18 | Summit | Colorado | 8117 | 86 | 1 |
64888 | 64888 | 2020-04-17 | Summit | Colorado | 8117 | 82 | 1 |
62155 | 62155 | 2020-04-16 | Summit | Colorado | 8117 | 77 | 1 |
59436 | 59436 | 2020-04-15 | Summit | Colorado | 8117 | 76 | 1 |
56728 | 56728 | 2020-04-14 | Summit | Colorado | 8117 | 74 | 1 |
54036 | 54036 | 2020-04-13 | Summit | Colorado | 8117 | 72 | 1 |
51357 | 51357 | 2020-04-12 | Summit | Colorado | 8117 | 68 | 1 |
48695 | 48695 | 2020-04-11 | Summit | Colorado | 8117 | 68 | 0 |
46065 | 46065 | 2020-04-10 | Summit | Colorado | 8117 | 61 | 0 |
43465 | 43465 | 2020-04-09 | Summit | Colorado | 8117 | 57 | 0 |
40891 | 40891 | 2020-04-08 | Summit | Colorado | 8117 | 56 | 0 |
38348 | 38348 | 2020-04-07 | Summit | Colorado | 8117 | 53 | 0 |
35858 | 35858 | 2020-04-06 | Summit | Colorado | 8117 | 47 | 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);