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-1007"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
105-s-1007,Agriculture and Food Disaster Streamlining and Costs Reduction Act of 1997 105-s-1007 Agriculture and Food
105-s-1007,Arts, Culture, Religion Disaster Streamlining and Costs Reduction Act of 1997 105-s-1007 Arts, Culture, Religion
105-s-1007,Beaches Disaster Streamlining and Costs Reduction Act of 1997 105-s-1007 Beaches
105-s-1007,Cemeteries and funerals Disaster Streamlining and Costs Reduction Act of 1997 105-s-1007 Cemeteries and funerals
105-s-1007,Commerce Disaster Streamlining and Costs Reduction Act of 1997 105-s-1007 Commerce
105-s-1007,Construction costs Disaster Streamlining and Costs Reduction Act of 1997 105-s-1007 Construction costs
105-s-1007,Cultural property Disaster Streamlining and Costs Reduction Act of 1997 105-s-1007 Cultural property
105-s-1007,Dental care Disaster Streamlining and Costs Reduction Act of 1997 105-s-1007 Dental care
105-s-1007,Disaster insurance Disaster Streamlining and Costs Reduction Act of 1997 105-s-1007 Disaster insurance
105-s-1007,Disaster loans Disaster Streamlining and Costs Reduction Act of 1997 105-s-1007 Disaster loans
105-s-1007,Disaster relief Disaster Streamlining and Costs Reduction Act of 1997 105-s-1007 Disaster relief
105-s-1007,Disasters Disaster Streamlining and Costs Reduction Act of 1997 105-s-1007 Disasters
105-s-1007,Economics and Public Finance Disaster Streamlining and Costs Reduction Act of 1997 105-s-1007 Economics and Public Finance
105-s-1007,Electric utilities Disaster Streamlining and Costs Reduction Act of 1997 105-s-1007 Electric utilities
105-s-1007,Emergency housing Disaster Streamlining and Costs Reduction Act of 1997 105-s-1007 Emergency housing
105-s-1007,Energy Disaster Streamlining and Costs Reduction Act of 1997 105-s-1007 Energy
105-s-1007,Finance and Financial Sector Disaster Streamlining and Costs Reduction Act of 1997 105-s-1007 Finance and Financial Sector
105-s-1007,Flood control Disaster Streamlining and Costs Reduction Act of 1997 105-s-1007 Flood control
105-s-1007,Flood insurance Disaster Streamlining and Costs Reduction Act of 1997 105-s-1007 Flood insurance

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