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 = "111-s-3263"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
111-s-3263,Animal protection and human-animal relationships A bill to establish a Chief Veterinary Officer in the Department of Homeland Security, and for other purposes. 111-s-3263 Animal protection and human-animal relationships
111-s-3263,Department of Homeland Security A bill to establish a Chief Veterinary Officer in the Department of Homeland Security, and for other purposes. 111-s-3263 Department of Homeland Security
111-s-3263,Emergency medical services and trauma care A bill to establish a Chief Veterinary Officer in the Department of Homeland Security, and for other purposes. 111-s-3263 Emergency medical services and trauma care
111-s-3263,Executive agency funding and structure A bill to establish a Chief Veterinary Officer in the Department of Homeland Security, and for other purposes. 111-s-3263 Executive agency funding and structure
111-s-3263,Federal officials A bill to establish a Chief Veterinary Officer in the Department of Homeland Security, and for other purposes. 111-s-3263 Federal officials
111-s-3263,Food supply, safety, and labeling A bill to establish a Chief Veterinary Officer in the Department of Homeland Security, and for other purposes. 111-s-3263 Food supply, safety, and labeling
111-s-3263,Medical research A bill to establish a Chief Veterinary Officer in the Department of Homeland Security, and for other purposes. 111-s-3263 Medical research
111-s-3263,Research and development A bill to establish a Chief Veterinary Officer in the Department of Homeland Security, and for other purposes. 111-s-3263 Research and development
111-s-3263,Terrorism A bill to establish a Chief Veterinary Officer in the Department of Homeland Security, and for other purposes. 111-s-3263 Terrorism
111-s-3263,Veterinary medicine and animal diseases A bill to establish a Chief Veterinary Officer in the Department of Homeland Security, and for other purposes. 111-s-3263 Veterinary medicine and animal diseases

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