ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Hamilton" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176759 | 2176759 | 2022-02-02 | Hamilton | Tennessee | 47065 | 91829 | 1005 |
2173505 | 2173505 | 2022-02-01 | Hamilton | Tennessee | 47065 | 89878 | 999 |
2170253 | 2170253 | 2022-01-31 | Hamilton | Tennessee | 47065 | 89000 | 988 |
2166999 | 2166999 | 2022-01-30 | Hamilton | Tennessee | 47065 | 87645 | 985 |
2163744 | 2163744 | 2022-01-29 | Hamilton | Tennessee | 47065 | 87645 | 985 |
2160489 | 2160489 | 2022-01-28 | Hamilton | Tennessee | 47065 | 87645 | 985 |
2157233 | 2157233 | 2022-01-27 | Hamilton | Tennessee | 47065 | 87645 | 981 |
2153980 | 2153980 | 2022-01-26 | Hamilton | Tennessee | 47065 | 87645 | 980 |
2150728 | 2150728 | 2022-01-25 | Hamilton | Tennessee | 47065 | 85234 | 977 |
2147476 | 2147476 | 2022-01-24 | Hamilton | Tennessee | 47065 | 84422 | 971 |
2144222 | 2144222 | 2022-01-23 | Hamilton | Tennessee | 47065 | 82495 | 957 |
2140967 | 2140967 | 2022-01-22 | Hamilton | Tennessee | 47065 | 82495 | 957 |
2137711 | 2137711 | 2022-01-21 | Hamilton | Tennessee | 47065 | 82495 | 957 |
2134457 | 2134457 | 2022-01-20 | Hamilton | Tennessee | 47065 | 82227 | 952 |
2131205 | 2131205 | 2022-01-19 | Hamilton | Tennessee | 47065 | 82227 | 946 |
2127951 | 2127951 | 2022-01-18 | Hamilton | Tennessee | 47065 | 80480 | 936 |
2124699 | 2124699 | 2022-01-17 | Hamilton | Tennessee | 47065 | 79246 | 922 |
2121447 | 2121447 | 2022-01-16 | Hamilton | Tennessee | 47065 | 79246 | 922 |
2118195 | 2118195 | 2022-01-15 | Hamilton | Tennessee | 47065 | 79246 | 922 |
2114944 | 2114944 | 2022-01-14 | Hamilton | Tennessee | 47065 | 79246 | 922 |
2111692 | 2111692 | 2022-01-13 | Hamilton | Tennessee | 47065 | 78616 | 920 |
2108440 | 2108440 | 2022-01-12 | Hamilton | Tennessee | 47065 | 77963 | 919 |
2105189 | 2105189 | 2022-01-11 | Hamilton | Tennessee | 47065 | 77290 | 916 |
2101938 | 2101938 | 2022-01-10 | Hamilton | Tennessee | 47065 | 76545 | 911 |
2098687 | 2098687 | 2022-01-09 | Hamilton | Tennessee | 47065 | 76054 | 904 |
2095435 | 2095435 | 2022-01-08 | Hamilton | Tennessee | 47065 | 75128 | 904 |
2092183 | 2092183 | 2022-01-07 | Hamilton | Tennessee | 47065 | 75128 | 904 |
2088931 | 2088931 | 2022-01-06 | Hamilton | Tennessee | 47065 | 74557 | 904 |
2085680 | 2085680 | 2022-01-05 | Hamilton | Tennessee | 47065 | 73041 | 904 |
2082428 | 2082428 | 2022-01-04 | Hamilton | Tennessee | 47065 | 73041 | 904 |
2079176 | 2079176 | 2022-01-03 | Hamilton | Tennessee | 47065 | 72027 | 902 |
2075925 | 2075925 | 2022-01-02 | Hamilton | Tennessee | 47065 | 71535 | 901 |
2072674 | 2072674 | 2022-01-01 | Hamilton | Tennessee | 47065 | 71335 | 901 |
2069423 | 2069423 | 2021-12-31 | Hamilton | Tennessee | 47065 | 71335 | 901 |
2066172 | 2066172 | 2021-12-30 | Hamilton | Tennessee | 47065 | 70797 | 901 |
2062922 | 2062922 | 2021-12-29 | Hamilton | Tennessee | 47065 | 70070 | 900 |
2059672 | 2059672 | 2021-12-28 | Hamilton | Tennessee | 47065 | 69122 | 899 |
2056423 | 2056423 | 2021-12-27 | Hamilton | Tennessee | 47065 | 68617 | 892 |
2053174 | 2053174 | 2021-12-26 | Hamilton | Tennessee | 47065 | 67892 | 881 |
2049924 | 2049924 | 2021-12-25 | Hamilton | Tennessee | 47065 | 67892 | 881 |
2046674 | 2046674 | 2021-12-24 | Hamilton | Tennessee | 47065 | 67892 | 881 |
2043424 | 2043424 | 2021-12-23 | Hamilton | Tennessee | 47065 | 67892 | 881 |
2040175 | 2040175 | 2021-12-22 | Hamilton | Tennessee | 47065 | 67892 | 754 |
2036925 | 2036925 | 2021-12-21 | Hamilton | Tennessee | 47065 | 67670 | 749 |
2033675 | 2033675 | 2021-12-20 | Hamilton | Tennessee | 47065 | 67522 | 744 |
2030425 | 2030425 | 2021-12-19 | Hamilton | Tennessee | 47065 | 67203 | 740 |
2027174 | 2027174 | 2021-12-18 | Hamilton | Tennessee | 47065 | 67203 | 740 |
2023923 | 2023923 | 2021-12-17 | Hamilton | Tennessee | 47065 | 67203 | 740 |
2020672 | 2020672 | 2021-12-16 | Hamilton | Tennessee | 47065 | 67102 | 736 |
2017421 | 2017421 | 2021-12-15 | Hamilton | Tennessee | 47065 | 66907 | 733 |
2014171 | 2014171 | 2021-12-14 | Hamilton | Tennessee | 47065 | 66823 | 727 |
2010920 | 2010920 | 2021-12-13 | Hamilton | Tennessee | 47065 | 66679 | 726 |
2007669 | 2007669 | 2021-12-12 | Hamilton | Tennessee | 47065 | 66466 | 726 |
2004418 | 2004418 | 2021-12-11 | Hamilton | Tennessee | 47065 | 66466 | 726 |
2001167 | 2001167 | 2021-12-10 | Hamilton | Tennessee | 47065 | 66466 | 726 |
1997917 | 1997917 | 2021-12-09 | Hamilton | Tennessee | 47065 | 66358 | 723 |
1994666 | 1994666 | 2021-12-08 | Hamilton | Tennessee | 47065 | 66181 | 723 |
1991415 | 1991415 | 2021-12-07 | Hamilton | Tennessee | 47065 | 66082 | 724 |
1988164 | 1988164 | 2021-12-06 | Hamilton | Tennessee | 47065 | 65970 | 713 |
1984914 | 1984914 | 2021-12-05 | Hamilton | Tennessee | 47065 | 65818 | 711 |
1981664 | 1981664 | 2021-12-04 | Hamilton | Tennessee | 47065 | 65818 | 711 |
1978414 | 1978414 | 2021-12-03 | Hamilton | Tennessee | 47065 | 65818 | 711 |
1975164 | 1975164 | 2021-12-02 | Hamilton | Tennessee | 47065 | 65721 | 704 |
1971915 | 1971915 | 2021-12-01 | Hamilton | Tennessee | 47065 | 65614 | 685 |
1968665 | 1968665 | 2021-11-30 | Hamilton | Tennessee | 47065 | 65533 | 681 |
1965414 | 1965414 | 2021-11-29 | Hamilton | Tennessee | 47065 | 65405 | 679 |
1962162 | 1962162 | 2021-11-28 | Hamilton | Tennessee | 47065 | 65218 | 677 |
1958911 | 1958911 | 2021-11-27 | Hamilton | Tennessee | 47065 | 65218 | 677 |
1955660 | 1955660 | 2021-11-26 | Hamilton | Tennessee | 47065 | 65218 | 677 |
1952409 | 1952409 | 2021-11-25 | Hamilton | Tennessee | 47065 | 65218 | 677 |
1949158 | 1949158 | 2021-11-24 | Hamilton | Tennessee | 47065 | 65218 | 677 |
1945907 | 1945907 | 2021-11-23 | Hamilton | Tennessee | 47065 | 65169 | 675 |
1942656 | 1942656 | 2021-11-22 | Hamilton | Tennessee | 47065 | 65104 | 671 |
1939406 | 1939406 | 2021-11-21 | Hamilton | Tennessee | 47065 | 64982 | 669 |
1936156 | 1936156 | 2021-11-20 | Hamilton | Tennessee | 47065 | 64982 | 669 |
1932906 | 1932906 | 2021-11-19 | Hamilton | Tennessee | 47065 | 64982 | 669 |
1929655 | 1929655 | 2021-11-18 | Hamilton | Tennessee | 47065 | 64931 | 668 |
1926405 | 1926405 | 2021-11-17 | Hamilton | Tennessee | 47065 | 64865 | 667 |
1923155 | 1923155 | 2021-11-16 | Hamilton | Tennessee | 47065 | 64796 | 665 |
1919906 | 1919906 | 2021-11-15 | Hamilton | Tennessee | 47065 | 64741 | 663 |
1916656 | 1916656 | 2021-11-14 | Hamilton | Tennessee | 47065 | 64614 | 660 |
1913406 | 1913406 | 2021-11-13 | Hamilton | Tennessee | 47065 | 64614 | 660 |
1910156 | 1910156 | 2021-11-12 | Hamilton | Tennessee | 47065 | 64614 | 660 |
1906907 | 1906907 | 2021-11-11 | Hamilton | Tennessee | 47065 | 64560 | 660 |
1903658 | 1903658 | 2021-11-10 | Hamilton | Tennessee | 47065 | 64509 | 660 |
1900408 | 1900408 | 2021-11-09 | Hamilton | Tennessee | 47065 | 64473 | 658 |
1897158 | 1897158 | 2021-11-08 | Hamilton | Tennessee | 47065 | 64412 | 653 |
1893908 | 1893908 | 2021-11-07 | Hamilton | Tennessee | 47065 | 64325 | 653 |
1890658 | 1890658 | 2021-11-06 | Hamilton | Tennessee | 47065 | 64325 | 653 |
1887408 | 1887408 | 2021-11-05 | Hamilton | Tennessee | 47065 | 64325 | 653 |
1884158 | 1884158 | 2021-11-04 | Hamilton | Tennessee | 47065 | 64280 | 652 |
1880909 | 1880909 | 2021-11-03 | Hamilton | Tennessee | 47065 | 64238 | 652 |
1877660 | 1877660 | 2021-11-02 | Hamilton | Tennessee | 47065 | 64205 | 652 |
1874411 | 1874411 | 2021-11-01 | Hamilton | Tennessee | 47065 | 64136 | 652 |
1871162 | 1871162 | 2021-10-31 | Hamilton | Tennessee | 47065 | 64029 | 651 |
1867913 | 1867913 | 2021-10-30 | Hamilton | Tennessee | 47065 | 64029 | 651 |
1864664 | 1864664 | 2021-10-29 | Hamilton | Tennessee | 47065 | 64029 | 651 |
1861415 | 1861415 | 2021-10-28 | Hamilton | Tennessee | 47065 | 63989 | 651 |
1858166 | 1858166 | 2021-10-27 | Hamilton | Tennessee | 47065 | 63933 | 649 |
1854917 | 1854917 | 2021-10-26 | Hamilton | Tennessee | 47065 | 63843 | 648 |
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);