courts

1 row where county = "Jones" and court_type = "district"

This data as json, CSV (advanced)

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

court_type 1

  • district · 1 ✖

county 1

  • Jones · 1 ✖

coa_district 1

ajr 1

  • 7 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-DIST-259-JONES 259th District Court 259 district   Jones ["Jones", "Shackelford"] 7 11 Brooks H. Hagler   P O Box 429 (325)823-2721 http://www.co.jones.tx.us/default.aspx?Jones_County/District.Clerk         2026-03-10 Multi-county: Jones, Shackelford

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