Patent Data By Sector, KET And SGC

CREATE TABLE patents_by_economic_sector_societal_grand_challenges_a_bfc8f595 (
  "time_period" BIGINT,
  "nuts" VARCHAR,
  "office" VARCHAR,
  "indicator" VARCHAR,
  "indicator_desc" VARCHAR,
  "sector" VARCHAR,
  "field" VARCHAR,
  "inv_app_at" VARCHAR,
  "obs_value" DOUBLE,
  "field_desc" VARCHAR,
  "inv_app_at_desc" VARCHAR,
  "office_desc" VARCHAR,
  "nuts_desc" VARCHAR,
  "nuts_level" BIGINT,
  "sector_desc" VARCHAR
);