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

19 rows where bill_id = "103-s-4"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
103-s-4,Administrative procedure National Competitiveness Act of 1993 103-s-4 Administrative procedure
103-s-4,Agriculture and Food National Competitiveness Act of 1993 103-s-4 Agriculture and Food
103-s-4,Annuities National Competitiveness Act of 1993 103-s-4 Annuities
103-s-4,Armed Forces and National Security National Competitiveness Act of 1993 103-s-4 Armed Forces and National Security
103-s-4,Auditing National Competitiveness Act of 1993 103-s-4 Auditing
103-s-4,Authorization National Competitiveness Act of 1993 103-s-4 Authorization
103-s-4,Awards, medals, prizes National Competitiveness Act of 1993 103-s-4 Awards, medals, prizes
103-s-4,Bank records National Competitiveness Act of 1993 103-s-4 Bank records
103-s-4,Building construction National Competitiveness Act of 1993 103-s-4 Building construction
103-s-4,Business intelligence National Competitiveness Act of 1993 103-s-4 Business intelligence
103-s-4,Business records National Competitiveness Act of 1993 103-s-4 Business records
103-s-4,Buy American National Competitiveness Act of 1993 103-s-4 Buy American
103-s-4,Campaign funds National Competitiveness Act of 1993 103-s-4 Campaign funds
103-s-4,Chemical engineering National Competitiveness Act of 1993 103-s-4 Chemical engineering
103-s-4,Civil Rights and Liberties, Minority Issues National Competitiveness Act of 1993 103-s-4 Civil Rights and Liberties, Minority Issues
103-s-4,Civil Service pensions National Competitiveness Act of 1993 103-s-4 Civil Service pensions
103-s-4,Civil actions and liability National Competitiveness Act of 1993 103-s-4 Civil actions and liability
103-s-4,Claims National Competitiveness Act of 1993 103-s-4 Claims
103-s-4,Classified defense information National Competitiveness Act of 1993 103-s-4 Classified defense information

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