courts

9 rows where ajr = 10 and county = "Smith"

This data as json, CSV (advanced)

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

county 1

  • Smith · 9 ✖

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-SMITH Smith County Court   county_constitutional   Smith ["Smith"] 10 12 Neal Franklin   200 E Ferguson, Ste 100 (903)590-4625 http://www.smith-county.com/   1 0 0 2026-03-10 Constitutional county court (county judge presides)
TX-CCL-001-SMITH County Court at Law   county_court_at_law   Smith ["Smith"] 10 12 Jason A. Ellis   100 N Broadway, 2nd Fl (903)590-1650 http://www.smith-county.com/   1 0 0 2026-03-10  
TX-CCL-002-SMITH County Court at Law No. 2 2 county_court_at_law   Smith ["Smith"] 10 12 Sara Katherine Maynard   100 N Broadway, Rm 104 (903)590-1611 https://www.smith-county.com/government/elected-officials/county-courts-at-law-judges/county-court-at-law-2   1 0 0 2026-03-10  
TX-CCL-003-SMITH County Court at Law No. 3 3 county_court_at_law   Smith ["Smith"] 10 12 Clay M. White   100 N Broadway, 3rd Fl (903)590-1690 http://www.smith-county.com/   1 0 0 2026-03-10  
TX-DIST-007-SMITH 7th District Court 7 district   Smith ["Smith"] 10 12 Kerry L. Russell   100 N Broadway, Rm 203 (903)590-1640 http://www.smith-county.com/   1 0 0 2026-03-10  
TX-DIST-114-SMITH 114th District Court 114 district   Smith ["Smith"] 10 12 Austin Reeve Jackson   100 N Broadway, Rm 212 (903)590-1625 http://www.smith-county.com/   1 0 0 2026-03-10  
TX-DIST-241-SMITH 241st District Court 241 district   Smith ["Smith"] 10 12 Debra (Debby) Gunter   100 N Broadway, Rm 114 (903)590-1792 http://www.smith-county.com/   1 0 0 2026-03-10  
TX-DIST-321-SMITH 321st District Court 321 district   Smith ["Smith"] 10 12 Robert H. Wilson   200 E Ferguson St, 5th Fl (903)590-1699 http://www.smith-county.com/   1 0 0 2026-03-10  
TX-DIST-475-SMITH 475th District Court 475 district   Smith ["Smith"] 10 12 Taylor Brooks Heaton   100 N Broadway, Rm 220 (903)590-4923 http://www.smith-county.com/government/elected-officials/district-court-judges/475th-district-court   1 0 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
);