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 2022-01-15 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2115877 | 2115877 | 2022-01-15 | Adams | Colorado | 8001 | 112787 | 1138 |
2115878 | 2115878 | 2022-01-15 | Alamosa | Colorado | 8003 | 3426 | 58 |
2115879 | 2115879 | 2022-01-15 | Arapahoe | Colorado | 8005 | 126947 | 1111 |
2115880 | 2115880 | 2022-01-15 | Archuleta | Colorado | 8007 | 2384 | 9 |
2115881 | 2115881 | 2022-01-15 | Baca | Colorado | 8009 | 612 | 8 |
2115882 | 2115882 | 2022-01-15 | Bent | Colorado | 8011 | 2021 | 45 |
2115883 | 2115883 | 2022-01-15 | Boulder | Colorado | 8013 | 49376 | 336 |
2115884 | 2115884 | 2022-01-15 | Broomfield | Colorado | 8014 | 10645 | 99 |
2115885 | 2115885 | 2022-01-15 | Chaffee | Colorado | 8015 | 3613 | 38 |
2115886 | 2115886 | 2022-01-15 | Cheyenne | Colorado | 8017 | 271 | 9 |
2115887 | 2115887 | 2022-01-15 | Clear Creek | Colorado | 8019 | 1254 | 10 |
2115888 | 2115888 | 2022-01-15 | Conejos | Colorado | 8021 | 1306 | 48 |
2115889 | 2115889 | 2022-01-15 | Costilla | Colorado | 8023 | 513 | 14 |
2115890 | 2115890 | 2022-01-15 | Crowley | Colorado | 8025 | 2600 | 27 |
2115891 | 2115891 | 2022-01-15 | Custer | Colorado | 8027 | 525 | 16 |
2115892 | 2115892 | 2022-01-15 | Delta | Colorado | 8029 | 4973 | 124 |
2115893 | 2115893 | 2022-01-15 | Denver | Colorado | 8031 | 142720 | 1122 |
2115894 | 2115894 | 2022-01-15 | Dolores | Colorado | 8033 | 297 | 6 |
2115895 | 2115895 | 2022-01-15 | Douglas | Colorado | 8035 | 63674 | 384 |
2115896 | 2115896 | 2022-01-15 | Eagle | Colorado | 8037 | 13931 | 33 |
2115897 | 2115897 | 2022-01-15 | El Paso | Colorado | 8041 | 148029 | 1457 |
2115898 | 2115898 | 2022-01-15 | Elbert | Colorado | 8039 | 3916 | 31 |
2115899 | 2115899 | 2022-01-15 | Fremont | Colorado | 8043 | 11393 | 164 |
2115900 | 2115900 | 2022-01-15 | Garfield | Colorado | 8045 | 11975 | 80 |
2115901 | 2115901 | 2022-01-15 | Gilpin | Colorado | 8047 | 769 | 4 |
2115902 | 2115902 | 2022-01-15 | Grand | Colorado | 8049 | 3039 | 20 |
2115903 | 2115903 | 2022-01-15 | Gunnison | Colorado | 8051 | 2733 | 13 |
2115904 | 2115904 | 2022-01-15 | Hinsdale | Colorado | 8053 | 98 | 0 |
2115905 | 2115905 | 2022-01-15 | Huerfano | Colorado | 8055 | 1086 | 28 |
2115906 | 2115906 | 2022-01-15 | Jackson | Colorado | 8057 | 132 | 0 |
2115907 | 2115907 | 2022-01-15 | Jefferson | Colorado | 8059 | 99452 | 1142 |
2115908 | 2115908 | 2022-01-15 | Kiowa | Colorado | 8061 | 295 | 4 |
2115909 | 2115909 | 2022-01-15 | Kit Carson | Colorado | 8063 | 1381 | 28 |
2115910 | 2115910 | 2022-01-15 | La Plata | Colorado | 8067 | 9849 | 68 |
2115911 | 2115911 | 2022-01-15 | Lake | Colorado | 8065 | 1592 | 2 |
2115912 | 2115912 | 2022-01-15 | Larimer | Colorado | 8069 | 59489 | 410 |
2115913 | 2115913 | 2022-01-15 | Las Animas | Colorado | 8071 | 2712 | 35 |
2115914 | 2115914 | 2022-01-15 | Lincoln | Colorado | 8073 | 1660 | 9 |
2115915 | 2115915 | 2022-01-15 | Logan | Colorado | 8075 | 5690 | 99 |
2115916 | 2115916 | 2022-01-15 | Mesa | Colorado | 8077 | 33287 | 482 |
2115917 | 2115917 | 2022-01-15 | Mineral | Colorado | 8079 | 180 | 1 |
2115918 | 2115918 | 2022-01-15 | Moffat | Colorado | 8081 | 2463 | 49 |
2115919 | 2115919 | 2022-01-15 | Montezuma | Colorado | 8083 | 4652 | 59 |
2115920 | 2115920 | 2022-01-15 | Montrose | Colorado | 8085 | 7619 | 150 |
2115921 | 2115921 | 2022-01-15 | Morgan | Colorado | 8087 | 4675 | 128 |
2115922 | 2115922 | 2022-01-15 | Otero | Colorado | 8089 | 3562 | 118 |
2115923 | 2115923 | 2022-01-15 | Ouray | Colorado | 8091 | 732 | 6 |
2115924 | 2115924 | 2022-01-15 | Park | Colorado | 8093 | 2358 | 18 |
2115925 | 2115925 | 2022-01-15 | Phillips | Colorado | 8095 | 672 | 15 |
2115926 | 2115926 | 2022-01-15 | Pitkin | Colorado | 8097 | 5531 | 6 |
2115927 | 2115927 | 2022-01-15 | Prowers | Colorado | 8099 | 2174 | 44 |
2115928 | 2115928 | 2022-01-15 | Pueblo | Colorado | 8101 | 36164 | 699 |
2115929 | 2115929 | 2022-01-15 | Rio Blanco | Colorado | 8103 | 1360 | 13 |
2115930 | 2115930 | 2022-01-15 | Rio Grande | Colorado | 8105 | 2178 | 41 |
2115931 | 2115931 | 2022-01-15 | Routt | Colorado | 8107 | 5439 | 24 |
2115932 | 2115932 | 2022-01-15 | Saguache | Colorado | 8109 | 919 | 10 |
2115933 | 2115933 | 2022-01-15 | San Juan | Colorado | 8111 | 170 | 0 |
2115934 | 2115934 | 2022-01-15 | San Miguel | Colorado | 8113 | 1966 | 7 |
2115935 | 2115935 | 2022-01-15 | Sedgwick | Colorado | 8115 | 385 | 6 |
2115936 | 2115936 | 2022-01-15 | Summit | Colorado | 8117 | 8640 | 12 |
2115937 | 2115937 | 2022-01-15 | Teller | Colorado | 8119 | 4008 | 54 |
2115938 | 2115938 | 2022-01-15 | Washington | Colorado | 8121 | 818 | 25 |
2115939 | 2115939 | 2022-01-15 | Weld | Colorado | 8123 | 67265 | 608 |
2115940 | 2115940 | 2022-01-15 | Yuma | Colorado | 8125 | 1583 | 22 |
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);