ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64 rows where date = "2021-02-18" 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 |
---|---|---|---|---|---|---|---|
1040766 | 1040766 | 2021-02-18 | Adams | Colorado | 8001 | 48279 | 625 |
1040767 | 1040767 | 2021-02-18 | Alamosa | Colorado | 8003 | 1244 | 28 |
1040768 | 1040768 | 2021-02-18 | Arapahoe | Colorado | 8005 | 48221 | 687 |
1040769 | 1040769 | 2021-02-18 | Archuleta | Colorado | 8007 | 629 | 1 |
1040770 | 1040770 | 2021-02-18 | Baca | Colorado | 8009 | 270 | 4 |
1040771 | 1040771 | 2021-02-18 | Bent | Colorado | 8011 | 1468 | 21 |
1040772 | 1040772 | 2021-02-18 | Boulder | Colorado | 8013 | 18410 | 245 |
1040773 | 1040773 | 2021-02-18 | Broomfield | Colorado | 8014 | 3623 | 73 |
1040774 | 1040774 | 2021-02-18 | Chaffee | Colorado | 8015 | 1402 | 23 |
1040775 | 1040775 | 2021-02-18 | Cheyenne | Colorado | 8017 | 125 | 5 |
1040776 | 1040776 | 2021-02-18 | Clear Creek | Colorado | 8019 | 355 | 2 |
1040777 | 1040777 | 2021-02-18 | Conejos | Colorado | 8021 | 428 | 7 |
1040778 | 1040778 | 2021-02-18 | Costilla | Colorado | 8023 | 177 | 2 |
1040779 | 1040779 | 2021-02-18 | Crowley | Colorado | 8025 | 1934 | 14 |
1040780 | 1040780 | 2021-02-18 | Custer | Colorado | 8027 | 163 | 1 |
1040781 | 1040781 | 2021-02-18 | Delta | Colorado | 8029 | 2430 | 57 |
1040782 | 1040782 | 2021-02-18 | Denver | Colorado | 8031 | 58288 | 762 |
1040783 | 1040783 | 2021-02-18 | Dolores | Colorado | 8033 | 66 | 0 |
1040784 | 1040784 | 2021-02-18 | Douglas | Colorado | 8035 | 21061 | 230 |
1040785 | 1040785 | 2021-02-18 | Eagle | Colorado | 8037 | 4825 | 20 |
1040786 | 1040786 | 2021-02-18 | El Paso | Colorado | 8041 | 50561 | 736 |
1040787 | 1040787 | 2021-02-18 | Elbert | Colorado | 8039 | 1242 | 12 |
1040788 | 1040788 | 2021-02-18 | Fremont | Colorado | 8043 | 5375 | 46 |
1040789 | 1040789 | 2021-02-18 | Garfield | Colorado | 8045 | 4995 | 38 |
1040790 | 1040790 | 2021-02-18 | Gilpin | Colorado | 8047 | 164 | 3 |
1040791 | 1040791 | 2021-02-18 | Grand | Colorado | 8049 | 1218 | 5 |
1040792 | 1040792 | 2021-02-18 | Gunnison | Colorado | 8051 | 1179 | 6 |
1040793 | 1040793 | 2021-02-18 | Hinsdale | Colorado | 8053 | 17 | 0 |
1040794 | 1040794 | 2021-02-18 | Huerfano | Colorado | 8055 | 299 | 17 |
1040795 | 1040795 | 2021-02-18 | Jackson | Colorado | 8057 | 49 | 0 |
1040796 | 1040796 | 2021-02-18 | Jefferson | Colorado | 8059 | 36263 | 702 |
1040797 | 1040797 | 2021-02-18 | Kiowa | Colorado | 8061 | 91 | 3 |
1040798 | 1040798 | 2021-02-18 | Kit Carson | Colorado | 8063 | 523 | 10 |
1040799 | 1040799 | 2021-02-18 | La Plata | Colorado | 8067 | 2858 | 36 |
1040800 | 1040800 | 2021-02-18 | Lake | Colorado | 8065 | 646 | 0 |
1040801 | 1040801 | 2021-02-18 | Larimer | Colorado | 8069 | 19312 | 217 |
1040802 | 1040802 | 2021-02-18 | Las Animas | Colorado | 8071 | 974 | 11 |
1040803 | 1040803 | 2021-02-18 | Lincoln | Colorado | 8073 | 988 | 3 |
1040804 | 1040804 | 2021-02-18 | Logan | Colorado | 8075 | 3702 | 63 |
1040805 | 1040805 | 2021-02-18 | Mesa | Colorado | 8077 | 12985 | 191 |
1040806 | 1040806 | 2021-02-18 | Mineral | Colorado | 8079 | 62 | 1 |
1040807 | 1040807 | 2021-02-18 | Moffat | Colorado | 8081 | 654 | 22 |
1040808 | 1040808 | 2021-02-18 | Montezuma | Colorado | 8083 | 1694 | 22 |
1040809 | 1040809 | 2021-02-18 | Montrose | Colorado | 8085 | 3178 | 51 |
1040810 | 1040810 | 2021-02-18 | Morgan | Colorado | 8087 | 2409 | 90 |
1040811 | 1040811 | 2021-02-18 | Otero | Colorado | 8089 | 1824 | 61 |
1040812 | 1040812 | 2021-02-18 | Ouray | Colorado | 8091 | 240 | 3 |
1040813 | 1040813 | 2021-02-18 | Park | Colorado | 8093 | 529 | 5 |
1040814 | 1040814 | 2021-02-18 | Phillips | Colorado | 8095 | 332 | 12 |
1040815 | 1040815 | 2021-02-18 | Pitkin | Colorado | 8097 | 1923 | 4 |
1040816 | 1040816 | 2021-02-18 | Prowers | Colorado | 8099 | 1155 | 21 |
1040817 | 1040817 | 2021-02-18 | Pueblo | Colorado | 8101 | 14839 | 362 |
1040818 | 1040818 | 2021-02-18 | Rio Blanco | Colorado | 8103 | 452 | 3 |
1040819 | 1040819 | 2021-02-18 | Rio Grande | Colorado | 8105 | 674 | 12 |
1040820 | 1040820 | 2021-02-18 | Routt | Colorado | 8107 | 1813 | 19 |
1040821 | 1040821 | 2021-02-18 | Saguache | Colorado | 8109 | 310 | 4 |
1040822 | 1040822 | 2021-02-18 | San Juan | Colorado | 8111 | 41 | 0 |
1040823 | 1040823 | 2021-02-18 | San Miguel | Colorado | 8113 | 797 | 0 |
1040824 | 1040824 | 2021-02-18 | Sedgwick | Colorado | 8115 | 190 | 2 |
1040825 | 1040825 | 2021-02-18 | Summit | Colorado | 8117 | 2929 | 7 |
1040826 | 1040826 | 2021-02-18 | Teller | Colorado | 8119 | 1236 | 14 |
1040827 | 1040827 | 2021-02-18 | Washington | Colorado | 8121 | 374 | 12 |
1040828 | 1040828 | 2021-02-18 | Weld | Colorado | 8123 | 24903 | 316 |
1040829 | 1040829 | 2021-02-18 | Yuma | Colorado | 8125 | 697 | 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);