NI Direct Website Data
OpenDataNI
@ukgov.ni_direct_website_data
OpenDataNI
@ukgov.ni_direct_website_data
Data relating to public internet visits to the NI Direct website (https://www.nidirect.gov.uk), the official government website for Northern Ireland citizens. Last updated: 6 April 2022.
Publisher name: OpenDataNI
Last updated: 2024-06-14T04:02:48Z
CREATE TABLE ni_direct_browser_information_2016_q3_q4 (
"date" BIGINT,
"browser" VARCHAR,
"browser_version" VARCHAR,
"sessions" BIGINT,
"avg_session_duration" VARCHAR -- Avg. Session Duration,
"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 -- Avg. Session Duration,
"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 -- Avg. Session Duration,
"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 -- Avg. Session Duration,
"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 -- Avg. Session Duration,
"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 -- Avg. Session Duration,
"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 -- Avg. Session Duration,
"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 -- Avg. Session Duration,
"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 -- Avg. Session Duration,
"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 -- Avg. Session Duration,
"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 -- Avg. Session Duration,
"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 -- Avg. Session Duration,
"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 -- Avg. Time On Page,
"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 -- Avg. Time On Page,
"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 -- Avg. Time On Page,
"bounces" DOUBLE,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7
);CREATE TABLE ni_direct_pageviews_2018_q1_q2 (
"date" BIGINT,
"page_title" VARCHAR,
"unique_pageviews" BIGINT,
"pageviews" BIGINT,
"avg_time_on_page" VARCHAR -- Avg. Time On Page,
"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 -- Avg. Time On Page,
"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 -- Avg. Time On Page,
"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 -- Avg. Time On Page,
"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 -- Avg. Time On Page,
"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 -- Avg. Time On Page,
"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 -- Avg. Time On Page,
"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 -- Avg. Time On Page,
"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 -- Avg. Time On Page,
"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 -- Results Pageviews / Search,
"n__search_exits" VARCHAR -- % Search Exits,
"n__search_refinements" VARCHAR -- % Search Refinements,
"time_after_search" VARCHAR,
"average_search_depth" DOUBLE
);Anyone who has the link will be able to view this.