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

✎ 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
12691 The Budget Resolution and the Senate’s Automatic Discharge Process IN11693   112 pub 112-37 112-pub-112-37
12692 The Budget Resolution and the Senate’s Automatic Discharge Process IN11693   112 pub 112-42 112-pub-112-42
12693 The Budget Resolution and the Senate’s Automatic Discharge Process IN11693   117 pub 117-14 117-pub-117-14
12694 The Budget Resolution and the Senate’s Automatic Discharge Process IN11693 A concurrent resolution setting forth the congressional budget for the United States Government for fiscal year 2013, and setting forth the appropriate budgetary levels for fiscal years 2014 through 2022. 112 sconres 37 112-sconres-37
12695 The Budget Resolution and the Senate’s Automatic Discharge Process IN11693 A concurrent resolution setting forth the congressional budget for the United States Government for fiscal year 2013, revising the appropriate budgetary levels for fiscal year 2012, and setting forth the appropriate budgetary levels for fiscal years 2013 through 2022. 112 sconres 42 112-sconres-42
12696 The Budget Resolution and the Senate’s Automatic Discharge Process IN11693 A concurrent resolution setting forth the congressional budget for the United States Government for fiscal year 2022 and setting forth the appropriate budgetary levels for fiscal years 2023 through 2031. 117 sconres 14 117-sconres-14

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