We organise UK open data by location and signpost the source.

Table Tennis England OpenActive Data Profile

This Data Profile summarises the data published by Table Tennis England under the OpenActive initiate. The Data Profile includes fieldnames, data structure, datatypes, example values and more.

Overview

Total number of items2,625
Last fetched onFri 24th Jan 2020

Number of items by state

StateNumber of items
Updated2,625
Deleted0
Total2,625

Data structure

The data structure is displayed as a series of paths. Each path can be a fieldname/value pair, or an array of variables. Note that the Opportunity Model allows for both within the same feed, so a path might be a fieldname/value pair for one item, and an array for another.

Special symbol [0] signifies a sequential array.

data
data/accreditation
data/accreditation/[0]
data/accreditation/[0]/description
data/accreditation/[0]/id
data/accreditation/[0]/name
data/id
data/name
data/provisions
data/provisions/[0]
data/provisions/[0]/description
data/provisions/[0]/id
data/provisions/[0]/name
data/timetableUrl
data/venue
data/venue/[0]
data/venue/[0]/address
data/venue/[0]/availableTables
data/venue/[0]/email
data/venue/[0]/facilities
data/venue/[0]/facilities/[0]
data/venue/[0]/facilities/[0]/description
data/venue/[0]/facilities/[0]/id
data/venue/[0]/facilities/[0]/name
data/venue/[0]/id
data/venue/[0]/lat
data/venue/[0]/lng
data/venue/[0]/name
data/venue/[0]/phone
data/venue/[0]/postcode
data/venue/[0]/primaryVenue
data/venue/[0]/type
data/venue/[0]/website
data/websiteUrl
id
kind
modified
state

Datatypes

All data in the feed is extracted and analysed, and a profile produced on what is found. Note that this represents a point in time - the publisher may make changes to their feeds which would alter the data profile.

Fieldname:data
Path:data
Present:100.00%(2,625 items)
% of updated items containing this field
Datatype:objectPresent:100%
% of values with datatype=object
Minimum number of elements:7
Maximum number of elements:7
 
Fieldname:accreditation
Path:data/accreditation
Present:100.00%(2,625 items)
% of updated items containing this field
Datatype:arrayPresent:100%
% of values with datatype=array
Minimum number of elements:0
Maximum number of elements:1
 
Fieldname:[0](denotes one or more array elements)
Path:data/accreditation/[0]
Present:11.81%(310 items)
% of updated items containing this field
Datatype:objectPresent:100%
% of values with datatype=object
Minimum number of elements:3
Maximum number of elements:3
 
Fieldname:description
Path:data/accreditation/[0]/description
Present:11.81%(310 items)
% of updated items containing this field
Datatype:stringPresent:100%
% of values with datatype=string
Minimum string length:42
Maximum string length:107
Possible values:
  • Club holds the Ability Club status from Table Tennis England and has received Disability Awareness Training
  • Club is affiliated to Table Tennis England
 
Fieldname:id
Path:data/accreditation/[0]/id
Present:11.81%(310 items)
% of updated items containing this field
Datatype:integerPresent:100%
% of values with datatype=integer
Minimum integer value:2
Maximum integer value:4
Possible values:
  • 2
  • 4
 
Fieldname:name
Path:data/accreditation/[0]/name
Present:11.81%(310 items)
% of updated items containing this field
Datatype:stringPresent:100%
% of values with datatype=string
Minimum string length:9
Maximum string length:12
Possible values:
  • Ability Club
  • Free Club
 
Fieldname:id
Path:data/id
Present:100.00%(2,625 items)
% of updated items containing this field
Datatype:integerPresent:100%
% of values with datatype=integer
Minimum integer value:16
Maximum integer value:5732
Number of unique values:>10
Example:2383
 
Fieldname:name
Path:data/name
Present:100.00%(2,625 items)
% of updated items containing this field
Datatype:stringPresent:100%
% of values with datatype=string
Minimum string length:2
Maximum string length:52
Number of unique values:>10
Example: The Untouchables
 
Fieldname:provisions
Path:data/provisions
Present:100.00%(2,625 items)
% of updated items containing this field
Datatype:arrayPresent:100%
% of values with datatype=array
Minimum number of elements:0
Maximum number of elements:8
 
Fieldname:[0](denotes one or more array elements)
Path:data/provisions/[0]
Present:7.01%(184 items)
% of updated items containing this field
Datatype:objectPresent:100%
% of values with datatype=object
Minimum number of elements:3
Maximum number of elements:3
 
Fieldname:description
Path:data/provisions/[0]/description
Present:7.01%(184 items)
% of updated items containing this field
Datatype:stringPresent:100%
% of values with datatype=string
Minimum string length:23
Maximum string length:53
Possible values:
  • Beginners are welcome at this club
  • Has opportunities for open unstructured play
  • Junior coaching is available
  • Provides access to competitive events
  • Runs female only sessions
  • Runs over 55's sessions
  • Senior coaching is available
  • Suitable for people with disabilities and impairments
 
