ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
323 rows where deaths = 114 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2241994 | 2241994 | 2022-02-22 | Kendall | Texas | 48259 | 7904 | 114 |
2238743 | 2238743 | 2022-02-21 | Kendall | Texas | 48259 | 7894 | 114 |
2235492 | 2235492 | 2022-02-20 | Kendall | Texas | 48259 | 7890 | 114 |
2232241 | 2232241 | 2022-02-19 | Kendall | Texas | 48259 | 7888 | 114 |
2199664 | 2199664 | 2022-02-09 | Erath | Texas | 48143 | 8274 | 114 |
2196410 | 2196410 | 2022-02-08 | Erath | Texas | 48143 | 8245 | 114 |
2193156 | 2193156 | 2022-02-07 | Erath | Texas | 48143 | 8220 | 114 |
2193177 | 2193177 | 2022-02-07 | Grimes | Texas | 48185 | 8224 | 114 |
2193253 | 2193253 | 2022-02-07 | Montague | Texas | 48337 | 4504 | 114 |
2189902 | 2189902 | 2022-02-06 | Erath | Texas | 48143 | 8215 | 114 |
2189923 | 2189923 | 2022-02-06 | Grimes | Texas | 48185 | 8214 | 114 |
2189999 | 2189999 | 2022-02-06 | Montague | Texas | 48337 | 4497 | 114 |
2186649 | 2186649 | 2022-02-05 | Erath | Texas | 48143 | 8202 | 114 |
2186670 | 2186670 | 2022-02-05 | Grimes | Texas | 48185 | 8178 | 114 |
2186746 | 2186746 | 2022-02-05 | Montague | Texas | 48337 | 4476 | 114 |
2183397 | 2183397 | 2022-02-04 | Erath | Texas | 48143 | 8188 | 114 |
2183418 | 2183418 | 2022-02-04 | Grimes | Texas | 48185 | 8151 | 114 |
2183494 | 2183494 | 2022-02-04 | Montague | Texas | 48337 | 4457 | 114 |
2180145 | 2180145 | 2022-02-03 | Erath | Texas | 48143 | 8157 | 114 |
2180166 | 2180166 | 2022-02-03 | Grimes | Texas | 48185 | 8108 | 114 |
2180242 | 2180242 | 2022-02-03 | Montague | Texas | 48337 | 4433 | 114 |
2176894 | 2176894 | 2022-02-02 | Erath | Texas | 48143 | 8126 | 114 |
2176915 | 2176915 | 2022-02-02 | Grimes | Texas | 48185 | 8083 | 114 |
2177047 | 2177047 | 2022-02-02 | Titus | Texas | 48449 | 7946 | 114 |
2173793 | 2173793 | 2022-02-01 | Titus | Texas | 48449 | 7912 | 114 |
2147588 | 2147588 | 2022-01-24 | Cooke | Texas | 48097 | 6652 | 114 |
2144334 | 2144334 | 2022-01-23 | Cooke | Texas | 48097 | 6632 | 114 |
2141079 | 2141079 | 2022-01-22 | Cooke | Texas | 48097 | 6603 | 114 |
2137823 | 2137823 | 2022-01-21 | Cooke | Texas | 48097 | 6548 | 114 |
2137957 | 2137957 | 2022-01-21 | Panola | Texas | 48365 | 3895 | 114 |
2134569 | 2134569 | 2022-01-20 | Cooke | Texas | 48097 | 6497 | 114 |
2131317 | 2131317 | 2022-01-19 | Cooke | Texas | 48097 | 6434 | 114 |
2128063 | 2128063 | 2022-01-18 | Cooke | Texas | 48097 | 6383 | 114 |
2124811 | 2124811 | 2022-01-17 | Cooke | Texas | 48097 | 6342 | 114 |
2121559 | 2121559 | 2022-01-16 | Cooke | Texas | 48097 | 6310 | 114 |
2118307 | 2118307 | 2022-01-15 | Cooke | Texas | 48097 | 6246 | 114 |
2115056 | 2115056 | 2022-01-14 | Cooke | Texas | 48097 | 6172 | 114 |
2111804 | 2111804 | 2022-01-13 | Cooke | Texas | 48097 | 5907 | 114 |
2112000 | 2112000 | 2022-01-13 | Willacy | Texas | 48489 | 5266 | 114 |
2108552 | 2108552 | 2022-01-12 | Cooke | Texas | 48097 | 5833 | 114 |
2108748 | 2108748 | 2022-01-12 | Willacy | Texas | 48489 | 5233 | 114 |
2105301 | 2105301 | 2022-01-11 | Cooke | Texas | 48097 | 5805 | 114 |
2105497 | 2105497 | 2022-01-11 | Willacy | Texas | 48489 | 5199 | 114 |
2102050 | 2102050 | 2022-01-10 | Cooke | Texas | 48097 | 5756 | 114 |
2102246 | 2102246 | 2022-01-10 | Willacy | Texas | 48489 | 5178 | 114 |
2098799 | 2098799 | 2022-01-09 | Cooke | Texas | 48097 | 5725 | 114 |
2098995 | 2098995 | 2022-01-09 | Willacy | Texas | 48489 | 5164 | 114 |
2095743 | 2095743 | 2022-01-08 | Willacy | Texas | 48489 | 5142 | 114 |
2092363 | 2092363 | 2022-01-07 | Hutchinson | Texas | 48233 | 4542 | 114 |
2092456 | 2092456 | 2022-01-07 | Shelby | Texas | 48419 | 3274 | 114 |
2092491 | 2092491 | 2022-01-07 | Willacy | Texas | 48489 | 5120 | 114 |
2089111 | 2089111 | 2022-01-06 | Hutchinson | Texas | 48233 | 4504 | 114 |
2089204 | 2089204 | 2022-01-06 | Shelby | Texas | 48419 | 3227 | 114 |
2089239 | 2089239 | 2022-01-06 | Willacy | Texas | 48489 | 5108 | 114 |
2085953 | 2085953 | 2022-01-05 | Shelby | Texas | 48419 | 3204 | 114 |
2085988 | 2085988 | 2022-01-05 | Willacy | Texas | 48489 | 5096 | 114 |
2082701 | 2082701 | 2022-01-04 | Shelby | Texas | 48419 | 3190 | 114 |
2082736 | 2082736 | 2022-01-04 | Willacy | Texas | 48489 | 5082 | 114 |
2079449 | 2079449 | 2022-01-03 | Shelby | Texas | 48419 | 3159 | 114 |
2079484 | 2079484 | 2022-01-03 | Willacy | Texas | 48489 | 5053 | 114 |
2076198 | 2076198 | 2022-01-02 | Shelby | Texas | 48419 | 3077 | 114 |
2076233 | 2076233 | 2022-01-02 | Willacy | Texas | 48489 | 5003 | 114 |
2072947 | 2072947 | 2022-01-01 | Shelby | Texas | 48419 | 3077 | 114 |
2072982 | 2072982 | 2022-01-01 | Willacy | Texas | 48489 | 5003 | 114 |
2069696 | 2069696 | 2021-12-31 | Shelby | Texas | 48419 | 3077 | 114 |
2069731 | 2069731 | 2021-12-31 | Willacy | Texas | 48489 | 5003 | 114 |
2066445 | 2066445 | 2021-12-30 | Shelby | Texas | 48419 | 3077 | 114 |
2066480 | 2066480 | 2021-12-30 | Willacy | Texas | 48489 | 5003 | 114 |
2063195 | 2063195 | 2021-12-29 | Shelby | Texas | 48419 | 3060 | 114 |
2063230 | 2063230 | 2021-12-29 | Willacy | Texas | 48489 | 5000 | 114 |
2059945 | 2059945 | 2021-12-28 | Shelby | Texas | 48419 | 3039 | 114 |
2059980 | 2059980 | 2021-12-28 | Willacy | Texas | 48489 | 4998 | 114 |
2056696 | 2056696 | 2021-12-27 | Shelby | Texas | 48419 | 3030 | 114 |
2056731 | 2056731 | 2021-12-27 | Willacy | Texas | 48489 | 4996 | 114 |
2053447 | 2053447 | 2021-12-26 | Shelby | Texas | 48419 | 3018 | 114 |
2053482 | 2053482 | 2021-12-26 | Willacy | Texas | 48489 | 4982 | 114 |
2050197 | 2050197 | 2021-12-25 | Shelby | Texas | 48419 | 3018 | 114 |
2050232 | 2050232 | 2021-12-25 | Willacy | Texas | 48489 | 4982 | 114 |
2046947 | 2046947 | 2021-12-24 | Shelby | Texas | 48419 | 3018 | 114 |
2046982 | 2046982 | 2021-12-24 | Willacy | Texas | 48489 | 4982 | 114 |
2043697 | 2043697 | 2021-12-23 | Shelby | Texas | 48419 | 3018 | 114 |
2043732 | 2043732 | 2021-12-23 | Willacy | Texas | 48489 | 4982 | 114 |
2040448 | 2040448 | 2021-12-22 | Shelby | Texas | 48419 | 3017 | 114 |
2040483 | 2040483 | 2021-12-22 | Willacy | Texas | 48489 | 4981 | 114 |
2037198 | 2037198 | 2021-12-21 | Shelby | Texas | 48419 | 3014 | 114 |
2037233 | 2037233 | 2021-12-21 | Willacy | Texas | 48489 | 4975 | 114 |
2033983 | 2033983 | 2021-12-20 | Willacy | Texas | 48489 | 4973 | 114 |
2030733 | 2030733 | 2021-12-19 | Willacy | Texas | 48489 | 4970 | 114 |
2027482 | 2027482 | 2021-12-18 | Willacy | Texas | 48489 | 4968 | 114 |
2024231 | 2024231 | 2021-12-17 | Willacy | Texas | 48489 | 4967 | 114 |
2020980 | 2020980 | 2021-12-16 | Willacy | Texas | 48489 | 4967 | 114 |
2017729 | 2017729 | 2021-12-15 | Willacy | Texas | 48489 | 4965 | 114 |
2014479 | 2014479 | 2021-12-14 | Willacy | Texas | 48489 | 4965 | 114 |
2011228 | 2011228 | 2021-12-13 | Willacy | Texas | 48489 | 4960 | 114 |
2007977 | 2007977 | 2021-12-12 | Willacy | Texas | 48489 | 4959 | 114 |
2004726 | 2004726 | 2021-12-11 | Willacy | Texas | 48489 | 4959 | 114 |
2001475 | 2001475 | 2021-12-10 | Willacy | Texas | 48489 | 4944 | 114 |
1998225 | 1998225 | 2021-12-09 | Willacy | Texas | 48489 | 4924 | 114 |
1994974 | 1994974 | 2021-12-08 | Willacy | Texas | 48489 | 4924 | 114 |
1991723 | 1991723 | 2021-12-07 | Willacy | Texas | 48489 | 4924 | 114 |
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);