NIO: Special Advisers’ Gifts, Hospitality And Meetings

CREATE TABLE nio_special_advisers_gifts_hospitality_and_meetings_ap_7a16abce (
  "special_adviser" VARCHAR,
  "date" VARCHAR,
  "gift" VARCHAR,
  "given_or_received" VARCHAR,
  "who_gift_was_given_to_or_received_from" VARCHAR,
  "value" VARCHAR,
  "outcome_received_gifts_only" VARCHAR
);

CREATE TABLE nio_special_advisers_gifts_hospitality_and_meetings_ap_a42caad7 (
  "special_adviser" VARCHAR,
  "date" VARCHAR,
  "name_of_senior_media_figure" VARCHAR,
  "purpose_of_meeting" VARCHAR
);

CREATE TABLE nio_s_special_adviser_gifts_july_to_september_2023 (
  "special_adviser" VARCHAR,
  "date" VARCHAR,
  "name_of_organisation_or_individual" VARCHAR,
  "purpose_of_meeting" VARCHAR
);

CREATE TABLE nio_s_special_adviser_hospitality_july_to_september_2023 (
  "special_adviser" VARCHAR,
  "date" VARCHAR,
  "name_of_organisation_or_individual" VARCHAR,
  "purpose_of_meeting" VARCHAR
);

CREATE TABLE nio_s_special_advisers_gifts_january_to_march_2024 (
  "special_adviser" VARCHAR,
  "date" VARCHAR,
  "gift" VARCHAR,
  "who_gift_was_received_from" VARCHAR,
  "value" VARCHAR,
  "outcome" VARCHAR
);

CREATE TABLE nio_s_special_advisers_gifts_october_december_2023 (
  "special_adviser" VARCHAR,
  "date" VARCHAR,
  "gift" VARCHAR,
  "given_or_received" VARCHAR,
  "who_gift_was_given_to_or_received_from" VARCHAR,
  "value" VARCHAR,
  "outcome_received_gifts_only" VARCHAR
);

CREATE TABLE nio_s_special_advisers_gifts_oct_to_dec_2021 (
  "special_adviser" VARCHAR,
  "date" VARCHAR,
  "gift" VARCHAR,
  "given_or_received" VARCHAR,
  "who_gift_was_given_to_or_received_from" VARCHAR,
  "value" VARCHAR,
  "outcome_received_gifts_only" VARCHAR
);

CREATE TABLE nio_s_special_advisers_hospitality_january_to_march_2024 (
  "special_adviser" VARCHAR,
  "date" TIMESTAMP,
  "individual_or_organisation_that_offered_hospitality" VARCHAR,
  "type_of_hospitality_received" VARCHAR,
  "accompanied_by_guest" VARCHAR
);

CREATE TABLE nio_s_special_advisers_hospitality_october_december_2023 (
  "special_adviser" VARCHAR,
  "date" TIMESTAMP,
  "person_or_organisation_that_offered_hospitality" VARCHAR,
  "type_of_hospitality_received" VARCHAR,
  "accompanied_by_spouse_family_member_s_or_friend" VARCHAR
);

CREATE TABLE nio_s_special_advisers_hospitality_oct_to_dec_2021 (
  "special_adviser" VARCHAR,
  "date" VARCHAR,
  "person_or_organisation_that_offered_hospitality" VARCHAR,
  "type_of_hospitality_received" VARCHAR,
  "accompanied_by_spouse_family_member_s_or_friend" VARCHAR
);

CREATE TABLE nio_s_special_advisers_meetings_january_to_march_2024 (
  "special_adviser" VARCHAR,
  "date" VARCHAR,
  "name_of_senior_media_figure" VARCHAR,
  "purpose_of_meeting" VARCHAR
);

CREATE TABLE nio_s_special_advisers_meetings_july_to_september_2023 (
  "special_adviser" VARCHAR,
  "date" VARCHAR,
  "name_of_organisation_or_individual" VARCHAR,
  "purpose_of_meeting" VARCHAR
);

CREATE TABLE nio_s_special_advisers_meetings_october_december_2023 (
  "special_adviser" VARCHAR,
  "date" VARCHAR,
  "name_of_organisation_or_individual" VARCHAR,
  "purpose_of_meeting" VARCHAR
);

CREATE TABLE nio_s_special_advisers_meetings_with_senior_media_figu_a4d2889d (
  "special_adviser" VARCHAR,
  "date" VARCHAR,
  "name_of_organisation_or_individual" VARCHAR,
  "purpose_of_meeting" VARCHAR
);