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-01-19 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2128887 | 2128887 | 2022-01-19 | Adams | Colorado | 8001 | 116453 | 1147 |
2128888 | 2128888 | 2022-01-19 | Alamosa | Colorado | 8003 | 3565 | 58 |
2128889 | 2128889 | 2022-01-19 | Arapahoe | Colorado | 8005 | 131868 | 1120 |
2128890 | 2128890 | 2022-01-19 | Archuleta | Colorado | 8007 | 2510 | 9 |
2128891 | 2128891 | 2022-01-19 | Baca | Colorado | 8009 | 642 | 8 |
2128892 | 2128892 | 2022-01-19 | Bent | Colorado | 8011 | 2075 | 46 |
2128893 | 2128893 | 2022-01-19 | Boulder | Colorado | 8013 | 52395 | 339 |
2128894 | 2128894 | 2022-01-19 | Broomfield | Colorado | 8014 | 11269 | 102 |
2128895 | 2128895 | 2022-01-19 | Chaffee | Colorado | 8015 | 3731 | 39 |
2128896 | 2128896 | 2022-01-19 | Cheyenne | Colorado | 8017 | 278 | 9 |
2128897 | 2128897 | 2022-01-19 | Clear Creek | Colorado | 8019 | 1322 | 10 |
2128898 | 2128898 | 2022-01-19 | Conejos | Colorado | 8021 | 1372 | 48 |
2128899 | 2128899 | 2022-01-19 | Costilla | Colorado | 8023 | 548 | 14 |
2128900 | 2128900 | 2022-01-19 | Crowley | Colorado | 8025 | 2719 | 27 |
2128901 | 2128901 | 2022-01-19 | Custer | Colorado | 8027 | 547 | 16 |
2128902 | 2128902 | 2022-01-19 | Delta | Colorado | 8029 | 5143 | 124 |
2128903 | 2128903 | 2022-01-19 | Denver | Colorado | 8031 | 148647 | 1136 |
2128904 | 2128904 | 2022-01-19 | Dolores | Colorado | 8033 | 304 | 6 |
2128905 | 2128905 | 2022-01-19 | Douglas | Colorado | 8035 | 66775 | 385 |
2128906 | 2128906 | 2022-01-19 | Eagle | Colorado | 8037 | 14308 | 33 |
2128907 | 2128907 | 2022-01-19 | El Paso | Colorado | 8041 | 155663 | 1469 |
2128908 | 2128908 | 2022-01-19 | Elbert | Colorado | 8039 | 4110 | 32 |
2128909 | 2128909 | 2022-01-19 | Fremont | Colorado | 8043 | 11761 | 164 |
2128910 | 2128910 | 2022-01-19 | Garfield | Colorado | 8045 | 12502 | 80 |
2128911 | 2128911 | 2022-01-19 | Gilpin | Colorado | 8047 | 822 | 4 |
2128912 | 2128912 | 2022-01-19 | Grand | Colorado | 8049 | 3116 | 20 |
2128913 | 2128913 | 2022-01-19 | Gunnison | Colorado | 8051 | 2885 | 13 |
2128914 | 2128914 | 2022-01-19 | Hinsdale | Colorado | 8053 | 106 | 0 |
2128915 | 2128915 | 2022-01-19 | Huerfano | Colorado | 8055 | 1116 | 28 |
2128916 | 2128916 | 2022-01-19 | Jackson | Colorado | 8057 | 134 | 0 |
2128917 | 2128917 | 2022-01-19 | Jefferson | Colorado | 8059 | 103944 | 1149 |
2128918 | 2128918 | 2022-01-19 | Kiowa | Colorado | 8061 | 297 | 4 |
2128919 | 2128919 | 2022-01-19 | Kit Carson | Colorado | 8063 | 1424 | 28 |
2128920 | 2128920 | 2022-01-19 | La Plata | Colorado | 8067 | 10392 | 69 |
2128921 | 2128921 | 2022-01-19 | Lake | Colorado | 8065 | 1631 | 3 |
2128922 | 2128922 | 2022-01-19 | Larimer | Colorado | 8069 | 62550 | 418 |
2128923 | 2128923 | 2022-01-19 | Las Animas | Colorado | 8071 | 2875 | 35 |
2128924 | 2128924 | 2022-01-19 | Lincoln | Colorado | 8073 | 1703 | 9 |
2128925 | 2128925 | 2022-01-19 | Logan | Colorado | 8075 | 5963 | 100 |
2128926 | 2128926 | 2022-01-19 | Mesa | Colorado | 8077 | 34810 | 487 |
2128927 | 2128927 | 2022-01-19 | Mineral | Colorado | 8079 | 192 | 1 |
2128928 | 2128928 | 2022-01-19 | Moffat | Colorado | 8081 | 2548 | 50 |
2128929 | 2128929 | 2022-01-19 | Montezuma | Colorado | 8083 | 4813 | 61 |
2128930 | 2128930 | 2022-01-19 | Montrose | Colorado | 8085 | 7861 | 150 |
2128931 | 2128931 | 2022-01-19 | Morgan | Colorado | 8087 | 4878 | 128 |
2128932 | 2128932 | 2022-01-19 | Otero | Colorado | 8089 | 3693 | 118 |
2128933 | 2128933 | 2022-01-19 | Ouray | Colorado | 8091 | 753 | 6 |
2128934 | 2128934 | 2022-01-19 | Park | Colorado | 8093 | 2463 | 17 |
2128935 | 2128935 | 2022-01-19 | Phillips | Colorado | 8095 | 697 | 15 |
2128936 | 2128936 | 2022-01-19 | Pitkin | Colorado | 8097 | 5657 | 6 |
2128937 | 2128937 | 2022-01-19 | Prowers | Colorado | 8099 | 2237 | 45 |
2128938 | 2128938 | 2022-01-19 | Pueblo | Colorado | 8101 | 38120 | 705 |
2128939 | 2128939 | 2022-01-19 | Rio Blanco | Colorado | 8103 | 1388 | 13 |
2128940 | 2128940 | 2022-01-19 | Rio Grande | Colorado | 8105 | 2269 | 41 |
2128941 | 2128941 | 2022-01-19 | Routt | Colorado | 8107 | 5641 | 24 |
2128942 | 2128942 | 2022-01-19 | Saguache | Colorado | 8109 | 947 | 10 |
2128943 | 2128943 | 2022-01-19 | San Juan | Colorado | 8111 | 175 | 0 |
2128944 | 2128944 | 2022-01-19 | San Miguel | Colorado | 8113 | 2000 | 7 |
2128945 | 2128945 | 2022-01-19 | Sedgwick | Colorado | 8115 | 398 | 7 |
2128946 | 2128946 | 2022-01-19 | Summit | Colorado | 8117 | 8895 | 12 |
2128947 | 2128947 | 2022-01-19 | Teller | Colorado | 8119 | 4139 | 55 |
2128948 | 2128948 | 2022-01-19 | Washington | Colorado | 8121 | 838 | 26 |
2128949 | 2128949 | 2022-01-19 | Weld | Colorado | 8123 | 70690 | 614 |
2128950 | 2128950 | 2022-01-19 | Yuma | Colorado | 8125 | 1622 | 22 |
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);