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

16 rows where bill_id = "99-s-1960"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
99-s-1960,Armed Forces and National Security Medical Offer and Recovery Act 99-s-1960 Armed Forces and National Security
99-s-1960,Business and commerce Medical Offer and Recovery Act 99-s-1960 Business and commerce
99-s-1960,Federal employees and officials Medical Offer and Recovery Act 99-s-1960 Federal employees and officials
99-s-1960,Government employees' health insurance Medical Offer and Recovery Act 99-s-1960 Government employees' health insurance
99-s-1960,Insurance Medical Offer and Recovery Act 99-s-1960 Insurance
99-s-1960,Liability (Law) Medical Offer and Recovery Act 99-s-1960 Liability (Law)
99-s-1960,Malpractice Medical Offer and Recovery Act 99-s-1960 Malpractice
99-s-1960,Mediation Medical Offer and Recovery Act 99-s-1960 Mediation
99-s-1960,Medicaid Medical Offer and Recovery Act 99-s-1960 Medicaid
99-s-1960,Medical malpractice insurance Medical Offer and Recovery Act 99-s-1960 Medical malpractice insurance
99-s-1960,Medical personnel Medical Offer and Recovery Act 99-s-1960 Medical personnel
99-s-1960,Medicare Medical Offer and Recovery Act 99-s-1960 Medicare
99-s-1960,Military medicine Medical Offer and Recovery Act 99-s-1960 Military medicine
99-s-1960,Patients' rights Medical Offer and Recovery Act 99-s-1960 Patients' rights
99-s-1960,Social Welfare Medical Offer and Recovery Act 99-s-1960 Social Welfare
99-s-1960,Veterans' medical care Medical Offer and Recovery Act 99-s-1960 Veterans' medical care

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