ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where fips = 8041 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1810382 | 1810382 | 2021-10-13 | El Paso | Colorado | 8041 | 96167 | 1059 |
1807133 | 1807133 | 2021-10-12 | El Paso | Colorado | 8041 | 95848 | 1050 |
1803882 | 1803882 | 2021-10-11 | El Paso | Colorado | 8041 | 95581 | 1047 |
1800633 | 1800633 | 2021-10-10 | El Paso | Colorado | 8041 | 94658 | 1042 |
1797384 | 1797384 | 2021-10-09 | El Paso | Colorado | 8041 | 94658 | 1042 |
1794135 | 1794135 | 2021-10-08 | El Paso | Colorado | 8041 | 94658 | 1042 |
1790887 | 1790887 | 2021-10-07 | El Paso | Colorado | 8041 | 94170 | 1030 |
1787638 | 1787638 | 2021-10-06 | El Paso | Colorado | 8041 | 93711 | 1027 |
1784389 | 1784389 | 2021-10-05 | El Paso | Colorado | 8041 | 93412 | 1024 |
1781140 | 1781140 | 2021-10-04 | El Paso | Colorado | 8041 | 93030 | 1023 |
1777890 | 1777890 | 2021-10-03 | El Paso | Colorado | 8041 | 92151 | 1017 |
1774640 | 1774640 | 2021-10-02 | El Paso | Colorado | 8041 | 92151 | 1017 |
1771390 | 1771390 | 2021-10-01 | El Paso | Colorado | 8041 | 92151 | 1017 |
1768141 | 1768141 | 2021-09-30 | El Paso | Colorado | 8041 | 91824 | 1010 |
1764892 | 1764892 | 2021-09-29 | El Paso | Colorado | 8041 | 91375 | 1008 |
1761643 | 1761643 | 2021-09-28 | El Paso | Colorado | 8041 | 91095 | 1005 |
1758395 | 1758395 | 2021-09-27 | El Paso | Colorado | 8041 | 90704 | 998 |
1755147 | 1755147 | 2021-09-26 | El Paso | Colorado | 8041 | 89984 | 991 |
1751899 | 1751899 | 2021-09-25 | El Paso | Colorado | 8041 | 89984 | 991 |
1748650 | 1748650 | 2021-09-24 | El Paso | Colorado | 8041 | 89984 | 991 |
1745400 | 1745400 | 2021-09-23 | El Paso | Colorado | 8041 | 89681 | 991 |
1742151 | 1742151 | 2021-09-22 | El Paso | Colorado | 8041 | 89321 | 988 |
1738902 | 1738902 | 2021-09-21 | El Paso | Colorado | 8041 | 89034 | 983 |
1735653 | 1735653 | 2021-09-20 | El Paso | Colorado | 8041 | 88717 | 979 |
1732403 | 1732403 | 2021-09-19 | El Paso | Colorado | 8041 | 87936 | 975 |
1729153 | 1729153 | 2021-09-18 | El Paso | Colorado | 8041 | 87936 | 975 |
1725903 | 1725903 | 2021-09-17 | El Paso | Colorado | 8041 | 87936 | 975 |
1722654 | 1722654 | 2021-09-16 | El Paso | Colorado | 8041 | 87596 | 973 |
1719405 | 1719405 | 2021-09-15 | El Paso | Colorado | 8041 | 87249 | 973 |
1716157 | 1716157 | 2021-09-14 | El Paso | Colorado | 8041 | 86922 | 970 |
1712911 | 1712911 | 2021-09-13 | El Paso | Colorado | 8041 | 86531 | 968 |
1709664 | 1709664 | 2021-09-12 | El Paso | Colorado | 8041 | 85603 | 966 |
1706417 | 1706417 | 2021-09-11 | El Paso | Colorado | 8041 | 85603 | 966 |
1703169 | 1703169 | 2021-09-10 | El Paso | Colorado | 8041 | 85603 | 966 |
1699919 | 1699919 | 2021-09-09 | El Paso | Colorado | 8041 | 85222 | 965 |
1696670 | 1696670 | 2021-09-08 | El Paso | Colorado | 8041 | 84847 | 958 |
1693422 | 1693422 | 2021-09-07 | El Paso | Colorado | 8041 | 84593 | 956 |
1690173 | 1690173 | 2021-09-06 | El Paso | Colorado | 8041 | 84360 | 956 |
1686923 | 1686923 | 2021-09-05 | El Paso | Colorado | 8041 | 83578 | 949 |
1683673 | 1683673 | 2021-09-04 | El Paso | Colorado | 8041 | 83578 | 949 |
1680422 | 1680422 | 2021-09-03 | El Paso | Colorado | 8041 | 83578 | 949 |
1677174 | 1677174 | 2021-09-02 | El Paso | Colorado | 8041 | 83187 | 944 |
1673927 | 1673927 | 2021-09-01 | El Paso | Colorado | 8041 | 82854 | 939 |
1670679 | 1670679 | 2021-08-31 | El Paso | Colorado | 8041 | 82521 | 938 |
1667432 | 1667432 | 2021-08-30 | El Paso | Colorado | 8041 | 82082 | 937 |
1664185 | 1664185 | 2021-08-29 | El Paso | Colorado | 8041 | 81527 | 933 |
1660937 | 1660937 | 2021-08-28 | El Paso | Colorado | 8041 | 81527 | 933 |
1657689 | 1657689 | 2021-08-27 | El Paso | Colorado | 8041 | 81527 | 933 |
1654441 | 1654441 | 2021-08-26 | El Paso | Colorado | 8041 | 81239 | 931 |
1651194 | 1651194 | 2021-08-25 | El Paso | Colorado | 8041 | 80981 | 931 |
1647945 | 1647945 | 2021-08-24 | El Paso | Colorado | 8041 | 80680 | 932 |
1644697 | 1644697 | 2021-08-23 | El Paso | Colorado | 8041 | 80513 | 930 |
1641447 | 1641447 | 2021-08-22 | El Paso | Colorado | 8041 | 79952 | 927 |
1638197 | 1638197 | 2021-08-21 | El Paso | Colorado | 8041 | 79952 | 927 |
1634947 | 1634947 | 2021-08-20 | El Paso | Colorado | 8041 | 79952 | 927 |
1631698 | 1631698 | 2021-08-19 | El Paso | Colorado | 8041 | 79746 | 926 |
1628451 | 1628451 | 2021-08-18 | El Paso | Colorado | 8041 | 79547 | 926 |
1625204 | 1625204 | 2021-08-17 | El Paso | Colorado | 8041 | 79317 | 926 |
1621957 | 1621957 | 2021-08-16 | El Paso | Colorado | 8041 | 79060 | 926 |
1618710 | 1618710 | 2021-08-15 | El Paso | Colorado | 8041 | 78666 | 920 |
1615462 | 1615462 | 2021-08-14 | El Paso | Colorado | 8041 | 78666 | 920 |
1612213 | 1612213 | 2021-08-13 | El Paso | Colorado | 8041 | 78666 | 920 |
1608965 | 1608965 | 2021-08-12 | El Paso | Colorado | 8041 | 78504 | 916 |
1605716 | 1605716 | 2021-08-11 | El Paso | Colorado | 8041 | 78272 | 916 |
1602467 | 1602467 | 2021-08-10 | El Paso | Colorado | 8041 | 78054 | 917 |
1599218 | 1599218 | 2021-08-09 | El Paso | Colorado | 8041 | 77888 | 914 |
1595969 | 1595969 | 2021-08-08 | El Paso | Colorado | 8041 | 77490 | 910 |
1592720 | 1592720 | 2021-08-07 | El Paso | Colorado | 8041 | 77490 | 910 |
1589471 | 1589471 | 2021-08-06 | El Paso | Colorado | 8041 | 77490 | 910 |
1586222 | 1586222 | 2021-08-05 | El Paso | Colorado | 8041 | 77258 | 909 |
1582972 | 1582972 | 2021-08-04 | El Paso | Colorado | 8041 | 77024 | 909 |
1579722 | 1579722 | 2021-08-03 | El Paso | Colorado | 8041 | 76758 | 909 |
1576474 | 1576474 | 2021-08-02 | El Paso | Colorado | 8041 | 76581 | 909 |
1573226 | 1573226 | 2021-08-01 | El Paso | Colorado | 8041 | 76231 | 905 |
1569978 | 1569978 | 2021-07-31 | El Paso | Colorado | 8041 | 76231 | 905 |
1566730 | 1566730 | 2021-07-30 | El Paso | Colorado | 8041 | 76231 | 905 |
1563482 | 1563482 | 2021-07-29 | El Paso | Colorado | 8041 | 76067 | 903 |
1560234 | 1560234 | 2021-07-28 | El Paso | Colorado | 8041 | 75870 | 899 |
1556987 | 1556987 | 2021-07-27 | El Paso | Colorado | 8041 | 75587 | 900 |
1553740 | 1553740 | 2021-07-26 | El Paso | Colorado | 8041 | 75587 | 900 |
1550493 | 1550493 | 2021-07-25 | El Paso | Colorado | 8041 | 75300 | 897 |
1547246 | 1547246 | 2021-07-24 | El Paso | Colorado | 8041 | 75300 | 897 |
1543999 | 1543999 | 2021-07-23 | El Paso | Colorado | 8041 | 75300 | 897 |
1540751 | 1540751 | 2021-07-22 | El Paso | Colorado | 8041 | 75193 | 898 |
1537504 | 1537504 | 2021-07-21 | El Paso | Colorado | 8041 | 75043 | 894 |
1534256 | 1534256 | 2021-07-20 | El Paso | Colorado | 8041 | 74816 | 890 |
1531009 | 1531009 | 2021-07-19 | El Paso | Colorado | 8041 | 74816 | 890 |
1527762 | 1527762 | 2021-07-18 | El Paso | Colorado | 8041 | 74598 | 887 |
1524515 | 1524515 | 2021-07-17 | El Paso | Colorado | 8041 | 74598 | 887 |
1521267 | 1521267 | 2021-07-16 | El Paso | Colorado | 8041 | 74598 | 887 |
1518019 | 1518019 | 2021-07-15 | El Paso | Colorado | 8041 | 74502 | 887 |
1514772 | 1514772 | 2021-07-14 | El Paso | Colorado | 8041 | 74434 | 889 |
1511526 | 1511526 | 2021-07-13 | El Paso | Colorado | 8041 | 74353 | 886 |
1508279 | 1508279 | 2021-07-12 | El Paso | Colorado | 8041 | 74223 | 885 |
1505033 | 1505033 | 2021-07-11 | El Paso | Colorado | 8041 | 74171 | 885 |
1501787 | 1501787 | 2021-07-10 | El Paso | Colorado | 8041 | 74110 | 883 |
1498541 | 1498541 | 2021-07-09 | El Paso | Colorado | 8041 | 74046 | 883 |
1495294 | 1495294 | 2021-07-08 | El Paso | Colorado | 8041 | 73908 | 883 |
1492048 | 1492048 | 2021-07-07 | El Paso | Colorado | 8041 | 73813 | 882 |
1488801 | 1488801 | 2021-07-06 | El Paso | Colorado | 8041 | 73725 | 880 |
Advanced export
JSON shape: default, array, newline-delimited
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);