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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: bill_type

id ▼ report_id bill_title congress bill_type bill_number bill_id
37487 Federal Grants-in-Aid Administration: A Primer R42769   106 pub 106-107 106-pub-106-107
37488 Federal Grants-in-Aid Administration: A Primer R42769   110 pub 110-282 110-pub-110-282
37489 Federal Grants-in-Aid Administration: A Primer R42769   98 pub 98-502 98-pub-98-502
37490 Federal Grants-in-Aid Administration: A Primer R42769   113 pub 113-101 113-pub-113-101
37491 Federal Grants-in-Aid Administration: A Primer R42769   109 pub 109-282 109-pub-109-282
37492 Federal Grants-in-Aid Administration: A Primer R42769   116 pub 116-103 116-pub-116-103
37493 Federal Grants-in-Aid Administration: A Primer R42769   93 pub 93-344 93-pub-93-344
37494 Federal Grants-in-Aid Administration: A Primer R42769 A bill making appropriations for financial services and general government for the fiscal year ending September 30, 2026, and for other purposes. 119 s 3290 119-s-3290

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