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-10-23 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
657848 | 657848 | 2020-10-23 | Adams | Colorado | 8001 | 12818 | 253 |
657849 | 657849 | 2020-10-23 | Alamosa | Colorado | 8003 | 294 | 9 |
657850 | 657850 | 2020-10-23 | Arapahoe | Colorado | 8005 | 11842 | 395 |
657851 | 657851 | 2020-10-23 | Archuleta | Colorado | 8007 | 63 | 0 |
657852 | 657852 | 2020-10-23 | Baca | Colorado | 8009 | 29 | 0 |
657853 | 657853 | 2020-10-23 | Bent | Colorado | 8011 | 14 | 0 |
657854 | 657854 | 2020-10-23 | Boulder | Colorado | 8013 | 5310 | 85 |
657855 | 657855 | 2020-10-23 | Broomfield | Colorado | 8014 | 879 | 41 |
657856 | 657856 | 2020-10-23 | Chaffee | Colorado | 8015 | 381 | 20 |
657857 | 657857 | 2020-10-23 | Cheyenne | Colorado | 8017 | 15 | 0 |
657858 | 657858 | 2020-10-23 | Clear Creek | Colorado | 8019 | 65 | 1 |
657859 | 657859 | 2020-10-23 | Conejos | Colorado | 8021 | 65 | 0 |
657860 | 657860 | 2020-10-23 | Costilla | Colorado | 8023 | 36 | 1 |
657861 | 657861 | 2020-10-23 | Crowley | Colorado | 8025 | 85 | 1 |
657862 | 657862 | 2020-10-23 | Custer | Colorado | 8027 | 19 | 0 |
657863 | 657863 | 2020-10-23 | Delta | Colorado | 8029 | 200 | 3 |
657864 | 657864 | 2020-10-23 | Denver | Colorado | 8031 | 16896 | 450 |
657865 | 657865 | 2020-10-23 | Dolores | Colorado | 8033 | 3 | 0 |
657866 | 657866 | 2020-10-23 | Douglas | Colorado | 8035 | 3607 | 64 |
657867 | 657867 | 2020-10-23 | Eagle | Colorado | 8037 | 1399 | 10 |
657868 | 657868 | 2020-10-23 | El Paso | Colorado | 8041 | 9563 | 195 |
657869 | 657869 | 2020-10-23 | Elbert | Colorado | 8039 | 193 | 3 |
657870 | 657870 | 2020-10-23 | Fremont | Colorado | 8043 | 611 | 1 |
657871 | 657871 | 2020-10-23 | Garfield | Colorado | 8045 | 1118 | 5 |
657872 | 657872 | 2020-10-23 | Gilpin | Colorado | 8047 | 29 | 0 |
657873 | 657873 | 2020-10-23 | Grand | Colorado | 8049 | 142 | 1 |
657874 | 657874 | 2020-10-23 | Gunnison | Colorado | 8051 | 305 | 7 |
657875 | 657875 | 2020-10-23 | Hinsdale | Colorado | 8053 | 3 | 0 |
657876 | 657876 | 2020-10-23 | Huerfano | Colorado | 8055 | 29 | 2 |
657877 | 657877 | 2020-10-23 | Jackson | Colorado | 8057 | 9 | 0 |
657878 | 657878 | 2020-10-23 | Jefferson | Colorado | 8059 | 7721 | 305 |
657879 | 657879 | 2020-10-23 | Kiowa | Colorado | 8061 | 3 | 0 |
657880 | 657880 | 2020-10-23 | Kit Carson | Colorado | 8063 | 122 | 3 |
657881 | 657881 | 2020-10-23 | La Plata | Colorado | 8067 | 341 | 2 |
657882 | 657882 | 2020-10-23 | Lake | Colorado | 8065 | 124 | 0 |
657883 | 657883 | 2020-10-23 | Larimer | Colorado | 8069 | 3801 | 55 |
657884 | 657884 | 2020-10-23 | Las Animas | Colorado | 8071 | 66 | 1 |
657885 | 657885 | 2020-10-23 | Lincoln | Colorado | 8073 | 24 | 0 |
657886 | 657886 | 2020-10-23 | Logan | Colorado | 8075 | 1149 | 11 |
657887 | 657887 | 2020-10-23 | Mesa | Colorado | 8077 | 1209 | 9 |
657888 | 657888 | 2020-10-23 | Mineral | Colorado | 8079 | 21 | 0 |
657889 | 657889 | 2020-10-23 | Moffat | Colorado | 8081 | 58 | 1 |
657890 | 657890 | 2020-10-23 | Montezuma | Colorado | 8083 | 189 | 5 |
657891 | 657891 | 2020-10-23 | Montrose | Colorado | 8085 | 441 | 13 |
657892 | 657892 | 2020-10-23 | Morgan | Colorado | 8087 | 835 | 48 |
657893 | 657893 | 2020-10-23 | Otero | Colorado | 8089 | 123 | 6 |
657894 | 657894 | 2020-10-23 | Ouray | Colorado | 8091 | 36 | 2 |
657895 | 657895 | 2020-10-23 | Park | Colorado | 8093 | 91 | 1 |
657896 | 657896 | 2020-10-23 | Phillips | Colorado | 8095 | 44 | 0 |
657897 | 657897 | 2020-10-23 | Pitkin | Colorado | 8097 | 271 | 2 |
657898 | 657898 | 2020-10-23 | Prowers | Colorado | 8099 | 158 | 0 |
657899 | 657899 | 2020-10-23 | Pueblo | Colorado | 8101 | 1762 | 40 |
657900 | 657900 | 2020-10-23 | Rio Blanco | Colorado | 8103 | 27 | 0 |
657901 | 657901 | 2020-10-23 | Rio Grande | Colorado | 8105 | 116 | 3 |
657902 | 657902 | 2020-10-23 | Routt | Colorado | 8107 | 200 | 8 |
657903 | 657903 | 2020-10-23 | Saguache | Colorado | 8109 | 130 | 2 |
657904 | 657904 | 2020-10-23 | San Juan | Colorado | 8111 | 7 | 0 |
657905 | 657905 | 2020-10-23 | San Miguel | Colorado | 8113 | 100 | 0 |
657906 | 657906 | 2020-10-23 | Sedgwick | Colorado | 8115 | 38 | 1 |
657907 | 657907 | 2020-10-23 | Summit | Colorado | 8117 | 636 | 4 |
657908 | 657908 | 2020-10-23 | Teller | Colorado | 8119 | 205 | 4 |
657909 | 657909 | 2020-10-23 | Washington | Colorado | 8121 | 85 | 0 |
657910 | 657910 | 2020-10-23 | Weld | Colorado | 8123 | 5708 | 159 |
657911 | 657911 | 2020-10-23 | Yuma | Colorado | 8125 | 204 | 1 |
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);