courts

4 rows where ajr = 2 and county = "Grimes"

This data as json, CSV (advanced)

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

county 1

  • Grimes · 4 ✖

coa_district 1

  • 1 4

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-GRIMES Grimes County Court   county_constitutional   Grimes ["Grimes"] 2 1 Joe Fauth III   270 FM 146 W (936)873-4476 https://www.grimescountytexas.gov/judge-precincts   1 1 1 2026-03-10 Constitutional county court (county judge presides)
TX-CCL-001-GRIMES County Court at Law   county_court_at_law   Grimes ["Grimes"] 2 1 Tuck Moody McLain   270 FM 149 W (936)873-4472 http://www.grimesccl.org   1 1 1 2026-03-10  
TX-DIST-012-GRIMES 12th District Court 12 district   Grimes ["Grimes", "Madison", "Walker"] 2 1 David W. Moorman   1100 University Ave, Ste 303 (936)436-4915 http://www.co.grimes.tx.us/default.aspx?Grimes_County/12th   1 1 1 2026-03-10 Multi-county: Grimes, Madison, Walker
TX-DIST-506-GRIMES 506th District Court 506 district   Grimes ["Grimes", "Waller"] 2 1 Gary W. Chaney   400 Sheriff R. Glenn Smith Dr (979)921-0921 http://www.court506.com   1 1 1 2026-03-10 Multi-county: Grimes, Waller

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