ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 48027 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176836 | 2176836 | 2022-02-02 | Bell | Texas | 48027 | 61018 | 785 |
2173582 | 2173582 | 2022-02-01 | Bell | Texas | 48027 | 60734 | 783 |
2170330 | 2170330 | 2022-01-31 | Bell | Texas | 48027 | 60491 | 782 |
2167076 | 2167076 | 2022-01-30 | Bell | Texas | 48027 | 60165 | 780 |
2163821 | 2163821 | 2022-01-29 | Bell | Texas | 48027 | 59878 | 779 |
2160566 | 2160566 | 2022-01-28 | Bell | Texas | 48027 | 59321 | 776 |
2157310 | 2157310 | 2022-01-27 | Bell | Texas | 48027 | 58985 | 773 |
2154057 | 2154057 | 2022-01-26 | Bell | Texas | 48027 | 58624 | 773 |
2150805 | 2150805 | 2022-01-25 | Bell | Texas | 48027 | 58292 | 770 |
2147553 | 2147553 | 2022-01-24 | Bell | Texas | 48027 | 57604 | 768 |
2144299 | 2144299 | 2022-01-23 | Bell | Texas | 48027 | 57059 | 767 |
2141044 | 2141044 | 2022-01-22 | Bell | Texas | 48027 | 56277 | 767 |
2137788 | 2137788 | 2022-01-21 | Bell | Texas | 48027 | 54569 | 766 |
2134534 | 2134534 | 2022-01-20 | Bell | Texas | 48027 | 53831 | 764 |
2131282 | 2131282 | 2022-01-19 | Bell | Texas | 48027 | 53324 | 762 |
2128028 | 2128028 | 2022-01-18 | Bell | Texas | 48027 | 52674 | 761 |
2124776 | 2124776 | 2022-01-17 | Bell | Texas | 48027 | 52256 | 761 |
2121524 | 2121524 | 2022-01-16 | Bell | Texas | 48027 | 51558 | 761 |
2118272 | 2118272 | 2022-01-15 | Bell | Texas | 48027 | 51118 | 761 |
2115021 | 2115021 | 2022-01-14 | Bell | Texas | 48027 | 50528 | 760 |
2111769 | 2111769 | 2022-01-13 | Bell | Texas | 48027 | 46969 | 759 |
2108517 | 2108517 | 2022-01-12 | Bell | Texas | 48027 | 46204 | 758 |
2105266 | 2105266 | 2022-01-11 | Bell | Texas | 48027 | 45324 | 758 |
2102015 | 2102015 | 2022-01-10 | Bell | Texas | 48027 | 44923 | 757 |
2098764 | 2098764 | 2022-01-09 | Bell | Texas | 48027 | 44458 | 757 |
2095512 | 2095512 | 2022-01-08 | Bell | Texas | 48027 | 44159 | 757 |
2092260 | 2092260 | 2022-01-07 | Bell | Texas | 48027 | 43743 | 757 |
2089008 | 2089008 | 2022-01-06 | Bell | Texas | 48027 | 43301 | 756 |
2085757 | 2085757 | 2022-01-05 | Bell | Texas | 48027 | 42870 | 754 |
2082505 | 2082505 | 2022-01-04 | Bell | Texas | 48027 | 42638 | 753 |
2079253 | 2079253 | 2022-01-03 | Bell | Texas | 48027 | 42300 | 751 |
2076002 | 2076002 | 2022-01-02 | Bell | Texas | 48027 | 40806 | 751 |
2072751 | 2072751 | 2022-01-01 | Bell | Texas | 48027 | 40806 | 751 |
2069500 | 2069500 | 2021-12-31 | Bell | Texas | 48027 | 40806 | 751 |
2066249 | 2066249 | 2021-12-30 | Bell | Texas | 48027 | 40806 | 751 |
2062999 | 2062999 | 2021-12-29 | Bell | Texas | 48027 | 40762 | 750 |
2059749 | 2059749 | 2021-12-28 | Bell | Texas | 48027 | 40681 | 750 |
2056500 | 2056500 | 2021-12-27 | Bell | Texas | 48027 | 40607 | 750 |
2053251 | 2053251 | 2021-12-26 | Bell | Texas | 48027 | 40272 | 748 |
2050001 | 2050001 | 2021-12-25 | Bell | Texas | 48027 | 40272 | 748 |
2046751 | 2046751 | 2021-12-24 | Bell | Texas | 48027 | 40272 | 748 |
2043501 | 2043501 | 2021-12-23 | Bell | Texas | 48027 | 40272 | 748 |
2040252 | 2040252 | 2021-12-22 | Bell | Texas | 48027 | 40200 | 748 |
2037002 | 2037002 | 2021-12-21 | Bell | Texas | 48027 | 40153 | 748 |
2033752 | 2033752 | 2021-12-20 | Bell | Texas | 48027 | 40110 | 747 |
2030502 | 2030502 | 2021-12-19 | Bell | Texas | 48027 | 40049 | 747 |
2027251 | 2027251 | 2021-12-18 | Bell | Texas | 48027 | 40022 | 746 |
2024000 | 2024000 | 2021-12-17 | Bell | Texas | 48027 | 39966 | 745 |
2020749 | 2020749 | 2021-12-16 | Bell | Texas | 48027 | 39949 | 745 |
2017498 | 2017498 | 2021-12-15 | Bell | Texas | 48027 | 39917 | 745 |
2014248 | 2014248 | 2021-12-14 | Bell | Texas | 48027 | 39885 | 745 |
2010997 | 2010997 | 2021-12-13 | Bell | Texas | 48027 | 39861 | 745 |
2007746 | 2007746 | 2021-12-12 | Bell | Texas | 48027 | 39840 | 745 |
2004495 | 2004495 | 2021-12-11 | Bell | Texas | 48027 | 39818 | 745 |
2001244 | 2001244 | 2021-12-10 | Bell | Texas | 48027 | 39782 | 744 |
1997994 | 1997994 | 2021-12-09 | Bell | Texas | 48027 | 39702 | 744 |
1994743 | 1994743 | 2021-12-08 | Bell | Texas | 48027 | 39666 | 744 |
1991492 | 1991492 | 2021-12-07 | Bell | Texas | 48027 | 39654 | 742 |
1988241 | 1988241 | 2021-12-06 | Bell | Texas | 48027 | 39628 | 742 |
1984991 | 1984991 | 2021-12-05 | Bell | Texas | 48027 | 39603 | 742 |
1981741 | 1981741 | 2021-12-04 | Bell | Texas | 48027 | 39576 | 742 |
1978491 | 1978491 | 2021-12-03 | Bell | Texas | 48027 | 39565 | 740 |
1975241 | 1975241 | 2021-12-02 | Bell | Texas | 48027 | 39546 | 739 |
1971992 | 1971992 | 2021-12-01 | Bell | Texas | 48027 | 39525 | 739 |
1968742 | 1968742 | 2021-11-30 | Bell | Texas | 48027 | 39510 | 739 |
1965491 | 1965491 | 2021-11-29 | Bell | Texas | 48027 | 39510 | 739 |
1962239 | 1962239 | 2021-11-28 | Bell | Texas | 48027 | 39510 | 736 |
1958988 | 1958988 | 2021-11-27 | Bell | Texas | 48027 | 39510 | 736 |
1955737 | 1955737 | 2021-11-26 | Bell | Texas | 48027 | 39510 | 736 |
1952486 | 1952486 | 2021-11-25 | Bell | Texas | 48027 | 39510 | 736 |
1949235 | 1949235 | 2021-11-24 | Bell | Texas | 48027 | 39510 | 736 |
1945984 | 1945984 | 2021-11-23 | Bell | Texas | 48027 | 39510 | 735 |
1942733 | 1942733 | 2021-11-22 | Bell | Texas | 48027 | 39510 | 734 |
1939483 | 1939483 | 2021-11-21 | Bell | Texas | 48027 | 39510 | 734 |
1936233 | 1936233 | 2021-11-20 | Bell | Texas | 48027 | 39510 | 734 |
1932983 | 1932983 | 2021-11-19 | Bell | Texas | 48027 | 39472 | 734 |
1929732 | 1929732 | 2021-11-18 | Bell | Texas | 48027 | 39381 | 731 |
1926482 | 1926482 | 2021-11-17 | Bell | Texas | 48027 | 39381 | 730 |
1923232 | 1923232 | 2021-11-16 | Bell | Texas | 48027 | 39370 | 730 |
1919983 | 1919983 | 2021-11-15 | Bell | Texas | 48027 | 39304 | 730 |
1916733 | 1916733 | 2021-11-14 | Bell | Texas | 48027 | 39304 | 730 |
1913483 | 1913483 | 2021-11-13 | Bell | Texas | 48027 | 39304 | 730 |
1910233 | 1910233 | 2021-11-12 | Bell | Texas | 48027 | 39259 | 728 |
1906984 | 1906984 | 2021-11-11 | Bell | Texas | 48027 | 39259 | 726 |
1903735 | 1903735 | 2021-11-10 | Bell | Texas | 48027 | 39146 | 723 |
1900485 | 1900485 | 2021-11-09 | Bell | Texas | 48027 | 39146 | 723 |
1897235 | 1897235 | 2021-11-08 | Bell | Texas | 48027 | 39077 | 719 |
1893985 | 1893985 | 2021-11-07 | Bell | Texas | 48027 | 39077 | 719 |
1890735 | 1890735 | 2021-11-06 | Bell | Texas | 48027 | 39077 | 719 |
1887485 | 1887485 | 2021-11-05 | Bell | Texas | 48027 | 38911 | 719 |
1884235 | 1884235 | 2021-11-04 | Bell | Texas | 48027 | 38878 | 718 |
1880986 | 1880986 | 2021-11-03 | Bell | Texas | 48027 | 38808 | 714 |
1877737 | 1877737 | 2021-11-02 | Bell | Texas | 48027 | 38757 | 712 |
1874488 | 1874488 | 2021-11-01 | Bell | Texas | 48027 | 38691 | 712 |
1871239 | 1871239 | 2021-10-31 | Bell | Texas | 48027 | 38691 | 712 |
1867990 | 1867990 | 2021-10-30 | Bell | Texas | 48027 | 38691 | 710 |
1864741 | 1864741 | 2021-10-29 | Bell | Texas | 48027 | 38631 | 710 |
1861492 | 1861492 | 2021-10-28 | Bell | Texas | 48027 | 38506 | 709 |
1858243 | 1858243 | 2021-10-27 | Bell | Texas | 48027 | 38506 | 707 |
1854994 | 1854994 | 2021-10-26 | Bell | Texas | 48027 | 38344 | 705 |
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);