ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64 rows where date = "2021-05-05" 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 |
---|---|---|---|---|---|---|---|
1287528 | 1287528 | 2021-05-05 | Adams | Colorado | 8001 | 57533 | 704 |
1287529 | 1287529 | 2021-05-05 | Alamosa | Colorado | 8003 | 1475 | 30 |
1287530 | 1287530 | 2021-05-05 | Arapahoe | Colorado | 8005 | 59134 | 774 |
1287531 | 1287531 | 2021-05-05 | Archuleta | Colorado | 8007 | 924 | 1 |
1287532 | 1287532 | 2021-05-05 | Baca | Colorado | 8009 | 290 | 4 |
1287533 | 1287533 | 2021-05-05 | Bent | Colorado | 8011 | 1526 | 21 |
1287534 | 1287534 | 2021-05-05 | Boulder | Colorado | 8013 | 23189 | 255 |
1287535 | 1287535 | 2021-05-05 | Broomfield | Colorado | 8014 | 4731 | 75 |
1287536 | 1287536 | 2021-05-05 | Chaffee | Colorado | 8015 | 1648 | 25 |
1287537 | 1287537 | 2021-05-05 | Cheyenne | Colorado | 8017 | 127 | 6 |
1287538 | 1287538 | 2021-05-05 | Clear Creek | Colorado | 8019 | 439 | 3 |
1287539 | 1287539 | 2021-05-05 | Conejos | Colorado | 8021 | 533 | 10 |
1287540 | 1287540 | 2021-05-05 | Costilla | Colorado | 8023 | 213 | 2 |
1287541 | 1287541 | 2021-05-05 | Crowley | Colorado | 8025 | 2183 | 15 |
1287542 | 1287542 | 2021-05-05 | Custer | Colorado | 8027 | 192 | 1 |
1287543 | 1287543 | 2021-05-05 | Delta | Colorado | 8029 | 2676 | 61 |
1287544 | 1287544 | 2021-05-05 | Denver | Colorado | 8031 | 71072 | 807 |
1287545 | 1287545 | 2021-05-05 | Dolores | Colorado | 8033 | 80 | 0 |
1287546 | 1287546 | 2021-05-05 | Douglas | Colorado | 8035 | 28578 | 253 |
1287547 | 1287547 | 2021-05-05 | Eagle | Colorado | 8037 | 6253 | 22 |
1287548 | 1287548 | 2021-05-05 | El Paso | Colorado | 8041 | 65156 | 797 |
1287549 | 1287549 | 2021-05-05 | Elbert | Colorado | 8039 | 1700 | 13 |
1287550 | 1287550 | 2021-05-05 | Fremont | Colorado | 8043 | 6156 | 56 |
1287551 | 1287551 | 2021-05-05 | Garfield | Colorado | 8045 | 5798 | 38 |
1287552 | 1287552 | 2021-05-05 | Gilpin | Colorado | 8047 | 234 | 3 |
1287553 | 1287553 | 2021-05-05 | Grand | Colorado | 8049 | 1469 | 7 |
1287554 | 1287554 | 2021-05-05 | Gunnison | Colorado | 8051 | 1327 | 6 |
1287555 | 1287555 | 2021-05-05 | Hinsdale | Colorado | 8053 | 18 | 0 |
1287556 | 1287556 | 2021-05-05 | Huerfano | Colorado | 8055 | 402 | 17 |
1287557 | 1287557 | 2021-05-05 | Jackson | Colorado | 8057 | 57 | 0 |
1287558 | 1287558 | 2021-05-05 | Jefferson | Colorado | 8059 | 45755 | 754 |
1287559 | 1287559 | 2021-05-05 | Kiowa | Colorado | 8061 | 95 | 3 |
1287560 | 1287560 | 2021-05-05 | Kit Carson | Colorado | 8063 | 609 | 11 |
1287561 | 1287561 | 2021-05-05 | La Plata | Colorado | 8067 | 3868 | 39 |
1287562 | 1287562 | 2021-05-05 | Lake | Colorado | 8065 | 782 | 0 |
1287563 | 1287563 | 2021-05-05 | Larimer | Colorado | 8069 | 25807 | 233 |
1287564 | 1287564 | 2021-05-05 | Las Animas | Colorado | 8071 | 1121 | 11 |
1287565 | 1287565 | 2021-05-05 | Lincoln | Colorado | 8073 | 1024 | 4 |
1287566 | 1287566 | 2021-05-05 | Logan | Colorado | 8075 | 3947 | 67 |
1287567 | 1287567 | 2021-05-05 | Mesa | Colorado | 8077 | 14539 | 215 |
1287568 | 1287568 | 2021-05-05 | Mineral | Colorado | 8079 | 87 | 1 |
1287569 | 1287569 | 2021-05-05 | Moffat | Colorado | 8081 | 764 | 22 |
1287570 | 1287570 | 2021-05-05 | Montezuma | Colorado | 8083 | 1898 | 24 |
1287571 | 1287571 | 2021-05-05 | Montrose | Colorado | 8085 | 3445 | 58 |
1287572 | 1287572 | 2021-05-05 | Morgan | Colorado | 8087 | 2631 | 93 |
1287573 | 1287573 | 2021-05-05 | Otero | Colorado | 8089 | 1987 | 65 |
1287574 | 1287574 | 2021-05-05 | Ouray | Colorado | 8091 | 284 | 3 |
1287575 | 1287575 | 2021-05-05 | Park | Colorado | 8093 | 742 | 5 |
1287576 | 1287576 | 2021-05-05 | Phillips | Colorado | 8095 | 375 | 13 |
1287577 | 1287577 | 2021-05-05 | Pitkin | Colorado | 8097 | 2578 | 4 |
1287578 | 1287578 | 2021-05-05 | Prowers | Colorado | 8099 | 1220 | 21 |
1287579 | 1287579 | 2021-05-05 | Pueblo | Colorado | 8101 | 18252 | 383 |
1287580 | 1287580 | 2021-05-05 | Rio Blanco | Colorado | 8103 | 570 | 4 |
1287581 | 1287581 | 2021-05-05 | Rio Grande | Colorado | 8105 | 797 | 14 |
1287582 | 1287582 | 2021-05-05 | Routt | Colorado | 8107 | 2193 | 20 |
1287583 | 1287583 | 2021-05-05 | Saguache | Colorado | 8109 | 380 | 4 |
1287584 | 1287584 | 2021-05-05 | San Juan | Colorado | 8111 | 48 | 0 |
1287585 | 1287585 | 2021-05-05 | San Miguel | Colorado | 8113 | 875 | 0 |
1287586 | 1287586 | 2021-05-05 | Sedgwick | Colorado | 8115 | 216 | 2 |
1287587 | 1287587 | 2021-05-05 | Summit | Colorado | 8117 | 3690 | 7 |
1287588 | 1287588 | 2021-05-05 | Teller | Colorado | 8119 | 1678 | 15 |
1287589 | 1287589 | 2021-05-05 | Washington | Colorado | 8121 | 450 | 12 |
1287590 | 1287590 | 2021-05-05 | Weld | Colorado | 8123 | 30985 | 337 |
1287591 | 1287591 | 2021-05-05 | Yuma | Colorado | 8125 | 888 | 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);