legislation_subjects

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 = "104-hconres-164"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
104-hconres-164,Associations, institutions, etc. Honoring the national organization of Future Business Leaders of America-Phi Beta Lambda. 104-hconres-164 Associations, institutions, etc.
104-hconres-164,Business and social problems Honoring the national organization of Future Business Leaders of America-Phi Beta Lambda. 104-hconres-164 Business and social problems
104-hconres-164,Commemorations Honoring the national organization of Future Business Leaders of America-Phi Beta Lambda. 104-hconres-164 Commemorations
104-hconres-164,Congress Honoring the national organization of Future Business Leaders of America-Phi Beta Lambda. 104-hconres-164 Congress
104-hconres-164,Congressional tributes Honoring the national organization of Future Business Leaders of America-Phi Beta Lambda. 104-hconres-164 Congressional tributes
104-hconres-164,Families Honoring the national organization of Future Business Leaders of America-Phi Beta Lambda. 104-hconres-164 Families
104-hconres-164,Social Welfare Honoring the national organization of Future Business Leaders of America-Phi Beta Lambda. 104-hconres-164 Social Welfare
104-hconres-164,Volunteer workers in social service Honoring the national organization of Future Business Leaders of America-Phi Beta Lambda. 104-hconres-164 Volunteer workers in social service
104-hconres-164,Youth services Honoring the national organization of Future Business Leaders of America-Phi Beta Lambda. 104-hconres-164 Youth services

Advanced export

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

CSV options: 

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