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

39 rows where bill_id = "108-s-2575"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
108-s-2575,Agriculture and Food Sudden Oak Death Syndrome Control Act of 2004 108-s-2575 Agriculture and Food
108-s-2575,Biological research Sudden Oak Death Syndrome Control Act of 2004 108-s-2575 Biological research
108-s-2575,Data banks Sudden Oak Death Syndrome Control Act of 2004 108-s-2575 Data banks
108-s-2575,Economics and Public Finance Sudden Oak Death Syndrome Control Act of 2004 108-s-2575 Economics and Public Finance
108-s-2575,Electronic government information Sudden Oak Death Syndrome Control Act of 2004 108-s-2575 Electronic government information
108-s-2575,Emergency Management Sudden Oak Death Syndrome Control Act of 2004 108-s-2575 Emergency Management
108-s-2575,Environmental Protection Sudden Oak Death Syndrome Control Act of 2004 108-s-2575 Environmental Protection
108-s-2575,Environmental monitoring Sudden Oak Death Syndrome Control Act of 2004 108-s-2575 Environmental monitoring
108-s-2575,Environmental research Sudden Oak Death Syndrome Control Act of 2004 108-s-2575 Environmental research
108-s-2575,Federal-Indian relations Sudden Oak Death Syndrome Control Act of 2004 108-s-2575 Federal-Indian relations
108-s-2575,Federal-local relations Sudden Oak Death Syndrome Control Act of 2004 108-s-2575 Federal-local relations
108-s-2575,Federal-state relations Sudden Oak Death Syndrome Control Act of 2004 108-s-2575 Federal-state relations
108-s-2575,Fire prevention Sudden Oak Death Syndrome Control Act of 2004 108-s-2575 Fire prevention
108-s-2575,Forest conservation Sudden Oak Death Syndrome Control Act of 2004 108-s-2575 Forest conservation
108-s-2575,Forest fires Sudden Oak Death Syndrome Control Act of 2004 108-s-2575 Forest fires
108-s-2575,Forest management Sudden Oak Death Syndrome Control Act of 2004 108-s-2575 Forest management
108-s-2575,Fungi Sudden Oak Death Syndrome Control Act of 2004 108-s-2575 Fungi
108-s-2575,Geographic information systems Sudden Oak Death Syndrome Control Act of 2004 108-s-2575 Geographic information systems
108-s-2575,Government Operations and Politics Sudden Oak Death Syndrome Control Act of 2004 108-s-2575 Government Operations and Politics
108-s-2575,Government paperwork Sudden Oak Death Syndrome Control Act of 2004 108-s-2575 Government paperwork
108-s-2575,Government publicity Sudden Oak Death Syndrome Control Act of 2004 108-s-2575 Government publicity
108-s-2575,Grants-in-aid Sudden Oak Death Syndrome Control Act of 2004 108-s-2575 Grants-in-aid
108-s-2575,Horticulture Sudden Oak Death Syndrome Control Act of 2004 108-s-2575 Horticulture
108-s-2575,Internet Sudden Oak Death Syndrome Control Act of 2004 108-s-2575 Internet
108-s-2575,Minorities Sudden Oak Death Syndrome Control Act of 2004 108-s-2575 Minorities
108-s-2575,Native Americans Sudden Oak Death Syndrome Control Act of 2004 108-s-2575 Native Americans
108-s-2575,Nonprofit organizations Sudden Oak Death Syndrome Control Act of 2004 108-s-2575 Nonprofit organizations
108-s-2575,Plant breeding Sudden Oak Death Syndrome Control Act of 2004 108-s-2575 Plant breeding
108-s-2575,Plant diseases Sudden Oak Death Syndrome Control Act of 2004 108-s-2575 Plant diseases
108-s-2575,Recycling of waste products Sudden Oak Death Syndrome Control Act of 2004 108-s-2575 Recycling of waste products
108-s-2575,Reforestation Sudden Oak Death Syndrome Control Act of 2004 108-s-2575 Reforestation
108-s-2575,Refuse and refuse disposal Sudden Oak Death Syndrome Control Act of 2004 108-s-2575 Refuse and refuse disposal
108-s-2575,Restoration ecology Sudden Oak Death Syndrome Control Act of 2004 108-s-2575 Restoration ecology
108-s-2575,Risk Sudden Oak Death Syndrome Control Act of 2004 108-s-2575 Risk
108-s-2575,Science, Technology, Communications Sudden Oak Death Syndrome Control Act of 2004 108-s-2575 Science, Technology, Communications
108-s-2575,Social Welfare Sudden Oak Death Syndrome Control Act of 2004 108-s-2575 Social Welfare
108-s-2575,Surveys Sudden Oak Death Syndrome Control Act of 2004 108-s-2575 Surveys
108-s-2575,Tree diseases Sudden Oak Death Syndrome Control Act of 2004 108-s-2575 Tree diseases
108-s-2575,Web sites Sudden Oak Death Syndrome Control Act of 2004 108-s-2575 Web sites

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