Dataset: Tourism - Visitors To Attractions

Metadata for the Tourism - Visits to Attractions dataset. This file contains Metadata (information about a dataset). It shows the schema for dataset fields and their contents. This file should be used along with the dataset, to aid correct interpretation of the data.

dataset_id Dataset ID	dataset_name Dataset Name	field Field	type Type	mandatory_or_optional_requirement_mor Mandatory Or Optional Requirement (MOR)	field_description Field Description	schema Schema	schema_data_rules_comment Schema Data Rules Comment	formatreference FormatReference	example Example
62	Tourism - Visits to Visitor Attractions	Organisation Name	String	Optional	Name of the organisation that is the asset owner and if not the owner the main user of the asset.	LGA	Name of the Organisation's area coverage. Would be beneficial if added to all the datasets	Name of the Organisation's area coverage.	Lincolnshire
62	Tourism - Visits to Visitor Attractions	Organisation Code	String	Optional	A unique code to identify the asset owning/using organisation. For LAs this can be the URI from Open Data Communities.	LGA		http://opendatacommunities.org/def/concept/folders/themes/geography	Lincolnshire County Council: http://opendatacommunities.org/doc/geography/administration/cty/E10000019
62	Tourism - Visits to Visitor Attractions	Published Date	DateTime	Optional	Date at which the information provided is true.	LGA	Include 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-datetime	YYYY-MM-DDThh:mm:ss eg: 2017-02-15T00:00:00
62	Tourism - Visits to Visitor Attractions	Duration From	DateTime	Optional	Dataset time period start, or start of accounting/reporting period. DurationFrom will always include a Time of 00:00:00.	LGA	Dataset 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_8601	YYYY-MM-DDThh:mm:ss eg: 2017-04-01T00:00:00
62	Tourism - Visits to Visitor Attractions	Duration To	DateTime	Optional	Dataset time period end, or end of accounting/reporting period.	LGA	Dataset time period end, or end of accounting/reporting period.	http://calendars.wikia.com/wiki/ISO_8601	YYYY-MM-DDThh:mm:ss eg: 2017-06-30T23:59:59
62	Tourism - Visits to Visitor Attractions	Latest Data	Boolean	Optional	TRUE where the data is the latest for the indicator. Else blank.	LCC			TRUE
62	Tourism - Visits to Visitor Attractions	Reporting Period Type	String	Mandatory	The type of time period the data record covers (eg. Calendar Year, Financial Year, Month, Quarter)	LCC	The type of time period the data record covers (eg. Calendar Year, Financial Year, Month, Quarter)		eg. Calendar Year
62	Tourism - Visits to Visitor Attractions	Geo Entity Name	String	Optional	Type of geographic area	LCC		http://statistics.data.gov.uk/areas	County
62	Tourism - Visits to Visitor Attractions	Geo Code	String	Optional	ONS geography identifier for the geography in which the data is located	LCC		http://statistics.data.gov.uk/areas	E10000019
62	Tourism - Visits to Visitor Attractions	Geo Name	String	Optional	ONS geography name for the geography in which the data is located	LCC		http://statistics.data.gov.uk/areas	Lincolnshire

dataset_id

Dataset ID

dataset_name

Dataset 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

Tourism - Visits to Visitor Attractions

Organisation Name

String

Optional

Name of the organisation that is the asset owner and if not the owner the main user of the asset.

LGA

Name of the Organisation's area coverage. Would be beneficial if added to all the datasets

Name of the Organisation's area coverage.

Lincolnshire

Tourism - Visits to Visitor Attractions

Organisation Code

String

Optional

A unique code to identify the asset owning/using organisation. For LAs this can be the URI from Open Data Communities.

LGA

http://opendatacommunities.org/def/concept/folders/themes/geography

Lincolnshire County Council: http://opendatacommunities.org/doc/geography/administration/cty/E10000019

Tourism - Visits to Visitor Attractions

Published Date

DateTime

Optional

Date at which the information provided is true.

LGA

Include 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-datetime

YYYY-MM-DDThh:mm:ss eg: 2017-02-15T00:00:00

Tourism - Visits to Visitor Attractions

Duration From

DateTime

Optional

Dataset time period start, or start of accounting/reporting period. DurationFrom will always include a Time of 00:00:00.

LGA

Dataset 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_8601

YYYY-MM-DDThh:mm:ss eg: 2017-04-01T00:00:00

Tourism - Visits to Visitor Attractions

Duration To

DateTime

Optional

Dataset time period end, or end of accounting/reporting period.

LGA

Dataset time period end, or end of accounting/reporting period.

http://calendars.wikia.com/wiki/ISO_8601

YYYY-MM-DDThh:mm:ss eg: 2017-06-30T23:59:59

Tourism - Visits to Visitor Attractions

Latest Data

Boolean

Optional

TRUE where the data is the latest for the indicator. Else blank.

LCC

TRUE

Tourism - Visits to Visitor Attractions

Reporting Period Type

String

Mandatory

The type of time period the data record covers (eg. Calendar Year, Financial Year, Month, Quarter)

LCC

The type of time period the data record covers (eg. Calendar Year, Financial Year, Month, Quarter)

eg. Calendar Year

Tourism - Visits to Visitor Attractions

Geo Entity Name

String

Optional

Type of geographic area

LCC

http://statistics.data.gov.uk/areas

County

Tourism - Visits to Visitor Attractions

Geo Code

String

Optional

ONS geography identifier for the geography in which the data is located

LCC

http://statistics.data.gov.uk/areas

E10000019

Tourism - Visits to Visitor Attractions

Geo Name

String

Optional

ONS geography name for the geography in which the data is located

LCC

http://statistics.data.gov.uk/areas

Lincolnshire

CREATE TABLE table_2 ( "dataset_id" BIGINT, "dataset_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 );

Tourism - Visitors To Attractions

Table List

Table 2

@ukgov.tourism_visitors_to_attractions.table_2

dataset_id

dataset_name

field

type

mandatory_or_optional_requirement_mor

field_description

schema

lcc_mapping

schema_comments

schema_data_rules_comment

formatreference

example

Share link