ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Clayton" and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2109550 | 2109550 | 2022-01-13 | Clayton | Georgia | 13063 | 53911 | 811 |
2106299 | 2106299 | 2022-01-12 | Clayton | Georgia | 13063 | 53183 | 808 |
2103048 | 2103048 | 2022-01-11 | Clayton | Georgia | 13063 | 52856 | 807 |
2099797 | 2099797 | 2022-01-10 | Clayton | Georgia | 13063 | 52494 | 804 |
2096546 | 2096546 | 2022-01-09 | Clayton | Georgia | 13063 | 49676 | 800 |
2093294 | 2093294 | 2022-01-08 | Clayton | Georgia | 13063 | 49676 | 800 |
2090042 | 2090042 | 2022-01-07 | Clayton | Georgia | 13063 | 49676 | 800 |
2086791 | 2086791 | 2022-01-06 | Clayton | Georgia | 13063 | 49676 | 800 |
2083539 | 2083539 | 2022-01-05 | Clayton | Georgia | 13063 | 49676 | 800 |
2080287 | 2080287 | 2022-01-04 | Clayton | Georgia | 13063 | 48843 | 799 |
2077035 | 2077035 | 2022-01-03 | Clayton | Georgia | 13063 | 46999 | 797 |
2073784 | 2073784 | 2022-01-02 | Clayton | Georgia | 13063 | 46999 | 797 |
2070533 | 2070533 | 2022-01-01 | Clayton | Georgia | 13063 | 46999 | 797 |
2067282 | 2067282 | 2021-12-31 | Clayton | Georgia | 13063 | 46999 | 797 |
2064031 | 2064031 | 2021-12-30 | Clayton | Georgia | 13063 | 46284 | 795 |
2060781 | 2060781 | 2021-12-29 | Clayton | Georgia | 13063 | 45308 | 794 |
2057532 | 2057532 | 2021-12-28 | Clayton | Georgia | 13063 | 44625 | 792 |
2054283 | 2054283 | 2021-12-27 | Clayton | Georgia | 13063 | 44061 | 790 |
2051033 | 2051033 | 2021-12-26 | Clayton | Georgia | 13063 | 42911 | 786 |
2047783 | 2047783 | 2021-12-25 | Clayton | Georgia | 13063 | 42911 | 786 |
2044533 | 2044533 | 2021-12-24 | Clayton | Georgia | 13063 | 42911 | 786 |
2041284 | 2041284 | 2021-12-23 | Clayton | Georgia | 13063 | 42582 | 785 |
2038034 | 2038034 | 2021-12-22 | Clayton | Georgia | 13063 | 42195 | 784 |
2034784 | 2034784 | 2021-12-21 | Clayton | Georgia | 13063 | 41872 | 783 |
2031534 | 2031534 | 2021-12-20 | Clayton | Georgia | 13063 | 41623 | 782 |
2028283 | 2028283 | 2021-12-19 | Clayton | Georgia | 13063 | 41228 | 782 |
2025032 | 2025032 | 2021-12-18 | Clayton | Georgia | 13063 | 41228 | 782 |
2021781 | 2021781 | 2021-12-17 | Clayton | Georgia | 13063 | 41228 | 782 |
2018530 | 2018530 | 2021-12-16 | Clayton | Georgia | 13063 | 41075 | 781 |
2015280 | 2015280 | 2021-12-15 | Clayton | Georgia | 13063 | 40981 | 781 |
2012029 | 2012029 | 2021-12-14 | Clayton | Georgia | 13063 | 40853 | 780 |
2008778 | 2008778 | 2021-12-13 | Clayton | Georgia | 13063 | 40783 | 780 |
2005527 | 2005527 | 2021-12-12 | Clayton | Georgia | 13063 | 40695 | 779 |
2002276 | 2002276 | 2021-12-11 | Clayton | Georgia | 13063 | 40695 | 779 |
1999026 | 1999026 | 2021-12-10 | Clayton | Georgia | 13063 | 40695 | 779 |
1995775 | 1995775 | 2021-12-09 | Clayton | Georgia | 13063 | 40641 | 778 |
1992524 | 1992524 | 2021-12-08 | Clayton | Georgia | 13063 | 40578 | 778 |
1989273 | 1989273 | 2021-12-07 | Clayton | Georgia | 13063 | 40512 | 777 |
1986023 | 1986023 | 2021-12-06 | Clayton | Georgia | 13063 | 40433 | 776 |
1982773 | 1982773 | 2021-12-05 | Clayton | Georgia | 13063 | 40319 | 774 |
1979523 | 1979523 | 2021-12-04 | Clayton | Georgia | 13063 | 40319 | 774 |
1976273 | 1976273 | 2021-12-03 | Clayton | Georgia | 13063 | 40319 | 774 |
1973024 | 1973024 | 2021-12-02 | Clayton | Georgia | 13063 | 40270 | 774 |
1969774 | 1969774 | 2021-12-01 | Clayton | Georgia | 13063 | 40219 | 772 |
1966524 | 1966524 | 2021-11-30 | Clayton | Georgia | 13063 | 40152 | 770 |
1963272 | 1963272 | 2021-11-29 | Clayton | Georgia | 13063 | 40119 | 770 |
1960021 | 1960021 | 2021-11-28 | Clayton | Georgia | 13063 | 40007 | 767 |
1956770 | 1956770 | 2021-11-27 | Clayton | Georgia | 13063 | 40007 | 767 |
1953519 | 1953519 | 2021-11-26 | Clayton | Georgia | 13063 | 40007 | 767 |
1950268 | 1950268 | 2021-11-25 | Clayton | Georgia | 13063 | 40007 | 767 |
1947017 | 1947017 | 2021-11-24 | Clayton | Georgia | 13063 | 40007 | 767 |
1943766 | 1943766 | 2021-11-23 | Clayton | Georgia | 13063 | 39984 | 765 |
1940516 | 1940516 | 2021-11-22 | Clayton | Georgia | 13063 | 39961 | 765 |
1937266 | 1937266 | 2021-11-21 | Clayton | Georgia | 13063 | 39914 | 763 |
1934016 | 1934016 | 2021-11-20 | Clayton | Georgia | 13063 | 39914 | 763 |
1930764 | 1930764 | 2021-11-19 | Clayton | Georgia | 13063 | 39914 | 763 |
1927514 | 1927514 | 2021-11-18 | Clayton | Georgia | 13063 | 39887 | 759 |
1924264 | 1924264 | 2021-11-17 | Clayton | Georgia | 13063 | 39860 | 758 |
1921015 | 1921015 | 2021-11-16 | Clayton | Georgia | 13063 | 39839 | 753 |
1917765 | 1917765 | 2021-11-15 | Clayton | Georgia | 13063 | 39809 | 753 |
1914515 | 1914515 | 2021-11-14 | Clayton | Georgia | 13063 | 39757 | 753 |
1911265 | 1911265 | 2021-11-13 | Clayton | Georgia | 13063 | 39757 | 753 |
1908016 | 1908016 | 2021-11-12 | Clayton | Georgia | 13063 | 39757 | 753 |
1904767 | 1904767 | 2021-11-11 | Clayton | Georgia | 13063 | 39675 | 744 |
1901517 | 1901517 | 2021-11-10 | Clayton | Georgia | 13063 | 39675 | 744 |
1898267 | 1898267 | 2021-11-09 | Clayton | Georgia | 13063 | 39654 | 743 |
1895017 | 1895017 | 2021-11-08 | Clayton | Georgia | 13063 | 39568 | 742 |
1891767 | 1891767 | 2021-11-07 | Clayton | Georgia | 13063 | 39566 | 742 |
1888517 | 1888517 | 2021-11-06 | Clayton | Georgia | 13063 | 39566 | 742 |
1885267 | 1885267 | 2021-11-05 | Clayton | Georgia | 13063 | 39566 | 742 |
1882018 | 1882018 | 2021-11-04 | Clayton | Georgia | 13063 | 39505 | 739 |
1878769 | 1878769 | 2021-11-03 | Clayton | Georgia | 13063 | 39474 | 733 |
1875520 | 1875520 | 2021-11-02 | Clayton | Georgia | 13063 | 39441 | 728 |
1872271 | 1872271 | 2021-11-01 | Clayton | Georgia | 13063 | 39403 | 727 |
1869022 | 1869022 | 2021-10-31 | Clayton | Georgia | 13063 | 39321 | 722 |
1865773 | 1865773 | 2021-10-30 | Clayton | Georgia | 13063 | 39321 | 722 |
1862524 | 1862524 | 2021-10-29 | Clayton | Georgia | 13063 | 39321 | 722 |
1859275 | 1859275 | 2021-10-28 | Clayton | Georgia | 13063 | 39291 | 719 |
1856026 | 1856026 | 2021-10-27 | Clayton | Georgia | 13063 | 39231 | 716 |
1852777 | 1852777 | 2021-10-26 | Clayton | Georgia | 13063 | 39198 | 708 |
1849528 | 1849528 | 2021-10-25 | Clayton | Georgia | 13063 | 39167 | 707 |
1846278 | 1846278 | 2021-10-24 | Clayton | Georgia | 13063 | 39088 | 705 |
1843028 | 1843028 | 2021-10-23 | Clayton | Georgia | 13063 | 39088 | 705 |
1839778 | 1839778 | 2021-10-22 | Clayton | Georgia | 13063 | 39088 | 705 |
1836529 | 1836529 | 2021-10-21 | Clayton | Georgia | 13063 | 39054 | 700 |
1833280 | 1833280 | 2021-10-20 | Clayton | Georgia | 13063 | 39024 | 694 |
1830031 | 1830031 | 2021-10-19 | Clayton | Georgia | 13063 | 38965 | 692 |
1826782 | 1826782 | 2021-10-18 | Clayton | Georgia | 13063 | 38929 | 691 |
1823533 | 1823533 | 2021-10-17 | Clayton | Georgia | 13063 | 38855 | 688 |
1820284 | 1820284 | 2021-10-16 | Clayton | Georgia | 13063 | 38855 | 688 |
1817035 | 1817035 | 2021-10-15 | Clayton | Georgia | 13063 | 38855 | 688 |
1813787 | 1813787 | 2021-10-14 | Clayton | Georgia | 13063 | 38789 | 681 |
1810538 | 1810538 | 2021-10-13 | Clayton | Georgia | 13063 | 38740 | 680 |
1807289 | 1807289 | 2021-10-12 | Clayton | Georgia | 13063 | 38688 | 678 |
1804038 | 1804038 | 2021-10-11 | Clayton | Georgia | 13063 | 38479 | 671 |
1800789 | 1800789 | 2021-10-10 | Clayton | Georgia | 13063 | 38479 | 671 |
1797540 | 1797540 | 2021-10-09 | Clayton | Georgia | 13063 | 38479 | 671 |
1794291 | 1794291 | 2021-10-08 | Clayton | Georgia | 13063 | 38479 | 671 |
1791043 | 1791043 | 2021-10-07 | Clayton | Georgia | 13063 | 38411 | 670 |
1787794 | 1787794 | 2021-10-06 | Clayton | Georgia | 13063 | 38292 | 663 |
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);