NI Direct Website Data
OpenDataNI
@ukgov.ni_direct_website_data
OpenDataNI
@ukgov.ni_direct_website_data
CREATE TABLE ni_direct_user_device_categories_2017_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_2018_q1_q2 (
"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_2018_q3_q4 (
"date" DOUBLE,
"device_category" VARCHAR,
"sessions" DOUBLE,
"avg_session_duration" VARCHAR,
"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,
"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,
"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,
"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,
"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,
"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,
"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,
"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,
"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,
"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,
"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,
"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,
"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,
"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,
"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,
"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,
"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,
"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,
"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,
"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,
"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,
"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,
"bounce_rate" VARCHAR,
"users" DOUBLE,
"new_users" DOUBLE
);
Anyone who has the link will be able to view this.