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

6 rows where report_id = "R48872"

✎ 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
108388 Nippon Steel’s Acquisition of U.S. Steel: Potential Implications for the Industry R48872   117 pub 117-169 117-pub-117-169
108389 Nippon Steel’s Acquisition of U.S. Steel: Potential Implications for the Industry R48872   107 pub 107-107 107-pub-107-107
108390 Nippon Steel’s Acquisition of U.S. Steel: Potential Implications for the Industry R48872   116 pub 116-92 116-pub-116-92
108391 Nippon Steel’s Acquisition of U.S. Steel: Potential Implications for the Industry R48872   117 pub 117-58 117-pub-117-58
108392 Nippon Steel’s Acquisition of U.S. Steel: Potential Implications for the Industry R48872   119 pub 119-21 119-pub-119-21
108393 Nippon Steel’s Acquisition of U.S. Steel: Potential Implications for the Industry R48872 To strengthen domestic manufacturing, bring next generation iron and steel back to the United States, and revitalize deindustrialized regions. 118 hr 9334 118-hr-9334

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