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

7 rows where bill_id = "114-hr-1682"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
114-hr-1682,Commemorative events and holidays National Jazz Preservation, Education, and Promulgation Act of 2015 114-hr-1682 Commemorative events and holidays
114-hr-1682,Elementary and secondary education National Jazz Preservation, Education, and Promulgation Act of 2015 114-hr-1682 Elementary and secondary education
114-hr-1682,Historical and cultural resources National Jazz Preservation, Education, and Promulgation Act of 2015 114-hr-1682 Historical and cultural resources
114-hr-1682,Museums, exhibitions, cultural centers National Jazz Preservation, Education, and Promulgation Act of 2015 114-hr-1682 Museums, exhibitions, cultural centers
114-hr-1682,Music National Jazz Preservation, Education, and Promulgation Act of 2015 114-hr-1682 Music
114-hr-1682,Sound recording National Jazz Preservation, Education, and Promulgation Act of 2015 114-hr-1682 Sound recording
114-hr-1682,Teaching, teachers, curricula National Jazz Preservation, Education, and Promulgation Act of 2015 114-hr-1682 Teaching, teachers, curricula

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