ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,533 rows where deaths = 11 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Culberson 251
- Sutton 138
- Kimble 127
- Foard 105
- Hudspeth 103
- Concho 100
- Menard 96
- Collingsworth 88
- Edwards 80
- Baylor 62
- Wheeler 62
- Delta 59
- Coke 54
- Crane 45
- Upton 45
- Bandera 41
- Lipscomb 39
- Archer 31
- Houston 27
- La Salle 25
- Sherman 24
- Jim Hogg 23
- Reagan 22
- Franklin 21
- Runnels 21
- Lynn 20
- San Jacinto 20
- Austin 19
- Bailey 18
- Red River 18
- …
state 1
- Texas · 2,533 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502254 | 2502254 | 2022-05-13 | Concho | Texas | 48095 | 1084 | 11 |
2502275 | 2502275 | 2022-05-13 | Edwards | Texas | 48137 | 467 | 11 |
2502284 | 2502284 | 2022-05-13 | Foard | Texas | 48155 | 209 | 11 |
2502342 | 2502342 | 2022-05-13 | Kinney | Texas | 48271 | 741 | 11 |
2498996 | 2498996 | 2022-05-12 | Concho | Texas | 48095 | 1084 | 11 |
2499017 | 2499017 | 2022-05-12 | Edwards | Texas | 48137 | 467 | 11 |
2499026 | 2499026 | 2022-05-12 | Foard | Texas | 48155 | 209 | 11 |
2495738 | 2495738 | 2022-05-11 | Concho | Texas | 48095 | 1084 | 11 |
2495759 | 2495759 | 2022-05-11 | Edwards | Texas | 48137 | 467 | 11 |
2495768 | 2495768 | 2022-05-11 | Foard | Texas | 48155 | 209 | 11 |
2492480 | 2492480 | 2022-05-10 | Concho | Texas | 48095 | 1084 | 11 |
2492501 | 2492501 | 2022-05-10 | Edwards | Texas | 48137 | 467 | 11 |
2492510 | 2492510 | 2022-05-10 | Foard | Texas | 48155 | 208 | 11 |
2489222 | 2489222 | 2022-05-09 | Concho | Texas | 48095 | 1084 | 11 |
2489243 | 2489243 | 2022-05-09 | Edwards | Texas | 48137 | 467 | 11 |
2489252 | 2489252 | 2022-05-09 | Foard | Texas | 48155 | 208 | 11 |
2485965 | 2485965 | 2022-05-08 | Concho | Texas | 48095 | 1084 | 11 |
2485986 | 2485986 | 2022-05-08 | Edwards | Texas | 48137 | 467 | 11 |
2485995 | 2485995 | 2022-05-08 | Foard | Texas | 48155 | 208 | 11 |
2482707 | 2482707 | 2022-05-07 | Concho | Texas | 48095 | 1084 | 11 |
2482728 | 2482728 | 2022-05-07 | Edwards | Texas | 48137 | 467 | 11 |
2482737 | 2482737 | 2022-05-07 | Foard | Texas | 48155 | 208 | 11 |
2479449 | 2479449 | 2022-05-06 | Concho | Texas | 48095 | 1084 | 11 |
2479470 | 2479470 | 2022-05-06 | Edwards | Texas | 48137 | 467 | 11 |
2479479 | 2479479 | 2022-05-06 | Foard | Texas | 48155 | 208 | 11 |
2476191 | 2476191 | 2022-05-05 | Concho | Texas | 48095 | 1084 | 11 |
2476212 | 2476212 | 2022-05-05 | Edwards | Texas | 48137 | 466 | 11 |
2476221 | 2476221 | 2022-05-05 | Foard | Texas | 48155 | 207 | 11 |
2472934 | 2472934 | 2022-05-04 | Concho | Texas | 48095 | 1084 | 11 |
2472955 | 2472955 | 2022-05-04 | Edwards | Texas | 48137 | 466 | 11 |
2472964 | 2472964 | 2022-05-04 | Foard | Texas | 48155 | 207 | 11 |
2469678 | 2469678 | 2022-05-03 | Concho | Texas | 48095 | 1084 | 11 |
2469699 | 2469699 | 2022-05-03 | Edwards | Texas | 48137 | 466 | 11 |
2469708 | 2469708 | 2022-05-03 | Foard | Texas | 48155 | 206 | 11 |
2466422 | 2466422 | 2022-05-02 | Concho | Texas | 48095 | 1084 | 11 |
2466443 | 2466443 | 2022-05-02 | Edwards | Texas | 48137 | 466 | 11 |
2466452 | 2466452 | 2022-05-02 | Foard | Texas | 48155 | 206 | 11 |
2463167 | 2463167 | 2022-05-01 | Concho | Texas | 48095 | 1084 | 11 |
2463188 | 2463188 | 2022-05-01 | Edwards | Texas | 48137 | 466 | 11 |
2463197 | 2463197 | 2022-05-01 | Foard | Texas | 48155 | 206 | 11 |
2459911 | 2459911 | 2022-04-30 | Concho | Texas | 48095 | 1084 | 11 |
2459932 | 2459932 | 2022-04-30 | Edwards | Texas | 48137 | 466 | 11 |
2459941 | 2459941 | 2022-04-30 | Foard | Texas | 48155 | 206 | 11 |
2456655 | 2456655 | 2022-04-29 | Concho | Texas | 48095 | 1084 | 11 |
2456676 | 2456676 | 2022-04-29 | Edwards | Texas | 48137 | 466 | 11 |
2456685 | 2456685 | 2022-04-29 | Foard | Texas | 48155 | 205 | 11 |
2453399 | 2453399 | 2022-04-28 | Concho | Texas | 48095 | 1079 | 11 |
2453420 | 2453420 | 2022-04-28 | Edwards | Texas | 48137 | 466 | 11 |
2453429 | 2453429 | 2022-04-28 | Foard | Texas | 48155 | 205 | 11 |
2450143 | 2450143 | 2022-04-27 | Concho | Texas | 48095 | 1079 | 11 |
2450164 | 2450164 | 2022-04-27 | Edwards | Texas | 48137 | 466 | 11 |
2450173 | 2450173 | 2022-04-27 | Foard | Texas | 48155 | 205 | 11 |
2446886 | 2446886 | 2022-04-26 | Concho | Texas | 48095 | 1079 | 11 |
2446907 | 2446907 | 2022-04-26 | Edwards | Texas | 48137 | 466 | 11 |
2446916 | 2446916 | 2022-04-26 | Foard | Texas | 48155 | 205 | 11 |
2443631 | 2443631 | 2022-04-25 | Concho | Texas | 48095 | 1079 | 11 |
2443652 | 2443652 | 2022-04-25 | Edwards | Texas | 48137 | 466 | 11 |
2443661 | 2443661 | 2022-04-25 | Foard | Texas | 48155 | 204 | 11 |
2440375 | 2440375 | 2022-04-24 | Concho | Texas | 48095 | 1079 | 11 |
2440396 | 2440396 | 2022-04-24 | Edwards | Texas | 48137 | 466 | 11 |
2440405 | 2440405 | 2022-04-24 | Foard | Texas | 48155 | 204 | 11 |
2437119 | 2437119 | 2022-04-23 | Concho | Texas | 48095 | 1079 | 11 |
2437140 | 2437140 | 2022-04-23 | Edwards | Texas | 48137 | 466 | 11 |
2437149 | 2437149 | 2022-04-23 | Foard | Texas | 48155 | 204 | 11 |
2433863 | 2433863 | 2022-04-22 | Concho | Texas | 48095 | 1079 | 11 |
2433884 | 2433884 | 2022-04-22 | Edwards | Texas | 48137 | 466 | 11 |
2433893 | 2433893 | 2022-04-22 | Foard | Texas | 48155 | 204 | 11 |
2430607 | 2430607 | 2022-04-21 | Concho | Texas | 48095 | 1079 | 11 |
2430628 | 2430628 | 2022-04-21 | Edwards | Texas | 48137 | 466 | 11 |
2430637 | 2430637 | 2022-04-21 | Foard | Texas | 48155 | 204 | 11 |
2427351 | 2427351 | 2022-04-20 | Concho | Texas | 48095 | 1079 | 11 |
2427372 | 2427372 | 2022-04-20 | Edwards | Texas | 48137 | 466 | 11 |
2427381 | 2427381 | 2022-04-20 | Foard | Texas | 48155 | 204 | 11 |
2424095 | 2424095 | 2022-04-19 | Concho | Texas | 48095 | 1079 | 11 |
2424116 | 2424116 | 2022-04-19 | Edwards | Texas | 48137 | 466 | 11 |
2424125 | 2424125 | 2022-04-19 | Foard | Texas | 48155 | 203 | 11 |
2420839 | 2420839 | 2022-04-18 | Concho | Texas | 48095 | 1079 | 11 |
2420860 | 2420860 | 2022-04-18 | Edwards | Texas | 48137 | 466 | 11 |
2420869 | 2420869 | 2022-04-18 | Foard | Texas | 48155 | 203 | 11 |
2417583 | 2417583 | 2022-04-17 | Concho | Texas | 48095 | 1079 | 11 |
2417604 | 2417604 | 2022-04-17 | Edwards | Texas | 48137 | 465 | 11 |
2417613 | 2417613 | 2022-04-17 | Foard | Texas | 48155 | 203 | 11 |
2414327 | 2414327 | 2022-04-16 | Concho | Texas | 48095 | 1079 | 11 |
2414348 | 2414348 | 2022-04-16 | Edwards | Texas | 48137 | 465 | 11 |
2414357 | 2414357 | 2022-04-16 | Foard | Texas | 48155 | 203 | 11 |
2411071 | 2411071 | 2022-04-15 | Concho | Texas | 48095 | 1079 | 11 |
2411092 | 2411092 | 2022-04-15 | Edwards | Texas | 48137 | 465 | 11 |
2411101 | 2411101 | 2022-04-15 | Foard | Texas | 48155 | 203 | 11 |
2407815 | 2407815 | 2022-04-14 | Concho | Texas | 48095 | 1079 | 11 |
2407836 | 2407836 | 2022-04-14 | Edwards | Texas | 48137 | 465 | 11 |
2407845 | 2407845 | 2022-04-14 | Foard | Texas | 48155 | 203 | 11 |
2404559 | 2404559 | 2022-04-13 | Concho | Texas | 48095 | 1079 | 11 |
2404580 | 2404580 | 2022-04-13 | Edwards | Texas | 48137 | 465 | 11 |
2404589 | 2404589 | 2022-04-13 | Foard | Texas | 48155 | 203 | 11 |
2401304 | 2401304 | 2022-04-12 | Concho | Texas | 48095 | 1079 | 11 |
2401325 | 2401325 | 2022-04-12 | Edwards | Texas | 48137 | 465 | 11 |
2401334 | 2401334 | 2022-04-12 | Foard | Texas | 48155 | 203 | 11 |
2398049 | 2398049 | 2022-04-11 | Concho | Texas | 48095 | 1078 | 11 |
2398070 | 2398070 | 2022-04-11 | Edwards | Texas | 48137 | 465 | 11 |
2398079 | 2398079 | 2022-04-11 | Foard | Texas | 48155 | 203 | 11 |
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);