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 2022-03-31 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2359820 | 2359820 | 2022-03-31 | Adams | Colorado | 8001 | 132763 | 1309 |
2359821 | 2359821 | 2022-03-31 | Alamosa | Colorado | 8003 | 4506 | 60 |
2359822 | 2359822 | 2022-03-31 | Arapahoe | Colorado | 8005 | 151568 | 1224 |
2359823 | 2359823 | 2022-03-31 | Archuleta | Colorado | 8007 | 2872 | 15 |
2359824 | 2359824 | 2022-03-31 | Baca | Colorado | 8009 | 841 | 8 |
2359825 | 2359825 | 2022-03-31 | Bent | Colorado | 8011 | 2517 | 47 |
2359826 | 2359826 | 2022-03-31 | Boulder | Colorado | 8013 | 63376 | 390 |
2359827 | 2359827 | 2022-03-31 | Broomfield | Colorado | 8014 | 13230 | 112 |
2359828 | 2359828 | 2022-03-31 | Chaffee | Colorado | 8015 | 4469 | 44 |
2359829 | 2359829 | 2022-03-31 | Cheyenne | Colorado | 8017 | 321 | 9 |
2359830 | 2359830 | 2022-03-31 | Clear Creek | Colorado | 8019 | 1533 | 12 |
2359831 | 2359831 | 2022-03-31 | Conejos | Colorado | 8021 | 1726 | 54 |
2359832 | 2359832 | 2022-03-31 | Costilla | Colorado | 8023 | 682 | 16 |
2359833 | 2359833 | 2022-03-31 | Crowley | Colorado | 8025 | 3225 | 28 |
2359834 | 2359834 | 2022-03-31 | Custer | Colorado | 8027 | 639 | 19 |
2359835 | 2359835 | 2022-03-31 | Delta | Colorado | 8029 | 6001 | 134 |
2359836 | 2359836 | 2022-03-31 | Denver | Colorado | 8031 | 168118 | 1285 |
2359837 | 2359837 | 2022-03-31 | Dolores | Colorado | 8033 | 354 | 8 |
2359838 | 2359838 | 2022-03-31 | Douglas | Colorado | 8035 | 77712 | 427 |
2359839 | 2359839 | 2022-03-31 | Eagle | Colorado | 8037 | 15865 | 35 |
2359840 | 2359840 | 2022-03-31 | El Paso | Colorado | 8041 | 183152 | 1610 |
2359841 | 2359841 | 2022-03-31 | Elbert | Colorado | 8039 | 4734 | 37 |
2359842 | 2359842 | 2022-03-31 | Fremont | Colorado | 8043 | 15129 | 177 |
2359843 | 2359843 | 2022-03-31 | Garfield | Colorado | 8045 | 14514 | 91 |
2359844 | 2359844 | 2022-03-31 | Gilpin | Colorado | 8047 | 940 | 4 |
2359845 | 2359845 | 2022-03-31 | Grand | Colorado | 8049 | 3484 | 26 |
2359846 | 2359846 | 2022-03-31 | Gunnison | Colorado | 8051 | 3348 | 14 |
2359847 | 2359847 | 2022-03-31 | Hinsdale | Colorado | 8053 | 123 | 0 |
2359848 | 2359848 | 2022-03-31 | Huerfano | Colorado | 8055 | 1438 | 31 |
2359849 | 2359849 | 2022-03-31 | Jackson | Colorado | 8057 | 164 | 0 |
2359850 | 2359850 | 2022-03-31 | Jefferson | Colorado | 8059 | 121322 | 1322 |
2359851 | 2359851 | 2022-03-31 | Kiowa | Colorado | 8061 | 332 | 6 |
2359852 | 2359852 | 2022-03-31 | Kit Carson | Colorado | 8063 | 1598 | 31 |
2359853 | 2359853 | 2022-03-31 | La Plata | Colorado | 8067 | 12683 | 80 |
2359854 | 2359854 | 2022-03-31 | Lake | Colorado | 8065 | 1789 | 2 |
2359855 | 2359855 | 2022-03-31 | Larimer | Colorado | 8069 | 76538 | 478 |
2359856 | 2359856 | 2022-03-31 | Las Animas | Colorado | 8071 | 3555 | 41 |
2359857 | 2359857 | 2022-03-31 | Lincoln | Colorado | 8073 | 2169 | 9 |
2359858 | 2359858 | 2022-03-31 | Logan | Colorado | 8075 | 7380 | 107 |
2359859 | 2359859 | 2022-03-31 | Mesa | Colorado | 8077 | 42154 | 530 |
2359860 | 2359860 | 2022-03-31 | Mineral | Colorado | 8079 | 226 | 1 |
2359861 | 2359861 | 2022-03-31 | Moffat | Colorado | 8081 | 2999 | 51 |
2359862 | 2359862 | 2022-03-31 | Montezuma | Colorado | 8083 | 6150 | 72 |
2359863 | 2359863 | 2022-03-31 | Montrose | Colorado | 8085 | 9225 | 158 |
2359864 | 2359864 | 2022-03-31 | Morgan | Colorado | 8087 | 5600 | 135 |
2359865 | 2359865 | 2022-03-31 | Otero | Colorado | 8089 | 4263 | 126 |
2359866 | 2359866 | 2022-03-31 | Ouray | Colorado | 8091 | 855 | 6 |
2359867 | 2359867 | 2022-03-31 | Park | Colorado | 8093 | 2800 | 20 |
2359868 | 2359868 | 2022-03-31 | Phillips | Colorado | 8095 | 875 | 18 |
2359869 | 2359869 | 2022-03-31 | Pitkin | Colorado | 8097 | 6394 | 6 |
2359870 | 2359870 | 2022-03-31 | Prowers | Colorado | 8099 | 2615 | 48 |
2359871 | 2359871 | 2022-03-31 | Pueblo | Colorado | 8101 | 45665 | 774 |
2359872 | 2359872 | 2022-03-31 | Rio Blanco | Colorado | 8103 | 1667 | 13 |
2359873 | 2359873 | 2022-03-31 | Rio Grande | Colorado | 8105 | 2785 | 46 |
2359874 | 2359874 | 2022-03-31 | Routt | Colorado | 8107 | 6370 | 24 |
2359875 | 2359875 | 2022-03-31 | Saguache | Colorado | 8109 | 1174 | 12 |
2359876 | 2359876 | 2022-03-31 | San Juan | Colorado | 8111 | 197 | 0 |
2359877 | 2359877 | 2022-03-31 | San Miguel | Colorado | 8113 | 2264 | 8 |
2359878 | 2359878 | 2022-03-31 | Sedgwick | Colorado | 8115 | 482 | 9 |
2359879 | 2359879 | 2022-03-31 | Summit | Colorado | 8117 | 9740 | 14 |
2359880 | 2359880 | 2022-03-31 | Teller | Colorado | 8119 | 4786 | 57 |
2359881 | 2359881 | 2022-03-31 | Washington | Colorado | 8121 | 1052 | 27 |
2359882 | 2359882 | 2022-03-31 | Weld | Colorado | 8123 | 82493 | 694 |
2359883 | 2359883 | 2022-03-31 | Yuma | Colorado | 8125 | 1863 | 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);