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

49,527 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 >30

county >30

state 1

  • Colorado · 49,527 ✖
Link rowid date ▲ county state fips cases deaths
2499820 2499820 2022-05-13 Adams Colorado 8001 137720 1380
2499821 2499821 2022-05-13 Alamosa Colorado 8003 4560 62
2499822 2499822 2022-05-13 Arapahoe Colorado 8005 158561 1284
2499823 2499823 2022-05-13 Archuleta Colorado 8007 2926 16
2499824 2499824 2022-05-13 Baca Colorado 8009 855 13
2499825 2499825 2022-05-13 Bent Colorado 8011 2560 47
2499826 2499826 2022-05-13 Boulder Colorado 8013 68435 373
2499827 2499827 2022-05-13 Broomfield Colorado 8014 13997 116
2499828 2499828 2022-05-13 Chaffee Colorado 8015 4749 47
2499829 2499829 2022-05-13 Cheyenne Colorado 8017 322 9
2499830 2499830 2022-05-13 Clear Creek Colorado 8019 1601 12
2499831 2499831 2022-05-13 Conejos Colorado 8021 1763 54
2499832 2499832 2022-05-13 Costilla Colorado 8023 708 18
2499833 2499833 2022-05-13 Crowley Colorado 8025 3347 30
2499834 2499834 2022-05-13 Custer Colorado 8027 656 21
2499835 2499835 2022-05-13 Delta Colorado 8029 6232 140
2499836 2499836 2022-05-13 Denver Colorado 8031 177033 1360
2499837 2499837 2022-05-13 Dolores Colorado 8033 367 8
2499838 2499838 2022-05-13 Douglas Colorado 8035 81400 460
2499839 2499839 2022-05-13 Eagle Colorado 8037 16274 35
2499840 2499840 2022-05-13 El Paso Colorado 8041 190541 1695
2499841 2499841 2022-05-13 Elbert Colorado 8039 4880 40
2499842 2499842 2022-05-13 Fremont Colorado 8043 15481 187
2499843 2499843 2022-05-13 Garfield Colorado 8045 15076 91
2499844 2499844 2022-05-13 Gilpin Colorado 8047 977 4
2499845 2499845 2022-05-13 Grand Colorado 8049 3599 28
2499846 2499846 2022-05-13 Gunnison Colorado 8051 3407 14
2499847 2499847 2022-05-13 Hinsdale Colorado 8053 131 0
2499848 2499848 2022-05-13 Huerfano Colorado 8055 1452 35
2499849 2499849 2022-05-13 Jackson Colorado 8057 166 0
2499850 2499850 2022-05-13 Jefferson Colorado 8059 128067 1356
2499851 2499851 2022-05-13 Kiowa Colorado 8061 336 6
2499852 2499852 2022-05-13 Kit Carson Colorado 8063 1621 33
2499853 2499853 2022-05-13 La Plata Colorado 8067 13002 86
2499854 2499854 2022-05-13 Lake Colorado 8065 1843 2
2499855 2499855 2022-05-13 Larimer Colorado 8069 81210 505
2499856 2499856 2022-05-13 Las Animas Colorado 8071 3635 43
2499857 2499857 2022-05-13 Lincoln Colorado 8073 2199 9
2499858 2499858 2022-05-13 Logan Colorado 8075 7480 109
2499859 2499859 2022-05-13 Mesa Colorado 8077 43093 565
2499860 2499860 2022-05-13 Mineral Colorado 8079 241 2
2499861 2499861 2022-05-13 Moffat Colorado 8081 3062 52
2499862 2499862 2022-05-13 Montezuma Colorado 8083 6229 81
2499863 2499863 2022-05-13 Montrose Colorado 8085 9398 160
2499864 2499864 2022-05-13 Morgan Colorado 8087 5735 138
2499865 2499865 2022-05-13 Otero Colorado 8089 4322 130
2499866 2499866 2022-05-13 Ouray Colorado 8091 884 6
2499867 2499867 2022-05-13 Park Colorado 8093 2913 20
2499868 2499868 2022-05-13 Phillips Colorado 8095 894 19
2499869 2499869 2022-05-13 Pitkin Colorado 8097 6676 7
2499870 2499870 2022-05-13 Prowers Colorado 8099 2654 51
2499871 2499871 2022-05-13 Pueblo Colorado 8101 47690 802
2499872 2499872 2022-05-13 Rio Blanco Colorado 8103 1696 13
2499873 2499873 2022-05-13 Rio Grande Colorado 8105 2856 46
2499874 2499874 2022-05-13 Routt Colorado 8107 6562 25
2499875 2499875 2022-05-13 Saguache Colorado 8109 1203 12
2499876 2499876 2022-05-13 San Juan Colorado 8111 203 0
2499877 2499877 2022-05-13 San Miguel Colorado 8113 2322 8
2499878 2499878 2022-05-13 Sedgwick Colorado 8115 490 11
2499879 2499879 2022-05-13 Summit Colorado 8117 10087 14
2499880 2499880 2022-05-13 Teller Colorado 8119 4897 57
2499881 2499881 2022-05-13 Washington Colorado 8121 1066 28
2499882 2499882 2022-05-13 Weld Colorado 8123 85893 703
2499883 2499883 2022-05-13 Yuma Colorado 8125 1886 23
2496562 2496562 2022-05-12 Adams Colorado 8001 137545 1379
2496563 2496563 2022-05-12 Alamosa Colorado 8003 4559 62
2496564 2496564 2022-05-12 Arapahoe Colorado 8005 158289 1283
2496565 2496565 2022-05-12 Archuleta Colorado 8007 2923 16
2496566 2496566 2022-05-12 Baca Colorado 8009 855 13
2496567 2496567 2022-05-12 Bent Colorado 8011 2558 47
2496568 2496568 2022-05-12 Boulder Colorado 8013 67712 373
2496569 2496569 2022-05-12 Broomfield Colorado 8014 13949 116
2496570 2496570 2022-05-12 Chaffee Colorado 8015 4740 47
2496571 2496571 2022-05-12 Cheyenne Colorado 8017 322 9
2496572 2496572 2022-05-12 Clear Creek Colorado 8019 1599 12
2496573 2496573 2022-05-12 Conejos Colorado 8021 1762 54
2496574 2496574 2022-05-12 Costilla Colorado 8023 708 18
2496575 2496575 2022-05-12 Crowley Colorado 8025 3344 30
2496576 2496576 2022-05-12 Custer Colorado 8027 656 21
2496577 2496577 2022-05-12 Delta Colorado 8029 6232 140
2496578 2496578 2022-05-12 Denver Colorado 8031 176787 1359
2496579 2496579 2022-05-12 Dolores Colorado 8033 367 8
2496580 2496580 2022-05-12 Douglas Colorado 8035 81277 460
2496581 2496581 2022-05-12 Eagle Colorado 8037 16264 35
2496582 2496582 2022-05-12 El Paso Colorado 8041 190329 1694
2496583 2496583 2022-05-12 Elbert Colorado 8039 4874 40
2496584 2496584 2022-05-12 Fremont Colorado 8043 15464 187
2496585 2496585 2022-05-12 Garfield Colorado 8045 15059 91
2496586 2496586 2022-05-12 Gilpin Colorado 8047 975 5
2496587 2496587 2022-05-12 Grand Colorado 8049 3599 28
2496588 2496588 2022-05-12 Gunnison Colorado 8051 3406 14
2496589 2496589 2022-05-12 Hinsdale Colorado 8053 131 0
2496590 2496590 2022-05-12 Huerfano Colorado 8055 1451 35
2496591 2496591 2022-05-12 Jackson Colorado 8057 166 0
2496592 2496592 2022-05-12 Jefferson Colorado 8059 127849 1356
2496593 2496593 2022-05-12 Kiowa Colorado 8061 336 6
2496594 2496594 2022-05-12 Kit Carson Colorado 8063 1621 33
2496595 2496595 2022-05-12 La Plata Colorado 8067 12990 86
2496596 2496596 2022-05-12 Lake Colorado 8065 1842 2
2496597 2496597 2022-05-12 Larimer Colorado 8069 81056 503

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