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_user_device_categories_2017_q3_q4 (
"date" BIGINT,
"device_category" VARCHAR,
"sessions" BIGINT,
"avg_session_duration" VARCHAR -- Avg. Session Duration,
"bounce_rate" VARCHAR,
"users" BIGINT,
"new_users" BIGINT
);CREATE TABLE ni_direct_user_device_categories_2018_q1_q2 (
"date" BIGINT,
"device_category" VARCHAR,
"sessions" BIGINT,
"avg_session_duration" VARCHAR -- Avg. Session Duration,
"bounce_rate" VARCHAR,
"users" BIGINT,
"new_users" BIGINT
);CREATE TABLE ni_direct_user_device_categories_2018_q3_q4 (
"date" DOUBLE,
"device_category" VARCHAR,
"sessions" DOUBLE,
"avg_session_duration" VARCHAR -- Avg. Session Duration,
"bounce_rate" VARCHAR,
"users" DOUBLE,
"new_users" DOUBLE
);CREATE TABLE ni_direct_user_device_categories_2019_q1_q2 (
"date" BIGINT,
"device_category" VARCHAR,
"sessions" BIGINT,
"avg_session_duration" VARCHAR -- Avg. Session Duration,
"bounce_rate" VARCHAR,
"users" BIGINT,
"new_users" BIGINT
);CREATE TABLE ni_direct_user_device_categories_2019_q3_q4 (
"date" BIGINT,
"device_category" VARCHAR,
"sessions" BIGINT,
"avg_session_duration" VARCHAR -- Avg. Session Duration,
"bounce_rate" VARCHAR,
"users" BIGINT,
"new_users" BIGINT
);CREATE TABLE ni_direct_user_device_categories_2020_q1_q2 (
"date" BIGINT,
"device_category" VARCHAR,
"sessions" BIGINT,
"avg_session_duration" VARCHAR -- Avg. Session Duration,
"bounce_rate" VARCHAR,
"users" BIGINT,
"new_users" BIGINT
);CREATE TABLE ni_direct_user_device_categories_2020_q3_q4 (
"date" BIGINT,
"device_category" VARCHAR,
"sessions" BIGINT,
"avg_session_duration" VARCHAR -- Avg. Session Duration,
"bounce_rate" VARCHAR,
"users" BIGINT,
"new_users" BIGINT
);CREATE TABLE ni_direct_user_device_categories_2021_q1_q2 (
"date" BIGINT,
"device_category" VARCHAR,
"sessions" BIGINT,
"avg_session_duration" VARCHAR -- Avg. Session Duration,
"bounce_rate" VARCHAR,
"users" BIGINT,
"new_users" BIGINT
);CREATE TABLE ni_direct_user_device_categories_2021_q3_q4 (
"date" BIGINT,
"device_category" VARCHAR,
"sessions" BIGINT,
"avg_session_duration" VARCHAR -- Avg. Session Duration,
"bounce_rate" VARCHAR,
"users" BIGINT,
"new_users" BIGINT
);CREATE TABLE ni_direct_user_device_categories_2022_q1_q2 (
"date" BIGINT,
"device_category" VARCHAR,
"sessions" BIGINT,
"avg_session_duration" VARCHAR -- Avg. Session Duration,
"bounce_rate" VARCHAR,
"users" BIGINT,
"new_users" BIGINT
);CREATE TABLE ni_direct_user_locations_2016_q3_q4 (
"date" BIGINT,
"city" VARCHAR,
"sessions" BIGINT,
"avg_session_duration" VARCHAR -- Avg. Session Duration,
"bounce_rate" VARCHAR,
"users" BIGINT,
"new_users" BIGINT
);CREATE TABLE ni_direct_user_locations_2017_q1_q2 (
"date" BIGINT,
"city" VARCHAR,
"sessions" BIGINT,
"avg_session_duration" VARCHAR -- Avg. Session Duration,
"bounce_rate" VARCHAR,
"users" BIGINT,
"new_users" BIGINT
);CREATE TABLE ni_direct_user_locations_2017_q3_q4 (
"date" BIGINT,
"city" VARCHAR,
"sessions" DOUBLE,
"avg_session_duration" VARCHAR -- Avg. Session Duration,
"bounce_rate" VARCHAR,
"users" DOUBLE,
"new_users" DOUBLE
);CREATE TABLE ni_direct_user_locations_2018_q1_q2 (
"date" BIGINT,
"city" VARCHAR,
"sessions" BIGINT,
"avg_session_duration" VARCHAR -- Avg. Session Duration,
"bounce_rate" VARCHAR,
"users" BIGINT,
"new_users" BIGINT
);CREATE TABLE ni_direct_user_locations_2018_q3_q4 (
"date" BIGINT,
"city" VARCHAR,
"sessions" BIGINT,
"avg_session_duration" VARCHAR -- Avg. Session Duration,
"bounce_rate" VARCHAR,
"users" BIGINT,
"new_users" BIGINT
);CREATE TABLE ni_direct_user_locations_2019_q1_q2 (
"date" BIGINT,
"city" VARCHAR,
"sessions" BIGINT,
"avg_session_duration" VARCHAR -- Avg. Session Duration,
"bounce_rate" VARCHAR,
"users" BIGINT,
"new_users" BIGINT
);CREATE TABLE ni_direct_user_locations_2019_q3_q4 (
"date" BIGINT,
"city" VARCHAR,
"sessions" BIGINT,
"avg_session_duration" VARCHAR -- Avg. Session Duration,
"bounce_rate" VARCHAR,
"users" BIGINT,
"new_users" BIGINT
);CREATE TABLE ni_direct_user_locations_2020_q1_q2 (
"date" BIGINT,
"city" VARCHAR,
"sessions" BIGINT,
"avg_session_duration" VARCHAR -- Avg. Session Duration,
"bounce_rate" VARCHAR,
"users" BIGINT,
"new_users" BIGINT
);CREATE TABLE ni_direct_user_locations_2020_q3_q4 (
"date" BIGINT,
"city" VARCHAR,
"sessions" BIGINT,
"avg_session_duration" VARCHAR -- Avg. Session Duration,
"bounce_rate" VARCHAR,
"users" BIGINT,
"new_users" BIGINT
);CREATE TABLE ni_direct_user_locations_2021_q1_q2 (
"date" BIGINT,
"city" VARCHAR,
"sessions" BIGINT,
"avg_session_duration" VARCHAR -- Avg. Session Duration,
"bounce_rate" VARCHAR,
"users" BIGINT,
"new_users" BIGINT
);CREATE TABLE ni_direct_user_locations_2021_q3_q4 (
"date" BIGINT,
"city" VARCHAR,
"sessions" BIGINT,
"avg_session_duration" VARCHAR -- Avg. Session Duration,
"bounce_rate" VARCHAR,
"users" BIGINT,
"new_users" BIGINT
);CREATE TABLE ni_direct_user_locations_2022_q1_q2 (
"date" BIGINT,
"city" VARCHAR,
"sessions" BIGINT,
"avg_session_duration" VARCHAR -- Avg. Session Duration,
"bounce_rate" VARCHAR,
"users" BIGINT,
"new_users" BIGINT
);CREATE TABLE ni_direct_user_network_domains_2016_q3_q4 (
"date" BIGINT,
"network_domain" VARCHAR,
"sessions" BIGINT,
"avg_session_duration" VARCHAR -- Avg. Session Duration,
"bounce_rate" VARCHAR,
"users" BIGINT,
"new_users" DOUBLE
);CREATE TABLE ni_direct_user_network_domains_2017_q1_q2 (
"date" BIGINT,
"network_domain" VARCHAR,
"sessions" BIGINT,
"avg_session_duration" VARCHAR -- Avg. Session Duration,
"bounce_rate" VARCHAR,
"users" BIGINT,
"new_users" BIGINT
);CREATE TABLE ni_direct_user_network_domains_2017_q3_q4 (
"date" BIGINT,
"network_domain" VARCHAR,
"sessions" DOUBLE,
"avg_session_duration" VARCHAR -- Avg. Session Duration,
"bounce_rate" VARCHAR,
"users" DOUBLE,
"new_users" DOUBLE
);Anyone who has the link will be able to view this.