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

21,623 rows where state = "Colorado" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

fips

county

state

  • Colorado · 21,623 ✖
Link rowid date ▲ county state fips cases deaths
1082960 1082960 2021-03-03 Adams Colorado 8001 49615 630
1082961 1082961 2021-03-03 Alamosa Colorado 8003 1294 28
1082962 1082962 2021-03-03 Arapahoe Colorado 8005 49722 695
1082963 1082963 2021-03-03 Archuleta Colorado 8007 662 1
1082964 1082964 2021-03-03 Baca Colorado 8009 273 4
1082965 1082965 2021-03-03 Bent Colorado 8011 1479 21
1082966 1082966 2021-03-03 Boulder Colorado 8013 19082 247
1082967 1082967 2021-03-03 Broomfield Colorado 8014 3789 74
1082968 1082968 2021-03-03 Chaffee Colorado 8015 1463 24
1082969 1082969 2021-03-03 Cheyenne Colorado 8017 125 5
1082970 1082970 2021-03-03 Clear Creek Colorado 8019 364 2
1082971 1082971 2021-03-03 Conejos Colorado 8021 444 9
1082972 1082972 2021-03-03 Costilla Colorado 8023 190 2
1082973 1082973 2021-03-03 Crowley Colorado 8025 2051 14
1082974 1082974 2021-03-03 Custer Colorado 8027 164 1
1082975 1082975 2021-03-03 Delta Colorado 8029 2476 60
1082976 1082976 2021-03-03 Denver Colorado 8031 59985 769
1082977 1082977 2021-03-03 Dolores Colorado 8033 69 0
1082978 1082978 2021-03-03 Douglas Colorado 8035 22046 231
1082979 1082979 2021-03-03 Eagle Colorado 8037 5148 21
1082980 1082980 2021-03-03 El Paso Colorado 8041 52443 746
1082981 1082981 2021-03-03 Elbert Colorado 8039 1289 12
1082982 1082982 2021-03-03 Fremont Colorado 8043 5480 50
1082983 1082983 2021-03-03 Garfield Colorado 8045 5120 38
1082984 1082984 2021-03-03 Gilpin Colorado 8047 168 3
1082985 1082985 2021-03-03 Grand Colorado 8049 1282 5
1082986 1082986 2021-03-03 Gunnison Colorado 8051 1211 6
1082987 1082987 2021-03-03 Hinsdale Colorado 8053 17 0
1082988 1082988 2021-03-03 Huerfano Colorado 8055 312 16
1082989 1082989 2021-03-03 Jackson Colorado 8057 51 0
1082990 1082990 2021-03-03 Jefferson Colorado 8059 37452 727
1082991 1082991 2021-03-03 Kiowa Colorado 8061 91 3
1082992 1082992 2021-03-03 Kit Carson Colorado 8063 542 10
1082993 1082993 2021-03-03 La Plata Colorado 8067 2987 37
1082994 1082994 2021-03-03 Lake Colorado 8065 660 0
1082995 1082995 2021-03-03 Larimer Colorado 8069 20300 224
1082996 1082996 2021-03-03 Las Animas Colorado 8071 1002 11
1082997 1082997 2021-03-03 Lincoln Colorado 8073 998 3
1082998 1082998 2021-03-03 Logan Colorado 8075 3744 65
1082999 1082999 2021-03-03 Mesa Colorado 8077 13392 200
1083000 1083000 2021-03-03 Mineral Colorado 8079 61 1
1083001 1083001 2021-03-03 Moffat Colorado 8081 678 22
1083002 1083002 2021-03-03 Montezuma Colorado 8083 1731 22
1083003 1083003 2021-03-03 Montrose Colorado 8085 3269 53
1083004 1083004 2021-03-03 Morgan Colorado 8087 2435 90
1083005 1083005 2021-03-03 Otero Colorado 8089 1863 62
1083006 1083006 2021-03-03 Ouray Colorado 8091 258 3
1083007 1083007 2021-03-03 Park Colorado 8093 554 5
1083008 1083008 2021-03-03 Phillips Colorado 8095 337 12
1083009 1083009 2021-03-03 Pitkin Colorado 8097 2034 4
1083010 1083010 2021-03-03 Prowers Colorado 8099 1161 21
1083011 1083011 2021-03-03 Pueblo Colorado 8101 15110 364
1083012 1083012 2021-03-03 Rio Blanco Colorado 8103 480 3
1083013 1083013 2021-03-03 Rio Grande Colorado 8105 708 13
1083014 1083014 2021-03-03 Routt Colorado 8107 1903 19
1083015 1083015 2021-03-03 Saguache Colorado 8109 323 4
1083016 1083016 2021-03-03 San Juan Colorado 8111 43 0
1083017 1083017 2021-03-03 San Miguel Colorado 8113 822 0
1083018 1083018 2021-03-03 Sedgwick Colorado 8115 191 2
1083019 1083019 2021-03-03 Summit Colorado 8117 3053 7
1083020 1083020 2021-03-03 Teller Colorado 8119 1279 14
1083021 1083021 2021-03-03 Washington Colorado 8121 392 12
1083022 1083022 2021-03-03 Weld Colorado 8123 25760 319
1083023 1083023 2021-03-03 Yuma Colorado 8125 716 17
1079714 1079714 2021-03-02 Adams Colorado 8001 49497 628
1079715 1079715 2021-03-02 Alamosa Colorado 8003 1289 28
1079716 1079716 2021-03-02 Arapahoe Colorado 8005 49624 695
1079717 1079717 2021-03-02 Archuleta Colorado 8007 656 1
1079718 1079718 2021-03-02 Baca Colorado 8009 273 4
1079719 1079719 2021-03-02 Bent Colorado 8011 1479 21
1079720 1079720 2021-03-02 Boulder Colorado 8013 19003 247
1079721 1079721 2021-03-02 Broomfield Colorado 8014 3772 74
1079722 1079722 2021-03-02 Chaffee Colorado 8015 1454 25
1079723 1079723 2021-03-02 Cheyenne Colorado 8017 125 5
1079724 1079724 2021-03-02 Clear Creek Colorado 8019 364 2
1079725 1079725 2021-03-02 Conejos Colorado 8021 444 9
1079726 1079726 2021-03-02 Costilla Colorado 8023 189 2
1079727 1079727 2021-03-02 Crowley Colorado 8025 2048 14
1079728 1079728 2021-03-02 Custer Colorado 8027 164 1
1079729 1079729 2021-03-02 Delta Colorado 8029 2473 60
1079730 1079730 2021-03-02 Denver Colorado 8031 59842 769
1079731 1079731 2021-03-02 Dolores Colorado 8033 69 0
1079732 1079732 2021-03-02 Douglas Colorado 8035 21940 230
1079733 1079733 2021-03-02 Eagle Colorado 8037 5120 20
1079734 1079734 2021-03-02 El Paso Colorado 8041 52264 746
1079735 1079735 2021-03-02 Elbert Colorado 8039 1287 12
1079736 1079736 2021-03-02 Fremont Colorado 8043 5476 50
1079737 1079737 2021-03-02 Garfield Colorado 8045 5116 38
1079738 1079738 2021-03-02 Gilpin Colorado 8047 168 3
1079739 1079739 2021-03-02 Grand Colorado 8049 1273 5
1079740 1079740 2021-03-02 Gunnison Colorado 8051 1207 6
1079741 1079741 2021-03-02 Hinsdale Colorado 8053 16 0
1079742 1079742 2021-03-02 Huerfano Colorado 8055 310 16
1079743 1079743 2021-03-02 Jackson Colorado 8057 51 0
1079744 1079744 2021-03-02 Jefferson Colorado 8059 37380 725
1079745 1079745 2021-03-02 Kiowa Colorado 8061 91 3
1079746 1079746 2021-03-02 Kit Carson Colorado 8063 540 10
1079747 1079747 2021-03-02 La Plata Colorado 8067 2982 37
1079748 1079748 2021-03-02 Lake Colorado 8065 661 0
1079749 1079749 2021-03-02 Larimer Colorado 8069 20234 222

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]);
CREATE INDEX [idx_ny_times_us_counties_date]
    ON [ny_times_us_counties] ([date]);