nominations

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.

416 rows where congress = 115 and status = "Returned" sorted by received_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: part_number, authority_date, is_civilian, is_military, received_date (date), authority_date (date)

Next page

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