Fieldname:id
Path:data/provisions/[0]/id
Present:7.01%(184 items)
% of updated items containing this field
Datatype:integerPresent:100%
% of values with datatype=integer
Minimum integer value:4
Maximum integer value:12
Possible values:
  • 4
  • 5
  • 6
  • 8
  • 9
  • 10
  • 11
  • 12
 
Fieldname:name
Path:data/provisions/[0]/name
Present:7.01%(184 items)
% of updated items containing this field
Datatype:NULLPresent:100%
% of values with datatype=NULL
Possible values:
  • NULL
 
Fieldname:timetableUrl
Path:data/timetableUrl
Present:100.00%(2,625 items)
% of updated items containing this field
Datatypes:NULLPresent:99%
% of values with datatype=NULL
Possible values:
  • NULL
stringPresent:1%
% of values with datatype=string
Minimum string length:0
Maximum string length:98
Number of unique values:>10
Example:7.15pm on Tuesdays
URLPresent:1%
% of values with datatype=URL
Minimum URL length:23
Maximum URL length:69
Number of unique values:>10
Example:http://www.corbysmashttc.co.uk
 
Fieldname:venue
Path:data/venue
Present:100.00%(2,625 items)
% of updated items containing this field
Datatype:arrayPresent:100%
% of values with datatype=array
Minimum number of elements:0
Maximum number of elements:8
 
Fieldname:[0](denotes one or more array elements)
Path:data/venue/[0]
Present:90.90%(2,386 items)
% of updated items containing this field
Datatype:objectPresent:100%
% of values with datatype=object
Minimum number of elements:13
Maximum number of elements:13
 
Fieldname:address
Path:data/venue/[0]/address
Present:90.90%(2,386 items)
% of updated items containing this field
Datatype:stringPresent:100%
% of values with datatype=string
Minimum string length:0
Maximum string length:150
Number of unique values:>10
Example:Clee Sports Hall, Ladysmith Road, Grimsby, Grimsby
 
Fieldname:availableTables
Path:data/venue/[0]/availableTables
Present:90.90%(2,386 items)
% of updated items containing this field
Datatype:integerPresent:100%
% of values with datatype=integer
Minimum integer value:0
Maximum integer value:20
Number of unique values:>10
Example:16
 
Fieldname:email
Path:data/venue/[0]/email
Present:90.90%(2,386 items)
% of updated items containing this field
Datatypes:NULLPresent:85%
% of values with datatype=NULL
Number of unique values:>10
Example:bttc.contact@gmail.com
emailPresent:15%
% of values with datatype=email
Minimum email length:11
Maximum email length:42
Number of unique values:>10
Example:Adeyfield@talktalkbusiness.net
 
Fieldname:facilities
Path:data/venue/[0]/facilities
Present:90.90%(2,386 items)
% of updated items containing this field
Datatype:arrayPresent:100%
% of values with datatype=array
Minimum number of elements:0
Maximum number of elements:6
 
Fieldname:[0](denotes one or more array elements)
Path:data/venue/[0]/facilities/[0]
Present:4.72%(124 items)
% of updated items containing this field
Datatype:objectPresent:100%
% of values with datatype=object
Minimum number of elements:3
Maximum number of elements:3
 
Fieldname:description
Path:data/venue/[0]/facilities/[0]/description
Present:4.72%(124 items)
% of updated items containing this field
Datatype:stringPresent:100%
% of values with datatype=string
Minimum string length:28
Maximum string length:70
Possible values:
  • Club has a place you can purchase refreshments or snacks
  • This Club has changing facilities suitable for those with disabilities
  • This Club has dedicated disability toilets
  • This club has onsite changing facilities
  • This club has onsite parking
  • Venue is wheelchair accessible
 
Fieldname:id
Path:data/venue/[0]/facilities/[0]/id
Present:4.72%(124 items)
% of updated items containing this field
Datatype:integerPresent:100%
% of values with datatype=integer
Minimum integer value:1
Maximum integer value:6
Possible values:
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
 
Fieldname:name
Path:data/venue/[0]/facilities/[0]/name
Present:4.72%(124 items)
% of updated items containing this field
Datatype:stringPresent:100%
% of values with datatype=string
Minimum string length:7
Maximum string length:19
Possible values:
  • Accessible Changing
  • Accessible Toilets
  • Cafe/Refreshments
  • Changing Rooms
  • Disability Access
  • Parking
 
Fieldname:id
Path:data/venue/[0]/id
Present:90.90%(2,386 items)
% of updated items containing this field
Datatype:integerPresent:100%
% of values with datatype=integer
Minimum integer value:2593
Maximum integer value:5733
Number of unique values:>10
Example:3722
 
Fieldname:lat
Path:data/venue/[0]/lat
Present:90.90%(2,386 items)
% of updated items containing this field
Datatypes:doublePresent:80%
% of values with datatype=double
Minimum double value:50.1225
Maximum double value:55.64044
Number of unique values:>10
Example:52.55368
integerPresent:20%
% of values with datatype=integer
Minimum integer value:0
Maximum integer value:0
Number of unique values:>10
Example:51.13074
 
