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

6 rows where bill_id = "119-hr-1352"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
119-hr-1352,Geography and mapping To designate the General George C. Marshall House, in the Commonwealth of Virginia, as an affiliated area of the National Park System, and for other purposes. 119-hr-1352 Geography and mapping
119-hr-1352,Historic sites and heritage areas To designate the General George C. Marshall House, in the Commonwealth of Virginia, as an affiliated area of the National Park System, and for other purposes. 119-hr-1352 Historic sites and heritage areas
119-hr-1352,Military history To designate the General George C. Marshall House, in the Commonwealth of Virginia, as an affiliated area of the National Park System, and for other purposes. 119-hr-1352 Military history
119-hr-1352,Parks, recreation areas, trails To designate the General George C. Marshall House, in the Commonwealth of Virginia, as an affiliated area of the National Park System, and for other purposes. 119-hr-1352 Parks, recreation areas, trails
119-hr-1352,U.S. history To designate the General George C. Marshall House, in the Commonwealth of Virginia, as an affiliated area of the National Park System, and for other purposes. 119-hr-1352 U.S. history
119-hr-1352,Virginia To designate the General George C. Marshall House, in the Commonwealth of Virginia, as an affiliated area of the National Park System, and for other purposes. 119-hr-1352 Virginia

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