ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Crane" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176874 | 2176874 | 2022-02-02 | Crane | Texas | 48103 | 1184 | 21 |
2173620 | 2173620 | 2022-02-01 | Crane | Texas | 48103 | 1175 | 21 |
2170368 | 2170368 | 2022-01-31 | Crane | Texas | 48103 | 1168 | 20 |
2167114 | 2167114 | 2022-01-30 | Crane | Texas | 48103 | 1166 | 20 |
2163859 | 2163859 | 2022-01-29 | Crane | Texas | 48103 | 1165 | 19 |
2160604 | 2160604 | 2022-01-28 | Crane | Texas | 48103 | 1149 | 19 |
2157348 | 2157348 | 2022-01-27 | Crane | Texas | 48103 | 1137 | 19 |
2154095 | 2154095 | 2022-01-26 | Crane | Texas | 48103 | 1122 | 19 |
2150843 | 2150843 | 2022-01-25 | Crane | Texas | 48103 | 1112 | 19 |
2147591 | 2147591 | 2022-01-24 | Crane | Texas | 48103 | 1102 | 19 |
2144337 | 2144337 | 2022-01-23 | Crane | Texas | 48103 | 1099 | 19 |
2141082 | 2141082 | 2022-01-22 | Crane | Texas | 48103 | 1096 | 19 |
2137826 | 2137826 | 2022-01-21 | Crane | Texas | 48103 | 1084 | 19 |
2134572 | 2134572 | 2022-01-20 | Crane | Texas | 48103 | 1074 | 19 |
2131320 | 2131320 | 2022-01-19 | Crane | Texas | 48103 | 1043 | 19 |
2128066 | 2128066 | 2022-01-18 | Crane | Texas | 48103 | 1033 | 19 |
2124814 | 2124814 | 2022-01-17 | Crane | Texas | 48103 | 1026 | 19 |
2121562 | 2121562 | 2022-01-16 | Crane | Texas | 48103 | 1015 | 19 |
2118310 | 2118310 | 2022-01-15 | Crane | Texas | 48103 | 997 | 19 |
2115059 | 2115059 | 2022-01-14 | Crane | Texas | 48103 | 984 | 19 |
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 |
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);