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

16 rows where granule_id = "CREC-2003-07-21-pt1-PgE1548" sorted by congress descending

✎ View and edit SQL

This data as json, CSV (advanced)

bill_type 4

congress 1

Link granule_id congress ▲ bill_type bill_number bill_id
CREC-2003-07-21-pt1-PgE1548,108,sres,4 SENATE COMMITTEE MEETINGS CREC-2003-07-21-pt1-PgE1548 108 sres 4 108-sres-4
CREC-2003-07-21-pt1-PgE1548,108,s,1314 SENATE COMMITTEE MEETINGS CREC-2003-07-21-pt1-PgE1548 108 s 1314 108-s-1314
CREC-2003-07-21-pt1-PgE1548,108,s,1289 SENATE COMMITTEE MEETINGS CREC-2003-07-21-pt1-PgE1548 108 s 1289 108-s-1289
CREC-2003-07-21-pt1-PgE1548,108,s,1283 SENATE COMMITTEE MEETINGS CREC-2003-07-21-pt1-PgE1548 108 s 1283 108-s-1283
CREC-2003-07-21-pt1-PgE1548,108,s,1213 SENATE COMMITTEE MEETINGS CREC-2003-07-21-pt1-PgE1548 108 s 1213 108-s-1213
CREC-2003-07-21-pt1-PgE1548,108,s,1156 SENATE COMMITTEE MEETINGS CREC-2003-07-21-pt1-PgE1548 108 s 1156 108-s-1156
CREC-2003-07-21-pt1-PgE1548,108,s,1144 SENATE COMMITTEE MEETINGS CREC-2003-07-21-pt1-PgE1548 108 s 1144 108-s-1144
CREC-2003-07-21-pt1-PgE1548,108,s,1107 SENATE COMMITTEE MEETINGS CREC-2003-07-21-pt1-PgE1548 108 s 1107 108-s-1107
CREC-2003-07-21-pt1-PgE1548,108,s,808 SENATE COMMITTEE MEETINGS CREC-2003-07-21-pt1-PgE1548 108 s 808 108-s-808
CREC-2003-07-21-pt1-PgE1548,108,s,615 SENATE COMMITTEE MEETINGS CREC-2003-07-21-pt1-PgE1548 108 s 615 108-s-615
CREC-2003-07-21-pt1-PgE1548,108,s,613 SENATE COMMITTEE MEETINGS CREC-2003-07-21-pt1-PgE1548 108 s 613 108-s-613
CREC-2003-07-21-pt1-PgE1548,108,s,578 SENATE COMMITTEE MEETINGS CREC-2003-07-21-pt1-PgE1548 108 s 578 108-s-578
CREC-2003-07-21-pt1-PgE1548,108,s,556 SENATE COMMITTEE MEETINGS CREC-2003-07-21-pt1-PgE1548 108 s 556 108-s-556
CREC-2003-07-21-pt1-PgE1548,108,hr,1904 SENATE COMMITTEE MEETINGS CREC-2003-07-21-pt1-PgE1548 108 hr 1904 108-hr-1904
CREC-2003-07-21-pt1-PgE1548,108,hr,620 SENATE COMMITTEE MEETINGS CREC-2003-07-21-pt1-PgE1548 108 hr 620 108-hr-620
CREC-2003-07-21-pt1-PgE1548,108,hconres,209 SENATE COMMITTEE MEETINGS CREC-2003-07-21-pt1-PgE1548 108 hconres 209 108-hconres-209

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