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

4 rows where report_id = "LSB11437"

✎ 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
15440 Denaturalization: A Brief Overview of the Current Legal Framework LSB11437 A bill to expand and clarify the grounds for civil denaturalization proceedings for individuals who have defrauded a governmental program, joined a terrorist organization, or committed certain criminal offenses. 119 s 3674 119-s-3674
15441 Denaturalization: A Brief Overview of the Current Legal Framework LSB11437 To expand and clarify the grounds for civil denaturalization proceedings for individuals who have defrauded a governmental program, joined a terrorist organization, or committed certain criminal offenses. 119 hr 7156 119-hr-7156
15442 Denaturalization: A Brief Overview of the Current Legal Framework LSB11437 A bill to include any felony conviction as a ground for revocation of naturalization, to strike the 5-year limitation on the revocation of naturalization for membership in certain totalitarian or treasonous organizations, and to eliminate the 10-year statute of limitation for certain criminal penalties that would disqualify a person from naturalization. 119 s 4105 119-s-4105
15443 Denaturalization: A Brief Overview of the Current Legal Framework LSB11437 A bill to terminate Federal benefits for noncitizens, to authorize the denaturalization of naturalized citizens who undermine domestic tranquility, to expand expedited removal authority, to require mandatory revetting of nationals of Afghanistan, and to provide for automatic termination of temporary protected status, and for other purposes. 119 s 3318 119-s-3318

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