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

3 rows where bill_id = "98-s-2804"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
98-s-2804,Claims A bill to reimburse the City of Frederick, Maryland, for money paid by the citizens of such city to save and hold harmless valuable military and hospital supplies owned by the United States Government. 98-s-2804 Claims
98-s-2804,Government liability A bill to reimburse the City of Frederick, Maryland, for money paid by the citizens of such city to save and hold harmless valuable military and hospital supplies owned by the United States Government. 98-s-2804 Government liability
98-s-2804,Maryland A bill to reimburse the City of Frederick, Maryland, for money paid by the citizens of such city to save and hold harmless valuable military and hospital supplies owned by the United States Government. 98-s-2804 Maryland

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