ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
246 rows where deaths = 125 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502296 | 2502296 | 2022-05-13 | Gray | Texas | 48179 | 6195 | 125 |
2499038 | 2499038 | 2022-05-12 | Gray | Texas | 48179 | 6195 | 125 |
2495780 | 2495780 | 2022-05-11 | Gray | Texas | 48179 | 6194 | 125 |
2492522 | 2492522 | 2022-05-10 | Gray | Texas | 48179 | 6194 | 125 |
2489264 | 2489264 | 2022-05-09 | Gray | Texas | 48179 | 6194 | 125 |
2486007 | 2486007 | 2022-05-08 | Gray | Texas | 48179 | 6194 | 125 |
2482749 | 2482749 | 2022-05-07 | Gray | Texas | 48179 | 6194 | 125 |
2479491 | 2479491 | 2022-05-06 | Gray | Texas | 48179 | 6194 | 125 |
2476233 | 2476233 | 2022-05-05 | Gray | Texas | 48179 | 6194 | 125 |
2472976 | 2472976 | 2022-05-04 | Gray | Texas | 48179 | 6194 | 125 |
2469720 | 2469720 | 2022-05-03 | Gray | Texas | 48179 | 6194 | 125 |
2466464 | 2466464 | 2022-05-02 | Gray | Texas | 48179 | 6194 | 125 |
2463209 | 2463209 | 2022-05-01 | Gray | Texas | 48179 | 6194 | 125 |
2459953 | 2459953 | 2022-04-30 | Gray | Texas | 48179 | 6194 | 125 |
2456697 | 2456697 | 2022-04-29 | Gray | Texas | 48179 | 6194 | 125 |
2453441 | 2453441 | 2022-04-28 | Gray | Texas | 48179 | 6193 | 125 |
2450185 | 2450185 | 2022-04-27 | Gray | Texas | 48179 | 6193 | 125 |
2446928 | 2446928 | 2022-04-26 | Gray | Texas | 48179 | 6193 | 125 |
2443673 | 2443673 | 2022-04-25 | Gray | Texas | 48179 | 6193 | 125 |
2440417 | 2440417 | 2022-04-24 | Gray | Texas | 48179 | 6193 | 125 |
2437161 | 2437161 | 2022-04-23 | Gray | Texas | 48179 | 6193 | 125 |
2433905 | 2433905 | 2022-04-22 | Gray | Texas | 48179 | 6193 | 125 |
2430649 | 2430649 | 2022-04-21 | Gray | Texas | 48179 | 6192 | 125 |
2427393 | 2427393 | 2022-04-20 | Gray | Texas | 48179 | 6190 | 125 |
2424137 | 2424137 | 2022-04-19 | Gray | Texas | 48179 | 6187 | 125 |
2420881 | 2420881 | 2022-04-18 | Gray | Texas | 48179 | 6183 | 125 |
2339601 | 2339601 | 2022-03-24 | Montague | Texas | 48337 | 4650 | 125 |
2336347 | 2336347 | 2022-03-23 | Montague | Texas | 48337 | 4649 | 125 |
2333093 | 2333093 | 2022-03-22 | Montague | Texas | 48337 | 4646 | 125 |
2323256 | 2323256 | 2022-03-19 | Gray | Texas | 48179 | 6164 | 125 |
2320002 | 2320002 | 2022-03-18 | Gray | Texas | 48179 | 6160 | 125 |
2297389 | 2297389 | 2022-03-11 | Willacy | Texas | 48489 | 6879 | 125 |
2294137 | 2294137 | 2022-03-10 | Willacy | Texas | 48489 | 6878 | 125 |
2290885 | 2290885 | 2022-03-09 | Willacy | Texas | 48489 | 6872 | 125 |
2287633 | 2287633 | 2022-03-08 | Willacy | Texas | 48489 | 6872 | 125 |
2284381 | 2284381 | 2022-03-07 | Willacy | Texas | 48489 | 6863 | 125 |
2281129 | 2281129 | 2022-03-06 | Willacy | Texas | 48489 | 6848 | 125 |
2277876 | 2277876 | 2022-03-05 | Willacy | Texas | 48489 | 6848 | 125 |
2274623 | 2274623 | 2022-03-04 | Willacy | Texas | 48489 | 6843 | 125 |
2271350 | 2271350 | 2022-03-03 | Titus | Texas | 48449 | 8392 | 125 |
2271370 | 2271370 | 2022-03-03 | Willacy | Texas | 48489 | 6835 | 125 |
2268098 | 2268098 | 2022-03-02 | Titus | Texas | 48449 | 8377 | 125 |
2268118 | 2268118 | 2022-03-02 | Willacy | Texas | 48489 | 6823 | 125 |
2264865 | 2264865 | 2022-03-01 | Willacy | Texas | 48489 | 6806 | 125 |
2261553 | 2261553 | 2022-02-28 | Panola | Texas | 48365 | 4463 | 125 |
2261615 | 2261615 | 2022-02-28 | Willacy | Texas | 48489 | 6792 | 125 |
2258302 | 2258302 | 2022-02-27 | Panola | Texas | 48365 | 4462 | 125 |
2258364 | 2258364 | 2022-02-27 | Willacy | Texas | 48489 | 6791 | 125 |
2255051 | 2255051 | 2022-02-26 | Panola | Texas | 48365 | 4462 | 125 |
2255113 | 2255113 | 2022-02-26 | Willacy | Texas | 48489 | 6789 | 125 |
2251800 | 2251800 | 2022-02-25 | Panola | Texas | 48365 | 4454 | 125 |
2238823 | 2238823 | 2022-02-21 | Shelby | Texas | 48419 | 4296 | 125 |
2235572 | 2235572 | 2022-02-20 | Shelby | Texas | 48419 | 4293 | 125 |
2232321 | 2232321 | 2022-02-19 | Shelby | Texas | 48419 | 4293 | 125 |
2229070 | 2229070 | 2022-02-18 | Shelby | Texas | 48419 | 4280 | 125 |
2225819 | 2225819 | 2022-02-17 | Shelby | Texas | 48419 | 4276 | 125 |
2222568 | 2222568 | 2022-02-16 | Shelby | Texas | 48419 | 4259 | 125 |
2215905 | 2215905 | 2022-02-14 | Cooke | Texas | 48097 | 7068 | 125 |
2212654 | 2212654 | 2022-02-13 | Cooke | Texas | 48097 | 7065 | 125 |
2196570 | 2196570 | 2022-02-08 | Uvalde | Texas | 48463 | 10329 | 125 |
2193316 | 2193316 | 2022-02-07 | Uvalde | Texas | 48463 | 10312 | 125 |
2190063 | 2190063 | 2022-02-06 | Uvalde | Texas | 48463 | 10293 | 125 |
2186810 | 2186810 | 2022-02-05 | Uvalde | Texas | 48463 | 10278 | 125 |
2183557 | 2183557 | 2022-02-04 | Uvalde | Texas | 48463 | 10272 | 125 |
2180305 | 2180305 | 2022-02-03 | Uvalde | Texas | 48463 | 10244 | 125 |
1864754 | 1864754 | 2021-10-29 | Burnet | Texas | 48053 | 7389 | 125 |
1842118 | 1842118 | 2021-10-22 | Kleberg | Texas | 48273 | 4299 | 125 |
1838869 | 1838869 | 2021-10-21 | Kleberg | Texas | 48273 | 4299 | 125 |
1835620 | 1835620 | 2021-10-20 | Kleberg | Texas | 48273 | 4291 | 125 |
1835722 | 1835722 | 2021-10-20 | Washington | Texas | 48477 | 5706 | 125 |
1832371 | 1832371 | 2021-10-19 | Kleberg | Texas | 48273 | 4284 | 125 |
1832473 | 1832473 | 2021-10-19 | Washington | Texas | 48477 | 5702 | 125 |
1829122 | 1829122 | 2021-10-18 | Kleberg | Texas | 48273 | 4283 | 125 |
1829224 | 1829224 | 2021-10-18 | Washington | Texas | 48477 | 5697 | 125 |
1825873 | 1825873 | 2021-10-17 | Kleberg | Texas | 48273 | 4283 | 125 |
1825975 | 1825975 | 2021-10-17 | Washington | Texas | 48477 | 5685 | 125 |
1822624 | 1822624 | 2021-10-16 | Kleberg | Texas | 48273 | 4279 | 125 |
1822726 | 1822726 | 2021-10-16 | Washington | Texas | 48477 | 5685 | 125 |
1819375 | 1819375 | 2021-10-15 | Kleberg | Texas | 48273 | 4272 | 125 |
1816126 | 1816126 | 2021-10-14 | Kleberg | Texas | 48273 | 4272 | 125 |
1816219 | 1816219 | 2021-10-14 | Upshur | Texas | 48459 | 5738 | 125 |
1812878 | 1812878 | 2021-10-13 | Kleberg | Texas | 48273 | 4266 | 125 |
1812971 | 1812971 | 2021-10-13 | Upshur | Texas | 48459 | 5730 | 125 |
1809625 | 1809625 | 2021-10-12 | Kerr | Texas | 48265 | 6425 | 125 |
1809629 | 1809629 | 2021-10-12 | Kleberg | Texas | 48273 | 4260 | 125 |
1806375 | 1806375 | 2021-10-11 | Kerr | Texas | 48265 | 6406 | 125 |
1803125 | 1803125 | 2021-10-10 | Kerr | Texas | 48265 | 6389 | 125 |
1799876 | 1799876 | 2021-10-09 | Kerr | Texas | 48265 | 6389 | 125 |
1799880 | 1799880 | 2021-10-09 | Kleberg | Texas | 48273 | 4251 | 125 |
1796627 | 1796627 | 2021-10-08 | Kerr | Texas | 48265 | 6389 | 125 |
1796631 | 1796631 | 2021-10-08 | Kleberg | Texas | 48273 | 4249 | 125 |
1793382 | 1793382 | 2021-10-07 | Kleberg | Texas | 48273 | 4239 | 125 |
1790110 | 1790110 | 2021-10-06 | Howard | Texas | 48227 | 5685 | 125 |
1790133 | 1790133 | 2021-10-06 | Kleberg | Texas | 48273 | 4233 | 125 |
1786862 | 1786862 | 2021-10-05 | Howard | Texas | 48227 | 5662 | 125 |
1786885 | 1786885 | 2021-10-05 | Kleberg | Texas | 48273 | 4228 | 125 |
1783636 | 1783636 | 2021-10-04 | Kleberg | Texas | 48273 | 4223 | 125 |
1780387 | 1780387 | 2021-10-03 | Kleberg | Texas | 48273 | 4223 | 125 |
1777137 | 1777137 | 2021-10-02 | Kleberg | Texas | 48273 | 4219 | 125 |
1770534 | 1770534 | 2021-09-30 | Cass | Texas | 48067 | 4240 | 125 |
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);