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

19 rows where bill_id = "106-hr-5646"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
106-hr-5646,Case mix (Medical care) Nursing Facility Staffing Improvement Act of 2000 106-hr-5646 Case mix (Medical care)
106-hr-5646,Electronic government information Nursing Facility Staffing Improvement Act of 2000 106-hr-5646 Electronic government information
106-hr-5646,Fines (Penalties) Nursing Facility Staffing Improvement Act of 2000 106-hr-5646 Fines (Penalties)
106-hr-5646,Government Operations and Politics Nursing Facility Staffing Improvement Act of 2000 106-hr-5646 Government Operations and Politics
106-hr-5646,Government paperwork Nursing Facility Staffing Improvement Act of 2000 106-hr-5646 Government paperwork
106-hr-5646,Government publicity Nursing Facility Staffing Improvement Act of 2000 106-hr-5646 Government publicity
106-hr-5646,Internet Nursing Facility Staffing Improvement Act of 2000 106-hr-5646 Internet
106-hr-5646,Labor and Employment Nursing Facility Staffing Improvement Act of 2000 106-hr-5646 Labor and Employment
106-hr-5646,Law Nursing Facility Staffing Improvement Act of 2000 106-hr-5646 Law
106-hr-5646,Medicaid Nursing Facility Staffing Improvement Act of 2000 106-hr-5646 Medicaid
106-hr-5646,Medicare Nursing Facility Staffing Improvement Act of 2000 106-hr-5646 Medicare
106-hr-5646,Nurse practitioners Nursing Facility Staffing Improvement Act of 2000 106-hr-5646 Nurse practitioners
106-hr-5646,Nurses Nursing Facility Staffing Improvement Act of 2000 106-hr-5646 Nurses
106-hr-5646,Nursing homes Nursing Facility Staffing Improvement Act of 2000 106-hr-5646 Nursing homes
106-hr-5646,Paramedical personnel Nursing Facility Staffing Improvement Act of 2000 106-hr-5646 Paramedical personnel
106-hr-5646,Quality of care Nursing Facility Staffing Improvement Act of 2000 106-hr-5646 Quality of care
106-hr-5646,Science, Technology, Communications Nursing Facility Staffing Improvement Act of 2000 106-hr-5646 Science, Technology, Communications
106-hr-5646,Social Welfare Nursing Facility Staffing Improvement Act of 2000 106-hr-5646 Social Welfare
106-hr-5646,Surveys Nursing Facility Staffing Improvement Act of 2000 106-hr-5646 Surveys

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