crec_bills

Bills referenced in Congressional Record floor proceedings. Links floor debate to specific legislation. Cross-references with the legislation table via bill_id.

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

3 rows where granule_id = "CREC-2017-07-25-pt1-PgH6268" sorted by congress descending

✎ View and edit SQL

This data as json, CSV (advanced)

bill_type 3

congress 1

Link granule_id congress ▲ bill_type bill_number bill_id
CREC-2017-07-25-pt1-PgH6268,115,hres,468 PROVIDING FOR CONGRESSIONAL DISAPPROVAL OF THE RULE SUBMITTED BY BUREAU OF CONSUMER FINANCIAL PROTECTION RELATING TO ARBITRATION AGREEMENTS CREC-2017-07-25-pt1-PgH6268 115 hres 468 115-hres-468
CREC-2017-07-25-pt1-PgH6268,115,hr,3364 PROVIDING FOR CONGRESSIONAL DISAPPROVAL OF THE RULE SUBMITTED BY BUREAU OF CONSUMER FINANCIAL PROTECTION RELATING TO ARBITRATION AGREEMENTS CREC-2017-07-25-pt1-PgH6268 115 hr 3364 115-hr-3364
CREC-2017-07-25-pt1-PgH6268,115,hjres,111 PROVIDING FOR CONGRESSIONAL DISAPPROVAL OF THE RULE SUBMITTED BY BUREAU OF CONSUMER FINANCIAL PROTECTION RELATING TO ARBITRATION AGREEMENTS CREC-2017-07-25-pt1-PgH6268 115 hjres 111 115-hjres-111

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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