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

39 rows where bill_id = "108-hr-4941"

✎ View and edit SQL

This data as json, CSV (advanced)

Link bill_id subject
108-hr-4941,Agriculture and Food Childhood Obesity Reduction Act 108-hr-4941 Agriculture and Food
108-hr-4941,Awards, medals, prizes Childhood Obesity Reduction Act 108-hr-4941 Awards, medals, prizes
108-hr-4941,Child health Childhood Obesity Reduction Act 108-hr-4941 Child health
108-hr-4941,Child nutrition Childhood Obesity Reduction Act 108-hr-4941 Child nutrition
108-hr-4941,Commemorations Childhood Obesity Reduction Act 108-hr-4941 Commemorations
108-hr-4941,Communication in medicine Childhood Obesity Reduction Act 108-hr-4941 Communication in medicine
108-hr-4941,Community and school Childhood Obesity Reduction Act 108-hr-4941 Community and school
108-hr-4941,Congress Childhood Obesity Reduction Act 108-hr-4941 Congress
108-hr-4941,Congressional agencies Childhood Obesity Reduction Act 108-hr-4941 Congressional agencies
108-hr-4941,Congressional reorganization Childhood Obesity Reduction Act 108-hr-4941 Congressional reorganization
108-hr-4941,Congressional tributes Childhood Obesity Reduction Act 108-hr-4941 Congressional tributes
108-hr-4941,Department of Health and Human Services Childhood Obesity Reduction Act 108-hr-4941 Department of Health and Human Services
108-hr-4941,Economics and Public Finance Childhood Obesity Reduction Act 108-hr-4941 Economics and Public Finance
108-hr-4941,Education Childhood Obesity Reduction Act 108-hr-4941 Education
108-hr-4941,Electronic government information Childhood Obesity Reduction Act 108-hr-4941 Electronic government information
108-hr-4941,Elementary and secondary education Childhood Obesity Reduction Act 108-hr-4941 Elementary and secondary education
108-hr-4941,Elementary education Childhood Obesity Reduction Act 108-hr-4941 Elementary education
108-hr-4941,Exercise Childhood Obesity Reduction Act 108-hr-4941 Exercise
108-hr-4941,Federal aid to education Childhood Obesity Reduction Act 108-hr-4941 Federal aid to education
108-hr-4941,Foundations Childhood Obesity Reduction Act 108-hr-4941 Foundations
108-hr-4941,Gifts Childhood Obesity Reduction Act 108-hr-4941 Gifts
108-hr-4941,Government Operations and Politics Childhood Obesity Reduction Act 108-hr-4941 Government Operations and Politics
108-hr-4941,Government paperwork Childhood Obesity Reduction Act 108-hr-4941 Government paperwork
108-hr-4941,Government publicity Childhood Obesity Reduction Act 108-hr-4941 Government publicity
108-hr-4941,Health Childhood Obesity Reduction Act 108-hr-4941 Health
108-hr-4941,Health education Childhood Obesity Reduction Act 108-hr-4941 Health education
108-hr-4941,Health planning Childhood Obesity Reduction Act 108-hr-4941 Health planning
108-hr-4941,Internet Childhood Obesity Reduction Act 108-hr-4941 Internet
108-hr-4941,Nonprofit organizations Childhood Obesity Reduction Act 108-hr-4941 Nonprofit organizations
108-hr-4941,Obesity Childhood Obesity Reduction Act 108-hr-4941 Obesity
108-hr-4941,Physical education and training Childhood Obesity Reduction Act 108-hr-4941 Physical education and training
108-hr-4941,Preventive medicine Childhood Obesity Reduction Act 108-hr-4941 Preventive medicine
108-hr-4941,School health programs Childhood Obesity Reduction Act 108-hr-4941 School health programs
108-hr-4941,Science, Technology, Communications Childhood Obesity Reduction Act 108-hr-4941 Science, Technology, Communications
108-hr-4941,Secondary education Childhood Obesity Reduction Act 108-hr-4941 Secondary education
108-hr-4941,Social Welfare Childhood Obesity Reduction Act 108-hr-4941 Social Welfare
108-hr-4941,Sports and Recreation Childhood Obesity Reduction Act 108-hr-4941 Sports and Recreation
108-hr-4941,Volunteer workers Childhood Obesity Reduction Act 108-hr-4941 Volunteer workers
108-hr-4941,Web sites Childhood Obesity Reduction Act 108-hr-4941 Web sites

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