ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Chaffee" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
534675 | 534675 | 2020-09-15 | Chaffee | Colorado | 8015 | 319 | 19 |
531440 | 531440 | 2020-09-14 | Chaffee | Colorado | 8015 | 318 | 19 |
528203 | 528203 | 2020-09-13 | Chaffee | Colorado | 8015 | 318 | 19 |
524967 | 524967 | 2020-09-12 | Chaffee | Colorado | 8015 | 318 | 19 |
521731 | 521731 | 2020-09-11 | Chaffee | Colorado | 8015 | 318 | 19 |
518494 | 518494 | 2020-09-10 | Chaffee | Colorado | 8015 | 318 | 19 |
515259 | 515259 | 2020-09-09 | Chaffee | Colorado | 8015 | 317 | 19 |
512026 | 512026 | 2020-09-08 | Chaffee | Colorado | 8015 | 317 | 19 |
508793 | 508793 | 2020-09-07 | Chaffee | Colorado | 8015 | 317 | 19 |
505561 | 505561 | 2020-09-06 | Chaffee | Colorado | 8015 | 317 | 19 |
502327 | 502327 | 2020-09-05 | Chaffee | Colorado | 8015 | 317 | 19 |
499093 | 499093 | 2020-09-04 | Chaffee | Colorado | 8015 | 317 | 19 |
495860 | 495860 | 2020-09-03 | Chaffee | Colorado | 8015 | 316 | 19 |
492626 | 492626 | 2020-09-02 | Chaffee | Colorado | 8015 | 316 | 19 |
489393 | 489393 | 2020-09-01 | Chaffee | Colorado | 8015 | 316 | 19 |
486160 | 486160 | 2020-08-31 | Chaffee | Colorado | 8015 | 316 | 19 |
482925 | 482925 | 2020-08-30 | Chaffee | Colorado | 8015 | 316 | 19 |
479691 | 479691 | 2020-08-29 | Chaffee | Colorado | 8015 | 315 | 19 |
476458 | 476458 | 2020-08-28 | Chaffee | Colorado | 8015 | 315 | 19 |
473225 | 473225 | 2020-08-27 | Chaffee | Colorado | 8015 | 315 | 19 |
469993 | 469993 | 2020-08-26 | Chaffee | Colorado | 8015 | 314 | 19 |
466764 | 466764 | 2020-08-25 | Chaffee | Colorado | 8015 | 314 | 19 |
463535 | 463535 | 2020-08-24 | Chaffee | Colorado | 8015 | 311 | 19 |
460306 | 460306 | 2020-08-23 | Chaffee | Colorado | 8015 | 310 | 19 |
457079 | 457079 | 2020-08-22 | Chaffee | Colorado | 8015 | 309 | 19 |
453851 | 453851 | 2020-08-21 | Chaffee | Colorado | 8015 | 308 | 19 |
450623 | 450623 | 2020-08-20 | Chaffee | Colorado | 8015 | 306 | 19 |
447395 | 447395 | 2020-08-19 | Chaffee | Colorado | 8015 | 305 | 19 |
444168 | 444168 | 2020-08-18 | Chaffee | Colorado | 8015 | 305 | 19 |
440942 | 440942 | 2020-08-17 | Chaffee | Colorado | 8015 | 304 | 19 |
437716 | 437716 | 2020-08-16 | Chaffee | Colorado | 8015 | 304 | 19 |
434490 | 434490 | 2020-08-15 | Chaffee | Colorado | 8015 | 304 | 19 |
431265 | 431265 | 2020-08-14 | Chaffee | Colorado | 8015 | 303 | 19 |
428037 | 428037 | 2020-08-13 | Chaffee | Colorado | 8015 | 305 | 19 |
424813 | 424813 | 2020-08-12 | Chaffee | Colorado | 8015 | 306 | 19 |
421592 | 421592 | 2020-08-11 | Chaffee | Colorado | 8015 | 304 | 19 |
418371 | 418371 | 2020-08-10 | Chaffee | Colorado | 8015 | 303 | 19 |
415150 | 415150 | 2020-08-09 | Chaffee | Colorado | 8015 | 303 | 19 |
411930 | 411930 | 2020-08-08 | Chaffee | Colorado | 8015 | 302 | 19 |
408711 | 408711 | 2020-08-07 | Chaffee | Colorado | 8015 | 296 | 19 |
405491 | 405491 | 2020-08-06 | Chaffee | Colorado | 8015 | 295 | 19 |
402273 | 402273 | 2020-08-05 | Chaffee | Colorado | 8015 | 292 | 19 |
399057 | 399057 | 2020-08-04 | Chaffee | Colorado | 8015 | 292 | 19 |
395841 | 395841 | 2020-08-03 | Chaffee | Colorado | 8015 | 287 | 19 |
392625 | 392625 | 2020-08-02 | Chaffee | Colorado | 8015 | 287 | 19 |
389408 | 389408 | 2020-08-01 | Chaffee | Colorado | 8015 | 286 | 19 |
386191 | 386191 | 2020-07-31 | Chaffee | Colorado | 8015 | 286 | 19 |
382973 | 382973 | 2020-07-30 | Chaffee | Colorado | 8015 | 281 | 19 |
379756 | 379756 | 2020-07-29 | Chaffee | Colorado | 8015 | 281 | 19 |
376539 | 376539 | 2020-07-28 | Chaffee | Colorado | 8015 | 281 | 19 |
373325 | 373325 | 2020-07-27 | Chaffee | Colorado | 8015 | 278 | 19 |
370113 | 370113 | 2020-07-26 | Chaffee | Colorado | 8015 | 277 | 19 |
366903 | 366903 | 2020-07-25 | Chaffee | Colorado | 8015 | 243 | 19 |
363696 | 363696 | 2020-07-24 | Chaffee | Colorado | 8015 | 224 | 19 |
360489 | 360489 | 2020-07-23 | Chaffee | Colorado | 8015 | 220 | 19 |
357284 | 357284 | 2020-07-22 | Chaffee | Colorado | 8015 | 220 | 19 |
354081 | 354081 | 2020-07-21 | Chaffee | Colorado | 8015 | 215 | 19 |
350879 | 350879 | 2020-07-20 | Chaffee | Colorado | 8015 | 215 | 19 |
347678 | 347678 | 2020-07-19 | Chaffee | Colorado | 8015 | 210 | 19 |
344478 | 344478 | 2020-07-18 | Chaffee | Colorado | 8015 | 210 | 19 |
341279 | 341279 | 2020-07-17 | Chaffee | Colorado | 8015 | 128 | 19 |
338083 | 338083 | 2020-07-16 | Chaffee | Colorado | 8015 | 124 | 19 |
334888 | 334888 | 2020-07-15 | Chaffee | Colorado | 8015 | 123 | 19 |
331695 | 331695 | 2020-07-14 | Chaffee | Colorado | 8015 | 123 | 19 |
328509 | 328509 | 2020-07-13 | Chaffee | Colorado | 8015 | 121 | 19 |
325323 | 325323 | 2020-07-12 | Chaffee | Colorado | 8015 | 116 | 19 |
322142 | 322142 | 2020-07-11 | Chaffee | Colorado | 8015 | 93 | 19 |
318963 | 318963 | 2020-07-10 | Chaffee | Colorado | 8015 | 82 | 19 |
315790 | 315790 | 2020-07-09 | Chaffee | Colorado | 8015 | 81 | 19 |
312615 | 312615 | 2020-07-08 | Chaffee | Colorado | 8015 | 81 | 19 |
309445 | 309445 | 2020-07-07 | Chaffee | Colorado | 8015 | 78 | 19 |
306277 | 306277 | 2020-07-06 | Chaffee | Colorado | 8015 | 78 | 19 |
303113 | 303113 | 2020-07-05 | Chaffee | Colorado | 8015 | 77 | 19 |
299949 | 299949 | 2020-07-04 | Chaffee | Colorado | 8015 | 77 | 19 |
296787 | 296787 | 2020-07-03 | Chaffee | Colorado | 8015 | 77 | 19 |
293631 | 293631 | 2020-07-02 | Chaffee | Colorado | 8015 | 77 | 19 |
290477 | 290477 | 2020-07-01 | Chaffee | Colorado | 8015 | 77 | 19 |
287326 | 287326 | 2020-06-30 | Chaffee | Colorado | 8015 | 77 | 19 |
284180 | 284180 | 2020-06-29 | Chaffee | Colorado | 8015 | 78 | 19 |
281034 | 281034 | 2020-06-28 | Chaffee | Colorado | 8015 | 78 | 19 |
277887 | 277887 | 2020-06-27 | Chaffee | Colorado | 8015 | 77 | 19 |
274739 | 274739 | 2020-06-26 | Chaffee | Colorado | 8015 | 77 | 19 |
271599 | 271599 | 2020-06-25 | Chaffee | Colorado | 8015 | 78 | 20 |
268464 | 268464 | 2020-06-24 | Chaffee | Colorado | 8015 | 78 | 20 |
265334 | 265334 | 2020-06-23 | Chaffee | Colorado | 8015 | 78 | 20 |
262206 | 262206 | 2020-06-22 | Chaffee | Colorado | 8015 | 78 | 20 |
259079 | 259079 | 2020-06-21 | Chaffee | Colorado | 8015 | 78 | 20 |
255952 | 255952 | 2020-06-20 | Chaffee | Colorado | 8015 | 78 | 20 |
252833 | 252833 | 2020-06-19 | Chaffee | Colorado | 8015 | 78 | 20 |
249718 | 249718 | 2020-06-18 | Chaffee | Colorado | 8015 | 78 | 20 |
246606 | 246606 | 2020-06-17 | Chaffee | Colorado | 8015 | 78 | 20 |
243493 | 243493 | 2020-06-16 | Chaffee | Colorado | 8015 | 78 | 20 |
240382 | 240382 | 2020-06-15 | Chaffee | Colorado | 8015 | 78 | 20 |
237274 | 237274 | 2020-06-14 | Chaffee | Colorado | 8015 | 78 | 20 |
234167 | 234167 | 2020-06-13 | Chaffee | Colorado | 8015 | 78 | 20 |
231061 | 231061 | 2020-06-12 | Chaffee | Colorado | 8015 | 78 | 20 |
227958 | 227958 | 2020-06-11 | Chaffee | Colorado | 8015 | 78 | 20 |
224856 | 224856 | 2020-06-10 | Chaffee | Colorado | 8015 | 78 | 20 |
221761 | 221761 | 2020-06-09 | Chaffee | Colorado | 8015 | 78 | 20 |
218666 | 218666 | 2020-06-08 | Chaffee | Colorado | 8015 | 78 | 20 |
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);