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

36,599 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 · 36,599 ✖
Link rowid date ▲ county state fips cases deaths
1842852 1842852 2021-10-23 Adams Colorado 8001 76085 878
1842853 1842853 2021-10-23 Alamosa Colorado 8003 2408 44
1842854 1842854 2021-10-23 Arapahoe Colorado 8005 80204 928
1842855 1842855 2021-10-23 Archuleta Colorado 8007 1469 4
1842856 1842856 2021-10-23 Baca Colorado 8009 437 5
1842857 1842857 2021-10-23 Bent Colorado 8011 1704 26
1842858 1842858 2021-10-23 Boulder Colorado 8013 30551 279
1842859 1842859 2021-10-23 Broomfield Colorado 8014 6584 81
1842860 1842860 2021-10-23 Chaffee Colorado 8015 2241 30
1842861 1842861 2021-10-23 Cheyenne Colorado 8017 181 7
1842862 1842862 2021-10-23 Clear Creek Colorado 8019 762 5
1842863 1842863 2021-10-23 Conejos Colorado 8021 983 33
1842864 1842864 2021-10-23 Costilla Colorado 8023 379 10
1842865 1842865 2021-10-23 Crowley Colorado 8025 2378 22
1842866 1842866 2021-10-23 Custer Colorado 8027 358 7
1842867 1842867 2021-10-23 Delta Colorado 8029 3907 82
1842868 1842868 2021-10-23 Denver Colorado 8031 90270 929
1842869 1842869 2021-10-23 Dolores Colorado 8033 235 2
1842870 1842870 2021-10-23 Douglas Colorado 8035 40548 319
1842871 1842871 2021-10-23 Eagle Colorado 8037 8268 31
1842872 1842872 2021-10-23 El Paso Colorado 8041 99562 1092
1842873 1842873 2021-10-23 Elbert Colorado 8039 2684 23
1842874 1842874 2021-10-23 Fremont Colorado 8043 8334 89
1842875 1842875 2021-10-23 Garfield Colorado 8045 7800 60
1842876 1842876 2021-10-23 Gilpin Colorado 8047 432 3
1842877 1842877 2021-10-23 Grand Colorado 8049 2144 16
1842878 1842878 2021-10-23 Gunnison Colorado 8051 1817 12
1842879 1842879 2021-10-23 Hinsdale Colorado 8053 56 0
1842880 1842880 2021-10-23 Huerfano Colorado 8055 622 19
1842881 1842881 2021-10-23 Jackson Colorado 8057 111 0
1842882 1842882 2021-10-23 Jefferson Colorado 8059 62065 903
1842883 1842883 2021-10-23 Kiowa Colorado 8061 205 4
1842884 1842884 2021-10-23 Kit Carson Colorado 8063 974 15
1842885 1842885 2021-10-23 La Plata Colorado 8067 5696 52
1842886 1842886 2021-10-23 Lake Colorado 8065 1023 1
1842887 1842887 2021-10-23 Larimer Colorado 8069 38435 303
1842888 1842888 2021-10-23 Las Animas Colorado 8071 1801 22
1842889 1842889 2021-10-23 Lincoln Colorado 8073 1311 8
1842890 1842890 2021-10-23 Logan Colorado 8075 4663 80
1842891 1842891 2021-10-23 Mesa Colorado 8077 23575 324
1842892 1842892 2021-10-23 Mineral Colorado 8079 128 1
1842893 1842893 2021-10-23 Moffat Colorado 8081 1948 40
1842894 1842894 2021-10-23 Montezuma Colorado 8083 3095 37
1842895 1842895 2021-10-23 Montrose Colorado 8085 5319 84
1842896 1842896 2021-10-23 Morgan Colorado 8087 3375 99
1842897 1842897 2021-10-23 Otero Colorado 8089 2628 80
1842898 1842898 2021-10-23 Ouray Colorado 8091 444 5
1842899 1842899 2021-10-23 Park Colorado 8093 1385 8
1842900 1842900 2021-10-23 Phillips Colorado 8095 516 14
1842901 1842901 2021-10-23 Pitkin Colorado 8097 3111 5
1842902 1842902 2021-10-23 Prowers Colorado 8099 1628 30
1842903 1842903 2021-10-23 Pueblo Colorado 8101 24665 483
1842904 1842904 2021-10-23 Rio Blanco Colorado 8103 969 8
1842905 1842905 2021-10-23 Rio Grande Colorado 8105 1477 22
1842906 1842906 2021-10-23 Routt Colorado 8107 3322 23
1842907 1842907 2021-10-23 Saguache Colorado 8109 671 8
1842908 1842908 2021-10-23 San Juan Colorado 8111 95 1
1842909 1842909 2021-10-23 San Miguel Colorado 8113 1171 4
1842910 1842910 2021-10-23 Sedgwick Colorado 8115 314 4
1842911 1842911 2021-10-23 Summit Colorado 8117 4747 11
1842912 1842912 2021-10-23 Teller Colorado 8119 2807 27
1842913 1842913 2021-10-23 Washington Colorado 8121 655 18
1842914 1842914 2021-10-23 Weld Colorado 8123 45764 440
1842915 1842915 2021-10-23 Yuma Colorado 8125 1220 18
1839602 1839602 2021-10-22 Adams Colorado 8001 75814 872
1839603 1839603 2021-10-22 Alamosa Colorado 8003 2408 44
1839604 1839604 2021-10-22 Arapahoe Colorado 8005 79966 919
1839605 1839605 2021-10-22 Archuleta Colorado 8007 1469 4
1839606 1839606 2021-10-22 Baca Colorado 8009 437 5
1839607 1839607 2021-10-22 Bent Colorado 8011 1704 26
1839608 1839608 2021-10-22 Boulder Colorado 8013 30551 279
1839609 1839609 2021-10-22 Broomfield Colorado 8014 6584 81
1839610 1839610 2021-10-22 Chaffee Colorado 8015 2241 30
1839611 1839611 2021-10-22 Cheyenne Colorado 8017 181 7
1839612 1839612 2021-10-22 Clear Creek Colorado 8019 762 5
1839613 1839613 2021-10-22 Conejos Colorado 8021 983 33
1839614 1839614 2021-10-22 Costilla Colorado 8023 379 10
1839615 1839615 2021-10-22 Crowley Colorado 8025 2378 22
1839616 1839616 2021-10-22 Custer Colorado 8027 358 7
1839617 1839617 2021-10-22 Delta Colorado 8029 3907 82
1839618 1839618 2021-10-22 Denver Colorado 8031 90270 929
1839619 1839619 2021-10-22 Dolores Colorado 8033 235 2
1839620 1839620 2021-10-22 Douglas Colorado 8035 40415 318
1839621 1839621 2021-10-22 Eagle Colorado 8037 8268 31
1839622 1839622 2021-10-22 El Paso Colorado 8041 99562 1092
1839623 1839623 2021-10-22 Elbert Colorado 8039 2684 23
1839624 1839624 2021-10-22 Fremont Colorado 8043 8334 89
1839625 1839625 2021-10-22 Garfield Colorado 8045 7800 60
1839626 1839626 2021-10-22 Gilpin Colorado 8047 432 3
1839627 1839627 2021-10-22 Grand Colorado 8049 2144 16
1839628 1839628 2021-10-22 Gunnison Colorado 8051 1817 12
1839629 1839629 2021-10-22 Hinsdale Colorado 8053 56 0
1839630 1839630 2021-10-22 Huerfano Colorado 8055 622 19
1839631 1839631 2021-10-22 Jackson Colorado 8057 111 0
1839632 1839632 2021-10-22 Jefferson Colorado 8059 62065 903
1839633 1839633 2021-10-22 Kiowa Colorado 8061 205 4
1839634 1839634 2021-10-22 Kit Carson Colorado 8063 974 15
1839635 1839635 2021-10-22 La Plata Colorado 8067 5696 52
1839636 1839636 2021-10-22 Lake Colorado 8065 1023 1
1839637 1839637 2021-10-22 Larimer Colorado 8069 38435 303

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