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

✎ 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
11034 Soft Targets and the Nonprofit Security Grant Program IF13201   118 pub 118-50 118-pub-118-50
11035 Soft Targets and the Nonprofit Security Grant Program IF13201 To authorize and improve the Federal Emergency Management Agency and reform Federal disaster mitigation, preparedness, response, and recovery, and for other purposes. 119 hr 4669 119-hr-4669
11036 Soft Targets and the Nonprofit Security Grant Program IF13201 To amend the Homeland Security Act of 2002 and certain other laws relating to certain preparedness, transit, and port security grant programs to improve oversight, transparency, and stakeholder engagement in the administration of such grant programs, and for other purposes. 119 hr 6507 119-hr-6507

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