ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64 rows where date = "2022-04-20" 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 |
---|---|---|---|---|---|---|---|
2424917 | 2424917 | 2022-04-20 | Adams | Colorado | 8001 | 135092 | 1326 |
2424918 | 2424918 | 2022-04-20 | Alamosa | Colorado | 8003 | 4527 | 61 |
2424919 | 2424919 | 2022-04-20 | Arapahoe | Colorado | 8005 | 154410 | 1239 |
2424920 | 2424920 | 2022-04-20 | Archuleta | Colorado | 8007 | 2902 | 15 |
2424921 | 2424921 | 2022-04-20 | Baca | Colorado | 8009 | 846 | 8 |
2424922 | 2424922 | 2022-04-20 | Bent | Colorado | 8011 | 2540 | 47 |
2424923 | 2424923 | 2022-04-20 | Boulder | Colorado | 8013 | 65019 | 388 |
2424924 | 2424924 | 2022-04-20 | Broomfield | Colorado | 8014 | 13520 | 113 |
2424925 | 2424925 | 2022-04-20 | Chaffee | Colorado | 8015 | 4648 | 44 |
2424926 | 2424926 | 2022-04-20 | Cheyenne | Colorado | 8017 | 321 | 9 |
2424927 | 2424927 | 2022-04-20 | Clear Creek | Colorado | 8019 | 1562 | 12 |
2424928 | 2424928 | 2022-04-20 | Conejos | Colorado | 8021 | 1743 | 54 |
2424929 | 2424929 | 2022-04-20 | Costilla | Colorado | 8023 | 695 | 16 |
2424930 | 2424930 | 2022-04-20 | Crowley | Colorado | 8025 | 3317 | 28 |
2424931 | 2424931 | 2022-04-20 | Custer | Colorado | 8027 | 650 | 20 |
2424932 | 2424932 | 2022-04-20 | Delta | Colorado | 8029 | 6157 | 134 |
2424933 | 2424933 | 2022-04-20 | Denver | Colorado | 8031 | 171562 | 1287 |
2424934 | 2424934 | 2022-04-20 | Dolores | Colorado | 8033 | 365 | 8 |
2424935 | 2424935 | 2022-04-20 | Douglas | Colorado | 8035 | 79252 | 429 |
2424936 | 2424936 | 2022-04-20 | Eagle | Colorado | 8037 | 16038 | 35 |
2424937 | 2424937 | 2022-04-20 | El Paso | Colorado | 8041 | 186140 | 1615 |
2424938 | 2424938 | 2022-04-20 | Elbert | Colorado | 8039 | 4793 | 37 |
2424939 | 2424939 | 2022-04-20 | Fremont | Colorado | 8043 | 15273 | 179 |
2424940 | 2424940 | 2022-04-20 | Garfield | Colorado | 8045 | 14738 | 90 |
2424941 | 2424941 | 2022-04-20 | Gilpin | Colorado | 8047 | 953 | 4 |
2424942 | 2424942 | 2022-04-20 | Grand | Colorado | 8049 | 3528 | 26 |
2424943 | 2424943 | 2022-04-20 | Gunnison | Colorado | 8051 | 3387 | 14 |
2424944 | 2424944 | 2022-04-20 | Hinsdale | Colorado | 8053 | 129 | 0 |
2424945 | 2424945 | 2022-04-20 | Huerfano | Colorado | 8055 | 1443 | 31 |
2424946 | 2424946 | 2022-04-20 | Jackson | Colorado | 8057 | 165 | 0 |
2424947 | 2424947 | 2022-04-20 | Jefferson | Colorado | 8059 | 124313 | 1328 |
2424948 | 2424948 | 2022-04-20 | Kiowa | Colorado | 8061 | 335 | 6 |
2424949 | 2424949 | 2022-04-20 | Kit Carson | Colorado | 8063 | 1610 | 34 |
2424950 | 2424950 | 2022-04-20 | La Plata | Colorado | 8067 | 12826 | 81 |
2424951 | 2424951 | 2022-04-20 | Lake | Colorado | 8065 | 1803 | 2 |
2424952 | 2424952 | 2022-04-20 | Larimer | Colorado | 8069 | 78368 | 480 |
2424953 | 2424953 | 2022-04-20 | Las Animas | Colorado | 8071 | 3604 | 40 |
2424954 | 2424954 | 2022-04-20 | Lincoln | Colorado | 8073 | 2180 | 9 |
2424955 | 2424955 | 2022-04-20 | Logan | Colorado | 8075 | 7440 | 107 |
2424956 | 2424956 | 2022-04-20 | Mesa | Colorado | 8077 | 42625 | 534 |
2424957 | 2424957 | 2022-04-20 | Mineral | Colorado | 8079 | 233 | 1 |
2424958 | 2424958 | 2022-04-20 | Moffat | Colorado | 8081 | 3023 | 51 |
2424959 | 2424959 | 2022-04-20 | Montezuma | Colorado | 8083 | 6186 | 75 |
2424960 | 2424960 | 2022-04-20 | Montrose | Colorado | 8085 | 9315 | 158 |
2424961 | 2424961 | 2022-04-20 | Morgan | Colorado | 8087 | 5668 | 135 |
2424962 | 2424962 | 2022-04-20 | Otero | Colorado | 8089 | 4290 | 127 |
2424963 | 2424963 | 2022-04-20 | Ouray | Colorado | 8091 | 861 | 6 |
2424964 | 2424964 | 2022-04-20 | Park | Colorado | 8093 | 2843 | 20 |
2424965 | 2424965 | 2022-04-20 | Phillips | Colorado | 8095 | 889 | 18 |
2424966 | 2424966 | 2022-04-20 | Pitkin | Colorado | 8097 | 6518 | 6 |
2424967 | 2424967 | 2022-04-20 | Prowers | Colorado | 8099 | 2639 | 48 |
2424968 | 2424968 | 2022-04-20 | Pueblo | Colorado | 8101 | 46665 | 777 |
2424969 | 2424969 | 2022-04-20 | Rio Blanco | Colorado | 8103 | 1681 | 13 |
2424970 | 2424970 | 2022-04-20 | Rio Grande | Colorado | 8105 | 2808 | 46 |
2424971 | 2424971 | 2022-04-20 | Routt | Colorado | 8107 | 6448 | 25 |
2424972 | 2424972 | 2022-04-20 | Saguache | Colorado | 8109 | 1190 | 12 |
2424973 | 2424973 | 2022-04-20 | San Juan | Colorado | 8111 | 202 | 0 |
2424974 | 2424974 | 2022-04-20 | San Miguel | Colorado | 8113 | 2282 | 8 |
2424975 | 2424975 | 2022-04-20 | Sedgwick | Colorado | 8115 | 484 | 9 |
2424976 | 2424976 | 2022-04-20 | Summit | Colorado | 8117 | 9872 | 14 |
2424977 | 2424977 | 2022-04-20 | Teller | Colorado | 8119 | 4842 | 57 |
2424978 | 2424978 | 2022-04-20 | Washington | Colorado | 8121 | 1061 | 27 |
2424979 | 2424979 | 2022-04-20 | Weld | Colorado | 8123 | 83881 | 696 |
2424980 | 2424980 | 2022-04-20 | Yuma | Colorado | 8125 | 1883 | 23 |
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);