ny_times_us_counties

Table actions
⚠️ 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

19,191 rows where state = "Colorado" sorted by date descending

✎ View and edit SQL

This data as json, yaml, copyable, CSV (advanced)

Suggested facets: date (date)

fips

county

state

  • Colorado · 19,191 ✖
Link rowid date ▲ county state fips cases deaths
959707 959707 2021-01-24 Adams Colorado 8001 45480 587
959708 959708 2021-01-24 Alamosa Colorado 8003 1118 27
959709 959709 2021-01-24 Arapahoe Colorado 8005 44488 644
959710 959710 2021-01-24 Archuleta Colorado 8007 592 1
959711 959711 2021-01-24 Baca Colorado 8009 262 3
959712 959712 2021-01-24 Bent Colorado 8011 1283 20
959713 959713 2021-01-24 Boulder Colorado 8013 16848 219
959714 959714 2021-01-24 Broomfield Colorado 8014 3313 69
959715 959715 2021-01-24 Chaffee Colorado 8015 1258 23
959716 959716 2021-01-24 Cheyenne Colorado 8017 113 5
959717 959717 2021-01-24 Clear Creek Colorado 8019 340 2
959718 959718 2021-01-24 Conejos Colorado 8021 394 3
959719 959719 2021-01-24 Costilla Colorado 8023 175 2
959720 959720 2021-01-24 Crowley Colorado 8025 1764 14
959721 959721 2021-01-24 Custer Colorado 8027 159 1
959722 959722 2021-01-24 Delta Colorado 8029 2240 48
959723 959723 2021-01-24 Denver Colorado 8031 54554 732
959724 959724 2021-01-24 Dolores Colorado 8033 61 0
959725 959725 2021-01-24 Douglas Colorado 8035 18710 224
959726 959726 2021-01-24 Eagle Colorado 8037 4192 18
959727 959727 2021-01-24 El Paso Colorado 8041 46875 685
959728 959728 2021-01-24 Elbert Colorado 8039 1120 12
959729 959729 2021-01-24 Fremont Colorado 8043 5075 35
959730 959730 2021-01-24 Garfield Colorado 8045 4640 36
959731 959731 2021-01-24 Gilpin Colorado 8047 144 2
959732 959732 2021-01-24 Grand Colorado 8049 898 5
959733 959733 2021-01-24 Gunnison Colorado 8051 987 6
959734 959734 2021-01-24 Hinsdale Colorado 8053 15 0
959735 959735 2021-01-24 Huerfano Colorado 8055 288 17
959736 959736 2021-01-24 Jackson Colorado 8057 44 0
959737 959737 2021-01-24 Jefferson Colorado 8059 33760 676
959738 959738 2021-01-24 Kiowa Colorado 8061 85 3
959739 959739 2021-01-24 Kit Carson Colorado 8063 496 10
959740 959740 2021-01-24 La Plata Colorado 8067 2646 31
959741 959741 2021-01-24 Lake Colorado 8065 487 0
959742 959742 2021-01-24 Larimer Colorado 8069 17517 182
959743 959743 2021-01-24 Las Animas Colorado 8071 899 10
959744 959744 2021-01-24 Lincoln Colorado 8073 886 3
959745 959745 2021-01-24 Logan Colorado 8075 3567 58
959746 959746 2021-01-24 Mesa Colorado 8077 11539 161
959747 959747 2021-01-24 Mineral Colorado 8079 57 1
959748 959748 2021-01-24 Moffat Colorado 8081 610 23
959749 959749 2021-01-24 Montezuma Colorado 8083 1579 21
959750 959750 2021-01-24 Montrose Colorado 8085 2900 42
959751 959751 2021-01-24 Morgan Colorado 8087 2338 87
959752 959752 2021-01-24 Otero Colorado 8089 1777 57
959753 959753 2021-01-24 Ouray Colorado 8091 186 3
959754 959754 2021-01-24 Park Colorado 8093 471 5
959755 959755 2021-01-24 Phillips Colorado 8095 319 11
959756 959756 2021-01-24 Pitkin Colorado 8097 1761 4
959757 959757 2021-01-24 Prowers Colorado 8099 1104 21
959758 959758 2021-01-24 Pueblo Colorado 8101 14177 356
959759 959759 2021-01-24 Rio Blanco Colorado 8103 377 3
959760 959760 2021-01-24 Rio Grande Colorado 8105 587 10
959761 959761 2021-01-24 Routt Colorado 8107 1503 19
959762 959762 2021-01-24 Saguache Colorado 8109 290 4
959763 959763 2021-01-24 San Juan Colorado 8111 40 0
959764 959764 2021-01-24 San Miguel Colorado 8113 597 0
959765 959765 2021-01-24 Sedgwick Colorado 8115 183 2
959766 959766 2021-01-24 Summit Colorado 8117 2532 5
959767 959767 2021-01-24 Teller Colorado 8119 1146 13
959768 959768 2021-01-24 Washington Colorado 8121 364 11
959769 959769 2021-01-24 Weld Colorado 8123 23106 301
959770 959770 2021-01-24 Yuma Colorado 8125 644 15
956461 956461 2021-01-23 Adams Colorado 8001 45305 582
956462 956462 2021-01-23 Alamosa Colorado 8003 1110 27
956463 956463 2021-01-23 Arapahoe Colorado 8005 44230 641
956464 956464 2021-01-23 Archuleta Colorado 8007 592 1
956465 956465 2021-01-23 Baca Colorado 8009 260 3
956466 956466 2021-01-23 Bent Colorado 8011 1283 20
956467 956467 2021-01-23 Boulder Colorado 8013 16784 219
956468 956468 2021-01-23 Broomfield Colorado 8014 3290 69
956469 956469 2021-01-23 Chaffee Colorado 8015 1255 23
956470 956470 2021-01-23 Cheyenne Colorado 8017 113 5
956471 956471 2021-01-23 Clear Creek Colorado 8019 340 2
956472 956472 2021-01-23 Conejos Colorado 8021 389 3
956473 956473 2021-01-23 Costilla Colorado 8023 175 2
956474 956474 2021-01-23 Crowley Colorado 8025 1765 14
956475 956475 2021-01-23 Custer Colorado 8027 159 1
956476 956476 2021-01-23 Delta Colorado 8029 2222 45
956477 956477 2021-01-23 Denver Colorado 8031 54371 728
956478 956478 2021-01-23 Dolores Colorado 8033 61 0
956479 956479 2021-01-23 Douglas Colorado 8035 18602 224
956480 956480 2021-01-23 Eagle Colorado 8037 4172 18
956481 956481 2021-01-23 El Paso Colorado 8041 46718 681
956482 956482 2021-01-23 Elbert Colorado 8039 1115 12
956483 956483 2021-01-23 Fremont Colorado 8043 5062 35
956484 956484 2021-01-23 Garfield Colorado 8045 4627 36
956485 956485 2021-01-23 Gilpin Colorado 8047 143 2
956486 956486 2021-01-23 Grand Colorado 8049 892 5
956487 956487 2021-01-23 Gunnison Colorado 8051 975 6
956488 956488 2021-01-23 Hinsdale Colorado 8053 16 0
956489 956489 2021-01-23 Huerfano Colorado 8055 288 17
956490 956490 2021-01-23 Jackson Colorado 8057 44 0
956491 956491 2021-01-23 Jefferson Colorado 8059 33640 675
956492 956492 2021-01-23 Kiowa Colorado 8061 85 3
956493 956493 2021-01-23 Kit Carson Colorado 8063 495 10
956494 956494 2021-01-23 La Plata Colorado 8067 2639 30
956495 956495 2021-01-23 Lake Colorado 8065 486 0
956496 956496 2021-01-23 Larimer Colorado 8069 17454 181

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
);
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]);