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

12 rows where bill_id = "110-s-2913"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
110-s-2913,Administrative procedure Shawn Bentley Orphan Works Act of 2008 110-s-2913 Administrative procedure
110-s-2913,Alternative dispute resolution Shawn Bentley Orphan Works Act of 2008 110-s-2913 Alternative dispute resolution
110-s-2913,Congress Shawn Bentley Orphan Works Act of 2008 110-s-2913 Congress
110-s-2913,Congressional investigations Shawn Bentley Orphan Works Act of 2008 110-s-2913 Congressional investigations
110-s-2913,Congressional reporting requirements Shawn Bentley Orphan Works Act of 2008 110-s-2913 Congressional reporting requirements
110-s-2913,Copyright Shawn Bentley Orphan Works Act of 2008 110-s-2913 Copyright
110-s-2913,Data banks Shawn Bentley Orphan Works Act of 2008 110-s-2913 Data banks
110-s-2913,Governmental investigations Shawn Bentley Orphan Works Act of 2008 110-s-2913 Governmental investigations
110-s-2913,Intellectual property Shawn Bentley Orphan Works Act of 2008 110-s-2913 Intellectual property
110-s-2913,Law Shawn Bentley Orphan Works Act of 2008 110-s-2913 Law
110-s-2913,Legislation Shawn Bentley Orphan Works Act of 2008 110-s-2913 Legislation
110-s-2913,Science, Technology, Communications Shawn Bentley Orphan Works Act of 2008 110-s-2913 Science, Technology, Communications

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