Fieldname:lng
Path:data/venue/[0]/lng
Present:90.90%(2,386 items)
% of updated items containing this field
Datatypes:doublePresent:80%
% of values with datatype=double
Minimum double value:-5.90503
Maximum double value:1.73278
Number of unique values:>10
Example:-1.46495
integerPresent:20%
% of values with datatype=integer
Minimum integer value:0
Maximum integer value:0
Number of unique values:>10
Example:-2.80626
 
Fieldname:name
Path:data/venue/[0]/name
Present:90.90%(2,386 items)
% of updated items containing this field
Datatype:stringPresent:100%
% of values with datatype=string
Minimum string length:3
Maximum string length:60
Number of unique values:>10
Example:Clee Sports Hall
 
Fieldname:phone
Path:data/venue/[0]/phone
Present:90.90%(2,386 items)
% of updated items containing this field
Datatype:stringPresent:100%
% of values with datatype=string
Minimum string length:0
Maximum string length:0
Possible values:
  • [EMPTY]
 
Fieldname:postcode
Path:data/venue/[0]/postcode
Present:90.90%(2,386 items)
% of updated items containing this field
Datatypes:stringPresent:100%
% of values with datatype=string
Minimum string length:6
Maximum string length:8
Number of unique values:>10
Example:DN32 9SW
NULLPresent:0%
% of values with datatype=NULL
Possible values:
  • NULL
  • BD17 5NH
  • BD9 5PH
  • WF16 9ED
 
Fieldname:primaryVenue
Path:data/venue/[0]/primaryVenue
Present:90.90%(2,386 items)
% of updated items containing this field
Datatype:booleanPresent:100%
% of values with datatype=boolean
Possible values:
  • [EMPTY]
  • 1
 
Fieldname:type
Path:data/venue/[0]/type
Present:90.90%(2,386 items)
% of updated items containing this field
Datatypes:NULLPresent:40%
% of values with datatype=NULL
Possible values:
  • NULL
  • A dedicated Table Tennis facility
  • A school, college or university
  • A village hall or leisure centre
stringPresent:60%
% of values with datatype=string
Minimum string length:0
Maximum string length:33
Possible values:
  • NULL
  • A dedicated Table Tennis facility
  • A school, college or university
  • A village hall or leisure centre
 
Fieldname:website
Path:data/venue/[0]/website
Present:90.90%(2,386 items)
% of updated items containing this field
Datatypes:NULLPresent:92%
% of values with datatype=NULL
Number of unique values:>10
Example:http://www.thenorthern.co.uk
URLPresent:7%
% of values with datatype=URL
Minimum URL length:20
Maximum URL length:116
Number of unique values:>10
Example:http://www.pontesquash.com/
stringPresent:1%
% of values with datatype=string
Minimum string length:19
Maximum string length:32
Possible values:
  • NULL
  • http:\\www.theabbeycentre.org.uk
  • www.mossfordttc.org
 
Fieldname:websiteUrl
Path:data/websiteUrl
Present:100.00%(2,625 items)
% of updated items containing this field
Datatypes:stringPresent:1%
% of values with datatype=string
Minimum string length:16
Maximum string length:37
Number of unique values:>10
Example:61 Westhill Road
NULLPresent:92%
% of values with datatype=NULL
Possible values:
  • NULL
URLPresent:7%
% of values with datatype=URL
Minimum URL length:19
Maximum URL length:186
Number of unique values:>10
Example:https://www.tabletennis365.com/AbbeydalePark
emailPresent:0%
% of values with datatype=email
Minimum email length:21
Maximum email length:21
Possible values:
  • sainttony68@gmail.com
 
Fieldname:id
Path:id
Present:100.00%(2,625 items)
% of items containing this field
Datatype:integerPresent:100%
% of values with datatype=integer
Minimum integer value:16
Maximum integer value:5732
Number of unique values:>10
Example:2383
 
Fieldname:kind
Path:kind
Present:100.00%(2,625 items)
% of items containing this field
Datatype:stringPresent:100%
% of values with datatype=string
Minimum string length:4
Maximum string length:4
Possible values:
  • club
 
Fieldname:modified
Path:modified
Present:100.00%(2,625 items)
% of items containing this field
Datatype:integerPresent:100%
% of values with datatype=integer
Minimum integer value:332253
Maximum integer value:2110450
Number of unique values:>10
Example:1594164
 
Fieldname:state
Path:state
Present:100.00%(2,625 items)
% of items containing this field
Datatype:stringPresent:100%
% of values with datatype=string
Minimum string length:7
Maximum string length:7
Possible values:
  • updated
 

Activities

The data/activity field contains one or more activities for each item, as an array of objects. The table below shows the distinct activities present in the feed, and the number of items for each activity:

Activity#Items
Tennis2,625
Total

2,625

Tools