crec_bills
Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API
118,330 rows where bill_type = "hres" sorted by congress descending
This data as json, CSV (advanced)
congress >30
bill_type 1
- hres · 118,330 ✖
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE crec_bills (
granule_id TEXT NOT NULL REFERENCES congressional_record(granule_id),
congress INTEGER,
bill_type TEXT,
bill_number INTEGER,
bill_id TEXT,
PRIMARY KEY (granule_id, congress, bill_type, bill_number)
);
CREATE INDEX idx_crec_bill_id ON crec_bills(bill_id);
CREATE INDEX idx_crec_bill_type ON crec_bills(bill_type, bill_number);