presidential_documents
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
5,904 rows sorted by signing_date descending
This data as json, CSV (advanced)
Suggested facets: signing_date (date), publication_date (date)
document_type 2
- proclamation 4,380
- executive_order 1,524
Advanced export
JSON shape: default, array, newline-delimited, object
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);