Baselight
Sign In

Website Statistics

Lincolnshire County Council

@ukgov.website_statistics1

Metadata - Website Statistics Summary
@ukgov.website_statistics1.metadata_website_statistics_summary

Metadata for Website Statistics Summary 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.11 KB
  • 21 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 StatisticsWebsite Statistics SummaryOrganisation 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 StatisticsWebsite Statistics SummaryOrganisation 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 StatisticsWebsite Statistics SummaryPublished 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 StatisticsWebsite Statistics SummaryLatest DataBooleanOptionalTRUE where the data is the latest for the indicator. Else blank.LCCTRUE
50Website StatisticsWebsite Statistics SummaryDuration 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 StatisticsWebsite Statistics SummaryDuration 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 StatisticsWebsite Statistics SummaryGeo Entity NameStringOptionalType of geographic areaLCChttp://statistics.data.gov.uk/areasCounty
50Website StatisticsWebsite Statistics SummaryGeo CodeStringOptionalONS geography identifier for the geography in which the data is locatedLCChttp://statistics.data.gov.uk/areasE10000019
50Website StatisticsWebsite Statistics SummaryGeo NameStringOptionalONS geography name for the geography in which the data is locatedLCChttp://statistics.data.gov.uk/areasLincolnshire
50Website StatisticsWebsite Statistics SummaryGeo 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_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
);

Share link

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