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

14 rows where bill_id = "103-s-2247"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
103-s-2247,Associations, institutions, etc. Housing for Older Persons Act of 1994 103-s-2247 Associations, institutions, etc.
103-s-2247,Church property Housing for Older Persons Act of 1994 103-s-2247 Church property
103-s-2247,Civil Rights and Liberties, Minority Issues Housing for Older Persons Act of 1994 103-s-2247 Civil Rights and Liberties, Minority Issues
103-s-2247,Civil actions and liability Housing for Older Persons Act of 1994 103-s-2247 Civil actions and liability
103-s-2247,Damages Housing for Older Persons Act of 1994 103-s-2247 Damages
103-s-2247,Families Housing for Older Persons Act of 1994 103-s-2247 Families
103-s-2247,Households Housing for Older Persons Act of 1994 103-s-2247 Households
103-s-2247,Housing discrimination Housing for Older Persons Act of 1994 103-s-2247 Housing discrimination
103-s-2247,Housing for the aged Housing for Older Persons Act of 1994 103-s-2247 Housing for the aged
103-s-2247,Law Housing for Older Persons Act of 1994 103-s-2247 Law
103-s-2247,Liability (Law) Housing for Older Persons Act of 1994 103-s-2247 Liability (Law)
103-s-2247,Real estate agents Housing for Older Persons Act of 1994 103-s-2247 Real estate agents
103-s-2247,Religion Housing for Older Persons Act of 1994 103-s-2247 Religion
103-s-2247,Social Welfare Housing for Older Persons Act of 1994 103-s-2247 Social Welfare

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