ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64 rows where date = "2020-10-15" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
631883 | 631883 | 2020-10-15 | Adams | Colorado | 8001 | 11340 | 245 |
631884 | 631884 | 2020-10-15 | Alamosa | Colorado | 8003 | 271 | 9 |
631885 | 631885 | 2020-10-15 | Arapahoe | Colorado | 8005 | 10916 | 390 |
631886 | 631886 | 2020-10-15 | Archuleta | Colorado | 8007 | 58 | 0 |
631887 | 631887 | 2020-10-15 | Baca | Colorado | 8009 | 23 | 0 |
631888 | 631888 | 2020-10-15 | Bent | Colorado | 8011 | 12 | 0 |
631889 | 631889 | 2020-10-15 | Boulder | Colorado | 8013 | 4954 | 83 |
631890 | 631890 | 2020-10-15 | Broomfield | Colorado | 8014 | 763 | 37 |
631891 | 631891 | 2020-10-15 | Chaffee | Colorado | 8015 | 358 | 20 |
631892 | 631892 | 2020-10-15 | Cheyenne | Colorado | 8017 | 14 | 0 |
631893 | 631893 | 2020-10-15 | Clear Creek | Colorado | 8019 | 61 | 1 |
631894 | 631894 | 2020-10-15 | Conejos | Colorado | 8021 | 44 | 0 |
631895 | 631895 | 2020-10-15 | Costilla | Colorado | 8023 | 34 | 1 |
631896 | 631896 | 2020-10-15 | Crowley | Colorado | 8025 | 78 | 1 |
631897 | 631897 | 2020-10-15 | Custer | Colorado | 8027 | 19 | 0 |
631898 | 631898 | 2020-10-15 | Delta | Colorado | 8029 | 194 | 4 |
631899 | 631899 | 2020-10-15 | Denver | Colorado | 8031 | 15466 | 449 |
631900 | 631900 | 2020-10-15 | Dolores | Colorado | 8033 | 3 | 0 |
631901 | 631901 | 2020-10-15 | Douglas | Colorado | 8035 | 3297 | 63 |
631902 | 631902 | 2020-10-15 | Eagle | Colorado | 8037 | 1335 | 10 |
631903 | 631903 | 2020-10-15 | El Paso | Colorado | 8041 | 8182 | 188 |
631904 | 631904 | 2020-10-15 | Elbert | Colorado | 8039 | 177 | 3 |
631905 | 631905 | 2020-10-15 | Fremont | Colorado | 8043 | 310 | 1 |
631906 | 631906 | 2020-10-15 | Garfield | Colorado | 8045 | 1047 | 5 |
631907 | 631907 | 2020-10-15 | Gilpin | Colorado | 8047 | 21 | 0 |
631908 | 631908 | 2020-10-15 | Grand | Colorado | 8049 | 123 | 1 |
631909 | 631909 | 2020-10-15 | Gunnison | Colorado | 8051 | 296 | 7 |
631910 | 631910 | 2020-10-15 | Hinsdale | Colorado | 8053 | 3 | 0 |
631911 | 631911 | 2020-10-15 | Huerfano | Colorado | 8055 | 27 | 2 |
631912 | 631912 | 2020-10-15 | Jackson | Colorado | 8057 | 9 | 0 |
631913 | 631913 | 2020-10-15 | Jefferson | Colorado | 8059 | 6887 | 296 |
631914 | 631914 | 2020-10-15 | Kiowa | Colorado | 8061 | 2 | 0 |
631915 | 631915 | 2020-10-15 | Kit Carson | Colorado | 8063 | 98 | 3 |
631916 | 631916 | 2020-10-15 | La Plata | Colorado | 8067 | 305 | 2 |
631917 | 631917 | 2020-10-15 | Lake | Colorado | 8065 | 114 | 0 |
631918 | 631918 | 2020-10-15 | Larimer | Colorado | 8069 | 3327 | 55 |
631919 | 631919 | 2020-10-15 | Las Animas | Colorado | 8071 | 31 | 0 |
631920 | 631920 | 2020-10-15 | Lincoln | Colorado | 8073 | 24 | 0 |
631921 | 631921 | 2020-10-15 | Logan | Colorado | 8075 | 1038 | 10 |
631922 | 631922 | 2020-10-15 | Mesa | Colorado | 8077 | 847 | 8 |
631923 | 631923 | 2020-10-15 | Mineral | Colorado | 8079 | 21 | 0 |
631924 | 631924 | 2020-10-15 | Moffat | Colorado | 8081 | 49 | 1 |
631925 | 631925 | 2020-10-15 | Montezuma | Colorado | 8083 | 173 | 5 |
631926 | 631926 | 2020-10-15 | Montrose | Colorado | 8085 | 412 | 13 |
631927 | 631927 | 2020-10-15 | Morgan | Colorado | 8087 | 800 | 48 |
631928 | 631928 | 2020-10-15 | Otero | Colorado | 8089 | 114 | 6 |
631929 | 631929 | 2020-10-15 | Ouray | Colorado | 8091 | 32 | 1 |
631930 | 631930 | 2020-10-15 | Park | Colorado | 8093 | 65 | 1 |
631931 | 631931 | 2020-10-15 | Phillips | Colorado | 8095 | 35 | 0 |
631932 | 631932 | 2020-10-15 | Pitkin | Colorado | 8097 | 253 | 2 |
631933 | 631933 | 2020-10-15 | Prowers | Colorado | 8099 | 102 | 0 |
631934 | 631934 | 2020-10-15 | Pueblo | Colorado | 8101 | 1492 | 39 |
631935 | 631935 | 2020-10-15 | Rio Blanco | Colorado | 8103 | 25 | 0 |
631936 | 631936 | 2020-10-15 | Rio Grande | Colorado | 8105 | 112 | 2 |
631937 | 631937 | 2020-10-15 | Routt | Colorado | 8107 | 175 | 8 |
631938 | 631938 | 2020-10-15 | Saguache | Colorado | 8109 | 117 | 2 |
631939 | 631939 | 2020-10-15 | San Juan | Colorado | 8111 | 6 | 0 |
631940 | 631940 | 2020-10-15 | San Miguel | Colorado | 8113 | 99 | 0 |
631941 | 631941 | 2020-10-15 | Sedgwick | Colorado | 8115 | 16 | 1 |
631942 | 631942 | 2020-10-15 | Summit | Colorado | 8117 | 537 | 4 |
631943 | 631943 | 2020-10-15 | Teller | Colorado | 8119 | 186 | 4 |
631944 | 631944 | 2020-10-15 | Washington | Colorado | 8121 | 77 | 0 |
631945 | 631945 | 2020-10-15 | Weld | Colorado | 8123 | 5264 | 155 |
631946 | 631946 | 2020-10-15 | Yuma | Colorado | 8125 | 173 | 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);