ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 8014 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1810369 | 1810369 | 2021-10-13 | Broomfield | Colorado | 8014 | 6437 | 80 |
1807120 | 1807120 | 2021-10-12 | Broomfield | Colorado | 8014 | 6397 | 79 |
1803869 | 1803869 | 2021-10-11 | Broomfield | Colorado | 8014 | 6380 | 79 |
1800620 | 1800620 | 2021-10-10 | Broomfield | Colorado | 8014 | 6335 | 79 |
1797371 | 1797371 | 2021-10-09 | Broomfield | Colorado | 8014 | 6335 | 79 |
1794122 | 1794122 | 2021-10-08 | Broomfield | Colorado | 8014 | 6335 | 79 |
1790874 | 1790874 | 2021-10-07 | Broomfield | Colorado | 8014 | 6296 | 79 |
1787625 | 1787625 | 2021-10-06 | Broomfield | Colorado | 8014 | 6268 | 79 |
1784376 | 1784376 | 2021-10-05 | Broomfield | Colorado | 8014 | 6258 | 78 |
1781127 | 1781127 | 2021-10-04 | Broomfield | Colorado | 8014 | 6240 | 78 |
1777877 | 1777877 | 2021-10-03 | Broomfield | Colorado | 8014 | 6198 | 78 |
1774627 | 1774627 | 2021-10-02 | Broomfield | Colorado | 8014 | 6198 | 78 |
1771377 | 1771377 | 2021-10-01 | Broomfield | Colorado | 8014 | 6198 | 78 |
1768128 | 1768128 | 2021-09-30 | Broomfield | Colorado | 8014 | 6174 | 78 |
1764879 | 1764879 | 2021-09-29 | Broomfield | Colorado | 8014 | 6152 | 78 |
1761630 | 1761630 | 2021-09-28 | Broomfield | Colorado | 8014 | 6142 | 78 |
1758382 | 1758382 | 2021-09-27 | Broomfield | Colorado | 8014 | 6123 | 78 |
1755134 | 1755134 | 2021-09-26 | Broomfield | Colorado | 8014 | 6076 | 78 |
1751886 | 1751886 | 2021-09-25 | Broomfield | Colorado | 8014 | 6076 | 78 |
1748637 | 1748637 | 2021-09-24 | Broomfield | Colorado | 8014 | 6076 | 78 |
1745387 | 1745387 | 2021-09-23 | Broomfield | Colorado | 8014 | 6064 | 78 |
1742138 | 1742138 | 2021-09-22 | Broomfield | Colorado | 8014 | 6046 | 78 |
1738889 | 1738889 | 2021-09-21 | Broomfield | Colorado | 8014 | 6032 | 78 |
1735640 | 1735640 | 2021-09-20 | Broomfield | Colorado | 8014 | 6018 | 78 |
1732390 | 1732390 | 2021-09-19 | Broomfield | Colorado | 8014 | 5952 | 78 |
1729140 | 1729140 | 2021-09-18 | Broomfield | Colorado | 8014 | 5952 | 78 |
1725890 | 1725890 | 2021-09-17 | Broomfield | Colorado | 8014 | 5952 | 78 |
1722641 | 1722641 | 2021-09-16 | Broomfield | Colorado | 8014 | 5934 | 78 |
1719392 | 1719392 | 2021-09-15 | Broomfield | Colorado | 8014 | 5904 | 78 |
1716144 | 1716144 | 2021-09-14 | Broomfield | Colorado | 8014 | 5883 | 77 |
1712898 | 1712898 | 2021-09-13 | Broomfield | Colorado | 8014 | 5855 | 77 |
1709651 | 1709651 | 2021-09-12 | Broomfield | Colorado | 8014 | 5797 | 77 |
1706404 | 1706404 | 2021-09-11 | Broomfield | Colorado | 8014 | 5797 | 77 |
1703156 | 1703156 | 2021-09-10 | Broomfield | Colorado | 8014 | 5797 | 77 |
1699906 | 1699906 | 2021-09-09 | Broomfield | Colorado | 8014 | 5783 | 77 |
1696657 | 1696657 | 2021-09-08 | Broomfield | Colorado | 8014 | 5768 | 77 |
1693409 | 1693409 | 2021-09-07 | Broomfield | Colorado | 8014 | 5749 | 77 |
1690160 | 1690160 | 2021-09-06 | Broomfield | Colorado | 8014 | 5739 | 77 |
1686910 | 1686910 | 2021-09-05 | Broomfield | Colorado | 8014 | 5681 | 77 |
1683660 | 1683660 | 2021-09-04 | Broomfield | Colorado | 8014 | 5681 | 77 |
1680409 | 1680409 | 2021-09-03 | Broomfield | Colorado | 8014 | 5681 | 77 |
1677161 | 1677161 | 2021-09-02 | Broomfield | Colorado | 8014 | 5664 | 77 |
1673914 | 1673914 | 2021-09-01 | Broomfield | Colorado | 8014 | 5646 | 77 |
1670666 | 1670666 | 2021-08-31 | Broomfield | Colorado | 8014 | 5619 | 76 |
1667419 | 1667419 | 2021-08-30 | Broomfield | Colorado | 8014 | 5595 | 76 |
1664172 | 1664172 | 2021-08-29 | Broomfield | Colorado | 8014 | 5564 | 76 |
1660924 | 1660924 | 2021-08-28 | Broomfield | Colorado | 8014 | 5564 | 76 |
1657676 | 1657676 | 2021-08-27 | Broomfield | Colorado | 8014 | 5564 | 76 |
1654428 | 1654428 | 2021-08-26 | Broomfield | Colorado | 8014 | 5550 | 76 |
1651181 | 1651181 | 2021-08-25 | Broomfield | Colorado | 8014 | 5534 | 77 |
1647932 | 1647932 | 2021-08-24 | Broomfield | Colorado | 8014 | 5515 | 77 |
1644684 | 1644684 | 2021-08-23 | Broomfield | Colorado | 8014 | 5509 | 77 |
1641434 | 1641434 | 2021-08-22 | Broomfield | Colorado | 8014 | 5455 | 77 |
1638184 | 1638184 | 2021-08-21 | Broomfield | Colorado | 8014 | 5455 | 77 |
1634934 | 1634934 | 2021-08-20 | Broomfield | Colorado | 8014 | 5455 | 77 |
1631685 | 1631685 | 2021-08-19 | Broomfield | Colorado | 8014 | 5440 | 77 |
1628438 | 1628438 | 2021-08-18 | Broomfield | Colorado | 8014 | 5419 | 77 |
1625191 | 1625191 | 2021-08-17 | Broomfield | Colorado | 8014 | 5399 | 77 |
1621944 | 1621944 | 2021-08-16 | Broomfield | Colorado | 8014 | 5385 | 77 |
1618697 | 1618697 | 2021-08-15 | Broomfield | Colorado | 8014 | 5360 | 77 |
1615449 | 1615449 | 2021-08-14 | Broomfield | Colorado | 8014 | 5360 | 77 |
1612200 | 1612200 | 2021-08-13 | Broomfield | Colorado | 8014 | 5360 | 77 |
1608952 | 1608952 | 2021-08-12 | Broomfield | Colorado | 8014 | 5340 | 77 |
1605703 | 1605703 | 2021-08-11 | Broomfield | Colorado | 8014 | 5306 | 77 |
1602454 | 1602454 | 2021-08-10 | Broomfield | Colorado | 8014 | 5298 | 77 |
1599205 | 1599205 | 2021-08-09 | Broomfield | Colorado | 8014 | 5291 | 77 |
1595956 | 1595956 | 2021-08-08 | Broomfield | Colorado | 8014 | 5259 | 77 |
1592707 | 1592707 | 2021-08-07 | Broomfield | Colorado | 8014 | 5259 | 77 |
1589458 | 1589458 | 2021-08-06 | Broomfield | Colorado | 8014 | 5259 | 77 |
1586209 | 1586209 | 2021-08-05 | Broomfield | Colorado | 8014 | 5247 | 77 |
1582959 | 1582959 | 2021-08-04 | Broomfield | Colorado | 8014 | 5234 | 77 |
1579709 | 1579709 | 2021-08-03 | Broomfield | Colorado | 8014 | 5219 | 77 |
1576461 | 1576461 | 2021-08-02 | Broomfield | Colorado | 8014 | 5192 | 77 |
1573213 | 1573213 | 2021-08-01 | Broomfield | Colorado | 8014 | 5165 | 77 |
1569965 | 1569965 | 2021-07-31 | Broomfield | Colorado | 8014 | 5165 | 77 |
1566717 | 1566717 | 2021-07-30 | Broomfield | Colorado | 8014 | 5165 | 77 |
1563469 | 1563469 | 2021-07-29 | Broomfield | Colorado | 8014 | 5152 | 77 |
1560221 | 1560221 | 2021-07-28 | Broomfield | Colorado | 8014 | 5140 | 77 |
1556974 | 1556974 | 2021-07-27 | Broomfield | Colorado | 8014 | 5116 | 77 |
1553727 | 1553727 | 2021-07-26 | Broomfield | Colorado | 8014 | 5116 | 77 |
1550480 | 1550480 | 2021-07-25 | Broomfield | Colorado | 8014 | 5096 | 76 |
1547233 | 1547233 | 2021-07-24 | Broomfield | Colorado | 8014 | 5096 | 76 |
1543986 | 1543986 | 2021-07-23 | Broomfield | Colorado | 8014 | 5096 | 76 |
1540738 | 1540738 | 2021-07-22 | Broomfield | Colorado | 8014 | 5089 | 76 |
1537491 | 1537491 | 2021-07-21 | Broomfield | Colorado | 8014 | 5080 | 76 |
1534243 | 1534243 | 2021-07-20 | Broomfield | Colorado | 8014 | 5071 | 76 |
1530996 | 1530996 | 2021-07-19 | Broomfield | Colorado | 8014 | 5071 | 76 |
1527749 | 1527749 | 2021-07-18 | Broomfield | Colorado | 8014 | 5065 | 76 |
1524502 | 1524502 | 2021-07-17 | Broomfield | Colorado | 8014 | 5065 | 76 |
1521254 | 1521254 | 2021-07-16 | Broomfield | Colorado | 8014 | 5065 | 76 |
1518006 | 1518006 | 2021-07-15 | Broomfield | Colorado | 8014 | 5059 | 76 |
1514759 | 1514759 | 2021-07-14 | Broomfield | Colorado | 8014 | 5057 | 76 |
1511513 | 1511513 | 2021-07-13 | Broomfield | Colorado | 8014 | 5044 | 76 |
1508266 | 1508266 | 2021-07-12 | Broomfield | Colorado | 8014 | 5041 | 76 |
1505020 | 1505020 | 2021-07-11 | Broomfield | Colorado | 8014 | 5035 | 76 |
1501774 | 1501774 | 2021-07-10 | Broomfield | Colorado | 8014 | 5031 | 76 |
1498528 | 1498528 | 2021-07-09 | Broomfield | Colorado | 8014 | 5029 | 76 |
1495281 | 1495281 | 2021-07-08 | Broomfield | Colorado | 8014 | 5022 | 76 |
1492035 | 1492035 | 2021-07-07 | Broomfield | Colorado | 8014 | 5020 | 76 |
1488788 | 1488788 | 2021-07-06 | Broomfield | Colorado | 8014 | 5018 | 76 |
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);