openregs: legislation_subjects: 8 rows where bill

CRS legislative subject terms assigned to bills, useful for filtering by topic.

Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API

8 rows where bill_id = "110-s-2829"

descending

Link	bill_id	subject
110-s-2829,Administrative remedies	A bill to make technical corrections to section 1244 of the National Defense Authorization Act for Fiscal Year 2008, which provides special immigrant status for certain Iraqis, and for other purposes. 110-s-2829	Administrative remedies
110-s-2829,Aliens	A bill to make technical corrections to section 1244 of the National Defense Authorization Act for Fiscal Year 2008, which provides special immigrant status for certain Iraqis, and for other purposes. 110-s-2829	Aliens
110-s-2829,Immigrants	A bill to make technical corrections to section 1244 of the National Defense Authorization Act for Fiscal Year 2008, which provides special immigrant status for certain Iraqis, and for other purposes. 110-s-2829	Immigrants
110-s-2829,Iraq	A bill to make technical corrections to section 1244 of the National Defense Authorization Act for Fiscal Year 2008, which provides special immigrant status for certain Iraqis, and for other purposes. 110-s-2829	Iraq
110-s-2829,Iraq compilation	A bill to make technical corrections to section 1244 of the National Defense Authorization Act for Fiscal Year 2008, which provides special immigrant status for certain Iraqis, and for other purposes. 110-s-2829	Iraq compilation
110-s-2829,Law	A bill to make technical corrections to section 1244 of the National Defense Authorization Act for Fiscal Year 2008, which provides special immigrant status for certain Iraqis, and for other purposes. 110-s-2829	Law
110-s-2829,Middle East and North Africa	A bill to make technical corrections to section 1244 of the National Defense Authorization Act for Fiscal Year 2008, which provides special immigrant status for certain Iraqis, and for other purposes. 110-s-2829	Middle East and North Africa
110-s-2829,Visas	A bill to make technical corrections to section 1244 of the National Defense Authorization Act for Fiscal Year 2008, which provides special immigrant status for certain Iraqis, and for other purposes. 110-s-2829	Visas

Advanced export

JSON shape: default, array, newline-delimited, object

CREATE TABLE legislation_subjects (
    bill_id TEXT REFERENCES legislation(bill_id),
    subject TEXT,
    PRIMARY KEY (bill_id, subject)
);
CREATE INDEX idx_legsub_subject ON legislation_subjects(subject);