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

3 rows where report_id = "IN12662"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: bill_type

id ▼ report_id bill_title congress bill_type bill_number bill_id
14864 U.S. and Israeli Military Operations Against Iran: Issues for Congress IN12662 Directing the President pursuant to section 5(c) of the War Powers Resolution to remove United States Armed Forces from unauthorized hostilities in the Islamic Republic of Iran. 119 hconres 38 119-hconres-38
14865 U.S. and Israeli Military Operations Against Iran: Issues for Congress IN12662 A joint resolution to direct the removal of United States Armed Forces from hostilities within or against the Islamic Republic of Iran that have not been authorized by Congress. 119 sjres 104 119-sjres-104
14866 U.S. and Israeli Military Operations Against Iran: Issues for Congress IN12662 A joint resolution to direct the removal of United States Armed Forces from hostilities against the Islamic Republic of Iran that have not been authorized by Congress. 119 sjres 59 119-sjres-59

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