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

12 rows where bill_id = "103-s-9"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
103-s-9,Appropriations Legislative Line Item Veto Act of 1993 103-s-9 Appropriations
103-s-9,Balanced budgets Legislative Line Item Veto Act of 1993 103-s-9 Balanced budgets
103-s-9,Budget deficits Legislative Line Item Veto Act of 1993 103-s-9 Budget deficits
103-s-9,Congressional veto Legislative Line Item Veto Act of 1993 103-s-9 Congressional veto
103-s-9,Executive impoundment of appropriated funds Legislative Line Item Veto Act of 1993 103-s-9 Executive impoundment of appropriated funds
103-s-9,Federal budgets Legislative Line Item Veto Act of 1993 103-s-9 Federal budgets
103-s-9,House rules and procedure Legislative Line Item Veto Act of 1993 103-s-9 House rules and procedure
103-s-9,Item veto Legislative Line Item Veto Act of 1993 103-s-9 Item veto
103-s-9,Legislation Legislative Line Item Veto Act of 1993 103-s-9 Legislation
103-s-9,Presidential powers Legislative Line Item Veto Act of 1993 103-s-9 Presidential powers
103-s-9,Public debt Legislative Line Item Veto Act of 1993 103-s-9 Public debt
103-s-9,Senate rules and procedure Legislative Line Item Veto Act of 1993 103-s-9 Senate rules and procedure

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