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

7 rows where bill_id = "97-s-2863"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
97-s-2863,Courts and Civil Procedure A bill to amend title 28 to provide protection to all jurors in Federal cases to clarify the compensation of attorneys for jurors in protecting their employment rights, and authorizing the service of jury summonses by ordinary mail. 97-s-2863 Courts and Civil Procedure
97-s-2863,Federal employees A bill to amend title 28 to provide protection to all jurors in Federal cases to clarify the compensation of attorneys for jurors in protecting their employment rights, and authorizing the service of jury summonses by ordinary mail. 97-s-2863 Federal employees
97-s-2863,Juries A bill to amend title 28 to provide protection to all jurors in Federal cases to clarify the compensation of attorneys for jurors in protecting their employment rights, and authorizing the service of jury summonses by ordinary mail. 97-s-2863 Juries
97-s-2863,Labor and Employment A bill to amend title 28 to provide protection to all jurors in Federal cases to clarify the compensation of attorneys for jurors in protecting their employment rights, and authorizing the service of jury summonses by ordinary mail. 97-s-2863 Labor and Employment
97-s-2863,Lawyers and legal services A bill to amend title 28 to provide protection to all jurors in Federal cases to clarify the compensation of attorneys for jurors in protecting their employment rights, and authorizing the service of jury summonses by ordinary mail. 97-s-2863 Lawyers and legal services
97-s-2863,Legal fees A bill to amend title 28 to provide protection to all jurors in Federal cases to clarify the compensation of attorneys for jurors in protecting their employment rights, and authorizing the service of jury summonses by ordinary mail. 97-s-2863 Legal fees
97-s-2863,Workers' compensation A bill to amend title 28 to provide protection to all jurors in Federal cases to clarify the compensation of attorneys for jurors in protecting their employment rights, and authorizing the service of jury summonses by ordinary mail. 97-s-2863 Workers' compensation

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