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-23 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2141903 | 2141903 | 2022-01-23 | Adams | Colorado | 8001 | 118899 | 1150 |
2141904 | 2141904 | 2022-01-23 | Alamosa | Colorado | 8003 | 3700 | 58 |
2141905 | 2141905 | 2022-01-23 | Arapahoe | Colorado | 8005 | 134793 | 1122 |
2141906 | 2141906 | 2022-01-23 | Archuleta | Colorado | 8007 | 2581 | 9 |
2141907 | 2141907 | 2022-01-23 | Baca | Colorado | 8009 | 658 | 8 |
2141908 | 2141908 | 2022-01-23 | Bent | Colorado | 8011 | 2110 | 46 |
2141909 | 2141909 | 2022-01-23 | Boulder | Colorado | 8013 | 54219 | 341 |
2141910 | 2141910 | 2022-01-23 | Broomfield | Colorado | 8014 | 11612 | 102 |
2141911 | 2141911 | 2022-01-23 | Chaffee | Colorado | 8015 | 3806 | 39 |
2141912 | 2141912 | 2022-01-23 | Cheyenne | Colorado | 8017 | 282 | 9 |
2141913 | 2141913 | 2022-01-23 | Clear Creek | Colorado | 8019 | 1381 | 10 |
2141914 | 2141914 | 2022-01-23 | Conejos | Colorado | 8021 | 1409 | 49 |
2141915 | 2141915 | 2022-01-23 | Costilla | Colorado | 8023 | 571 | 14 |
2141916 | 2141916 | 2022-01-23 | Crowley | Colorado | 8025 | 2741 | 27 |
2141917 | 2141917 | 2022-01-23 | Custer | Colorado | 8027 | 552 | 16 |
2141918 | 2141918 | 2022-01-23 | Delta | Colorado | 8029 | 5217 | 124 |
2141919 | 2141919 | 2022-01-23 | Denver | Colorado | 8031 | 151854 | 1141 |
2141920 | 2141920 | 2022-01-23 | Dolores | Colorado | 8033 | 318 | 7 |
2141921 | 2141921 | 2022-01-23 | Douglas | Colorado | 8035 | 68572 | 385 |
2141922 | 2141922 | 2022-01-23 | Eagle | Colorado | 8037 | 14491 | 33 |
2141923 | 2141923 | 2022-01-23 | El Paso | Colorado | 8041 | 160065 | 1482 |
2141924 | 2141924 | 2022-01-23 | Elbert | Colorado | 8039 | 4199 | 32 |
2141925 | 2141925 | 2022-01-23 | Fremont | Colorado | 8043 | 12047 | 164 |
2141926 | 2141926 | 2022-01-23 | Garfield | Colorado | 8045 | 12815 | 80 |
2141927 | 2141927 | 2022-01-23 | Gilpin | Colorado | 8047 | 854 | 4 |
2141928 | 2141928 | 2022-01-23 | Grand | Colorado | 8049 | 3169 | 20 |
2141929 | 2141929 | 2022-01-23 | Gunnison | Colorado | 8051 | 2955 | 13 |
2141930 | 2141930 | 2022-01-23 | Hinsdale | Colorado | 8053 | 106 | 0 |
2141931 | 2141931 | 2022-01-23 | Huerfano | Colorado | 8055 | 1178 | 28 |
2141932 | 2141932 | 2022-01-23 | Jackson | Colorado | 8057 | 137 | 0 |
2141933 | 2141933 | 2022-01-23 | Jefferson | Colorado | 8059 | 106859 | 1161 |
2141934 | 2141934 | 2022-01-23 | Kiowa | Colorado | 8061 | 303 | 4 |
2141935 | 2141935 | 2022-01-23 | Kit Carson | Colorado | 8063 | 1441 | 29 |
2141936 | 2141936 | 2022-01-23 | La Plata | Colorado | 8067 | 10797 | 72 |
2141937 | 2141937 | 2022-01-23 | Lake | Colorado | 8065 | 1654 | 2 |
2141938 | 2141938 | 2022-01-23 | Larimer | Colorado | 8069 | 64693 | 420 |
2141939 | 2141939 | 2022-01-23 | Las Animas | Colorado | 8071 | 2920 | 37 |
2141940 | 2141940 | 2022-01-23 | Lincoln | Colorado | 8073 | 1812 | 9 |
2141941 | 2141941 | 2022-01-23 | Logan | Colorado | 8075 | 6021 | 101 |
2141942 | 2141942 | 2022-01-23 | Mesa | Colorado | 8077 | 35805 | 488 |
2141943 | 2141943 | 2022-01-23 | Mineral | Colorado | 8079 | 195 | 1 |
2141944 | 2141944 | 2022-01-23 | Moffat | Colorado | 8081 | 2602 | 50 |
2141945 | 2141945 | 2022-01-23 | Montezuma | Colorado | 8083 | 4952 | 60 |
2141946 | 2141946 | 2022-01-23 | Montrose | Colorado | 8085 | 8003 | 151 |
2141947 | 2141947 | 2022-01-23 | Morgan | Colorado | 8087 | 4962 | 128 |
2141948 | 2141948 | 2022-01-23 | Otero | Colorado | 8089 | 3775 | 118 |
2141949 | 2141949 | 2022-01-23 | Ouray | Colorado | 8091 | 769 | 6 |
2141950 | 2141950 | 2022-01-23 | Park | Colorado | 8093 | 2513 | 17 |
2141951 | 2141951 | 2022-01-23 | Phillips | Colorado | 8095 | 728 | 15 |
2141952 | 2141952 | 2022-01-23 | Pitkin | Colorado | 8097 | 5789 | 6 |
2141953 | 2141953 | 2022-01-23 | Prowers | Colorado | 8099 | 2289 | 45 |
2141954 | 2141954 | 2022-01-23 | Pueblo | Colorado | 8101 | 39121 | 708 |
2141955 | 2141955 | 2022-01-23 | Rio Blanco | Colorado | 8103 | 1401 | 13 |
2141956 | 2141956 | 2022-01-23 | Rio Grande | Colorado | 8105 | 2311 | 41 |
2141957 | 2141957 | 2022-01-23 | Routt | Colorado | 8107 | 5721 | 24 |
2141958 | 2141958 | 2022-01-23 | Saguache | Colorado | 8109 | 982 | 10 |
2141959 | 2141959 | 2022-01-23 | San Juan | Colorado | 8111 | 175 | 0 |
2141960 | 2141960 | 2022-01-23 | San Miguel | Colorado | 8113 | 2024 | 7 |
2141961 | 2141961 | 2022-01-23 | Sedgwick | Colorado | 8115 | 401 | 7 |
2141962 | 2141962 | 2022-01-23 | Summit | Colorado | 8117 | 8998 | 12 |
2141963 | 2141963 | 2022-01-23 | Teller | Colorado | 8119 | 4255 | 54 |
2141964 | 2141964 | 2022-01-23 | Washington | Colorado | 8121 | 843 | 26 |
2141965 | 2141965 | 2022-01-23 | Weld | Colorado | 8123 | 72372 | 617 |
2141966 | 2141966 | 2022-01-23 | Yuma | Colorado | 8125 | 1644 | 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);