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 = "105-s-1535"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
105-s-1535,Administrative procedure Peanut Program Improvement Act of 1997 105-s-1535 Administrative procedure
105-s-1535,Agricultural colleges Peanut Program Improvement Act of 1997 105-s-1535 Agricultural colleges
105-s-1535,Agricultural credit Peanut Program Improvement Act of 1997 105-s-1535 Agricultural credit
105-s-1535,Agricultural price supports Peanut Program Improvement Act of 1997 105-s-1535 Agricultural price supports
105-s-1535,Agricultural research Peanut Program Improvement Act of 1997 105-s-1535 Agricultural research
105-s-1535,Agriculture in foreign trade Peanut Program Improvement Act of 1997 105-s-1535 Agriculture in foreign trade
105-s-1535,Department of Agriculture Peanut Program Improvement Act of 1997 105-s-1535 Department of Agriculture
105-s-1535,Education Peanut Program Improvement Act of 1997 105-s-1535 Education
105-s-1535,Farm production quotas Peanut Program Improvement Act of 1997 105-s-1535 Farm production quotas
105-s-1535,Finance and Financial Sector Peanut Program Improvement Act of 1997 105-s-1535 Finance and Financial Sector
105-s-1535,Fines (Penalties) Peanut Program Improvement Act of 1997 105-s-1535 Fines (Penalties)
105-s-1535,Foreign Trade and International Finance Peanut Program Improvement Act of 1997 105-s-1535 Foreign Trade and International Finance
105-s-1535,Government Operations and Politics Peanut Program Improvement Act of 1997 105-s-1535 Government Operations and Politics
105-s-1535,Higher education Peanut Program Improvement Act of 1997 105-s-1535 Higher education
105-s-1535,Import quotas Peanut Program Improvement Act of 1997 105-s-1535 Import quotas
105-s-1535,Interest Peanut Program Improvement Act of 1997 105-s-1535 Interest
105-s-1535,Law Peanut Program Improvement Act of 1997 105-s-1535 Law
105-s-1535,Marketing of farm produce Peanut Program Improvement Act of 1997 105-s-1535 Marketing of farm produce
105-s-1535,Peanuts Peanut Program Improvement Act of 1997 105-s-1535 Peanuts

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