crs_report_bills

Cross-references between CRS reports and related legislation. Links CRS analysis to specific bills tracked in the legislation table.

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

4 rows where report_id = "IN12678"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: congress, bill_type

id ▼ report_id bill_title congress bill_type bill_number bill_id
14937 U.S.-Iran Ceasefire: Assessment, Reactions, and Issues for Congress IN12678   93 pub 93-148 93-pub-93-148
14938 U.S.-Iran Ceasefire: Assessment, Reactions, and Issues for Congress IN12678   114 pub 114-17 114-pub-114-17
14939 U.S.-Iran Ceasefire: Assessment, Reactions, and Issues for Congress IN12678 To provide for congressional review of actions to terminate or waive sanctions imposed with respect to Iran. 119 hr 2012 119-hr-2012
14940 U.S.-Iran Ceasefire: Assessment, Reactions, and Issues for Congress IN12678 To impose additional sanctions with respect to Iran and modify other existing sanctions with respect to Iran, and for other purposes. 119 hr 2570 119-hr-2570

Advanced export

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

CSV options: 

CREATE TABLE crs_report_bills (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    report_id TEXT NOT NULL REFERENCES crs_reports(id),
    bill_title TEXT,
    congress INTEGER,
    bill_type TEXT,
    bill_number INTEGER,
    bill_id TEXT
);
CREATE INDEX idx_crb_report ON crs_report_bills(report_id);
CREATE INDEX idx_crb_bill ON crs_report_bills(bill_id);