courts
3 rows where ajr = 9 and county = "Castro"
This data as json, CSV (advanced)
Suggested facets: counties, notes, last_verified (date), counties (array)
| court_id ▼ | court_name | court_number | court_type | court_subtype | county | counties | ajr | coa_district | judge_name | judge_start_date | address | phone | website_url | topics_url | has_local_rules | has_standing_orders | has_forms | last_verified | notes |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| TX-CC-001-CASTRO | Castro County Court | county_constitutional | Castro | ["Castro"] | 9 | 7 | Mandy Gfeller | 100 E Bedford, Rm 111 | (806)647-4451 | http://www.co.castro.tx.us/default.aspx?Castro_County/County.Judge | 2026-03-10 | Constitutional county court (county judge presides) | |||||||
| TX-DIST-064-CASTRO | 64th District Court | 64 | district | Castro | ["Castro", "Hale", "Swisher"] | 9 | 7 | Danah L. Zirpoli | 225 Broadway, Ste 5 | (806)291-5234 | http://www.halecounty.org | 2026-03-10 | Multi-county: Castro, Hale, Swisher | ||||||
| TX-DIST-242-CASTRO | 242nd District Court | 242 | district | Castro | ["Castro", "Hale", "Swisher"] | 9 | 7 | Lowell Kregg Hukill | 225 Broadway, Ste 3 | (806)291-5254 | http://www.242ndcourt.com/ | 2026-03-10 | Multi-county: Castro, Hale, Swisher |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE courts (
court_id TEXT PRIMARY KEY,
court_name TEXT,
court_number INTEGER,
court_type TEXT,
court_subtype TEXT,
county TEXT,
counties TEXT,
ajr INTEGER,
coa_district INTEGER,
judge_name TEXT,
judge_start_date TEXT,
address TEXT,
phone TEXT,
website_url TEXT,
topics_url TEXT,
has_local_rules INTEGER,
has_standing_orders INTEGER,
has_forms INTEGER,
last_verified TEXT,
notes TEXT
);