ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 48123 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176881 | 2176881 | 2022-02-02 | DeWitt | Texas | 48123 | 6272 | 87 |
2173627 | 2173627 | 2022-02-01 | DeWitt | Texas | 48123 | 6260 | 86 |
2170375 | 2170375 | 2022-01-31 | DeWitt | Texas | 48123 | 6251 | 86 |
2167121 | 2167121 | 2022-01-30 | DeWitt | Texas | 48123 | 6232 | 86 |
2163866 | 2163866 | 2022-01-29 | DeWitt | Texas | 48123 | 6198 | 86 |
2160611 | 2160611 | 2022-01-28 | DeWitt | Texas | 48123 | 6166 | 86 |
2157355 | 2157355 | 2022-01-27 | DeWitt | Texas | 48123 | 6153 | 86 |
2154102 | 2154102 | 2022-01-26 | DeWitt | Texas | 48123 | 6108 | 86 |
2150850 | 2150850 | 2022-01-25 | DeWitt | Texas | 48123 | 6101 | 86 |
2147598 | 2147598 | 2022-01-24 | DeWitt | Texas | 48123 | 6062 | 86 |
2144344 | 2144344 | 2022-01-23 | DeWitt | Texas | 48123 | 6031 | 86 |
2141089 | 2141089 | 2022-01-22 | DeWitt | Texas | 48123 | 5963 | 86 |
2137833 | 2137833 | 2022-01-21 | DeWitt | Texas | 48123 | 5896 | 86 |
2134579 | 2134579 | 2022-01-20 | DeWitt | Texas | 48123 | 5764 | 86 |
2131327 | 2131327 | 2022-01-19 | DeWitt | Texas | 48123 | 5673 | 86 |
2128073 | 2128073 | 2022-01-18 | DeWitt | Texas | 48123 | 5639 | 86 |
2124821 | 2124821 | 2022-01-17 | DeWitt | Texas | 48123 | 5610 | 86 |
2121569 | 2121569 | 2022-01-16 | DeWitt | Texas | 48123 | 5596 | 86 |
2118317 | 2118317 | 2022-01-15 | DeWitt | Texas | 48123 | 5575 | 86 |
2115066 | 2115066 | 2022-01-14 | DeWitt | Texas | 48123 | 5516 | 86 |
2111814 | 2111814 | 2022-01-13 | DeWitt | Texas | 48123 | 3412 | 86 |
2108562 | 2108562 | 2022-01-12 | DeWitt | Texas | 48123 | 3353 | 86 |
2105311 | 2105311 | 2022-01-11 | DeWitt | Texas | 48123 | 3298 | 86 |
2102060 | 2102060 | 2022-01-10 | DeWitt | Texas | 48123 | 3274 | 86 |
2098809 | 2098809 | 2022-01-09 | DeWitt | Texas | 48123 | 3239 | 86 |
2095557 | 2095557 | 2022-01-08 | DeWitt | Texas | 48123 | 3220 | 86 |
2092305 | 2092305 | 2022-01-07 | DeWitt | Texas | 48123 | 3196 | 86 |
2089053 | 2089053 | 2022-01-06 | DeWitt | Texas | 48123 | 3181 | 86 |
2085802 | 2085802 | 2022-01-05 | DeWitt | Texas | 48123 | 3164 | 86 |
2082550 | 2082550 | 2022-01-04 | DeWitt | Texas | 48123 | 3146 | 86 |
2079298 | 2079298 | 2022-01-03 | DeWitt | Texas | 48123 | 3135 | 86 |
2076047 | 2076047 | 2022-01-02 | DeWitt | Texas | 48123 | 3049 | 86 |
2072796 | 2072796 | 2022-01-01 | DeWitt | Texas | 48123 | 3049 | 86 |
2069545 | 2069545 | 2021-12-31 | DeWitt | Texas | 48123 | 3049 | 86 |
2066294 | 2066294 | 2021-12-30 | DeWitt | Texas | 48123 | 3049 | 86 |
2063044 | 2063044 | 2021-12-29 | DeWitt | Texas | 48123 | 3049 | 86 |
2059794 | 2059794 | 2021-12-28 | DeWitt | Texas | 48123 | 3043 | 86 |
2056545 | 2056545 | 2021-12-27 | DeWitt | Texas | 48123 | 3041 | 86 |
2053296 | 2053296 | 2021-12-26 | DeWitt | Texas | 48123 | 3034 | 86 |
2050046 | 2050046 | 2021-12-25 | DeWitt | Texas | 48123 | 3034 | 86 |
2046796 | 2046796 | 2021-12-24 | DeWitt | Texas | 48123 | 3034 | 86 |
2043546 | 2043546 | 2021-12-23 | DeWitt | Texas | 48123 | 3034 | 86 |
2040297 | 2040297 | 2021-12-22 | DeWitt | Texas | 48123 | 3032 | 86 |
2037047 | 2037047 | 2021-12-21 | DeWitt | Texas | 48123 | 3030 | 86 |
2033797 | 2033797 | 2021-12-20 | DeWitt | Texas | 48123 | 3030 | 86 |
2030547 | 2030547 | 2021-12-19 | DeWitt | Texas | 48123 | 3030 | 86 |
2027296 | 2027296 | 2021-12-18 | DeWitt | Texas | 48123 | 3030 | 86 |
2024045 | 2024045 | 2021-12-17 | DeWitt | Texas | 48123 | 3029 | 86 |
2020794 | 2020794 | 2021-12-16 | DeWitt | Texas | 48123 | 3027 | 86 |
2017543 | 2017543 | 2021-12-15 | DeWitt | Texas | 48123 | 3027 | 86 |
2014293 | 2014293 | 2021-12-14 | DeWitt | Texas | 48123 | 3025 | 86 |
2011042 | 2011042 | 2021-12-13 | DeWitt | Texas | 48123 | 3025 | 86 |
2007791 | 2007791 | 2021-12-12 | DeWitt | Texas | 48123 | 3024 | 86 |
2004540 | 2004540 | 2021-12-11 | DeWitt | Texas | 48123 | 3024 | 86 |
2001289 | 2001289 | 2021-12-10 | DeWitt | Texas | 48123 | 3024 | 86 |
1998039 | 1998039 | 2021-12-09 | DeWitt | Texas | 48123 | 3016 | 86 |
1994788 | 1994788 | 2021-12-08 | DeWitt | Texas | 48123 | 3016 | 85 |
1991537 | 1991537 | 2021-12-07 | DeWitt | Texas | 48123 | 3015 | 85 |
1988286 | 1988286 | 2021-12-06 | DeWitt | Texas | 48123 | 3015 | 85 |
1985036 | 1985036 | 2021-12-05 | DeWitt | Texas | 48123 | 3015 | 85 |
1981786 | 1981786 | 2021-12-04 | DeWitt | Texas | 48123 | 3015 | 85 |
1978536 | 1978536 | 2021-12-03 | DeWitt | Texas | 48123 | 3014 | 85 |
1975286 | 1975286 | 2021-12-02 | DeWitt | Texas | 48123 | 3013 | 85 |
1972037 | 1972037 | 2021-12-01 | DeWitt | Texas | 48123 | 3013 | 85 |
1968787 | 1968787 | 2021-11-30 | DeWitt | Texas | 48123 | 3013 | 85 |
1965536 | 1965536 | 2021-11-29 | DeWitt | Texas | 48123 | 3013 | 85 |
1962284 | 1962284 | 2021-11-28 | DeWitt | Texas | 48123 | 3013 | 85 |
1959033 | 1959033 | 2021-11-27 | DeWitt | Texas | 48123 | 3013 | 85 |
1955782 | 1955782 | 2021-11-26 | DeWitt | Texas | 48123 | 3013 | 85 |
1952531 | 1952531 | 2021-11-25 | DeWitt | Texas | 48123 | 3013 | 85 |
1949280 | 1949280 | 2021-11-24 | DeWitt | Texas | 48123 | 3013 | 85 |
1946029 | 1946029 | 2021-11-23 | DeWitt | Texas | 48123 | 3018 | 84 |
1942778 | 1942778 | 2021-11-22 | DeWitt | Texas | 48123 | 3018 | 84 |
1939528 | 1939528 | 2021-11-21 | DeWitt | Texas | 48123 | 3018 | 84 |
1936278 | 1936278 | 2021-11-20 | DeWitt | Texas | 48123 | 3018 | 84 |
1933028 | 1933028 | 2021-11-19 | DeWitt | Texas | 48123 | 3018 | 84 |
1929777 | 1929777 | 2021-11-18 | DeWitt | Texas | 48123 | 2944 | 84 |
1926527 | 1926527 | 2021-11-17 | DeWitt | Texas | 48123 | 2943 | 84 |
1923277 | 1923277 | 2021-11-16 | DeWitt | Texas | 48123 | 2943 | 84 |
1920028 | 1920028 | 2021-11-15 | DeWitt | Texas | 48123 | 2943 | 84 |
1916778 | 1916778 | 2021-11-14 | DeWitt | Texas | 48123 | 2943 | 84 |
1913528 | 1913528 | 2021-11-13 | DeWitt | Texas | 48123 | 2943 | 84 |
1910278 | 1910278 | 2021-11-12 | DeWitt | Texas | 48123 | 2943 | 84 |
1907029 | 1907029 | 2021-11-11 | DeWitt | Texas | 48123 | 2942 | 84 |
1903780 | 1903780 | 2021-11-10 | DeWitt | Texas | 48123 | 2942 | 84 |
1900530 | 1900530 | 2021-11-09 | DeWitt | Texas | 48123 | 2942 | 84 |
1897280 | 1897280 | 2021-11-08 | DeWitt | Texas | 48123 | 2946 | 83 |
1894030 | 1894030 | 2021-11-07 | DeWitt | Texas | 48123 | 2945 | 83 |
1890780 | 1890780 | 2021-11-06 | DeWitt | Texas | 48123 | 2945 | 83 |
1887530 | 1887530 | 2021-11-05 | DeWitt | Texas | 48123 | 2945 | 82 |
1884280 | 1884280 | 2021-11-04 | DeWitt | Texas | 48123 | 2948 | 82 |
1881031 | 1881031 | 2021-11-03 | DeWitt | Texas | 48123 | 2948 | 82 |
1877782 | 1877782 | 2021-11-02 | DeWitt | Texas | 48123 | 2946 | 82 |
1874533 | 1874533 | 2021-11-01 | DeWitt | Texas | 48123 | 2946 | 82 |
1871284 | 1871284 | 2021-10-31 | DeWitt | Texas | 48123 | 2948 | 82 |
1868035 | 1868035 | 2021-10-30 | DeWitt | Texas | 48123 | 2948 | 82 |
1864786 | 1864786 | 2021-10-29 | DeWitt | Texas | 48123 | 2948 | 82 |
1861537 | 1861537 | 2021-10-28 | DeWitt | Texas | 48123 | 2950 | 82 |
1858288 | 1858288 | 2021-10-27 | DeWitt | Texas | 48123 | 2952 | 82 |
1855039 | 1855039 | 2021-10-26 | DeWitt | Texas | 48123 | 2952 | 82 |
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);