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-01-04 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
894721 | 894721 | 2021-01-04 | Adams | Colorado | 8001 | 41506 | 536 |
894722 | 894722 | 2021-01-04 | Alamosa | Colorado | 8003 | 958 | 24 |
894723 | 894723 | 2021-01-04 | Arapahoe | Colorado | 8005 | 39642 | 598 |
894724 | 894724 | 2021-01-04 | Archuleta | Colorado | 8007 | 504 | 0 |
894725 | 894725 | 2021-01-04 | Baca | Colorado | 8009 | 199 | 1 |
894726 | 894726 | 2021-01-04 | Bent | Colorado | 8011 | 1143 | 12 |
894727 | 894727 | 2021-01-04 | Boulder | Colorado | 8013 | 15151 | 184 |
894728 | 894728 | 2021-01-04 | Broomfield | Colorado | 8014 | 2870 | 68 |
894729 | 894729 | 2021-01-04 | Chaffee | Colorado | 8015 | 1111 | 21 |
894730 | 894730 | 2021-01-04 | Cheyenne | Colorado | 8017 | 89 | 5 |
894731 | 894731 | 2021-01-04 | Clear Creek | Colorado | 8019 | 294 | 2 |
894732 | 894732 | 2021-01-04 | Conejos | Colorado | 8021 | 321 | 3 |
894733 | 894733 | 2021-01-04 | Costilla | Colorado | 8023 | 163 | 2 |
894734 | 894734 | 2021-01-04 | Crowley | Colorado | 8025 | 1660 | 12 |
894735 | 894735 | 2021-01-04 | Custer | Colorado | 8027 | 150 | 1 |
894736 | 894736 | 2021-01-04 | Delta | Colorado | 8029 | 1703 | 27 |
894737 | 894737 | 2021-01-04 | Denver | Colorado | 8031 | 48605 | 681 |
894738 | 894738 | 2021-01-04 | Dolores | Colorado | 8033 | 52 | 0 |
894739 | 894739 | 2021-01-04 | Douglas | Colorado | 8035 | 16445 | 202 |
894740 | 894740 | 2021-01-04 | Eagle | Colorado | 8037 | 3450 | 16 |
894741 | 894741 | 2021-01-04 | El Paso | Colorado | 8041 | 42447 | 585 |
894742 | 894742 | 2021-01-04 | Elbert | Colorado | 8039 | 1012 | 10 |
894743 | 894743 | 2021-01-04 | Fremont | Colorado | 8043 | 4773 | 20 |
894744 | 894744 | 2021-01-04 | Garfield | Colorado | 8045 | 4033 | 30 |
894745 | 894745 | 2021-01-04 | Gilpin | Colorado | 8047 | 130 | 1 |
894746 | 894746 | 2021-01-04 | Grand | Colorado | 8049 | 688 | 4 |
894747 | 894747 | 2021-01-04 | Gunnison | Colorado | 8051 | 727 | 6 |
894748 | 894748 | 2021-01-04 | Hinsdale | Colorado | 8053 | 14 | 0 |
894749 | 894749 | 2021-01-04 | Huerfano | Colorado | 8055 | 282 | 18 |
894750 | 894750 | 2021-01-04 | Jackson | Colorado | 8057 | 37 | 0 |
894751 | 894751 | 2021-01-04 | Jefferson | Colorado | 8059 | 30268 | 620 |
894752 | 894752 | 2021-01-04 | Kiowa | Colorado | 8061 | 75 | 2 |
894753 | 894753 | 2021-01-04 | Kit Carson | Colorado | 8063 | 438 | 10 |
894754 | 894754 | 2021-01-04 | La Plata | Colorado | 8067 | 2287 | 30 |
894755 | 894755 | 2021-01-04 | Lake | Colorado | 8065 | 444 | 0 |
894756 | 894756 | 2021-01-04 | Larimer | Colorado | 8069 | 15451 | 151 |
894757 | 894757 | 2021-01-04 | Las Animas | Colorado | 8071 | 684 | 7 |
894758 | 894758 | 2021-01-04 | Lincoln | Colorado | 8073 | 787 | 3 |
894759 | 894759 | 2021-01-04 | Logan | Colorado | 8075 | 3290 | 56 |
894760 | 894760 | 2021-01-04 | Mesa | Colorado | 8077 | 9496 | 142 |
894761 | 894761 | 2021-01-04 | Mineral | Colorado | 8079 | 44 | 1 |
894762 | 894762 | 2021-01-04 | Moffat | Colorado | 8081 | 549 | 20 |
894763 | 894763 | 2021-01-04 | Montezuma | Colorado | 8083 | 1282 | 16 |
894764 | 894764 | 2021-01-04 | Montrose | Colorado | 8085 | 2268 | 33 |
894765 | 894765 | 2021-01-04 | Morgan | Colorado | 8087 | 2164 | 83 |
894766 | 894766 | 2021-01-04 | Otero | Colorado | 8089 | 1677 | 42 |
894767 | 894767 | 2021-01-04 | Ouray | Colorado | 8091 | 155 | 3 |
894768 | 894768 | 2021-01-04 | Park | Colorado | 8093 | 398 | 5 |
894769 | 894769 | 2021-01-04 | Phillips | Colorado | 8095 | 289 | 8 |
894770 | 894770 | 2021-01-04 | Pitkin | Colorado | 8097 | 1180 | 4 |
894771 | 894771 | 2021-01-04 | Prowers | Colorado | 8099 | 1023 | 20 |
894772 | 894772 | 2021-01-04 | Pueblo | Colorado | 8101 | 13523 | 326 |
894773 | 894773 | 2021-01-04 | Rio Blanco | Colorado | 8103 | 275 | 3 |
894774 | 894774 | 2021-01-04 | Rio Grande | Colorado | 8105 | 397 | 7 |
894775 | 894775 | 2021-01-04 | Routt | Colorado | 8107 | 1077 | 18 |
894776 | 894776 | 2021-01-04 | Saguache | Colorado | 8109 | 257 | 4 |
894777 | 894777 | 2021-01-04 | San Juan | Colorado | 8111 | 27 | 0 |
894778 | 894778 | 2021-01-04 | San Miguel | Colorado | 8113 | 400 | 0 |
894779 | 894779 | 2021-01-04 | Sedgwick | Colorado | 8115 | 147 | 2 |
894780 | 894780 | 2021-01-04 | Summit | Colorado | 8117 | 2185 | 5 |
894781 | 894781 | 2021-01-04 | Teller | Colorado | 8119 | 1014 | 9 |
894782 | 894782 | 2021-01-04 | Washington | Colorado | 8121 | 349 | 11 |
894783 | 894783 | 2021-01-04 | Weld | Colorado | 8123 | 20621 | 288 |
894784 | 894784 | 2021-01-04 | Yuma | Colorado | 8125 | 559 | 13 |
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);