courts

6 rows where ajr = 2, coa_district = 9 and county = "Orange"

This data as json, CSV (advanced)

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

county 1

  • Orange · 6 ✖

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-ORANGE Orange County Court   county_constitutional   Orange ["Orange"] 2 9 John Gothia   123 S 6th St (409)882-7070 http://www.co.orange.tx.us/County_Judge.html   0 1 1 2026-03-10 Constitutional county court (county judge presides)
TX-CCL-001-ORANGE County Court at Law   county_court_at_law   Orange ["Orange"] 2 9 Mandy White-Rogers   801 W Division (409)882-7084 http://www.co.orange.tx.us/County_Court_At_Law.html   0 1 1 2026-03-10  
TX-CCL-002-ORANGE County Court at Law No. 2 2 county_court_at_law   Orange ["Orange"] 2 9 Rodney Townsend   801 W Division (409)670-4189 http://www.co.orange.tx.us/County_Court_at_Law_2.html   0 1 1 2026-03-10  
TX-DIST-128-ORANGE 128th District Court 128 district   Orange ["Orange"] 2 9 Courtney B. Arkeen   801 W Division (409)882-7085 http://www.co.orange.tx.us/128th_District_Judge.html   0 1 1 2026-03-10  
TX-DIST-163-ORANGE 163rd District Court 163 district   Orange ["Orange"] 2 9 Rex Peveto   801 W Division (409)882-7090 http://www.co.orange.tx.us/163rd_District_Court.html   0 1 1 2026-03-10  
TX-DIST-260-ORANGE 260th District Court 260 district   Orange ["Orange"] 2 9 Steve L. Parkhurst   801 W Division (409)882-7095 http://www.co.orange.tx.us/260th_District_Court.html   0 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
);