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

19 rows where bill_id = "102-hr-4591"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
102-hr-4591,Aid to dependent children Community Works Progress Act of 1992 102-hr-4591 Aid to dependent children
102-hr-4591,Department of Labor Community Works Progress Act of 1992 102-hr-4591 Department of Labor
102-hr-4591,Education Community Works Progress Act of 1992 102-hr-4591 Education
102-hr-4591,Executive reorganization Community Works Progress Act of 1992 102-hr-4591 Executive reorganization
102-hr-4591,Federal aid to higher education Community Works Progress Act of 1992 102-hr-4591 Federal aid to higher education
102-hr-4591,Federal aid to youth services Community Works Progress Act of 1992 102-hr-4591 Federal aid to youth services
102-hr-4591,Food stamps Community Works Progress Act of 1992 102-hr-4591 Food stamps
102-hr-4591,Government paperwork Community Works Progress Act of 1992 102-hr-4591 Government paperwork
102-hr-4591,Grants-in-aid Community Works Progress Act of 1992 102-hr-4591 Grants-in-aid
102-hr-4591,Hard-core unemployed Community Works Progress Act of 1992 102-hr-4591 Hard-core unemployed
102-hr-4591,Income Community Works Progress Act of 1992 102-hr-4591 Income
102-hr-4591,Income tax Community Works Progress Act of 1992 102-hr-4591 Income tax
102-hr-4591,Job hunting Community Works Progress Act of 1992 102-hr-4591 Job hunting
102-hr-4591,Manpower training programs Community Works Progress Act of 1992 102-hr-4591 Manpower training programs
102-hr-4591,Poor Community Works Progress Act of 1992 102-hr-4591 Poor
102-hr-4591,Public assistance programs Community Works Progress Act of 1992 102-hr-4591 Public assistance programs
102-hr-4591,Public service employment Community Works Progress Act of 1992 102-hr-4591 Public service employment
102-hr-4591,Social security eligibility Community Works Progress Act of 1992 102-hr-4591 Social security eligibility
102-hr-4591,Student aid Community Works Progress Act of 1992 102-hr-4591 Student aid

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