home / openregs

nomination_actions

Action history for executive nominations (committee referral, hearings, votes).

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

3 rows where nomination_id = "107-2304-00" sorted by action_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: action_date, action_date (date)

id nomination_id action_date ▲ action_text action_type
56369 James M. Loy, of Virginia, to be Under Secretary of Transportation for Security for a term of five years, vice John Magaw, resigned. 107-2304-00 2002-11-18 Confirmed by the Senate by Voice Vote. Floor
56370 James M. Loy, of Virginia, to be Under Secretary of Transportation for Security for a term of five years, vice John Magaw, resigned. 107-2304-00 2002-11-18 Senate Committee on Commerce, Science, and Transportation discharged. Pursuant to unanimous consent of November 18, 2002. Discharge
56371 James M. Loy, of Virginia, to be Under Secretary of Transportation for Security for a term of five years, vice John Magaw, resigned. 107-2304-00 2002-11-14 Received in the Senate and referred to the Committee on Commerce, Science, and Transportation. IntroReferral

Advanced export

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

CSV options:

CREATE TABLE nomination_actions (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    nomination_id TEXT NOT NULL REFERENCES nominations(id),
    action_date TEXT,
    action_text TEXT,
    action_type TEXT
);
CREATE INDEX idx_nomact_nom ON nomination_actions(nomination_id);
Powered by Datasette · Queries took 2760.524ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API