Asia And Pacific Regional Economic Outlook (APDREO)

CREATE TABLE codes_cl_apdreo_country (
  "code" VARCHAR,
  "description" VARCHAR
);

CREATE TABLE codes_cl_freq (
  "code" VARCHAR,
  "description" VARCHAR
);

CREATE TABLE indicators (
  "indicator" VARCHAR,
  "series_name" VARCHAR,
  "unit" VARCHAR,
  "transformation" VARCHAR,
  "http_www_w3_org_2001_xmlschema_instance_type" VARCHAR,
  "key_indicator" VARCHAR,
  "topic" VARCHAR,
  "soc_concepts" VARCHAR,
  "statistical_measures" VARCHAR,
  "na_sto" VARCHAR,
  "prices" VARCHAR,
  "gfs_sto" VARCHAR,
  "sector" VARCHAR,
  "int_acc_item" VARCHAR,
  "index_type" VARCHAR
);

CREATE TABLE observations (
  "country" VARCHAR,
  "indicator" VARCHAR,
  "frequency" VARCHAR,
  "time_period" BIGINT,
  "value" DOUBLE
);