ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where county = "Lee" and fips = 48287 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176966 | 2176966 | 2022-02-02 | Lee | Texas | 48287 | 3882 | 56 |
2173712 | 2173712 | 2022-02-01 | Lee | Texas | 48287 | 3858 | 56 |
2170460 | 2170460 | 2022-01-31 | Lee | Texas | 48287 | 3846 | 56 |
2167206 | 2167206 | 2022-01-30 | Lee | Texas | 48287 | 3842 | 56 |
2163951 | 2163951 | 2022-01-29 | Lee | Texas | 48287 | 3834 | 56 |
2160696 | 2160696 | 2022-01-28 | Lee | Texas | 48287 | 3818 | 56 |
2157440 | 2157440 | 2022-01-27 | Lee | Texas | 48287 | 3816 | 56 |
2154187 | 2154187 | 2022-01-26 | Lee | Texas | 48287 | 3809 | 56 |
2150935 | 2150935 | 2022-01-25 | Lee | Texas | 48287 | 3759 | 56 |
2147683 | 2147683 | 2022-01-24 | Lee | Texas | 48287 | 3737 | 55 |
2144429 | 2144429 | 2022-01-23 | Lee | Texas | 48287 | 3728 | 55 |
2141174 | 2141174 | 2022-01-22 | Lee | Texas | 48287 | 3715 | 55 |
2137918 | 2137918 | 2022-01-21 | Lee | Texas | 48287 | 3671 | 55 |
2134664 | 2134664 | 2022-01-20 | Lee | Texas | 48287 | 3598 | 55 |
2131412 | 2131412 | 2022-01-19 | Lee | Texas | 48287 | 3573 | 55 |
2128158 | 2128158 | 2022-01-18 | Lee | Texas | 48287 | 3513 | 55 |
2124906 | 2124906 | 2022-01-17 | Lee | Texas | 48287 | 3506 | 55 |
2121654 | 2121654 | 2022-01-16 | Lee | Texas | 48287 | 3474 | 55 |
2118402 | 2118402 | 2022-01-15 | Lee | Texas | 48287 | 3461 | 55 |
2115151 | 2115151 | 2022-01-14 | Lee | Texas | 48287 | 3428 | 54 |
2111899 | 2111899 | 2022-01-13 | Lee | Texas | 48287 | 3351 | 54 |
2108647 | 2108647 | 2022-01-12 | Lee | Texas | 48287 | 3324 | 54 |
2105396 | 2105396 | 2022-01-11 | Lee | Texas | 48287 | 3314 | 54 |
2102145 | 2102145 | 2022-01-10 | Lee | Texas | 48287 | 3298 | 54 |
2098894 | 2098894 | 2022-01-09 | Lee | Texas | 48287 | 3292 | 54 |
2095642 | 2095642 | 2022-01-08 | Lee | Texas | 48287 | 3281 | 54 |
2092390 | 2092390 | 2022-01-07 | Lee | Texas | 48287 | 3248 | 54 |
2089138 | 2089138 | 2022-01-06 | Lee | Texas | 48287 | 3201 | 54 |
2085887 | 2085887 | 2022-01-05 | Lee | Texas | 48287 | 3177 | 54 |
2082635 | 2082635 | 2022-01-04 | Lee | Texas | 48287 | 3108 | 54 |
2079383 | 2079383 | 2022-01-03 | Lee | Texas | 48287 | 3092 | 54 |
2076132 | 2076132 | 2022-01-02 | Lee | Texas | 48287 | 3057 | 54 |
2072881 | 2072881 | 2022-01-01 | Lee | Texas | 48287 | 3057 | 54 |
2069630 | 2069630 | 2021-12-31 | Lee | Texas | 48287 | 3057 | 54 |
2066379 | 2066379 | 2021-12-30 | Lee | Texas | 48287 | 3057 | 54 |
2063129 | 2063129 | 2021-12-29 | Lee | Texas | 48287 | 3044 | 54 |
2059879 | 2059879 | 2021-12-28 | Lee | Texas | 48287 | 3025 | 54 |
2056630 | 2056630 | 2021-12-27 | Lee | Texas | 48287 | 3023 | 54 |
2053381 | 2053381 | 2021-12-26 | Lee | Texas | 48287 | 3020 | 54 |
2050131 | 2050131 | 2021-12-25 | Lee | Texas | 48287 | 3020 | 54 |
2046881 | 2046881 | 2021-12-24 | Lee | Texas | 48287 | 3020 | 54 |
2043631 | 2043631 | 2021-12-23 | Lee | Texas | 48287 | 3020 | 54 |
2040382 | 2040382 | 2021-12-22 | Lee | Texas | 48287 | 3016 | 54 |
2037132 | 2037132 | 2021-12-21 | Lee | Texas | 48287 | 3011 | 54 |
2033882 | 2033882 | 2021-12-20 | Lee | Texas | 48287 | 3011 | 54 |
2030632 | 2030632 | 2021-12-19 | Lee | Texas | 48287 | 3011 | 54 |
2027381 | 2027381 | 2021-12-18 | Lee | Texas | 48287 | 3010 | 54 |
2024130 | 2024130 | 2021-12-17 | Lee | Texas | 48287 | 3010 | 54 |
2020879 | 2020879 | 2021-12-16 | Lee | Texas | 48287 | 3010 | 54 |
2017628 | 2017628 | 2021-12-15 | Lee | Texas | 48287 | 3010 | 54 |
2014378 | 2014378 | 2021-12-14 | Lee | Texas | 48287 | 3007 | 54 |
2011127 | 2011127 | 2021-12-13 | Lee | Texas | 48287 | 3007 | 54 |
2007876 | 2007876 | 2021-12-12 | Lee | Texas | 48287 | 3007 | 54 |
2004625 | 2004625 | 2021-12-11 | Lee | Texas | 48287 | 3007 | 54 |
2001374 | 2001374 | 2021-12-10 | Lee | Texas | 48287 | 3006 | 54 |
1998124 | 1998124 | 2021-12-09 | Lee | Texas | 48287 | 2997 | 54 |
1994873 | 1994873 | 2021-12-08 | Lee | Texas | 48287 | 2995 | 54 |
1991622 | 1991622 | 2021-12-07 | Lee | Texas | 48287 | 2992 | 54 |
1988371 | 1988371 | 2021-12-06 | Lee | Texas | 48287 | 2991 | 54 |
1985121 | 1985121 | 2021-12-05 | Lee | Texas | 48287 | 2990 | 54 |
1981871 | 1981871 | 2021-12-04 | Lee | Texas | 48287 | 2990 | 54 |
1978621 | 1978621 | 2021-12-03 | Lee | Texas | 48287 | 2988 | 54 |
1975371 | 1975371 | 2021-12-02 | Lee | Texas | 48287 | 2985 | 54 |
1972122 | 1972122 | 2021-12-01 | Lee | Texas | 48287 | 2985 | 54 |
1968872 | 1968872 | 2021-11-30 | Lee | Texas | 48287 | 2985 | 54 |
1965621 | 1965621 | 2021-11-29 | Lee | Texas | 48287 | 2985 | 54 |
1962369 | 1962369 | 2021-11-28 | Lee | Texas | 48287 | 2982 | 54 |
1959118 | 1959118 | 2021-11-27 | Lee | Texas | 48287 | 2982 | 54 |
1955867 | 1955867 | 2021-11-26 | Lee | Texas | 48287 | 2982 | 54 |
1952616 | 1952616 | 2021-11-25 | Lee | Texas | 48287 | 2982 | 54 |
1949365 | 1949365 | 2021-11-24 | Lee | Texas | 48287 | 2982 | 54 |
1946114 | 1946114 | 2021-11-23 | Lee | Texas | 48287 | 2979 | 54 |
1942863 | 1942863 | 2021-11-22 | Lee | Texas | 48287 | 2978 | 54 |
1939613 | 1939613 | 2021-11-21 | Lee | Texas | 48287 | 2977 | 54 |
1936363 | 1936363 | 2021-11-20 | Lee | Texas | 48287 | 2977 | 54 |
1933113 | 1933113 | 2021-11-19 | Lee | Texas | 48287 | 2976 | 54 |
1929862 | 1929862 | 2021-11-18 | Lee | Texas | 48287 | 2976 | 54 |
1926612 | 1926612 | 2021-11-17 | Lee | Texas | 48287 | 2975 | 54 |
1923362 | 1923362 | 2021-11-16 | Lee | Texas | 48287 | 2973 | 54 |
1920113 | 1920113 | 2021-11-15 | Lee | Texas | 48287 | 2971 | 54 |
1916863 | 1916863 | 2021-11-14 | Lee | Texas | 48287 | 2971 | 54 |
1913613 | 1913613 | 2021-11-13 | Lee | Texas | 48287 | 2969 | 54 |
1910363 | 1910363 | 2021-11-12 | Lee | Texas | 48287 | 2969 | 54 |
1907114 | 1907114 | 2021-11-11 | Lee | Texas | 48287 | 2969 | 54 |
1903865 | 1903865 | 2021-11-10 | Lee | Texas | 48287 | 2969 | 53 |
1900615 | 1900615 | 2021-11-09 | Lee | Texas | 48287 | 2969 | 53 |
1897365 | 1897365 | 2021-11-08 | Lee | Texas | 48287 | 2967 | 52 |
1894115 | 1894115 | 2021-11-07 | Lee | Texas | 48287 | 2965 | 52 |
1890865 | 1890865 | 2021-11-06 | Lee | Texas | 48287 | 2965 | 52 |
1887615 | 1887615 | 2021-11-05 | Lee | Texas | 48287 | 2962 | 51 |
1884365 | 1884365 | 2021-11-04 | Lee | Texas | 48287 | 2962 | 51 |
1881116 | 1881116 | 2021-11-03 | Lee | Texas | 48287 | 2962 | 51 |
1877867 | 1877867 | 2021-11-02 | Lee | Texas | 48287 | 2961 | 51 |
1874618 | 1874618 | 2021-11-01 | Lee | Texas | 48287 | 2959 | 51 |
1871369 | 1871369 | 2021-10-31 | Lee | Texas | 48287 | 2954 | 51 |
1868120 | 1868120 | 2021-10-30 | Lee | Texas | 48287 | 2954 | 51 |
1864871 | 1864871 | 2021-10-29 | Lee | Texas | 48287 | 2950 | 51 |
1861622 | 1861622 | 2021-10-28 | Lee | Texas | 48287 | 2943 | 51 |
1858373 | 1858373 | 2021-10-27 | Lee | Texas | 48287 | 2943 | 51 |
1855124 | 1855124 | 2021-10-26 | Lee | Texas | 48287 | 2941 | 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);