ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
278 rows where deaths = 116 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2313548 | 2313548 | 2022-03-16 | Lavaca | Texas | 48285 | 4174 | 116 |
2294022 | 2294022 | 2022-03-10 | Kendall | Texas | 48259 | 8060 | 116 |
2290770 | 2290770 | 2022-03-09 | Kendall | Texas | 48259 | 8045 | 116 |
2287518 | 2287518 | 2022-03-08 | Kendall | Texas | 48259 | 8037 | 116 |
2284266 | 2284266 | 2022-03-07 | Kendall | Texas | 48259 | 8024 | 116 |
2281014 | 2281014 | 2022-03-06 | Kendall | Texas | 48259 | 8023 | 116 |
2271218 | 2271218 | 2022-03-03 | Grimes | Texas | 48185 | 8415 | 116 |
2267966 | 2267966 | 2022-03-02 | Grimes | Texas | 48185 | 8410 | 116 |
2264713 | 2264713 | 2022-03-01 | Grimes | Texas | 48185 | 8409 | 116 |
2261463 | 2261463 | 2022-02-28 | Grimes | Texas | 48185 | 8403 | 116 |
2258212 | 2258212 | 2022-02-27 | Grimes | Texas | 48185 | 8402 | 116 |
2254961 | 2254961 | 2022-02-26 | Grimes | Texas | 48185 | 8401 | 116 |
2251710 | 2251710 | 2022-02-25 | Grimes | Texas | 48185 | 8396 | 116 |
2248459 | 2248459 | 2022-02-24 | Grimes | Texas | 48185 | 8391 | 116 |
2248507 | 2248507 | 2022-02-24 | Lamb | Texas | 48279 | 4264 | 116 |
2245208 | 2245208 | 2022-02-23 | Grimes | Texas | 48185 | 8390 | 116 |
2245256 | 2245256 | 2022-02-23 | Lamb | Texas | 48279 | 4264 | 116 |
2241957 | 2241957 | 2022-02-22 | Grimes | Texas | 48185 | 8383 | 116 |
2242005 | 2242005 | 2022-02-22 | Lamb | Texas | 48279 | 4256 | 116 |
2238706 | 2238706 | 2022-02-21 | Grimes | Texas | 48185 | 8375 | 116 |
2238754 | 2238754 | 2022-02-21 | Lamb | Texas | 48279 | 4256 | 116 |
2235455 | 2235455 | 2022-02-20 | Grimes | Texas | 48185 | 8374 | 116 |
2235503 | 2235503 | 2022-02-20 | Lamb | Texas | 48279 | 4256 | 116 |
2232204 | 2232204 | 2022-02-19 | Grimes | Texas | 48185 | 8373 | 116 |
2232252 | 2232252 | 2022-02-19 | Lamb | Texas | 48279 | 4256 | 116 |
2228932 | 2228932 | 2022-02-18 | Erath | Texas | 48143 | 8417 | 116 |
2228953 | 2228953 | 2022-02-18 | Grimes | Texas | 48185 | 8365 | 116 |
2225681 | 2225681 | 2022-02-17 | Erath | Texas | 48143 | 8403 | 116 |
2225702 | 2225702 | 2022-02-17 | Grimes | Texas | 48185 | 8354 | 116 |
2222430 | 2222430 | 2022-02-16 | Erath | Texas | 48143 | 8386 | 116 |
2222448 | 2222448 | 2022-02-16 | Gray | Texas | 48179 | 5998 | 116 |
2222451 | 2222451 | 2022-02-16 | Grimes | Texas | 48185 | 8349 | 116 |
2219179 | 2219179 | 2022-02-15 | Erath | Texas | 48143 | 8366 | 116 |
2219197 | 2219197 | 2022-02-15 | Gray | Texas | 48179 | 5987 | 116 |
2215928 | 2215928 | 2022-02-14 | Erath | Texas | 48143 | 8354 | 116 |
2215946 | 2215946 | 2022-02-14 | Gray | Texas | 48179 | 5972 | 116 |
2212677 | 2212677 | 2022-02-13 | Erath | Texas | 48143 | 8352 | 116 |
2212695 | 2212695 | 2022-02-13 | Gray | Texas | 48179 | 5969 | 116 |
2209521 | 2209521 | 2022-02-12 | Montague | Texas | 48337 | 4565 | 116 |
2206268 | 2206268 | 2022-02-11 | Montague | Texas | 48337 | 4557 | 116 |
2202993 | 2202993 | 2022-02-10 | Limestone | Texas | 48293 | 4963 | 116 |
2203015 | 2203015 | 2022-02-10 | Montague | Texas | 48337 | 4549 | 116 |
2199739 | 2199739 | 2022-02-09 | Limestone | Texas | 48293 | 4956 | 116 |
2199761 | 2199761 | 2022-02-09 | Montague | Texas | 48337 | 4541 | 116 |
2196485 | 2196485 | 2022-02-08 | Limestone | Texas | 48293 | 4950 | 116 |
2193231 | 2193231 | 2022-02-07 | Limestone | Texas | 48293 | 4942 | 116 |
2189977 | 2189977 | 2022-02-06 | Limestone | Texas | 48293 | 4925 | 116 |
2186724 | 2186724 | 2022-02-05 | Limestone | Texas | 48293 | 4913 | 116 |
2183472 | 2183472 | 2022-02-04 | Limestone | Texas | 48293 | 4895 | 116 |
2183550 | 2183550 | 2022-02-04 | Titus | Texas | 48449 | 8009 | 116 |
2180220 | 2180220 | 2022-02-03 | Limestone | Texas | 48293 | 4882 | 116 |
2176969 | 2176969 | 2022-02-02 | Limestone | Texas | 48293 | 4850 | 116 |
2173715 | 2173715 | 2022-02-01 | Limestone | Texas | 48293 | 4839 | 116 |
2173751 | 2173751 | 2022-02-01 | Panola | Texas | 48365 | 4189 | 116 |
2170463 | 2170463 | 2022-01-31 | Limestone | Texas | 48293 | 4811 | 116 |
2170499 | 2170499 | 2022-01-31 | Panola | Texas | 48365 | 4178 | 116 |
2167209 | 2167209 | 2022-01-30 | Limestone | Texas | 48293 | 4785 | 116 |
2167245 | 2167245 | 2022-01-30 | Panola | Texas | 48365 | 4169 | 116 |
2163954 | 2163954 | 2022-01-29 | Limestone | Texas | 48293 | 4778 | 116 |
2163990 | 2163990 | 2022-01-29 | Panola | Texas | 48365 | 4160 | 116 |
2160699 | 2160699 | 2022-01-28 | Limestone | Texas | 48293 | 4753 | 116 |
2160735 | 2160735 | 2022-01-28 | Panola | Texas | 48365 | 4129 | 116 |
2157443 | 2157443 | 2022-01-27 | Limestone | Texas | 48293 | 4735 | 116 |
2157479 | 2157479 | 2022-01-27 | Panola | Texas | 48365 | 4094 | 116 |
2154092 | 2154092 | 2022-01-26 | Cooke | Texas | 48097 | 6723 | 116 |
2154190 | 2154190 | 2022-01-26 | Limestone | Texas | 48293 | 4711 | 116 |
2154226 | 2154226 | 2022-01-26 | Panola | Texas | 48365 | 4066 | 116 |
2150938 | 2150938 | 2022-01-25 | Limestone | Texas | 48293 | 4681 | 116 |
2150974 | 2150974 | 2022-01-25 | Panola | Texas | 48365 | 4041 | 116 |
2147686 | 2147686 | 2022-01-24 | Limestone | Texas | 48293 | 4662 | 116 |
2144432 | 2144432 | 2022-01-23 | Limestone | Texas | 48293 | 4644 | 116 |
2141177 | 2141177 | 2022-01-22 | Limestone | Texas | 48293 | 4616 | 116 |
2137921 | 2137921 | 2022-01-21 | Limestone | Texas | 48293 | 4566 | 116 |
2134667 | 2134667 | 2022-01-20 | Limestone | Texas | 48293 | 4534 | 116 |
2134766 | 2134766 | 2022-01-20 | Willacy | Texas | 48489 | 5812 | 116 |
2131415 | 2131415 | 2022-01-19 | Limestone | Texas | 48293 | 4479 | 116 |
2131514 | 2131514 | 2022-01-19 | Willacy | Texas | 48489 | 5755 | 116 |
2128161 | 2128161 | 2022-01-18 | Limestone | Texas | 48293 | 4447 | 116 |
2128224 | 2128224 | 2022-01-18 | Shelby | Texas | 48419 | 3771 | 116 |
2128260 | 2128260 | 2022-01-18 | Willacy | Texas | 48489 | 5724 | 116 |
2124909 | 2124909 | 2022-01-17 | Limestone | Texas | 48293 | 4434 | 116 |
2124972 | 2124972 | 2022-01-17 | Shelby | Texas | 48419 | 3741 | 116 |
2125008 | 2125008 | 2022-01-17 | Willacy | Texas | 48489 | 5678 | 116 |
2121657 | 2121657 | 2022-01-16 | Limestone | Texas | 48293 | 4399 | 116 |
2121720 | 2121720 | 2022-01-16 | Shelby | Texas | 48419 | 3665 | 116 |
2121756 | 2121756 | 2022-01-16 | Willacy | Texas | 48489 | 5634 | 116 |
2118405 | 2118405 | 2022-01-15 | Limestone | Texas | 48293 | 4383 | 116 |
2118468 | 2118468 | 2022-01-15 | Shelby | Texas | 48419 | 3646 | 116 |
2118504 | 2118504 | 2022-01-15 | Willacy | Texas | 48489 | 5600 | 116 |
2115252 | 2115252 | 2022-01-14 | Willacy | Texas | 48489 | 5558 | 116 |
2105369 | 2105369 | 2022-01-11 | Hutchinson | Texas | 48233 | 4630 | 116 |
2102118 | 2102118 | 2022-01-10 | Hutchinson | Texas | 48233 | 4601 | 116 |
2098867 | 2098867 | 2022-01-09 | Hutchinson | Texas | 48233 | 4597 | 116 |
2095615 | 2095615 | 2022-01-08 | Hutchinson | Texas | 48233 | 4574 | 116 |
1926700 | 1926700 | 2021-11-17 | Uvalde | Texas | 48463 | 6362 | 116 |
1923450 | 1923450 | 2021-11-16 | Uvalde | Texas | 48463 | 6354 | 116 |
1832261 | 1832261 | 2021-10-19 | Burnet | Texas | 48053 | 7327 | 116 |
1829012 | 1829012 | 2021-10-18 | Burnet | Texas | 48053 | 7323 | 116 |
1773763 | 1773763 | 2021-10-01 | Bee | Texas | 48025 | 5238 | 116 |
1770614 | 1770614 | 2021-09-30 | Howard | Texas | 48227 | 5639 | 116 |
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);