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

13 rows where bill_id = "108-hconres-511"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
108-hconres-511,Congress Expressing the sense of the Congress with respect to Inez Sitter. 108-hconres-511 Congress
108-hconres-511,Congressional tributes Expressing the sense of the Congress with respect to Inez Sitter. 108-hconres-511 Congressional tributes
108-hconres-511,Education Expressing the sense of the Congress with respect to Inez Sitter. 108-hconres-511 Education
108-hconres-511,Elementary and secondary education Expressing the sense of the Congress with respect to Inez Sitter. 108-hconres-511 Elementary and secondary education
108-hconres-511,Elementary education Expressing the sense of the Congress with respect to Inez Sitter. 108-hconres-511 Elementary education
108-hconres-511,Minorities Expressing the sense of the Congress with respect to Inez Sitter. 108-hconres-511 Minorities
108-hconres-511,Minority education Expressing the sense of the Congress with respect to Inez Sitter. 108-hconres-511 Minority education
108-hconres-511,Native Americans Expressing the sense of the Congress with respect to Inez Sitter. 108-hconres-511 Native Americans
108-hconres-511,Oklahoma Expressing the sense of the Congress with respect to Inez Sitter. 108-hconres-511 Oklahoma
108-hconres-511,School administration Expressing the sense of the Congress with respect to Inez Sitter. 108-hconres-511 School administration
108-hconres-511,School personnel Expressing the sense of the Congress with respect to Inez Sitter. 108-hconres-511 School personnel
108-hconres-511,Secondary education Expressing the sense of the Congress with respect to Inez Sitter. 108-hconres-511 Secondary education
108-hconres-511,Teachers Expressing the sense of the Congress with respect to Inez Sitter. 108-hconres-511 Teachers

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