nominations

Executive nominations to the Senate (Congresses 100–119), with confirmation status and vote tallies.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

status
Confirmed, Withdrawn, Returned, Rejected, or Pending.
is_civilian
Whether this is a civilian (non-military) nomination.
vote_yea
Yea votes if confirmed by roll call.
vote_nay
Nay votes if confirmed by roll call.

1 row where status = "Rejected" sorted by received_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: received_date (date)

status 1

  • Rejected · 1 ✖

congress 1

id congress number part_number citation description organization received_date ▲ authority_date is_civilian is_military status vote_yea vote_nay
100-487-00 100 487 00 PN487 Robert H. Bork, of the District of Columbia, to be an Associate Justice of the Supreme Court of the United States, vice Lewis F. Powell, Jr., retired. The Judiciary 1987-07-07   1 0 Rejected    

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE nominations (
    id TEXT PRIMARY KEY,
    congress INTEGER,
    number INTEGER,
    part_number TEXT,
    citation TEXT,
    description TEXT,
    organization TEXT,
    received_date TEXT,
    authority_date TEXT,
    is_civilian INTEGER,
    is_military INTEGER,
    status TEXT,
    vote_yea INTEGER,
    vote_nay INTEGER
);
CREATE INDEX idx_nom_congress ON nominations(congress);
CREATE INDEX idx_nom_date ON nominations(received_date);
CREATE INDEX idx_nom_org ON nominations(organization) WHERE organization IS NOT NULL AND organization != '';
CREATE INDEX idx_nom_status_date ON nominations(status, received_date DESC);
CREATE INDEX idx_nom_civ_status ON nominations(is_civilian, status, received_date DESC);