ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
304 rows where cases = 8 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
fips >30
county >30
- Archuleta 69
- Lincoln 44
- Ouray 26
- Jackson 24
- Huerfano 22
- Moffat 16
- Cheyenne 15
- Gilpin 10
- Lake 6
- Otero 6
- Montezuma 5
- Rio Grande 5
- Hinsdale 4
- Kit Carson 4
- Prowers 4
- Costilla 3
- Custer 3
- Las Animas 3
- Rio Blanco 3
- Washington 3
- Yuma 3
- Bent 2
- Boulder 2
- Douglas 2
- Fremont 2
- Garfield 2
- Montrose 2
- Phillips 2
- Saguache 2
- Adams 1
- …
state 1
- Colorado · 304 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
784406 | 784406 | 2020-12-01 | Hinsdale | Colorado | 8053 | 8 | 0 |
781161 | 781161 | 2020-11-30 | Hinsdale | Colorado | 8053 | 8 | 0 |
764934 | 764934 | 2020-11-25 | Hinsdale | Colorado | 8053 | 8 | 0 |
755197 | 755197 | 2020-11-22 | Hinsdale | Colorado | 8053 | 8 | 0 |
748695 | 748695 | 2020-11-20 | Dolores | Colorado | 8033 | 8 | 0 |
709774 | 709774 | 2020-11-08 | Kiowa | Colorado | 8061 | 8 | 0 |
557365 | 557365 | 2020-09-22 | Lincoln | Colorado | 8073 | 8 | 0 |
541176 | 541176 | 2020-09-17 | Lincoln | Colorado | 8073 | 8 | 0 |
537939 | 537939 | 2020-09-16 | Lincoln | Colorado | 8073 | 8 | 0 |
534703 | 534703 | 2020-09-15 | Lincoln | Colorado | 8073 | 8 | 0 |
531468 | 531468 | 2020-09-14 | Lincoln | Colorado | 8073 | 8 | 0 |
528231 | 528231 | 2020-09-13 | Lincoln | Colorado | 8073 | 8 | 0 |
524995 | 524995 | 2020-09-12 | Lincoln | Colorado | 8073 | 8 | 0 |
521759 | 521759 | 2020-09-11 | Lincoln | Colorado | 8073 | 8 | 0 |
518522 | 518522 | 2020-09-10 | Lincoln | Colorado | 8073 | 8 | 0 |
515287 | 515287 | 2020-09-09 | Lincoln | Colorado | 8073 | 8 | 0 |
512054 | 512054 | 2020-09-08 | Lincoln | Colorado | 8073 | 8 | 0 |
508821 | 508821 | 2020-09-07 | Lincoln | Colorado | 8073 | 8 | 0 |
505589 | 505589 | 2020-09-06 | Lincoln | Colorado | 8073 | 8 | 0 |
502355 | 502355 | 2020-09-05 | Lincoln | Colorado | 8073 | 8 | 0 |
499121 | 499121 | 2020-09-04 | Lincoln | Colorado | 8073 | 8 | 0 |
495888 | 495888 | 2020-09-03 | Lincoln | Colorado | 8073 | 8 | 0 |
492654 | 492654 | 2020-09-02 | Lincoln | Colorado | 8073 | 8 | 0 |
489421 | 489421 | 2020-09-01 | Lincoln | Colorado | 8073 | 8 | 0 |
486188 | 486188 | 2020-08-31 | Lincoln | Colorado | 8073 | 8 | 0 |
482953 | 482953 | 2020-08-30 | Lincoln | Colorado | 8073 | 8 | 0 |
479719 | 479719 | 2020-08-29 | Lincoln | Colorado | 8073 | 8 | 0 |
476486 | 476486 | 2020-08-28 | Lincoln | Colorado | 8073 | 8 | 0 |
473245 | 473245 | 2020-08-27 | Huerfano | Colorado | 8055 | 8 | 1 |
473253 | 473253 | 2020-08-27 | Lincoln | Colorado | 8073 | 8 | 0 |
470013 | 470013 | 2020-08-26 | Huerfano | Colorado | 8055 | 8 | 1 |
470021 | 470021 | 2020-08-26 | Lincoln | Colorado | 8073 | 8 | 0 |
466784 | 466784 | 2020-08-25 | Huerfano | Colorado | 8055 | 8 | 1 |
466792 | 466792 | 2020-08-25 | Lincoln | Colorado | 8073 | 8 | 0 |
463555 | 463555 | 2020-08-24 | Huerfano | Colorado | 8055 | 8 | 1 |
463563 | 463563 | 2020-08-24 | Lincoln | Colorado | 8073 | 8 | 0 |
460326 | 460326 | 2020-08-23 | Huerfano | Colorado | 8055 | 8 | 1 |
460334 | 460334 | 2020-08-23 | Lincoln | Colorado | 8073 | 8 | 0 |
457099 | 457099 | 2020-08-22 | Huerfano | Colorado | 8055 | 8 | 1 |
457107 | 457107 | 2020-08-22 | Lincoln | Colorado | 8073 | 8 | 0 |
453871 | 453871 | 2020-08-21 | Huerfano | Colorado | 8055 | 8 | 1 |
453879 | 453879 | 2020-08-21 | Lincoln | Colorado | 8073 | 8 | 0 |
450643 | 450643 | 2020-08-20 | Huerfano | Colorado | 8055 | 8 | 1 |
450651 | 450651 | 2020-08-20 | Lincoln | Colorado | 8073 | 8 | 0 |
447415 | 447415 | 2020-08-19 | Huerfano | Colorado | 8055 | 8 | 1 |
447423 | 447423 | 2020-08-19 | Lincoln | Colorado | 8073 | 8 | 0 |
444188 | 444188 | 2020-08-18 | Huerfano | Colorado | 8055 | 8 | 1 |
444196 | 444196 | 2020-08-18 | Lincoln | Colorado | 8073 | 8 | 0 |
440962 | 440962 | 2020-08-17 | Huerfano | Colorado | 8055 | 8 | 1 |
440970 | 440970 | 2020-08-17 | Lincoln | Colorado | 8073 | 8 | 0 |
437736 | 437736 | 2020-08-16 | Huerfano | Colorado | 8055 | 8 | 1 |
437744 | 437744 | 2020-08-16 | Lincoln | Colorado | 8073 | 8 | 0 |
434510 | 434510 | 2020-08-15 | Huerfano | Colorado | 8055 | 8 | 1 |
434518 | 434518 | 2020-08-15 | Lincoln | Colorado | 8073 | 8 | 0 |
431285 | 431285 | 2020-08-14 | Huerfano | Colorado | 8055 | 8 | 1 |
431293 | 431293 | 2020-08-14 | Lincoln | Colorado | 8073 | 8 | 0 |
428057 | 428057 | 2020-08-13 | Huerfano | Colorado | 8055 | 8 | 1 |
428065 | 428065 | 2020-08-13 | Lincoln | Colorado | 8073 | 8 | 0 |
424833 | 424833 | 2020-08-12 | Huerfano | Colorado | 8055 | 8 | 1 |
424841 | 424841 | 2020-08-12 | Lincoln | Colorado | 8073 | 8 | 0 |
421612 | 421612 | 2020-08-11 | Huerfano | Colorado | 8055 | 8 | 1 |
421620 | 421620 | 2020-08-11 | Lincoln | Colorado | 8073 | 8 | 0 |
418391 | 418391 | 2020-08-10 | Huerfano | Colorado | 8055 | 8 | 1 |
418399 | 418399 | 2020-08-10 | Lincoln | Colorado | 8073 | 8 | 0 |
415170 | 415170 | 2020-08-09 | Huerfano | Colorado | 8055 | 8 | 1 |
415178 | 415178 | 2020-08-09 | Lincoln | Colorado | 8073 | 8 | 0 |
411931 | 411931 | 2020-08-08 | Cheyenne | Colorado | 8017 | 8 | 0 |
411950 | 411950 | 2020-08-08 | Huerfano | Colorado | 8055 | 8 | 1 |
411958 | 411958 | 2020-08-08 | Lincoln | Colorado | 8073 | 8 | 0 |
408712 | 408712 | 2020-08-07 | Cheyenne | Colorado | 8017 | 8 | 0 |
408731 | 408731 | 2020-08-07 | Huerfano | Colorado | 8055 | 8 | 1 |
408739 | 408739 | 2020-08-07 | Lincoln | Colorado | 8073 | 8 | 0 |
405488 | 405488 | 2020-08-06 | Bent | Colorado | 8011 | 8 | 0 |
405492 | 405492 | 2020-08-06 | Cheyenne | Colorado | 8017 | 8 | 0 |
405511 | 405511 | 2020-08-06 | Huerfano | Colorado | 8055 | 8 | 1 |
405519 | 405519 | 2020-08-06 | Lincoln | Colorado | 8073 | 8 | 0 |
402270 | 402270 | 2020-08-05 | Bent | Colorado | 8011 | 8 | 0 |
402274 | 402274 | 2020-08-05 | Cheyenne | Colorado | 8017 | 8 | 0 |
402294 | 402294 | 2020-08-05 | Jackson | Colorado | 8057 | 8 | 0 |
402316 | 402316 | 2020-08-05 | Rio Blanco | Colorado | 8103 | 8 | 0 |
399058 | 399058 | 2020-08-04 | Cheyenne | Colorado | 8017 | 8 | 0 |
399078 | 399078 | 2020-08-04 | Jackson | Colorado | 8057 | 8 | 0 |
399100 | 399100 | 2020-08-04 | Rio Blanco | Colorado | 8103 | 8 | 0 |
395842 | 395842 | 2020-08-03 | Cheyenne | Colorado | 8017 | 8 | 0 |
395862 | 395862 | 2020-08-03 | Jackson | Colorado | 8057 | 8 | 0 |
395884 | 395884 | 2020-08-03 | Rio Blanco | Colorado | 8103 | 8 | 0 |
392626 | 392626 | 2020-08-02 | Cheyenne | Colorado | 8017 | 8 | 0 |
392646 | 392646 | 2020-08-02 | Jackson | Colorado | 8057 | 8 | 0 |
389409 | 389409 | 2020-08-01 | Cheyenne | Colorado | 8017 | 8 | 0 |
389429 | 389429 | 2020-08-01 | Jackson | Colorado | 8057 | 8 | 0 |
386192 | 386192 | 2020-07-31 | Cheyenne | Colorado | 8017 | 8 | 0 |
386212 | 386212 | 2020-07-31 | Jackson | Colorado | 8057 | 8 | 0 |
382974 | 382974 | 2020-07-30 | Cheyenne | Colorado | 8017 | 8 | 0 |
382994 | 382994 | 2020-07-30 | Jackson | Colorado | 8057 | 8 | 0 |
379757 | 379757 | 2020-07-29 | Cheyenne | Colorado | 8017 | 8 | 0 |
379777 | 379777 | 2020-07-29 | Jackson | Colorado | 8057 | 8 | 0 |
376540 | 376540 | 2020-07-28 | Cheyenne | Colorado | 8017 | 8 | 0 |
376560 | 376560 | 2020-07-28 | Jackson | Colorado | 8057 | 8 | 0 |
373326 | 373326 | 2020-07-27 | Cheyenne | Colorado | 8017 | 8 | 0 |
373346 | 373346 | 2020-07-27 | Jackson | Colorado | 8057 | 8 | 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);