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

7 rows where bill_id = "95-s-3136"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
95-s-3136,Electric power A bill to amend section 15d of the Tennessee Valley Authority Act of 1933 to provide that expenditures for pollution control facilities will be credited against required power investment return payments and repayments. 95-s-3136 Electric power
95-s-3136,Energy A bill to amend section 15d of the Tennessee Valley Authority Act of 1933 to provide that expenditures for pollution control facilities will be credited against required power investment return payments and repayments. 95-s-3136 Energy
95-s-3136,Pollution control A bill to amend section 15d of the Tennessee Valley Authority Act of 1933 to provide that expenditures for pollution control facilities will be credited against required power investment return payments and repayments. 95-s-3136 Pollution control
95-s-3136,Public utilities A bill to amend section 15d of the Tennessee Valley Authority Act of 1933 to provide that expenditures for pollution control facilities will be credited against required power investment return payments and repayments. 95-s-3136 Public utilities
95-s-3136,Tennessee A bill to amend section 15d of the Tennessee Valley Authority Act of 1933 to provide that expenditures for pollution control facilities will be credited against required power investment return payments and repayments. 95-s-3136 Tennessee
95-s-3136,Tennessee Valley Authority A bill to amend section 15d of the Tennessee Valley Authority Act of 1933 to provide that expenditures for pollution control facilities will be credited against required power investment return payments and repayments. 95-s-3136 Tennessee Valley Authority
95-s-3136,Tennessee Valley development A bill to amend section 15d of the Tennessee Valley Authority Act of 1933 to provide that expenditures for pollution control facilities will be credited against required power investment return payments and repayments. 95-s-3136 Tennessee Valley development

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