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-04-15 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1222586 | 1222586 | 2021-04-15 | Adams | Colorado | 8001 | 54498 | 685 |
1222587 | 1222587 | 2021-04-15 | Alamosa | Colorado | 8003 | 1397 | 30 |
1222588 | 1222588 | 2021-04-15 | Arapahoe | Colorado | 8005 | 55634 | 755 |
1222589 | 1222589 | 2021-04-15 | Archuleta | Colorado | 8007 | 820 | 1 |
1222590 | 1222590 | 2021-04-15 | Baca | Colorado | 8009 | 278 | 4 |
1222591 | 1222591 | 2021-04-15 | Bent | Colorado | 8011 | 1487 | 21 |
1222592 | 1222592 | 2021-04-15 | Boulder | Colorado | 8013 | 21912 | 250 |
1222593 | 1222593 | 2021-04-15 | Broomfield | Colorado | 8014 | 4401 | 75 |
1222594 | 1222594 | 2021-04-15 | Chaffee | Colorado | 8015 | 1555 | 24 |
1222595 | 1222595 | 2021-04-15 | Cheyenne | Colorado | 8017 | 127 | 6 |
1222596 | 1222596 | 2021-04-15 | Clear Creek | Colorado | 8019 | 428 | 3 |
1222597 | 1222597 | 2021-04-15 | Conejos | Colorado | 8021 | 474 | 10 |
1222598 | 1222598 | 2021-04-15 | Costilla | Colorado | 8023 | 205 | 2 |
1222599 | 1222599 | 2021-04-15 | Crowley | Colorado | 8025 | 2154 | 14 |
1222600 | 1222600 | 2021-04-15 | Custer | Colorado | 8027 | 177 | 1 |
1222601 | 1222601 | 2021-04-15 | Delta | Colorado | 8029 | 2620 | 61 |
1222602 | 1222602 | 2021-04-15 | Denver | Colorado | 8031 | 67641 | 792 |
1222603 | 1222603 | 2021-04-15 | Dolores | Colorado | 8033 | 72 | 0 |
1222604 | 1222604 | 2021-04-15 | Douglas | Colorado | 8035 | 26345 | 250 |
1222605 | 1222605 | 2021-04-15 | Eagle | Colorado | 8037 | 6018 | 22 |
1222606 | 1222606 | 2021-04-15 | El Paso | Colorado | 8041 | 59991 | 771 |
1222607 | 1222607 | 2021-04-15 | Elbert | Colorado | 8039 | 1523 | 12 |
1222608 | 1222608 | 2021-04-15 | Fremont | Colorado | 8043 | 5752 | 54 |
1222609 | 1222609 | 2021-04-15 | Garfield | Colorado | 8045 | 5629 | 38 |
1222610 | 1222610 | 2021-04-15 | Gilpin | Colorado | 8047 | 209 | 3 |
1222611 | 1222611 | 2021-04-15 | Grand | Colorado | 8049 | 1397 | 6 |
1222612 | 1222612 | 2021-04-15 | Gunnison | Colorado | 8051 | 1288 | 6 |
1222613 | 1222613 | 2021-04-15 | Hinsdale | Colorado | 8053 | 17 | 0 |
1222614 | 1222614 | 2021-04-15 | Huerfano | Colorado | 8055 | 348 | 16 |
1222615 | 1222615 | 2021-04-15 | Jackson | Colorado | 8057 | 56 | 0 |
1222616 | 1222616 | 2021-04-15 | Jefferson | Colorado | 8059 | 42496 | 738 |
1222617 | 1222617 | 2021-04-15 | Kiowa | Colorado | 8061 | 93 | 3 |
1222618 | 1222618 | 2021-04-15 | Kit Carson | Colorado | 8063 | 597 | 11 |
1222619 | 1222619 | 2021-04-15 | La Plata | Colorado | 8067 | 3601 | 38 |
1222620 | 1222620 | 2021-04-15 | Lake | Colorado | 8065 | 727 | 0 |
1222621 | 1222621 | 2021-04-15 | Larimer | Colorado | 8069 | 23929 | 231 |
1222622 | 1222622 | 2021-04-15 | Las Animas | Colorado | 8071 | 1079 | 11 |
1222623 | 1222623 | 2021-04-15 | Lincoln | Colorado | 8073 | 1010 | 4 |
1222624 | 1222624 | 2021-04-15 | Logan | Colorado | 8075 | 3872 | 65 |
1222625 | 1222625 | 2021-04-15 | Mesa | Colorado | 8077 | 13910 | 209 |
1222626 | 1222626 | 2021-04-15 | Mineral | Colorado | 8079 | 86 | 1 |
1222627 | 1222627 | 2021-04-15 | Moffat | Colorado | 8081 | 722 | 22 |
1222628 | 1222628 | 2021-04-15 | Montezuma | Colorado | 8083 | 1847 | 23 |
1222629 | 1222629 | 2021-04-15 | Montrose | Colorado | 8085 | 3361 | 57 |
1222630 | 1222630 | 2021-04-15 | Morgan | Colorado | 8087 | 2566 | 93 |
1222631 | 1222631 | 2021-04-15 | Otero | Colorado | 8089 | 1908 | 63 |
1222632 | 1222632 | 2021-04-15 | Ouray | Colorado | 8091 | 277 | 3 |
1222633 | 1222633 | 2021-04-15 | Park | Colorado | 8093 | 656 | 5 |
1222634 | 1222634 | 2021-04-15 | Phillips | Colorado | 8095 | 354 | 13 |
1222635 | 1222635 | 2021-04-15 | Pitkin | Colorado | 8097 | 2551 | 4 |
1222636 | 1222636 | 2021-04-15 | Prowers | Colorado | 8099 | 1181 | 21 |
1222637 | 1222637 | 2021-04-15 | Pueblo | Colorado | 8101 | 16640 | 365 |
1222638 | 1222638 | 2021-04-15 | Rio Blanco | Colorado | 8103 | 543 | 4 |
1222639 | 1222639 | 2021-04-15 | Rio Grande | Colorado | 8105 | 773 | 14 |
1222640 | 1222640 | 2021-04-15 | Routt | Colorado | 8107 | 2147 | 20 |
1222641 | 1222641 | 2021-04-15 | Saguache | Colorado | 8109 | 348 | 4 |
1222642 | 1222642 | 2021-04-15 | San Juan | Colorado | 8111 | 46 | 0 |
1222643 | 1222643 | 2021-04-15 | San Miguel | Colorado | 8113 | 862 | 0 |
1222644 | 1222644 | 2021-04-15 | Sedgwick | Colorado | 8115 | 207 | 2 |
1222645 | 1222645 | 2021-04-15 | Summit | Colorado | 8117 | 3601 | 7 |
1222646 | 1222646 | 2021-04-15 | Teller | Colorado | 8119 | 1521 | 14 |
1222647 | 1222647 | 2021-04-15 | Washington | Colorado | 8121 | 440 | 12 |
1222648 | 1222648 | 2021-04-15 | Weld | Colorado | 8123 | 28897 | 329 |
1222649 | 1222649 | 2021-04-15 | Yuma | Colorado | 8125 | 850 | 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);