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-04-23 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2434685 | 2434685 | 2022-04-23 | Adams | Colorado | 8001 | 135780 | 1331 |
2434686 | 2434686 | 2022-04-23 | Alamosa | Colorado | 8003 | 4527 | 61 |
2434687 | 2434687 | 2022-04-23 | Arapahoe | Colorado | 8005 | 155364 | 1241 |
2434688 | 2434688 | 2022-04-23 | Archuleta | Colorado | 8007 | 2905 | 15 |
2434689 | 2434689 | 2022-04-23 | Baca | Colorado | 8009 | 848 | 8 |
2434690 | 2434690 | 2022-04-23 | Bent | Colorado | 8011 | 2542 | 47 |
2434691 | 2434691 | 2022-04-23 | Boulder | Colorado | 8013 | 65019 | 389 |
2434692 | 2434692 | 2022-04-23 | Broomfield | Colorado | 8014 | 13568 | 115 |
2434693 | 2434693 | 2022-04-23 | Chaffee | Colorado | 8015 | 4656 | 44 |
2434694 | 2434694 | 2022-04-23 | Cheyenne | Colorado | 8017 | 322 | 9 |
2434695 | 2434695 | 2022-04-23 | Clear Creek | Colorado | 8019 | 1566 | 12 |
2434696 | 2434696 | 2022-04-23 | Conejos | Colorado | 8021 | 1745 | 54 |
2434697 | 2434697 | 2022-04-23 | Costilla | Colorado | 8023 | 697 | 16 |
2434698 | 2434698 | 2022-04-23 | Crowley | Colorado | 8025 | 3338 | 30 |
2434699 | 2434699 | 2022-04-23 | Custer | Colorado | 8027 | 650 | 21 |
2434700 | 2434700 | 2022-04-23 | Delta | Colorado | 8029 | 6176 | 134 |
2434701 | 2434701 | 2022-04-23 | Denver | Colorado | 8031 | 172140 | 1296 |
2434702 | 2434702 | 2022-04-23 | Dolores | Colorado | 8033 | 365 | 8 |
2434703 | 2434703 | 2022-04-23 | Douglas | Colorado | 8035 | 79685 | 431 |
2434704 | 2434704 | 2022-04-23 | Eagle | Colorado | 8037 | 16081 | 35 |
2434705 | 2434705 | 2022-04-23 | El Paso | Colorado | 8041 | 186634 | 1626 |
2434706 | 2434706 | 2022-04-23 | Elbert | Colorado | 8039 | 4800 | 39 |
2434707 | 2434707 | 2022-04-23 | Fremont | Colorado | 8043 | 15307 | 179 |
2434708 | 2434708 | 2022-04-23 | Garfield | Colorado | 8045 | 14861 | 90 |
2434709 | 2434709 | 2022-04-23 | Gilpin | Colorado | 8047 | 954 | 4 |
2434710 | 2434710 | 2022-04-23 | Grand | Colorado | 8049 | 3537 | 26 |
2434711 | 2434711 | 2022-04-23 | Gunnison | Colorado | 8051 | 3390 | 14 |
2434712 | 2434712 | 2022-04-23 | Hinsdale | Colorado | 8053 | 129 | 0 |
2434713 | 2434713 | 2022-04-23 | Huerfano | Colorado | 8055 | 1443 | 32 |
2434714 | 2434714 | 2022-04-23 | Jackson | Colorado | 8057 | 165 | 0 |
2434715 | 2434715 | 2022-04-23 | Jefferson | Colorado | 8059 | 124703 | 1329 |
2434716 | 2434716 | 2022-04-23 | Kiowa | Colorado | 8061 | 335 | 6 |
2434717 | 2434717 | 2022-04-23 | Kit Carson | Colorado | 8063 | 1612 | 33 |
2434718 | 2434718 | 2022-04-23 | La Plata | Colorado | 8067 | 12847 | 82 |
2434719 | 2434719 | 2022-04-23 | Lake | Colorado | 8065 | 1808 | 2 |
2434720 | 2434720 | 2022-04-23 | Larimer | Colorado | 8069 | 78628 | 480 |
2434721 | 2434721 | 2022-04-23 | Las Animas | Colorado | 8071 | 3605 | 40 |
2434722 | 2434722 | 2022-04-23 | Lincoln | Colorado | 8073 | 2180 | 9 |
2434723 | 2434723 | 2022-04-23 | Logan | Colorado | 8075 | 7454 | 107 |
2434724 | 2434724 | 2022-04-23 | Mesa | Colorado | 8077 | 42667 | 536 |
2434725 | 2434725 | 2022-04-23 | Mineral | Colorado | 8079 | 233 | 2 |
2434726 | 2434726 | 2022-04-23 | Moffat | Colorado | 8081 | 3029 | 51 |
2434727 | 2434727 | 2022-04-23 | Montezuma | Colorado | 8083 | 6188 | 76 |
2434728 | 2434728 | 2022-04-23 | Montrose | Colorado | 8085 | 9332 | 158 |
2434729 | 2434729 | 2022-04-23 | Morgan | Colorado | 8087 | 5680 | 136 |
2434730 | 2434730 | 2022-04-23 | Otero | Colorado | 8089 | 4295 | 127 |
2434731 | 2434731 | 2022-04-23 | Ouray | Colorado | 8091 | 863 | 6 |
2434732 | 2434732 | 2022-04-23 | Park | Colorado | 8093 | 2851 | 20 |
2434733 | 2434733 | 2022-04-23 | Phillips | Colorado | 8095 | 889 | 18 |
2434734 | 2434734 | 2022-04-23 | Pitkin | Colorado | 8097 | 6551 | 6 |
2434735 | 2434735 | 2022-04-23 | Prowers | Colorado | 8099 | 2642 | 49 |
2434736 | 2434736 | 2022-04-23 | Pueblo | Colorado | 8101 | 46810 | 781 |
2434737 | 2434737 | 2022-04-23 | Rio Blanco | Colorado | 8103 | 1683 | 13 |
2434738 | 2434738 | 2022-04-23 | Rio Grande | Colorado | 8105 | 2811 | 46 |
2434739 | 2434739 | 2022-04-23 | Routt | Colorado | 8107 | 6456 | 25 |
2434740 | 2434740 | 2022-04-23 | Saguache | Colorado | 8109 | 1190 | 12 |
2434741 | 2434741 | 2022-04-23 | San Juan | Colorado | 8111 | 202 | 0 |
2434742 | 2434742 | 2022-04-23 | San Miguel | Colorado | 8113 | 2291 | 8 |
2434743 | 2434743 | 2022-04-23 | Sedgwick | Colorado | 8115 | 484 | 10 |
2434744 | 2434744 | 2022-04-23 | Summit | Colorado | 8117 | 9900 | 14 |
2434745 | 2434745 | 2022-04-23 | Teller | Colorado | 8119 | 4849 | 58 |
2434746 | 2434746 | 2022-04-23 | Washington | Colorado | 8121 | 1061 | 27 |
2434747 | 2434747 | 2022-04-23 | Weld | Colorado | 8123 | 84239 | 696 |
2434748 | 2434748 | 2022-04-23 | Yuma | Colorado | 8125 | 1883 | 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);