courts

3 rows where ajr = 10 and county = "Delta"

This data as json, CSV (advanced)

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

court_type 2

county 1

  • Delta · 3 ✖

coa_district 1

  • 6 3

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-DELTA Delta County Court   county_constitutional   Delta ["Delta"] 10 6 Tanner Bill Crutcher   200 W Dallas Ave (903)395-9302 https://www.deltacountytx.com/county-court   0 0 0 2026-03-10 Constitutional county court (county judge presides)
TX-DIST-008-DELTA 8th District Court 8 district   Delta ["Delta", "Franklin", "Hopkins", "Rains"] 10 6 Eddie Northcutt   118 Church St, 2nd Fl (903)438-4022 http://www.deltacountytx.com/districtcourtjudge.html   0 0 0 2026-03-10 Multi-county: Delta, Franklin, Hopkins, Rains
TX-DIST-062-DELTA 62nd District Court 62 district   Delta ["Delta", "Franklin", "Hopkins", "Lamar"] 10 6 Gary D. Young   119 N Main St (903)737-2433 http://www.deltacountytx.com/districtcourtjudge.html   0 0 0 2026-03-10 Multi-county: Delta, Franklin, Hopkins, Lamar

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