federal_register
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
280 rows where pub_year = 2010 and type = "Presidential Document" sorted by publication_date descending
This data as json, CSV (advanced)
Suggested facets: publication_date (date)
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE federal_register (
document_number TEXT PRIMARY KEY,
title TEXT,
type TEXT,
abstract TEXT,
publication_date TEXT,
pub_year INTEGER,
pub_month INTEGER,
html_url TEXT,
pdf_url TEXT,
agency_names TEXT,
agency_ids TEXT,
excerpts TEXT
);
CREATE INDEX idx_fr_date ON federal_register(publication_date);
CREATE INDEX idx_fr_year ON federal_register(pub_year);
CREATE INDEX idx_fr_type ON federal_register(type);
CREATE INDEX idx_fr_agencies ON federal_register(agency_names);