Dataset: Website Statistics

About this Dataset

Website Statistics

This Website Statistics dataset has three resources showing usage of the Lincolnshire Open Data website. Web analytics terms used in each resource are defined in their accompanying Metadata file. Please Note: due to a change in Analytics platform and accompanying metrics, the current files do not contain a full years data. The files will be updated again in January 2025 with 2024-2025 data. The previous dataset containing Web Analytics has been archived and can be found in the following link; https://lincolnshire.ckan.io/dataset/website-statistics-archived - Website Usage Statistics: This document shows a statistical summary of usage of the Lincolnshire Open Data site for the latest calendar year. - Website Statistics Summary: This dataset shows a website statistics summary for the Lincolnshire Open Data site for the latest calendar year. - Webpage Statistics: This dataset shows statistics for individual Webpages on the Lincolnshire Open Data site by calendar year. Note: The resources above exclude API calls (automated requests for datasets). These Website Statistics resources are updated annually in February by the Lincolnshire County Council Open Data team.
Publisher name: Lincolnshire County Council
Last updated: 2024-06-14T04:01:29Z

Tables

Website Statistics Summary

@ukgov.website_statistics1.website_statistics_summary

15.66 KB
1 row
21 columns


CREATE TABLE website_statistics_summary (
  "organisationlabel" VARCHAR,
  "organisationuri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "latestdata" BOOLEAN,
  "durationfrom" TIMESTAMP,
  "durationto" TIMESTAMP,
  "geoentityname" VARCHAR,
  "geocode" VARCHAR,
  "geoname" VARCHAR,
  "geouri" VARCHAR,
  "reportingperiodtype" VARCHAR,
  "year" BIGINT,
  "country" VARCHAR,
  "total_users" BIGINT,
  "new_users" BIGINT,
  "sessions" BIGINT,
  "views_per_session" DOUBLE,
  "average_engagement_time_per_session" VARCHAR,
  "sessions_per_user" DOUBLE,
  "views" BIGINT,
  "event_count" BIGINT
);

Metadata - Website Usage Statistics

@ukgov.website_statistics1.metadata_website_usage_statistics

5.17 KB
5 rows
5 columns


CREATE TABLE metadata_website_usage_statistics (
  "dataset_id" BIGINT,
  "dataset_name" VARCHAR,
  "resource_name" VARCHAR,
  "analytics_term" VARCHAR,
  "definition" VARCHAR
);

Metadata - Website Statistics Summary

@ukgov.website_statistics1.metadata_website_statistics_summary

12.11 KB
21 rows
13 columns


CREATE TABLE metadata_website_statistics_summary (
  "dataset_id" BIGINT,
  "dataset_name" VARCHAR,
  "resource_name" VARCHAR,
  "field" VARCHAR,
  "type" VARCHAR,
  "mandatory_or_optional_requirement_mor" VARCHAR,
  "field_description" VARCHAR,
  "schema" VARCHAR,
  "lcc_mapping" VARCHAR,
  "schema_comments" VARCHAR,
  "schema_data_rules_comment" VARCHAR,
  "formatreference" VARCHAR,
  "example" VARCHAR
);

Webpage Statistics

@ukgov.website_statistics1.webpage_statistics

24.96 KB
239 rows
19 columns


CREATE TABLE webpage_statistics (
  "organisationlabel" VARCHAR,
  "organisationuri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "latestdata" BOOLEAN,
  "durationfrom" TIMESTAMP,
  "durationto" TIMESTAMP,
  "geoentityname" VARCHAR,
  "geocode" VARCHAR,
  "geoname" VARCHAR,
  "geouri" VARCHAR,
  "reportingperiodtype" VARCHAR,
  "year" BIGINT,
  "pagepathandscreenclass" VARCHAR,
  "views" BIGINT,
  "averageengagementtimepersession" VARCHAR,
  "entrances" BIGINT,
  "bouncerate" VARCHAR,
  "exits" BIGINT,
  "totalusers" BIGINT
);

Metadata - Webpage Statistics

@ukgov.website_statistics1.metadata_webpage_statistics

12.17 KB
18 rows
13 columns


CREATE TABLE metadata_webpage_statistics (
  "dataset_id" BIGINT,
  "dataset_name" VARCHAR,
  "resource_name" VARCHAR,
  "field" VARCHAR,
  "type" VARCHAR,
  "mandatory_or_optional_requirement_mor" VARCHAR,
  "field_description" VARCHAR,
  "schema" VARCHAR,
  "lcc_mapping" VARCHAR,
  "schema_comments" VARCHAR,
  "schema_data_rules_comment" VARCHAR,
  "formatreference" VARCHAR,
  "example" VARCHAR
);