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-12-02 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1972848 | 1972848 | 2021-12-02 | Adams | Colorado | 8001 | 86888 | 992 |
1972849 | 1972849 | 2021-12-02 | Alamosa | Colorado | 8003 | 2944 | 49 |
1972850 | 1972850 | 2021-12-02 | Arapahoe | Colorado | 8005 | 91706 | 1003 |
1972851 | 1972851 | 2021-12-02 | Archuleta | Colorado | 8007 | 1921 | 8 |
1972852 | 1972852 | 2021-12-02 | Baca | Colorado | 8009 | 566 | 6 |
1972853 | 1972853 | 2021-12-02 | Bent | Colorado | 8011 | 1897 | 32 |
1972854 | 1972854 | 2021-12-02 | Boulder | Colorado | 8013 | 35157 | 312 |
1972855 | 1972855 | 2021-12-02 | Broomfield | Colorado | 8014 | 7653 | 86 |
1972856 | 1972856 | 2021-12-02 | Chaffee | Colorado | 8015 | 2713 | 36 |
1972857 | 1972857 | 2021-12-02 | Cheyenne | Colorado | 8017 | 236 | 7 |
1972858 | 1972858 | 2021-12-02 | Clear Creek | Colorado | 8019 | 895 | 6 |
1972859 | 1972859 | 2021-12-02 | Conejos | Colorado | 8021 | 1138 | 42 |
1972860 | 1972860 | 2021-12-02 | Costilla | Colorado | 8023 | 432 | 13 |
1972861 | 1972861 | 2021-12-02 | Crowley | Colorado | 8025 | 2474 | 27 |
1972862 | 1972862 | 2021-12-02 | Custer | Colorado | 8027 | 467 | 12 |
1972863 | 1972863 | 2021-12-02 | Delta | Colorado | 8029 | 4591 | 98 |
1972864 | 1972864 | 2021-12-02 | Denver | Colorado | 8031 | 102605 | 1022 |
1972865 | 1972865 | 2021-12-02 | Dolores | Colorado | 8033 | 262 | 5 |
1972866 | 1972866 | 2021-12-02 | Douglas | Colorado | 8035 | 46866 | 346 |
1972867 | 1972867 | 2021-12-02 | Eagle | Colorado | 8037 | 9304 | 32 |
1972868 | 1972868 | 2021-12-02 | El Paso | Colorado | 8041 | 115397 | 1267 |
1972869 | 1972869 | 2021-12-02 | Elbert | Colorado | 8039 | 3036 | 26 |
1972870 | 1972870 | 2021-12-02 | Fremont | Colorado | 8043 | 10064 | 139 |
1972871 | 1972871 | 2021-12-02 | Garfield | Colorado | 8045 | 8831 | 72 |
1972872 | 1972872 | 2021-12-02 | Gilpin | Colorado | 8047 | 538 | 3 |
1972873 | 1972873 | 2021-12-02 | Grand | Colorado | 8049 | 2312 | 16 |
1972874 | 1972874 | 2021-12-02 | Gunnison | Colorado | 8051 | 2000 | 12 |
1972875 | 1972875 | 2021-12-02 | Hinsdale | Colorado | 8053 | 65 | 0 |
1972876 | 1972876 | 2021-12-02 | Huerfano | Colorado | 8055 | 845 | 21 |
1972877 | 1972877 | 2021-12-02 | Jackson | Colorado | 8057 | 124 | 0 |
1972878 | 1972878 | 2021-12-02 | Jefferson | Colorado | 8059 | 73440 | 1001 |
1972879 | 1972879 | 2021-12-02 | Kiowa | Colorado | 8061 | 266 | 4 |
1972880 | 1972880 | 2021-12-02 | Kit Carson | Colorado | 8063 | 1158 | 23 |
1972881 | 1972881 | 2021-12-02 | La Plata | Colorado | 8067 | 6991 | 63 |
1972882 | 1972882 | 2021-12-02 | Lake | Colorado | 8065 | 1150 | 1 |
1972883 | 1972883 | 2021-12-02 | Larimer | Colorado | 8069 | 45425 | 378 |
1972884 | 1972884 | 2021-12-02 | Las Animas | Colorado | 8071 | 2233 | 27 |
1972885 | 1972885 | 2021-12-02 | Lincoln | Colorado | 8073 | 1382 | 8 |
1972886 | 1972886 | 2021-12-02 | Logan | Colorado | 8075 | 5093 | 92 |
1972887 | 1972887 | 2021-12-02 | Mesa | Colorado | 8077 | 28114 | 410 |
1972888 | 1972888 | 2021-12-02 | Mineral | Colorado | 8079 | 148 | 1 |
1972889 | 1972889 | 2021-12-02 | Moffat | Colorado | 8081 | 2176 | 47 |
1972890 | 1972890 | 2021-12-02 | Montezuma | Colorado | 8083 | 3939 | 48 |
1972891 | 1972891 | 2021-12-02 | Montrose | Colorado | 8085 | 6698 | 113 |
1972892 | 1972892 | 2021-12-02 | Morgan | Colorado | 8087 | 4013 | 115 |
1972893 | 1972893 | 2021-12-02 | Otero | Colorado | 8089 | 3227 | 103 |
1972894 | 1972894 | 2021-12-02 | Ouray | Colorado | 8091 | 515 | 6 |
1972895 | 1972895 | 2021-12-02 | Park | Colorado | 8093 | 1720 | 13 |
1972896 | 1972896 | 2021-12-02 | Phillips | Colorado | 8095 | 582 | 15 |
1972897 | 1972897 | 2021-12-02 | Pitkin | Colorado | 8097 | 3318 | 6 |
1972898 | 1972898 | 2021-12-02 | Prowers | Colorado | 8099 | 1939 | 38 |
1972899 | 1972899 | 2021-12-02 | Pueblo | Colorado | 8101 | 29695 | 593 |
1972900 | 1972900 | 2021-12-02 | Rio Blanco | Colorado | 8103 | 1210 | 10 |
1972901 | 1972901 | 2021-12-02 | Rio Grande | Colorado | 8105 | 1853 | 32 |
1972902 | 1972902 | 2021-12-02 | Routt | Colorado | 8107 | 3850 | 24 |
1972903 | 1972903 | 2021-12-02 | Saguache | Colorado | 8109 | 801 | 9 |
1972904 | 1972904 | 2021-12-02 | San Juan | Colorado | 8111 | 104 | 0 |
1972905 | 1972905 | 2021-12-02 | San Miguel | Colorado | 8113 | 1278 | 5 |
1972906 | 1972906 | 2021-12-02 | Sedgwick | Colorado | 8115 | 354 | 6 |
1972907 | 1972907 | 2021-12-02 | Summit | Colorado | 8117 | 5423 | 12 |
1972908 | 1972908 | 2021-12-02 | Teller | Colorado | 8119 | 3340 | 43 |
1972909 | 1972909 | 2021-12-02 | Washington | Colorado | 8121 | 751 | 24 |
1972910 | 1972910 | 2021-12-02 | Weld | Colorado | 8123 | 53273 | 540 |
1972911 | 1972911 | 2021-12-02 | Yuma | Colorado | 8125 | 1377 | 18 |
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);