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-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 |
---|---|---|---|---|---|---|---|
868757 | 868757 | 2020-12-27 | Adams | Colorado | 8001 | 39189 | 505 |
868758 | 868758 | 2020-12-27 | Alamosa | Colorado | 8003 | 907 | 22 |
868759 | 868759 | 2020-12-27 | Arapahoe | Colorado | 8005 | 37464 | 568 |
868760 | 868760 | 2020-12-27 | Archuleta | Colorado | 8007 | 467 | 0 |
868761 | 868761 | 2020-12-27 | Baca | Colorado | 8009 | 171 | 1 |
868762 | 868762 | 2020-12-27 | Bent | Colorado | 8011 | 1026 | 13 |
868763 | 868763 | 2020-12-27 | Boulder | Colorado | 8013 | 14339 | 174 |
868764 | 868764 | 2020-12-27 | Broomfield | Colorado | 8014 | 2726 | 63 |
868765 | 868765 | 2020-12-27 | Chaffee | Colorado | 8015 | 1002 | 20 |
868766 | 868766 | 2020-12-27 | Cheyenne | Colorado | 8017 | 87 | 4 |
868767 | 868767 | 2020-12-27 | Clear Creek | Colorado | 8019 | 267 | 2 |
868768 | 868768 | 2020-12-27 | Conejos | Colorado | 8021 | 304 | 3 |
868769 | 868769 | 2020-12-27 | Costilla | Colorado | 8023 | 157 | 2 |
868770 | 868770 | 2020-12-27 | Crowley | Colorado | 8025 | 1632 | 12 |
868771 | 868771 | 2020-12-27 | Custer | Colorado | 8027 | 146 | 0 |
868772 | 868772 | 2020-12-27 | Delta | Colorado | 8029 | 1534 | 22 |
868773 | 868773 | 2020-12-27 | Denver | Colorado | 8031 | 46570 | 658 |
868774 | 868774 | 2020-12-27 | Dolores | Colorado | 8033 | 49 | 0 |
868775 | 868775 | 2020-12-27 | Douglas | Colorado | 8035 | 15442 | 186 |
868776 | 868776 | 2020-12-27 | Eagle | Colorado | 8037 | 3226 | 14 |
868777 | 868777 | 2020-12-27 | El Paso | Colorado | 8041 | 40005 | 533 |
868778 | 868778 | 2020-12-27 | Elbert | Colorado | 8039 | 955 | 8 |
868779 | 868779 | 2020-12-27 | Fremont | Colorado | 8043 | 4507 | 17 |
868780 | 868780 | 2020-12-27 | Garfield | Colorado | 8045 | 3731 | 26 |
868781 | 868781 | 2020-12-27 | Gilpin | Colorado | 8047 | 121 | 1 |
868782 | 868782 | 2020-12-27 | Grand | Colorado | 8049 | 620 | 4 |
868783 | 868783 | 2020-12-27 | Gunnison | Colorado | 8051 | 670 | 5 |
868784 | 868784 | 2020-12-27 | Hinsdale | Colorado | 8053 | 12 | 0 |
868785 | 868785 | 2020-12-27 | Huerfano | Colorado | 8055 | 273 | 17 |
868786 | 868786 | 2020-12-27 | Jackson | Colorado | 8057 | 31 | 0 |
868787 | 868787 | 2020-12-27 | Jefferson | Colorado | 8059 | 28828 | 596 |
868788 | 868788 | 2020-12-27 | Kiowa | Colorado | 8061 | 74 | 2 |
868789 | 868789 | 2020-12-27 | Kit Carson | Colorado | 8063 | 430 | 9 |
868790 | 868790 | 2020-12-27 | La Plata | Colorado | 8067 | 2189 | 28 |
868791 | 868791 | 2020-12-27 | Lake | Colorado | 8065 | 401 | 0 |
868792 | 868792 | 2020-12-27 | Larimer | Colorado | 8069 | 14676 | 128 |
868793 | 868793 | 2020-12-27 | Las Animas | Colorado | 8071 | 489 | 4 |
868794 | 868794 | 2020-12-27 | Lincoln | Colorado | 8073 | 777 | 3 |
868795 | 868795 | 2020-12-27 | Logan | Colorado | 8075 | 3200 | 53 |
868796 | 868796 | 2020-12-27 | Mesa | Colorado | 8077 | 8801 | 127 |
868797 | 868797 | 2020-12-27 | Mineral | Colorado | 8079 | 42 | 1 |
868798 | 868798 | 2020-12-27 | Moffat | Colorado | 8081 | 531 | 19 |
868799 | 868799 | 2020-12-27 | Montezuma | Colorado | 8083 | 1199 | 14 |
868800 | 868800 | 2020-12-27 | Montrose | Colorado | 8085 | 2034 | 29 |
868801 | 868801 | 2020-12-27 | Morgan | Colorado | 8087 | 2092 | 74 |
868802 | 868802 | 2020-12-27 | Otero | Colorado | 8089 | 1590 | 34 |
868803 | 868803 | 2020-12-27 | Ouray | Colorado | 8091 | 152 | 3 |
868804 | 868804 | 2020-12-27 | Park | Colorado | 8093 | 373 | 4 |
868805 | 868805 | 2020-12-27 | Phillips | Colorado | 8095 | 241 | 6 |
868806 | 868806 | 2020-12-27 | Pitkin | Colorado | 8097 | 971 | 3 |
868807 | 868807 | 2020-12-27 | Prowers | Colorado | 8099 | 976 | 20 |
868808 | 868808 | 2020-12-27 | Pueblo | Colorado | 8101 | 12884 | 288 |
868809 | 868809 | 2020-12-27 | Rio Blanco | Colorado | 8103 | 262 | 2 |
868810 | 868810 | 2020-12-27 | Rio Grande | Colorado | 8105 | 373 | 5 |
868811 | 868811 | 2020-12-27 | Routt | Colorado | 8107 | 1010 | 18 |
868812 | 868812 | 2020-12-27 | Saguache | Colorado | 8109 | 251 | 4 |
868813 | 868813 | 2020-12-27 | San Juan | Colorado | 8111 | 26 | 0 |
868814 | 868814 | 2020-12-27 | San Miguel | Colorado | 8113 | 388 | 0 |
868815 | 868815 | 2020-12-27 | Sedgwick | Colorado | 8115 | 125 | 2 |
868816 | 868816 | 2020-12-27 | Summit | Colorado | 8117 | 2077 | 5 |
868817 | 868817 | 2020-12-27 | Teller | Colorado | 8119 | 956 | 7 |
868818 | 868818 | 2020-12-27 | Washington | Colorado | 8121 | 340 | 10 |
868819 | 868819 | 2020-12-27 | Weld | Colorado | 8123 | 19361 | 272 |
868820 | 868820 | 2020-12-27 | Yuma | Colorado | 8125 | 527 | 10 |
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);