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-10-18 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1826606 | 1826606 | 2021-10-18 | Adams | Colorado | 8001 | 75092 | 868 |
1826607 | 1826607 | 2021-10-18 | Alamosa | Colorado | 8003 | 2364 | 44 |
1826608 | 1826608 | 2021-10-18 | Arapahoe | Colorado | 8005 | 79122 | 917 |
1826609 | 1826609 | 2021-10-18 | Archuleta | Colorado | 8007 | 1444 | 4 |
1826610 | 1826610 | 2021-10-18 | Baca | Colorado | 8009 | 422 | 5 |
1826611 | 1826611 | 2021-10-18 | Bent | Colorado | 8011 | 1681 | 23 |
1826612 | 1826612 | 2021-10-18 | Boulder | Colorado | 8013 | 30227 | 275 |
1826613 | 1826613 | 2021-10-18 | Broomfield | Colorado | 8014 | 6508 | 81 |
1826614 | 1826614 | 2021-10-18 | Chaffee | Colorado | 8015 | 2186 | 30 |
1826615 | 1826615 | 2021-10-18 | Cheyenne | Colorado | 8017 | 170 | 7 |
1826616 | 1826616 | 2021-10-18 | Clear Creek | Colorado | 8019 | 754 | 5 |
1826617 | 1826617 | 2021-10-18 | Conejos | Colorado | 8021 | 976 | 32 |
1826618 | 1826618 | 2021-10-18 | Costilla | Colorado | 8023 | 369 | 10 |
1826619 | 1826619 | 2021-10-18 | Crowley | Colorado | 8025 | 2365 | 22 |
1826620 | 1826620 | 2021-10-18 | Custer | Colorado | 8027 | 348 | 6 |
1826621 | 1826621 | 2021-10-18 | Delta | Colorado | 8029 | 3820 | 80 |
1826622 | 1826622 | 2021-10-18 | Denver | Colorado | 8031 | 89363 | 925 |
1826623 | 1826623 | 2021-10-18 | Dolores | Colorado | 8033 | 230 | 2 |
1826624 | 1826624 | 2021-10-18 | Douglas | Colorado | 8035 | 39969 | 313 |
1826625 | 1826625 | 2021-10-18 | Eagle | Colorado | 8037 | 8184 | 31 |
1826626 | 1826626 | 2021-10-18 | El Paso | Colorado | 8041 | 97962 | 1068 |
1826627 | 1826627 | 2021-10-18 | Elbert | Colorado | 8039 | 2622 | 22 |
1826628 | 1826628 | 2021-10-18 | Fremont | Colorado | 8043 | 8137 | 85 |
1826629 | 1826629 | 2021-10-18 | Garfield | Colorado | 8045 | 7705 | 60 |
1826630 | 1826630 | 2021-10-18 | Gilpin | Colorado | 8047 | 417 | 3 |
1826631 | 1826631 | 2021-10-18 | Grand | Colorado | 8049 | 2123 | 15 |
1826632 | 1826632 | 2021-10-18 | Gunnison | Colorado | 8051 | 1808 | 11 |
1826633 | 1826633 | 2021-10-18 | Hinsdale | Colorado | 8053 | 55 | 0 |
1826634 | 1826634 | 2021-10-18 | Huerfano | Colorado | 8055 | 607 | 19 |
1826635 | 1826635 | 2021-10-18 | Jackson | Colorado | 8057 | 107 | 0 |
1826636 | 1826636 | 2021-10-18 | Jefferson | Colorado | 8059 | 61245 | 896 |
1826637 | 1826637 | 2021-10-18 | Kiowa | Colorado | 8061 | 192 | 4 |
1826638 | 1826638 | 2021-10-18 | Kit Carson | Colorado | 8063 | 937 | 15 |
1826639 | 1826639 | 2021-10-18 | La Plata | Colorado | 8067 | 5601 | 52 |
1826640 | 1826640 | 2021-10-18 | Lake | Colorado | 8065 | 1002 | 1 |
1826641 | 1826641 | 2021-10-18 | Larimer | Colorado | 8069 | 37702 | 298 |
1826642 | 1826642 | 2021-10-18 | Las Animas | Colorado | 8071 | 1747 | 21 |
1826643 | 1826643 | 2021-10-18 | Lincoln | Colorado | 8073 | 1294 | 8 |
1826644 | 1826644 | 2021-10-18 | Logan | Colorado | 8075 | 4604 | 79 |
1826645 | 1826645 | 2021-10-18 | Mesa | Colorado | 8077 | 23136 | 319 |
1826646 | 1826646 | 2021-10-18 | Mineral | Colorado | 8079 | 124 | 1 |
1826647 | 1826647 | 2021-10-18 | Moffat | Colorado | 8081 | 1912 | 40 |
1826648 | 1826648 | 2021-10-18 | Montezuma | Colorado | 8083 | 2971 | 36 |
1826649 | 1826649 | 2021-10-18 | Montrose | Colorado | 8085 | 5155 | 83 |
1826650 | 1826650 | 2021-10-18 | Morgan | Colorado | 8087 | 3303 | 98 |
1826651 | 1826651 | 2021-10-18 | Otero | Colorado | 8089 | 2582 | 79 |
1826652 | 1826652 | 2021-10-18 | Ouray | Colorado | 8091 | 423 | 5 |
1826653 | 1826653 | 2021-10-18 | Park | Colorado | 8093 | 1335 | 8 |
1826654 | 1826654 | 2021-10-18 | Phillips | Colorado | 8095 | 506 | 14 |
1826655 | 1826655 | 2021-10-18 | Pitkin | Colorado | 8097 | 3087 | 5 |
1826656 | 1826656 | 2021-10-18 | Prowers | Colorado | 8099 | 1592 | 29 |
1826657 | 1826657 | 2021-10-18 | Pueblo | Colorado | 8101 | 24164 | 474 |
1826658 | 1826658 | 2021-10-18 | Rio Blanco | Colorado | 8103 | 927 | 8 |
1826659 | 1826659 | 2021-10-18 | Rio Grande | Colorado | 8105 | 1445 | 21 |
1826660 | 1826660 | 2021-10-18 | Routt | Colorado | 8107 | 3266 | 23 |
1826661 | 1826661 | 2021-10-18 | Saguache | Colorado | 8109 | 661 | 8 |
1826662 | 1826662 | 2021-10-18 | San Juan | Colorado | 8111 | 95 | 1 |
1826663 | 1826663 | 2021-10-18 | San Miguel | Colorado | 8113 | 1161 | 4 |
1826664 | 1826664 | 2021-10-18 | Sedgwick | Colorado | 8115 | 308 | 4 |
1826665 | 1826665 | 2021-10-18 | Summit | Colorado | 8117 | 4711 | 11 |
1826666 | 1826666 | 2021-10-18 | Teller | Colorado | 8119 | 2744 | 25 |
1826667 | 1826667 | 2021-10-18 | Washington | Colorado | 8121 | 619 | 15 |
1826668 | 1826668 | 2021-10-18 | Weld | Colorado | 8123 | 44879 | 433 |
1826669 | 1826669 | 2021-10-18 | Yuma | Colorado | 8125 | 1196 | 18 |
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);