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

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ report_id bill_title congress bill_type bill_number bill_id
14868 Executive Office for Immigration Review Immigration Judge Staffing Issues IN12664   119 pub 119-21 119-pub-119-21
14869 Executive Office for Immigration Review Immigration Judge Staffing Issues IN12664 To codify in statute the authorization of the Attorney General to appoint experienced immigration law experts as temporary immigration judges to reduce the number of pending cases in immigration courts. 119 hr 6497 119-hr-6497
14870 Executive Office for Immigration Review Immigration Judge Staffing Issues IN12664 A bill to codify in statute the authorization of the Attorney General to appoint experienced immigration law experts as temporary immigration judges to reduce the number of pending cases in immigration courts. 119 s 3326 119-s-3326

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