Judge Registry

Data license: Government edicts — not subject to copyright · Data source: nycourts.gov

14 rows where county = "Queens" and court_type = "supreme"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: last_verified (date)

CREATE TABLE judges (
    judge_id TEXT PRIMARY KEY,
    judge_name TEXT,
    honorific TEXT DEFAULT 'Hon.',
    court_type TEXT DEFAULT 'supreme',
    judicial_district INTEGER,
    county TEXT,
    part_number TEXT,
    assignment TEXT,
    is_commercial_division INTEGER DEFAULT 0,
    law_clerk TEXT,
    part_clerk TEXT,
    phone TEXT,
    email TEXT,
    courtroom TEXT,
    source_url TEXT,
    last_verified TEXT,
    notes TEXT
);