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

7 rows where report_id = "R48072"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: congress, bill_type, bill_number, bill_id

id ▼ report_id bill_title congress bill_type bill_number bill_id
100928 Kenya: Current Issues and U.S. Relations R48072   106 pub 106-200 106-pub-106-200
100929 Kenya: Current Issues and U.S. Relations R48072   106 pub 106-200 106-pub-106-200
100930 Kenya: Current Issues and U.S. Relations R48072   119 pub 119-75 119-pub-119-75
100931 Kenya: Current Issues and U.S. Relations R48072 A resolution recognizing the strategic importance of Kenya to the United States and celebrating the 60-year anniversary of United States-Kenya relations. 118 sres 704 118-sres-704
100932 Kenya: Current Issues and U.S. Relations R48072 Recognizing the strategic importance of Kenya to the United States and celebrating the 60-year anniversary of United States-Kenya relations. 118 hres 1254 118-hres-1254
100933 Kenya: Current Issues and U.S. Relations R48072 A bill to restrict the use of United States Assessed Contributions to the United Nations under United Nations Security Council Resolution 2719 (2023) to support the African Union's peacekeeping mission in Somalia. 119 s 1583 119-s-1583
100934 Kenya: Current Issues and U.S. Relations R48072 Condemning Uganda's undemocratic human rights regression. 118 hres 1324 118-hres-1324

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