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-12-30 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
878492 | 878492 | 2020-12-30 | Adams | Colorado | 8001 | 39915 | 524 |
878493 | 878493 | 2020-12-30 | Alamosa | Colorado | 8003 | 920 | 23 |
878494 | 878494 | 2020-12-30 | Arapahoe | Colorado | 8005 | 38021 | 582 |
878495 | 878495 | 2020-12-30 | Archuleta | Colorado | 8007 | 470 | 0 |
878496 | 878496 | 2020-12-30 | Baca | Colorado | 8009 | 189 | 1 |
878497 | 878497 | 2020-12-30 | Bent | Colorado | 8011 | 1027 | 12 |
878498 | 878498 | 2020-12-30 | Boulder | Colorado | 8013 | 14614 | 182 |
878499 | 878499 | 2020-12-30 | Broomfield | Colorado | 8014 | 2781 | 63 |
878500 | 878500 | 2020-12-30 | Chaffee | Colorado | 8015 | 1016 | 21 |
878501 | 878501 | 2020-12-30 | Cheyenne | Colorado | 8017 | 88 | 5 |
878502 | 878502 | 2020-12-30 | Clear Creek | Colorado | 8019 | 272 | 2 |
878503 | 878503 | 2020-12-30 | Conejos | Colorado | 8021 | 309 | 3 |
878504 | 878504 | 2020-12-30 | Costilla | Colorado | 8023 | 161 | 2 |
878505 | 878505 | 2020-12-30 | Crowley | Colorado | 8025 | 1640 | 12 |
878506 | 878506 | 2020-12-30 | Custer | Colorado | 8027 | 147 | 0 |
878507 | 878507 | 2020-12-30 | Delta | Colorado | 8029 | 1569 | 25 |
878508 | 878508 | 2020-12-30 | Denver | Colorado | 8031 | 47353 | 672 |
878509 | 878509 | 2020-12-30 | Dolores | Colorado | 8033 | 52 | 0 |
878510 | 878510 | 2020-12-30 | Douglas | Colorado | 8035 | 15782 | 196 |
878511 | 878511 | 2020-12-30 | Eagle | Colorado | 8037 | 3323 | 15 |
878512 | 878512 | 2020-12-30 | El Paso | Colorado | 8041 | 41125 | 551 |
878513 | 878513 | 2020-12-30 | Elbert | Colorado | 8039 | 969 | 9 |
878514 | 878514 | 2020-12-30 | Fremont | Colorado | 8043 | 4617 | 18 |
878515 | 878515 | 2020-12-30 | Garfield | Colorado | 8045 | 3833 | 28 |
878516 | 878516 | 2020-12-30 | Gilpin | Colorado | 8047 | 122 | 1 |
878517 | 878517 | 2020-12-30 | Grand | Colorado | 8049 | 648 | 4 |
878518 | 878518 | 2020-12-30 | Gunnison | Colorado | 8051 | 693 | 5 |
878519 | 878519 | 2020-12-30 | Hinsdale | Colorado | 8053 | 12 | 0 |
878520 | 878520 | 2020-12-30 | Huerfano | Colorado | 8055 | 276 | 17 |
878521 | 878521 | 2020-12-30 | Jackson | Colorado | 8057 | 31 | 0 |
878522 | 878522 | 2020-12-30 | Jefferson | Colorado | 8059 | 29295 | 609 |
878523 | 878523 | 2020-12-30 | Kiowa | Colorado | 8061 | 75 | 2 |
878524 | 878524 | 2020-12-30 | Kit Carson | Colorado | 8063 | 432 | 9 |
878525 | 878525 | 2020-12-30 | La Plata | Colorado | 8067 | 2206 | 28 |
878526 | 878526 | 2020-12-30 | Lake | Colorado | 8065 | 419 | 0 |
878527 | 878527 | 2020-12-30 | Larimer | Colorado | 8069 | 14985 | 137 |
878528 | 878528 | 2020-12-30 | Las Animas | Colorado | 8071 | 502 | 6 |
878529 | 878529 | 2020-12-30 | Lincoln | Colorado | 8073 | 780 | 3 |
878530 | 878530 | 2020-12-30 | Logan | Colorado | 8075 | 3215 | 53 |
878531 | 878531 | 2020-12-30 | Mesa | Colorado | 8077 | 8941 | 132 |
878532 | 878532 | 2020-12-30 | Mineral | Colorado | 8079 | 42 | 1 |
878533 | 878533 | 2020-12-30 | Moffat | Colorado | 8081 | 538 | 19 |
878534 | 878534 | 2020-12-30 | Montezuma | Colorado | 8083 | 1219 | 15 |
878535 | 878535 | 2020-12-30 | Montrose | Colorado | 8085 | 2092 | 30 |
878536 | 878536 | 2020-12-30 | Morgan | Colorado | 8087 | 2110 | 77 |
878537 | 878537 | 2020-12-30 | Otero | Colorado | 8089 | 1602 | 39 |
878538 | 878538 | 2020-12-30 | Ouray | Colorado | 8091 | 155 | 3 |
878539 | 878539 | 2020-12-30 | Park | Colorado | 8093 | 382 | 4 |
878540 | 878540 | 2020-12-30 | Phillips | Colorado | 8095 | 278 | 7 |
878541 | 878541 | 2020-12-30 | Pitkin | Colorado | 8097 | 1042 | 3 |
878542 | 878542 | 2020-12-30 | Prowers | Colorado | 8099 | 994 | 20 |
878543 | 878543 | 2020-12-30 | Pueblo | Colorado | 8101 | 13103 | 302 |
878544 | 878544 | 2020-12-30 | Rio Blanco | Colorado | 8103 | 266 | 3 |
878545 | 878545 | 2020-12-30 | Rio Grande | Colorado | 8105 | 378 | 6 |
878546 | 878546 | 2020-12-30 | Routt | Colorado | 8107 | 1031 | 18 |
878547 | 878547 | 2020-12-30 | Saguache | Colorado | 8109 | 252 | 4 |
878548 | 878548 | 2020-12-30 | San Juan | Colorado | 8111 | 28 | 0 |
878549 | 878549 | 2020-12-30 | San Miguel | Colorado | 8113 | 391 | 0 |
878550 | 878550 | 2020-12-30 | Sedgwick | Colorado | 8115 | 127 | 2 |
878551 | 878551 | 2020-12-30 | Summit | Colorado | 8117 | 2114 | 5 |
878552 | 878552 | 2020-12-30 | Teller | Colorado | 8119 | 974 | 9 |
878553 | 878553 | 2020-12-30 | Washington | Colorado | 8121 | 346 | 10 |
878554 | 878554 | 2020-12-30 | Weld | Colorado | 8123 | 19855 | 282 |
878555 | 878555 | 2020-12-30 | Yuma | Colorado | 8125 | 542 | 11 |
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);