courts
1 row where coa_district = 14
This data as json, CSV (advanced)
Suggested facets: 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-COA-014-HOUSTON | 14th Court of Appeals | 14 | court_of_appeals | regional | ["Austin", "Brazoria", "Chambers", "Colorado", "Fort Bend", "Galveston", "Grimes", "Harris", "Waller", "Washington"] | 14 | Chief Justice Tracy Christopher | 301 Fannin, Ste 245, Houston 77002 | (713) 274-2800 | http://www.txcourts.gov/14thcoa.aspx | 2026-03-10 | 9 justices (incl. Chief Justice), HQ: Houston |
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
);