Annual Media Evaluation

CREATE TABLE annual_media_evaluation (
  "date" TIMESTAMP,
  "articletype_commentopinion" BIGINT,
  "articletype_feature" BIGINT,
  "articletype_interview" BIGINT,
  "articletype_letter" BIGINT,
  "articletype_newsitem" BIGINT,
  "userfeedback_stronglyunfavourable" BIGINT,
  "userfeedback_slightlyunfavourable" BIGINT,
  "userfeedback_neutral" BIGINT,
  "userfeedback_slightlyfavourable" BIGINT,
  "userfeedback_stronglyfavourable" BIGINT,
  "fsamention_yes" BIGINT,
  "fsamention_no" BIGINT,
  "campaign_foodsafetyweek" BIGINT,
  "campaign_foodsecurity_foodsustainability" BIGINT,
  "campaign_fhrs" BIGINT,
  "campaign_campylobactersurvey" BIGINT,
  "campaign_ourfoodculture" BIGINT,
  "campaign_allergyawarenesscampaign" BIGINT,
  "campaign_rareburgers" BIGINT,
  "campaign_fhrs_ni" BIGINT,
  "campaign_freezerfoodfairy" BIGINT,
  "campaign_acrylamide" BIGINT,
  "mediatype_consumer" BIGINT,
  "mediatype_nationalprint" BIGINT,
  "mediatype_regionalprint" BIGINT,
  "mediatype_trade" BIGINT,
  "mediatype_nationalonline" BIGINT,
  "mediatype_nationalbroadcast" BIGINT,
  "mediatype_regionalonline" BIGINT,
  "mediatype_regionalbroadcast" BIGINT,
  "regions_england" BIGINT,
  "regions_scotland" BIGINT,
  "regions_wales" BIGINT,
  "regions_northernireland" BIGINT,
  "regions_national" BIGINT,
  "regions_international" BIGINT,
  "coveragesource_proactive" BIGINT,
  "coveragesource_reactive" BIGINT,
  "reach_percentallukadults" BIGINT
);