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 424
- Jefferson 424
- Denver 423
- Eagle 423
- El Paso 423
- Arapahoe 420
- Larimer 420
- Gunnison 419
- Pitkin 418
- Adams 417
- Clear Creek 416
- Pueblo 416
- Routt 416
- Summit 416
- Weld 416
- Boulder 415
- Mesa 415
- Garfield 414
- Yuma 411
- Crowley 410
- Grand 410
- Morgan 410
- Broomfield 409
- Park 409
- San Miguel 409
- Chaffee 408
- Elbert 408
- Hinsdale 408
- Montrose 408
- La Plata 406
- …
state 1
- Colorado · 25,463 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1277788 | 1277788 | 2021-05-02 | Adams | Colorado | 8001 | 57422 | 701 |
1277789 | 1277789 | 2021-05-02 | Alamosa | Colorado | 8003 | 1463 | 30 |
1277790 | 1277790 | 2021-05-02 | Arapahoe | Colorado | 8005 | 58989 | 773 |
1277791 | 1277791 | 2021-05-02 | Archuleta | Colorado | 8007 | 908 | 1 |
1277792 | 1277792 | 2021-05-02 | Baca | Colorado | 8009 | 289 | 4 |
1277793 | 1277793 | 2021-05-02 | Bent | Colorado | 8011 | 1524 | 21 |
1277794 | 1277794 | 2021-05-02 | Boulder | Colorado | 8013 | 23068 | 254 |
1277795 | 1277795 | 2021-05-02 | Broomfield | Colorado | 8014 | 4690 | 75 |
1277796 | 1277796 | 2021-05-02 | Chaffee | Colorado | 8015 | 1633 | 25 |
1277797 | 1277797 | 2021-05-02 | Cheyenne | Colorado | 8017 | 127 | 6 |
1277798 | 1277798 | 2021-05-02 | Clear Creek | Colorado | 8019 | 438 | 3 |
1277799 | 1277799 | 2021-05-02 | Conejos | Colorado | 8021 | 518 | 10 |
1277800 | 1277800 | 2021-05-02 | Costilla | Colorado | 8023 | 208 | 2 |
1277801 | 1277801 | 2021-05-02 | Crowley | Colorado | 8025 | 2181 | 15 |
1277802 | 1277802 | 2021-05-02 | Custer | Colorado | 8027 | 190 | 1 |
1277803 | 1277803 | 2021-05-02 | Delta | Colorado | 8029 | 2671 | 61 |
1277804 | 1277804 | 2021-05-02 | Denver | Colorado | 8031 | 70708 | 806 |
1277805 | 1277805 | 2021-05-02 | Dolores | Colorado | 8033 | 80 | 0 |
1277806 | 1277806 | 2021-05-02 | Douglas | Colorado | 8035 | 28493 | 253 |
1277807 | 1277807 | 2021-05-02 | Eagle | Colorado | 8037 | 6231 | 22 |
1277808 | 1277808 | 2021-05-02 | El Paso | Colorado | 8041 | 64366 | 791 |
1277809 | 1277809 | 2021-05-02 | Elbert | Colorado | 8039 | 1674 | 13 |
1277810 | 1277810 | 2021-05-02 | Fremont | Colorado | 8043 | 6098 | 55 |
1277811 | 1277811 | 2021-05-02 | Garfield | Colorado | 8045 | 5775 | 38 |
1277812 | 1277812 | 2021-05-02 | Gilpin | Colorado | 8047 | 231 | 3 |
1277813 | 1277813 | 2021-05-02 | Grand | Colorado | 8049 | 1460 | 7 |
1277814 | 1277814 | 2021-05-02 | Gunnison | Colorado | 8051 | 1324 | 6 |
1277815 | 1277815 | 2021-05-02 | Hinsdale | Colorado | 8053 | 17 | 0 |
1277816 | 1277816 | 2021-05-02 | Huerfano | Colorado | 8055 | 392 | 17 |
1277817 | 1277817 | 2021-05-02 | Jackson | Colorado | 8057 | 57 | 0 |
1277818 | 1277818 | 2021-05-02 | Jefferson | Colorado | 8059 | 45356 | 750 |
1277819 | 1277819 | 2021-05-02 | Kiowa | Colorado | 8061 | 93 | 3 |
1277820 | 1277820 | 2021-05-02 | Kit Carson | Colorado | 8063 | 606 | 11 |
1277821 | 1277821 | 2021-05-02 | La Plata | Colorado | 8067 | 3846 | 39 |
1277822 | 1277822 | 2021-05-02 | Lake | Colorado | 8065 | 776 | 0 |
1277823 | 1277823 | 2021-05-02 | Larimer | Colorado | 8069 | 25579 | 233 |
1277824 | 1277824 | 2021-05-02 | Las Animas | Colorado | 8071 | 1112 | 11 |
1277825 | 1277825 | 2021-05-02 | Lincoln | Colorado | 8073 | 1022 | 4 |
1277826 | 1277826 | 2021-05-02 | Logan | Colorado | 8075 | 3941 | 67 |
1277827 | 1277827 | 2021-05-02 | Mesa | Colorado | 8077 | 14455 | 212 |
1277828 | 1277828 | 2021-05-02 | Mineral | Colorado | 8079 | 88 | 1 |
1277829 | 1277829 | 2021-05-02 | Moffat | Colorado | 8081 | 752 | 22 |
1277830 | 1277830 | 2021-05-02 | Montezuma | Colorado | 8083 | 1889 | 24 |
1277831 | 1277831 | 2021-05-02 | Montrose | Colorado | 8085 | 3434 | 57 |
1277832 | 1277832 | 2021-05-02 | Morgan | Colorado | 8087 | 2631 | 93 |
1277833 | 1277833 | 2021-05-02 | Otero | Colorado | 8089 | 1968 | 65 |
1277834 | 1277834 | 2021-05-02 | Ouray | Colorado | 8091 | 283 | 3 |
1277835 | 1277835 | 2021-05-02 | Park | Colorado | 8093 | 739 | 5 |
1277836 | 1277836 | 2021-05-02 | Phillips | Colorado | 8095 | 375 | 13 |
1277837 | 1277837 | 2021-05-02 | Pitkin | Colorado | 8097 | 2579 | 4 |
1277838 | 1277838 | 2021-05-02 | Prowers | Colorado | 8099 | 1206 | 21 |
1277839 | 1277839 | 2021-05-02 | Pueblo | Colorado | 8101 | 17982 | 377 |
1277840 | 1277840 | 2021-05-02 | Rio Blanco | Colorado | 8103 | 564 | 4 |
1277841 | 1277841 | 2021-05-02 | Rio Grande | Colorado | 8105 | 789 | 14 |
1277842 | 1277842 | 2021-05-02 | Routt | Colorado | 8107 | 2186 | 20 |
1277843 | 1277843 | 2021-05-02 | Saguache | Colorado | 8109 | 368 | 4 |
1277844 | 1277844 | 2021-05-02 | San Juan | Colorado | 8111 | 52 | 2 |
1277845 | 1277845 | 2021-05-02 | San Miguel | Colorado | 8113 | 872 | 0 |
1277846 | 1277846 | 2021-05-02 | Sedgwick | Colorado | 8115 | 213 | 2 |
1277847 | 1277847 | 2021-05-02 | Summit | Colorado | 8117 | 3679 | 7 |
1277848 | 1277848 | 2021-05-02 | Teller | Colorado | 8119 | 1658 | 14 |
1277849 | 1277849 | 2021-05-02 | Washington | Colorado | 8121 | 449 | 12 |
1277850 | 1277850 | 2021-05-02 | Weld | Colorado | 8123 | 30688 | 334 |
1277851 | 1277851 | 2021-05-02 | Yuma | Colorado | 8125 | 882 | 17 |
1274541 | 1274541 | 2021-05-01 | Adams | Colorado | 8001 | 57233 | 701 |
1274542 | 1274542 | 2021-05-01 | Alamosa | Colorado | 8003 | 1459 | 30 |
1274543 | 1274543 | 2021-05-01 | Arapahoe | Colorado | 8005 | 58753 | 771 |
1274544 | 1274544 | 2021-05-01 | Archuleta | Colorado | 8007 | 900 | 1 |
1274545 | 1274545 | 2021-05-01 | Baca | Colorado | 8009 | 288 | 4 |
1274546 | 1274546 | 2021-05-01 | Bent | Colorado | 8011 | 1522 | 21 |
1274547 | 1274547 | 2021-05-01 | Boulder | Colorado | 8013 | 23037 | 254 |
1274548 | 1274548 | 2021-05-01 | Broomfield | Colorado | 8014 | 4687 | 75 |
1274549 | 1274549 | 2021-05-01 | Chaffee | Colorado | 8015 | 1632 | 25 |
1274550 | 1274550 | 2021-05-01 | Cheyenne | Colorado | 8017 | 127 | 6 |
1274551 | 1274551 | 2021-05-01 | Clear Creek | Colorado | 8019 | 437 | 3 |
1274552 | 1274552 | 2021-05-01 | Conejos | Colorado | 8021 | 512 | 10 |
1274553 | 1274553 | 2021-05-01 | Costilla | Colorado | 8023 | 208 | 2 |
1274554 | 1274554 | 2021-05-01 | Crowley | Colorado | 8025 | 2179 | 15 |
1274555 | 1274555 | 2021-05-01 | Custer | Colorado | 8027 | 190 | 1 |
1274556 | 1274556 | 2021-05-01 | Delta | Colorado | 8029 | 2671 | 61 |
1274557 | 1274557 | 2021-05-01 | Denver | Colorado | 8031 | 70636 | 806 |
1274558 | 1274558 | 2021-05-01 | Dolores | Colorado | 8033 | 79 | 0 |
1274559 | 1274559 | 2021-05-01 | Douglas | Colorado | 8035 | 28385 | 253 |
1274560 | 1274560 | 2021-05-01 | Eagle | Colorado | 8037 | 6230 | 22 |
1274561 | 1274561 | 2021-05-01 | El Paso | Colorado | 8041 | 64179 | 791 |
1274562 | 1274562 | 2021-05-01 | Elbert | Colorado | 8039 | 1669 | 13 |
1274563 | 1274563 | 2021-05-01 | Fremont | Colorado | 8043 | 6083 | 55 |
1274564 | 1274564 | 2021-05-01 | Garfield | Colorado | 8045 | 5770 | 38 |
1274565 | 1274565 | 2021-05-01 | Gilpin | Colorado | 8047 | 230 | 3 |
1274566 | 1274566 | 2021-05-01 | Grand | Colorado | 8049 | 1455 | 7 |
1274567 | 1274567 | 2021-05-01 | Gunnison | Colorado | 8051 | 1324 | 6 |
1274568 | 1274568 | 2021-05-01 | Hinsdale | Colorado | 8053 | 18 | 0 |
1274569 | 1274569 | 2021-05-01 | Huerfano | Colorado | 8055 | 387 | 17 |
1274570 | 1274570 | 2021-05-01 | Jackson | Colorado | 8057 | 57 | 0 |
1274571 | 1274571 | 2021-05-01 | Jefferson | Colorado | 8059 | 45266 | 750 |
1274572 | 1274572 | 2021-05-01 | Kiowa | Colorado | 8061 | 93 | 3 |
1274573 | 1274573 | 2021-05-01 | Kit Carson | Colorado | 8063 | 606 | 11 |
1274574 | 1274574 | 2021-05-01 | La Plata | Colorado | 8067 | 3844 | 39 |
1274575 | 1274575 | 2021-05-01 | Lake | Colorado | 8065 | 776 | 0 |
1274576 | 1274576 | 2021-05-01 | Larimer | Colorado | 8069 | 25541 | 233 |
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);