ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
49,527 rows where state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Douglas 797
- Jefferson 797
- Denver 796
- Eagle 796
- El Paso 796
- Larimer 793
- Arapahoe 792
- Gunnison 792
- Pitkin 791
- Adams 789
- Clear Creek 789
- Pueblo 789
- Routt 789
- Summit 789
- Weld 789
- Mesa 788
- Boulder 787
- Garfield 787
- Yuma 784
- Crowley 783
- Grand 783
- Morgan 783
- Park 782
- San Miguel 782
- Broomfield 781
- Chaffee 781
- Elbert 781
- Hinsdale 781
- Montrose 781
- La Plata 779
- …
state 1
- Colorado · 49,327 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2490054 | 2490054 | 2022-05-10 | Chaffee | Colorado | 8015 | 4717 | 47 |
2490055 | 2490055 | 2022-05-10 | Cheyenne | Colorado | 8017 | 322 | 9 |
2490056 | 2490056 | 2022-05-10 | Clear Creek | Colorado | 8019 | 1587 | 12 |
2490057 | 2490057 | 2022-05-10 | Conejos | Colorado | 8021 | 1757 | 54 |
2490058 | 2490058 | 2022-05-10 | Costilla | Colorado | 8023 | 703 | 18 |
2490059 | 2490059 | 2022-05-10 | Crowley | Colorado | 8025 | 3342 | 30 |
2490060 | 2490060 | 2022-05-10 | Custer | Colorado | 8027 | 655 | 21 |
2490061 | 2490061 | 2022-05-10 | Delta | Colorado | 8029 | 6195 | 140 |
2490062 | 2490062 | 2022-05-10 | Denver | Colorado | 8031 | 175374 | 1357 |
2490063 | 2490063 | 2022-05-10 | Dolores | Colorado | 8033 | 367 | 8 |
2490064 | 2490064 | 2022-05-10 | Douglas | Colorado | 8035 | 81050 | 458 |
2490065 | 2490065 | 2022-05-10 | Eagle | Colorado | 8037 | 16203 | 35 |
2490066 | 2490066 | 2022-05-10 | El Paso | Colorado | 8041 | 188684 | 1694 |
2490067 | 2490067 | 2022-05-10 | Elbert | Colorado | 8039 | 4831 | 40 |
2490068 | 2490068 | 2022-05-10 | Fremont | Colorado | 8043 | 15407 | 187 |
2490069 | 2490069 | 2022-05-10 | Garfield | Colorado | 8045 | 15012 | 91 |
2490070 | 2490070 | 2022-05-10 | Gilpin | Colorado | 8047 | 972 | 4 |
2490071 | 2490071 | 2022-05-10 | Grand | Colorado | 8049 | 3593 | 28 |
2490072 | 2490072 | 2022-05-10 | Gunnison | Colorado | 8051 | 3402 | 14 |
2490073 | 2490073 | 2022-05-10 | Hinsdale | Colorado | 8053 | 131 | 0 |
2490074 | 2490074 | 2022-05-10 | Huerfano | Colorado | 8055 | 1449 | 35 |
2490075 | 2490075 | 2022-05-10 | Jackson | Colorado | 8057 | 165 | 0 |
2490076 | 2490076 | 2022-05-10 | Jefferson | Colorado | 8059 | 126673 | 1356 |
2490077 | 2490077 | 2022-05-10 | Kiowa | Colorado | 8061 | 336 | 6 |
2490078 | 2490078 | 2022-05-10 | Kit Carson | Colorado | 8063 | 1614 | 34 |
2490079 | 2490079 | 2022-05-10 | La Plata | Colorado | 8067 | 12943 | 86 |
2490080 | 2490080 | 2022-05-10 | Lake | Colorado | 8065 | 1825 | 2 |
2490081 | 2490081 | 2022-05-10 | Larimer | Colorado | 8069 | 80142 | 503 |
2490082 | 2490082 | 2022-05-10 | Las Animas | Colorado | 8071 | 3623 | 43 |
2490083 | 2490083 | 2022-05-10 | Lincoln | Colorado | 8073 | 2185 | 9 |
2490084 | 2490084 | 2022-05-10 | Logan | Colorado | 8075 | 7466 | 109 |
2490085 | 2490085 | 2022-05-10 | Mesa | Colorado | 8077 | 42913 | 563 |
2490086 | 2490086 | 2022-05-10 | Mineral | Colorado | 8079 | 237 | 2 |
2490087 | 2490087 | 2022-05-10 | Moffat | Colorado | 8081 | 3045 | 52 |
2490088 | 2490088 | 2022-05-10 | Montezuma | Colorado | 8083 | 6211 | 81 |
2490089 | 2490089 | 2022-05-10 | Montrose | Colorado | 8085 | 9369 | 160 |
2490090 | 2490090 | 2022-05-10 | Morgan | Colorado | 8087 | 5706 | 138 |
2490091 | 2490091 | 2022-05-10 | Otero | Colorado | 8089 | 4309 | 130 |
2490092 | 2490092 | 2022-05-10 | Ouray | Colorado | 8091 | 875 | 6 |
2490093 | 2490093 | 2022-05-10 | Park | Colorado | 8093 | 2883 | 20 |
2490094 | 2490094 | 2022-05-10 | Phillips | Colorado | 8095 | 890 | 19 |
2490095 | 2490095 | 2022-05-10 | Pitkin | Colorado | 8097 | 6624 | 7 |
2490096 | 2490096 | 2022-05-10 | Prowers | Colorado | 8099 | 2645 | 51 |
2490097 | 2490097 | 2022-05-10 | Pueblo | Colorado | 8101 | 47224 | 801 |
2490098 | 2490098 | 2022-05-10 | Rio Blanco | Colorado | 8103 | 1685 | 13 |
2490099 | 2490099 | 2022-05-10 | Rio Grande | Colorado | 8105 | 2847 | 46 |
2490100 | 2490100 | 2022-05-10 | Routt | Colorado | 8107 | 6516 | 25 |
2490101 | 2490101 | 2022-05-10 | Saguache | Colorado | 8109 | 1200 | 12 |
2490102 | 2490102 | 2022-05-10 | San Juan | Colorado | 8111 | 203 | 0 |
2490103 | 2490103 | 2022-05-10 | San Miguel | Colorado | 8113 | 2314 | 8 |
2490104 | 2490104 | 2022-05-10 | Sedgwick | Colorado | 8115 | 489 | 10 |
2490105 | 2490105 | 2022-05-10 | Summit | Colorado | 8117 | 10004 | 14 |
2490106 | 2490106 | 2022-05-10 | Teller | Colorado | 8119 | 4880 | 57 |
2490107 | 2490107 | 2022-05-10 | Washington | Colorado | 8121 | 1063 | 28 |
2490108 | 2490108 | 2022-05-10 | Weld | Colorado | 8123 | 85522 | 702 |
2490109 | 2490109 | 2022-05-10 | Yuma | Colorado | 8125 | 1883 | 23 |
2486789 | 2486789 | 2022-05-09 | Adams | Colorado | 8001 | 137047 | 1376 |
2486790 | 2486790 | 2022-05-09 | Alamosa | Colorado | 8003 | 4547 | 62 |
2486791 | 2486791 | 2022-05-09 | Arapahoe | Colorado | 8005 | 157351 | 1283 |
2486792 | 2486792 | 2022-05-09 | Archuleta | Colorado | 8007 | 2911 | 16 |
2486793 | 2486793 | 2022-05-09 | Baca | Colorado | 8009 | 850 | 13 |
2486794 | 2486794 | 2022-05-09 | Bent | Colorado | 8011 | 2549 | 47 |
2486795 | 2486795 | 2022-05-09 | Boulder | Colorado | 8013 | 66988 | 390 |
2486796 | 2486796 | 2022-05-09 | Broomfield | Colorado | 8014 | 13811 | 116 |
2486797 | 2486797 | 2022-05-09 | Chaffee | Colorado | 8015 | 4709 | 47 |
2486798 | 2486798 | 2022-05-09 | Cheyenne | Colorado | 8017 | 322 | 9 |
2486799 | 2486799 | 2022-05-09 | Clear Creek | Colorado | 8019 | 1587 | 12 |
2486800 | 2486800 | 2022-05-09 | Conejos | Colorado | 8021 | 1757 | 54 |
2486801 | 2486801 | 2022-05-09 | Costilla | Colorado | 8023 | 702 | 17 |
2486802 | 2486802 | 2022-05-09 | Crowley | Colorado | 8025 | 3342 | 30 |
2486803 | 2486803 | 2022-05-09 | Custer | Colorado | 8027 | 655 | 21 |
2486804 | 2486804 | 2022-05-09 | Delta | Colorado | 8029 | 6191 | 140 |
2486805 | 2486805 | 2022-05-09 | Denver | Colorado | 8031 | 175189 | 1356 |
2486806 | 2486806 | 2022-05-09 | Dolores | Colorado | 8033 | 367 | 8 |
2486807 | 2486807 | 2022-05-09 | Douglas | Colorado | 8035 | 80797 | 457 |
2486808 | 2486808 | 2022-05-09 | Eagle | Colorado | 8037 | 16195 | 35 |
2486809 | 2486809 | 2022-05-09 | El Paso | Colorado | 8041 | 188527 | 1695 |
2486810 | 2486810 | 2022-05-09 | Elbert | Colorado | 8039 | 4826 | 40 |
2486811 | 2486811 | 2022-05-09 | Fremont | Colorado | 8043 | 15403 | 187 |
2486812 | 2486812 | 2022-05-09 | Garfield | Colorado | 8045 | 15005 | 91 |
2486813 | 2486813 | 2022-05-09 | Gilpin | Colorado | 8047 | 969 | 4 |
2486814 | 2486814 | 2022-05-09 | Grand | Colorado | 8049 | 3590 | 28 |
2486815 | 2486815 | 2022-05-09 | Gunnison | Colorado | 8051 | 3402 | 14 |
2486816 | 2486816 | 2022-05-09 | Hinsdale | Colorado | 8053 | 131 | 0 |
2486817 | 2486817 | 2022-05-09 | Huerfano | Colorado | 8055 | 1449 | 35 |
2486818 | 2486818 | 2022-05-09 | Jackson | Colorado | 8057 | 165 | 0 |
2486819 | 2486819 | 2022-05-09 | Jefferson | Colorado | 8059 | 126559 | 1354 |
2486820 | 2486820 | 2022-05-09 | Kiowa | Colorado | 8061 | 336 | 6 |
2486821 | 2486821 | 2022-05-09 | Kit Carson | Colorado | 8063 | 1614 | 33 |
2486822 | 2486822 | 2022-05-09 | La Plata | Colorado | 8067 | 12941 | 86 |
2486823 | 2486823 | 2022-05-09 | Lake | Colorado | 8065 | 1824 | 2 |
2486824 | 2486824 | 2022-05-09 | Larimer | Colorado | 8069 | 80033 | 502 |
2486825 | 2486825 | 2022-05-09 | Las Animas | Colorado | 8071 | 3622 | 43 |
2486826 | 2486826 | 2022-05-09 | Lincoln | Colorado | 8073 | 2184 | 9 |
2486827 | 2486827 | 2022-05-09 | Logan | Colorado | 8075 | 7463 | 109 |
2486828 | 2486828 | 2022-05-09 | Mesa | Colorado | 8077 | 42900 | 563 |
2486829 | 2486829 | 2022-05-09 | Mineral | Colorado | 8079 | 233 | 2 |
2486830 | 2486830 | 2022-05-09 | Moffat | Colorado | 8081 | 3045 | 52 |
2486831 | 2486831 | 2022-05-09 | Montezuma | Colorado | 8083 | 6208 | 81 |
2486832 | 2486832 | 2022-05-09 | Montrose | Colorado | 8085 | 9366 | 160 |
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);