courts
45 rows where coa_district = 2 and court_type = "district"
This data as json, CSV (advanced)
Suggested facets: counties, address, has_local_rules, has_standing_orders, has_forms, last_verified (date), counties (array)
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
);