ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64 rows where date = "2022-03-24" 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 |
---|---|---|---|---|---|---|---|
2337049 | 2337049 | 2022-03-24 | Adams | Colorado | 8001 | 132598 | 1315 |
2337050 | 2337050 | 2022-03-24 | Alamosa | Colorado | 8003 | 4489 | 61 |
2337051 | 2337051 | 2022-03-24 | Arapahoe | Colorado | 8005 | 151366 | 1240 |
2337052 | 2337052 | 2022-03-24 | Archuleta | Colorado | 8007 | 2856 | 15 |
2337053 | 2337053 | 2022-03-24 | Baca | Colorado | 8009 | 836 | 8 |
2337054 | 2337054 | 2022-03-24 | Bent | Colorado | 8011 | 2511 | 47 |
2337055 | 2337055 | 2022-03-24 | Boulder | Colorado | 8013 | 62618 | 388 |
2337056 | 2337056 | 2022-03-24 | Broomfield | Colorado | 8014 | 13143 | 112 |
2337057 | 2337057 | 2022-03-24 | Chaffee | Colorado | 8015 | 4400 | 44 |
2337058 | 2337058 | 2022-03-24 | Cheyenne | Colorado | 8017 | 321 | 9 |
2337059 | 2337059 | 2022-03-24 | Clear Creek | Colorado | 8019 | 1518 | 12 |
2337060 | 2337060 | 2022-03-24 | Conejos | Colorado | 8021 | 1721 | 54 |
2337061 | 2337061 | 2022-03-24 | Costilla | Colorado | 8023 | 675 | 16 |
2337062 | 2337062 | 2022-03-24 | Crowley | Colorado | 8025 | 3150 | 28 |
2337063 | 2337063 | 2022-03-24 | Custer | Colorado | 8027 | 636 | 19 |
2337064 | 2337064 | 2022-03-24 | Delta | Colorado | 8029 | 5972 | 134 |
2337065 | 2337065 | 2022-03-24 | Denver | Colorado | 8031 | 167062 | 1283 |
2337066 | 2337066 | 2022-03-24 | Dolores | Colorado | 8033 | 355 | 8 |
2337067 | 2337067 | 2022-03-24 | Douglas | Colorado | 8035 | 77551 | 431 |
2337068 | 2337068 | 2022-03-24 | Eagle | Colorado | 8037 | 15799 | 35 |
2337069 | 2337069 | 2022-03-24 | El Paso | Colorado | 8041 | 182100 | 1609 |
2337070 | 2337070 | 2022-03-24 | Elbert | Colorado | 8039 | 4715 | 37 |
2337071 | 2337071 | 2022-03-24 | Fremont | Colorado | 8043 | 15061 | 177 |
2337072 | 2337072 | 2022-03-24 | Garfield | Colorado | 8045 | 14422 | 90 |
2337073 | 2337073 | 2022-03-24 | Gilpin | Colorado | 8047 | 936 | 4 |
2337074 | 2337074 | 2022-03-24 | Grand | Colorado | 8049 | 3455 | 25 |
2337075 | 2337075 | 2022-03-24 | Gunnison | Colorado | 8051 | 3337 | 14 |
2337076 | 2337076 | 2022-03-24 | Hinsdale | Colorado | 8053 | 123 | 0 |
2337077 | 2337077 | 2022-03-24 | Huerfano | Colorado | 8055 | 1438 | 31 |
2337078 | 2337078 | 2022-03-24 | Jackson | Colorado | 8057 | 164 | 0 |
2337079 | 2337079 | 2022-03-24 | Jefferson | Colorado | 8059 | 120508 | 1319 |
2337080 | 2337080 | 2022-03-24 | Kiowa | Colorado | 8061 | 332 | 6 |
2337081 | 2337081 | 2022-03-24 | Kit Carson | Colorado | 8063 | 1594 | 31 |
2337082 | 2337082 | 2022-03-24 | La Plata | Colorado | 8067 | 12634 | 80 |
2337083 | 2337083 | 2022-03-24 | Lake | Colorado | 8065 | 1785 | 2 |
2337084 | 2337084 | 2022-03-24 | Larimer | Colorado | 8069 | 75722 | 477 |
2337085 | 2337085 | 2022-03-24 | Las Animas | Colorado | 8071 | 3545 | 41 |
2337086 | 2337086 | 2022-03-24 | Lincoln | Colorado | 8073 | 2121 | 9 |
2337087 | 2337087 | 2022-03-24 | Logan | Colorado | 8075 | 7314 | 106 |
2337088 | 2337088 | 2022-03-24 | Mesa | Colorado | 8077 | 41979 | 529 |
2337089 | 2337089 | 2022-03-24 | Mineral | Colorado | 8079 | 225 | 1 |
2337090 | 2337090 | 2022-03-24 | Moffat | Colorado | 8081 | 2988 | 51 |
2337091 | 2337091 | 2022-03-24 | Montezuma | Colorado | 8083 | 6138 | 72 |
2337092 | 2337092 | 2022-03-24 | Montrose | Colorado | 8085 | 9196 | 158 |
2337093 | 2337093 | 2022-03-24 | Morgan | Colorado | 8087 | 5552 | 135 |
2337094 | 2337094 | 2022-03-24 | Otero | Colorado | 8089 | 4246 | 126 |
2337095 | 2337095 | 2022-03-24 | Ouray | Colorado | 8091 | 852 | 6 |
2337096 | 2337096 | 2022-03-24 | Park | Colorado | 8093 | 2778 | 20 |
2337097 | 2337097 | 2022-03-24 | Phillips | Colorado | 8095 | 869 | 18 |
2337098 | 2337098 | 2022-03-24 | Pitkin | Colorado | 8097 | 6330 | 6 |
2337099 | 2337099 | 2022-03-24 | Prowers | Colorado | 8099 | 2608 | 48 |
2337100 | 2337100 | 2022-03-24 | Pueblo | Colorado | 8101 | 45399 | 773 |
2337101 | 2337101 | 2022-03-24 | Rio Blanco | Colorado | 8103 | 1665 | 13 |
2337102 | 2337102 | 2022-03-24 | Rio Grande | Colorado | 8105 | 2775 | 46 |
2337103 | 2337103 | 2022-03-24 | Routt | Colorado | 8107 | 6335 | 24 |
2337104 | 2337104 | 2022-03-24 | Saguache | Colorado | 8109 | 1167 | 12 |
2337105 | 2337105 | 2022-03-24 | San Juan | Colorado | 8111 | 196 | 0 |
2337106 | 2337106 | 2022-03-24 | San Miguel | Colorado | 8113 | 2247 | 8 |
2337107 | 2337107 | 2022-03-24 | Sedgwick | Colorado | 8115 | 481 | 9 |
2337108 | 2337108 | 2022-03-24 | Summit | Colorado | 8117 | 9707 | 14 |
2337109 | 2337109 | 2022-03-24 | Teller | Colorado | 8119 | 4765 | 57 |
2337110 | 2337110 | 2022-03-24 | Washington | Colorado | 8121 | 1052 | 27 |
2337111 | 2337111 | 2022-03-24 | Weld | Colorado | 8123 | 81996 | 693 |
2337112 | 2337112 | 2022-03-24 | Yuma | Colorado | 8125 | 1860 | 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);