home / openregs

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 = "107-hr-3406"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
107-hr-3406,Accounting Electric Supply and Transmission Act 107-hr-3406 Accounting
107-hr-3406,Administrative procedure Electric Supply and Transmission Act 107-hr-3406 Administrative procedure
107-hr-3406,Administrative remedies Electric Supply and Transmission Act 107-hr-3406 Administrative remedies
107-hr-3406,Affiliated corporations Electric Supply and Transmission Act 107-hr-3406 Affiliated corporations
107-hr-3406,Alternative energy sources Electric Supply and Transmission Act 107-hr-3406 Alternative energy sources
107-hr-3406,Antitrust law Electric Supply and Transmission Act 107-hr-3406 Antitrust law
107-hr-3406,Biomass energy Electric Supply and Transmission Act 107-hr-3406 Biomass energy
107-hr-3406,Building construction Electric Supply and Transmission Act 107-hr-3406 Building construction
107-hr-3406,Business income tax Electric Supply and Transmission Act 107-hr-3406 Business income tax
107-hr-3406,Business records Electric Supply and Transmission Act 107-hr-3406 Business records
107-hr-3406,Canada Electric Supply and Transmission Act 107-hr-3406 Canada
107-hr-3406,Capital investments Electric Supply and Transmission Act 107-hr-3406 Capital investments
107-hr-3406,Civil Rights and Liberties, Minority Issues Electric Supply and Transmission Act 107-hr-3406 Civil Rights and Liberties, Minority Issues
107-hr-3406,Civil actions and liability Electric Supply and Transmission Act 107-hr-3406 Civil actions and liability
107-hr-3406,Commerce Electric Supply and Transmission Act 107-hr-3406 Commerce
107-hr-3406,Commercial arbitration Electric Supply and Transmission Act 107-hr-3406 Commercial arbitration
107-hr-3406,Competition Electric Supply and Transmission Act 107-hr-3406 Competition
107-hr-3406,Confidential communications Electric Supply and Transmission Act 107-hr-3406 Confidential communications
107-hr-3406,Congress Electric Supply and Transmission Act 107-hr-3406 Congress

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);
Powered by Datasette · Queries took 1.309ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API · Privacy