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 2021-02-23 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1056996 | 1056996 | 2021-02-23 | Adams | Colorado | 8001 | 48791 | 627 |
1056997 | 1056997 | 2021-02-23 | Alamosa | Colorado | 8003 | 1263 | 28 |
1056998 | 1056998 | 2021-02-23 | Arapahoe | Colorado | 8005 | 48820 | 688 |
1056999 | 1056999 | 2021-02-23 | Archuleta | Colorado | 8007 | 633 | 1 |
1057000 | 1057000 | 2021-02-23 | Baca | Colorado | 8009 | 270 | 4 |
1057001 | 1057001 | 2021-02-23 | Bent | Colorado | 8011 | 1469 | 21 |
1057002 | 1057002 | 2021-02-23 | Boulder | Colorado | 8013 | 18659 | 246 |
1057003 | 1057003 | 2021-02-23 | Broomfield | Colorado | 8014 | 3669 | 74 |
1057004 | 1057004 | 2021-02-23 | Chaffee | Colorado | 8015 | 1419 | 23 |
1057005 | 1057005 | 2021-02-23 | Cheyenne | Colorado | 8017 | 125 | 5 |
1057006 | 1057006 | 2021-02-23 | Clear Creek | Colorado | 8019 | 359 | 2 |
1057007 | 1057007 | 2021-02-23 | Conejos | Colorado | 8021 | 437 | 8 |
1057008 | 1057008 | 2021-02-23 | Costilla | Colorado | 8023 | 182 | 2 |
1057009 | 1057009 | 2021-02-23 | Crowley | Colorado | 8025 | 1962 | 14 |
1057010 | 1057010 | 2021-02-23 | Custer | Colorado | 8027 | 164 | 1 |
1057011 | 1057011 | 2021-02-23 | Delta | Colorado | 8029 | 2447 | 58 |
1057012 | 1057012 | 2021-02-23 | Denver | Colorado | 8031 | 58929 | 766 |
1057013 | 1057013 | 2021-02-23 | Dolores | Colorado | 8033 | 67 | 0 |
1057014 | 1057014 | 2021-02-23 | Douglas | Colorado | 8035 | 21405 | 230 |
1057015 | 1057015 | 2021-02-23 | Eagle | Colorado | 8037 | 4940 | 20 |
1057016 | 1057016 | 2021-02-23 | El Paso | Colorado | 8041 | 51293 | 742 |
1057017 | 1057017 | 2021-02-23 | Elbert | Colorado | 8039 | 1263 | 12 |
1057018 | 1057018 | 2021-02-23 | Fremont | Colorado | 8043 | 5414 | 48 |
1057019 | 1057019 | 2021-02-23 | Garfield | Colorado | 8045 | 5034 | 38 |
1057020 | 1057020 | 2021-02-23 | Gilpin | Colorado | 8047 | 165 | 3 |
1057021 | 1057021 | 2021-02-23 | Grand | Colorado | 8049 | 1243 | 5 |
1057022 | 1057022 | 2021-02-23 | Gunnison | Colorado | 8051 | 1192 | 6 |
1057023 | 1057023 | 2021-02-23 | Hinsdale | Colorado | 8053 | 16 | 0 |
1057024 | 1057024 | 2021-02-23 | Huerfano | Colorado | 8055 | 300 | 17 |
1057025 | 1057025 | 2021-02-23 | Jackson | Colorado | 8057 | 51 | 0 |
1057026 | 1057026 | 2021-02-23 | Jefferson | Colorado | 8059 | 36660 | 711 |
1057027 | 1057027 | 2021-02-23 | Kiowa | Colorado | 8061 | 91 | 3 |
1057028 | 1057028 | 2021-02-23 | Kit Carson | Colorado | 8063 | 531 | 10 |
1057029 | 1057029 | 2021-02-23 | La Plata | Colorado | 8067 | 2899 | 37 |
1057030 | 1057030 | 2021-02-23 | Lake | Colorado | 8065 | 653 | 0 |
1057031 | 1057031 | 2021-02-23 | Larimer | Colorado | 8069 | 19663 | 221 |
1057032 | 1057032 | 2021-02-23 | Las Animas | Colorado | 8071 | 987 | 11 |
1057033 | 1057033 | 2021-02-23 | Lincoln | Colorado | 8073 | 997 | 3 |
1057034 | 1057034 | 2021-02-23 | Logan | Colorado | 8075 | 3706 | 63 |
1057035 | 1057035 | 2021-02-23 | Mesa | Colorado | 8077 | 13115 | 194 |
1057036 | 1057036 | 2021-02-23 | Mineral | Colorado | 8079 | 61 | 1 |
1057037 | 1057037 | 2021-02-23 | Moffat | Colorado | 8081 | 657 | 22 |
1057038 | 1057038 | 2021-02-23 | Montezuma | Colorado | 8083 | 1710 | 22 |
1057039 | 1057039 | 2021-02-23 | Montrose | Colorado | 8085 | 3199 | 52 |
1057040 | 1057040 | 2021-02-23 | Morgan | Colorado | 8087 | 2415 | 90 |
1057041 | 1057041 | 2021-02-23 | Otero | Colorado | 8089 | 1842 | 61 |
1057042 | 1057042 | 2021-02-23 | Ouray | Colorado | 8091 | 248 | 3 |
1057043 | 1057043 | 2021-02-23 | Park | Colorado | 8093 | 540 | 5 |
1057044 | 1057044 | 2021-02-23 | Phillips | Colorado | 8095 | 333 | 12 |
1057045 | 1057045 | 2021-02-23 | Pitkin | Colorado | 8097 | 1951 | 4 |
1057046 | 1057046 | 2021-02-23 | Prowers | Colorado | 8099 | 1157 | 21 |
1057047 | 1057047 | 2021-02-23 | Pueblo | Colorado | 8101 | 14900 | 361 |
1057048 | 1057048 | 2021-02-23 | Rio Blanco | Colorado | 8103 | 460 | 3 |
1057049 | 1057049 | 2021-02-23 | Rio Grande | Colorado | 8105 | 689 | 12 |
1057050 | 1057050 | 2021-02-23 | Routt | Colorado | 8107 | 1839 | 19 |
1057051 | 1057051 | 2021-02-23 | Saguache | Colorado | 8109 | 318 | 4 |
1057052 | 1057052 | 2021-02-23 | San Juan | Colorado | 8111 | 41 | 0 |
1057053 | 1057053 | 2021-02-23 | San Miguel | Colorado | 8113 | 805 | 0 |
1057054 | 1057054 | 2021-02-23 | Sedgwick | Colorado | 8115 | 191 | 2 |
1057055 | 1057055 | 2021-02-23 | Summit | Colorado | 8117 | 2983 | 7 |
1057056 | 1057056 | 2021-02-23 | Teller | Colorado | 8119 | 1252 | 14 |
1057057 | 1057057 | 2021-02-23 | Washington | Colorado | 8121 | 377 | 12 |
1057058 | 1057058 | 2021-02-23 | Weld | Colorado | 8123 | 25205 | 317 |
1057059 | 1057059 | 2021-02-23 | Yuma | Colorado | 8125 | 699 | 17 |
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);