ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Richmond" and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1947107 | 1947107 | 2021-11-24 | Richmond | Georgia | 13245 | 35541 | 731 |
1943856 | 1943856 | 2021-11-23 | Richmond | Georgia | 13245 | 35527 | 729 |
1940606 | 1940606 | 2021-11-22 | Richmond | Georgia | 13245 | 35500 | 729 |
1937356 | 1937356 | 2021-11-21 | Richmond | Georgia | 13245 | 35442 | 726 |
1934106 | 1934106 | 2021-11-20 | Richmond | Georgia | 13245 | 35442 | 726 |
1930854 | 1930854 | 2021-11-19 | Richmond | Georgia | 13245 | 35442 | 726 |
1927604 | 1927604 | 2021-11-18 | Richmond | Georgia | 13245 | 35423 | 725 |
1924354 | 1924354 | 2021-11-17 | Richmond | Georgia | 13245 | 35393 | 722 |
1921105 | 1921105 | 2021-11-16 | Richmond | Georgia | 13245 | 35364 | 721 |
1917855 | 1917855 | 2021-11-15 | Richmond | Georgia | 13245 | 35338 | 721 |
1914605 | 1914605 | 2021-11-14 | Richmond | Georgia | 13245 | 35302 | 721 |
1911355 | 1911355 | 2021-11-13 | Richmond | Georgia | 13245 | 35302 | 721 |
1908106 | 1908106 | 2021-11-12 | Richmond | Georgia | 13245 | 35302 | 721 |
1904857 | 1904857 | 2021-11-11 | Richmond | Georgia | 13245 | 35261 | 715 |
1901607 | 1901607 | 2021-11-10 | Richmond | Georgia | 13245 | 35261 | 715 |
1898357 | 1898357 | 2021-11-09 | Richmond | Georgia | 13245 | 35242 | 711 |
1895107 | 1895107 | 2021-11-08 | Richmond | Georgia | 13245 | 35182 | 709 |
1891857 | 1891857 | 2021-11-07 | Richmond | Georgia | 13245 | 35182 | 709 |
1888607 | 1888607 | 2021-11-06 | Richmond | Georgia | 13245 | 35182 | 709 |
1885357 | 1885357 | 2021-11-05 | Richmond | Georgia | 13245 | 35182 | 709 |
1882108 | 1882108 | 2021-11-04 | Richmond | Georgia | 13245 | 35161 | 705 |
1878859 | 1878859 | 2021-11-03 | Richmond | Georgia | 13245 | 35138 | 704 |
1875610 | 1875610 | 2021-11-02 | Richmond | Georgia | 13245 | 35123 | 700 |
1872361 | 1872361 | 2021-11-01 | Richmond | Georgia | 13245 | 35110 | 697 |
1869112 | 1869112 | 2021-10-31 | Richmond | Georgia | 13245 | 35046 | 695 |
1865863 | 1865863 | 2021-10-30 | Richmond | Georgia | 13245 | 35046 | 695 |
1862614 | 1862614 | 2021-10-29 | Richmond | Georgia | 13245 | 35046 | 695 |
1859365 | 1859365 | 2021-10-28 | Richmond | Georgia | 13245 | 35022 | 692 |
1856116 | 1856116 | 2021-10-27 | Richmond | Georgia | 13245 | 34996 | 692 |
1852867 | 1852867 | 2021-10-26 | Richmond | Georgia | 13245 | 34966 | 689 |
1849618 | 1849618 | 2021-10-25 | Richmond | Georgia | 13245 | 34945 | 687 |
1846368 | 1846368 | 2021-10-24 | Richmond | Georgia | 13245 | 34896 | 682 |
1843118 | 1843118 | 2021-10-23 | Richmond | Georgia | 13245 | 34896 | 682 |
1839868 | 1839868 | 2021-10-22 | Richmond | Georgia | 13245 | 34896 | 682 |
1836619 | 1836619 | 2021-10-21 | Richmond | Georgia | 13245 | 34872 | 676 |
1833370 | 1833370 | 2021-10-20 | Richmond | Georgia | 13245 | 34849 | 672 |
1830121 | 1830121 | 2021-10-19 | Richmond | Georgia | 13245 | 34796 | 671 |
1826872 | 1826872 | 2021-10-18 | Richmond | Georgia | 13245 | 34764 | 665 |
1823623 | 1823623 | 2021-10-17 | Richmond | Georgia | 13245 | 34704 | 658 |
1820374 | 1820374 | 2021-10-16 | Richmond | Georgia | 13245 | 34704 | 658 |
1817125 | 1817125 | 2021-10-15 | Richmond | Georgia | 13245 | 34704 | 658 |
1813877 | 1813877 | 2021-10-14 | Richmond | Georgia | 13245 | 34667 | 649 |
1810628 | 1810628 | 2021-10-13 | Richmond | Georgia | 13245 | 34625 | 644 |
1807379 | 1807379 | 2021-10-12 | Richmond | Georgia | 13245 | 34579 | 642 |
1804128 | 1804128 | 2021-10-11 | Richmond | Georgia | 13245 | 34423 | 637 |
1800879 | 1800879 | 2021-10-10 | Richmond | Georgia | 13245 | 34423 | 637 |
1797630 | 1797630 | 2021-10-09 | Richmond | Georgia | 13245 | 34423 | 637 |
1794381 | 1794381 | 2021-10-08 | Richmond | Georgia | 13245 | 34423 | 637 |
1791133 | 1791133 | 2021-10-07 | Richmond | Georgia | 13245 | 34380 | 635 |
1787884 | 1787884 | 2021-10-06 | Richmond | Georgia | 13245 | 34254 | 632 |
1784635 | 1784635 | 2021-10-05 | Richmond | Georgia | 13245 | 34238 | 630 |
1781386 | 1781386 | 2021-10-04 | Richmond | Georgia | 13245 | 34164 | 625 |
1778136 | 1778136 | 2021-10-03 | Richmond | Georgia | 13245 | 34047 | 619 |
1774886 | 1774886 | 2021-10-02 | Richmond | Georgia | 13245 | 34047 | 619 |
1771636 | 1771636 | 2021-10-01 | Richmond | Georgia | 13245 | 34047 | 619 |
1768387 | 1768387 | 2021-09-30 | Richmond | Georgia | 13245 | 33971 | 617 |
1765138 | 1765138 | 2021-09-29 | Richmond | Georgia | 13245 | 33885 | 614 |
1761889 | 1761889 | 2021-09-28 | Richmond | Georgia | 13245 | 33782 | 613 |
1758641 | 1758641 | 2021-09-27 | Richmond | Georgia | 13245 | 33700 | 607 |
1755393 | 1755393 | 2021-09-26 | Richmond | Georgia | 13245 | 33474 | 608 |
1752145 | 1752145 | 2021-09-25 | Richmond | Georgia | 13245 | 33474 | 608 |
1748896 | 1748896 | 2021-09-24 | Richmond | Georgia | 13245 | 33474 | 608 |
1745646 | 1745646 | 2021-09-23 | Richmond | Georgia | 13245 | 33361 | 607 |
1742397 | 1742397 | 2021-09-22 | Richmond | Georgia | 13245 | 33249 | 606 |
1739148 | 1739148 | 2021-09-21 | Richmond | Georgia | 13245 | 33116 | 600 |
1735899 | 1735899 | 2021-09-20 | Richmond | Georgia | 13245 | 33025 | 595 |
1732649 | 1732649 | 2021-09-19 | Richmond | Georgia | 13245 | 32748 | 592 |
1729399 | 1729399 | 2021-09-18 | Richmond | Georgia | 13245 | 32748 | 592 |
1726149 | 1726149 | 2021-09-17 | Richmond | Georgia | 13245 | 32748 | 592 |
1722900 | 1722900 | 2021-09-16 | Richmond | Georgia | 13245 | 32610 | 590 |
1719651 | 1719651 | 2021-09-15 | Richmond | Georgia | 13245 | 32468 | 586 |
1716403 | 1716403 | 2021-09-14 | Richmond | Georgia | 13245 | 32307 | 577 |
1713157 | 1713157 | 2021-09-13 | Richmond | Georgia | 13245 | 32189 | 568 |
1709910 | 1709910 | 2021-09-12 | Richmond | Georgia | 13245 | 31817 | 567 |
1706663 | 1706663 | 2021-09-11 | Richmond | Georgia | 13245 | 31817 | 567 |
1703415 | 1703415 | 2021-09-10 | Richmond | Georgia | 13245 | 31817 | 567 |
1700165 | 1700165 | 2021-09-09 | Richmond | Georgia | 13245 | 31503 | 557 |
1696916 | 1696916 | 2021-09-08 | Richmond | Georgia | 13245 | 31328 | 556 |
1693668 | 1693668 | 2021-09-07 | Richmond | Georgia | 13245 | 31110 | 556 |
1690419 | 1690419 | 2021-09-06 | Richmond | Georgia | 13245 | 30468 | 555 |
1687169 | 1687169 | 2021-09-05 | Richmond | Georgia | 13245 | 30468 | 555 |
1683919 | 1683919 | 2021-09-04 | Richmond | Georgia | 13245 | 30468 | 555 |
1680668 | 1680668 | 2021-09-03 | Richmond | Georgia | 13245 | 30468 | 555 |
1677420 | 1677420 | 2021-09-02 | Richmond | Georgia | 13245 | 30199 | 553 |
1674173 | 1674173 | 2021-09-01 | Richmond | Georgia | 13245 | 29983 | 552 |
1670925 | 1670925 | 2021-08-31 | Richmond | Georgia | 13245 | 29765 | 549 |
1667678 | 1667678 | 2021-08-30 | Richmond | Georgia | 13245 | 29616 | 549 |
1664431 | 1664431 | 2021-08-29 | Richmond | Georgia | 13245 | 29074 | 549 |
1661183 | 1661183 | 2021-08-28 | Richmond | Georgia | 13245 | 29074 | 549 |
1657935 | 1657935 | 2021-08-27 | Richmond | Georgia | 13245 | 29074 | 549 |
1654687 | 1654687 | 2021-08-26 | Richmond | Georgia | 13245 | 28879 | 548 |
1651440 | 1651440 | 2021-08-25 | Richmond | Georgia | 13245 | 28640 | 547 |
1648191 | 1648191 | 2021-08-24 | Richmond | Georgia | 13245 | 28464 | 545 |
1644943 | 1644943 | 2021-08-23 | Richmond | Georgia | 13245 | 28288 | 545 |
1641693 | 1641693 | 2021-08-22 | Richmond | Georgia | 13245 | 27925 | 545 |
1638443 | 1638443 | 2021-08-21 | Richmond | Georgia | 13245 | 27925 | 545 |
1635193 | 1635193 | 2021-08-20 | Richmond | Georgia | 13245 | 27925 | 545 |
1631944 | 1631944 | 2021-08-19 | Richmond | Georgia | 13245 | 27750 | 544 |
1628697 | 1628697 | 2021-08-18 | Richmond | Georgia | 13245 | 27597 | 544 |
1625450 | 1625450 | 2021-08-17 | Richmond | Georgia | 13245 | 27459 | 544 |
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);