ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64 rows where date = "2021-07-01" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1472549 | 1472549 | 2021-07-01 | Adams | Colorado | 8001 | 62099 | 757 |
1472550 | 1472550 | 2021-07-01 | Alamosa | Colorado | 8003 | 1726 | 37 |
1472551 | 1472551 | 2021-07-01 | Arapahoe | Colorado | 8005 | 64137 | 829 |
1472552 | 1472552 | 2021-07-01 | Archuleta | Colorado | 8007 | 1042 | 3 |
1472553 | 1472553 | 2021-07-01 | Baca | Colorado | 8009 | 323 | 4 |
1472554 | 1472554 | 2021-07-01 | Bent | Colorado | 8011 | 1545 | 22 |
1472555 | 1472555 | 2021-07-01 | Boulder | Colorado | 8013 | 24099 | 261 |
1472556 | 1472556 | 2021-07-01 | Broomfield | Colorado | 8014 | 5002 | 76 |
1472557 | 1472557 | 2021-07-01 | Chaffee | Colorado | 8015 | 1773 | 25 |
1472558 | 1472558 | 2021-07-01 | Cheyenne | Colorado | 8017 | 130 | 6 |
1472559 | 1472559 | 2021-07-01 | Clear Creek | Colorado | 8019 | 477 | 3 |
1472560 | 1472560 | 2021-07-01 | Conejos | Colorado | 8021 | 738 | 21 |
1472561 | 1472561 | 2021-07-01 | Costilla | Colorado | 8023 | 251 | 5 |
1472562 | 1472562 | 2021-07-01 | Crowley | Colorado | 8025 | 2213 | 17 |
1472563 | 1472563 | 2021-07-01 | Custer | Colorado | 8027 | 227 | 2 |
1472564 | 1472564 | 2021-07-01 | Delta | Colorado | 8029 | 2943 | 66 |
1472565 | 1472565 | 2021-07-01 | Denver | Colorado | 8031 | 74392 | 843 |
1472566 | 1472566 | 2021-07-01 | Dolores | Colorado | 8033 | 130 | 1 |
1472567 | 1472567 | 2021-07-01 | Douglas | Colorado | 8035 | 31176 | 266 |
1472568 | 1472568 | 2021-07-01 | Eagle | Colorado | 8037 | 6360 | 23 |
1472569 | 1472569 | 2021-07-01 | El Paso | Colorado | 8041 | 73451 | 875 |
1472570 | 1472570 | 2021-07-01 | Elbert | Colorado | 8039 | 1886 | 14 |
1472571 | 1472571 | 2021-07-01 | Fremont | Colorado | 8043 | 6553 | 63 |
1472572 | 1472572 | 2021-07-01 | Garfield | Colorado | 8045 | 6192 | 50 |
1472573 | 1472573 | 2021-07-01 | Gilpin | Colorado | 8047 | 285 | 3 |
1472574 | 1472574 | 2021-07-01 | Grand | Colorado | 8049 | 1507 | 7 |
1472575 | 1472575 | 2021-07-01 | Gunnison | Colorado | 8051 | 1397 | 6 |
1472576 | 1472576 | 2021-07-01 | Hinsdale | Colorado | 8053 | 20 | 0 |
1472577 | 1472577 | 2021-07-01 | Huerfano | Colorado | 8055 | 436 | 17 |
1472578 | 1472578 | 2021-07-01 | Jackson | Colorado | 8057 | 67 | 0 |
1472579 | 1472579 | 2021-07-01 | Jefferson | Colorado | 8059 | 48950 | 805 |
1472580 | 1472580 | 2021-07-01 | Kiowa | Colorado | 8061 | 95 | 3 |
1472581 | 1472581 | 2021-07-01 | Kit Carson | Colorado | 8063 | 647 | 11 |
1472582 | 1472582 | 2021-07-01 | La Plata | Colorado | 8067 | 4151 | 41 |
1472583 | 1472583 | 2021-07-01 | Lake | Colorado | 8065 | 835 | 0 |
1472584 | 1472584 | 2021-07-01 | Larimer | Colorado | 8069 | 27728 | 248 |
1472585 | 1472585 | 2021-07-01 | Las Animas | Colorado | 8071 | 1171 | 14 |
1472586 | 1472586 | 2021-07-01 | Lincoln | Colorado | 8073 | 1035 | 4 |
1472587 | 1472587 | 2021-07-01 | Logan | Colorado | 8075 | 4061 | 69 |
1472588 | 1472588 | 2021-07-01 | Mesa | Colorado | 8077 | 17246 | 251 |
1472589 | 1472589 | 2021-07-01 | Mineral | Colorado | 8079 | 93 | 1 |
1472590 | 1472590 | 2021-07-01 | Moffat | Colorado | 8081 | 1031 | 26 |
1472591 | 1472591 | 2021-07-01 | Montezuma | Colorado | 8083 | 2091 | 25 |
1472592 | 1472592 | 2021-07-01 | Montrose | Colorado | 8085 | 3744 | 65 |
1472593 | 1472593 | 2021-07-01 | Morgan | Colorado | 8087 | 2754 | 96 |
1472594 | 1472594 | 2021-07-01 | Otero | Colorado | 8089 | 2087 | 68 |
1472595 | 1472595 | 2021-07-01 | Ouray | Colorado | 8091 | 294 | 3 |
1472596 | 1472596 | 2021-07-01 | Park | Colorado | 8093 | 832 | 5 |
1472597 | 1472597 | 2021-07-01 | Phillips | Colorado | 8095 | 400 | 13 |
1472598 | 1472598 | 2021-07-01 | Pitkin | Colorado | 8097 | 2622 | 4 |
1472599 | 1472599 | 2021-07-01 | Prowers | Colorado | 8099 | 1278 | 22 |
1472600 | 1472600 | 2021-07-01 | Pueblo | Colorado | 8101 | 19599 | 418 |
1472601 | 1472601 | 2021-07-01 | Rio Blanco | Colorado | 8103 | 623 | 5 |
1472602 | 1472602 | 2021-07-01 | Rio Grande | Colorado | 8105 | 907 | 16 |
1472603 | 1472603 | 2021-07-01 | Routt | Colorado | 8107 | 2290 | 21 |
1472604 | 1472604 | 2021-07-01 | Saguache | Colorado | 8109 | 456 | 5 |
1472605 | 1472605 | 2021-07-01 | San Juan | Colorado | 8111 | 47 | 0 |
1472606 | 1472606 | 2021-07-01 | San Miguel | Colorado | 8113 | 923 | 1 |
1472607 | 1472607 | 2021-07-01 | Sedgwick | Colorado | 8115 | 236 | 3 |
1472608 | 1472608 | 2021-07-01 | Summit | Colorado | 8117 | 3771 | 8 |
1472609 | 1472609 | 2021-07-01 | Teller | Colorado | 8119 | 1921 | 18 |
1472610 | 1472610 | 2021-07-01 | Washington | Colorado | 8121 | 473 | 13 |
1472611 | 1472611 | 2021-07-01 | Weld | Colorado | 8123 | 33523 | 351 |
1472612 | 1472612 | 2021-07-01 | Yuma | Colorado | 8125 | 969 | 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);