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 = "104-s-2000"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
104-s-2000,Administrative procedure White House Accountability Act 104-s-2000 Administrative procedure
104-s-2000,Administrative remedies White House Accountability Act 104-s-2000 Administrative remedies
104-s-2000,Age and employment White House Accountability Act 104-s-2000 Age and employment
104-s-2000,Age discrimination White House Accountability Act 104-s-2000 Age discrimination
104-s-2000,Age discrimination in employment White House Accountability Act 104-s-2000 Age discrimination in employment
104-s-2000,Architecture and the disabled White House Accountability Act 104-s-2000 Architecture and the disabled
104-s-2000,Armed Forces and National Security White House Accountability Act 104-s-2000 Armed Forces and National Security
104-s-2000,Civil Rights and Liberties, Minority Issues White House Accountability Act 104-s-2000 Civil Rights and Liberties, Minority Issues
104-s-2000,Civil rights enforcement White House Accountability Act 104-s-2000 Civil rights enforcement
104-s-2000,Confidential communications White House Accountability Act 104-s-2000 Confidential communications
104-s-2000,Congress White House Accountability Act 104-s-2000 Congress
104-s-2000,Congressional employees White House Accountability Act 104-s-2000 Congressional employees
104-s-2000,Counseling White House Accountability Act 104-s-2000 Counseling
104-s-2000,Damages White House Accountability Act 104-s-2000 Damages
104-s-2000,Department of Labor White House Accountability Act 104-s-2000 Department of Labor
104-s-2000,Disabled White House Accountability Act 104-s-2000 Disabled
104-s-2000,Disciplining of employees White House Accountability Act 104-s-2000 Disciplining of employees
104-s-2000,Discrimination against the disabled White House Accountability Act 104-s-2000 Discrimination against the disabled
104-s-2000,Discrimination in employment White House Accountability Act 104-s-2000 Discrimination in employment

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 2.99ms · Data license: Public Domain (U.S. Government data) · Data source: Federal Register API & Regulations.gov API