courts

3 rows where ajr = 7 and coa_district = 7

This data as json, CSV (advanced)

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

county 3

court_type 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-GARZA Garza County Court   county_constitutional   Garza ["Garza"] 7 7 John Lee Norman   300 W Main (806)495-4405 http://www.garzacounty.net/id20.html   0 1 1 2026-03-10 Constitutional county court (county judge presides)
TX-CC-001-KENT Kent County Court   county_constitutional   Kent ["Kent"] 7 7 Layne Coulter   P O Box 6 (806)237-3373           2026-03-10 Constitutional county court (county judge presides)
TX-CC-001-LYNN Lynn County Court   county_constitutional   Lynn ["Lynn"] 7 7 Mike Braddock   P O Box 1167 (806)561-4222 http://www.co.lynn.tx.us/default.aspx?Lynn_County/County.Judge   0 1 0 2026-03-10 Constitutional county court (county judge presides)

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