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-09-27 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
573528 | 573528 | 2020-09-27 | Adams | Colorado | 8001 | 9106 | 225 |
573529 | 573529 | 2020-09-27 | Alamosa | Colorado | 8003 | 242 | 9 |
573530 | 573530 | 2020-09-27 | Arapahoe | Colorado | 8005 | 9380 | 372 |
573531 | 573531 | 2020-09-27 | Archuleta | Colorado | 8007 | 54 | 0 |
573532 | 573532 | 2020-09-27 | Baca | Colorado | 8009 | 17 | 0 |
573533 | 573533 | 2020-09-27 | Bent | Colorado | 8011 | 11 | 0 |
573534 | 573534 | 2020-09-27 | Boulder | Colorado | 8013 | 4375 | 79 |
573535 | 573535 | 2020-09-27 | Broomfield | Colorado | 8014 | 645 | 33 |
573536 | 573536 | 2020-09-27 | Chaffee | Colorado | 8015 | 333 | 19 |
573537 | 573537 | 2020-09-27 | Cheyenne | Colorado | 8017 | 14 | 0 |
573538 | 573538 | 2020-09-27 | Clear Creek | Colorado | 8019 | 39 | 1 |
573539 | 573539 | 2020-09-27 | Conejos | Colorado | 8021 | 33 | 0 |
573540 | 573540 | 2020-09-27 | Costilla | Colorado | 8023 | 32 | 1 |
573541 | 573541 | 2020-09-27 | Crowley | Colorado | 8025 | 73 | 1 |
573542 | 573542 | 2020-09-27 | Custer | Colorado | 8027 | 17 | 0 |
573543 | 573543 | 2020-09-27 | Delta | Colorado | 8029 | 189 | 3 |
573544 | 573544 | 2020-09-27 | Denver | Colorado | 8031 | 13116 | 440 |
573545 | 573545 | 2020-09-27 | Dolores | Colorado | 8033 | 3 | 0 |
573546 | 573546 | 2020-09-27 | Douglas | Colorado | 8035 | 2708 | 60 |
573547 | 573547 | 2020-09-27 | Eagle | Colorado | 8037 | 1254 | 10 |
573548 | 573548 | 2020-09-27 | El Paso | Colorado | 8041 | 6951 | 174 |
573549 | 573549 | 2020-09-27 | Elbert | Colorado | 8039 | 158 | 3 |
573550 | 573550 | 2020-09-27 | Fremont | Colorado | 8043 | 175 | 1 |
573551 | 573551 | 2020-09-27 | Garfield | Colorado | 8045 | 945 | 5 |
573552 | 573552 | 2020-09-27 | Gilpin | Colorado | 8047 | 18 | 0 |
573553 | 573553 | 2020-09-27 | Grand | Colorado | 8049 | 74 | 1 |
573554 | 573554 | 2020-09-27 | Gunnison | Colorado | 8051 | 296 | 7 |
573555 | 573555 | 2020-09-27 | Hinsdale | Colorado | 8053 | 3 | 0 |
573556 | 573556 | 2020-09-27 | Huerfano | Colorado | 8055 | 23 | 1 |
573557 | 573557 | 2020-09-27 | Jackson | Colorado | 8057 | 9 | 0 |
573558 | 573558 | 2020-09-27 | Jefferson | Colorado | 8059 | 5716 | 248 |
573559 | 573559 | 2020-09-27 | Kiowa | Colorado | 8061 | 1 | 0 |
573560 | 573560 | 2020-09-27 | Kit Carson | Colorado | 8063 | 79 | 3 |
573561 | 573561 | 2020-09-27 | La Plata | Colorado | 8067 | 260 | 2 |
573562 | 573562 | 2020-09-27 | Lake | Colorado | 8065 | 94 | 0 |
573563 | 573563 | 2020-09-27 | Larimer | Colorado | 8069 | 2530 | 52 |
573564 | 573564 | 2020-09-27 | Las Animas | Colorado | 8071 | 25 | 0 |
573565 | 573565 | 2020-09-27 | Lincoln | Colorado | 8073 | 11 | 0 |
573566 | 573566 | 2020-09-27 | Logan | Colorado | 8075 | 868 | 6 |
573567 | 573567 | 2020-09-27 | Mesa | Colorado | 8077 | 615 | 7 |
573568 | 573568 | 2020-09-27 | Mineral | Colorado | 8079 | 20 | 0 |
573569 | 573569 | 2020-09-27 | Moffat | Colorado | 8081 | 42 | 1 |
573570 | 573570 | 2020-09-27 | Montezuma | Colorado | 8083 | 138 | 5 |
573571 | 573571 | 2020-09-27 | Montrose | Colorado | 8085 | 383 | 13 |
573572 | 573572 | 2020-09-27 | Morgan | Colorado | 8087 | 747 | 48 |
573573 | 573573 | 2020-09-27 | Otero | Colorado | 8089 | 96 | 6 |
573574 | 573574 | 2020-09-27 | Ouray | Colorado | 8091 | 25 | 1 |
573575 | 573575 | 2020-09-27 | Park | Colorado | 8093 | 57 | 1 |
573576 | 573576 | 2020-09-27 | Phillips | Colorado | 8095 | 34 | 0 |
573577 | 573577 | 2020-09-27 | Pitkin | Colorado | 8097 | 223 | 2 |
573578 | 573578 | 2020-09-27 | Prowers | Colorado | 8099 | 94 | 0 |
573579 | 573579 | 2020-09-27 | Pueblo | Colorado | 8101 | 1090 | 37 |
573580 | 573580 | 2020-09-27 | Rio Blanco | Colorado | 8103 | 26 | 0 |
573581 | 573581 | 2020-09-27 | Rio Grande | Colorado | 8105 | 96 | 2 |
573582 | 573582 | 2020-09-27 | Routt | Colorado | 8107 | 155 | 8 |
573583 | 573583 | 2020-09-27 | Saguache | Colorado | 8109 | 111 | 2 |
573584 | 573584 | 2020-09-27 | San Juan | Colorado | 8111 | 6 | 0 |
573585 | 573585 | 2020-09-27 | San Miguel | Colorado | 8113 | 97 | 0 |
573586 | 573586 | 2020-09-27 | Sedgwick | Colorado | 8115 | 15 | 1 |
573587 | 573587 | 2020-09-27 | Summit | Colorado | 8117 | 462 | 4 |
573588 | 573588 | 2020-09-27 | Teller | Colorado | 8119 | 176 | 4 |
573589 | 573589 | 2020-09-27 | Washington | Colorado | 8121 | 61 | 0 |
573590 | 573590 | 2020-09-27 | Weld | Colorado | 8123 | 4712 | 149 |
573591 | 573591 | 2020-09-27 | Yuma | Colorado | 8125 | 114 | 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);