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-02-10 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1014803 | 1014803 | 2021-02-10 | Adams | Colorado | 8001 | 47503 | 623 |
1014804 | 1014804 | 2021-02-10 | Alamosa | Colorado | 8003 | 1218 | 28 |
1014805 | 1014805 | 2021-02-10 | Arapahoe | Colorado | 8005 | 47234 | 679 |
1014806 | 1014806 | 2021-02-10 | Archuleta | Colorado | 8007 | 620 | 1 |
1014807 | 1014807 | 2021-02-10 | Baca | Colorado | 8009 | 269 | 3 |
1014808 | 1014808 | 2021-02-10 | Bent | Colorado | 8011 | 1328 | 21 |
1014809 | 1014809 | 2021-02-10 | Boulder | Colorado | 8013 | 17860 | 236 |
1014810 | 1014810 | 2021-02-10 | Broomfield | Colorado | 8014 | 3554 | 72 |
1014811 | 1014811 | 2021-02-10 | Chaffee | Colorado | 8015 | 1360 | 23 |
1014812 | 1014812 | 2021-02-10 | Cheyenne | Colorado | 8017 | 125 | 5 |
1014813 | 1014813 | 2021-02-10 | Clear Creek | Colorado | 8019 | 349 | 2 |
1014814 | 1014814 | 2021-02-10 | Conejos | Colorado | 8021 | 416 | 5 |
1014815 | 1014815 | 2021-02-10 | Costilla | Colorado | 8023 | 177 | 2 |
1014816 | 1014816 | 2021-02-10 | Crowley | Colorado | 8025 | 1884 | 14 |
1014817 | 1014817 | 2021-02-10 | Custer | Colorado | 8027 | 162 | 1 |
1014818 | 1014818 | 2021-02-10 | Delta | Colorado | 8029 | 2396 | 56 |
1014819 | 1014819 | 2021-02-10 | Denver | Colorado | 8031 | 57100 | 751 |
1014820 | 1014820 | 2021-02-10 | Dolores | Colorado | 8033 | 63 | 0 |
1014821 | 1014821 | 2021-02-10 | Douglas | Colorado | 8035 | 20336 | 230 |
1014822 | 1014822 | 2021-02-10 | Eagle | Colorado | 8037 | 4648 | 20 |
1014823 | 1014823 | 2021-02-10 | El Paso | Colorado | 8041 | 49302 | 722 |
1014824 | 1014824 | 2021-02-10 | Elbert | Colorado | 8039 | 1216 | 12 |
1014825 | 1014825 | 2021-02-10 | Fremont | Colorado | 8043 | 5240 | 41 |
1014826 | 1014826 | 2021-02-10 | Garfield | Colorado | 8045 | 4939 | 38 |
1014827 | 1014827 | 2021-02-10 | Gilpin | Colorado | 8047 | 159 | 3 |
1014828 | 1014828 | 2021-02-10 | Grand | Colorado | 8049 | 1119 | 5 |
1014829 | 1014829 | 2021-02-10 | Gunnison | Colorado | 8051 | 1092 | 6 |
1014830 | 1014830 | 2021-02-10 | Hinsdale | Colorado | 8053 | 17 | 0 |
1014831 | 1014831 | 2021-02-10 | Huerfano | Colorado | 8055 | 295 | 17 |
1014832 | 1014832 | 2021-02-10 | Jackson | Colorado | 8057 | 47 | 0 |
1014833 | 1014833 | 2021-02-10 | Jefferson | Colorado | 8059 | 35480 | 691 |
1014834 | 1014834 | 2021-02-10 | Kiowa | Colorado | 8061 | 89 | 3 |
1014835 | 1014835 | 2021-02-10 | Kit Carson | Colorado | 8063 | 517 | 10 |
1014836 | 1014836 | 2021-02-10 | La Plata | Colorado | 8067 | 2799 | 35 |
1014837 | 1014837 | 2021-02-10 | Lake | Colorado | 8065 | 610 | 0 |
1014838 | 1014838 | 2021-02-10 | Larimer | Colorado | 8069 | 18719 | 209 |
1014839 | 1014839 | 2021-02-10 | Las Animas | Colorado | 8071 | 953 | 11 |
1014840 | 1014840 | 2021-02-10 | Lincoln | Colorado | 8073 | 965 | 3 |
1014841 | 1014841 | 2021-02-10 | Logan | Colorado | 8075 | 3672 | 62 |
1014842 | 1014842 | 2021-02-10 | Mesa | Colorado | 8077 | 12712 | 180 |
1014843 | 1014843 | 2021-02-10 | Mineral | Colorado | 8079 | 61 | 1 |
1014844 | 1014844 | 2021-02-10 | Moffat | Colorado | 8081 | 644 | 22 |
1014845 | 1014845 | 2021-02-10 | Montezuma | Colorado | 8083 | 1681 | 22 |
1014846 | 1014846 | 2021-02-10 | Montrose | Colorado | 8085 | 3107 | 50 |
1014847 | 1014847 | 2021-02-10 | Morgan | Colorado | 8087 | 2398 | 89 |
1014848 | 1014848 | 2021-02-10 | Otero | Colorado | 8089 | 1798 | 61 |
1014849 | 1014849 | 2021-02-10 | Ouray | Colorado | 8091 | 226 | 3 |
1014850 | 1014850 | 2021-02-10 | Park | Colorado | 8093 | 514 | 5 |
1014851 | 1014851 | 2021-02-10 | Phillips | Colorado | 8095 | 330 | 11 |
1014852 | 1014852 | 2021-02-10 | Pitkin | Colorado | 8097 | 1886 | 4 |
1014853 | 1014853 | 2021-02-10 | Prowers | Colorado | 8099 | 1152 | 21 |
1014854 | 1014854 | 2021-02-10 | Pueblo | Colorado | 8101 | 14451 | 361 |
1014855 | 1014855 | 2021-02-10 | Rio Blanco | Colorado | 8103 | 425 | 3 |
1014856 | 1014856 | 2021-02-10 | Rio Grande | Colorado | 8105 | 645 | 10 |
1014857 | 1014857 | 2021-02-10 | Routt | Colorado | 8107 | 1746 | 19 |
1014858 | 1014858 | 2021-02-10 | Saguache | Colorado | 8109 | 296 | 4 |
1014859 | 1014859 | 2021-02-10 | San Juan | Colorado | 8111 | 43 | 0 |
1014860 | 1014860 | 2021-02-10 | San Miguel | Colorado | 8113 | 760 | 0 |
1014861 | 1014861 | 2021-02-10 | Sedgwick | Colorado | 8115 | 190 | 2 |
1014862 | 1014862 | 2021-02-10 | Summit | Colorado | 8117 | 2811 | 5 |
1014863 | 1014863 | 2021-02-10 | Teller | Colorado | 8119 | 1212 | 14 |
1014864 | 1014864 | 2021-02-10 | Washington | Colorado | 8121 | 365 | 12 |
1014865 | 1014865 | 2021-02-10 | Weld | Colorado | 8123 | 24417 | 313 |
1014866 | 1014866 | 2021-02-10 | Yuma | Colorado | 8125 | 682 | 16 |
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);