ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
324 rows where deaths = 103 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Medina 55
- Hockley 52
- Howard 20
- Scurry 14
- Van Zandt 13
- Kendall 12
- Polk 11
- Deaf Smith 8
- Jim Wells 7
- Willacy 6
- Cooke 5
- Gregg 5
- Matagorda 5
- Walker 5
- Caldwell 4
- Cherokee 4
- Coryell 4
- Hutchinson 4
- Orange 4
- Waller 4
- Williamson 4
- Anderson 3
- Bee 3
- Gillespie 3
- Hood 3
- Houston 3
- Midland 3
- Taylor 3
- Wharton 3
- Angelina 2
- …
state 1
- Texas · 324 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2420999 | 2420999 | 2022-04-18 | Scurry | Texas | 48415 | 4973 | 103 |
2417743 | 2417743 | 2022-04-17 | Scurry | Texas | 48415 | 4970 | 103 |
2414487 | 2414487 | 2022-04-16 | Scurry | Texas | 48415 | 4970 | 103 |
2411231 | 2411231 | 2022-04-15 | Scurry | Texas | 48415 | 4970 | 103 |
2407975 | 2407975 | 2022-04-14 | Scurry | Texas | 48415 | 4970 | 103 |
2404719 | 2404719 | 2022-04-13 | Scurry | Texas | 48415 | 4968 | 103 |
2401464 | 2401464 | 2022-04-12 | Scurry | Texas | 48415 | 4968 | 103 |
2398209 | 2398209 | 2022-04-11 | Scurry | Texas | 48415 | 4968 | 103 |
2394954 | 2394954 | 2022-04-10 | Scurry | Texas | 48415 | 4968 | 103 |
2391698 | 2391698 | 2022-04-09 | Scurry | Texas | 48415 | 4968 | 103 |
2388442 | 2388442 | 2022-04-08 | Scurry | Texas | 48415 | 4968 | 103 |
2385187 | 2385187 | 2022-04-07 | Scurry | Texas | 48415 | 4966 | 103 |
2381932 | 2381932 | 2022-04-06 | Scurry | Texas | 48415 | 4964 | 103 |
2378677 | 2378677 | 2022-04-05 | Scurry | Texas | 48415 | 4964 | 103 |
2332999 | 2332999 | 2022-03-22 | Fayette | Texas | 48149 | 4751 | 103 |
2310389 | 2310389 | 2022-03-15 | Waller | Texas | 48473 | 9387 | 103 |
2307136 | 2307136 | 2022-03-14 | Waller | Texas | 48473 | 9386 | 103 |
2303885 | 2303885 | 2022-03-13 | Waller | Texas | 48473 | 9384 | 103 |
2300633 | 2300633 | 2022-03-12 | Waller | Texas | 48473 | 9382 | 103 |
2245201 | 2245201 | 2022-02-23 | Gillespie | Texas | 48171 | 5200 | 103 |
2241950 | 2241950 | 2022-02-22 | Gillespie | Texas | 48171 | 5185 | 103 |
2238699 | 2238699 | 2022-02-21 | Gillespie | Texas | 48171 | 5176 | 103 |
2235475 | 2235475 | 2022-02-20 | Houston | Texas | 48225 | 3896 | 103 |
2232224 | 2232224 | 2022-02-19 | Houston | Texas | 48225 | 3896 | 103 |
2228973 | 2228973 | 2022-02-18 | Houston | Texas | 48225 | 3888 | 103 |
2160693 | 2160693 | 2022-01-28 | Lamb | Texas | 48279 | 4163 | 103 |
2157437 | 2157437 | 2022-01-27 | Lamb | Texas | 48279 | 4156 | 103 |
2157439 | 2157439 | 2022-01-27 | Lavaca | Texas | 48285 | 3979 | 103 |
2157467 | 2157467 | 2022-01-27 | Moore | Texas | 48341 | 4927 | 103 |
2154214 | 2154214 | 2022-01-26 | Moore | Texas | 48341 | 4909 | 103 |
2150851 | 2150851 | 2022-01-25 | Deaf Smith | Texas | 48117 | 3987 | 103 |
2147599 | 2147599 | 2022-01-24 | Deaf Smith | Texas | 48117 | 3973 | 103 |
2144345 | 2144345 | 2022-01-23 | Deaf Smith | Texas | 48117 | 3961 | 103 |
2141090 | 2141090 | 2022-01-22 | Deaf Smith | Texas | 48117 | 3950 | 103 |
2137834 | 2137834 | 2022-01-21 | Deaf Smith | Texas | 48117 | 3930 | 103 |
2134580 | 2134580 | 2022-01-20 | Deaf Smith | Texas | 48117 | 3891 | 103 |
2131328 | 2131328 | 2022-01-19 | Deaf Smith | Texas | 48117 | 3874 | 103 |
2128074 | 2128074 | 2022-01-18 | Deaf Smith | Texas | 48117 | 3852 | 103 |
2115137 | 2115137 | 2022-01-14 | Kendall | Texas | 48259 | 6459 | 103 |
2111885 | 2111885 | 2022-01-13 | Kendall | Texas | 48259 | 6028 | 103 |
2108593 | 2108593 | 2022-01-12 | Gray | Texas | 48179 | 4638 | 103 |
2108633 | 2108633 | 2022-01-12 | Kendall | Texas | 48259 | 5962 | 103 |
2105382 | 2105382 | 2022-01-11 | Kendall | Texas | 48259 | 5902 | 103 |
2102131 | 2102131 | 2022-01-10 | Kendall | Texas | 48259 | 5848 | 103 |
2098880 | 2098880 | 2022-01-09 | Kendall | Texas | 48259 | 5779 | 103 |
2095628 | 2095628 | 2022-01-08 | Kendall | Texas | 48259 | 5748 | 103 |
2092376 | 2092376 | 2022-01-07 | Kendall | Texas | 48259 | 5704 | 103 |
2089124 | 2089124 | 2022-01-06 | Kendall | Texas | 48259 | 5674 | 103 |
2085873 | 2085873 | 2022-01-05 | Kendall | Texas | 48259 | 5633 | 103 |
2082621 | 2082621 | 2022-01-04 | Kendall | Texas | 48259 | 5598 | 103 |
2079369 | 2079369 | 2022-01-03 | Kendall | Texas | 48259 | 5567 | 103 |
2037105 | 2037105 | 2021-12-21 | Hutchinson | Texas | 48233 | 4304 | 103 |
2033855 | 2033855 | 2021-12-20 | Hutchinson | Texas | 48233 | 4290 | 103 |
2030605 | 2030605 | 2021-12-19 | Hutchinson | Texas | 48233 | 4275 | 103 |
2027354 | 2027354 | 2021-12-18 | Hutchinson | Texas | 48233 | 4267 | 103 |
1926517 | 1926517 | 2021-11-17 | Cooke | Texas | 48097 | 5175 | 103 |
1923267 | 1923267 | 2021-11-16 | Cooke | Texas | 48097 | 5175 | 103 |
1920018 | 1920018 | 2021-11-15 | Cooke | Texas | 48097 | 5169 | 103 |
1920041 | 1920041 | 2021-11-15 | Erath | Texas | 48143 | 6408 | 103 |
1916768 | 1916768 | 2021-11-14 | Cooke | Texas | 48097 | 5169 | 103 |
1916791 | 1916791 | 2021-11-14 | Erath | Texas | 48143 | 6408 | 103 |
1913518 | 1913518 | 2021-11-13 | Cooke | Texas | 48097 | 5169 | 103 |
1877948 | 1877948 | 2021-11-02 | Titus | Texas | 48449 | 5727 | 103 |
1829078 | 1829078 | 2021-10-18 | Grimes | Texas | 48185 | 5127 | 103 |
1825829 | 1825829 | 2021-10-17 | Grimes | Texas | 48185 | 5116 | 103 |
1793428 | 1793428 | 2021-10-07 | Panola | Texas | 48365 | 2884 | 103 |
1773995 | 1773995 | 2021-10-01 | Willacy | Texas | 48489 | 4486 | 103 |
1770745 | 1770745 | 2021-09-30 | Willacy | Texas | 48489 | 4467 | 103 |
1767398 | 1767398 | 2021-09-29 | Limestone | Texas | 48293 | 3545 | 103 |
1767496 | 1767496 | 2021-09-29 | Willacy | Texas | 48489 | 4464 | 103 |
1764247 | 1764247 | 2021-09-28 | Willacy | Texas | 48489 | 4462 | 103 |
1760998 | 1760998 | 2021-09-27 | Willacy | Texas | 48489 | 4441 | 103 |
1757750 | 1757750 | 2021-09-26 | Willacy | Texas | 48489 | 4441 | 103 |
1738025 | 1738025 | 2021-09-20 | Bee | Texas | 48025 | 5122 | 103 |
1734775 | 1734775 | 2021-09-19 | Bee | Texas | 48025 | 5122 | 103 |
1731525 | 1731525 | 2021-09-18 | Bee | Texas | 48025 | 5114 | 103 |
1725260 | 1725260 | 2021-09-16 | Wilson | Texas | 48493 | 6740 | 103 |
1692583 | 1692583 | 2021-09-06 | Coryell | Texas | 48099 | 9202 | 103 |
1689334 | 1689334 | 2021-09-05 | Coryell | Texas | 48099 | 9062 | 103 |
1686084 | 1686084 | 2021-09-04 | Coryell | Texas | 48099 | 9062 | 103 |
1682833 | 1682833 | 2021-09-03 | Coryell | Texas | 48099 | 8959 | 103 |
1673175 | 1673175 | 2021-08-31 | Kleberg | Texas | 48273 | 3735 | 103 |
1657037 | 1657037 | 2021-08-26 | Washington | Texas | 48477 | 4850 | 103 |
1653790 | 1653790 | 2021-08-25 | Washington | Texas | 48477 | 4827 | 103 |
1604854 | 1604854 | 2021-08-10 | Caldwell | Texas | 48055 | 6380 | 103 |
1604940 | 1604940 | 2021-08-10 | Howard | Texas | 48227 | 4869 | 103 |
1601605 | 1601605 | 2021-08-09 | Caldwell | Texas | 48055 | 6351 | 103 |
1601691 | 1601691 | 2021-08-09 | Howard | Texas | 48227 | 4856 | 103 |
1598357 | 1598357 | 2021-08-08 | Caldwell | Texas | 48055 | 6296 | 103 |
1598443 | 1598443 | 2021-08-08 | Howard | Texas | 48227 | 4852 | 103 |
1595108 | 1595108 | 2021-08-07 | Caldwell | Texas | 48055 | 6296 | 103 |
1595194 | 1595194 | 2021-08-07 | Howard | Texas | 48227 | 4847 | 103 |
1591945 | 1591945 | 2021-08-06 | Howard | Texas | 48227 | 4818 | 103 |
1588696 | 1588696 | 2021-08-05 | Howard | Texas | 48227 | 4810 | 103 |
1585446 | 1585446 | 2021-08-04 | Howard | Texas | 48227 | 4789 | 103 |
1582196 | 1582196 | 2021-08-03 | Howard | Texas | 48227 | 4782 | 103 |
1578947 | 1578947 | 2021-08-02 | Howard | Texas | 48227 | 4774 | 103 |
1575699 | 1575699 | 2021-08-01 | Howard | Texas | 48227 | 4771 | 103 |
1572451 | 1572451 | 2021-07-31 | Howard | Texas | 48227 | 4765 | 103 |
1569203 | 1569203 | 2021-07-30 | Howard | Texas | 48227 | 4758 | 103 |
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);