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  -- 0 Days,
  "n_1_day" VARCHAR  -- 1 Day,
  "n_2_days" DOUBLE  -- 2 Days,
  "n_3_days" DOUBLE  -- 3 Days,
  "n_4_days" DOUBLE  -- 4 Days,
  "n_5_days" DOUBLE  -- 5 Days,
  "n_6_days" DOUBLE  -- 6 Days,
  "n_7_days" DOUBLE  -- 7 Days,
  "n_8_14_days" DOUBLE  -- 8-14 Days,
  "n_15_30_days" DOUBLE  -- 15-30 Days,
  "n_31_60_days" DOUBLE  -- 31-60 Days
);

CREATE TABLE dwell_information_for_chemistry_building (
  "timestamp" VARCHAR,
  "visitor_type" VARCHAR,
  "visits" BIGINT,
  "n__of_visits" DOUBLE  -- % Of Visits,
  "visitors" BIGINT,
  "n__of_visitors" DOUBLE  -- % Of Visitors,
  "avg_duration" VARCHAR,
  "visits_visitors" DOUBLE  -- Visits / Visitors
);

CREATE TABLE dwell_information_for_library (
  "timestamp" VARCHAR,
  "visitor_type" VARCHAR,
  "visits" BIGINT,
  "n__of_visits" DOUBLE  -- % Of Visits,
  "visitors" BIGINT,
  "n__of_visitors" DOUBLE  -- % Of Visitors,
  "avg_duration" VARCHAR,
  "visits_visitors" DOUBLE  -- Visits / Visitors
);

CREATE TABLE dwell_information_for_palace_green (
  "timestamp" VARCHAR,
  "visitor_type" VARCHAR,
  "visits" BIGINT,
  "n__of_visits" DOUBLE  -- % Of Visits,
  "visitors" BIGINT,
  "n__of_visitors" DOUBLE  -- % Of Visitors,
  "avg_duration" VARCHAR,
  "visits_visitors" DOUBLE  -- Visits / Visitors
);

CREATE TABLE dwell_information_for_palatine_building (
  "timestamp" VARCHAR,
  "visitor_type" VARCHAR,
  "visits" BIGINT,
  "n__of_visits" DOUBLE  -- % Of Visits,
  "visitors" BIGINT,
  "n__of_visitors" DOUBLE  -- % Of Visitors,
  "avg_duration" VARCHAR,
  "visits_visitors" DOUBLE  -- Visits / Visitors
);

CREATE TABLE passerby_for_all_venues_combined (
  "timestamp" VARCHAR,
  "passerby_type" VARCHAR,
  "passbys" BIGINT,
  "n__of_passbys" DOUBLE  -- % Of Passbys,
  "passersby" BIGINT,
  "n__of_passersby" DOUBLE  -- % Of Passersby,
  "avg_duration" VARCHAR,
  "passbys_passersby" DOUBLE  -- Passbys / Passersby
);

CREATE TABLE passers_by_for_libray (
  "timestamp" VARCHAR,
  "passerby_type" VARCHAR,
  "passbys" BIGINT,
  "n__of_passbys" DOUBLE  -- % Of Passbys,
  "passersby" BIGINT,
  "n__of_passersby" DOUBLE  -- % Of Passersby,
  "avg_duration" VARCHAR,
  "passbys_passersby" DOUBLE  -- Passbys / Passersby
);

CREATE TABLE passers_by_for_palace_green (
  "timestamp" VARCHAR,
  "passerby_type" VARCHAR,
  "passbys" BIGINT,
  "n__of_passbys" DOUBLE  -- % Of Passbys,
  "passersby" BIGINT,
  "n__of_passersby" DOUBLE  -- % Of Passersby,
  "avg_duration" VARCHAR,
  "passbys_passersby" DOUBLE  -- Passbys / Passersby
);

CREATE TABLE passers_by_for_palatine_building (
  "timestamp" VARCHAR,
  "passerby_type" VARCHAR,
  "passbys" BIGINT,
  "n__of_passbys" DOUBLE  -- % Of Passbys,
  "passersby" BIGINT,
  "n__of_passersby" DOUBLE  -- % Of Passersby,
  "avg_duration" VARCHAR,
  "passbys_passersby" DOUBLE  -- Passbys / Passersby
);

CREATE TABLE windowconversion_for_all_venues_combined (
  "timestamp" VARCHAR,
  "visitor_type" VARCHAR,
  "visitors" BIGINT,
  "n__of_visitors" DOUBLE  -- % Of Visitors,
  "window_conversion" DOUBLE  -- Window Conversion %
);

CREATE TABLE window_conversion_for_chemistry_building (
  "timestamp" VARCHAR,
  "visitor_type" VARCHAR,
  "visitors" BIGINT,
  "n__of_visitors" DOUBLE  -- % Of Visitors,
  "window_conversion" DOUBLE  -- Window Conversion %
);

CREATE TABLE window_conversion_for_library (
  "timestamp" VARCHAR,
  "visitor_type" VARCHAR,
  "visitors" BIGINT,
  "n__of_visitors" DOUBLE  -- % Of Visitors,
  "window_conversion" DOUBLE  -- Window Conversion %
);

CREATE TABLE window_conversion_for_palace_green (
  "timestamp" VARCHAR,
  "visitor_type" VARCHAR,
  "visitors" BIGINT,
  "n__of_visitors" DOUBLE  -- % Of Visitors,
  "window_conversion" DOUBLE  -- Window Conversion %
);

CREATE TABLE window_conversion_for_palatine_building (
  "timestamp" VARCHAR,
  "visitor_type" VARCHAR,
  "visitors" BIGINT,
  "n__of_visitors" DOUBLE  -- % Of Visitors,
  "window_conversion" DOUBLE  -- Window Conversion %
);