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-21 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
949891 | 949891 | 2021-01-21 | Adams | Colorado | 8001 | 44980 | 578 |
949892 | 949892 | 2021-01-21 | Alamosa | Colorado | 8003 | 1098 | 27 |
949893 | 949893 | 2021-01-21 | Arapahoe | Colorado | 8005 | 43837 | 639 |
949894 | 949894 | 2021-01-21 | Archuleta | Colorado | 8007 | 580 | 1 |
949895 | 949895 | 2021-01-21 | Baca | Colorado | 8009 | 256 | 2 |
949896 | 949896 | 2021-01-21 | Bent | Colorado | 8011 | 1279 | 19 |
949897 | 949897 | 2021-01-21 | Boulder | Colorado | 8013 | 16649 | 217 |
949898 | 949898 | 2021-01-21 | Broomfield | Colorado | 8014 | 3240 | 69 |
949899 | 949899 | 2021-01-21 | Chaffee | Colorado | 8015 | 1239 | 23 |
949900 | 949900 | 2021-01-21 | Cheyenne | Colorado | 8017 | 113 | 5 |
949901 | 949901 | 2021-01-21 | Clear Creek | Colorado | 8019 | 337 | 2 |
949902 | 949902 | 2021-01-21 | Conejos | Colorado | 8021 | 377 | 3 |
949903 | 949903 | 2021-01-21 | Costilla | Colorado | 8023 | 175 | 2 |
949904 | 949904 | 2021-01-21 | Crowley | Colorado | 8025 | 1743 | 14 |
949905 | 949905 | 2021-01-21 | Custer | Colorado | 8027 | 156 | 1 |
949906 | 949906 | 2021-01-21 | Delta | Colorado | 8029 | 2187 | 41 |
949907 | 949907 | 2021-01-21 | Denver | Colorado | 8031 | 54006 | 728 |
949908 | 949908 | 2021-01-21 | Dolores | Colorado | 8033 | 58 | 0 |
949909 | 949909 | 2021-01-21 | Douglas | Colorado | 8035 | 18411 | 222 |
949910 | 949910 | 2021-01-21 | Eagle | Colorado | 8037 | 4121 | 17 |
949911 | 949911 | 2021-01-21 | El Paso | Colorado | 8041 | 46446 | 677 |
949912 | 949912 | 2021-01-21 | Elbert | Colorado | 8039 | 1103 | 12 |
949913 | 949913 | 2021-01-21 | Fremont | Colorado | 8043 | 5012 | 33 |
949914 | 949914 | 2021-01-21 | Garfield | Colorado | 8045 | 4585 | 36 |
949915 | 949915 | 2021-01-21 | Gilpin | Colorado | 8047 | 140 | 2 |
949916 | 949916 | 2021-01-21 | Grand | Colorado | 8049 | 842 | 4 |
949917 | 949917 | 2021-01-21 | Gunnison | Colorado | 8051 | 949 | 6 |
949918 | 949918 | 2021-01-21 | Hinsdale | Colorado | 8053 | 16 | 0 |
949919 | 949919 | 2021-01-21 | Huerfano | Colorado | 8055 | 287 | 17 |
949920 | 949920 | 2021-01-21 | Jackson | Colorado | 8057 | 44 | 0 |
949921 | 949921 | 2021-01-21 | Jefferson | Colorado | 8059 | 33321 | 672 |
949922 | 949922 | 2021-01-21 | Kiowa | Colorado | 8061 | 83 | 2 |
949923 | 949923 | 2021-01-21 | Kit Carson | Colorado | 8063 | 483 | 10 |
949924 | 949924 | 2021-01-21 | La Plata | Colorado | 8067 | 2626 | 30 |
949925 | 949925 | 2021-01-21 | Lake | Colorado | 8065 | 482 | 0 |
949926 | 949926 | 2021-01-21 | Larimer | Colorado | 8069 | 17259 | 179 |
949927 | 949927 | 2021-01-21 | Las Animas | Colorado | 8071 | 887 | 10 |
949928 | 949928 | 2021-01-21 | Lincoln | Colorado | 8073 | 835 | 3 |
949929 | 949929 | 2021-01-21 | Logan | Colorado | 8075 | 3550 | 57 |
949930 | 949930 | 2021-01-21 | Mesa | Colorado | 8077 | 11266 | 157 |
949931 | 949931 | 2021-01-21 | Mineral | Colorado | 8079 | 55 | 1 |
949932 | 949932 | 2021-01-21 | Moffat | Colorado | 8081 | 605 | 23 |
949933 | 949933 | 2021-01-21 | Montezuma | Colorado | 8083 | 1555 | 19 |
949934 | 949934 | 2021-01-21 | Montrose | Colorado | 8085 | 2805 | 41 |
949935 | 949935 | 2021-01-21 | Morgan | Colorado | 8087 | 2330 | 86 |
949936 | 949936 | 2021-01-21 | Otero | Colorado | 8089 | 1763 | 57 |
949937 | 949937 | 2021-01-21 | Ouray | Colorado | 8091 | 180 | 3 |
949938 | 949938 | 2021-01-21 | Park | Colorado | 8093 | 461 | 5 |
949939 | 949939 | 2021-01-21 | Phillips | Colorado | 8095 | 316 | 10 |
949940 | 949940 | 2021-01-21 | Pitkin | Colorado | 8097 | 1732 | 4 |
949941 | 949941 | 2021-01-21 | Prowers | Colorado | 8099 | 1088 | 21 |
949942 | 949942 | 2021-01-21 | Pueblo | Colorado | 8101 | 14113 | 355 |
949943 | 949943 | 2021-01-21 | Rio Blanco | Colorado | 8103 | 349 | 3 |
949944 | 949944 | 2021-01-21 | Rio Grande | Colorado | 8105 | 560 | 11 |
949945 | 949945 | 2021-01-21 | Routt | Colorado | 8107 | 1415 | 19 |
949946 | 949946 | 2021-01-21 | Saguache | Colorado | 8109 | 286 | 4 |
949947 | 949947 | 2021-01-21 | San Juan | Colorado | 8111 | 35 | 0 |
949948 | 949948 | 2021-01-21 | San Miguel | Colorado | 8113 | 532 | 0 |
949949 | 949949 | 2021-01-21 | Sedgwick | Colorado | 8115 | 182 | 2 |
949950 | 949950 | 2021-01-21 | Summit | Colorado | 8117 | 2460 | 5 |
949951 | 949951 | 2021-01-21 | Teller | Colorado | 8119 | 1129 | 13 |
949952 | 949952 | 2021-01-21 | Washington | Colorado | 8121 | 364 | 11 |
949953 | 949953 | 2021-01-21 | Weld | Colorado | 8123 | 22913 | 299 |
949954 | 949954 | 2021-01-21 | Yuma | Colorado | 8125 | 632 | 14 |
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);