NIO: Senior Officials' Transparency Data

CREATE TABLE nio_senior_officials_business_expenses_and_hospitality_c4c96f47 (
  "senior_official_s_name" VARCHAR,
  "start_date_of_expense" TIMESTAMP,
  "end_date_of_expense" TIMESTAMP,
  "purpose_of_expense" VARCHAR,
  "destination" VARCHAR,
  "mode_s_of_transport" VARCHAR,
  "class_of_transport" VARCHAR,
  "sub_total_of_all_transport_used" VARCHAR,
  "sub_total_costs_of_all_accomodation_and_meals" VARCHAR,
  "sub_total_cost_of_all_other_expenses_including_hospita_da45d94f" VARCHAR,
  "total_cost_of_expenses_claimed" DOUBLE
);

CREATE TABLE nio_senior_officials_business_expenses_and_the_permane_d89cd204 (
  "senior_officials_name" VARCHAR,
  "start_date_of_trip" TIMESTAMP,
  "duration_of_visit_days" BIGINT,
  "destination" VARCHAR,
  "purpose_of_trip" VARCHAR,
  "mode_of_transport" VARCHAR,
  "class_of_travel" VARCHAR,
  "accommodation_meals" VARCHAR,
  "other_including_hospitality_given" VARCHAR,
  "total_cost_including_all_visas_accommodation_travel_meals_etc" DOUBLE,
  "total_cost_of_use_of_official_secure_car" VARCHAR
);

CREATE TABLE nio_senior_officials_meeting_july_to_september_2023 (
  "senior_official_name" VARCHAR,
  "date" VARCHAR,
  "person_or_organisation_that_offered_hospitality" VARCHAR,
  "type_of_hospitality_received" VARCHAR,
  "accompanied_by_spouse_family_member_or_friend" VARCHAR
);

CREATE TABLE nio_s_senior_officials_hospitality_january_to_march_2024 (
  "senior_official_s_name" VARCHAR,
  "date" VARCHAR,
  "individual_or_organisation_that_provided_hospitality" VARCHAR,
  "type_of_hospitality_received" VARCHAR,
  "accompanied_by_guest" VARCHAR
);

CREATE TABLE nio_s_senior_officials_hospitality_july_to_september_2023 (
  "senior_official_name" VARCHAR,
  "date" VARCHAR,
  "person_or_organisation_that_offered_hospitality" VARCHAR,
  "type_of_hospitality_received" VARCHAR,
  "accompanied_by_spouse_family_member_or_friend" VARCHAR
);

CREATE TABLE nio_s_senior_officials_hospitality_october_december_2023 (
  "senior_official_name" VARCHAR,
  "date" VARCHAR,
  "person_or_organisation_that_offered_hospitality" VARCHAR,
  "type_of_hospitality_received" VARCHAR,
  "accompanied_by_spouse_family_member_or_friend" VARCHAR
);

CREATE TABLE nio_s_senior_officials_meetings_january_to_march_2024 (
  "senior_official_s_name" VARCHAR,
  "date" VARCHAR,
  "name_of_individual_or_organisation" VARCHAR,
  "purpose_of_meeting" VARCHAR
);

CREATE TABLE nio_s_senior_officials_meetings_october_december_2023 (
  "name_permanent_secretary_only" VARCHAR,
  "date" TIMESTAMP,
  "person_or_organisation_that_meeting_was_with" VARCHAR,
  "purpose_of_meeting" VARCHAR
);

CREATE TABLE nio_s_senior_officials_travel_expenses_january_to_march_2024 (
  "senior_official_s_name" VARCHAR,
  "start_date_of_expense" VARCHAR,
  "end_date_of_expense" VARCHAR,
  "purpose_of_expense" VARCHAR,
  "destination" VARCHAR,
  "mode_s_of_transport" VARCHAR,
  "class_of_transport" VARCHAR,
  "sub_total_of_all_transport_used" VARCHAR,
  "sub_total_costs_of_all_accomodation_and_meals" VARCHAR,
  "sub_total_cost_of_all_other_expenses_including_hospita_da45d94f" VARCHAR,
  "total_cost_of_expenses_claimed" VARCHAR
);

CREATE TABLE nio_s_senior_officials_travel_expenses_october_december_2023 (
  "senior_official_s_name" VARCHAR,
  "start_date_of_trip" VARCHAR,
  "duration_of_visit_days" BIGINT,
  "destination" VARCHAR,
  "purpose_of_trip" VARCHAR,
  "mode_of_transport" VARCHAR,
  "class_of_travel" VARCHAR,
  "accommodation_meals" VARCHAR,
  "other_including_hospitality_given" VARCHAR,
  "total_cost_including_all_visas_accommodation_travel_meals_etc" DOUBLE,
  "total_cost_of_use_of_official_secure_car" VARCHAR
);

CREATE TABLE nio_s_senior_officials_travel_july_to_september_2023 (
  "senior_official_name" VARCHAR,
  "date" VARCHAR,
  "person_or_organisation_that_offered_hospitality" VARCHAR,
  "type_of_hospitality_received" VARCHAR,
  "accompanied_by_spouse_family_member_or_friend" VARCHAR
);