About this Dataset

CDC STATE System E-Cigarette Legislation - Licensure

1995-2024. Centers for Disease Control and Prevention (CDC). State Tobacco Activities Tracking and Evaluation (STATE) System. E-Cigarette Legislation—Licensure. 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 information related to requirements, restrictions and penalties associated with holding a retail license to sell e-cigarettes over-the-counter and through vending machines.
Organization: U.S. Department of Health & Human Services
Last updated: 2020-11-10T16:17:11.447783
Tags: e-cigarette, legislation, licensure, osh, policy, state-system

Tables

Table 1

@usgov.hhs_gov_cdc_state_system_e_cigarette_legislation_licensure.table_1

952.78 kB
123,888 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
);