courts

6 rows where ajr = 2 and coa_district = 12

This data as json, CSV (advanced)

Suggested facets: counties, address, has_forms, last_verified (date), counties (array)

county 2

coa_district 1

ajr 1

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-ANGELINA Angelina County Court   county_constitutional   Angelina ["Angelina"] 2 12 Keith Neil Wright   P O Box 908 (936)634-5413 http://www.angelinacounty.net/cojudge/   1 1 1 2026-03-10 Constitutional county court (county judge presides)
TX-CC-001-TRINITY Trinity County Court   county_constitutional   Trinity ["Trinity"] 2 12 Danny R. Martin   P O Box 457 (936)642-1746 http://www.co.trinity.tx.us/default.aspx?Trinity_County/County.Judge   1 1 0 2026-03-10 Constitutional county court (county judge presides)
TX-CCL-001-ANGELINA County Court at Law No. 1 1 county_court_at_law   Angelina ["Angelina"] 2 12 Joe Lee Register   P O Box 908 (936)639-2204 http://www.angelinacounty.net/ccl1/   1 1 1 2026-03-10  
TX-CCL-002-ANGELINA County Court at Law No. 2 2 county_court_at_law   Angelina ["Angelina"] 2 12 Jimmy A. Cassels   P O Box 908 (936)634-8984 http://www.angelinacounty.net/ccl2/   1 1 1 2026-03-10  
TX-DIST-159-ANGELINA 159th District Court 159 district   Angelina ["Angelina"] 2 12 Todd Lee Kassaw   P O Box 908 (936)639-3913 http://www.angelinacounty.net/dist159/   1 1 1 2026-03-10  
TX-DIST-217-ANGELINA 217th District Court 217 district   Angelina ["Angelina"] 2 12 Robert (Bob) Kenneth Inselmann Jr.   P O Box 908 (936)637-0217 http://www.angelinacounty.net/dist217/   1 1 1 2026-03-10  

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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
);