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

3 rows where bill_id = "93-s-4165"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
93-s-4165,Advisory bodies A bill to make more chemical fertilizer available throughout the world for the production of food during 1975 by substantially reducing the amount of such fertilizer used in the United States for non-food-growing purposes. 93-s-4165 Advisory bodies
93-s-4165,Fertilizers A bill to make more chemical fertilizer available throughout the world for the production of food during 1975 by substantially reducing the amount of such fertilizer used in the United States for non-food-growing purposes. 93-s-4165 Fertilizers
93-s-4165,Government Operations and Politics A bill to make more chemical fertilizer available throughout the world for the production of food during 1975 by substantially reducing the amount of such fertilizer used in the United States for non-food-growing purposes. 93-s-4165 Government Operations and Politics

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