ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
98 rows where cases = 24 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
fips >30
county >30
- Lincoln 18
- Rio Blanco 17
- Clear Creek 5
- San Miguel 5
- Costilla 4
- Mineral 4
- Otero 4
- Archuleta 3
- Custer 3
- Elbert 3
- Huerfano 3
- Kit Carson 3
- Moffat 3
- Bent 2
- Logan 2
- Park 2
- Prowers 2
- Teller 2
- Baca 1
- Boulder 1
- Eagle 1
- Gilpin 1
- Jackson 1
- Kiowa 1
- La Plata 1
- Lake 1
- Las Animas 1
- Montezuma 1
- Ouray 1
- Saguache 1
- …
state 1
- Colorado · 98 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
816857 | 816857 | 2020-12-11 | Jackson | Colorado | 8057 | 24 | 0 |
807149 | 807149 | 2020-12-08 | San Juan | Colorado | 8111 | 24 | 0 |
781165 | 781165 | 2020-11-30 | Kiowa | Colorado | 8061 | 24 | 0 |
758457 | 758457 | 2020-11-23 | Mineral | Colorado | 8079 | 24 | 0 |
755210 | 755210 | 2020-11-22 | Mineral | Colorado | 8079 | 24 | 0 |
751964 | 751964 | 2020-11-21 | Mineral | Colorado | 8079 | 24 | 0 |
748718 | 748718 | 2020-11-20 | Mineral | Colorado | 8079 | 24 | 0 |
709748 | 709748 | 2020-11-08 | Bent | Colorado | 8011 | 24 | 0 |
706504 | 706504 | 2020-11-07 | Bent | Colorado | 8011 | 24 | 0 |
690298 | 690298 | 2020-11-02 | Custer | Colorado | 8027 | 24 | 0 |
687053 | 687053 | 2020-11-01 | Custer | Colorado | 8027 | 24 | 0 |
683809 | 683809 | 2020-10-31 | Custer | Colorado | 8027 | 24 | 0 |
667618 | 667618 | 2020-10-26 | Lincoln | Colorado | 8073 | 24 | 0 |
664373 | 664373 | 2020-10-25 | Lincoln | Colorado | 8073 | 24 | 0 |
661129 | 661129 | 2020-10-24 | Lincoln | Colorado | 8073 | 24 | 0 |
657885 | 657885 | 2020-10-23 | Lincoln | Colorado | 8073 | 24 | 0 |
654640 | 654640 | 2020-10-22 | Lincoln | Colorado | 8073 | 24 | 0 |
651395 | 651395 | 2020-10-21 | Lincoln | Colorado | 8073 | 24 | 0 |
648151 | 648151 | 2020-10-20 | Lincoln | Colorado | 8073 | 24 | 0 |
644873 | 644873 | 2020-10-19 | Baca | Colorado | 8009 | 24 | 0 |
644893 | 644893 | 2020-10-19 | Gilpin | Colorado | 8047 | 24 | 0 |
644906 | 644906 | 2020-10-19 | Lincoln | Colorado | 8073 | 24 | 0 |
641658 | 641658 | 2020-10-18 | Lincoln | Colorado | 8073 | 24 | 0 |
638411 | 638411 | 2020-10-17 | Lincoln | Colorado | 8073 | 24 | 0 |
635166 | 635166 | 2020-10-16 | Lincoln | Colorado | 8073 | 24 | 0 |
631920 | 631920 | 2020-10-15 | Lincoln | Colorado | 8073 | 24 | 0 |
628676 | 628676 | 2020-10-14 | Lincoln | Colorado | 8073 | 24 | 0 |
625433 | 625433 | 2020-10-13 | Lincoln | Colorado | 8073 | 24 | 0 |
622190 | 622190 | 2020-10-12 | Lincoln | Colorado | 8073 | 24 | 0 |
618947 | 618947 | 2020-10-11 | Lincoln | Colorado | 8073 | 24 | 0 |
615705 | 615705 | 2020-10-10 | Lincoln | Colorado | 8073 | 24 | 0 |
612464 | 612464 | 2020-10-09 | Lincoln | Colorado | 8073 | 24 | 0 |
586519 | 586519 | 2020-10-01 | Huerfano | Colorado | 8055 | 24 | 1 |
583279 | 583279 | 2020-09-30 | Huerfano | Colorado | 8055 | 24 | 1 |
580040 | 580040 | 2020-09-29 | Huerfano | Colorado | 8055 | 24 | 1 |
570322 | 570322 | 2020-09-26 | Las Animas | Colorado | 8071 | 24 | 0 |
547665 | 547665 | 2020-09-19 | Rio Blanco | Colorado | 8103 | 24 | 0 |
544427 | 544427 | 2020-09-18 | Rio Blanco | Colorado | 8103 | 24 | 0 |
541191 | 541191 | 2020-09-17 | Rio Blanco | Colorado | 8103 | 24 | 0 |
537954 | 537954 | 2020-09-16 | Rio Blanco | Colorado | 8103 | 24 | 0 |
534718 | 534718 | 2020-09-15 | Rio Blanco | Colorado | 8103 | 24 | 0 |
531483 | 531483 | 2020-09-14 | Rio Blanco | Colorado | 8103 | 24 | 0 |
528246 | 528246 | 2020-09-13 | Rio Blanco | Colorado | 8103 | 24 | 0 |
525010 | 525010 | 2020-09-12 | Rio Blanco | Colorado | 8103 | 24 | 0 |
521774 | 521774 | 2020-09-11 | Rio Blanco | Colorado | 8103 | 24 | 0 |
518537 | 518537 | 2020-09-10 | Rio Blanco | Colorado | 8103 | 24 | 0 |
515302 | 515302 | 2020-09-09 | Rio Blanco | Colorado | 8103 | 24 | 0 |
512069 | 512069 | 2020-09-08 | Rio Blanco | Colorado | 8103 | 24 | 0 |
508836 | 508836 | 2020-09-07 | Rio Blanco | Colorado | 8103 | 24 | 0 |
505604 | 505604 | 2020-09-06 | Rio Blanco | Colorado | 8103 | 24 | 0 |
502370 | 502370 | 2020-09-05 | Rio Blanco | Colorado | 8103 | 24 | 0 |
499136 | 499136 | 2020-09-04 | Rio Blanco | Colorado | 8103 | 24 | 0 |
495897 | 495897 | 2020-09-03 | Ouray | Colorado | 8091 | 24 | 1 |
495903 | 495903 | 2020-09-03 | Rio Blanco | Colorado | 8103 | 24 | 0 |
440946 | 440946 | 2020-08-17 | Costilla | Colorado | 8023 | 24 | 0 |
437720 | 437720 | 2020-08-16 | Costilla | Colorado | 8023 | 24 | 0 |
434494 | 434494 | 2020-08-15 | Costilla | Colorado | 8023 | 24 | 0 |
431269 | 431269 | 2020-08-14 | Costilla | Colorado | 8023 | 24 | 0 |
386223 | 386223 | 2020-07-31 | Moffat | Colorado | 8081 | 24 | 1 |
383005 | 383005 | 2020-07-30 | Moffat | Colorado | 8081 | 24 | 1 |
379788 | 379788 | 2020-07-29 | Moffat | Colorado | 8081 | 24 | 1 |
363691 | 363691 | 2020-07-24 | Archuleta | Colorado | 8007 | 24 | 0 |
363698 | 363698 | 2020-07-24 | Clear Creek | Colorado | 8019 | 24 | 1 |
360484 | 360484 | 2020-07-23 | Archuleta | Colorado | 8007 | 24 | 0 |
360491 | 360491 | 2020-07-23 | Clear Creek | Colorado | 8019 | 24 | 1 |
357279 | 357279 | 2020-07-22 | Archuleta | Colorado | 8007 | 24 | 0 |
357286 | 357286 | 2020-07-22 | Clear Creek | Colorado | 8019 | 24 | 1 |
354083 | 354083 | 2020-07-21 | Clear Creek | Colorado | 8019 | 24 | 1 |
350881 | 350881 | 2020-07-20 | Clear Creek | Colorado | 8019 | 24 | 1 |
350915 | 350915 | 2020-07-20 | Otero | Colorado | 8089 | 24 | 1 |
347714 | 347714 | 2020-07-19 | Otero | Colorado | 8089 | 24 | 1 |
344514 | 344514 | 2020-07-18 | Otero | Colorado | 8089 | 24 | 1 |
338118 | 338118 | 2020-07-16 | Otero | Colorado | 8089 | 24 | 1 |
299989 | 299989 | 2020-07-04 | Prowers | Colorado | 8099 | 24 | 0 |
296827 | 296827 | 2020-07-03 | Prowers | Colorado | 8099 | 24 | 0 |
259115 | 259115 | 2020-06-21 | Park | Colorado | 8093 | 24 | 0 |
240428 | 240428 | 2020-06-15 | San Miguel | Colorado | 8113 | 24 | 0 |
237320 | 237320 | 2020-06-14 | San Miguel | Colorado | 8113 | 24 | 0 |
234213 | 234213 | 2020-06-13 | San Miguel | Colorado | 8113 | 24 | 0 |
224892 | 224892 | 2020-06-10 | Park | Colorado | 8093 | 24 | 0 |
206368 | 206368 | 2020-06-04 | San Miguel | Colorado | 8113 | 24 | 0 |
203288 | 203288 | 2020-06-03 | San Miguel | Colorado | 8113 | 24 | 0 |
169652 | 169652 | 2020-05-23 | Saguache | Colorado | 8109 | 24 | 0 |
145467 | 145467 | 2020-05-15 | Lake | Colorado | 8065 | 24 | 0 |
133499 | 133499 | 2020-05-11 | Montezuma | Colorado | 8083 | 24 | 3 |
124521 | 124521 | 2020-05-08 | Kit Carson | Colorado | 8063 | 24 | 2 |
121541 | 121541 | 2020-05-07 | Kit Carson | Colorado | 8063 | 24 | 2 |
118572 | 118572 | 2020-05-06 | Kit Carson | Colorado | 8063 | 24 | 2 |
81502 | 81502 | 2020-04-23 | Logan | Colorado | 8075 | 24 | 1 |
78693 | 78693 | 2020-04-22 | Elbert | Colorado | 8039 | 24 | 1 |
78708 | 78708 | 2020-04-22 | Logan | Colorado | 8075 | 24 | 1 |
75909 | 75909 | 2020-04-21 | Elbert | Colorado | 8039 | 24 | 1 |
73133 | 73133 | 2020-04-20 | Elbert | Colorado | 8039 | 24 | 1 |
73168 | 73168 | 2020-04-20 | Teller | Colorado | 8119 | 24 | 2 |
70399 | 70399 | 2020-04-19 | Teller | Colorado | 8119 | 24 | 2 |
26327 | 26327 | 2020-04-02 | La Plata | Colorado | 8067 | 24 | 0 |
5264 | 5264 | 2020-03-20 | Boulder | Colorado | 8013 | 24 | 0 |
2362 | 2362 | 2020-03-15 | Eagle | Colorado | 8037 | 24 | 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);