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 2022-01-07 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2089866 | 2089866 | 2022-01-07 | Adams | Colorado | 8001 | 101706 | 1110 |
2089867 | 2089867 | 2022-01-07 | Alamosa | Colorado | 8003 | 3201 | 56 |
2089868 | 2089868 | 2022-01-07 | Arapahoe | Colorado | 8005 | 112299 | 1089 |
2089869 | 2089869 | 2022-01-07 | Archuleta | Colorado | 8007 | 2146 | 9 |
2089870 | 2089870 | 2022-01-07 | Baca | Colorado | 8009 | 600 | 7 |
2089871 | 2089871 | 2022-01-07 | Bent | Colorado | 8011 | 1969 | 44 |
2089872 | 2089872 | 2022-01-07 | Boulder | Colorado | 8013 | 43263 | 328 |
2089873 | 2089873 | 2022-01-07 | Broomfield | Colorado | 8014 | 9422 | 98 |
2089874 | 2089874 | 2022-01-07 | Chaffee | Colorado | 8015 | 3120 | 38 |
2089875 | 2089875 | 2022-01-07 | Cheyenne | Colorado | 8017 | 259 | 9 |
2089876 | 2089876 | 2022-01-07 | Clear Creek | Colorado | 8019 | 1066 | 8 |
2089877 | 2089877 | 2022-01-07 | Conejos | Colorado | 8021 | 1221 | 46 |
2089878 | 2089878 | 2022-01-07 | Costilla | Colorado | 8023 | 456 | 14 |
2089879 | 2089879 | 2022-01-07 | Crowley | Colorado | 8025 | 2529 | 27 |
2089880 | 2089880 | 2022-01-07 | Custer | Colorado | 8027 | 507 | 16 |
2089881 | 2089881 | 2022-01-07 | Delta | Colorado | 8029 | 4837 | 123 |
2089882 | 2089882 | 2022-01-07 | Denver | Colorado | 8031 | 126727 | 1106 |
2089883 | 2089883 | 2022-01-07 | Dolores | Colorado | 8033 | 292 | 6 |
2089884 | 2089884 | 2022-01-07 | Douglas | Colorado | 8035 | 56598 | 378 |
2089885 | 2089885 | 2022-01-07 | Eagle | Colorado | 8037 | 12713 | 32 |
2089886 | 2089886 | 2022-01-07 | El Paso | Colorado | 8041 | 132842 | 1440 |
2089887 | 2089887 | 2022-01-07 | Elbert | Colorado | 8039 | 3557 | 31 |
2089888 | 2089888 | 2022-01-07 | Fremont | Colorado | 8043 | 10915 | 163 |
2089889 | 2089889 | 2022-01-07 | Garfield | Colorado | 8045 | 10459 | 79 |
2089890 | 2089890 | 2022-01-07 | Gilpin | Colorado | 8047 | 672 | 4 |
2089891 | 2089891 | 2022-01-07 | Grand | Colorado | 8049 | 2709 | 20 |
2089892 | 2089892 | 2022-01-07 | Gunnison | Colorado | 8051 | 2304 | 13 |
2089893 | 2089893 | 2022-01-07 | Hinsdale | Colorado | 8053 | 73 | 0 |
2089894 | 2089894 | 2022-01-07 | Huerfano | Colorado | 8055 | 964 | 27 |
2089895 | 2089895 | 2022-01-07 | Jackson | Colorado | 8057 | 131 | 0 |
2089896 | 2089896 | 2022-01-07 | Jefferson | Colorado | 8059 | 88641 | 1124 |
2089897 | 2089897 | 2022-01-07 | Kiowa | Colorado | 8061 | 286 | 4 |
2089898 | 2089898 | 2022-01-07 | Kit Carson | Colorado | 8063 | 1316 | 28 |
2089899 | 2089899 | 2022-01-07 | La Plata | Colorado | 8067 | 8307 | 68 |
2089900 | 2089900 | 2022-01-07 | Lake | Colorado | 8065 | 1375 | 2 |
2089901 | 2089901 | 2022-01-07 | Larimer | Colorado | 8069 | 53277 | 403 |
2089902 | 2089902 | 2022-01-07 | Las Animas | Colorado | 8071 | 2538 | 33 |
2089903 | 2089903 | 2022-01-07 | Lincoln | Colorado | 8073 | 1478 | 9 |
2089904 | 2089904 | 2022-01-07 | Logan | Colorado | 8075 | 5479 | 97 |
2089905 | 2089905 | 2022-01-07 | Mesa | Colorado | 8077 | 31202 | 477 |
2089906 | 2089906 | 2022-01-07 | Mineral | Colorado | 8079 | 158 | 1 |
2089907 | 2089907 | 2022-01-07 | Moffat | Colorado | 8081 | 2342 | 49 |
2089908 | 2089908 | 2022-01-07 | Montezuma | Colorado | 8083 | 4352 | 57 |
2089909 | 2089909 | 2022-01-07 | Montrose | Colorado | 8085 | 7223 | 146 |
2089910 | 2089910 | 2022-01-07 | Morgan | Colorado | 8087 | 4360 | 127 |
2089911 | 2089911 | 2022-01-07 | Otero | Colorado | 8089 | 3427 | 117 |
2089912 | 2089912 | 2022-01-07 | Ouray | Colorado | 8091 | 671 | 6 |
2089913 | 2089913 | 2022-01-07 | Park | Colorado | 8093 | 2141 | 15 |
2089914 | 2089914 | 2022-01-07 | Phillips | Colorado | 8095 | 636 | 15 |
2089915 | 2089915 | 2022-01-07 | Pitkin | Colorado | 8097 | 4718 | 6 |
2089916 | 2089916 | 2022-01-07 | Prowers | Colorado | 8099 | 2071 | 43 |
2089917 | 2089917 | 2022-01-07 | Pueblo | Colorado | 8101 | 32885 | 680 |
2089918 | 2089918 | 2022-01-07 | Rio Blanco | Colorado | 8103 | 1310 | 11 |
2089919 | 2089919 | 2022-01-07 | Rio Grande | Colorado | 8105 | 2039 | 40 |
2089920 | 2089920 | 2022-01-07 | Routt | Colorado | 8107 | 4788 | 24 |
2089921 | 2089921 | 2022-01-07 | Saguache | Colorado | 8109 | 871 | 10 |
2089922 | 2089922 | 2022-01-07 | San Juan | Colorado | 8111 | 148 | 0 |
2089923 | 2089923 | 2022-01-07 | San Miguel | Colorado | 8113 | 1721 | 7 |
2089924 | 2089924 | 2022-01-07 | Sedgwick | Colorado | 8115 | 371 | 6 |
2089925 | 2089925 | 2022-01-07 | Summit | Colorado | 8117 | 7829 | 12 |
2089926 | 2089926 | 2022-01-07 | Teller | Colorado | 8119 | 3704 | 52 |
2089927 | 2089927 | 2022-01-07 | Washington | Colorado | 8121 | 787 | 25 |
2089928 | 2089928 | 2022-01-07 | Weld | Colorado | 8123 | 60879 | 596 |
2089929 | 2089929 | 2022-01-07 | Yuma | Colorado | 8125 | 1517 | 22 |
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);