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

8 rows where report_id = "R48912"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: congress

id ▼ report_id bill_title congress bill_type bill_number bill_id
109089 Child Welfare Funding in the President’s FY2027 Budget: In Brief R48912   118 pub 118-47 118-pub-118-47
109090 Child Welfare Funding in the President’s FY2027 Budget: In Brief R48912   118 pub 118-42 118-pub-118-42
109091 Child Welfare Funding in the President’s FY2027 Budget: In Brief R48912   119 pub 119-4 119-pub-119-4
109092 Child Welfare Funding in the President’s FY2027 Budget: In Brief R48912   119 pub 119-75 119-pub-119-75
109093 Child Welfare Funding in the President’s FY2027 Budget: In Brief R48912   119 pub 119-74 119-pub-119-74
109094 Child Welfare Funding in the President’s FY2027 Budget: In Brief R48912   109 pub 109-149 109-pub-109-149
109095 Child Welfare Funding in the President’s FY2027 Budget: In Brief R48912   115 pub 115-245 115-pub-115-245
109096 Child Welfare Funding in the President’s FY2027 Budget: In Brief R48912   116 pub 116-6 116-pub-116-6

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