OpenDataNI Website Statistics Data
OpenDataNI
@ukgov.opendatani_website_statistics_data
OpenDataNI
@ukgov.opendatani_website_statistics_data
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
);
CREATE TABLE opendatani_quarterly_dataset_download_totals_by_publisher (
"publisher" VARCHAR,
"download_numbers_2015_q4" VARCHAR,
"download_numbers_2016_q1" VARCHAR,
"download_numbers_2016_q2" VARCHAR,
"download_numbers_2016_q3" VARCHAR,
"download_numbers_2016_q4" VARCHAR,
"download_numbers_2017_q1" VARCHAR,
"download_numbers_2017_q2" VARCHAR,
"download_numbers_2017_q3" VARCHAR,
"download_numbers_2017_q4" VARCHAR,
"download_numbers_2018_q1" VARCHAR,
"download_numbers_2018_q2" VARCHAR,
"download_numbers_2018_q3" VARCHAR,
"download_numbers_2018_q4" VARCHAR,
"download_numbers_2019_q1" VARCHAR,
"download_numbers_2019_q2" VARCHAR,
"download_numbers_2019_q3" VARCHAR,
"download_numbers_2019_q4" VARCHAR,
"download_numbers_2020_q1" VARCHAR,
"download_numbers_2020_q2" VARCHAR,
"download_numbers_2020_q3" VARCHAR,
"download_numbers_2020_q4" VARCHAR,
"download_numbers_2021_q1" VARCHAR,
"download_numbers_2021_q2" VARCHAR,
"download_numbers_2021_q3" VARCHAR,
"download_numbers_2021_q4" VARCHAR,
"download_numbers_2022_q1" VARCHAR,
"download_numbers_2022_q2" VARCHAR,
"unnamed_28" VARCHAR,
"unnamed_29" VARCHAR,
"unnamed_30" VARCHAR
);
Anyone who has the link will be able to view this.