Air Emissions Accounts

CREATE TABLE observations (
  "dataflow" VARCHAR,
  "freq" VARCHAR,
  "ref_area" VARCHAR,
  "demand_prod" VARCHAR,
  "accounting_entry" VARCHAR,
  "counterpart_area" VARCHAR,
  "interactors" VARCHAR,
  "bridge_items" VARCHAR,
  "airpol" VARCHAR,
  "sto" VARCHAR,
  "unit_measure" VARCHAR,
  "product" VARCHAR,
  "sector" VARCHAR,
  "time_period" BIGINT,
  "obs_value" DOUBLE,
  "conf_status" VARCHAR,
  "obs_status_1" VARCHAR,
  "obs_status_2" VARCHAR,
  "obs_status_3" VARCHAR,
  "obs_status_4" VARCHAR,
  "comment_dset" VARCHAR,
  "comment_obs" VARCHAR,
  "comment_ts" VARCHAR,
  "unit_mult" BIGINT,
  "embargo_time" VARCHAR,
  "decimals" VARCHAR,
  "title" VARCHAR,
  "title_compl" VARCHAR,
  "last_update" VARCHAR,
  "compiling_org" VARCHAR,
  "pre_break_value" VARCHAR,
  "diss_org" VARCHAR
);