ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
61 rows where date = "2020-05-22" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
fips >30
county >30
- Adams 1
- Alamosa 1
- Arapahoe 1
- Archuleta 1
- Baca 1
- Bent 1
- Boulder 1
- Broomfield 1
- Chaffee 1
- Cheyenne 1
- Clear Creek 1
- Conejos 1
- Costilla 1
- Crowley 1
- Custer 1
- Delta 1
- Denver 1
- Douglas 1
- Eagle 1
- El Paso 1
- Elbert 1
- Fremont 1
- Garfield 1
- Gilpin 1
- Grand 1
- Gunnison 1
- Hinsdale 1
- Huerfano 1
- Jefferson 1
- Kit Carson 1
- …
state 1
- Colorado · 61 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
166563 | 166563 | 2020-05-22 | Adams | Colorado | 8001 | 2802 | 111 |
166564 | 166564 | 2020-05-22 | Alamosa | Colorado | 8003 | 51 | 2 |
166565 | 166565 | 2020-05-22 | Arapahoe | Colorado | 8005 | 3974 | 276 |
166566 | 166566 | 2020-05-22 | Archuleta | Colorado | 8007 | 8 | 0 |
166567 | 166567 | 2020-05-22 | Baca | Colorado | 8009 | 12 | 0 |
166568 | 166568 | 2020-05-22 | Bent | Colorado | 8011 | 2 | 0 |
166569 | 166569 | 2020-05-22 | Boulder | Colorado | 8013 | 898 | 61 |
166570 | 166570 | 2020-05-22 | Broomfield | Colorado | 8014 | 220 | 25 |
166571 | 166571 | 2020-05-22 | Chaffee | Colorado | 8015 | 69 | 18 |
166572 | 166572 | 2020-05-22 | Cheyenne | Colorado | 8017 | 5 | 0 |
166573 | 166573 | 2020-05-22 | Clear Creek | Colorado | 8019 | 16 | 1 |
166574 | 166574 | 2020-05-22 | Conejos | Colorado | 8021 | 1 | 0 |
166575 | 166575 | 2020-05-22 | Costilla | Colorado | 8023 | 3 | 0 |
166576 | 166576 | 2020-05-22 | Crowley | Colorado | 8025 | 44 | 1 |
166577 | 166577 | 2020-05-22 | Custer | Colorado | 8027 | 2 | 0 |
166578 | 166578 | 2020-05-22 | Delta | Colorado | 8029 | 61 | 1 |
166579 | 166579 | 2020-05-22 | Denver | Colorado | 8031 | 5056 | 299 |
166580 | 166580 | 2020-05-22 | Douglas | Colorado | 8035 | 669 | 43 |
166581 | 166581 | 2020-05-22 | Eagle | Colorado | 8037 | 577 | 8 |
166582 | 166582 | 2020-05-22 | El Paso | Colorado | 8041 | 1460 | 88 |
166583 | 166583 | 2020-05-22 | Elbert | Colorado | 8039 | 48 | 2 |
166584 | 166584 | 2020-05-22 | Fremont | Colorado | 8043 | 26 | 0 |
166585 | 166585 | 2020-05-22 | Garfield | Colorado | 8045 | 120 | 2 |
166586 | 166586 | 2020-05-22 | Gilpin | Colorado | 8047 | 3 | 0 |
166587 | 166587 | 2020-05-22 | Grand | Colorado | 8049 | 5 | 0 |
166588 | 166588 | 2020-05-22 | Gunnison | Colorado | 8051 | 177 | 6 |
166589 | 166589 | 2020-05-22 | Hinsdale | Colorado | 8053 | 3 | 0 |
166590 | 166590 | 2020-05-22 | Huerfano | Colorado | 8055 | 3 | 0 |
166591 | 166591 | 2020-05-22 | Jefferson | Colorado | 8059 | 1999 | 142 |
166592 | 166592 | 2020-05-22 | Kit Carson | Colorado | 8063 | 26 | 3 |
166593 | 166593 | 2020-05-22 | La Plata | Colorado | 8067 | 73 | 1 |
166594 | 166594 | 2020-05-22 | Lake | Colorado | 8065 | 27 | 0 |
166595 | 166595 | 2020-05-22 | Larimer | Colorado | 8069 | 520 | 21 |
166596 | 166596 | 2020-05-22 | Las Animas | Colorado | 8071 | 5 | 0 |
166597 | 166597 | 2020-05-22 | Lincoln | Colorado | 8073 | 3 | 0 |
166598 | 166598 | 2020-05-22 | Logan | Colorado | 8075 | 491 | 3 |
166599 | 166599 | 2020-05-22 | Mesa | Colorado | 8077 | 50 | 0 |
166600 | 166600 | 2020-05-22 | Mineral | Colorado | 8079 | 2 | 0 |
166601 | 166601 | 2020-05-22 | Moffat | Colorado | 8081 | 6 | 0 |
166602 | 166602 | 2020-05-22 | Montezuma | Colorado | 8083 | 35 | 3 |
166603 | 166603 | 2020-05-22 | Montrose | Colorado | 8085 | 152 | 12 |
166604 | 166604 | 2020-05-22 | Morgan | Colorado | 8087 | 591 | 40 |
166605 | 166605 | 2020-05-22 | Otero | Colorado | 8089 | 14 | 1 |
166606 | 166606 | 2020-05-22 | Ouray | Colorado | 8091 | 7 | 1 |
166607 | 166607 | 2020-05-22 | Park | Colorado | 8093 | 21 | 0 |
166608 | 166608 | 2020-05-22 | Phillips | Colorado | 8095 | 10 | 0 |
166609 | 166609 | 2020-05-22 | Pitkin | Colorado | 8097 | 57 | 2 |
166610 | 166610 | 2020-05-22 | Prowers | Colorado | 8099 | 11 | 0 |
166611 | 166611 | 2020-05-22 | Pueblo | Colorado | 8101 | 233 | 14 |
166612 | 166612 | 2020-05-22 | Rio Blanco | Colorado | 8103 | 1 | 0 |
166613 | 166613 | 2020-05-22 | Rio Grande | Colorado | 8105 | 15 | 1 |
166614 | 166614 | 2020-05-22 | Routt | Colorado | 8107 | 59 | 6 |
166615 | 166615 | 2020-05-22 | Saguache | Colorado | 8109 | 23 | 0 |
166616 | 166616 | 2020-05-22 | San Juan | Colorado | 8111 | 1 | 0 |
166617 | 166617 | 2020-05-22 | San Miguel | Colorado | 8113 | 23 | 0 |
166618 | 166618 | 2020-05-22 | Summit | Colorado | 8117 | 197 | 2 |
166619 | 166619 | 2020-05-22 | Teller | Colorado | 8119 | 32 | 2 |
166620 | 166620 | 2020-05-22 | Unknown | Colorado | 63 | 1 | |
166621 | 166621 | 2020-05-22 | Washington | Colorado | 8121 | 15 | 0 |
166622 | 166622 | 2020-05-22 | Weld | Colorado | 8123 | 2367 | 125 |
166623 | 166623 | 2020-05-22 | Yuma | Colorado | 8125 | 12 | 0 |
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);