openregs: legislation_subjects: 9 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

9 rows where bill_id = "103-s-2004"

descending

Link	bill_id	subject
103-s-2004,Black colleges	A bill to extend until July 1, 1998, the exemption from ineligibility based on a high default rate for certain institutions of higher education. 103-s-2004	Black colleges
103-s-2004,Collection of accounts	A bill to extend until July 1, 1998, the exemption from ineligibility based on a high default rate for certain institutions of higher education. 103-s-2004	Collection of accounts
103-s-2004,Community colleges	A bill to extend until July 1, 1998, the exemption from ineligibility based on a high default rate for certain institutions of higher education. 103-s-2004	Community colleges
103-s-2004,Economics and Public Finance	A bill to extend until July 1, 1998, the exemption from ineligibility based on a high default rate for certain institutions of higher education. 103-s-2004	Economics and Public Finance
103-s-2004,Education of Indians	A bill to extend until July 1, 1998, the exemption from ineligibility based on a high default rate for certain institutions of higher education. 103-s-2004	Education of Indians
103-s-2004,Federal aid to higher education	A bill to extend until July 1, 1998, the exemption from ineligibility based on a high default rate for certain institutions of higher education. 103-s-2004	Federal aid to higher education
103-s-2004,Higher education	A bill to extend until July 1, 1998, the exemption from ineligibility based on a high default rate for certain institutions of higher education. 103-s-2004	Higher education
103-s-2004,Minorities	A bill to extend until July 1, 1998, the exemption from ineligibility based on a high default rate for certain institutions of higher education. 103-s-2004	Minorities
103-s-2004,Student loan funds	A bill to extend until July 1, 1998, the exemption from ineligibility based on a high default rate for certain institutions of higher education. 103-s-2004	Student loan funds

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