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 = "R46259"

✎ 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
78265 Northern Ireland: The Peace Process, Ongoing Challenges, and U.S. Interests R46259   118 pub 118-157 118-pub-118-157
78266 Northern Ireland: The Peace Process, Ongoing Challenges, and U.S. Interests R46259   117 pub 117-117 117-pub-117-117
78267 Northern Ireland: The Peace Process, Ongoing Challenges, and U.S. Interests R46259   117 pub 117-134 117-pub-117-134
78268 Northern Ireland: The Peace Process, Ongoing Challenges, and U.S. Interests R46259   112 pub 112-10 112-pub-112-10
78269 Northern Ireland: The Peace Process, Ongoing Challenges, and U.S. Interests R46259   99 pub 99-415 99-pub-99-415
78270 Northern Ireland: The Peace Process, Ongoing Challenges, and U.S. Interests R46259 Reaffirming the State of Israel's right to exist. 118 hres 888 118-hres-888
78271 Northern Ireland: The Peace Process, Ongoing Challenges, and U.S. Interests R46259 Reaffirming support for the Good Friday Agreement and other agreements to ensure a lasting peace in Northern Ireland. 116 hres 585 116-hres-585
78272 Northern Ireland: The Peace Process, Ongoing Challenges, and U.S. Interests R46259 A resolution commemorating the 25th anniversary of the signing of the Good Friday Agreement, and for other purposes. 118 sres 157 118-sres-157
78273 Northern Ireland: The Peace Process, Ongoing Challenges, and U.S. Interests R46259 A resolution expressing support for the full implementation of the Good Friday Agreement, or the Belfast Agreement, and subsequent agreements and arrangements for implementation to support peace on the island of Ireland. 117 sres 117 117-sres-117
78274 Northern Ireland: The Peace Process, Ongoing Challenges, and U.S. Interests R46259 A resolution expressing the sense of the Senate that the President should work with the Government of the United Kingdom to conclude negotiations for a comprehensive free trade agreement between the United States and the United Kingdom. 117 sres 134 117-sres-134

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