ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64 rows where date = "2022-05-09" 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 |
---|---|---|---|---|---|---|---|
2486789 | 2486789 | 2022-05-09 | Adams | Colorado | 8001 | 137047 | 1376 |
2486790 | 2486790 | 2022-05-09 | Alamosa | Colorado | 8003 | 4547 | 62 |
2486791 | 2486791 | 2022-05-09 | Arapahoe | Colorado | 8005 | 157351 | 1283 |
2486792 | 2486792 | 2022-05-09 | Archuleta | Colorado | 8007 | 2911 | 16 |
2486793 | 2486793 | 2022-05-09 | Baca | Colorado | 8009 | 850 | 13 |
2486794 | 2486794 | 2022-05-09 | Bent | Colorado | 8011 | 2549 | 47 |
2486795 | 2486795 | 2022-05-09 | Boulder | Colorado | 8013 | 66988 | 390 |
2486796 | 2486796 | 2022-05-09 | Broomfield | Colorado | 8014 | 13811 | 116 |
2486797 | 2486797 | 2022-05-09 | Chaffee | Colorado | 8015 | 4709 | 47 |
2486798 | 2486798 | 2022-05-09 | Cheyenne | Colorado | 8017 | 322 | 9 |
2486799 | 2486799 | 2022-05-09 | Clear Creek | Colorado | 8019 | 1587 | 12 |
2486800 | 2486800 | 2022-05-09 | Conejos | Colorado | 8021 | 1757 | 54 |
2486801 | 2486801 | 2022-05-09 | Costilla | Colorado | 8023 | 702 | 17 |
2486802 | 2486802 | 2022-05-09 | Crowley | Colorado | 8025 | 3342 | 30 |
2486803 | 2486803 | 2022-05-09 | Custer | Colorado | 8027 | 655 | 21 |
2486804 | 2486804 | 2022-05-09 | Delta | Colorado | 8029 | 6191 | 140 |
2486805 | 2486805 | 2022-05-09 | Denver | Colorado | 8031 | 175189 | 1356 |
2486806 | 2486806 | 2022-05-09 | Dolores | Colorado | 8033 | 367 | 8 |
2486807 | 2486807 | 2022-05-09 | Douglas | Colorado | 8035 | 80797 | 457 |
2486808 | 2486808 | 2022-05-09 | Eagle | Colorado | 8037 | 16195 | 35 |
2486809 | 2486809 | 2022-05-09 | El Paso | Colorado | 8041 | 188527 | 1695 |
2486810 | 2486810 | 2022-05-09 | Elbert | Colorado | 8039 | 4826 | 40 |
2486811 | 2486811 | 2022-05-09 | Fremont | Colorado | 8043 | 15403 | 187 |
2486812 | 2486812 | 2022-05-09 | Garfield | Colorado | 8045 | 15005 | 91 |
2486813 | 2486813 | 2022-05-09 | Gilpin | Colorado | 8047 | 969 | 4 |
2486814 | 2486814 | 2022-05-09 | Grand | Colorado | 8049 | 3590 | 28 |
2486815 | 2486815 | 2022-05-09 | Gunnison | Colorado | 8051 | 3402 | 14 |
2486816 | 2486816 | 2022-05-09 | Hinsdale | Colorado | 8053 | 131 | 0 |
2486817 | 2486817 | 2022-05-09 | Huerfano | Colorado | 8055 | 1449 | 35 |
2486818 | 2486818 | 2022-05-09 | Jackson | Colorado | 8057 | 165 | 0 |
2486819 | 2486819 | 2022-05-09 | Jefferson | Colorado | 8059 | 126559 | 1354 |
2486820 | 2486820 | 2022-05-09 | Kiowa | Colorado | 8061 | 336 | 6 |
2486821 | 2486821 | 2022-05-09 | Kit Carson | Colorado | 8063 | 1614 | 33 |
2486822 | 2486822 | 2022-05-09 | La Plata | Colorado | 8067 | 12941 | 86 |
2486823 | 2486823 | 2022-05-09 | Lake | Colorado | 8065 | 1824 | 2 |
2486824 | 2486824 | 2022-05-09 | Larimer | Colorado | 8069 | 80033 | 502 |
2486825 | 2486825 | 2022-05-09 | Las Animas | Colorado | 8071 | 3622 | 43 |
2486826 | 2486826 | 2022-05-09 | Lincoln | Colorado | 8073 | 2184 | 9 |
2486827 | 2486827 | 2022-05-09 | Logan | Colorado | 8075 | 7463 | 109 |
2486828 | 2486828 | 2022-05-09 | Mesa | Colorado | 8077 | 42900 | 563 |
2486829 | 2486829 | 2022-05-09 | Mineral | Colorado | 8079 | 233 | 2 |
2486830 | 2486830 | 2022-05-09 | Moffat | Colorado | 8081 | 3045 | 52 |
2486831 | 2486831 | 2022-05-09 | Montezuma | Colorado | 8083 | 6208 | 81 |
2486832 | 2486832 | 2022-05-09 | Montrose | Colorado | 8085 | 9366 | 160 |
2486833 | 2486833 | 2022-05-09 | Morgan | Colorado | 8087 | 5704 | 138 |
2486834 | 2486834 | 2022-05-09 | Otero | Colorado | 8089 | 4309 | 130 |
2486835 | 2486835 | 2022-05-09 | Ouray | Colorado | 8091 | 874 | 6 |
2486836 | 2486836 | 2022-05-09 | Park | Colorado | 8093 | 2882 | 20 |
2486837 | 2486837 | 2022-05-09 | Phillips | Colorado | 8095 | 890 | 19 |
2486838 | 2486838 | 2022-05-09 | Pitkin | Colorado | 8097 | 6623 | 7 |
2486839 | 2486839 | 2022-05-09 | Prowers | Colorado | 8099 | 2644 | 51 |
2486840 | 2486840 | 2022-05-09 | Pueblo | Colorado | 8101 | 47210 | 800 |
2486841 | 2486841 | 2022-05-09 | Rio Blanco | Colorado | 8103 | 1685 | 13 |
2486842 | 2486842 | 2022-05-09 | Rio Grande | Colorado | 8105 | 2842 | 46 |
2486843 | 2486843 | 2022-05-09 | Routt | Colorado | 8107 | 6508 | 25 |
2486844 | 2486844 | 2022-05-09 | Saguache | Colorado | 8109 | 1200 | 12 |
2486845 | 2486845 | 2022-05-09 | San Juan | Colorado | 8111 | 203 | 0 |
2486846 | 2486846 | 2022-05-09 | San Miguel | Colorado | 8113 | 2314 | 8 |
2486847 | 2486847 | 2022-05-09 | Sedgwick | Colorado | 8115 | 487 | 10 |
2486848 | 2486848 | 2022-05-09 | Summit | Colorado | 8117 | 9998 | 14 |
2486849 | 2486849 | 2022-05-09 | Teller | Colorado | 8119 | 4878 | 57 |
2486850 | 2486850 | 2022-05-09 | Washington | Colorado | 8121 | 1063 | 28 |
2486851 | 2486851 | 2022-05-09 | Weld | Colorado | 8123 | 85257 | 702 |
2486852 | 2486852 | 2022-05-09 | 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);