Baselight
Sign In

Website Statistics

Lincolnshire County Council

@ukgov.website_statistics1

Metadata - Webpage Statistics
@ukgov.website_statistics1.metadata_webpage_statistics

Metadata for Webpage Statistics dataset. This file contains Metadata (information about a dataset). It shows definitions of the web analytics terms used in the dataset. This file should be used along with the dataset to aid correct interpretation of the data.

  • 12.17 KB
  • 18 rows
  • 13 columns
dataset_id

Dataset ID

dataset_name

Dataset Name

resource_name

Resource Name

field

Field

type

Type

mandatory_or_optional_requirement_mor

Mandatory Or Optional Requirement (MOR)

field_description

Field Description

schema

Schema

lcc_mapping

LCC Mapping

schema_comments

Schema Comments

schema_data_rules_comment

Schema Data Rules Comment

formatreference

FormatReference

example

Example

50Website StatisticsWebpage StatisticsOrganisation NameStringOptionalName of the organisation that is the asset owner and if not the owner the main user of the asset.LGAName of the Organisation's area coverage. Would be beneficial if added to all the datasetsName of the Organisation's area coverage.Lincolnshire
50Website StatisticsWebpage StatisticsOrganisation URIStringOptionalA unique code to identify the asset owning/using organisation. For LAs this can be the URI from Open Data Communities.LGAhttp://opendatacommunities.org/def/concept/folders/themes/geographyLincolnshire County Council: http://opendatacommunities.org/doc/geography/administration/cty/E10000019
50Website StatisticsWebpage StatisticsPublished DateDateTimeOptionalDate at which the information provided is true.LGAInclude this field to show the publication date of the dataset (ie. the date on which the dataset's information is true).https://www.w3.org/TR/NOTE-datetimeYYYY-MM-DDThh:mm:ss eg: 2017-02-15T00:00:00
50Website StatisticsWebpage StatisticsLatest DataBooleanOptionalTRUE where the data is the latest for the indicator. Else blank.LCCTRUE
50Website StatisticsWebpage StatisticsDuration FromDateTimeOptionalDataset time period start, or start of accounting/reporting period. DurationFrom will always include a Time of 00:00:00.LGADataset time period start, or start of accounting/reporting period. DurationFrom will always include a Time of 00:00:00.http://calendars.wikia.com/wiki/ISO_8601YYYY-MM-DDThh:mm:ss eg: 2017-04-01T00:00:00
50Website StatisticsWebpage StatisticsDuration ToDateTimeOptionalDataset time period end, or end of accounting/reporting period.LGADataset time period end, or end of accounting/reporting period.http://calendars.wikia.com/wiki/ISO_8601YYYY-MM-DDThh:mm:ss eg: 2017-06-30T23:59:59
50Website StatisticsWebpage StatisticsGeo Entity NameStringOptionalType of geographic areaLCChttp://statistics.data.gov.uk/areasCounty
50Website StatisticsWebpage StatisticsGeo CodeStringOptionalONS geography identifier for the geography in which the data is locatedLCChttp://statistics.data.gov.uk/areasE10000019
50Website StatisticsWebpage StatisticsGeo NameStringOptionalONS geography name for the geography in which the data is locatedLCChttp://statistics.data.gov.uk/areasLincolnshire
50Website StatisticsWebpage StatisticsGeo URIStringOptionalONS geography linked data URI for the geography in which the data is locatedLCChttp://statistics.data.gov.uk/areashttp://statistics.data.gov.uk/doc/statistical-geography/E10000019

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
);

Share link

Anyone who has the link will be able to view this.