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

3 rows where report_id = "IN12660"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: bill_type

id ▼ report_id bill_title congress bill_type bill_number bill_id
14860 The Child Support Enforcement Passport Denial Program IN12660   104 pub 104-193 104-pub-104-193
14861 The Child Support Enforcement Passport Denial Program IN12660   109 pub 109-171 109-pub-109-171
14862 The Child Support Enforcement Passport Denial Program IN12660 To require the Secretary of State to revoke any United States passport issued to an individual, on receipt of a certification by the Secretary of Health and Human Services that the individual has a child support arrearage exceeding $2,500. 119 hr 6903 119-hr-6903

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