ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
800 rows where county = "Clark" and state = "Nevada" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1818381 | 1818381 | 2021-10-15 | Clark | Nevada | 32003 | 334318 | 5835 |
1815132 | 1815132 | 2021-10-14 | Clark | Nevada | 32003 | 334036 | 5830 |
1811884 | 1811884 | 2021-10-13 | Clark | Nevada | 32003 | 333608 | 5801 |
1808635 | 1808635 | 2021-10-12 | Clark | Nevada | 32003 | 333186 | 5781 |
1805384 | 1805384 | 2021-10-11 | Clark | Nevada | 32003 | 332667 | 5765 |
1802135 | 1802135 | 2021-10-10 | Clark | Nevada | 32003 | 331430 | 5743 |
1798886 | 1798886 | 2021-10-09 | Clark | Nevada | 32003 | 331430 | 5743 |
1795637 | 1795637 | 2021-10-08 | Clark | Nevada | 32003 | 331430 | 5743 |
1792388 | 1792388 | 2021-10-07 | Clark | Nevada | 32003 | 330961 | 5739 |
1789139 | 1789139 | 2021-10-06 | Clark | Nevada | 32003 | 330432 | 5714 |
1785891 | 1785891 | 2021-10-05 | Clark | Nevada | 32003 | 322524 | 5701 |
1782642 | 1782642 | 2021-10-04 | Clark | Nevada | 32003 | 322066 | 5677 |
1779392 | 1779392 | 2021-10-03 | Clark | Nevada | 32003 | 320777 | 5660 |
1776142 | 1776142 | 2021-10-02 | Clark | Nevada | 32003 | 320777 | 5660 |
1772892 | 1772892 | 2021-10-01 | Clark | Nevada | 32003 | 320777 | 5660 |
1769643 | 1769643 | 2021-09-30 | Clark | Nevada | 32003 | 320232 | 5651 |
1766394 | 1766394 | 2021-09-29 | Clark | Nevada | 32003 | 319545 | 5623 |
1763145 | 1763145 | 2021-09-28 | Clark | Nevada | 32003 | 319081 | 5594 |
1759896 | 1759896 | 2021-09-27 | Clark | Nevada | 32003 | 318665 | 5579 |
1756648 | 1756648 | 2021-09-26 | Clark | Nevada | 32003 | 317520 | 5559 |
1753400 | 1753400 | 2021-09-25 | Clark | Nevada | 32003 | 317520 | 5559 |
1750152 | 1750152 | 2021-09-24 | Clark | Nevada | 32003 | 317520 | 5559 |
1746902 | 1746902 | 2021-09-23 | Clark | Nevada | 32003 | 316956 | 5545 |
1743653 | 1743653 | 2021-09-22 | Clark | Nevada | 32003 | 316397 | 5515 |
1740404 | 1740404 | 2021-09-21 | Clark | Nevada | 32003 | 316045 | 5496 |
1737155 | 1737155 | 2021-09-20 | Clark | Nevada | 32003 | 315569 | 5477 |
1733905 | 1733905 | 2021-09-19 | Clark | Nevada | 32003 | 314282 | 5446 |
1730655 | 1730655 | 2021-09-18 | Clark | Nevada | 32003 | 314282 | 5446 |
1727405 | 1727405 | 2021-09-17 | Clark | Nevada | 32003 | 314282 | 5446 |
1724156 | 1724156 | 2021-09-16 | Clark | Nevada | 32003 | 313601 | 5429 |
1720907 | 1720907 | 2021-09-15 | Clark | Nevada | 32003 | 312821 | 5402 |
1717659 | 1717659 | 2021-09-14 | Clark | Nevada | 32003 | 312334 | 5383 |
1714411 | 1714411 | 2021-09-13 | Clark | Nevada | 32003 | 311915 | 5358 |
1711165 | 1711165 | 2021-09-12 | Clark | Nevada | 32003 | 309977 | 5339 |
1707918 | 1707918 | 2021-09-11 | Clark | Nevada | 32003 | 309977 | 5339 |
1704671 | 1704671 | 2021-09-10 | Clark | Nevada | 32003 | 309977 | 5339 |
1701421 | 1701421 | 2021-09-09 | Clark | Nevada | 32003 | 309175 | 5325 |
1698172 | 1698172 | 2021-09-08 | Clark | Nevada | 32003 | 308741 | 5303 |
1694924 | 1694924 | 2021-09-07 | Clark | Nevada | 32003 | 308228 | 5278 |
1691675 | 1691675 | 2021-09-06 | Clark | Nevada | 32003 | 306149 | 5265 |
1688425 | 1688425 | 2021-09-05 | Clark | Nevada | 32003 | 306149 | 5265 |
1685175 | 1685175 | 2021-09-04 | Clark | Nevada | 32003 | 306149 | 5265 |
1681924 | 1681924 | 2021-09-03 | Clark | Nevada | 32003 | 306149 | 5265 |
1678676 | 1678676 | 2021-09-02 | Clark | Nevada | 32003 | 305401 | 5255 |
1675428 | 1675428 | 2021-09-01 | Clark | Nevada | 32003 | 304856 | 5237 |
1672180 | 1672180 | 2021-08-31 | Clark | Nevada | 32003 | 304102 | 5218 |
1668933 | 1668933 | 2021-08-30 | Clark | Nevada | 32003 | 303487 | 5198 |
1665686 | 1665686 | 2021-08-29 | Clark | Nevada | 32003 | 301709 | 5160 |
1662438 | 1662438 | 2021-08-28 | Clark | Nevada | 32003 | 301709 | 5160 |
1659190 | 1659190 | 2021-08-27 | Clark | Nevada | 32003 | 301709 | 5160 |
1655941 | 1655941 | 2021-08-26 | Clark | Nevada | 32003 | 301011 | 5127 |
1652694 | 1652694 | 2021-08-25 | Clark | Nevada | 32003 | 300358 | 5108 |
1649446 | 1649446 | 2021-08-24 | Clark | Nevada | 32003 | 299565 | 5090 |
1646197 | 1646197 | 2021-08-23 | Clark | Nevada | 32003 | 298914 | 5052 |
1642948 | 1642948 | 2021-08-22 | Clark | Nevada | 32003 | 296722 | 5032 |
1639698 | 1639698 | 2021-08-21 | Clark | Nevada | 32003 | 296722 | 5032 |
1636448 | 1636448 | 2021-08-20 | Clark | Nevada | 32003 | 296722 | 5032 |
1633198 | 1633198 | 2021-08-19 | Clark | Nevada | 32003 | 296022 | 5014 |
1629951 | 1629951 | 2021-08-18 | Clark | Nevada | 32003 | 295104 | 5005 |
1626704 | 1626704 | 2021-08-17 | Clark | Nevada | 32003 | 294015 | 4988 |
1623457 | 1623457 | 2021-08-16 | Clark | Nevada | 32003 | 293466 | 4962 |
1620210 | 1620210 | 2021-08-15 | Clark | Nevada | 32003 | 291502 | 4936 |
1616962 | 1616962 | 2021-08-14 | Clark | Nevada | 32003 | 291502 | 4936 |
1613714 | 1613714 | 2021-08-13 | Clark | Nevada | 32003 | 291502 | 4936 |
1610465 | 1610465 | 2021-08-12 | Clark | Nevada | 32003 | 290632 | 4898 |
1607217 | 1607217 | 2021-08-11 | Clark | Nevada | 32003 | 289746 | 4875 |
1603968 | 1603968 | 2021-08-10 | Clark | Nevada | 32003 | 289114 | 4860 |
1600719 | 1600719 | 2021-08-09 | Clark | Nevada | 32003 | 288381 | 4828 |
1597471 | 1597471 | 2021-08-08 | Clark | Nevada | 32003 | 285938 | 4794 |
1594222 | 1594222 | 2021-08-07 | Clark | Nevada | 32003 | 285938 | 4794 |
1590973 | 1590973 | 2021-08-06 | Clark | Nevada | 32003 | 285938 | 4794 |
1587724 | 1587724 | 2021-08-05 | Clark | Nevada | 32003 | 284982 | 4768 |
1584473 | 1584473 | 2021-08-04 | Clark | Nevada | 32003 | 284046 | 4744 |
1581224 | 1581224 | 2021-08-03 | Clark | Nevada | 32003 | 283321 | 4721 |
1577975 | 1577975 | 2021-08-02 | Clark | Nevada | 32003 | 282357 | 4711 |
1574727 | 1574727 | 2021-08-01 | Clark | Nevada | 32003 | 280201 | 4705 |
1571479 | 1571479 | 2021-07-31 | Clark | Nevada | 32003 | 280201 | 4705 |
1568231 | 1568231 | 2021-07-30 | Clark | Nevada | 32003 | 280201 | 4705 |
1564983 | 1564983 | 2021-07-29 | Clark | Nevada | 32003 | 279142 | 4693 |
1561735 | 1561735 | 2021-07-28 | Clark | Nevada | 32003 | 277982 | 4669 |
1558487 | 1558487 | 2021-07-27 | Clark | Nevada | 32003 | 276934 | 4653 |
1555240 | 1555240 | 2021-07-26 | Clark | Nevada | 32003 | 275983 | 4636 |
1551993 | 1551993 | 2021-07-25 | Clark | Nevada | 32003 | 273860 | 4616 |
1548746 | 1548746 | 2021-07-24 | Clark | Nevada | 32003 | 273860 | 4616 |
1545499 | 1545499 | 2021-07-23 | Clark | Nevada | 32003 | 273860 | 4616 |
1542251 | 1542251 | 2021-07-22 | Clark | Nevada | 32003 | 272979 | 4599 |
1539004 | 1539004 | 2021-07-21 | Clark | Nevada | 32003 | 272152 | 4592 |
1535757 | 1535757 | 2021-07-20 | Clark | Nevada | 32003 | 271310 | 4565 |
1532509 | 1532509 | 2021-07-19 | Clark | Nevada | 32003 | 270421 | 4566 |
1529262 | 1529262 | 2021-07-18 | Clark | Nevada | 32003 | 268514 | 4563 |
1526015 | 1526015 | 2021-07-17 | Clark | Nevada | 32003 | 268514 | 4563 |
1522768 | 1522768 | 2021-07-16 | Clark | Nevada | 32003 | 268514 | 4563 |
1519519 | 1519519 | 2021-07-15 | Clark | Nevada | 32003 | 267734 | 4558 |
1516272 | 1516272 | 2021-07-14 | Clark | Nevada | 32003 | 266846 | 4545 |
1513025 | 1513025 | 2021-07-13 | Clark | Nevada | 32003 | 266224 | 4539 |
1509778 | 1509778 | 2021-07-12 | Clark | Nevada | 32003 | 265462 | 4538 |
1506532 | 1506532 | 2021-07-11 | Clark | Nevada | 32003 | 263915 | 4530 |
1503286 | 1503286 | 2021-07-10 | Clark | Nevada | 32003 | 263915 | 4530 |
1500040 | 1500040 | 2021-07-09 | Clark | Nevada | 32003 | 263915 | 4530 |
1496794 | 1496794 | 2021-07-08 | Clark | Nevada | 32003 | 263144 | 4517 |
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);