ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64 rows where date = "2022-04-27" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2447709 | 2447709 | 2022-04-27 | Adams | Colorado | 8001 | 135971 | 1351 |
2447710 | 2447710 | 2022-04-27 | Alamosa | Colorado | 8003 | 4538 | 61 |
2447711 | 2447711 | 2022-04-27 | Arapahoe | Colorado | 8005 | 155666 | 1251 |
2447712 | 2447712 | 2022-04-27 | Archuleta | Colorado | 8007 | 2906 | 16 |
2447713 | 2447713 | 2022-04-27 | Baca | Colorado | 8009 | 848 | 8 |
2447714 | 2447714 | 2022-04-27 | Bent | Colorado | 8011 | 2544 | 47 |
2447715 | 2447715 | 2022-04-27 | Boulder | Colorado | 8013 | 65404 | 388 |
2447716 | 2447716 | 2022-04-27 | Broomfield | Colorado | 8014 | 13618 | 115 |
2447717 | 2447717 | 2022-04-27 | Chaffee | Colorado | 8015 | 4671 | 44 |
2447718 | 2447718 | 2022-04-27 | Cheyenne | Colorado | 8017 | 322 | 9 |
2447719 | 2447719 | 2022-04-27 | Clear Creek | Colorado | 8019 | 1570 | 12 |
2447720 | 2447720 | 2022-04-27 | Conejos | Colorado | 8021 | 1750 | 54 |
2447721 | 2447721 | 2022-04-27 | Costilla | Colorado | 8023 | 699 | 16 |
2447722 | 2447722 | 2022-04-27 | Crowley | Colorado | 8025 | 3338 | 29 |
2447723 | 2447723 | 2022-04-27 | Custer | Colorado | 8027 | 653 | 21 |
2447724 | 2447724 | 2022-04-27 | Delta | Colorado | 8029 | 6181 | 134 |
2447725 | 2447725 | 2022-04-27 | Denver | Colorado | 8031 | 172861 | 1303 |
2447726 | 2447726 | 2022-04-27 | Dolores | Colorado | 8033 | 367 | 8 |
2447727 | 2447727 | 2022-04-27 | Douglas | Colorado | 8035 | 79858 | 436 |
2447728 | 2447728 | 2022-04-27 | Eagle | Colorado | 8037 | 16138 | 35 |
2447729 | 2447729 | 2022-04-27 | El Paso | Colorado | 8041 | 187338 | 1642 |
2447730 | 2447730 | 2022-04-27 | Elbert | Colorado | 8039 | 4810 | 39 |
2447731 | 2447731 | 2022-04-27 | Fremont | Colorado | 8043 | 15345 | 179 |
2447732 | 2447732 | 2022-04-27 | Garfield | Colorado | 8045 | 14922 | 90 |
2447733 | 2447733 | 2022-04-27 | Gilpin | Colorado | 8047 | 957 | 4 |
2447734 | 2447734 | 2022-04-27 | Grand | Colorado | 8049 | 3575 | 26 |
2447735 | 2447735 | 2022-04-27 | Gunnison | Colorado | 8051 | 3395 | 14 |
2447736 | 2447736 | 2022-04-27 | Hinsdale | Colorado | 8053 | 129 | 0 |
2447737 | 2447737 | 2022-04-27 | Huerfano | Colorado | 8055 | 1445 | 33 |
2447738 | 2447738 | 2022-04-27 | Jackson | Colorado | 8057 | 165 | 0 |
2447739 | 2447739 | 2022-04-27 | Jefferson | Colorado | 8059 | 125201 | 1329 |
2447740 | 2447740 | 2022-04-27 | Kiowa | Colorado | 8061 | 335 | 6 |
2447741 | 2447741 | 2022-04-27 | Kit Carson | Colorado | 8063 | 1615 | 33 |
2447742 | 2447742 | 2022-04-27 | La Plata | Colorado | 8067 | 12862 | 82 |
2447743 | 2447743 | 2022-04-27 | Lake | Colorado | 8065 | 1814 | 2 |
2447744 | 2447744 | 2022-04-27 | Larimer | Colorado | 8069 | 79109 | 483 |
2447745 | 2447745 | 2022-04-27 | Las Animas | Colorado | 8071 | 3606 | 40 |
2447746 | 2447746 | 2022-04-27 | Lincoln | Colorado | 8073 | 2182 | 9 |
2447747 | 2447747 | 2022-04-27 | Logan | Colorado | 8075 | 7456 | 109 |
2447748 | 2447748 | 2022-04-27 | Mesa | Colorado | 8077 | 42751 | 536 |
2447749 | 2447749 | 2022-04-27 | Mineral | Colorado | 8079 | 233 | 2 |
2447750 | 2447750 | 2022-04-27 | Moffat | Colorado | 8081 | 3031 | 51 |
2447751 | 2447751 | 2022-04-27 | Montezuma | Colorado | 8083 | 6192 | 76 |
2447752 | 2447752 | 2022-04-27 | Montrose | Colorado | 8085 | 9344 | 158 |
2447753 | 2447753 | 2022-04-27 | Morgan | Colorado | 8087 | 5688 | 136 |
2447754 | 2447754 | 2022-04-27 | Otero | Colorado | 8089 | 4298 | 127 |
2447755 | 2447755 | 2022-04-27 | Ouray | Colorado | 8091 | 867 | 6 |
2447756 | 2447756 | 2022-04-27 | Park | Colorado | 8093 | 2859 | 20 |
2447757 | 2447757 | 2022-04-27 | Phillips | Colorado | 8095 | 890 | 18 |
2447758 | 2447758 | 2022-04-27 | Pitkin | Colorado | 8097 | 6611 | 6 |
2447759 | 2447759 | 2022-04-27 | Prowers | Colorado | 8099 | 2642 | 49 |
2447760 | 2447760 | 2022-04-27 | Pueblo | Colorado | 8101 | 47000 | 782 |
2447761 | 2447761 | 2022-04-27 | Rio Blanco | Colorado | 8103 | 1683 | 13 |
2447762 | 2447762 | 2022-04-27 | Rio Grande | Colorado | 8105 | 2822 | 46 |
2447763 | 2447763 | 2022-04-27 | Routt | Colorado | 8107 | 6474 | 25 |
2447764 | 2447764 | 2022-04-27 | Saguache | Colorado | 8109 | 1193 | 12 |
2447765 | 2447765 | 2022-04-27 | San Juan | Colorado | 8111 | 202 | 0 |
2447766 | 2447766 | 2022-04-27 | San Miguel | Colorado | 8113 | 2306 | 8 |
2447767 | 2447767 | 2022-04-27 | Sedgwick | Colorado | 8115 | 485 | 10 |
2447768 | 2447768 | 2022-04-27 | Summit | Colorado | 8117 | 9942 | 14 |
2447769 | 2447769 | 2022-04-27 | Teller | Colorado | 8119 | 4856 | 57 |
2447770 | 2447770 | 2022-04-27 | Washington | Colorado | 8121 | 1061 | 27 |
2447771 | 2447771 | 2022-04-27 | Weld | Colorado | 8123 | 84425 | 696 |
2447772 | 2447772 | 2022-04-27 | Yuma | Colorado | 8125 | 1884 | 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);