ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Jackson" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-28 1
- 2020-03-29 1
- 2020-03-30 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- 2020-04-10 1
- 2020-04-11 1
- 2020-04-12 1
- 2020-04-13 1
- 2020-04-14 1
- 2020-04-15 1
- 2020-04-16 1
- 2020-04-17 1
- 2020-04-18 1
- 2020-04-19 1
- 2020-04-20 1
- 2020-04-21 1
- 2020-04-22 1
- 2020-04-23 1
- 2020-04-24 1
- …
state 1
- Texas · 679 ✖
fips 1
- 48239 679
county 1
- Jackson · 679 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176942 | 2176942 | 2022-02-02 | Jackson | Texas | 48239 | 3111 | 55 |
2173688 | 2173688 | 2022-02-01 | Jackson | Texas | 48239 | 3110 | 55 |
2170436 | 2170436 | 2022-01-31 | Jackson | Texas | 48239 | 3105 | 55 |
2167182 | 2167182 | 2022-01-30 | Jackson | Texas | 48239 | 3098 | 55 |
2163927 | 2163927 | 2022-01-29 | Jackson | Texas | 48239 | 3090 | 55 |
2160672 | 2160672 | 2022-01-28 | Jackson | Texas | 48239 | 3086 | 55 |
2157416 | 2157416 | 2022-01-27 | Jackson | Texas | 48239 | 3076 | 55 |
2154163 | 2154163 | 2022-01-26 | Jackson | Texas | 48239 | 3069 | 55 |
2150911 | 2150911 | 2022-01-25 | Jackson | Texas | 48239 | 3065 | 54 |
2147659 | 2147659 | 2022-01-24 | Jackson | Texas | 48239 | 3060 | 54 |
2144405 | 2144405 | 2022-01-23 | Jackson | Texas | 48239 | 3053 | 54 |
2141150 | 2141150 | 2022-01-22 | Jackson | Texas | 48239 | 3042 | 53 |
2137894 | 2137894 | 2022-01-21 | Jackson | Texas | 48239 | 3032 | 53 |
2134640 | 2134640 | 2022-01-20 | Jackson | Texas | 48239 | 3018 | 53 |
2131388 | 2131388 | 2022-01-19 | Jackson | Texas | 48239 | 3012 | 53 |
2128134 | 2128134 | 2022-01-18 | Jackson | Texas | 48239 | 3007 | 53 |
2124882 | 2124882 | 2022-01-17 | Jackson | Texas | 48239 | 3004 | 53 |
2121630 | 2121630 | 2022-01-16 | Jackson | Texas | 48239 | 2995 | 53 |
2118378 | 2118378 | 2022-01-15 | Jackson | Texas | 48239 | 2992 | 53 |
2115127 | 2115127 | 2022-01-14 | Jackson | Texas | 48239 | 2978 | 53 |
2111875 | 2111875 | 2022-01-13 | Jackson | Texas | 48239 | 2922 | 52 |
2108623 | 2108623 | 2022-01-12 | Jackson | Texas | 48239 | 2904 | 52 |
2105372 | 2105372 | 2022-01-11 | Jackson | Texas | 48239 | 2895 | 52 |
2102121 | 2102121 | 2022-01-10 | Jackson | Texas | 48239 | 2889 | 52 |
2098870 | 2098870 | 2022-01-09 | Jackson | Texas | 48239 | 2880 | 52 |
2095618 | 2095618 | 2022-01-08 | Jackson | Texas | 48239 | 2876 | 52 |
2092366 | 2092366 | 2022-01-07 | Jackson | Texas | 48239 | 2866 | 52 |
2089114 | 2089114 | 2022-01-06 | Jackson | Texas | 48239 | 2850 | 52 |
2085863 | 2085863 | 2022-01-05 | Jackson | Texas | 48239 | 2842 | 52 |
2082611 | 2082611 | 2022-01-04 | Jackson | Texas | 48239 | 2834 | 52 |
2079359 | 2079359 | 2022-01-03 | Jackson | Texas | 48239 | 2833 | 52 |
2076108 | 2076108 | 2022-01-02 | Jackson | Texas | 48239 | 2809 | 52 |
2072857 | 2072857 | 2022-01-01 | Jackson | Texas | 48239 | 2809 | 52 |
2069606 | 2069606 | 2021-12-31 | Jackson | Texas | 48239 | 2809 | 52 |
2066355 | 2066355 | 2021-12-30 | Jackson | Texas | 48239 | 2809 | 52 |
2063105 | 2063105 | 2021-12-29 | Jackson | Texas | 48239 | 2809 | 52 |
2059855 | 2059855 | 2021-12-28 | Jackson | Texas | 48239 | 2808 | 52 |
2056606 | 2056606 | 2021-12-27 | Jackson | Texas | 48239 | 2808 | 52 |
2053357 | 2053357 | 2021-12-26 | Jackson | Texas | 48239 | 2803 | 52 |
2050107 | 2050107 | 2021-12-25 | Jackson | Texas | 48239 | 2803 | 52 |
2046857 | 2046857 | 2021-12-24 | Jackson | Texas | 48239 | 2803 | 52 |
2043607 | 2043607 | 2021-12-23 | Jackson | Texas | 48239 | 2803 | 52 |
2040358 | 2040358 | 2021-12-22 | Jackson | Texas | 48239 | 2801 | 52 |
2037108 | 2037108 | 2021-12-21 | Jackson | Texas | 48239 | 2800 | 52 |
2033858 | 2033858 | 2021-12-20 | Jackson | Texas | 48239 | 2800 | 52 |
2030608 | 2030608 | 2021-12-19 | Jackson | Texas | 48239 | 2800 | 52 |
2027357 | 2027357 | 2021-12-18 | Jackson | Texas | 48239 | 2800 | 52 |
2024106 | 2024106 | 2021-12-17 | Jackson | Texas | 48239 | 2799 | 52 |
2020855 | 2020855 | 2021-12-16 | Jackson | Texas | 48239 | 2798 | 52 |
2017604 | 2017604 | 2021-12-15 | Jackson | Texas | 48239 | 2797 | 52 |
2014354 | 2014354 | 2021-12-14 | Jackson | Texas | 48239 | 2795 | 52 |
2011103 | 2011103 | 2021-12-13 | Jackson | Texas | 48239 | 2795 | 52 |
2007852 | 2007852 | 2021-12-12 | Jackson | Texas | 48239 | 2795 | 52 |
2004601 | 2004601 | 2021-12-11 | Jackson | Texas | 48239 | 2795 | 52 |
2001350 | 2001350 | 2021-12-10 | Jackson | Texas | 48239 | 2794 | 52 |
1998100 | 1998100 | 2021-12-09 | Jackson | Texas | 48239 | 2794 | 52 |
1994849 | 1994849 | 2021-12-08 | Jackson | Texas | 48239 | 2794 | 52 |
1991598 | 1991598 | 2021-12-07 | Jackson | Texas | 48239 | 2793 | 52 |
1988347 | 1988347 | 2021-12-06 | Jackson | Texas | 48239 | 2793 | 52 |
1985097 | 1985097 | 2021-12-05 | Jackson | Texas | 48239 | 2793 | 52 |
1981847 | 1981847 | 2021-12-04 | Jackson | Texas | 48239 | 2793 | 52 |
1978597 | 1978597 | 2021-12-03 | Jackson | Texas | 48239 | 2790 | 52 |
1975347 | 1975347 | 2021-12-02 | Jackson | Texas | 48239 | 2787 | 52 |
1972098 | 1972098 | 2021-12-01 | Jackson | Texas | 48239 | 2787 | 52 |
1968848 | 1968848 | 2021-11-30 | Jackson | Texas | 48239 | 2786 | 52 |
1965597 | 1965597 | 2021-11-29 | Jackson | Texas | 48239 | 2786 | 52 |
1962345 | 1962345 | 2021-11-28 | Jackson | Texas | 48239 | 2786 | 52 |
1959094 | 1959094 | 2021-11-27 | Jackson | Texas | 48239 | 2786 | 52 |
1955843 | 1955843 | 2021-11-26 | Jackson | Texas | 48239 | 2786 | 52 |
1952592 | 1952592 | 2021-11-25 | Jackson | Texas | 48239 | 2786 | 52 |
1949341 | 1949341 | 2021-11-24 | Jackson | Texas | 48239 | 2786 | 52 |
1946090 | 1946090 | 2021-11-23 | Jackson | Texas | 48239 | 2786 | 52 |
1942839 | 1942839 | 2021-11-22 | Jackson | Texas | 48239 | 2786 | 52 |
1939589 | 1939589 | 2021-11-21 | Jackson | Texas | 48239 | 2786 | 52 |
1936339 | 1936339 | 2021-11-20 | Jackson | Texas | 48239 | 2786 | 52 |
1933089 | 1933089 | 2021-11-19 | Jackson | Texas | 48239 | 2786 | 52 |
1929838 | 1929838 | 2021-11-18 | Jackson | Texas | 48239 | 2786 | 52 |
1926588 | 1926588 | 2021-11-17 | Jackson | Texas | 48239 | 2786 | 52 |
1923338 | 1923338 | 2021-11-16 | Jackson | Texas | 48239 | 2786 | 52 |
1920089 | 1920089 | 2021-11-15 | Jackson | Texas | 48239 | 2786 | 52 |
1916839 | 1916839 | 2021-11-14 | Jackson | Texas | 48239 | 2786 | 51 |
1913589 | 1913589 | 2021-11-13 | Jackson | Texas | 48239 | 2786 | 51 |
1910339 | 1910339 | 2021-11-12 | Jackson | Texas | 48239 | 2786 | 51 |
1907090 | 1907090 | 2021-11-11 | Jackson | Texas | 48239 | 2786 | 51 |
1903841 | 1903841 | 2021-11-10 | Jackson | Texas | 48239 | 2786 | 50 |
1900591 | 1900591 | 2021-11-09 | Jackson | Texas | 48239 | 2786 | 50 |
1897341 | 1897341 | 2021-11-08 | Jackson | Texas | 48239 | 2786 | 50 |
1894091 | 1894091 | 2021-11-07 | Jackson | Texas | 48239 | 2786 | 50 |
1890841 | 1890841 | 2021-11-06 | Jackson | Texas | 48239 | 2786 | 50 |
1887591 | 1887591 | 2021-11-05 | Jackson | Texas | 48239 | 2786 | 50 |
1884341 | 1884341 | 2021-11-04 | Jackson | Texas | 48239 | 2786 | 50 |
1881092 | 1881092 | 2021-11-03 | Jackson | Texas | 48239 | 2786 | 50 |
1877843 | 1877843 | 2021-11-02 | Jackson | Texas | 48239 | 2786 | 50 |
1874594 | 1874594 | 2021-11-01 | Jackson | Texas | 48239 | 2786 | 50 |
1871345 | 1871345 | 2021-10-31 | Jackson | Texas | 48239 | 2786 | 50 |
1868096 | 1868096 | 2021-10-30 | Jackson | Texas | 48239 | 2786 | 50 |
1864847 | 1864847 | 2021-10-29 | Jackson | Texas | 48239 | 2786 | 50 |
1861598 | 1861598 | 2021-10-28 | Jackson | Texas | 48239 | 2786 | 50 |
1858349 | 1858349 | 2021-10-27 | Jackson | Texas | 48239 | 2782 | 50 |
1855100 | 1855100 | 2021-10-26 | Jackson | Texas | 48239 | 2782 | 50 |
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);