ny_times_us_counties

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

6,910 rows where state = "Colorado" sorted by date descending

View and edit SQL

Suggested facets: date (date)

fips

county

state

  • Colorado · 6,910
Link rowid date ▲ county state fips cases deaths
334618 2020-07-15 Adams Colorado 8001 4916 159
334619 2020-07-15 Alamosa Colorado 8003 204 7
334620 2020-07-15 Arapahoe Colorado 8005 5789 352
334621 2020-07-15 Archuleta Colorado 8007 13 0
334622 2020-07-15 Baca Colorado 8009 14 0
334623 2020-07-15 Bent Colorado 8011 5 0
334624 2020-07-15 Boulder Colorado 8013 1595 74
334625 2020-07-15 Broomfield Colorado 8014 352 30
334626 2020-07-15 Chaffee Colorado 8015 123 19
334627 2020-07-15 Cheyenne Colorado 8017 5 0
334628 2020-07-15 Clear Creek Colorado 8019 21 1
334629 2020-07-15 Conejos Colorado 8021 18 0
334630 2020-07-15 Costilla Colorado 8023 22 0
334631 2020-07-15 Crowley Colorado 8025 71 1
334632 2020-07-15 Custer Colorado 8027 7 0
334633 2020-07-15 Delta Colorado 8029 86 1
334634 2020-07-15 Denver Colorado 8031 8098 397
334635 2020-07-15 Douglas Colorado 8035 1224 54
334636 2020-07-15 Eagle Colorado 8037 795 9
334637 2020-07-15 El Paso Colorado 8041 3287 119
334638 2020-07-15 Elbert Colorado 8039 67 2
334639 2020-07-15 Fremont Colorado 8043 47 0
334640 2020-07-15 Garfield Colorado 8045 448 4
334641 2020-07-15 Gilpin Colorado 8047 11 0
334642 2020-07-15 Grand Colorado 8049 29 1
334643 2020-07-15 Gunnison Colorado 8051 193 6
334644 2020-07-15 Hinsdale Colorado 8053 3 0
334645 2020-07-15 Huerfano Colorado 8055 5 1
334646 2020-07-15 Jackson Colorado 8057 8 0
334647 2020-07-15 Jefferson Colorado 8059 3118 217
334648 2020-07-15 Kit Carson Colorado 8063 36 3
334649 2020-07-15 La Plata Colorado 8067 146 1
334650 2020-07-15 Lake Colorado 8065 56 0
334651 2020-07-15 Larimer Colorado 8069 982 30
334652 2020-07-15 Las Animas Colorado 8071 11 0
334653 2020-07-15 Lincoln Colorado 8073 4 0
334654 2020-07-15 Logan Colorado 8075 641 5
334655 2020-07-15 Mesa Colorado 8077 162 0
334656 2020-07-15 Mineral Colorado 8079 17 0
334657 2020-07-15 Moffat Colorado 8081 16 1
334658 2020-07-15 Montezuma Colorado 8083 84 3
334659 2020-07-15 Montrose Colorado 8085 222 12
334660 2020-07-15 Morgan Colorado 8087 663 46
334661 2020-07-15 Otero Colorado 8089 23 1
334662 2020-07-15 Ouray Colorado 8091 12 1
334663 2020-07-15 Park Colorado 8093 33 0
334664 2020-07-15 Phillips Colorado 8095 16 0
334665 2020-07-15 Pitkin Colorado 8097 140 2
334666 2020-07-15 Prowers Colorado 8099 39 0
334667 2020-07-15 Pueblo Colorado 8101 458 32
334668 2020-07-15 Rio Blanco Colorado 8103 6 0
334669 2020-07-15 Rio Grande Colorado 8105 83 2
334670 2020-07-15 Routt Colorado 8107 86 6
334671 2020-07-15 Saguache Colorado 8109 103 2
334672 2020-07-15 San Juan Colorado 8111 2 0
334673 2020-07-15 San Miguel Colorado 8113 57 0
334674 2020-07-15 Sedgwick Colorado 8115 3 0
334675 2020-07-15 Summit Colorado 8117 294 4
334676 2020-07-15 Teller Colorado 8119 65 2
334677 2020-07-15 Washington Colorado 8121 46 0
334678 2020-07-15 Weld Colorado 8123 3105 138
334679 2020-07-15 Yuma Colorado 8125 55 0
331427 2020-07-14 Adams Colorado 8001 4847 159
331428 2020-07-14 Alamosa Colorado 8003 204 7
331429 2020-07-14 Arapahoe Colorado 8005 5734 352
331430 2020-07-14 Archuleta Colorado 8007 12 0
331431 2020-07-14 Baca Colorado 8009 14 0
331432 2020-07-14 Bent Colorado 8011 4 0
331433 2020-07-14 Boulder Colorado 8013 1572 74
331434 2020-07-14 Broomfield Colorado 8014 348 30
331435 2020-07-14 Chaffee Colorado 8015 123 19
331436 2020-07-14 Cheyenne Colorado 8017 5 0
331437 2020-07-14 Clear Creek Colorado 8019 21 1
331438 2020-07-14 Conejos Colorado 8021 18 0
331439 2020-07-14 Costilla Colorado 8023 22 0
331440 2020-07-14 Crowley Colorado 8025 71 1
331441 2020-07-14 Custer Colorado 8027 7 0
331442 2020-07-14 Delta Colorado 8029 84 1
331443 2020-07-14 Denver Colorado 8031 8011 395
331444 2020-07-14 Douglas Colorado 8035 1201 53
331445 2020-07-14 Eagle Colorado 8037 783 8
331446 2020-07-14 El Paso Colorado 8041 3224 118
331447 2020-07-14 Elbert Colorado 8039 65 2
331448 2020-07-14 Fremont Colorado 8043 46 0
331449 2020-07-14 Garfield Colorado 8045 441 3
331450 2020-07-14 Gilpin Colorado 8047 8 0
331451 2020-07-14 Grand Colorado 8049 29 1
331452 2020-07-14 Gunnison Colorado 8051 193 6
331453 2020-07-14 Hinsdale Colorado 8053 3 0
331454 2020-07-14 Huerfano Colorado 8055 5 1
331455 2020-07-14 Jackson Colorado 8057 8 0
331456 2020-07-14 Jefferson Colorado 8059 3089 217
331457 2020-07-14 Kit Carson Colorado 8063 37 3
331458 2020-07-14 La Plata Colorado 8067 146 1
331459 2020-07-14 Lake Colorado 8065 54 0
331460 2020-07-14 Larimer Colorado 8069 959 30
331461 2020-07-14 Las Animas Colorado 8071 10 0
331462 2020-07-14 Lincoln Colorado 8073 4 0
331463 2020-07-14 Logan Colorado 8075 641 5
331464 2020-07-14 Mesa Colorado 8077 153 0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [ny_times_us_counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);
Powered by Datasette · Query took 1464.114ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette