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

8 rows where bill_id = "110-s-2140"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
110-s-2140,Congress A bill to award a Congressional Gold Medal to Francis Collins, in recognition of his outstanding contributions and leadership in the fields of medicine and genetics. 110-s-2140 Congress
110-s-2140,Congressional gold medals A bill to award a Congressional Gold Medal to Francis Collins, in recognition of his outstanding contributions and leadership in the fields of medicine and genetics. 110-s-2140 Congressional gold medals
110-s-2140,Genetic research A bill to award a Congressional Gold Medal to Francis Collins, in recognition of his outstanding contributions and leadership in the fields of medicine and genetics. 110-s-2140 Genetic research
110-s-2140,Genetics A bill to award a Congressional Gold Medal to Francis Collins, in recognition of his outstanding contributions and leadership in the fields of medicine and genetics. 110-s-2140 Genetics
110-s-2140,Health A bill to award a Congressional Gold Medal to Francis Collins, in recognition of his outstanding contributions and leadership in the fields of medicine and genetics. 110-s-2140 Health
110-s-2140,Medical research A bill to award a Congressional Gold Medal to Francis Collins, in recognition of his outstanding contributions and leadership in the fields of medicine and genetics. 110-s-2140 Medical research
110-s-2140,Science, Technology, Communications A bill to award a Congressional Gold Medal to Francis Collins, in recognition of his outstanding contributions and leadership in the fields of medicine and genetics. 110-s-2140 Science, Technology, Communications
110-s-2140,Scientists A bill to award a Congressional Gold Medal to Francis Collins, in recognition of his outstanding contributions and leadership in the fields of medicine and genetics. 110-s-2140 Scientists

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