home / openregs

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

16 rows where report_id = "IF11200"

✎ 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
5113 Gold Star Designation: An Overview IF11200   89 pub 89-534 89-pub-89-534
5114 Gold Star Designation: An Overview IF11200   117 pub 117-103 117-pub-117-103
5115 Gold Star Designation: An Overview IF11200   117 pub 117-328 117-pub-117-328
5116 Gold Star Designation: An Overview IF11200   96 pub 96-497 96-pub-96-497
5117 Gold Star Designation: An Overview IF11200   98 pub 98-314 98-pub-98-314
5118 Gold Star Designation: An Overview IF11200   103 pub 103-160 103-pub-103-160
5119 Gold Star Designation: An Overview IF11200   105 pub 105-225 105-pub-105-225
5120 Gold Star Designation: An Overview IF11200   109 pub 109-163 109-pub-109-163
5121 Gold Star Designation: An Overview IF11200   109 pub 109-364 109-pub-109-364
5122 Gold Star Designation: An Overview IF11200   112 pub 112-239 112-pub-112-239
5123 Gold Star Designation: An Overview IF11200   113 pub 113-66 113-pub-113-66
5124 Gold Star Designation: An Overview IF11200   114 pub 114-62 114-pub-114-62
5125 Gold Star Designation: An Overview IF11200   114 pub 114-246 114-pub-114-246
5126 Gold Star Designation: An Overview IF11200   116 pub 116-92 116-pub-116-92
5127 Gold Star Designation: An Overview IF11200   116 pub 116-283 116-pub-116-283
5128 Gold Star Designation: An Overview IF11200   117 pub 117-81 117-pub-117-81

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);
Powered by Datasette · Queries took 21.265ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API