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

11 rows where report_id = "R48928"

✎ 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
109226 Restoring the Great Salt Lake Ecosystem R48928   117 pub 117-169 117-pub-117-169
109227 Restoring the Great Salt Lake Ecosystem R48928   118 pub 118-169 118-pub-118-169
109228 Restoring the Great Salt Lake Ecosystem R48928   102 pub 102-575 102-pub-102-575
109229 Restoring the Great Salt Lake Ecosystem R48928   117 pub 117-318 117-pub-117-318
109230 Restoring the Great Salt Lake Ecosystem R48928   117 pub 117-263 117-pub-117-263
109231 Restoring the Great Salt Lake Ecosystem R48928   108 pub 108-361 108-pub-108-361
109232 Restoring the Great Salt Lake Ecosystem R48928   117 pub 117-103 117-pub-117-103
109233 Restoring the Great Salt Lake Ecosystem R48928   106 pub 106-541 106-pub-106-541
109234 Restoring the Great Salt Lake Ecosystem R48928   110 pub 110-229 110-pub-110-229
109235 Restoring the Great Salt Lake Ecosystem R48928   116 pub 116-94 116-pub-116-94
109236 Restoring the Great Salt Lake Ecosystem R48928 A bill to authorize the Federal Emergency Management Agency to waive certain requirements for property acquisition and structure demolition or relocation projects. 119 s 378 119-s-378

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