ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
227 rows where deaths = 106 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2342922 | 2342922 | 2022-03-25 | Waller | Texas | 48473 | 9478 | 106 |
2339669 | 2339669 | 2022-03-24 | Waller | Texas | 48473 | 9475 | 106 |
2313491 | 2313491 | 2022-03-16 | Gillespie | Texas | 48171 | 5313 | 106 |
2310238 | 2310238 | 2022-03-15 | Gillespie | Texas | 48171 | 5312 | 106 |
2297230 | 2297230 | 2022-03-11 | Gillespie | Texas | 48171 | 5305 | 106 |
2293978 | 2293978 | 2022-03-10 | Gillespie | Texas | 48171 | 5304 | 106 |
2290726 | 2290726 | 2022-03-09 | Gillespie | Texas | 48171 | 5303 | 106 |
2287474 | 2287474 | 2022-03-08 | Gillespie | Texas | 48171 | 5300 | 106 |
2280970 | 2280970 | 2022-03-06 | Gillespie | Texas | 48171 | 5291 | 106 |
2274491 | 2274491 | 2022-03-04 | Houston | Texas | 48225 | 3974 | 106 |
2271211 | 2271211 | 2022-03-03 | Gillespie | Texas | 48171 | 5285 | 106 |
2271238 | 2271238 | 2022-03-03 | Houston | Texas | 48225 | 3964 | 106 |
2267986 | 2267986 | 2022-03-02 | Houston | Texas | 48225 | 3955 | 106 |
2264733 | 2264733 | 2022-03-01 | Houston | Texas | 48225 | 3951 | 106 |
2261483 | 2261483 | 2022-02-28 | Houston | Texas | 48225 | 3939 | 106 |
2258232 | 2258232 | 2022-02-27 | Houston | Texas | 48225 | 3938 | 106 |
2254981 | 2254981 | 2022-02-26 | Houston | Texas | 48225 | 3937 | 106 |
2251730 | 2251730 | 2022-02-25 | Houston | Texas | 48225 | 3919 | 106 |
2245182 | 2245182 | 2022-02-23 | Eastland | Texas | 48133 | 2741 | 106 |
2222418 | 2222418 | 2022-02-16 | Deaf Smith | Texas | 48117 | 4343 | 106 |
2222529 | 2222529 | 2022-02-16 | Moore | Texas | 48341 | 5259 | 106 |
2219167 | 2219167 | 2022-02-15 | Deaf Smith | Texas | 48117 | 4334 | 106 |
2219278 | 2219278 | 2022-02-15 | Moore | Texas | 48341 | 5236 | 106 |
2216027 | 2216027 | 2022-02-14 | Moore | Texas | 48341 | 5224 | 106 |
2212776 | 2212776 | 2022-02-13 | Moore | Texas | 48341 | 5224 | 106 |
2193120 | 2193120 | 2022-02-07 | Chambers | Texas | 48071 | 11430 | 106 |
2193227 | 2193227 | 2022-02-07 | Lavaca | Texas | 48285 | 4095 | 106 |
2189866 | 2189866 | 2022-02-06 | Chambers | Texas | 48071 | 11382 | 106 |
2189973 | 2189973 | 2022-02-06 | Lavaca | Texas | 48285 | 4094 | 106 |
2186613 | 2186613 | 2022-02-05 | Chambers | Texas | 48071 | 11382 | 106 |
2186720 | 2186720 | 2022-02-05 | Lavaca | Texas | 48285 | 4090 | 106 |
2183361 | 2183361 | 2022-02-04 | Chambers | Texas | 48071 | 11382 | 106 |
2183468 | 2183468 | 2022-02-04 | Lavaca | Texas | 48285 | 4053 | 106 |
2180109 | 2180109 | 2022-02-03 | Chambers | Texas | 48071 | 11354 | 106 |
2180216 | 2180216 | 2022-02-03 | Lavaca | Texas | 48285 | 4049 | 106 |
2176858 | 2176858 | 2022-02-02 | Chambers | Texas | 48071 | 11326 | 106 |
2176965 | 2176965 | 2022-02-02 | Lavaca | Texas | 48285 | 4038 | 106 |
2173604 | 2173604 | 2022-02-01 | Chambers | Texas | 48071 | 11272 | 106 |
2173698 | 2173698 | 2022-02-01 | Kendall | Texas | 48259 | 7511 | 106 |
2173711 | 2173711 | 2022-02-01 | Lavaca | Texas | 48285 | 4030 | 106 |
2170352 | 2170352 | 2022-01-31 | Chambers | Texas | 48071 | 11231 | 106 |
2170446 | 2170446 | 2022-01-31 | Kendall | Texas | 48259 | 7450 | 106 |
2170459 | 2170459 | 2022-01-31 | Lavaca | Texas | 48285 | 4026 | 106 |
2167192 | 2167192 | 2022-01-30 | Kendall | Texas | 48259 | 7413 | 106 |
2163937 | 2163937 | 2022-01-29 | Kendall | Texas | 48259 | 7383 | 106 |
2160682 | 2160682 | 2022-01-28 | Kendall | Texas | 48259 | 7320 | 106 |
2154212 | 2154212 | 2022-01-26 | Montague | Texas | 48337 | 4243 | 106 |
2150960 | 2150960 | 2022-01-25 | Montague | Texas | 48337 | 4220 | 106 |
2147708 | 2147708 | 2022-01-24 | Montague | Texas | 48337 | 4199 | 106 |
2144454 | 2144454 | 2022-01-23 | Montague | Texas | 48337 | 4171 | 106 |
2141199 | 2141199 | 2022-01-22 | Montague | Texas | 48337 | 4117 | 106 |
2134610 | 2134610 | 2022-01-20 | Gray | Texas | 48179 | 5553 | 106 |
2131358 | 2131358 | 2022-01-19 | Gray | Texas | 48179 | 5525 | 106 |
2128104 | 2128104 | 2022-01-18 | Gray | Texas | 48179 | 5468 | 106 |
2124852 | 2124852 | 2022-01-17 | Gray | Texas | 48179 | 5435 | 106 |
2121600 | 2121600 | 2022-01-16 | Gray | Texas | 48179 | 5422 | 106 |
2085968 | 2085968 | 2022-01-05 | Titus | Texas | 48449 | 6359 | 106 |
2082716 | 2082716 | 2022-01-04 | Titus | Texas | 48449 | 6305 | 106 |
2059852 | 2059852 | 2021-12-28 | Hutchinson | Texas | 48233 | 4392 | 106 |
2056603 | 2056603 | 2021-12-27 | Hutchinson | Texas | 48233 | 4371 | 106 |
2040287 | 2040287 | 2021-12-22 | Cooke | Texas | 48097 | 5315 | 106 |
2037037 | 2037037 | 2021-12-21 | Cooke | Texas | 48097 | 5314 | 106 |
2033787 | 2033787 | 2021-12-20 | Cooke | Texas | 48097 | 5309 | 106 |
2030537 | 2030537 | 2021-12-19 | Cooke | Texas | 48097 | 5304 | 106 |
2027286 | 2027286 | 2021-12-18 | Cooke | Texas | 48097 | 5301 | 106 |
2024035 | 2024035 | 2021-12-17 | Cooke | Texas | 48097 | 5294 | 106 |
2020784 | 2020784 | 2021-12-16 | Cooke | Texas | 48097 | 5285 | 106 |
2017533 | 2017533 | 2021-12-15 | Cooke | Texas | 48097 | 5269 | 106 |
1975299 | 1975299 | 2021-12-02 | Erath | Texas | 48143 | 6446 | 106 |
1972050 | 1972050 | 2021-12-01 | Erath | Texas | 48143 | 6445 | 106 |
1968800 | 1968800 | 2021-11-30 | Erath | Texas | 48143 | 6444 | 106 |
1965549 | 1965549 | 2021-11-29 | Erath | Texas | 48143 | 6436 | 106 |
1868069 | 1868069 | 2021-10-30 | Grimes | Texas | 48185 | 5164 | 106 |
1864820 | 1864820 | 2021-10-29 | Grimes | Texas | 48185 | 5160 | 106 |
1861571 | 1861571 | 2021-10-28 | Grimes | Texas | 48185 | 5158 | 106 |
1858322 | 1858322 | 2021-10-27 | Grimes | Texas | 48185 | 5158 | 106 |
1842213 | 1842213 | 2021-10-22 | Uvalde | Texas | 48463 | 6312 | 106 |
1822697 | 1822697 | 2021-10-16 | Shelby | Texas | 48419 | 2911 | 106 |
1819448 | 1819448 | 2021-10-15 | Shelby | Texas | 48419 | 2910 | 106 |
1816172 | 1816172 | 2021-10-14 | Panola | Texas | 48365 | 2930 | 106 |
1812924 | 1812924 | 2021-10-13 | Panola | Texas | 48365 | 2929 | 106 |
1806389 | 1806389 | 2021-10-11 | Limestone | Texas | 48293 | 3590 | 106 |
1803139 | 1803139 | 2021-10-10 | Limestone | Texas | 48293 | 3580 | 106 |
1799890 | 1799890 | 2021-10-09 | Limestone | Texas | 48293 | 3580 | 106 |
1796739 | 1796739 | 2021-10-08 | Willacy | Texas | 48489 | 4541 | 106 |
1773932 | 1773932 | 2021-10-01 | Palo Pinto | Texas | 48363 | 4508 | 106 |
1770527 | 1770527 | 2021-09-30 | Burnet | Texas | 48053 | 7161 | 106 |
1767278 | 1767278 | 2021-09-29 | Burnet | Texas | 48053 | 7149 | 106 |
1744523 | 1744523 | 2021-09-22 | Bee | Texas | 48025 | 5123 | 106 |
1738259 | 1738259 | 2021-09-20 | Wilson | Texas | 48493 | 6848 | 106 |
1735009 | 1735009 | 2021-09-19 | Wilson | Texas | 48493 | 6740 | 106 |
1702411 | 1702411 | 2021-09-09 | Kerr | Texas | 48265 | 5742 | 106 |
1702517 | 1702517 | 2021-09-09 | Washington | Texas | 48477 | 5165 | 106 |
1699162 | 1699162 | 2021-09-08 | Kerr | Texas | 48265 | 5668 | 106 |
1695815 | 1695815 | 2021-09-07 | Cass | Texas | 48067 | 3573 | 106 |
1695914 | 1695914 | 2021-09-07 | Kerr | Texas | 48265 | 5534 | 106 |
1695918 | 1695918 | 2021-09-07 | Kleberg | Texas | 48273 | 3897 | 106 |
1692567 | 1692567 | 2021-09-06 | Cass | Texas | 48067 | 3542 | 106 |
1692666 | 1692666 | 2021-09-06 | Kerr | Texas | 48265 | 5534 | 106 |
1692670 | 1692670 | 2021-09-06 | Kleberg | Texas | 48273 | 3897 | 106 |
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);