crec_bills

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

5 rows where granule_id = "CREC-2019-09-24-pt1-PgE1200-7" sorted by congress descending

✎ View and edit SQL

This data as json, CSV (advanced)

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);