ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,583 rows where deaths = 26 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Franklin 163
- Dallam 121
- Martin 92
- Donley 65
- Hansford 63
- Hamilton 57
- Stephens 49
- Mills 43
- Clay 39
- Trinity 36
- Ward 35
- Rains 34
- Yoakum 31
- Calhoun 30
- Brown 29
- Ochiltree 29
- Wilson 29
- Somervell 21
- Winkler 19
- Lynn 17
- Rockwall 17
- Haskell 15
- Nacogdoches 15
- Pecos 15
- San Saba 15
- Van Zandt 15
- Karnes 14
- Presidio 14
- San Augustine 14
- Brewster 13
- …
state 1
- Texas · 1,583 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502271 | 2502271 | 2022-05-13 | Donley | Texas | 48129 | 1153 | 26 |
2502362 | 2502362 | 2022-05-13 | Martin | Texas | 48317 | 1207 | 26 |
2499013 | 2499013 | 2022-05-12 | Donley | Texas | 48129 | 1153 | 26 |
2499104 | 2499104 | 2022-05-12 | Martin | Texas | 48317 | 1207 | 26 |
2495755 | 2495755 | 2022-05-11 | Donley | Texas | 48129 | 1153 | 26 |
2495846 | 2495846 | 2022-05-11 | Martin | Texas | 48317 | 1207 | 26 |
2492497 | 2492497 | 2022-05-10 | Donley | Texas | 48129 | 1153 | 26 |
2492588 | 2492588 | 2022-05-10 | Martin | Texas | 48317 | 1207 | 26 |
2489239 | 2489239 | 2022-05-09 | Donley | Texas | 48129 | 1153 | 26 |
2489330 | 2489330 | 2022-05-09 | Martin | Texas | 48317 | 1207 | 26 |
2485982 | 2485982 | 2022-05-08 | Donley | Texas | 48129 | 1153 | 26 |
2486073 | 2486073 | 2022-05-08 | Martin | Texas | 48317 | 1207 | 26 |
2482724 | 2482724 | 2022-05-07 | Donley | Texas | 48129 | 1153 | 26 |
2482815 | 2482815 | 2022-05-07 | Martin | Texas | 48317 | 1207 | 26 |
2479466 | 2479466 | 2022-05-06 | Donley | Texas | 48129 | 1153 | 26 |
2479557 | 2479557 | 2022-05-06 | Martin | Texas | 48317 | 1207 | 26 |
2476208 | 2476208 | 2022-05-05 | Donley | Texas | 48129 | 1153 | 26 |
2476299 | 2476299 | 2022-05-05 | Martin | Texas | 48317 | 1206 | 26 |
2472951 | 2472951 | 2022-05-04 | Donley | Texas | 48129 | 1153 | 26 |
2473042 | 2473042 | 2022-05-04 | Martin | Texas | 48317 | 1206 | 26 |
2469695 | 2469695 | 2022-05-03 | Donley | Texas | 48129 | 1153 | 26 |
2469786 | 2469786 | 2022-05-03 | Martin | Texas | 48317 | 1206 | 26 |
2466439 | 2466439 | 2022-05-02 | Donley | Texas | 48129 | 1153 | 26 |
2466530 | 2466530 | 2022-05-02 | Martin | Texas | 48317 | 1204 | 26 |
2463184 | 2463184 | 2022-05-01 | Donley | Texas | 48129 | 1153 | 26 |
2463275 | 2463275 | 2022-05-01 | Martin | Texas | 48317 | 1204 | 26 |
2459928 | 2459928 | 2022-04-30 | Donley | Texas | 48129 | 1153 | 26 |
2460019 | 2460019 | 2022-04-30 | Martin | Texas | 48317 | 1204 | 26 |
2456672 | 2456672 | 2022-04-29 | Donley | Texas | 48129 | 1153 | 26 |
2456763 | 2456763 | 2022-04-29 | Martin | Texas | 48317 | 1203 | 26 |
2453416 | 2453416 | 2022-04-28 | Donley | Texas | 48129 | 1153 | 26 |
2453507 | 2453507 | 2022-04-28 | Martin | Texas | 48317 | 1203 | 26 |
2450160 | 2450160 | 2022-04-27 | Donley | Texas | 48129 | 1153 | 26 |
2450251 | 2450251 | 2022-04-27 | Martin | Texas | 48317 | 1203 | 26 |
2446903 | 2446903 | 2022-04-26 | Donley | Texas | 48129 | 1153 | 26 |
2446994 | 2446994 | 2022-04-26 | Martin | Texas | 48317 | 1202 | 26 |
2443648 | 2443648 | 2022-04-25 | Donley | Texas | 48129 | 1153 | 26 |
2443739 | 2443739 | 2022-04-25 | Martin | Texas | 48317 | 1201 | 26 |
2440392 | 2440392 | 2022-04-24 | Donley | Texas | 48129 | 1153 | 26 |
2440483 | 2440483 | 2022-04-24 | Martin | Texas | 48317 | 1201 | 26 |
2437136 | 2437136 | 2022-04-23 | Donley | Texas | 48129 | 1153 | 26 |
2437227 | 2437227 | 2022-04-23 | Martin | Texas | 48317 | 1201 | 26 |
2433880 | 2433880 | 2022-04-22 | Donley | Texas | 48129 | 1153 | 26 |
2433971 | 2433971 | 2022-04-22 | Martin | Texas | 48317 | 1201 | 26 |
2430624 | 2430624 | 2022-04-21 | Donley | Texas | 48129 | 1153 | 26 |
2430715 | 2430715 | 2022-04-21 | Martin | Texas | 48317 | 1201 | 26 |
2427368 | 2427368 | 2022-04-20 | Donley | Texas | 48129 | 1153 | 26 |
2427459 | 2427459 | 2022-04-20 | Martin | Texas | 48317 | 1200 | 26 |
2424112 | 2424112 | 2022-04-19 | Donley | Texas | 48129 | 1153 | 26 |
2424203 | 2424203 | 2022-04-19 | Martin | Texas | 48317 | 1200 | 26 |
2420856 | 2420856 | 2022-04-18 | Donley | Texas | 48129 | 1152 | 26 |
2420947 | 2420947 | 2022-04-18 | Martin | Texas | 48317 | 1200 | 26 |
2417600 | 2417600 | 2022-04-17 | Donley | Texas | 48129 | 1149 | 26 |
2417691 | 2417691 | 2022-04-17 | Martin | Texas | 48317 | 1200 | 26 |
2414344 | 2414344 | 2022-04-16 | Donley | Texas | 48129 | 1149 | 26 |
2414435 | 2414435 | 2022-04-16 | Martin | Texas | 48317 | 1200 | 26 |
2411088 | 2411088 | 2022-04-15 | Donley | Texas | 48129 | 1149 | 26 |
2411179 | 2411179 | 2022-04-15 | Martin | Texas | 48317 | 1200 | 26 |
2407832 | 2407832 | 2022-04-14 | Donley | Texas | 48129 | 1149 | 26 |
2407923 | 2407923 | 2022-04-14 | Martin | Texas | 48317 | 1200 | 26 |
2404576 | 2404576 | 2022-04-13 | Donley | Texas | 48129 | 1147 | 26 |
2404667 | 2404667 | 2022-04-13 | Martin | Texas | 48317 | 1199 | 26 |
2401321 | 2401321 | 2022-04-12 | Donley | Texas | 48129 | 1146 | 26 |
2401412 | 2401412 | 2022-04-12 | Martin | Texas | 48317 | 1199 | 26 |
2398066 | 2398066 | 2022-04-11 | Donley | Texas | 48129 | 1146 | 26 |
2398157 | 2398157 | 2022-04-11 | Martin | Texas | 48317 | 1197 | 26 |
2394811 | 2394811 | 2022-04-10 | Donley | Texas | 48129 | 1146 | 26 |
2394902 | 2394902 | 2022-04-10 | Martin | Texas | 48317 | 1197 | 26 |
2391555 | 2391555 | 2022-04-09 | Donley | Texas | 48129 | 1146 | 26 |
2391646 | 2391646 | 2022-04-09 | Martin | Texas | 48317 | 1197 | 26 |
2388299 | 2388299 | 2022-04-08 | Donley | Texas | 48129 | 1146 | 26 |
2388390 | 2388390 | 2022-04-08 | Martin | Texas | 48317 | 1196 | 26 |
2385044 | 2385044 | 2022-04-07 | Donley | Texas | 48129 | 1145 | 26 |
2385135 | 2385135 | 2022-04-07 | Martin | Texas | 48317 | 1195 | 26 |
2381789 | 2381789 | 2022-04-06 | Donley | Texas | 48129 | 1145 | 26 |
2381880 | 2381880 | 2022-04-06 | Martin | Texas | 48317 | 1195 | 26 |
2378534 | 2378534 | 2022-04-05 | Donley | Texas | 48129 | 1145 | 26 |
2378625 | 2378625 | 2022-04-05 | Martin | Texas | 48317 | 1193 | 26 |
2375280 | 2375280 | 2022-04-04 | Donley | Texas | 48129 | 1143 | 26 |
2375371 | 2375371 | 2022-04-04 | Martin | Texas | 48317 | 1187 | 26 |
2372028 | 2372028 | 2022-04-03 | Donley | Texas | 48129 | 1143 | 26 |
2372119 | 2372119 | 2022-04-03 | Martin | Texas | 48317 | 1187 | 26 |
2368775 | 2368775 | 2022-04-02 | Donley | Texas | 48129 | 1143 | 26 |
2368866 | 2368866 | 2022-04-02 | Martin | Texas | 48317 | 1187 | 26 |
2365522 | 2365522 | 2022-04-01 | Donley | Texas | 48129 | 1143 | 26 |
2365613 | 2365613 | 2022-04-01 | Martin | Texas | 48317 | 1187 | 26 |
2362269 | 2362269 | 2022-03-31 | Donley | Texas | 48129 | 1142 | 26 |
2362360 | 2362360 | 2022-03-31 | Martin | Texas | 48317 | 1186 | 26 |
2359015 | 2359015 | 2022-03-30 | Donley | Texas | 48129 | 1141 | 26 |
2359106 | 2359106 | 2022-03-30 | Martin | Texas | 48317 | 1186 | 26 |
2355761 | 2355761 | 2022-03-29 | Donley | Texas | 48129 | 1141 | 26 |
2355852 | 2355852 | 2022-03-29 | Martin | Texas | 48317 | 1184 | 26 |
2352508 | 2352508 | 2022-03-28 | Donley | Texas | 48129 | 1141 | 26 |
2352599 | 2352599 | 2022-03-28 | Martin | Texas | 48317 | 1184 | 26 |
2349256 | 2349256 | 2022-03-27 | Donley | Texas | 48129 | 1141 | 26 |
2349347 | 2349347 | 2022-03-27 | Martin | Texas | 48317 | 1184 | 26 |
2346003 | 2346003 | 2022-03-26 | Donley | Texas | 48129 | 1141 | 26 |
2346094 | 2346094 | 2022-03-26 | Martin | Texas | 48317 | 1184 | 26 |
2342750 | 2342750 | 2022-03-25 | Donley | Texas | 48129 | 1140 | 26 |
2342841 | 2342841 | 2022-03-25 | Martin | Texas | 48317 | 1182 | 26 |
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);