ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Medina" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2176985 | 2176985 | 2022-02-02 | Medina | Texas | 48325 | 9356 | 179 |
2173731 | 2173731 | 2022-02-01 | Medina | Texas | 48325 | 9304 | 179 |
2170479 | 2170479 | 2022-01-31 | Medina | Texas | 48325 | 9218 | 179 |
2167225 | 2167225 | 2022-01-30 | Medina | Texas | 48325 | 9186 | 179 |
2163970 | 2163970 | 2022-01-29 | Medina | Texas | 48325 | 9154 | 178 |
2160715 | 2160715 | 2022-01-28 | Medina | Texas | 48325 | 9079 | 178 |
2157459 | 2157459 | 2022-01-27 | Medina | Texas | 48325 | 8992 | 178 |
2154206 | 2154206 | 2022-01-26 | Medina | Texas | 48325 | 8924 | 177 |
2150954 | 2150954 | 2022-01-25 | Medina | Texas | 48325 | 8872 | 177 |
2147702 | 2147702 | 2022-01-24 | Medina | Texas | 48325 | 8779 | 177 |
2144448 | 2144448 | 2022-01-23 | Medina | Texas | 48325 | 8701 | 177 |
2141193 | 2141193 | 2022-01-22 | Medina | Texas | 48325 | 8645 | 177 |
2137937 | 2137937 | 2022-01-21 | Medina | Texas | 48325 | 8533 | 177 |
2134683 | 2134683 | 2022-01-20 | Medina | Texas | 48325 | 8406 | 177 |
2131431 | 2131431 | 2022-01-19 | Medina | Texas | 48325 | 8308 | 176 |
2128177 | 2128177 | 2022-01-18 | Medina | Texas | 48325 | 8211 | 176 |
2124925 | 2124925 | 2022-01-17 | Medina | Texas | 48325 | 8147 | 175 |
2121673 | 2121673 | 2022-01-16 | Medina | Texas | 48325 | 8044 | 175 |
2118421 | 2118421 | 2022-01-15 | Medina | Texas | 48325 | 8000 | 175 |
2115170 | 2115170 | 2022-01-14 | Medina | Texas | 48325 | 7895 | 175 |
2111918 | 2111918 | 2022-01-13 | Medina | Texas | 48325 | 7864 | 175 |
2108666 | 2108666 | 2022-01-12 | Medina | Texas | 48325 | 7752 | 174 |
2105415 | 2105415 | 2022-01-11 | Medina | Texas | 48325 | 7669 | 174 |
2102164 | 2102164 | 2022-01-10 | Medina | Texas | 48325 | 7620 | 174 |
2098913 | 2098913 | 2022-01-09 | Medina | Texas | 48325 | 7573 | 174 |
2095661 | 2095661 | 2022-01-08 | Medina | Texas | 48325 | 7530 | 174 |
2092409 | 2092409 | 2022-01-07 | Medina | Texas | 48325 | 7477 | 174 |
2089157 | 2089157 | 2022-01-06 | Medina | Texas | 48325 | 7415 | 174 |
2085906 | 2085906 | 2022-01-05 | Medina | Texas | 48325 | 7391 | 174 |
2082654 | 2082654 | 2022-01-04 | Medina | Texas | 48325 | 7367 | 173 |
2079402 | 2079402 | 2022-01-03 | Medina | Texas | 48325 | 7315 | 173 |
2076151 | 2076151 | 2022-01-02 | Medina | Texas | 48325 | 7209 | 173 |
2072900 | 2072900 | 2022-01-01 | Medina | Texas | 48325 | 7209 | 173 |
2069649 | 2069649 | 2021-12-31 | Medina | Texas | 48325 | 7209 | 173 |
2066398 | 2066398 | 2021-12-30 | Medina | Texas | 48325 | 7209 | 173 |
2063148 | 2063148 | 2021-12-29 | Medina | Texas | 48325 | 7200 | 172 |
2059898 | 2059898 | 2021-12-28 | Medina | Texas | 48325 | 7198 | 171 |
2056649 | 2056649 | 2021-12-27 | Medina | Texas | 48325 | 7179 | 171 |
2053400 | 2053400 | 2021-12-26 | Medina | Texas | 48325 | 7156 | 172 |
2050150 | 2050150 | 2021-12-25 | Medina | Texas | 48325 | 7156 | 172 |
2046900 | 2046900 | 2021-12-24 | Medina | Texas | 48325 | 7156 | 172 |
2043650 | 2043650 | 2021-12-23 | Medina | Texas | 48325 | 7156 | 172 |
2040401 | 2040401 | 2021-12-22 | Medina | Texas | 48325 | 7151 | 171 |
2037151 | 2037151 | 2021-12-21 | Medina | Texas | 48325 | 7149 | 171 |
2033901 | 2033901 | 2021-12-20 | Medina | Texas | 48325 | 7136 | 171 |
2030651 | 2030651 | 2021-12-19 | Medina | Texas | 48325 | 7133 | 171 |
2027400 | 2027400 | 2021-12-18 | Medina | Texas | 48325 | 7131 | 171 |
2024149 | 2024149 | 2021-12-17 | Medina | Texas | 48325 | 7130 | 171 |
2020898 | 2020898 | 2021-12-16 | Medina | Texas | 48325 | 7127 | 170 |
2017647 | 2017647 | 2021-12-15 | Medina | Texas | 48325 | 7123 | 170 |
2014397 | 2014397 | 2021-12-14 | Medina | Texas | 48325 | 7122 | 170 |
2011146 | 2011146 | 2021-12-13 | Medina | Texas | 48325 | 7117 | 170 |
2007895 | 2007895 | 2021-12-12 | Medina | Texas | 48325 | 7116 | 170 |
2004644 | 2004644 | 2021-12-11 | Medina | Texas | 48325 | 7112 | 170 |
2001393 | 2001393 | 2021-12-10 | Medina | Texas | 48325 | 7108 | 170 |
1998143 | 1998143 | 2021-12-09 | Medina | Texas | 48325 | 7088 | 170 |
1994892 | 1994892 | 2021-12-08 | Medina | Texas | 48325 | 7084 | 170 |
1991641 | 1991641 | 2021-12-07 | Medina | Texas | 48325 | 7081 | 170 |
1988390 | 1988390 | 2021-12-06 | Medina | Texas | 48325 | 7075 | 170 |
1985140 | 1985140 | 2021-12-05 | Medina | Texas | 48325 | 7073 | 170 |
1981890 | 1981890 | 2021-12-04 | Medina | Texas | 48325 | 7069 | 170 |
1978640 | 1978640 | 2021-12-03 | Medina | Texas | 48325 | 7063 | 170 |
1975390 | 1975390 | 2021-12-02 | Medina | Texas | 48325 | 7058 | 170 |
1972141 | 1972141 | 2021-12-01 | Medina | Texas | 48325 | 7057 | 170 |
1968891 | 1968891 | 2021-11-30 | Medina | Texas | 48325 | 7054 | 169 |
1965640 | 1965640 | 2021-11-29 | Medina | Texas | 48325 | 7018 | 169 |
1962388 | 1962388 | 2021-11-28 | Medina | Texas | 48325 | 7018 | 168 |
1959137 | 1959137 | 2021-11-27 | Medina | Texas | 48325 | 7018 | 168 |
1955886 | 1955886 | 2021-11-26 | Medina | Texas | 48325 | 7018 | 168 |
1952635 | 1952635 | 2021-11-25 | Medina | Texas | 48325 | 7018 | 168 |
1949384 | 1949384 | 2021-11-24 | Medina | Texas | 48325 | 7018 | 168 |
1946133 | 1946133 | 2021-11-23 | Medina | Texas | 48325 | 7020 | 168 |
1942882 | 1942882 | 2021-11-22 | Medina | Texas | 48325 | 7020 | 167 |
1939632 | 1939632 | 2021-11-21 | Medina | Texas | 48325 | 6995 | 167 |
1936382 | 1936382 | 2021-11-20 | Medina | Texas | 48325 | 6995 | 167 |
1933132 | 1933132 | 2021-11-19 | Medina | Texas | 48325 | 6995 | 167 |
1929881 | 1929881 | 2021-11-18 | Medina | Texas | 48325 | 6968 | 167 |
1926631 | 1926631 | 2021-11-17 | Medina | Texas | 48325 | 6970 | 166 |
1923381 | 1923381 | 2021-11-16 | Medina | Texas | 48325 | 6954 | 166 |
1920132 | 1920132 | 2021-11-15 | Medina | Texas | 48325 | 6939 | 166 |
1916882 | 1916882 | 2021-11-14 | Medina | Texas | 48325 | 6939 | 166 |
1913632 | 1913632 | 2021-11-13 | Medina | Texas | 48325 | 6939 | 166 |
1910382 | 1910382 | 2021-11-12 | Medina | Texas | 48325 | 6939 | 166 |
1907133 | 1907133 | 2021-11-11 | Medina | Texas | 48325 | 6927 | 166 |
1903884 | 1903884 | 2021-11-10 | Medina | Texas | 48325 | 6927 | 166 |
1900634 | 1900634 | 2021-11-09 | Medina | Texas | 48325 | 6927 | 166 |
1897384 | 1897384 | 2021-11-08 | Medina | Texas | 48325 | 6930 | 166 |
1894134 | 1894134 | 2021-11-07 | Medina | Texas | 48325 | 6931 | 166 |
1890884 | 1890884 | 2021-11-06 | Medina | Texas | 48325 | 6931 | 166 |
1887634 | 1887634 | 2021-11-05 | Medina | Texas | 48325 | 6931 | 165 |
1884384 | 1884384 | 2021-11-04 | Medina | Texas | 48325 | 6929 | 165 |
1881135 | 1881135 | 2021-11-03 | Medina | Texas | 48325 | 6929 | 165 |
1877886 | 1877886 | 2021-11-02 | Medina | Texas | 48325 | 6935 | 165 |
1874637 | 1874637 | 2021-11-01 | Medina | Texas | 48325 | 6936 | 165 |
1871388 | 1871388 | 2021-10-31 | Medina | Texas | 48325 | 6935 | 165 |
1868139 | 1868139 | 2021-10-30 | Medina | Texas | 48325 | 6935 | 165 |
1864890 | 1864890 | 2021-10-29 | Medina | Texas | 48325 | 6935 | 165 |
1861641 | 1861641 | 2021-10-28 | Medina | Texas | 48325 | 6931 | 165 |
1858392 | 1858392 | 2021-10-27 | Medina | Texas | 48325 | 6908 | 164 |
1855143 | 1855143 | 2021-10-26 | Medina | Texas | 48325 | 6908 | 163 |
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);