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

10 rows where report_id = "IF12976"

✎ 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
10336 1944 U.S.-Mexico Water Treaty: Issues in the 119th Congress IF12976   119 pub 119-75 119-pub-119-75
10337 1944 U.S.-Mexico Water Treaty: Issues in the 119th Congress IF12976   117 pub 117-328 117-pub-117-328
10338 1944 U.S.-Mexico Water Treaty: Issues in the 119th Congress IF12976   118 pub 118-31 118-pub-118-31
10339 1944 U.S.-Mexico Water Treaty: Issues in the 119th Congress IF12976   116 pub 116-113 116-pub-116-113
10340 1944 U.S.-Mexico Water Treaty: Issues in the 119th Congress IF12976   118 pub 118-158 118-pub-118-158
10341 1944 U.S.-Mexico Water Treaty: Issues in the 119th Congress IF12976   118 pub 118-47 118-pub-118-47
10342 1944 U.S.-Mexico Water Treaty: Issues in the 119th Congress IF12976   119 pub 119-4 119-pub-119-4
10343 1944 U.S.-Mexico Water Treaty: Issues in the 119th Congress IF12976 Making appropriations for National Security, Department of State, and Related Programs for the fiscal year ending September 30, 2026, and for other purposes. 119 hr 4779 119-hr-4779
10344 1944 U.S.-Mexico Water Treaty: Issues in the 119th Congress IF12976 To limit engagement with the Government of Mexico unless Mexico provides water to the United States pursuant to its obligations under the Treaty relating to the Utilization of Waters of the Colorado and Tijuana Rivers and of the Rio Grande. 119 hr 6386 119-hr-6386
10345 1944 U.S.-Mexico Water Treaty: Issues in the 119th Congress IF12976 A bill to limit engagement with the Government of Mexico unless Mexico provides water to the United States pursuant to its obligations under the Treaty relating to the Utilization of Waters of the Colorado and Tijuana Rivers and of the Rio Grande. 119 s 3120 119-s-3120

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