ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Bledsoe" and state = "Tennessee" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2111663 | 2111663 | 2022-01-13 | Bledsoe | Tennessee | 47007 | 3746 | 40 |
2108411 | 2108411 | 2022-01-12 | Bledsoe | Tennessee | 47007 | 3746 | 40 |
2105160 | 2105160 | 2022-01-11 | Bledsoe | Tennessee | 47007 | 3687 | 39 |
2101909 | 2101909 | 2022-01-10 | Bledsoe | Tennessee | 47007 | 3687 | 39 |
2098658 | 2098658 | 2022-01-09 | Bledsoe | Tennessee | 47007 | 3687 | 39 |
2095406 | 2095406 | 2022-01-08 | Bledsoe | Tennessee | 47007 | 3687 | 39 |
2092154 | 2092154 | 2022-01-07 | Bledsoe | Tennessee | 47007 | 3687 | 39 |
2088902 | 2088902 | 2022-01-06 | Bledsoe | Tennessee | 47007 | 3687 | 39 |
2085651 | 2085651 | 2022-01-05 | Bledsoe | Tennessee | 47007 | 3687 | 39 |
2082399 | 2082399 | 2022-01-04 | Bledsoe | Tennessee | 47007 | 3687 | 39 |
2079147 | 2079147 | 2022-01-03 | Bledsoe | Tennessee | 47007 | 3678 | 39 |
2075896 | 2075896 | 2022-01-02 | Bledsoe | Tennessee | 47007 | 3657 | 38 |
2072645 | 2072645 | 2022-01-01 | Bledsoe | Tennessee | 47007 | 3657 | 38 |
2069394 | 2069394 | 2021-12-31 | Bledsoe | Tennessee | 47007 | 3657 | 38 |
2066143 | 2066143 | 2021-12-30 | Bledsoe | Tennessee | 47007 | 3657 | 38 |
2062893 | 2062893 | 2021-12-29 | Bledsoe | Tennessee | 47007 | 3643 | 37 |
2059643 | 2059643 | 2021-12-28 | Bledsoe | Tennessee | 47007 | 3637 | 37 |
2056394 | 2056394 | 2021-12-27 | Bledsoe | Tennessee | 47007 | 3632 | 37 |
2053145 | 2053145 | 2021-12-26 | Bledsoe | Tennessee | 47007 | 3619 | 37 |
2049895 | 2049895 | 2021-12-25 | Bledsoe | Tennessee | 47007 | 3619 | 37 |
2046645 | 2046645 | 2021-12-24 | Bledsoe | Tennessee | 47007 | 3619 | 37 |
2043395 | 2043395 | 2021-12-23 | Bledsoe | Tennessee | 47007 | 3619 | 37 |
2040146 | 2040146 | 2021-12-22 | Bledsoe | Tennessee | 47007 | 3607 | 29 |
2036896 | 2036896 | 2021-12-21 | Bledsoe | Tennessee | 47007 | 3605 | 29 |
2033646 | 2033646 | 2021-12-20 | Bledsoe | Tennessee | 47007 | 3604 | 28 |
2030396 | 2030396 | 2021-12-19 | Bledsoe | Tennessee | 47007 | 3600 | 27 |
2027145 | 2027145 | 2021-12-18 | Bledsoe | Tennessee | 47007 | 3600 | 27 |
2023894 | 2023894 | 2021-12-17 | Bledsoe | Tennessee | 47007 | 3600 | 27 |
2020643 | 2020643 | 2021-12-16 | Bledsoe | Tennessee | 47007 | 3599 | 27 |
2017392 | 2017392 | 2021-12-15 | Bledsoe | Tennessee | 47007 | 3596 | 26 |
2014142 | 2014142 | 2021-12-14 | Bledsoe | Tennessee | 47007 | 3591 | 26 |
2010891 | 2010891 | 2021-12-13 | Bledsoe | Tennessee | 47007 | 3588 | 26 |
2007640 | 2007640 | 2021-12-12 | Bledsoe | Tennessee | 47007 | 3585 | 26 |
2004389 | 2004389 | 2021-12-11 | Bledsoe | Tennessee | 47007 | 3585 | 26 |
2001138 | 2001138 | 2021-12-10 | Bledsoe | Tennessee | 47007 | 3585 | 26 |
1997888 | 1997888 | 2021-12-09 | Bledsoe | Tennessee | 47007 | 3584 | 26 |
1994637 | 1994637 | 2021-12-08 | Bledsoe | Tennessee | 47007 | 3584 | 26 |
1991386 | 1991386 | 2021-12-07 | Bledsoe | Tennessee | 47007 | 3582 | 26 |
1988135 | 1988135 | 2021-12-06 | Bledsoe | Tennessee | 47007 | 3582 | 24 |
1984885 | 1984885 | 2021-12-05 | Bledsoe | Tennessee | 47007 | 3575 | 23 |
1981635 | 1981635 | 2021-12-04 | Bledsoe | Tennessee | 47007 | 3575 | 23 |
1978385 | 1978385 | 2021-12-03 | Bledsoe | Tennessee | 47007 | 3575 | 23 |
1975135 | 1975135 | 2021-12-02 | Bledsoe | Tennessee | 47007 | 3568 | 22 |
1971886 | 1971886 | 2021-12-01 | Bledsoe | Tennessee | 47007 | 3566 | 22 |
1968636 | 1968636 | 2021-11-30 | Bledsoe | Tennessee | 47007 | 3561 | 22 |
1965385 | 1965385 | 2021-11-29 | Bledsoe | Tennessee | 47007 | 3556 | 22 |
1962133 | 1962133 | 2021-11-28 | Bledsoe | Tennessee | 47007 | 3547 | 22 |
1958882 | 1958882 | 2021-11-27 | Bledsoe | Tennessee | 47007 | 3547 | 22 |
1955631 | 1955631 | 2021-11-26 | Bledsoe | Tennessee | 47007 | 3547 | 22 |
1952380 | 1952380 | 2021-11-25 | Bledsoe | Tennessee | 47007 | 3547 | 22 |
1949129 | 1949129 | 2021-11-24 | Bledsoe | Tennessee | 47007 | 3547 | 22 |
1945878 | 1945878 | 2021-11-23 | Bledsoe | Tennessee | 47007 | 3546 | 20 |
1942627 | 1942627 | 2021-11-22 | Bledsoe | Tennessee | 47007 | 3542 | 18 |
1939377 | 1939377 | 2021-11-21 | Bledsoe | Tennessee | 47007 | 3530 | 18 |
1936127 | 1936127 | 2021-11-20 | Bledsoe | Tennessee | 47007 | 3530 | 18 |
1932877 | 1932877 | 2021-11-19 | Bledsoe | Tennessee | 47007 | 3530 | 18 |
1929626 | 1929626 | 2021-11-18 | Bledsoe | Tennessee | 47007 | 3526 | 18 |
1926376 | 1926376 | 2021-11-17 | Bledsoe | Tennessee | 47007 | 3524 | 18 |
1923126 | 1923126 | 2021-11-16 | Bledsoe | Tennessee | 47007 | 3520 | 18 |
1919877 | 1919877 | 2021-11-15 | Bledsoe | Tennessee | 47007 | 3519 | 18 |
1916627 | 1916627 | 2021-11-14 | Bledsoe | Tennessee | 47007 | 3519 | 18 |
1913377 | 1913377 | 2021-11-13 | Bledsoe | Tennessee | 47007 | 3519 | 18 |
1910127 | 1910127 | 2021-11-12 | Bledsoe | Tennessee | 47007 | 3519 | 18 |
1906878 | 1906878 | 2021-11-11 | Bledsoe | Tennessee | 47007 | 3515 | 18 |
1903629 | 1903629 | 2021-11-10 | Bledsoe | Tennessee | 47007 | 3515 | 18 |
1900379 | 1900379 | 2021-11-09 | Bledsoe | Tennessee | 47007 | 3514 | 18 |
1897129 | 1897129 | 2021-11-08 | Bledsoe | Tennessee | 47007 | 3509 | 18 |
1893879 | 1893879 | 2021-11-07 | Bledsoe | Tennessee | 47007 | 3509 | 18 |
1890629 | 1890629 | 2021-11-06 | Bledsoe | Tennessee | 47007 | 3509 | 18 |
1887379 | 1887379 | 2021-11-05 | Bledsoe | Tennessee | 47007 | 3509 | 18 |
1884129 | 1884129 | 2021-11-04 | Bledsoe | Tennessee | 47007 | 3506 | 18 |
1880880 | 1880880 | 2021-11-03 | Bledsoe | Tennessee | 47007 | 3502 | 18 |
1877631 | 1877631 | 2021-11-02 | Bledsoe | Tennessee | 47007 | 3503 | 18 |
1874382 | 1874382 | 2021-11-01 | Bledsoe | Tennessee | 47007 | 3494 | 18 |
1871133 | 1871133 | 2021-10-31 | Bledsoe | Tennessee | 47007 | 3494 | 18 |
1867884 | 1867884 | 2021-10-30 | Bledsoe | Tennessee | 47007 | 3494 | 18 |
1864635 | 1864635 | 2021-10-29 | Bledsoe | Tennessee | 47007 | 3494 | 18 |
1861386 | 1861386 | 2021-10-28 | Bledsoe | Tennessee | 47007 | 3491 | 18 |
1858137 | 1858137 | 2021-10-27 | Bledsoe | Tennessee | 47007 | 3486 | 18 |
1854888 | 1854888 | 2021-10-26 | Bledsoe | Tennessee | 47007 | 3485 | 18 |
1851639 | 1851639 | 2021-10-25 | Bledsoe | Tennessee | 47007 | 3479 | 18 |
1848389 | 1848389 | 2021-10-24 | Bledsoe | Tennessee | 47007 | 3479 | 18 |
1845139 | 1845139 | 2021-10-23 | Bledsoe | Tennessee | 47007 | 3479 | 18 |
1841889 | 1841889 | 2021-10-22 | Bledsoe | Tennessee | 47007 | 3479 | 18 |
1838640 | 1838640 | 2021-10-21 | Bledsoe | Tennessee | 47007 | 3479 | 17 |
1835391 | 1835391 | 2021-10-20 | Bledsoe | Tennessee | 47007 | 3477 | 17 |
1832142 | 1832142 | 2021-10-19 | Bledsoe | Tennessee | 47007 | 3473 | 17 |
1828893 | 1828893 | 2021-10-18 | Bledsoe | Tennessee | 47007 | 3471 | 17 |
1825644 | 1825644 | 2021-10-17 | Bledsoe | Tennessee | 47007 | 3455 | 17 |
1822395 | 1822395 | 2021-10-16 | Bledsoe | Tennessee | 47007 | 3455 | 17 |
1819146 | 1819146 | 2021-10-15 | Bledsoe | Tennessee | 47007 | 3455 | 17 |
1815897 | 1815897 | 2021-10-14 | Bledsoe | Tennessee | 47007 | 3445 | 17 |
1812649 | 1812649 | 2021-10-13 | Bledsoe | Tennessee | 47007 | 3438 | 17 |
1809400 | 1809400 | 2021-10-12 | Bledsoe | Tennessee | 47007 | 3431 | 16 |
1806150 | 1806150 | 2021-10-11 | Bledsoe | Tennessee | 47007 | 3427 | 16 |
1802900 | 1802900 | 2021-10-10 | Bledsoe | Tennessee | 47007 | 3405 | 15 |
1799651 | 1799651 | 2021-10-09 | Bledsoe | Tennessee | 47007 | 3405 | 15 |
1796402 | 1796402 | 2021-10-08 | Bledsoe | Tennessee | 47007 | 3405 | 15 |
1793153 | 1793153 | 2021-10-07 | Bledsoe | Tennessee | 47007 | 3394 | 14 |
1789904 | 1789904 | 2021-10-06 | Bledsoe | Tennessee | 47007 | 3390 | 14 |
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);