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 798
- Jefferson 798
- Denver 797
- Eagle 797
- El Paso 797
- Arapahoe 794
- Larimer 794
- Gunnison 793
- Pitkin 793
- Adams 791
- Pueblo 791
- Routt 791
- Summit 791
- Weld 791
- Clear Creek 790
- Mesa 790
- Boulder 789
- Garfield 788
- Yuma 786
- Morgan 785
- Crowley 784
- Grand 784
- Park 784
- San Miguel 784
- Broomfield 783
- Montrose 783
- Chaffee 782
- Elbert 782
- Hinsdale 782
- Logan 781
- …
state 1
- Colorado · 49,427 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2496598 | 2496598 | 2022-05-12 | Las Animas | Colorado | 8071 | 3634 | 43 |
2496599 | 2496599 | 2022-05-12 | Lincoln | Colorado | 8073 | 2199 | 9 |
2496600 | 2496600 | 2022-05-12 | Logan | Colorado | 8075 | 7477 | 109 |
2496601 | 2496601 | 2022-05-12 | Mesa | Colorado | 8077 | 43081 | 564 |
2496602 | 2496602 | 2022-05-12 | Mineral | Colorado | 8079 | 238 | 2 |
2496603 | 2496603 | 2022-05-12 | Moffat | Colorado | 8081 | 3062 | 52 |
2496604 | 2496604 | 2022-05-12 | Montezuma | Colorado | 8083 | 6222 | 81 |
2496605 | 2496605 | 2022-05-12 | Montrose | Colorado | 8085 | 9395 | 160 |
2496606 | 2496606 | 2022-05-12 | Morgan | Colorado | 8087 | 5734 | 138 |
2496607 | 2496607 | 2022-05-12 | Otero | Colorado | 8089 | 4319 | 130 |
2496608 | 2496608 | 2022-05-12 | Ouray | Colorado | 8091 | 882 | 6 |
2496609 | 2496609 | 2022-05-12 | Park | Colorado | 8093 | 2908 | 20 |
2496610 | 2496610 | 2022-05-12 | Phillips | Colorado | 8095 | 894 | 19 |
2496611 | 2496611 | 2022-05-12 | Pitkin | Colorado | 8097 | 6671 | 7 |
2496612 | 2496612 | 2022-05-12 | Prowers | Colorado | 8099 | 2654 | 51 |
2496613 | 2496613 | 2022-05-12 | Pueblo | Colorado | 8101 | 47647 | 802 |
2496614 | 2496614 | 2022-05-12 | Rio Blanco | Colorado | 8103 | 1694 | 13 |
2496615 | 2496615 | 2022-05-12 | Rio Grande | Colorado | 8105 | 2855 | 46 |
2496616 | 2496616 | 2022-05-12 | Routt | Colorado | 8107 | 6544 | 25 |
2496617 | 2496617 | 2022-05-12 | Saguache | Colorado | 8109 | 1202 | 12 |
2496618 | 2496618 | 2022-05-12 | San Juan | Colorado | 8111 | 203 | 0 |
2496619 | 2496619 | 2022-05-12 | San Miguel | Colorado | 8113 | 2321 | 8 |
2496620 | 2496620 | 2022-05-12 | Sedgwick | Colorado | 8115 | 490 | 11 |
2496621 | 2496621 | 2022-05-12 | Summit | Colorado | 8117 | 10081 | 14 |
2496622 | 2496622 | 2022-05-12 | Teller | Colorado | 8119 | 4894 | 57 |
2496623 | 2496623 | 2022-05-12 | Washington | Colorado | 8121 | 1065 | 28 |
2496624 | 2496624 | 2022-05-12 | Weld | Colorado | 8123 | 85569 | 703 |
2496625 | 2496625 | 2022-05-12 | Yuma | Colorado | 8125 | 1886 | 23 |
2493304 | 2493304 | 2022-05-11 | Adams | Colorado | 8001 | 137428 | 1378 |
2493305 | 2493305 | 2022-05-11 | Alamosa | Colorado | 8003 | 4549 | 62 |
2493306 | 2493306 | 2022-05-11 | Arapahoe | Colorado | 8005 | 158044 | 1283 |
2493307 | 2493307 | 2022-05-11 | Archuleta | Colorado | 8007 | 2914 | 16 |
2493308 | 2493308 | 2022-05-11 | Baca | Colorado | 8009 | 852 | 13 |
2493309 | 2493309 | 2022-05-11 | Bent | Colorado | 8011 | 2550 | 47 |
2493310 | 2493310 | 2022-05-11 | Boulder | Colorado | 8013 | 67280 | 373 |
2493311 | 2493311 | 2022-05-11 | Broomfield | Colorado | 8014 | 13868 | 116 |
2493312 | 2493312 | 2022-05-11 | Chaffee | Colorado | 8015 | 4722 | 47 |
2493313 | 2493313 | 2022-05-11 | Cheyenne | Colorado | 8017 | 322 | 9 |
2493314 | 2493314 | 2022-05-11 | Clear Creek | Colorado | 8019 | 1588 | 12 |
2493315 | 2493315 | 2022-05-11 | Conejos | Colorado | 8021 | 1758 | 54 |
2493316 | 2493316 | 2022-05-11 | Costilla | Colorado | 8023 | 703 | 18 |
2493317 | 2493317 | 2022-05-11 | Crowley | Colorado | 8025 | 3342 | 30 |
2493318 | 2493318 | 2022-05-11 | Custer | Colorado | 8027 | 656 | 21 |
2493319 | 2493319 | 2022-05-11 | Delta | Colorado | 8029 | 6195 | 140 |
2493320 | 2493320 | 2022-05-11 | Denver | Colorado | 8031 | 175501 | 1359 |
2493321 | 2493321 | 2022-05-11 | Dolores | Colorado | 8033 | 367 | 8 |
2493322 | 2493322 | 2022-05-11 | Douglas | Colorado | 8035 | 81128 | 459 |
2493323 | 2493323 | 2022-05-11 | Eagle | Colorado | 8037 | 16221 | 35 |
2493324 | 2493324 | 2022-05-11 | El Paso | Colorado | 8041 | 188797 | 1694 |
2493325 | 2493325 | 2022-05-11 | Elbert | Colorado | 8039 | 4834 | 40 |
2493326 | 2493326 | 2022-05-11 | Fremont | Colorado | 8043 | 15410 | 187 |
2493327 | 2493327 | 2022-05-11 | Garfield | Colorado | 8045 | 15020 | 91 |
2493328 | 2493328 | 2022-05-11 | Gilpin | Colorado | 8047 | 973 | 5 |
2493329 | 2493329 | 2022-05-11 | Grand | Colorado | 8049 | 3596 | 28 |
2493330 | 2493330 | 2022-05-11 | Gunnison | Colorado | 8051 | 3401 | 14 |
2493331 | 2493331 | 2022-05-11 | Hinsdale | Colorado | 8053 | 131 | 0 |
2493332 | 2493332 | 2022-05-11 | Huerfano | Colorado | 8055 | 1449 | 35 |
2493333 | 2493333 | 2022-05-11 | Jackson | Colorado | 8057 | 165 | 0 |
2493334 | 2493334 | 2022-05-11 | Jefferson | Colorado | 8059 | 126767 | 1356 |
2493335 | 2493335 | 2022-05-11 | Kiowa | Colorado | 8061 | 336 | 6 |
2493336 | 2493336 | 2022-05-11 | Kit Carson | Colorado | 8063 | 1616 | 33 |
2493337 | 2493337 | 2022-05-11 | La Plata | Colorado | 8067 | 12945 | 86 |
2493338 | 2493338 | 2022-05-11 | Lake | Colorado | 8065 | 1826 | 2 |
2493339 | 2493339 | 2022-05-11 | Larimer | Colorado | 8069 | 80284 | 503 |
2493340 | 2493340 | 2022-05-11 | Las Animas | Colorado | 8071 | 3623 | 43 |
2493341 | 2493341 | 2022-05-11 | Lincoln | Colorado | 8073 | 2186 | 9 |
2493342 | 2493342 | 2022-05-11 | Logan | Colorado | 8075 | 7468 | 109 |
2493343 | 2493343 | 2022-05-11 | Mesa | Colorado | 8077 | 42933 | 563 |
2493344 | 2493344 | 2022-05-11 | Mineral | Colorado | 8079 | 237 | 2 |
2493345 | 2493345 | 2022-05-11 | Moffat | Colorado | 8081 | 3046 | 52 |
2493346 | 2493346 | 2022-05-11 | Montezuma | Colorado | 8083 | 6213 | 81 |
2493347 | 2493347 | 2022-05-11 | Montrose | Colorado | 8085 | 9370 | 160 |
2493348 | 2493348 | 2022-05-11 | Morgan | Colorado | 8087 | 5707 | 138 |
2493349 | 2493349 | 2022-05-11 | Otero | Colorado | 8089 | 4309 | 130 |
2493350 | 2493350 | 2022-05-11 | Ouray | Colorado | 8091 | 875 | 6 |
2493351 | 2493351 | 2022-05-11 | Park | Colorado | 8093 | 2890 | 20 |
2493352 | 2493352 | 2022-05-11 | Phillips | Colorado | 8095 | 890 | 19 |
2493353 | 2493353 | 2022-05-11 | Pitkin | Colorado | 8097 | 6631 | 7 |
2493354 | 2493354 | 2022-05-11 | Prowers | Colorado | 8099 | 2647 | 51 |
2493355 | 2493355 | 2022-05-11 | Pueblo | Colorado | 8101 | 47261 | 801 |
2493356 | 2493356 | 2022-05-11 | Rio Blanco | Colorado | 8103 | 1685 | 13 |
2493357 | 2493357 | 2022-05-11 | Rio Grande | Colorado | 8105 | 2848 | 46 |
2493358 | 2493358 | 2022-05-11 | Routt | Colorado | 8107 | 6517 | 25 |
2493359 | 2493359 | 2022-05-11 | Saguache | Colorado | 8109 | 1200 | 12 |
2493360 | 2493360 | 2022-05-11 | San Juan | Colorado | 8111 | 203 | 0 |
2493361 | 2493361 | 2022-05-11 | San Miguel | Colorado | 8113 | 2315 | 8 |
2493362 | 2493362 | 2022-05-11 | Sedgwick | Colorado | 8115 | 489 | 11 |
2493363 | 2493363 | 2022-05-11 | Summit | Colorado | 8117 | 10003 | 14 |
2493364 | 2493364 | 2022-05-11 | Teller | Colorado | 8119 | 4884 | 57 |
2493365 | 2493365 | 2022-05-11 | Washington | Colorado | 8121 | 1063 | 28 |
2493366 | 2493366 | 2022-05-11 | Weld | Colorado | 8123 | 85522 | 703 |
2493367 | 2493367 | 2022-05-11 | Yuma | Colorado | 8125 | 1883 | 23 |
2490046 | 2490046 | 2022-05-10 | Adams | Colorado | 8001 | 137373 | 1378 |
2490047 | 2490047 | 2022-05-10 | Alamosa | Colorado | 8003 | 4549 | 62 |
2490048 | 2490048 | 2022-05-10 | Arapahoe | Colorado | 8005 | 157941 | 1283 |
2490049 | 2490049 | 2022-05-10 | Archuleta | Colorado | 8007 | 2912 | 16 |
2490050 | 2490050 | 2022-05-10 | Baca | Colorado | 8009 | 850 | 13 |
2490051 | 2490051 | 2022-05-10 | Bent | Colorado | 8011 | 2549 | 47 |
2490052 | 2490052 | 2022-05-10 | Boulder | Colorado | 8013 | 66988 | 390 |
2490053 | 2490053 | 2022-05-10 | Broomfield | Colorado | 8014 | 13842 | 116 |
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);