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

7 rows where report_id = "IF12310"

✎ 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
8357 The Small Business Administration’s Growth Accelerator Fund Competition IF12310   111 pub 111-358 111-pub-111-358
8358 The Small Business Administration’s Growth Accelerator Fund Competition IF12310   117 pub 117-163 117-pub-117-163
8359 The Small Business Administration’s Growth Accelerator Fund Competition IF12310   113 pub 113-235 113-pub-113-235
8360 The Small Business Administration’s Growth Accelerator Fund Competition IF12310 To codify the Small Business Administration's Growth Accelerator Fund Competition, and for other purposes. 115 hr 2686 115-hr-2686
8361 The Small Business Administration’s Growth Accelerator Fund Competition IF12310 To establish Growth Accelerator Fund Competition within the Small Business Administration, and for other purposes. 116 hr 4387 116-hr-4387
8362 The Small Business Administration’s Growth Accelerator Fund Competition IF12310 To provide for reconciliation pursuant to title II of S. Con. Res. 14. 117 hr 5376 117-hr-5376
8363 The Small Business Administration’s Growth Accelerator Fund Competition IF12310 To amend the Small Business Act to establish a growth accelerator fund competition, and for other purposes. 117 hr 4945 117-hr-4945

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