courts
4 rows where ajr = 3, coa_district = 10 and county = "Coryell"
This data as json, CSV (advanced)
Suggested facets: website_url, last_verified (date), counties (array)
| 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-CORYELL | Coryell County Court | county_constitutional | Coryell | ["Coryell"] | 3 | 10 | Roger A. Miller | 800 E Main St, Ste A | (254)865-5911 | https://www.coryellcounty.org/page/coryell.County.Judge | 1 | 1 | 0 | 2026-03-10 | Constitutional county court (county judge presides) | ||||
| TX-CCL-001-CORYELL | County Court at Law | county_court_at_law | Coryell | ["Coryell"] | 3 | 10 | John R. Lee | 620 E Main | (254)865-5911 | http://www.coryellcounty.org/government/county-court-at-law | 1 | 1 | 0 | 2026-03-10 | |||||
| TX-DIST-052-CORYELL | 52nd District Court | 52 | district | Coryell | ["Coryell"] | 3 | 10 | Trent D. Farrell | P O Box 19 | (254)865-5911 | http://www.coryellcounty.org/government/district-court | 1 | 1 | 0 | 2026-03-10 | ||||
| TX-DIST-440-CORYELL | 440th District Court | 440 | district | Coryell | ["Coryell"] | 3 | 10 | Grant Kinsey | 205 S 7th St, 7th St County Annex | (254)865-5911 | http://www.coryellcounty.org/government/district-court | 1 | 1 | 0 | 2026-03-10 |
Advanced export
JSON shape: default, array, newline-delimited, object
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
);