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

9 rows where bill_id = "111-s-3505"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
111-s-3505,Alternative and renewable resources China Fair Trade Act of 2010 111-s-3505 Alternative and renewable resources
111-s-3505,Asia China Fair Trade Act of 2010 111-s-3505 Asia
111-s-3505,Buy American requirements China Fair Trade Act of 2010 111-s-3505 Buy American requirements
111-s-3505,China China Fair Trade Act of 2010 111-s-3505 China
111-s-3505,Congressional oversight China Fair Trade Act of 2010 111-s-3505 Congressional oversight
111-s-3505,Manufacturing China Fair Trade Act of 2010 111-s-3505 Manufacturing
111-s-3505,Military procurement, research, weapons development China Fair Trade Act of 2010 111-s-3505 Military procurement, research, weapons development
111-s-3505,Public contracts and procurement China Fair Trade Act of 2010 111-s-3505 Public contracts and procurement
111-s-3505,Trade agreements and negotiations China Fair Trade Act of 2010 111-s-3505 Trade agreements and negotiations

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