courts

4 rows where ajr = 3 and coa_district = 4

This data as json, CSV (advanced)

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

county 1

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-GUADALUPE Guadalupe County Court   county_constitutional   Guadalupe ["Guadalupe"] 3 4 Kyle W. Kutscher   101 E Court St (830)303-8867 http://www.co.guadalupe.tx.us/judge/judge.php   1 1 0 2026-03-10 Constitutional county court (county judge presides)
TX-CCL-001-GUADALUPE County Court at Law   county_court_at_law   Guadalupe ["Guadalupe"] 3 4 William (Bill) G. Squires III   211 W Court St, Ste 330 (830)303-4188 http://www.guadalupetx.gov/ccl/ccl.php   1 1 0 2026-03-10  
TX-CCL-002-GUADALUPE County Court at Law No. 2 2 county_court_at_law   Guadalupe ["Guadalupe"] 3 4 Kirsten Legore   211 W Court St, Ste 339 (830)303-8871 http://www.co.guadalupe.tx.us/ccl/ccl.php   1 1 0 2026-03-10  
TX-DIST-456-GUADALUPE 456th District Court 456 district   Guadalupe ["Guadalupe"] 3 4 Heather Hines Wright   211 W Court St (830)303-8852 https://www.co.guadalupe.tx.us/456/456.php   1 1 0 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
);