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-07-19 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 |
---|---|---|---|---|---|---|---|
1530989 | 1530989 | 2021-07-19 | Adams | Colorado | 8001 | 62855 | 764 |
1530990 | 1530990 | 2021-07-19 | Alamosa | Colorado | 8003 | 1773 | 37 |
1530991 | 1530991 | 2021-07-19 | Arapahoe | Colorado | 8005 | 64927 | 843 |
1530992 | 1530992 | 2021-07-19 | Archuleta | Colorado | 8007 | 1106 | 3 |
1530993 | 1530993 | 2021-07-19 | Baca | Colorado | 8009 | 325 | 4 |
1530994 | 1530994 | 2021-07-19 | Bent | Colorado | 8011 | 1547 | 22 |
1530995 | 1530995 | 2021-07-19 | Boulder | Colorado | 8013 | 24442 | 261 |
1530996 | 1530996 | 2021-07-19 | Broomfield | Colorado | 8014 | 5071 | 76 |
1530997 | 1530997 | 2021-07-19 | Chaffee | Colorado | 8015 | 1799 | 25 |
1530998 | 1530998 | 2021-07-19 | Cheyenne | Colorado | 8017 | 130 | 6 |
1530999 | 1530999 | 2021-07-19 | Clear Creek | Colorado | 8019 | 488 | 3 |
1531000 | 1531000 | 2021-07-19 | Conejos | Colorado | 8021 | 754 | 24 |
1531001 | 1531001 | 2021-07-19 | Costilla | Colorado | 8023 | 253 | 5 |
1531002 | 1531002 | 2021-07-19 | Crowley | Colorado | 8025 | 2216 | 17 |
1531003 | 1531003 | 2021-07-19 | Custer | Colorado | 8027 | 235 | 2 |
1531004 | 1531004 | 2021-07-19 | Delta | Colorado | 8029 | 3073 | 70 |
1531005 | 1531005 | 2021-07-19 | Denver | Colorado | 8031 | 75170 | 848 |
1531006 | 1531006 | 2021-07-19 | Dolores | Colorado | 8033 | 131 | 1 |
1531007 | 1531007 | 2021-07-19 | Douglas | Colorado | 8035 | 31603 | 272 |
1531008 | 1531008 | 2021-07-19 | Eagle | Colorado | 8037 | 6434 | 23 |
1531009 | 1531009 | 2021-07-19 | El Paso | Colorado | 8041 | 74816 | 890 |
1531010 | 1531010 | 2021-07-19 | Elbert | Colorado | 8039 | 1911 | 14 |
1531011 | 1531011 | 2021-07-19 | Fremont | Colorado | 8043 | 6607 | 64 |
1531012 | 1531012 | 2021-07-19 | Garfield | Colorado | 8045 | 6370 | 51 |
1531013 | 1531013 | 2021-07-19 | Gilpin | Colorado | 8047 | 285 | 3 |
1531014 | 1531014 | 2021-07-19 | Grand | Colorado | 8049 | 1516 | 7 |
1531015 | 1531015 | 2021-07-19 | Gunnison | Colorado | 8051 | 1408 | 6 |
1531016 | 1531016 | 2021-07-19 | Hinsdale | Colorado | 8053 | 30 | 0 |
1531017 | 1531017 | 2021-07-19 | Huerfano | Colorado | 8055 | 448 | 18 |
1531018 | 1531018 | 2021-07-19 | Jackson | Colorado | 8057 | 67 | 0 |
1531019 | 1531019 | 2021-07-19 | Jefferson | Colorado | 8059 | 49480 | 810 |
1531020 | 1531020 | 2021-07-19 | Kiowa | Colorado | 8061 | 95 | 3 |
1531021 | 1531021 | 2021-07-19 | Kit Carson | Colorado | 8063 | 654 | 12 |
1531022 | 1531022 | 2021-07-19 | La Plata | Colorado | 8067 | 4239 | 41 |
1531023 | 1531023 | 2021-07-19 | Lake | Colorado | 8065 | 841 | 0 |
1531024 | 1531024 | 2021-07-19 | Larimer | Colorado | 8069 | 28263 | 248 |
1531025 | 1531025 | 2021-07-19 | Las Animas | Colorado | 8071 | 1229 | 14 |
1531026 | 1531026 | 2021-07-19 | Lincoln | Colorado | 8073 | 1041 | 4 |
1531027 | 1531027 | 2021-07-19 | Logan | Colorado | 8075 | 4071 | 69 |
1531028 | 1531028 | 2021-07-19 | Mesa | Colorado | 8077 | 17879 | 260 |
1531029 | 1531029 | 2021-07-19 | Mineral | Colorado | 8079 | 94 | 1 |
1531030 | 1531030 | 2021-07-19 | Moffat | Colorado | 8081 | 1136 | 26 |
1531031 | 1531031 | 2021-07-19 | Montezuma | Colorado | 8083 | 2142 | 27 |
1531032 | 1531032 | 2021-07-19 | Montrose | Colorado | 8085 | 3925 | 67 |
1531033 | 1531033 | 2021-07-19 | Morgan | Colorado | 8087 | 2768 | 96 |
1531034 | 1531034 | 2021-07-19 | Otero | Colorado | 8089 | 2092 | 67 |
1531035 | 1531035 | 2021-07-19 | Ouray | Colorado | 8091 | 309 | 4 |
1531036 | 1531036 | 2021-07-19 | Park | Colorado | 8093 | 851 | 5 |
1531037 | 1531037 | 2021-07-19 | Phillips | Colorado | 8095 | 401 | 13 |
1531038 | 1531038 | 2021-07-19 | Pitkin | Colorado | 8097 | 2640 | 4 |
1531039 | 1531039 | 2021-07-19 | Prowers | Colorado | 8099 | 1282 | 22 |
1531040 | 1531040 | 2021-07-19 | Pueblo | Colorado | 8101 | 19753 | 423 |
1531041 | 1531041 | 2021-07-19 | Rio Blanco | Colorado | 8103 | 669 | 5 |
1531042 | 1531042 | 2021-07-19 | Rio Grande | Colorado | 8105 | 938 | 18 |
1531043 | 1531043 | 2021-07-19 | Routt | Colorado | 8107 | 2381 | 21 |
1531044 | 1531044 | 2021-07-19 | Saguache | Colorado | 8109 | 466 | 7 |
1531045 | 1531045 | 2021-07-19 | San Juan | Colorado | 8111 | 47 | 0 |
1531046 | 1531046 | 2021-07-19 | San Miguel | Colorado | 8113 | 937 | 1 |
1531047 | 1531047 | 2021-07-19 | Sedgwick | Colorado | 8115 | 235 | 3 |
1531048 | 1531048 | 2021-07-19 | Summit | Colorado | 8117 | 3827 | 8 |
1531049 | 1531049 | 2021-07-19 | Teller | Colorado | 8119 | 1944 | 18 |
1531050 | 1531050 | 2021-07-19 | Washington | Colorado | 8121 | 475 | 13 |
1531051 | 1531051 | 2021-07-19 | Weld | Colorado | 8123 | 33993 | 354 |
1531052 | 1531052 | 2021-07-19 | Yuma | Colorado | 8125 | 973 | 17 |
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);