Footfall Around Durham University

CREATE TABLE busiest_day_for_all_venues_combined (
  "timestamp" VARCHAR,
  "new_visitors" DOUBLE,
  "return_visitors" DOUBLE
);

CREATE TABLE busiest_day_for_library (
  "timestamp" VARCHAR,
  "new_visitors" DOUBLE,
  "return_visitors" DOUBLE
);

CREATE TABLE busiest_day_for_palatine_building (
  "timestamp" VARCHAR,
  "new_visitors" DOUBLE,
  "return_visitors" DOUBLE
);

CREATE TABLE busiest_hour_for_chemistry_building (
  "timestamp" VARCHAR,
  "new_visitors" DOUBLE,
  "return_visitors" DOUBLE
);

CREATE TABLE busiest_hour_for_palace_green (
  "timestamp" VARCHAR,
  "new_visitors" DOUBLE,
  "return_visitors" DOUBLE
);

CREATE TABLE busiest_hour_for_palatine_building (
  "timestamp" VARCHAR,
  "new_visitors" DOUBLE,
  "return_visitors" DOUBLE
);

CREATE TABLE busiest_hours_for_all_venues_combined (
  "timestamp" VARCHAR,
  "new_visitors" DOUBLE,
  "return_visitors" DOUBLE
);

CREATE TABLE cross_shopping_for_all_venues_combined (
  "from_venue" VARCHAR,
  "to_venue" VARCHAR,
  "total_cross_visits" VARCHAR,
  "n_0_days" VARCHAR,
  "n_1_day" VARCHAR,
  "n_2_days" DOUBLE,
  "n_3_days" DOUBLE,
  "n_4_days" DOUBLE,
  "n_5_days" DOUBLE,
  "n_6_days" DOUBLE,
  "n_7_days" DOUBLE,
  "n_8_14_days" DOUBLE,
  "n_15_30_days" DOUBLE,
  "n_31_60_days" DOUBLE
);

CREATE TABLE dwell_information_for_chemistry_building (
  "timestamp" VARCHAR,
  "visitor_type" VARCHAR,
  "visits" BIGINT,
  "n__of_visits" DOUBLE,
  "visitors" BIGINT,
  "n__of_visitors" DOUBLE,
  "avg_duration" VARCHAR,
  "visits_visitors" DOUBLE
);

CREATE TABLE dwell_information_for_library (
  "timestamp" VARCHAR,
  "visitor_type" VARCHAR,
  "visits" BIGINT,
  "n__of_visits" DOUBLE,
  "visitors" BIGINT,
  "n__of_visitors" DOUBLE,
  "avg_duration" VARCHAR,
  "visits_visitors" DOUBLE
);

CREATE TABLE dwell_information_for_palace_green (
  "timestamp" VARCHAR,
  "visitor_type" VARCHAR,
  "visits" BIGINT,
  "n__of_visits" DOUBLE,
  "visitors" BIGINT,
  "n__of_visitors" DOUBLE,
  "avg_duration" VARCHAR,
  "visits_visitors" DOUBLE
);

CREATE TABLE dwell_information_for_palatine_building (
  "timestamp" VARCHAR,
  "visitor_type" VARCHAR,
  "visits" BIGINT,
  "n__of_visits" DOUBLE,
  "visitors" BIGINT,
  "n__of_visitors" DOUBLE,
  "avg_duration" VARCHAR,
  "visits_visitors" DOUBLE
);

CREATE TABLE passerby_for_all_venues_combined (
  "timestamp" VARCHAR,
  "passerby_type" VARCHAR,
  "passbys" BIGINT,
  "n__of_passbys" DOUBLE,
  "passersby" BIGINT,
  "n__of_passersby" DOUBLE,
  "avg_duration" VARCHAR,
  "passbys_passersby" DOUBLE
);

CREATE TABLE passers_by_for_libray (
  "timestamp" VARCHAR,
  "passerby_type" VARCHAR,
  "passbys" BIGINT,
  "n__of_passbys" DOUBLE,
  "passersby" BIGINT,
  "n__of_passersby" DOUBLE,
  "avg_duration" VARCHAR,
  "passbys_passersby" DOUBLE
);

CREATE TABLE passers_by_for_palace_green (
  "timestamp" VARCHAR,
  "passerby_type" VARCHAR,
  "passbys" BIGINT,
  "n__of_passbys" DOUBLE,
  "passersby" BIGINT,
  "n__of_passersby" DOUBLE,
  "avg_duration" VARCHAR,
  "passbys_passersby" DOUBLE
);

CREATE TABLE passers_by_for_palatine_building (
  "timestamp" VARCHAR,
  "passerby_type" VARCHAR,
  "passbys" BIGINT,
  "n__of_passbys" DOUBLE,
  "passersby" BIGINT,
  "n__of_passersby" DOUBLE,
  "avg_duration" VARCHAR,
  "passbys_passersby" DOUBLE
);

CREATE TABLE windowconversion_for_all_venues_combined (
  "timestamp" VARCHAR,
  "visitor_type" VARCHAR,
  "visitors" BIGINT,
  "n__of_visitors" DOUBLE,
  "window_conversion" DOUBLE
);

CREATE TABLE window_conversion_for_chemistry_building (
  "timestamp" VARCHAR,
  "visitor_type" VARCHAR,
  "visitors" BIGINT,
  "n__of_visitors" DOUBLE,
  "window_conversion" DOUBLE
);

CREATE TABLE window_conversion_for_library (
  "timestamp" VARCHAR,
  "visitor_type" VARCHAR,
  "visitors" BIGINT,
  "n__of_visitors" DOUBLE,
  "window_conversion" DOUBLE
);

CREATE TABLE window_conversion_for_palace_green (
  "timestamp" VARCHAR,
  "visitor_type" VARCHAR,
  "visitors" BIGINT,
  "n__of_visitors" DOUBLE,
  "window_conversion" DOUBLE
);

CREATE TABLE window_conversion_for_palatine_building (
  "timestamp" VARCHAR,
  "visitor_type" VARCHAR,
  "visitors" BIGINT,
  "n__of_visitors" DOUBLE,
  "window_conversion" DOUBLE
);