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

4 rows where bill_id = "109-hr-6387"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
109-hr-6387,Cemeteries and funerals To amend title 10, United States Code, to provide for support of funeral ceremonies for veterans provided by details that consist solely of members of veterans organizations and other organizations, and for other purposes. 109-hr-6387 Cemeteries and funerals
109-hr-6387,Transportation and Public Works To amend title 10, United States Code, to provide for support of funeral ceremonies for veterans provided by details that consist solely of members of veterans organizations and other organizations, and for other purposes. 109-hr-6387 Transportation and Public Works
109-hr-6387,Travel costs To amend title 10, United States Code, to provide for support of funeral ceremonies for veterans provided by details that consist solely of members of veterans organizations and other organizations, and for other purposes. 109-hr-6387 Travel costs
109-hr-6387,Veterans' organizations To amend title 10, United States Code, to provide for support of funeral ceremonies for veterans provided by details that consist solely of members of veterans organizations and other organizations, and for other purposes. 109-hr-6387 Veterans' organizations

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