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 2020-11-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 |
---|---|---|---|---|---|---|---|
761662 | 761662 | 2020-11-24 | Adams | Colorado | 8001 | 26942 | 317 |
761663 | 761663 | 2020-11-24 | Alamosa | Colorado | 8003 | 526 | 12 |
761664 | 761664 | 2020-11-24 | Arapahoe | Colorado | 8005 | 24758 | 431 |
761665 | 761665 | 2020-11-24 | Archuleta | Colorado | 8007 | 167 | 0 |
761666 | 761666 | 2020-11-24 | Baca | Colorado | 8009 | 72 | 0 |
761667 | 761667 | 2020-11-24 | Bent | Colorado | 8011 | 79 | 1 |
761668 | 761668 | 2020-11-24 | Boulder | Colorado | 8013 | 10282 | 117 |
761669 | 761669 | 2020-11-24 | Broomfield | Colorado | 8014 | 1848 | 48 |
761670 | 761670 | 2020-11-24 | Chaffee | Colorado | 8015 | 590 | 21 |
761671 | 761671 | 2020-11-24 | Cheyenne | Colorado | 8017 | 51 | 0 |
761672 | 761672 | 2020-11-24 | Clear Creek | Colorado | 8019 | 172 | 2 |
761673 | 761673 | 2020-11-24 | Conejos | Colorado | 8021 | 154 | 3 |
761674 | 761674 | 2020-11-24 | Costilla | Colorado | 8023 | 69 | 1 |
761675 | 761675 | 2020-11-24 | Crowley | Colorado | 8025 | 1011 | 2 |
761676 | 761676 | 2020-11-24 | Custer | Colorado | 8027 | 59 | 0 |
761677 | 761677 | 2020-11-24 | Delta | Colorado | 8029 | 511 | 8 |
761678 | 761678 | 2020-11-24 | Denver | Colorado | 8031 | 33971 | 510 |
761679 | 761679 | 2020-11-24 | Dolores | Colorado | 8033 | 11 | 0 |
761680 | 761680 | 2020-11-24 | Douglas | Colorado | 8035 | 9593 | 98 |
761681 | 761681 | 2020-11-24 | Eagle | Colorado | 8037 | 2155 | 11 |
761682 | 761682 | 2020-11-24 | El Paso | Colorado | 8041 | 23923 | 258 |
761683 | 761683 | 2020-11-24 | Elbert | Colorado | 8039 | 534 | 5 |
761684 | 761684 | 2020-11-24 | Fremont | Colorado | 8043 | 2296 | 3 |
761685 | 761685 | 2020-11-24 | Garfield | Colorado | 8045 | 1974 | 6 |
761686 | 761686 | 2020-11-24 | Gilpin | Colorado | 8047 | 75 | 0 |
761687 | 761687 | 2020-11-24 | Grand | Colorado | 8049 | 333 | 1 |
761688 | 761688 | 2020-11-24 | Gunnison | Colorado | 8051 | 447 | 7 |
761689 | 761689 | 2020-11-24 | Hinsdale | Colorado | 8053 | 7 | 0 |
761690 | 761690 | 2020-11-24 | Huerfano | Colorado | 8055 | 121 | 4 |
761691 | 761691 | 2020-11-24 | Jackson | Colorado | 8057 | 18 | 0 |
761692 | 761692 | 2020-11-24 | Jefferson | Colorado | 8059 | 18369 | 425 |
761693 | 761693 | 2020-11-24 | Kiowa | Colorado | 8061 | 21 | 0 |
761694 | 761694 | 2020-11-24 | Kit Carson | Colorado | 8063 | 251 | 7 |
761695 | 761695 | 2020-11-24 | La Plata | Colorado | 8067 | 1039 | 3 |
761696 | 761696 | 2020-11-24 | Lake | Colorado | 8065 | 248 | 0 |
761697 | 761697 | 2020-11-24 | Larimer | Colorado | 8069 | 9029 | 67 |
761698 | 761698 | 2020-11-24 | Las Animas | Colorado | 8071 | 186 | 0 |
761699 | 761699 | 2020-11-24 | Lincoln | Colorado | 8073 | 117 | 0 |
761700 | 761700 | 2020-11-24 | Logan | Colorado | 8075 | 2042 | 29 |
761701 | 761701 | 2020-11-24 | Mesa | Colorado | 8077 | 5051 | 50 |
761702 | 761702 | 2020-11-24 | Mineral | Colorado | 8079 | 32 | 0 |
761703 | 761703 | 2020-11-24 | Moffat | Colorado | 8081 | 243 | 2 |
761704 | 761704 | 2020-11-24 | Montezuma | Colorado | 8083 | 609 | 6 |
761705 | 761705 | 2020-11-24 | Montrose | Colorado | 8085 | 868 | 15 |
761706 | 761706 | 2020-11-24 | Morgan | Colorado | 8087 | 1499 | 51 |
761707 | 761707 | 2020-11-24 | Otero | Colorado | 8089 | 458 | 9 |
761708 | 761708 | 2020-11-24 | Ouray | Colorado | 8091 | 113 | 2 |
761709 | 761709 | 2020-11-24 | Park | Colorado | 8093 | 205 | 4 |
761710 | 761710 | 2020-11-24 | Phillips | Colorado | 8095 | 164 | 2 |
761711 | 761711 | 2020-11-24 | Pitkin | Colorado | 8097 | 442 | 2 |
761712 | 761712 | 2020-11-24 | Prowers | Colorado | 8099 | 534 | 12 |
761713 | 761713 | 2020-11-24 | Pueblo | Colorado | 8101 | 7195 | 96 |
761714 | 761714 | 2020-11-24 | Rio Blanco | Colorado | 8103 | 109 | 1 |
761715 | 761715 | 2020-11-24 | Rio Grande | Colorado | 8105 | 205 | 4 |
761716 | 761716 | 2020-11-24 | Routt | Colorado | 8107 | 560 | 10 |
761717 | 761717 | 2020-11-24 | Saguache | Colorado | 8109 | 201 | 2 |
761718 | 761718 | 2020-11-24 | San Juan | Colorado | 8111 | 20 | 0 |
761719 | 761719 | 2020-11-24 | San Miguel | Colorado | 8113 | 186 | 0 |
761720 | 761720 | 2020-11-24 | Sedgwick | Colorado | 8115 | 97 | 1 |
761721 | 761721 | 2020-11-24 | Summit | Colorado | 8117 | 1366 | 4 |
761722 | 761722 | 2020-11-24 | Teller | Colorado | 8119 | 559 | 4 |
761723 | 761723 | 2020-11-24 | Washington | Colorado | 8121 | 199 | 5 |
761724 | 761724 | 2020-11-24 | Weld | Colorado | 8123 | 12611 | 188 |
761725 | 761725 | 2020-11-24 | Yuma | Colorado | 8125 | 305 | 1 |
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);