presidential_documents

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

5,971 rows sorted by signing_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: signing_date (date), publication_date (date)

Next page

CREATE TABLE presidential_documents (
    document_number TEXT PRIMARY KEY,
    title TEXT,
    document_type TEXT,
    executive_order_number INTEGER,
    signing_date TEXT,
    publication_date TEXT,
    html_url TEXT,
    abstract TEXT
);
CREATE INDEX idx_presdoc_type ON presidential_documents(document_type);
CREATE INDEX idx_presdoc_eo ON presidential_documents(executive_order_number);
CREATE INDEX idx_presdoc_date ON presidential_documents(signing_date);