Dataset: Childrens Centres

Metadata for Lincolnshire Childrens Centres 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_dsid Dataset ID (DSID)	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_data_rules_comment Schema Data Rules Comment	formatreference FormatReference	example Example
46	Childrens Centres	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
46	Childrens Centres	Organisation URI	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
46	Childrens Centres	Published Date	DateTime	Optional	Date at which the information provided is true. This field shows the Publication date. It represents the Applicable Date in LGA Schema.	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
46	Childrens Centres	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
46	Childrens Centres	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
46	Childrens Centres	Latest Data	Boolean	Optional	TRUE where the data is the latest for the indicator. Else blank.	LCC				TRUE
46	Childrens Centres	Unique Asset Identity	String	Mandatory	Local reference identifier used by the local body, sometimes known as local name or building block.	LGA	Site Ref
46	Childrens Centres	URN	String	Optional	Unique Reference Number (URN) of the establishment in national EduBase system	LCC
46	Childrens Centres	Establishment Status	String	Optional	Status of the establishment. Encoded list: Open; Closed.	LCC
46	Childrens Centres	Open Date	DateTime	Optional	Date opened	LCC			http://calendars.wikia.com/wiki/ISO_8601	YYYY-MM-DDThh:mm:ss eg: 2017-04-01T00:00:00

dataset_id_dsid

Dataset ID (DSID)

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

Childrens Centres

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

Childrens Centres

Organisation URI

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

Childrens Centres

Published Date

DateTime

Optional

Date at which the information provided is true. This field shows the Publication date. It represents the Applicable Date in LGA Schema.

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

Childrens Centres

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

Childrens Centres

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

Childrens Centres

Latest Data

Boolean

Optional

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

LCC

TRUE

Childrens Centres

Unique Asset Identity

String

Mandatory

Local reference identifier used by the local body, sometimes known as local name or building block.

LGA

Site Ref

Childrens Centres

URN

String

Optional

Unique Reference Number (URN) of the establishment in national EduBase system

LCC

Childrens Centres

Establishment Status

String

Optional

Status of the establishment. Encoded list: Open; Closed.

LCC

Childrens Centres

Open Date

DateTime

Optional

Date opened

LCC

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

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

CREATE TABLE table_2 ( "dataset_id_dsid" 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 );

Childrens Centres

Table List

Table 2

@ukgov.childrens_centres2.table_2

dataset_id_dsid

dataset_name

field

type

mandatory_or_optional_requirement_mor

field_description

schema

lcc_mapping

schema_comments

schema_data_rules_comment

formatreference

example

Share link