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 = "100-sres-486"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
100-sres-486,Astronauts A resolution to congratulate the crew of the space shuttle Discovery on the successful completion of its mission. 100-sres-486 Astronauts
100-sres-486,Commemorations A resolution to congratulate the crew of the space shuttle Discovery on the successful completion of its mission. 100-sres-486 Commemorations
100-sres-486,Congressional tributes A resolution to congratulate the crew of the space shuttle Discovery on the successful completion of its mission. 100-sres-486 Congressional tributes
100-sres-486,Federal employees A resolution to congratulate the crew of the space shuttle Discovery on the successful completion of its mission. 100-sres-486 Federal employees
100-sres-486,Government contractors A resolution to congratulate the crew of the space shuttle Discovery on the successful completion of its mission. 100-sres-486 Government contractors
100-sres-486,Space programs A resolution to congratulate the crew of the space shuttle Discovery on the successful completion of its mission. 100-sres-486 Space programs
100-sres-486,Space shuttles A resolution to congratulate the crew of the space shuttle Discovery on the successful completion of its mission. 100-sres-486 Space shuttles

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);