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

2 rows where nomination_id = "110-2116-00" sorted by action_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: action_date (date)

id nomination_id action_date ▲ action_text action_type
83774 Jonathan R. Scharfen, of Virginia, to be Director of the United States Citizenship and Immigration Services, Department of Homeland Security, vice Emilio T. Gonzalez. 110-2116-00 2009-01-02 Returned to the President under the provisions of Senate Rule XXXI, paragraph 6 of the Standing Rules of the Senate pursuant to sine die adjournment. Floor
83775 Jonathan R. Scharfen, of Virginia, to be Director of the United States Citizenship and Immigration Services, Department of Homeland Security, vice Emilio T. Gonzalez. 110-2116-00 2008-10-01 Received in the Senate and referred to the Committee on the Judiciary. 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 696.69ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API