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

20 rows where bill_id = "110-hconres-252"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
110-hconres-252,Congress Expressing the sense of Congress that no Federal or State requirement to increase energy efficient lighting in public buildings should require a hospital, school, day care center, mental health facility, or nursing home to install or utilize such energy efficient lighting if the lighting contains mercury. 110-hconres-252 Congress
110-hconres-252,Day care Expressing the sense of Congress that no Federal or State requirement to increase energy efficient lighting in public buildings should require a hospital, school, day care center, mental health facility, or nursing home to install or utilize such energy efficient lighting if the lighting contains mercury. 110-hconres-252 Day care
110-hconres-252,Education Expressing the sense of Congress that no Federal or State requirement to increase energy efficient lighting in public buildings should require a hospital, school, day care center, mental health facility, or nursing home to install or utilize such energy efficient lighting if the lighting contains mercury. 110-hconres-252 Education
110-hconres-252,Elementary and secondary education Expressing the sense of Congress that no Federal or State requirement to increase energy efficient lighting in public buildings should require a hospital, school, day care center, mental health facility, or nursing home to install or utilize such energy efficient lighting if the lighting contains mercury. 110-hconres-252 Elementary and secondary education
110-hconres-252,Energy Expressing the sense of Congress that no Federal or State requirement to increase energy efficient lighting in public buildings should require a hospital, school, day care center, mental health facility, or nursing home to install or utilize such energy efficient lighting if the lighting contains mercury. 110-hconres-252 Energy
110-hconres-252,Energy conservation Expressing the sense of Congress that no Federal or State requirement to increase energy efficient lighting in public buildings should require a hospital, school, day care center, mental health facility, or nursing home to install or utilize such energy efficient lighting if the lighting contains mercury. 110-hconres-252 Energy conservation
110-hconres-252,Energy efficiency Expressing the sense of Congress that no Federal or State requirement to increase energy efficient lighting in public buildings should require a hospital, school, day care center, mental health facility, or nursing home to install or utilize such energy efficient lighting if the lighting contains mercury. 110-hconres-252 Energy efficiency
110-hconres-252,Families Expressing the sense of Congress that no Federal or State requirement to increase energy efficient lighting in public buildings should require a hospital, school, day care center, mental health facility, or nursing home to install or utilize such energy efficient lighting if the lighting contains mercury. 110-hconres-252 Families
110-hconres-252,Government Operations and Politics Expressing the sense of Congress that no Federal or State requirement to increase energy efficient lighting in public buildings should require a hospital, school, day care center, mental health facility, or nursing home to install or utilize such energy efficient lighting if the lighting contains mercury. 110-hconres-252 Government Operations and Politics
110-hconres-252,Health Expressing the sense of Congress that no Federal or State requirement to increase energy efficient lighting in public buildings should require a hospital, school, day care center, mental health facility, or nursing home to install or utilize such energy efficient lighting if the lighting contains mercury. 110-hconres-252 Health
110-hconres-252,Higher education Expressing the sense of Congress that no Federal or State requirement to increase energy efficient lighting in public buildings should require a hospital, school, day care center, mental health facility, or nursing home to install or utilize such energy efficient lighting if the lighting contains mercury. 110-hconres-252 Higher education
110-hconres-252,Hospitals Expressing the sense of Congress that no Federal or State requirement to increase energy efficient lighting in public buildings should require a hospital, school, day care center, mental health facility, or nursing home to install or utilize such energy efficient lighting if the lighting contains mercury. 110-hconres-252 Hospitals
110-hconres-252,Legislation Expressing the sense of Congress that no Federal or State requirement to increase energy efficient lighting in public buildings should require a hospital, school, day care center, mental health facility, or nursing home to install or utilize such energy efficient lighting if the lighting contains mercury. 110-hconres-252 Legislation
110-hconres-252,Lighting Expressing the sense of Congress that no Federal or State requirement to increase energy efficient lighting in public buildings should require a hospital, school, day care center, mental health facility, or nursing home to install or utilize such energy efficient lighting if the lighting contains mercury. 110-hconres-252 Lighting
110-hconres-252,Mental care facilities Expressing the sense of Congress that no Federal or State requirement to increase energy efficient lighting in public buildings should require a hospital, school, day care center, mental health facility, or nursing home to install or utilize such energy efficient lighting if the lighting contains mercury. 110-hconres-252 Mental care facilities
110-hconres-252,Mercury Expressing the sense of Congress that no Federal or State requirement to increase energy efficient lighting in public buildings should require a hospital, school, day care center, mental health facility, or nursing home to install or utilize such energy efficient lighting if the lighting contains mercury. 110-hconres-252 Mercury
110-hconres-252,Nursing homes Expressing the sense of Congress that no Federal or State requirement to increase energy efficient lighting in public buildings should require a hospital, school, day care center, mental health facility, or nursing home to install or utilize such energy efficient lighting if the lighting contains mercury. 110-hconres-252 Nursing homes
110-hconres-252,School buildings Expressing the sense of Congress that no Federal or State requirement to increase energy efficient lighting in public buildings should require a hospital, school, day care center, mental health facility, or nursing home to install or utilize such energy efficient lighting if the lighting contains mercury. 110-hconres-252 School buildings
110-hconres-252,Social Welfare Expressing the sense of Congress that no Federal or State requirement to increase energy efficient lighting in public buildings should require a hospital, school, day care center, mental health facility, or nursing home to install or utilize such energy efficient lighting if the lighting contains mercury. 110-hconres-252 Social Welfare
110-hconres-252,State laws Expressing the sense of Congress that no Federal or State requirement to increase energy efficient lighting in public buildings should require a hospital, school, day care center, mental health facility, or nursing home to install or utilize such energy efficient lighting if the lighting contains mercury. 110-hconres-252 State laws

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