OpenDataNI Website Statistics Data
OpenDataNI
@ukgov.opendatani_website_statistics_data
OpenDataNI
@ukgov.opendatani_website_statistics_data
OpenDataNI website usage data, collated via Google Analytics, for the period from the site's launch on 26th November 2015 onward.
Publisher name: OpenDataNI
Last updated: 2023-04-14T06:57:59Z
CREATE TABLE opendatani_daily_dataset_download_numbers (
"day_index" TIMESTAMP,
"total_events" BIGINT
);CREATE TABLE opendatani_monthly_dataset_downloads (
"month" BIGINT,
"event_action" VARCHAR,
"page_title" VARCHAR,
"total_events" BIGINT,
"sessions_with_event" BIGINT,
"publisher" VARCHAR,
"dataset_where_unclear_from_recorded_page_title" VARCHAR -- Dataset (where Unclear From Recorded Page Title)
);CREATE TABLE opendatani_quarterly_dataset_download_totals_by_publisher (
"publisher" VARCHAR,
"download_numbers_2015_q4" VARCHAR -- Download Numbers - 2015 Q4,
"download_numbers_2016_q1" VARCHAR -- Download Numbers - 2016 Q1,
"download_numbers_2016_q2" VARCHAR -- Download Numbers - 2016 Q2,
"download_numbers_2016_q3" VARCHAR -- Download Numbers - 2016 Q3,
"download_numbers_2016_q4" VARCHAR -- Download Numbers - 2016 Q4,
"download_numbers_2017_q1" VARCHAR -- Download Numbers - 2017 Q1,
"download_numbers_2017_q2" VARCHAR -- Download Numbers - 2017 Q2,
"download_numbers_2017_q3" VARCHAR -- Download Numbers - 2017 Q3,
"download_numbers_2017_q4" VARCHAR -- Download Numbers - 2017 Q4,
"download_numbers_2018_q1" VARCHAR -- Download Numbers - 2018 Q1,
"download_numbers_2018_q2" VARCHAR -- Download Numbers - 2018 Q2,
"download_numbers_2018_q3" VARCHAR -- Download Numbers - 2018 Q3,
"download_numbers_2018_q4" VARCHAR -- Download Numbers - 2018 Q4,
"download_numbers_2019_q1" VARCHAR -- Download Numbers - 2019 Q1,
"download_numbers_2019_q2" VARCHAR -- Download Numbers - 2019 Q2,
"download_numbers_2019_q3" VARCHAR -- Download Numbers - 2019 Q3,
"download_numbers_2019_q4" VARCHAR -- Download Numbers - 2019 Q4,
"download_numbers_2020_q1" VARCHAR -- Download Numbers - 2020 Q1,
"download_numbers_2020_q2" VARCHAR -- Download Numbers - 2020 Q2,
"download_numbers_2020_q3" VARCHAR -- Download Numbers - 2020 Q3,
"download_numbers_2020_q4" VARCHAR -- Download Numbers - 2020 Q4,
"download_numbers_2021_q1" VARCHAR -- Download Numbers - 2021 Q1,
"download_numbers_2021_q2" VARCHAR -- Download Numbers - 2021 Q2,
"download_numbers_2021_q3" VARCHAR -- Download Numbers - 2021 Q3,
"download_numbers_2021_q4" VARCHAR -- Download Numbers - 2021 Q4,
"download_numbers_2022_q1" VARCHAR -- Download Numbers - 2022 Q1,
"download_numbers_2022_q2" VARCHAR -- Download Numbers - 2022 Q2,
"unnamed_28" VARCHAR -- Unnamed: 28,
"unnamed_29" VARCHAR -- Unnamed: 29,
"unnamed_30" VARCHAR -- Unnamed: 30
);Anyone who has the link will be able to view this.