ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64 rows where date = "2020-12-20" 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 |
---|---|---|---|---|---|---|---|
846042 | 846042 | 2020-12-20 | Adams | Colorado | 8001 | 37620 | 477 |
846043 | 846043 | 2020-12-20 | Alamosa | Colorado | 8003 | 879 | 21 |
846044 | 846044 | 2020-12-20 | Arapahoe | Colorado | 8005 | 35699 | 547 |
846045 | 846045 | 2020-12-20 | Archuleta | Colorado | 8007 | 433 | 0 |
846046 | 846046 | 2020-12-20 | Baca | Colorado | 8009 | 163 | 0 |
846047 | 846047 | 2020-12-20 | Bent | Colorado | 8011 | 877 | 10 |
846048 | 846048 | 2020-12-20 | Boulder | Colorado | 8013 | 13775 | 166 |
846049 | 846049 | 2020-12-20 | Broomfield | Colorado | 8014 | 2583 | 62 |
846050 | 846050 | 2020-12-20 | Chaffee | Colorado | 8015 | 917 | 21 |
846051 | 846051 | 2020-12-20 | Cheyenne | Colorado | 8017 | 86 | 3 |
846052 | 846052 | 2020-12-20 | Clear Creek | Colorado | 8019 | 254 | 2 |
846053 | 846053 | 2020-12-20 | Conejos | Colorado | 8021 | 287 | 3 |
846054 | 846054 | 2020-12-20 | Costilla | Colorado | 8023 | 149 | 2 |
846055 | 846055 | 2020-12-20 | Crowley | Colorado | 8025 | 1578 | 12 |
846056 | 846056 | 2020-12-20 | Custer | Colorado | 8027 | 144 | 0 |
846057 | 846057 | 2020-12-20 | Delta | Colorado | 8029 | 1244 | 20 |
846058 | 846058 | 2020-12-20 | Denver | Colorado | 8031 | 44854 | 650 |
846059 | 846059 | 2020-12-20 | Dolores | Colorado | 8033 | 48 | 0 |
846060 | 846060 | 2020-12-20 | Douglas | Colorado | 8035 | 14702 | 170 |
846061 | 846061 | 2020-12-20 | Eagle | Colorado | 8037 | 3082 | 12 |
846062 | 846062 | 2020-12-20 | El Paso | Colorado | 8041 | 37984 | 484 |
846063 | 846063 | 2020-12-20 | Elbert | Colorado | 8039 | 893 | 7 |
846064 | 846064 | 2020-12-20 | Fremont | Colorado | 8043 | 4110 | 14 |
846065 | 846065 | 2020-12-20 | Garfield | Colorado | 8045 | 3461 | 24 |
846066 | 846066 | 2020-12-20 | Gilpin | Colorado | 8047 | 113 | 1 |
846067 | 846067 | 2020-12-20 | Grand | Colorado | 8049 | 594 | 4 |
846068 | 846068 | 2020-12-20 | Gunnison | Colorado | 8051 | 602 | 5 |
846069 | 846069 | 2020-12-20 | Hinsdale | Colorado | 8053 | 12 | 0 |
846070 | 846070 | 2020-12-20 | Huerfano | Colorado | 8055 | 256 | 15 |
846071 | 846071 | 2020-12-20 | Jackson | Colorado | 8057 | 29 | 0 |
846072 | 846072 | 2020-12-20 | Jefferson | Colorado | 8059 | 27481 | 589 |
846073 | 846073 | 2020-12-20 | Kiowa | Colorado | 8061 | 67 | 2 |
846074 | 846074 | 2020-12-20 | Kit Carson | Colorado | 8063 | 418 | 8 |
846075 | 846075 | 2020-12-20 | La Plata | Colorado | 8067 | 2069 | 22 |
846076 | 846076 | 2020-12-20 | Lake | Colorado | 8065 | 391 | 0 |
846077 | 846077 | 2020-12-20 | Larimer | Colorado | 8069 | 14031 | 112 |
846078 | 846078 | 2020-12-20 | Las Animas | Colorado | 8071 | 412 | 3 |
846079 | 846079 | 2020-12-20 | Lincoln | Colorado | 8073 | 749 | 2 |
846080 | 846080 | 2020-12-20 | Logan | Colorado | 8075 | 3043 | 52 |
846081 | 846081 | 2020-12-20 | Mesa | Colorado | 8077 | 8230 | 119 |
846082 | 846082 | 2020-12-20 | Mineral | Colorado | 8079 | 38 | 1 |
846083 | 846083 | 2020-12-20 | Moffat | Colorado | 8081 | 490 | 18 |
846084 | 846084 | 2020-12-20 | Montezuma | Colorado | 8083 | 1124 | 15 |
846085 | 846085 | 2020-12-20 | Montrose | Colorado | 8085 | 1836 | 28 |
846086 | 846086 | 2020-12-20 | Morgan | Colorado | 8087 | 2013 | 69 |
846087 | 846087 | 2020-12-20 | Otero | Colorado | 8089 | 1496 | 27 |
846088 | 846088 | 2020-12-20 | Ouray | Colorado | 8091 | 147 | 3 |
846089 | 846089 | 2020-12-20 | Park | Colorado | 8093 | 348 | 4 |
846090 | 846090 | 2020-12-20 | Phillips | Colorado | 8095 | 218 | 4 |
846091 | 846091 | 2020-12-20 | Pitkin | Colorado | 8097 | 838 | 3 |
846092 | 846092 | 2020-12-20 | Prowers | Colorado | 8099 | 930 | 19 |
846093 | 846093 | 2020-12-20 | Pueblo | Colorado | 8101 | 12320 | 267 |
846094 | 846094 | 2020-12-20 | Rio Blanco | Colorado | 8103 | 252 | 2 |
846095 | 846095 | 2020-12-20 | Rio Grande | Colorado | 8105 | 358 | 5 |
846096 | 846096 | 2020-12-20 | Routt | Colorado | 8107 | 951 | 18 |
846097 | 846097 | 2020-12-20 | Saguache | Colorado | 8109 | 246 | 4 |
846098 | 846098 | 2020-12-20 | San Juan | Colorado | 8111 | 28 | 0 |
846099 | 846099 | 2020-12-20 | San Miguel | Colorado | 8113 | 371 | 0 |
846100 | 846100 | 2020-12-20 | Sedgwick | Colorado | 8115 | 122 | 2 |
846101 | 846101 | 2020-12-20 | Summit | Colorado | 8117 | 1939 | 5 |
846102 | 846102 | 2020-12-20 | Teller | Colorado | 8119 | 919 | 7 |
846103 | 846103 | 2020-12-20 | Washington | Colorado | 8121 | 333 | 10 |
846104 | 846104 | 2020-12-20 | Weld | Colorado | 8123 | 18390 | 262 |
846105 | 846105 | 2020-12-20 | Yuma | Colorado | 8125 | 496 | 6 |
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);