openregs: nominations: 2 rows where status = "Withdrawn" sorted by received

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.

2 rows where status = "Withdrawn" sorted by received_date descending

descending

id	congress	number	part_number	citation	description	organization	received_date ▲	authority_date	is_civilian	is_military	status	vote_yea	vote_nay
100-281-00	100	281	00	PN281	Dorothy Livingston Strunk, of Maryland, to be Assistant Secretary of Labor for Mine Safety and Health, vice David A. Zegeer, resigned.	Department of Labor	1987-04-23		1	0	Withdrawn
100-168-01	100	168	01	PN168-1	Charles A. Moser, of Virginia, to be a Member of the National Council on the Humanities for a term expiring January 26, 1992, vice Samuel DuBois Cook, term expired.	National Foundation on the Arts and the Humanities	1987-03-03		1	0	Withdrawn

Advanced export

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

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