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-03-12 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2298014 | 2298014 | 2022-03-12 | Adams | Colorado | 8001 | 131529 | 1310 |
2298015 | 2298015 | 2022-03-12 | Alamosa | Colorado | 8003 | 4469 | 60 |
2298016 | 2298016 | 2022-03-12 | Arapahoe | Colorado | 8005 | 150022 | 1235 |
2298017 | 2298017 | 2022-03-12 | Archuleta | Colorado | 8007 | 2847 | 15 |
2298018 | 2298018 | 2022-03-12 | Baca | Colorado | 8009 | 825 | 8 |
2298019 | 2298019 | 2022-03-12 | Bent | Colorado | 8011 | 2494 | 47 |
2298020 | 2298020 | 2022-03-12 | Boulder | Colorado | 8013 | 61669 | 383 |
2298021 | 2298021 | 2022-03-12 | Broomfield | Colorado | 8014 | 13008 | 112 |
2298022 | 2298022 | 2022-03-12 | Chaffee | Colorado | 8015 | 4347 | 42 |
2298023 | 2298023 | 2022-03-12 | Cheyenne | Colorado | 8017 | 321 | 9 |
2298024 | 2298024 | 2022-03-12 | Clear Creek | Colorado | 8019 | 1505 | 11 |
2298025 | 2298025 | 2022-03-12 | Conejos | Colorado | 8021 | 1704 | 52 |
2298026 | 2298026 | 2022-03-12 | Costilla | Colorado | 8023 | 667 | 15 |
2298027 | 2298027 | 2022-03-12 | Crowley | Colorado | 8025 | 3146 | 28 |
2298028 | 2298028 | 2022-03-12 | Custer | Colorado | 8027 | 627 | 19 |
2298029 | 2298029 | 2022-03-12 | Delta | Colorado | 8029 | 5938 | 131 |
2298030 | 2298030 | 2022-03-12 | Denver | Colorado | 8031 | 165670 | 1275 |
2298031 | 2298031 | 2022-03-12 | Dolores | Colorado | 8033 | 355 | 8 |
2298032 | 2298032 | 2022-03-12 | Douglas | Colorado | 8035 | 76841 | 429 |
2298033 | 2298033 | 2022-03-12 | Eagle | Colorado | 8037 | 15711 | 35 |
2298034 | 2298034 | 2022-03-12 | El Paso | Colorado | 8041 | 180419 | 1595 |
2298035 | 2298035 | 2022-03-12 | Elbert | Colorado | 8039 | 4676 | 37 |
2298036 | 2298036 | 2022-03-12 | Fremont | Colorado | 8043 | 14782 | 177 |
2298037 | 2298037 | 2022-03-12 | Garfield | Colorado | 8045 | 14282 | 89 |
2298038 | 2298038 | 2022-03-12 | Gilpin | Colorado | 8047 | 926 | 4 |
2298039 | 2298039 | 2022-03-12 | Grand | Colorado | 8049 | 3436 | 23 |
2298040 | 2298040 | 2022-03-12 | Gunnison | Colorado | 8051 | 3299 | 14 |
2298041 | 2298041 | 2022-03-12 | Hinsdale | Colorado | 8053 | 123 | 0 |
2298042 | 2298042 | 2022-03-12 | Huerfano | Colorado | 8055 | 1427 | 31 |
2298043 | 2298043 | 2022-03-12 | Jackson | Colorado | 8057 | 164 | 0 |
2298044 | 2298044 | 2022-03-12 | Jefferson | Colorado | 8059 | 119134 | 1307 |
2298045 | 2298045 | 2022-03-12 | Kiowa | Colorado | 8061 | 330 | 6 |
2298046 | 2298046 | 2022-03-12 | Kit Carson | Colorado | 8063 | 1586 | 30 |
2298047 | 2298047 | 2022-03-12 | La Plata | Colorado | 8067 | 12558 | 80 |
2298048 | 2298048 | 2022-03-12 | Lake | Colorado | 8065 | 1777 | 2 |
2298049 | 2298049 | 2022-03-12 | Larimer | Colorado | 8069 | 74557 | 460 |
2298050 | 2298050 | 2022-03-12 | Las Animas | Colorado | 8071 | 3528 | 40 |
2298051 | 2298051 | 2022-03-12 | Lincoln | Colorado | 8073 | 2106 | 9 |
2298052 | 2298052 | 2022-03-12 | Logan | Colorado | 8075 | 7261 | 106 |
2298053 | 2298053 | 2022-03-12 | Mesa | Colorado | 8077 | 41656 | 528 |
2298054 | 2298054 | 2022-03-12 | Mineral | Colorado | 8079 | 224 | 1 |
2298055 | 2298055 | 2022-03-12 | Moffat | Colorado | 8081 | 2953 | 51 |
2298056 | 2298056 | 2022-03-12 | Montezuma | Colorado | 8083 | 6064 | 68 |
2298057 | 2298057 | 2022-03-12 | Montrose | Colorado | 8085 | 9114 | 158 |
2298058 | 2298058 | 2022-03-12 | Morgan | Colorado | 8087 | 5500 | 134 |
2298059 | 2298059 | 2022-03-12 | Otero | Colorado | 8089 | 4228 | 125 |
2298060 | 2298060 | 2022-03-12 | Ouray | Colorado | 8091 | 842 | 6 |
2298061 | 2298061 | 2022-03-12 | Park | Colorado | 8093 | 2755 | 20 |
2298062 | 2298062 | 2022-03-12 | Phillips | Colorado | 8095 | 864 | 18 |
2298063 | 2298063 | 2022-03-12 | Pitkin | Colorado | 8097 | 6259 | 6 |
2298064 | 2298064 | 2022-03-12 | Prowers | Colorado | 8099 | 2587 | 48 |
2298065 | 2298065 | 2022-03-12 | Pueblo | Colorado | 8101 | 44695 | 771 |
2298066 | 2298066 | 2022-03-12 | Rio Blanco | Colorado | 8103 | 1652 | 13 |
2298067 | 2298067 | 2022-03-12 | Rio Grande | Colorado | 8105 | 2753 | 46 |
2298068 | 2298068 | 2022-03-12 | Routt | Colorado | 8107 | 6288 | 24 |
2298069 | 2298069 | 2022-03-12 | Saguache | Colorado | 8109 | 1156 | 12 |
2298070 | 2298070 | 2022-03-12 | San Juan | Colorado | 8111 | 193 | 0 |
2298071 | 2298071 | 2022-03-12 | San Miguel | Colorado | 8113 | 2229 | 8 |
2298072 | 2298072 | 2022-03-12 | Sedgwick | Colorado | 8115 | 478 | 9 |
2298073 | 2298073 | 2022-03-12 | Summit | Colorado | 8117 | 9607 | 14 |
2298074 | 2298074 | 2022-03-12 | Teller | Colorado | 8119 | 4740 | 55 |
2298075 | 2298075 | 2022-03-12 | Washington | Colorado | 8121 | 1041 | 27 |
2298076 | 2298076 | 2022-03-12 | Weld | Colorado | 8123 | 81124 | 686 |
2298077 | 2298077 | 2022-03-12 | Yuma | Colorado | 8125 | 1849 | 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);