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

5 rows where bill_id = "95-hconres-421"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
95-hconres-421,Athletes Concurrent resolution commending the members of Billard Barbelis softball team of Reading, Pa., for their contribution to amateur sports in winning the 1977 U.S. Amateur Softball Association Championships. 95-hconres-421 Athletes
95-hconres-421,Awards, medals, prizes Concurrent resolution commending the members of Billard Barbelis softball team of Reading, Pa., for their contribution to amateur sports in winning the 1977 U.S. Amateur Softball Association Championships. 95-hconres-421 Awards, medals, prizes
95-hconres-421,Congress Concurrent resolution commending the members of Billard Barbelis softball team of Reading, Pa., for their contribution to amateur sports in winning the 1977 U.S. Amateur Softball Association Championships. 95-hconres-421 Congress
95-hconres-421,Congressional tributes Concurrent resolution commending the members of Billard Barbelis softball team of Reading, Pa., for their contribution to amateur sports in winning the 1977 U.S. Amateur Softball Association Championships. 95-hconres-421 Congressional tributes
95-hconres-421,Pennsylvania Concurrent resolution commending the members of Billard Barbelis softball team of Reading, Pa., for their contribution to amateur sports in winning the 1977 U.S. Amateur Softball Association Championships. 95-hconres-421 Pennsylvania

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