ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 47149 and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176801 | 2176801 | 2022-02-02 | Rutherford | Tennessee | 47149 | 90041 | 808 |
2173547 | 2173547 | 2022-02-01 | Rutherford | Tennessee | 47149 | 85516 | 792 |
2170295 | 2170295 | 2022-01-31 | Rutherford | Tennessee | 47149 | 85516 | 792 |
2167041 | 2167041 | 2022-01-30 | Rutherford | Tennessee | 47149 | 85516 | 792 |
2163786 | 2163786 | 2022-01-29 | Rutherford | Tennessee | 47149 | 85516 | 792 |
2160531 | 2160531 | 2022-01-28 | Rutherford | Tennessee | 47149 | 85516 | 792 |
2157275 | 2157275 | 2022-01-27 | Rutherford | Tennessee | 47149 | 85516 | 792 |
2154022 | 2154022 | 2022-01-26 | Rutherford | Tennessee | 47149 | 85516 | 792 |
2150770 | 2150770 | 2022-01-25 | Rutherford | Tennessee | 47149 | 79517 | 781 |
2147518 | 2147518 | 2022-01-24 | Rutherford | Tennessee | 47149 | 79517 | 781 |
2144264 | 2144264 | 2022-01-23 | Rutherford | Tennessee | 47149 | 79517 | 781 |
2141009 | 2141009 | 2022-01-22 | Rutherford | Tennessee | 47149 | 79517 | 781 |
2137753 | 2137753 | 2022-01-21 | Rutherford | Tennessee | 47149 | 79517 | 781 |
2134499 | 2134499 | 2022-01-20 | Rutherford | Tennessee | 47149 | 79517 | 781 |
2131247 | 2131247 | 2022-01-19 | Rutherford | Tennessee | 47149 | 79517 | 781 |
2127993 | 2127993 | 2022-01-18 | Rutherford | Tennessee | 47149 | 74216 | 745 |
2124741 | 2124741 | 2022-01-17 | Rutherford | Tennessee | 47149 | 74216 | 745 |
2121489 | 2121489 | 2022-01-16 | Rutherford | Tennessee | 47149 | 74216 | 745 |
2118237 | 2118237 | 2022-01-15 | Rutherford | Tennessee | 47149 | 74216 | 745 |
2114986 | 2114986 | 2022-01-14 | Rutherford | Tennessee | 47149 | 74216 | 745 |
2111734 | 2111734 | 2022-01-13 | Rutherford | Tennessee | 47149 | 74216 | 745 |
2108482 | 2108482 | 2022-01-12 | Rutherford | Tennessee | 47149 | 74216 | 745 |
2105231 | 2105231 | 2022-01-11 | Rutherford | Tennessee | 47149 | 70719 | 735 |
2101980 | 2101980 | 2022-01-10 | Rutherford | Tennessee | 47149 | 70719 | 735 |
2098729 | 2098729 | 2022-01-09 | Rutherford | Tennessee | 47149 | 70719 | 735 |
2095477 | 2095477 | 2022-01-08 | Rutherford | Tennessee | 47149 | 70719 | 735 |
2092225 | 2092225 | 2022-01-07 | Rutherford | Tennessee | 47149 | 70719 | 735 |
2088973 | 2088973 | 2022-01-06 | Rutherford | Tennessee | 47149 | 70719 | 735 |
2085722 | 2085722 | 2022-01-05 | Rutherford | Tennessee | 47149 | 70719 | 735 |
2082470 | 2082470 | 2022-01-04 | Rutherford | Tennessee | 47149 | 70719 | 735 |
2079218 | 2079218 | 2022-01-03 | Rutherford | Tennessee | 47149 | 70378 | 733 |
2075967 | 2075967 | 2022-01-02 | Rutherford | Tennessee | 47149 | 68185 | 731 |
2072716 | 2072716 | 2022-01-01 | Rutherford | Tennessee | 47149 | 68185 | 731 |
2069465 | 2069465 | 2021-12-31 | Rutherford | Tennessee | 47149 | 68185 | 731 |
2066214 | 2066214 | 2021-12-30 | Rutherford | Tennessee | 47149 | 68185 | 731 |
2062964 | 2062964 | 2021-12-29 | Rutherford | Tennessee | 47149 | 67523 | 723 |
2059714 | 2059714 | 2021-12-28 | Rutherford | Tennessee | 47149 | 67077 | 724 |
2056465 | 2056465 | 2021-12-27 | Rutherford | Tennessee | 47149 | 66839 | 716 |
2053216 | 2053216 | 2021-12-26 | Rutherford | Tennessee | 47149 | 66142 | 706 |
2049966 | 2049966 | 2021-12-25 | Rutherford | Tennessee | 47149 | 66142 | 706 |
2046716 | 2046716 | 2021-12-24 | Rutherford | Tennessee | 47149 | 66142 | 706 |
2043466 | 2043466 | 2021-12-23 | Rutherford | Tennessee | 47149 | 66142 | 706 |
2040217 | 2040217 | 2021-12-22 | Rutherford | Tennessee | 47149 | 65867 | 629 |
2036967 | 2036967 | 2021-12-21 | Rutherford | Tennessee | 47149 | 65766 | 625 |
2033717 | 2033717 | 2021-12-20 | Rutherford | Tennessee | 47149 | 65621 | 619 |
2030467 | 2030467 | 2021-12-19 | Rutherford | Tennessee | 47149 | 65338 | 616 |
2027216 | 2027216 | 2021-12-18 | Rutherford | Tennessee | 47149 | 65338 | 616 |
2023965 | 2023965 | 2021-12-17 | Rutherford | Tennessee | 47149 | 65338 | 616 |
2020714 | 2020714 | 2021-12-16 | Rutherford | Tennessee | 47149 | 65249 | 615 |
2017463 | 2017463 | 2021-12-15 | Rutherford | Tennessee | 47149 | 65124 | 613 |
2014213 | 2014213 | 2021-12-14 | Rutherford | Tennessee | 47149 | 65006 | 612 |
2010962 | 2010962 | 2021-12-13 | Rutherford | Tennessee | 47149 | 64943 | 611 |
2007711 | 2007711 | 2021-12-12 | Rutherford | Tennessee | 47149 | 64768 | 610 |
2004460 | 2004460 | 2021-12-11 | Rutherford | Tennessee | 47149 | 64768 | 610 |
2001209 | 2001209 | 2021-12-10 | Rutherford | Tennessee | 47149 | 64768 | 610 |
1997959 | 1997959 | 2021-12-09 | Rutherford | Tennessee | 47149 | 64538 | 608 |
1994708 | 1994708 | 2021-12-08 | Rutherford | Tennessee | 47149 | 64538 | 608 |
1991457 | 1991457 | 2021-12-07 | Rutherford | Tennessee | 47149 | 64445 | 606 |
1988206 | 1988206 | 2021-12-06 | Rutherford | Tennessee | 47149 | 64361 | 601 |
1984956 | 1984956 | 2021-12-05 | Rutherford | Tennessee | 47149 | 64165 | 595 |
1981706 | 1981706 | 2021-12-04 | Rutherford | Tennessee | 47149 | 64165 | 595 |
1978456 | 1978456 | 2021-12-03 | Rutherford | Tennessee | 47149 | 64165 | 595 |
1975206 | 1975206 | 2021-12-02 | Rutherford | Tennessee | 47149 | 64066 | 593 |
1971957 | 1971957 | 2021-12-01 | Rutherford | Tennessee | 47149 | 63966 | 588 |
1968707 | 1968707 | 2021-11-30 | Rutherford | Tennessee | 47149 | 63851 | 582 |
1965456 | 1965456 | 2021-11-29 | Rutherford | Tennessee | 47149 | 63782 | 580 |
1962204 | 1962204 | 2021-11-28 | Rutherford | Tennessee | 47149 | 63420 | 578 |
1958953 | 1958953 | 2021-11-27 | Rutherford | Tennessee | 47149 | 63420 | 578 |
1955702 | 1955702 | 2021-11-26 | Rutherford | Tennessee | 47149 | 63420 | 578 |
1952451 | 1952451 | 2021-11-25 | Rutherford | Tennessee | 47149 | 63420 | 578 |
1949200 | 1949200 | 2021-11-24 | Rutherford | Tennessee | 47149 | 63420 | 578 |
1945949 | 1945949 | 2021-11-23 | Rutherford | Tennessee | 47149 | 63384 | 576 |
1942698 | 1942698 | 2021-11-22 | Rutherford | Tennessee | 47149 | 63321 | 575 |
1939448 | 1939448 | 2021-11-21 | Rutherford | Tennessee | 47149 | 63136 | 574 |
1936198 | 1936198 | 2021-11-20 | Rutherford | Tennessee | 47149 | 63136 | 574 |
1932948 | 1932948 | 2021-11-19 | Rutherford | Tennessee | 47149 | 63136 | 574 |
1929697 | 1929697 | 2021-11-18 | Rutherford | Tennessee | 47149 | 63025 | 573 |
1926447 | 1926447 | 2021-11-17 | Rutherford | Tennessee | 47149 | 62920 | 573 |
1923197 | 1923197 | 2021-11-16 | Rutherford | Tennessee | 47149 | 62828 | 568 |
1919948 | 1919948 | 2021-11-15 | Rutherford | Tennessee | 47149 | 62788 | 567 |
1916698 | 1916698 | 2021-11-14 | Rutherford | Tennessee | 47149 | 62647 | 566 |
1913448 | 1913448 | 2021-11-13 | Rutherford | Tennessee | 47149 | 62647 | 566 |
1910198 | 1910198 | 2021-11-12 | Rutherford | Tennessee | 47149 | 62647 | 566 |
1906949 | 1906949 | 2021-11-11 | Rutherford | Tennessee | 47149 | 62541 | 563 |
1903700 | 1903700 | 2021-11-10 | Rutherford | Tennessee | 47149 | 62541 | 563 |
1900450 | 1900450 | 2021-11-09 | Rutherford | Tennessee | 47149 | 62462 | 562 |
1897200 | 1897200 | 2021-11-08 | Rutherford | Tennessee | 47149 | 62284 | 554 |
1893950 | 1893950 | 2021-11-07 | Rutherford | Tennessee | 47149 | 62284 | 554 |
1890700 | 1890700 | 2021-11-06 | Rutherford | Tennessee | 47149 | 62284 | 554 |
1887450 | 1887450 | 2021-11-05 | Rutherford | Tennessee | 47149 | 62284 | 554 |
1884200 | 1884200 | 2021-11-04 | Rutherford | Tennessee | 47149 | 62229 | 554 |
1880951 | 1880951 | 2021-11-03 | Rutherford | Tennessee | 47149 | 62170 | 554 |
1877702 | 1877702 | 2021-11-02 | Rutherford | Tennessee | 47149 | 62101 | 553 |
1874453 | 1874453 | 2021-11-01 | Rutherford | Tennessee | 47149 | 61914 | 551 |
1871204 | 1871204 | 2021-10-31 | Rutherford | Tennessee | 47149 | 61914 | 551 |
1867955 | 1867955 | 2021-10-30 | Rutherford | Tennessee | 47149 | 61914 | 551 |
1864706 | 1864706 | 2021-10-29 | Rutherford | Tennessee | 47149 | 61914 | 551 |
1861457 | 1861457 | 2021-10-28 | Rutherford | Tennessee | 47149 | 61863 | 549 |
1858208 | 1858208 | 2021-10-27 | Rutherford | Tennessee | 47149 | 61783 | 549 |
1854959 | 1854959 | 2021-10-26 | Rutherford | Tennessee | 47149 | 61714 | 546 |
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);