ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 48103 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2111807 | 2111807 | 2022-01-13 | Crane | Texas | 48103 | 1099 | 19 |
2108555 | 2108555 | 2022-01-12 | Crane | Texas | 48103 | 1090 | 19 |
2105304 | 2105304 | 2022-01-11 | Crane | Texas | 48103 | 1082 | 19 |
2102053 | 2102053 | 2022-01-10 | Crane | Texas | 48103 | 1064 | 19 |
2098802 | 2098802 | 2022-01-09 | Crane | Texas | 48103 | 1061 | 19 |
2095550 | 2095550 | 2022-01-08 | Crane | Texas | 48103 | 1054 | 19 |
2092298 | 2092298 | 2022-01-07 | Crane | Texas | 48103 | 1044 | 19 |
2089046 | 2089046 | 2022-01-06 | Crane | Texas | 48103 | 1041 | 19 |
2085795 | 2085795 | 2022-01-05 | Crane | Texas | 48103 | 1030 | 19 |
2082543 | 2082543 | 2022-01-04 | Crane | Texas | 48103 | 1022 | 19 |
2079291 | 2079291 | 2022-01-03 | Crane | Texas | 48103 | 1017 | 19 |
2076040 | 2076040 | 2022-01-02 | Crane | Texas | 48103 | 1002 | 19 |
2072789 | 2072789 | 2022-01-01 | Crane | Texas | 48103 | 1002 | 19 |
2069538 | 2069538 | 2021-12-31 | Crane | Texas | 48103 | 1002 | 19 |
2066287 | 2066287 | 2021-12-30 | Crane | Texas | 48103 | 1002 | 19 |
2063037 | 2063037 | 2021-12-29 | Crane | Texas | 48103 | 996 | 19 |
2059787 | 2059787 | 2021-12-28 | Crane | Texas | 48103 | 990 | 19 |
2056538 | 2056538 | 2021-12-27 | Crane | Texas | 48103 | 983 | 19 |
2053289 | 2053289 | 2021-12-26 | Crane | Texas | 48103 | 982 | 19 |
2050039 | 2050039 | 2021-12-25 | Crane | Texas | 48103 | 982 | 19 |
2046789 | 2046789 | 2021-12-24 | Crane | Texas | 48103 | 982 | 19 |
2043539 | 2043539 | 2021-12-23 | Crane | Texas | 48103 | 982 | 19 |
2040290 | 2040290 | 2021-12-22 | Crane | Texas | 48103 | 981 | 19 |
2037040 | 2037040 | 2021-12-21 | Crane | Texas | 48103 | 980 | 19 |
2033790 | 2033790 | 2021-12-20 | Crane | Texas | 48103 | 978 | 19 |
2030540 | 2030540 | 2021-12-19 | Crane | Texas | 48103 | 976 | 19 |
2027289 | 2027289 | 2021-12-18 | Crane | Texas | 48103 | 976 | 19 |
2024038 | 2024038 | 2021-12-17 | Crane | Texas | 48103 | 970 | 19 |
2020787 | 2020787 | 2021-12-16 | Crane | Texas | 48103 | 970 | 19 |
2017536 | 2017536 | 2021-12-15 | Crane | Texas | 48103 | 969 | 19 |
2014286 | 2014286 | 2021-12-14 | Crane | Texas | 48103 | 967 | 19 |
2011035 | 2011035 | 2021-12-13 | Crane | Texas | 48103 | 967 | 19 |
2007784 | 2007784 | 2021-12-12 | Crane | Texas | 48103 | 967 | 19 |
2004533 | 2004533 | 2021-12-11 | Crane | Texas | 48103 | 967 | 19 |
2001282 | 2001282 | 2021-12-10 | Crane | Texas | 48103 | 964 | 19 |
1998032 | 1998032 | 2021-12-09 | Crane | Texas | 48103 | 956 | 19 |
1994781 | 1994781 | 2021-12-08 | Crane | Texas | 48103 | 956 | 19 |
1991530 | 1991530 | 2021-12-07 | Crane | Texas | 48103 | 956 | 19 |
1988279 | 1988279 | 2021-12-06 | Crane | Texas | 48103 | 951 | 19 |
1985029 | 1985029 | 2021-12-05 | Crane | Texas | 48103 | 951 | 19 |
1981779 | 1981779 | 2021-12-04 | Crane | Texas | 48103 | 950 | 19 |
1978529 | 1978529 | 2021-12-03 | Crane | Texas | 48103 | 948 | 19 |
1975279 | 1975279 | 2021-12-02 | Crane | Texas | 48103 | 933 | 19 |
1972030 | 1972030 | 2021-12-01 | Crane | Texas | 48103 | 909 | 19 |
1968780 | 1968780 | 2021-11-30 | Crane | Texas | 48103 | 897 | 19 |
1965529 | 1965529 | 2021-11-29 | Crane | Texas | 48103 | 897 | 19 |
1962277 | 1962277 | 2021-11-28 | Crane | Texas | 48103 | 896 | 19 |
1959026 | 1959026 | 2021-11-27 | Crane | Texas | 48103 | 896 | 19 |
1955775 | 1955775 | 2021-11-26 | Crane | Texas | 48103 | 896 | 19 |
1952524 | 1952524 | 2021-11-25 | Crane | Texas | 48103 | 896 | 19 |
1949273 | 1949273 | 2021-11-24 | Crane | Texas | 48103 | 896 | 19 |
1946022 | 1946022 | 2021-11-23 | Crane | Texas | 48103 | 895 | 19 |
1942771 | 1942771 | 2021-11-22 | Crane | Texas | 48103 | 895 | 19 |
1939521 | 1939521 | 2021-11-21 | Crane | Texas | 48103 | 895 | 19 |
1936271 | 1936271 | 2021-11-20 | Crane | Texas | 48103 | 895 | 19 |
1933021 | 1933021 | 2021-11-19 | Crane | Texas | 48103 | 895 | 19 |
1929770 | 1929770 | 2021-11-18 | Crane | Texas | 48103 | 893 | 19 |
1926520 | 1926520 | 2021-11-17 | Crane | Texas | 48103 | 892 | 19 |
1923270 | 1923270 | 2021-11-16 | Crane | Texas | 48103 | 889 | 19 |
1920021 | 1920021 | 2021-11-15 | Crane | Texas | 48103 | 889 | 19 |
1916771 | 1916771 | 2021-11-14 | Crane | Texas | 48103 | 889 | 19 |
1913521 | 1913521 | 2021-11-13 | Crane | Texas | 48103 | 886 | 19 |
1910271 | 1910271 | 2021-11-12 | Crane | Texas | 48103 | 882 | 19 |
1907022 | 1907022 | 2021-11-11 | Crane | Texas | 48103 | 882 | 19 |
1903773 | 1903773 | 2021-11-10 | Crane | Texas | 48103 | 881 | 19 |
1900523 | 1900523 | 2021-11-09 | Crane | Texas | 48103 | 881 | 19 |
1897273 | 1897273 | 2021-11-08 | Crane | Texas | 48103 | 881 | 18 |
1894023 | 1894023 | 2021-11-07 | Crane | Texas | 48103 | 881 | 18 |
1890773 | 1890773 | 2021-11-06 | Crane | Texas | 48103 | 884 | 18 |
1887523 | 1887523 | 2021-11-05 | Crane | Texas | 48103 | 880 | 18 |
1884273 | 1884273 | 2021-11-04 | Crane | Texas | 48103 | 875 | 18 |
1881024 | 1881024 | 2021-11-03 | Crane | Texas | 48103 | 872 | 18 |
1877775 | 1877775 | 2021-11-02 | Crane | Texas | 48103 | 871 | 18 |
1874526 | 1874526 | 2021-11-01 | Crane | Texas | 48103 | 871 | 18 |
1871277 | 1871277 | 2021-10-31 | Crane | Texas | 48103 | 871 | 18 |
1868028 | 1868028 | 2021-10-30 | Crane | Texas | 48103 | 870 | 18 |
1864779 | 1864779 | 2021-10-29 | Crane | Texas | 48103 | 868 | 18 |
1861530 | 1861530 | 2021-10-28 | Crane | Texas | 48103 | 865 | 18 |
1858281 | 1858281 | 2021-10-27 | Crane | Texas | 48103 | 865 | 18 |
1855032 | 1855032 | 2021-10-26 | Crane | Texas | 48103 | 865 | 18 |
1851783 | 1851783 | 2021-10-25 | Crane | Texas | 48103 | 864 | 18 |
1848533 | 1848533 | 2021-10-24 | Crane | Texas | 48103 | 860 | 18 |
1845283 | 1845283 | 2021-10-23 | Crane | Texas | 48103 | 860 | 17 |
1842033 | 1842033 | 2021-10-22 | Crane | Texas | 48103 | 860 | 17 |
1838784 | 1838784 | 2021-10-21 | Crane | Texas | 48103 | 860 | 17 |
1835535 | 1835535 | 2021-10-20 | Crane | Texas | 48103 | 859 | 17 |
1832286 | 1832286 | 2021-10-19 | Crane | Texas | 48103 | 857 | 17 |
1829037 | 1829037 | 2021-10-18 | Crane | Texas | 48103 | 855 | 17 |
1825788 | 1825788 | 2021-10-17 | Crane | Texas | 48103 | 855 | 17 |
1822539 | 1822539 | 2021-10-16 | Crane | Texas | 48103 | 855 | 17 |
1819290 | 1819290 | 2021-10-15 | Crane | Texas | 48103 | 855 | 17 |
1816041 | 1816041 | 2021-10-14 | Crane | Texas | 48103 | 855 | 17 |
1812793 | 1812793 | 2021-10-13 | Crane | Texas | 48103 | 855 | 17 |
1809544 | 1809544 | 2021-10-12 | Crane | Texas | 48103 | 852 | 17 |
1806294 | 1806294 | 2021-10-11 | Crane | Texas | 48103 | 848 | 17 |
1803044 | 1803044 | 2021-10-10 | Crane | Texas | 48103 | 848 | 17 |
1799795 | 1799795 | 2021-10-09 | Crane | Texas | 48103 | 847 | 17 |
1796546 | 1796546 | 2021-10-08 | Crane | Texas | 48103 | 845 | 17 |
1793297 | 1793297 | 2021-10-07 | Crane | Texas | 48103 | 839 | 17 |
1790048 | 1790048 | 2021-10-06 | Crane | Texas | 48103 | 839 | 17 |
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);