CDC STATE System E-Cigarette Legislation - Smokefree Campus by US Government | Healthcare

About this Dataset

CDC STATE System E-Cigarette Legislation - Smokefree Campus

1995-2024. Centers for Disease Control and Prevention (CDC). State Tobacco Activities Tracking and Evaluation (STATE) System. E-Cigarette Legislation—Smokefree Campus. The STATE System houses current and historical state-level legislative data on tobacco use prevention and control policies. Data are reported on a quarterly basis. Data include state smokefree indoor air laws for smokefree campuses in private and public colleges and schools (K-12).
Organization: U.S. Department of Health & Human Services
Last updated: 2020-11-10T16:17:12.241096
Tags: e-cigarette, legislation, osh, policy, smokefree-campus, state-system

Tables

Table 1

@usgov.hhs_gov_cdc_state_system_e_cigarette_legislation_smoke_92ab5cb7.table_1

2.16 MB
299396 rows
23 columns


CREATE TABLE table_1 (
  "year" BIGINT,
  "quarter" BIGINT,
  "locationabbr" VARCHAR,
  "locationdesc" VARCHAR,
  "topicdesc" VARCHAR,
  "measuredesc" VARCHAR,
  "datasource" VARCHAR,
  "provisiongroupdesc" VARCHAR,
  "provisiondesc" VARCHAR,
  "provisionvalue" VARCHAR,
  "citation" VARCHAR,
  "provisionaltvalue" BIGINT,
  "datatype" VARCHAR,
  "comments" VARCHAR,
  "enacted_date" TIMESTAMP,
  "effective_date" TIMESTAMP,
  "geolocation" VARCHAR,
  "displayorder" BIGINT,
  "topictypeid" VARCHAR,
  "topicid" VARCHAR,
  "measureid" VARCHAR,
  "provisiongroupid" VARCHAR,
  "provisionid" BIGINT
);