NI Direct Website Data
OpenDataNI
@ukgov.ni_direct_website_data
OpenDataNI
@ukgov.ni_direct_website_data
CREATE TABLE ni_direct_browser_information_2016_q3_q4 (
"date" BIGINT,
"browser" VARCHAR,
"browser_version" VARCHAR,
"sessions" BIGINT,
"avg_session_duration" VARCHAR,
"bounce_rate" VARCHAR,
"users" BIGINT,
"new_users" BIGINT
);
CREATE TABLE ni_direct_browser_information_2017_q1_q2 (
"date" BIGINT,
"browser" VARCHAR,
"browser_version" VARCHAR,
"sessions" BIGINT,
"avg_session_duration" VARCHAR,
"bounce_rate" VARCHAR,
"users" BIGINT,
"new_users" BIGINT
);
CREATE TABLE ni_direct_browser_information_2017_q3_q4 (
"date" BIGINT,
"browser" VARCHAR,
"browser_version" VARCHAR,
"sessions" DOUBLE,
"avg_session_duration" VARCHAR,
"bounce_rate" VARCHAR,
"users" DOUBLE,
"new_users" DOUBLE
);
CREATE TABLE ni_direct_browser_information_2018_q1_q2 (
"date" BIGINT,
"browser" VARCHAR,
"browser_version" VARCHAR,
"sessions" BIGINT,
"avg_session_duration" VARCHAR,
"bounce_rate" VARCHAR,
"users" BIGINT,
"new_users" BIGINT
);
CREATE TABLE ni_direct_browser_information_2018_q3_q4 (
"date" BIGINT,
"browser" VARCHAR,
"browser_version" VARCHAR,
"sessions" BIGINT,
"avg_session_duration" VARCHAR,
"bounce_rate" VARCHAR,
"users" BIGINT,
"new_users" BIGINT
);
CREATE TABLE ni_direct_browser_information_2019_q1_q2 (
"date" BIGINT,
"browser" VARCHAR,
"browser_version" VARCHAR,
"sessions" BIGINT,
"avg_session_duration" VARCHAR,
"bounce_rate" VARCHAR,
"users" BIGINT,
"new_users" BIGINT
);
CREATE TABLE ni_direct_browser_information_2019_q3_q4 (
"date" BIGINT,
"browser" VARCHAR,
"browser_version" VARCHAR,
"sessions" BIGINT,
"avg_session_duration" VARCHAR,
"bounce_rate" VARCHAR,
"users" BIGINT,
"new_users" BIGINT
);
CREATE TABLE ni_direct_browser_information_2020_q1_q2 (
"date" BIGINT,
"browser" VARCHAR,
"browser_version" VARCHAR,
"sessions" BIGINT,
"avg_session_duration" VARCHAR,
"bounce_rate" VARCHAR,
"users" BIGINT,
"new_users" BIGINT
);
CREATE TABLE ni_direct_browser_information_2020_q3_q4 (
"date" BIGINT,
"browser" VARCHAR,
"browser_version" VARCHAR,
"sessions" BIGINT,
"avg_session_duration" VARCHAR,
"bounce_rate" VARCHAR,
"users" BIGINT,
"new_users" BIGINT
);
CREATE TABLE ni_direct_browser_information_2021_q1_q2 (
"date" BIGINT,
"browser" VARCHAR,
"browser_version" VARCHAR,
"sessions" BIGINT,
"avg_session_duration" VARCHAR,
"bounce_rate" VARCHAR,
"users" BIGINT,
"new_users" BIGINT
);
CREATE TABLE ni_direct_browser_information_2021_q3_q4 (
"date" DOUBLE,
"browser" VARCHAR,
"browser_version" VARCHAR,
"sessions" VARCHAR,
"avg_session_duration" VARCHAR,
"bounce_rate" VARCHAR,
"users" VARCHAR,
"new_users" VARCHAR
);
CREATE TABLE ni_direct_browser_information_2022_q1_q2 (
"date" BIGINT,
"browser" VARCHAR,
"browser_version" VARCHAR,
"sessions" BIGINT,
"avg_session_duration" VARCHAR,
"bounce_rate" VARCHAR,
"users" BIGINT,
"new_users" BIGINT
);
CREATE TABLE ni_direct_pageviews_2016_q3_q4 (
"date" BIGINT,
"page_title" VARCHAR,
"unique_pageviews" BIGINT,
"pageviews" BIGINT,
"avg_time_on_page" VARCHAR,
"bounces" BIGINT
);
CREATE TABLE ni_direct_pageviews_2017_q1_q2 (
"date" BIGINT,
"page_title" VARCHAR,
"unique_pageviews" BIGINT,
"pageviews" BIGINT,
"avg_time_on_page" VARCHAR,
"bounces" BIGINT
);
CREATE TABLE ni_direct_pageviews_2017_q3_q4 (
"date" BIGINT,
"page_title" VARCHAR,
"unique_pageviews" DOUBLE,
"pageviews" DOUBLE,
"avg_time_on_page" VARCHAR,
"bounces" DOUBLE,
"unnamed_6" VARCHAR,
"unnamed_7" VARCHAR
);
CREATE TABLE ni_direct_pageviews_2018_q1_q2 (
"date" BIGINT,
"page_title" VARCHAR,
"unique_pageviews" BIGINT,
"pageviews" BIGINT,
"avg_time_on_page" VARCHAR,
"bounces" BIGINT
);
CREATE TABLE ni_direct_pageviews_2018_q3_q4 (
"date" BIGINT,
"page_title" VARCHAR,
"unique_pageviews" BIGINT,
"pageviews" BIGINT,
"avg_time_on_page" VARCHAR,
"bounces" BIGINT
);
CREATE TABLE ni_direct_pageviews_2019_q1_q2 (
"date" BIGINT,
"page_title" VARCHAR,
"unique_pageviews" DOUBLE,
"pageviews" DOUBLE,
"avg_time_on_page" VARCHAR,
"bounces" DOUBLE
);
CREATE TABLE ni_direct_pageviews_2019_q3_q4 (
"date" BIGINT,
"page_title" VARCHAR,
"unique_pageviews" DOUBLE,
"pageviews" DOUBLE,
"avg_time_on_page" VARCHAR,
"bounces" DOUBLE
);
CREATE TABLE ni_direct_pageviews_2020_q1_q2 (
"date" BIGINT,
"page_title" VARCHAR,
"unique_pageviews" BIGINT,
"pageviews" BIGINT,
"avg_time_on_page" VARCHAR,
"bounces" BIGINT
);
CREATE TABLE ni_direct_pageviews_2020_q3_q4 (
"date" BIGINT,
"page_title" VARCHAR,
"unique_pageviews" BIGINT,
"pageviews" BIGINT,
"avg_time_on_page" VARCHAR,
"bounces" BIGINT
);
CREATE TABLE ni_direct_pageviews_2021_q1_q2 (
"date" BIGINT,
"page_title" VARCHAR,
"unique_pageviews" BIGINT,
"pageviews" BIGINT,
"avg_time_on_page" VARCHAR,
"bounces" BIGINT
);
CREATE TABLE ni_direct_pageviews_2021_q3_q4 (
"date" BIGINT,
"page_title" VARCHAR,
"unique_pageviews" BIGINT,
"pageviews" BIGINT,
"avg_time_on_page" VARCHAR,
"bounces" BIGINT
);
CREATE TABLE ni_direct_pageviews_2022_q1_q2 (
"date" BIGINT,
"page_title" VARCHAR,
"unique_pageviews" BIGINT,
"pageviews" BIGINT,
"avg_time_on_page" VARCHAR,
"bounces" BIGINT
);
CREATE TABLE ni_direct_search_terms_2016_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,
"average_search_depth" DOUBLE
);
Anyone who has the link will be able to view this.