NI Direct Website Data
OpenDataNI
@ukgov.ni_direct_website_data
OpenDataNI
@ukgov.ni_direct_website_data
CREATE TABLE ni_direct_search_terms_2017_q1_q2 (
"month_of_year" BIGINT,
"search_term" VARCHAR,
"total_unique_searches" BIGINT,
"results_pageviews_search" DOUBLE,
"n__search_exits" VARCHAR,
"n__search_refinements" VARCHAR,
"time_after_search" VARCHAR,
"avg_search_depth" DOUBLE
);
CREATE TABLE ni_direct_search_terms_2017_q3_q4 (
"month_of_year" BIGINT,
"search_term" VARCHAR,
"total_unique_searches" BIGINT,
"results_pageviews_search" DOUBLE,
"n__search_exits" VARCHAR,
"n__search_refinements" VARCHAR,
"time_after_search" VARCHAR,
"avg_search_depth" DOUBLE
);
CREATE TABLE ni_direct_search_terms_2018_q1_q2 (
"month_of_year" BIGINT,
"search_term" VARCHAR,
"total_unique_searches" BIGINT,
"results_pageviews_search" DOUBLE,
"n__search_exits" VARCHAR,
"n__search_refinements" VARCHAR,
"time_after_search" VARCHAR,
"avg_search_depth" DOUBLE
);
CREATE TABLE ni_direct_search_terms_2018_q3_q4 (
"month_of_year" DOUBLE,
"search_term" VARCHAR,
"total_unique_searches" DOUBLE,
"results_pageviews_search" DOUBLE,
"n__search_exits" VARCHAR,
"n__search_refinements" VARCHAR,
"time_after_search" VARCHAR,
"avg_search_depth" DOUBLE
);
CREATE TABLE ni_direct_search_terms_2019_q1_q2 (
"month_of_year" BIGINT,
"search_term" VARCHAR,
"total_unique_searches" BIGINT,
"results_pageviews_search" DOUBLE,
"n__search_exits" VARCHAR,
"n__search_refinements" VARCHAR,
"time_after_search" VARCHAR,
"avg_search_depth" DOUBLE
);
CREATE TABLE ni_direct_search_terms_2019_q3_q4 (
"month_of_year" BIGINT,
"search_term" VARCHAR,
"total_unique_searches" BIGINT,
"results_pageviews_search" DOUBLE,
"n__search_exits" VARCHAR,
"n__search_refinements" VARCHAR,
"time_after_search" VARCHAR,
"avg_search_depth" DOUBLE
);
CREATE TABLE ni_direct_search_terms_2020_q1_q2 (
"month_of_year" BIGINT,
"search_term" VARCHAR,
"total_unique_searches" BIGINT,
"results_pageviews_search" DOUBLE,
"n__search_exits" VARCHAR,
"n__search_refinements" VARCHAR,
"time_after_search" VARCHAR,
"avg_search_depth" DOUBLE
);
CREATE TABLE ni_direct_search_terms_2020_q3_q4 (
"month_of_year" BIGINT,
"search_term" VARCHAR,
"total_unique_searches" BIGINT,
"results_pageviews_search" DOUBLE,
"n__search_exits" VARCHAR,
"n__search_refinements" VARCHAR,
"time_after_search" VARCHAR,
"avg_search_depth" DOUBLE
);
CREATE TABLE ni_direct_search_terms_2021_q1_q2 (
"month_of_year" BIGINT,
"search_term" VARCHAR,
"total_unique_searches" BIGINT,
"results_pageviews_search" DOUBLE,
"n__search_exits" VARCHAR,
"n__search_refinements" VARCHAR,
"time_after_search" VARCHAR,
"avg_search_depth" DOUBLE
);
CREATE TABLE ni_direct_search_terms_2021_q3_q4 (
"month_of_year" BIGINT,
"search_term" VARCHAR,
"total_unique_searches" BIGINT,
"results_pageviews_search" DOUBLE,
"n__search_exits" VARCHAR,
"n__search_refinements" VARCHAR,
"time_after_search" VARCHAR,
"avg_search_depth" DOUBLE
);
CREATE TABLE ni_direct_search_terms_2022_q1_q2 (
"month_of_year" BIGINT,
"search_term" VARCHAR,
"total_unique_searches" BIGINT,
"results_pageviews_search" DOUBLE,
"n__search_exits" VARCHAR,
"n__search_refinements" VARCHAR,
"time_after_search" VARCHAR,
"avg_search_depth" DOUBLE
);
CREATE TABLE ni_direct_sources_2016_q3_q4 (
"date" BIGINT,
"source" VARCHAR,
"sessions" BIGINT,
"avg_session_duration" VARCHAR,
"bounce_rate" VARCHAR,
"users" BIGINT,
"new_users" BIGINT
);
CREATE TABLE ni_direct_sources_2017_q1_q2 (
"date" BIGINT,
"source" VARCHAR,
"sessions" BIGINT,
"avg_session_duration" VARCHAR,
"bounce_rate" VARCHAR,
"users" BIGINT,
"new_users" BIGINT
);
CREATE TABLE ni_direct_sources_2017_q3_q4 (
"date" BIGINT,
"source" VARCHAR,
"sessions" BIGINT,
"avg_session_duration" VARCHAR,
"bounce_rate" VARCHAR,
"users" BIGINT,
"new_users" BIGINT
);
CREATE TABLE ni_direct_sources_2018_q1_q2 (
"date" BIGINT,
"source" VARCHAR,
"sessions" BIGINT,
"avg_session_duration" VARCHAR,
"bounce_rate" VARCHAR,
"users" BIGINT,
"new_users" BIGINT
);
CREATE TABLE ni_direct_sources_2018_q3_q4 (
"date" DOUBLE,
"source" VARCHAR,
"sessions" DOUBLE,
"avg_session_duration" VARCHAR,
"bounce_rate" VARCHAR,
"users" DOUBLE,
"new_users" DOUBLE
);
CREATE TABLE ni_direct_sources_2019_q1_q2 (
"date" BIGINT,
"source" VARCHAR,
"sessions" BIGINT,
"avg_session_duration" VARCHAR,
"bounce_rate" VARCHAR,
"users" BIGINT,
"new_users" BIGINT
);
CREATE TABLE ni_direct_sources_2019_q3_q4 (
"date" BIGINT,
"source" VARCHAR,
"sessions" BIGINT,
"avg_session_duration" VARCHAR,
"bounce_rate" VARCHAR,
"users" BIGINT,
"new_users" BIGINT
);
CREATE TABLE ni_direct_sources_2020_q1_q2 (
"date" BIGINT,
"source" VARCHAR,
"sessions" BIGINT,
"avg_session_duration" VARCHAR,
"bounce_rate" VARCHAR,
"users" BIGINT,
"new_users" BIGINT
);
CREATE TABLE ni_direct_sources_2020_q3_q4 (
"date" BIGINT,
"source" VARCHAR,
"sessions" BIGINT,
"avg_session_duration" VARCHAR,
"bounce_rate" VARCHAR,
"users" BIGINT,
"new_users" BIGINT
);
CREATE TABLE ni_direct_sources_2021_q1_q2 (
"date" BIGINT,
"source" VARCHAR,
"sessions" BIGINT,
"avg_session_duration" VARCHAR,
"bounce_rate" VARCHAR,
"users" BIGINT,
"new_users" BIGINT
);
CREATE TABLE ni_direct_sources_2021_q3_q4 (
"date" BIGINT,
"source" VARCHAR,
"sessions" BIGINT,
"avg_session_duration" VARCHAR,
"bounce_rate" VARCHAR,
"users" BIGINT,
"new_users" BIGINT
);
CREATE TABLE ni_direct_sources_2022_q1_q2 (
"date" BIGINT,
"source" VARCHAR,
"sessions" BIGINT,
"avg_session_duration" VARCHAR,
"bounce_rate" VARCHAR,
"users" BIGINT,
"new_users" BIGINT
);
CREATE TABLE ni_direct_user_device_categories_2016_q3_q4 (
"date" BIGINT,
"device_category" VARCHAR,
"sessions" BIGINT,
"avg_session_duration" VARCHAR,
"bounce_rate" VARCHAR,
"users" BIGINT,
"new_users" BIGINT
);
CREATE TABLE ni_direct_user_device_categories_2017_q1_q2 (
"date" BIGINT,
"device_category" VARCHAR,
"sessions" BIGINT,
"avg_session_duration" VARCHAR,
"bounce_rate" VARCHAR,
"users" BIGINT,
"new_users" BIGINT
);
Anyone who has the link will be able to view this.