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

6 rows where report_id = "R48977"

✎ 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
110166 Russian Military Activities in Asia: Combined Military Exercises and Patrols R48977   118 pub 118-31 118-pub-118-31
110167 Russian Military Activities in Asia: Combined Military Exercises and Patrols R48977   117 pub 117-263 117-pub-117-263
110168 Russian Military Activities in Asia: Combined Military Exercises and Patrols R48977   119 pub 119-60 119-pub-119-60
110169 Russian Military Activities in Asia: Combined Military Exercises and Patrols R48977   116 pub 116-283 116-pub-116-283
110170 Russian Military Activities in Asia: Combined Military Exercises and Patrols R48977 A bill to require the imposition of sanctions with respect to Chinese financial institutions that clear, verify, or settle transactions with Russian or Russian-controlled financial institutions. 117 s 3877 117-s-3877
110171 Russian Military Activities in Asia: Combined Military Exercises and Patrols R48977 To impose certain sanctions relating to the People's Republic of China and support for the Russian invasion of Ukraine, and for other purposes. 118 hr 8043 118-hr-8043

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