ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64 rows where date = "2021-08-23" 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 |
---|---|---|---|---|---|---|---|
1644677 | 1644677 | 2021-08-23 | Adams | Colorado | 8001 | 66377 | 783 |
1644678 | 1644678 | 2021-08-23 | Alamosa | Colorado | 8003 | 1870 | 39 |
1644679 | 1644679 | 2021-08-23 | Arapahoe | Colorado | 8005 | 68888 | 849 |
1644680 | 1644680 | 2021-08-23 | Archuleta | Colorado | 8007 | 1230 | 2 |
1644681 | 1644681 | 2021-08-23 | Baca | Colorado | 8009 | 352 | 4 |
1644682 | 1644682 | 2021-08-23 | Bent | Colorado | 8011 | 1554 | 22 |
1644683 | 1644683 | 2021-08-23 | Boulder | Colorado | 8013 | 25977 | 264 |
1644684 | 1644684 | 2021-08-23 | Broomfield | Colorado | 8014 | 5509 | 77 |
1644685 | 1644685 | 2021-08-23 | Chaffee | Colorado | 8015 | 1913 | 25 |
1644686 | 1644686 | 2021-08-23 | Cheyenne | Colorado | 8017 | 145 | 7 |
1644687 | 1644687 | 2021-08-23 | Clear Creek | Colorado | 8019 | 546 | 3 |
1644688 | 1644688 | 2021-08-23 | Conejos | Colorado | 8021 | 780 | 27 |
1644689 | 1644689 | 2021-08-23 | Costilla | Colorado | 8023 | 266 | 5 |
1644690 | 1644690 | 2021-08-23 | Crowley | Colorado | 8025 | 2224 | 18 |
1644691 | 1644691 | 2021-08-23 | Custer | Colorado | 8027 | 251 | 6 |
1644692 | 1644692 | 2021-08-23 | Delta | Colorado | 8029 | 3217 | 76 |
1644693 | 1644693 | 2021-08-23 | Denver | Colorado | 8031 | 79469 | 867 |
1644694 | 1644694 | 2021-08-23 | Dolores | Colorado | 8033 | 141 | 1 |
1644695 | 1644695 | 2021-08-23 | Douglas | Colorado | 8035 | 33854 | 276 |
1644696 | 1644696 | 2021-08-23 | Eagle | Colorado | 8037 | 6991 | 26 |
1644697 | 1644697 | 2021-08-23 | El Paso | Colorado | 8041 | 80513 | 930 |
1644698 | 1644698 | 2021-08-23 | Elbert | Colorado | 8039 | 2031 | 16 |
1644699 | 1644699 | 2021-08-23 | Fremont | Colorado | 8043 | 6792 | 68 |
1644700 | 1644700 | 2021-08-23 | Garfield | Colorado | 8045 | 6666 | 56 |
1644701 | 1644701 | 2021-08-23 | Gilpin | Colorado | 8047 | 315 | 3 |
1644702 | 1644702 | 2021-08-23 | Grand | Colorado | 8049 | 1617 | 7 |
1644703 | 1644703 | 2021-08-23 | Gunnison | Colorado | 8051 | 1506 | 7 |
1644704 | 1644704 | 2021-08-23 | Hinsdale | Colorado | 8053 | 40 | 0 |
1644705 | 1644705 | 2021-08-23 | Huerfano | Colorado | 8055 | 480 | 18 |
1644706 | 1644706 | 2021-08-23 | Jackson | Colorado | 8057 | 69 | 0 |
1644707 | 1644707 | 2021-08-23 | Jefferson | Colorado | 8059 | 52599 | 827 |
1644708 | 1644708 | 2021-08-23 | Kiowa | Colorado | 8061 | 103 | 3 |
1644709 | 1644709 | 2021-08-23 | Kit Carson | Colorado | 8063 | 711 | 14 |
1644710 | 1644710 | 2021-08-23 | La Plata | Colorado | 8067 | 4623 | 45 |
1644711 | 1644711 | 2021-08-23 | Lake | Colorado | 8065 | 889 | 1 |
1644712 | 1644712 | 2021-08-23 | Larimer | Colorado | 8069 | 30714 | 252 |
1644713 | 1644713 | 2021-08-23 | Las Animas | Colorado | 8071 | 1399 | 15 |
1644714 | 1644714 | 2021-08-23 | Lincoln | Colorado | 8073 | 1078 | 4 |
1644715 | 1644715 | 2021-08-23 | Logan | Colorado | 8075 | 4141 | 69 |
1644716 | 1644716 | 2021-08-23 | Mesa | Colorado | 8077 | 18963 | 278 |
1644717 | 1644717 | 2021-08-23 | Mineral | Colorado | 8079 | 100 | 1 |
1644718 | 1644718 | 2021-08-23 | Moffat | Colorado | 8081 | 1261 | 30 |
1644719 | 1644719 | 2021-08-23 | Montezuma | Colorado | 8083 | 2302 | 28 |
1644720 | 1644720 | 2021-08-23 | Montrose | Colorado | 8085 | 4215 | 72 |
1644721 | 1644721 | 2021-08-23 | Morgan | Colorado | 8087 | 2849 | 96 |
1644722 | 1644722 | 2021-08-23 | Otero | Colorado | 8089 | 2128 | 68 |
1644723 | 1644723 | 2021-08-23 | Ouray | Colorado | 8091 | 342 | 5 |
1644724 | 1644724 | 2021-08-23 | Park | Colorado | 8093 | 967 | 6 |
1644725 | 1644725 | 2021-08-23 | Phillips | Colorado | 8095 | 414 | 13 |
1644726 | 1644726 | 2021-08-23 | Pitkin | Colorado | 8097 | 2773 | 5 |
1644727 | 1644727 | 2021-08-23 | Prowers | Colorado | 8099 | 1338 | 24 |
1644728 | 1644728 | 2021-08-23 | Pueblo | Colorado | 8101 | 20555 | 432 |
1644729 | 1644729 | 2021-08-23 | Rio Blanco | Colorado | 8103 | 726 | 5 |
1644730 | 1644730 | 2021-08-23 | Rio Grande | Colorado | 8105 | 1003 | 20 |
1644731 | 1644731 | 2021-08-23 | Routt | Colorado | 8107 | 2598 | 21 |
1644732 | 1644732 | 2021-08-23 | Saguache | Colorado | 8109 | 489 | 8 |
1644733 | 1644733 | 2021-08-23 | San Juan | Colorado | 8111 | 85 | 0 |
1644734 | 1644734 | 2021-08-23 | San Miguel | Colorado | 8113 | 991 | 1 |
1644735 | 1644735 | 2021-08-23 | Sedgwick | Colorado | 8115 | 256 | 3 |
1644736 | 1644736 | 2021-08-23 | Summit | Colorado | 8117 | 4229 | 8 |
1644737 | 1644737 | 2021-08-23 | Teller | Colorado | 8119 | 2057 | 19 |
1644738 | 1644738 | 2021-08-23 | Washington | Colorado | 8121 | 483 | 13 |
1644739 | 1644739 | 2021-08-23 | Weld | Colorado | 8123 | 36555 | 360 |
1644740 | 1644740 | 2021-08-23 | Yuma | Colorado | 8125 | 998 | 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);