ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64 rows where date = "2021-11-03" 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 |
---|---|---|---|---|---|---|---|
1878593 | 1878593 | 2021-11-03 | Adams | Colorado | 8001 | 78698 | 902 |
1878594 | 1878594 | 2021-11-03 | Alamosa | Colorado | 8003 | 2552 | 44 |
1878595 | 1878595 | 2021-11-03 | Arapahoe | Colorado | 8005 | 82858 | 948 |
1878596 | 1878596 | 2021-11-03 | Archuleta | Colorado | 8007 | 1556 | 4 |
1878597 | 1878597 | 2021-11-03 | Baca | Colorado | 8009 | 487 | 5 |
1878598 | 1878598 | 2021-11-03 | Bent | Colorado | 8011 | 1760 | 27 |
1878599 | 1878599 | 2021-11-03 | Boulder | Colorado | 8013 | 31842 | 286 |
1878600 | 1878600 | 2021-11-03 | Broomfield | Colorado | 8014 | 6846 | 83 |
1878601 | 1878601 | 2021-11-03 | Chaffee | Colorado | 8015 | 2369 | 31 |
1878602 | 1878602 | 2021-11-03 | Cheyenne | Colorado | 8017 | 186 | 7 |
1878603 | 1878603 | 2021-11-03 | Clear Creek | Colorado | 8019 | 797 | 5 |
1878604 | 1878604 | 2021-11-03 | Conejos | Colorado | 8021 | 1035 | 35 |
1878605 | 1878605 | 2021-11-03 | Costilla | Colorado | 8023 | 392 | 11 |
1878606 | 1878606 | 2021-11-03 | Crowley | Colorado | 8025 | 2400 | 24 |
1878607 | 1878607 | 2021-11-03 | Custer | Colorado | 8027 | 408 | 7 |
1878608 | 1878608 | 2021-11-03 | Delta | Colorado | 8029 | 4149 | 85 |
1878609 | 1878609 | 2021-11-03 | Denver | Colorado | 8031 | 93464 | 946 |
1878610 | 1878610 | 2021-11-03 | Dolores | Colorado | 8033 | 239 | 3 |
1878611 | 1878611 | 2021-11-03 | Douglas | Colorado | 8035 | 42122 | 327 |
1878612 | 1878612 | 2021-11-03 | Eagle | Colorado | 8037 | 8535 | 31 |
1878613 | 1878613 | 2021-11-03 | El Paso | Colorado | 8041 | 104284 | 1138 |
1878614 | 1878614 | 2021-11-03 | Elbert | Colorado | 8039 | 2797 | 23 |
1878615 | 1878615 | 2021-11-03 | Fremont | Colorado | 8043 | 8847 | 96 |
1878616 | 1878616 | 2021-11-03 | Garfield | Colorado | 8045 | 8135 | 64 |
1878617 | 1878617 | 2021-11-03 | Gilpin | Colorado | 8047 | 467 | 3 |
1878618 | 1878618 | 2021-11-03 | Grand | Colorado | 8049 | 2179 | 16 |
1878619 | 1878619 | 2021-11-03 | Gunnison | Colorado | 8051 | 1852 | 12 |
1878620 | 1878620 | 2021-11-03 | Hinsdale | Colorado | 8053 | 60 | 0 |
1878621 | 1878621 | 2021-11-03 | Huerfano | Colorado | 8055 | 691 | 19 |
1878622 | 1878622 | 2021-11-03 | Jackson | Colorado | 8057 | 115 | 0 |
1878623 | 1878623 | 2021-11-03 | Jefferson | Colorado | 8059 | 65112 | 924 |
1878624 | 1878624 | 2021-11-03 | Kiowa | Colorado | 8061 | 236 | 4 |
1878625 | 1878625 | 2021-11-03 | Kit Carson | Colorado | 8063 | 1005 | 20 |
1878626 | 1878626 | 2021-11-03 | La Plata | Colorado | 8067 | 6071 | 55 |
1878627 | 1878627 | 2021-11-03 | Lake | Colorado | 8065 | 1058 | 1 |
1878628 | 1878628 | 2021-11-03 | Larimer | Colorado | 8069 | 40635 | 314 |
1878629 | 1878629 | 2021-11-03 | Las Animas | Colorado | 8071 | 1912 | 23 |
1878630 | 1878630 | 2021-11-03 | Lincoln | Colorado | 8073 | 1333 | 8 |
1878631 | 1878631 | 2021-11-03 | Logan | Colorado | 8075 | 4807 | 84 |
1878632 | 1878632 | 2021-11-03 | Mesa | Colorado | 8077 | 24763 | 337 |
1878633 | 1878633 | 2021-11-03 | Mineral | Colorado | 8079 | 131 | 1 |
1878634 | 1878634 | 2021-11-03 | Moffat | Colorado | 8081 | 2010 | 44 |
1878635 | 1878635 | 2021-11-03 | Montezuma | Colorado | 8083 | 3405 | 37 |
1878636 | 1878636 | 2021-11-03 | Montrose | Colorado | 8085 | 5829 | 88 |
1878637 | 1878637 | 2021-11-03 | Morgan | Colorado | 8087 | 3551 | 99 |
1878638 | 1878638 | 2021-11-03 | Otero | Colorado | 8089 | 2752 | 84 |
1878639 | 1878639 | 2021-11-03 | Ouray | Colorado | 8091 | 471 | 5 |
1878640 | 1878640 | 2021-11-03 | Park | Colorado | 8093 | 1497 | 10 |
1878641 | 1878641 | 2021-11-03 | Phillips | Colorado | 8095 | 535 | 14 |
1878642 | 1878642 | 2021-11-03 | Pitkin | Colorado | 8097 | 3166 | 5 |
1878643 | 1878643 | 2021-11-03 | Prowers | Colorado | 8099 | 1735 | 30 |
1878644 | 1878644 | 2021-11-03 | Pueblo | Colorado | 8101 | 26336 | 504 |
1878645 | 1878645 | 2021-11-03 | Rio Blanco | Colorado | 8103 | 1076 | 9 |
1878646 | 1878646 | 2021-11-03 | Rio Grande | Colorado | 8105 | 1571 | 23 |
1878647 | 1878647 | 2021-11-03 | Routt | Colorado | 8107 | 3492 | 23 |
1878648 | 1878648 | 2021-11-03 | Saguache | Colorado | 8109 | 706 | 8 |
1878649 | 1878649 | 2021-11-03 | San Juan | Colorado | 8111 | 99 | 1 |
1878650 | 1878650 | 2021-11-03 | San Miguel | Colorado | 8113 | 1191 | 5 |
1878651 | 1878651 | 2021-11-03 | Sedgwick | Colorado | 8115 | 333 | 4 |
1878652 | 1878652 | 2021-11-03 | Summit | Colorado | 8117 | 4877 | 11 |
1878653 | 1878653 | 2021-11-03 | Teller | Colorado | 8119 | 2971 | 35 |
1878654 | 1878654 | 2021-11-03 | Washington | Colorado | 8121 | 691 | 19 |
1878655 | 1878655 | 2021-11-03 | Weld | Colorado | 8123 | 48148 | 464 |
1878656 | 1878656 | 2021-11-03 | Yuma | Colorado | 8125 | 1272 | 18 |
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);