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-12-11 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
816828 | 816828 | 2020-12-11 | Adams | Colorado | 8001 | 34701 | 412 |
816829 | 816829 | 2020-12-11 | Alamosa | Colorado | 8003 | 784 | 20 |
816830 | 816830 | 2020-12-11 | Arapahoe | Colorado | 8005 | 32608 | 505 |
816831 | 816831 | 2020-12-11 | Archuleta | Colorado | 8007 | 406 | 0 |
816832 | 816832 | 2020-12-11 | Baca | Colorado | 8009 | 151 | 0 |
816833 | 816833 | 2020-12-11 | Bent | Colorado | 8011 | 598 | 2 |
816834 | 816834 | 2020-12-11 | Boulder | Colorado | 8013 | 12865 | 141 |
816835 | 816835 | 2020-12-11 | Broomfield | Colorado | 8014 | 2411 | 56 |
816836 | 816836 | 2020-12-11 | Chaffee | Colorado | 8015 | 800 | 22 |
816837 | 816837 | 2020-12-11 | Cheyenne | Colorado | 8017 | 84 | 3 |
816838 | 816838 | 2020-12-11 | Clear Creek | Colorado | 8019 | 228 | 2 |
816839 | 816839 | 2020-12-11 | Conejos | Colorado | 8021 | 244 | 4 |
816840 | 816840 | 2020-12-11 | Costilla | Colorado | 8023 | 111 | 2 |
816841 | 816841 | 2020-12-11 | Crowley | Colorado | 8025 | 1421 | 10 |
816842 | 816842 | 2020-12-11 | Custer | Colorado | 8027 | 113 | 0 |
816843 | 816843 | 2020-12-11 | Delta | Colorado | 8029 | 1005 | 16 |
816844 | 816844 | 2020-12-11 | Denver | Colorado | 8031 | 42228 | 593 |
816845 | 816845 | 2020-12-11 | Dolores | Colorado | 8033 | 40 | 0 |
816846 | 816846 | 2020-12-11 | Douglas | Colorado | 8035 | 13396 | 142 |
816847 | 816847 | 2020-12-11 | Eagle | Colorado | 8037 | 2782 | 12 |
816848 | 816848 | 2020-12-11 | El Paso | Colorado | 8041 | 34714 | 413 |
816849 | 816849 | 2020-12-11 | Elbert | Colorado | 8039 | 790 | 5 |
816850 | 816850 | 2020-12-11 | Fremont | Colorado | 8043 | 3621 | 10 |
816851 | 816851 | 2020-12-11 | Garfield | Colorado | 8045 | 2868 | 16 |
816852 | 816852 | 2020-12-11 | Gilpin | Colorado | 8047 | 105 | 1 |
816853 | 816853 | 2020-12-11 | Grand | Colorado | 8049 | 517 | 5 |
816854 | 816854 | 2020-12-11 | Gunnison | Colorado | 8051 | 533 | 7 |
816855 | 816855 | 2020-12-11 | Hinsdale | Colorado | 8053 | 12 | 0 |
816856 | 816856 | 2020-12-11 | Huerfano | Colorado | 8055 | 227 | 11 |
816857 | 816857 | 2020-12-11 | Jackson | Colorado | 8057 | 24 | 0 |
816858 | 816858 | 2020-12-11 | Jefferson | Colorado | 8059 | 25137 | 543 |
816859 | 816859 | 2020-12-11 | Kiowa | Colorado | 8061 | 50 | 0 |
816860 | 816860 | 2020-12-11 | Kit Carson | Colorado | 8063 | 379 | 8 |
816861 | 816861 | 2020-12-11 | La Plata | Colorado | 8067 | 1833 | 10 |
816862 | 816862 | 2020-12-11 | Lake | Colorado | 8065 | 350 | 0 |
816863 | 816863 | 2020-12-11 | Larimer | Colorado | 8069 | 12731 | 92 |
816864 | 816864 | 2020-12-11 | Las Animas | Colorado | 8071 | 360 | 3 |
816865 | 816865 | 2020-12-11 | Lincoln | Colorado | 8073 | 657 | 1 |
816866 | 816866 | 2020-12-11 | Logan | Colorado | 8075 | 2709 | 45 |
816867 | 816867 | 2020-12-11 | Mesa | Colorado | 8077 | 7281 | 90 |
816868 | 816868 | 2020-12-11 | Mineral | Colorado | 8079 | 37 | 1 |
816869 | 816869 | 2020-12-11 | Moffat | Colorado | 8081 | 414 | 15 |
816870 | 816870 | 2020-12-11 | Montezuma | Colorado | 8083 | 962 | 11 |
816871 | 816871 | 2020-12-11 | Montrose | Colorado | 8085 | 1532 | 22 |
816872 | 816872 | 2020-12-11 | Morgan | Colorado | 8087 | 1871 | 63 |
816873 | 816873 | 2020-12-11 | Otero | Colorado | 8089 | 1219 | 18 |
816874 | 816874 | 2020-12-11 | Ouray | Colorado | 8091 | 133 | 3 |
816875 | 816875 | 2020-12-11 | Park | Colorado | 8093 | 301 | 4 |
816876 | 816876 | 2020-12-11 | Phillips | Colorado | 8095 | 205 | 3 |
816877 | 816877 | 2020-12-11 | Pitkin | Colorado | 8097 | 653 | 2 |
816878 | 816878 | 2020-12-11 | Prowers | Colorado | 8099 | 851 | 16 |
816879 | 816879 | 2020-12-11 | Pueblo | Colorado | 8101 | 11189 | 211 |
816880 | 816880 | 2020-12-11 | Rio Blanco | Colorado | 8103 | 209 | 2 |
816881 | 816881 | 2020-12-11 | Rio Grande | Colorado | 8105 | 292 | 5 |
816882 | 816882 | 2020-12-11 | Routt | Colorado | 8107 | 850 | 16 |
816883 | 816883 | 2020-12-11 | Saguache | Colorado | 8109 | 237 | 4 |
816884 | 816884 | 2020-12-11 | San Juan | Colorado | 8111 | 26 | 0 |
816885 | 816885 | 2020-12-11 | San Miguel | Colorado | 8113 | 269 | 0 |
816886 | 816886 | 2020-12-11 | Sedgwick | Colorado | 8115 | 116 | 2 |
816887 | 816887 | 2020-12-11 | Summit | Colorado | 8117 | 1789 | 5 |
816888 | 816888 | 2020-12-11 | Teller | Colorado | 8119 | 823 | 6 |
816889 | 816889 | 2020-12-11 | Washington | Colorado | 8121 | 300 | 9 |
816890 | 816890 | 2020-12-11 | Weld | Colorado | 8123 | 16992 | 235 |
816891 | 816891 | 2020-12-11 | Yuma | Colorado | 8125 | 427 | 3 |
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);