ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64 rows where date = "2021-01-24" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
959627 | 959627 | 2021-01-24 | Adams | Colorado | 8001 | 45480 | 587 |
959628 | 959628 | 2021-01-24 | Alamosa | Colorado | 8003 | 1118 | 27 |
959629 | 959629 | 2021-01-24 | Arapahoe | Colorado | 8005 | 44488 | 644 |
959630 | 959630 | 2021-01-24 | Archuleta | Colorado | 8007 | 592 | 1 |
959631 | 959631 | 2021-01-24 | Baca | Colorado | 8009 | 262 | 3 |
959632 | 959632 | 2021-01-24 | Bent | Colorado | 8011 | 1283 | 20 |
959633 | 959633 | 2021-01-24 | Boulder | Colorado | 8013 | 16848 | 219 |
959634 | 959634 | 2021-01-24 | Broomfield | Colorado | 8014 | 3313 | 69 |
959635 | 959635 | 2021-01-24 | Chaffee | Colorado | 8015 | 1258 | 23 |
959636 | 959636 | 2021-01-24 | Cheyenne | Colorado | 8017 | 113 | 5 |
959637 | 959637 | 2021-01-24 | Clear Creek | Colorado | 8019 | 340 | 2 |
959638 | 959638 | 2021-01-24 | Conejos | Colorado | 8021 | 394 | 3 |
959639 | 959639 | 2021-01-24 | Costilla | Colorado | 8023 | 175 | 2 |
959640 | 959640 | 2021-01-24 | Crowley | Colorado | 8025 | 1764 | 14 |
959641 | 959641 | 2021-01-24 | Custer | Colorado | 8027 | 159 | 1 |
959642 | 959642 | 2021-01-24 | Delta | Colorado | 8029 | 2240 | 48 |
959643 | 959643 | 2021-01-24 | Denver | Colorado | 8031 | 54554 | 732 |
959644 | 959644 | 2021-01-24 | Dolores | Colorado | 8033 | 61 | 0 |
959645 | 959645 | 2021-01-24 | Douglas | Colorado | 8035 | 18710 | 224 |
959646 | 959646 | 2021-01-24 | Eagle | Colorado | 8037 | 4192 | 18 |
959647 | 959647 | 2021-01-24 | El Paso | Colorado | 8041 | 46875 | 685 |
959648 | 959648 | 2021-01-24 | Elbert | Colorado | 8039 | 1120 | 12 |
959649 | 959649 | 2021-01-24 | Fremont | Colorado | 8043 | 5075 | 35 |
959650 | 959650 | 2021-01-24 | Garfield | Colorado | 8045 | 4640 | 36 |
959651 | 959651 | 2021-01-24 | Gilpin | Colorado | 8047 | 144 | 2 |
959652 | 959652 | 2021-01-24 | Grand | Colorado | 8049 | 898 | 5 |
959653 | 959653 | 2021-01-24 | Gunnison | Colorado | 8051 | 987 | 6 |
959654 | 959654 | 2021-01-24 | Hinsdale | Colorado | 8053 | 15 | 0 |
959655 | 959655 | 2021-01-24 | Huerfano | Colorado | 8055 | 288 | 17 |
959656 | 959656 | 2021-01-24 | Jackson | Colorado | 8057 | 44 | 0 |
959657 | 959657 | 2021-01-24 | Jefferson | Colorado | 8059 | 33760 | 676 |
959658 | 959658 | 2021-01-24 | Kiowa | Colorado | 8061 | 85 | 3 |
959659 | 959659 | 2021-01-24 | Kit Carson | Colorado | 8063 | 496 | 10 |
959660 | 959660 | 2021-01-24 | La Plata | Colorado | 8067 | 2646 | 31 |
959661 | 959661 | 2021-01-24 | Lake | Colorado | 8065 | 487 | 0 |
959662 | 959662 | 2021-01-24 | Larimer | Colorado | 8069 | 17517 | 182 |
959663 | 959663 | 2021-01-24 | Las Animas | Colorado | 8071 | 899 | 10 |
959664 | 959664 | 2021-01-24 | Lincoln | Colorado | 8073 | 886 | 3 |
959665 | 959665 | 2021-01-24 | Logan | Colorado | 8075 | 3567 | 58 |
959666 | 959666 | 2021-01-24 | Mesa | Colorado | 8077 | 11539 | 161 |
959667 | 959667 | 2021-01-24 | Mineral | Colorado | 8079 | 57 | 1 |
959668 | 959668 | 2021-01-24 | Moffat | Colorado | 8081 | 610 | 23 |
959669 | 959669 | 2021-01-24 | Montezuma | Colorado | 8083 | 1579 | 21 |
959670 | 959670 | 2021-01-24 | Montrose | Colorado | 8085 | 2900 | 42 |
959671 | 959671 | 2021-01-24 | Morgan | Colorado | 8087 | 2338 | 87 |
959672 | 959672 | 2021-01-24 | Otero | Colorado | 8089 | 1777 | 57 |
959673 | 959673 | 2021-01-24 | Ouray | Colorado | 8091 | 186 | 3 |
959674 | 959674 | 2021-01-24 | Park | Colorado | 8093 | 471 | 5 |
959675 | 959675 | 2021-01-24 | Phillips | Colorado | 8095 | 319 | 11 |
959676 | 959676 | 2021-01-24 | Pitkin | Colorado | 8097 | 1761 | 4 |
959677 | 959677 | 2021-01-24 | Prowers | Colorado | 8099 | 1104 | 21 |
959678 | 959678 | 2021-01-24 | Pueblo | Colorado | 8101 | 14177 | 356 |
959679 | 959679 | 2021-01-24 | Rio Blanco | Colorado | 8103 | 377 | 3 |
959680 | 959680 | 2021-01-24 | Rio Grande | Colorado | 8105 | 587 | 10 |
959681 | 959681 | 2021-01-24 | Routt | Colorado | 8107 | 1503 | 19 |
959682 | 959682 | 2021-01-24 | Saguache | Colorado | 8109 | 290 | 4 |
959683 | 959683 | 2021-01-24 | San Juan | Colorado | 8111 | 40 | 0 |
959684 | 959684 | 2021-01-24 | San Miguel | Colorado | 8113 | 597 | 0 |
959685 | 959685 | 2021-01-24 | Sedgwick | Colorado | 8115 | 183 | 2 |
959686 | 959686 | 2021-01-24 | Summit | Colorado | 8117 | 2532 | 5 |
959687 | 959687 | 2021-01-24 | Teller | Colorado | 8119 | 1146 | 13 |
959688 | 959688 | 2021-01-24 | Washington | Colorado | 8121 | 364 | 11 |
959689 | 959689 | 2021-01-24 | Weld | Colorado | 8123 | 23106 | 301 |
959690 | 959690 | 2021-01-24 | Yuma | Colorado | 8125 | 644 | 15 |
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);