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

10 rows where bill_id = "103-s-2145"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
103-s-2145,Administrative procedure Agricultural Mediation Act of 1994 103-s-2145 Administrative procedure
103-s-2145,Agricultural credit Agricultural Mediation Act of 1994 103-s-2145 Agricultural credit
103-s-2145,Agricultural economics Agricultural Mediation Act of 1994 103-s-2145 Agricultural economics
103-s-2145,Department of Agriculture Agricultural Mediation Act of 1994 103-s-2145 Department of Agriculture
103-s-2145,Economics and Public Finance Agricultural Mediation Act of 1994 103-s-2145 Economics and Public Finance
103-s-2145,Federal-state relations Agricultural Mediation Act of 1994 103-s-2145 Federal-state relations
103-s-2145,Government Operations and Politics Agricultural Mediation Act of 1994 103-s-2145 Government Operations and Politics
103-s-2145,Grants-in-aid Agricultural Mediation Act of 1994 103-s-2145 Grants-in-aid
103-s-2145,Law Agricultural Mediation Act of 1994 103-s-2145 Law
103-s-2145,Mediation Agricultural Mediation Act of 1994 103-s-2145 Mediation

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