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,603
Last fetched onMon 21st Jan 2019

Number of items by state

StateNumber of items
Updated2,603
Deleted0
Total2,603

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,603 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,603 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:10.99%(286 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:10.99%(286 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:10.99%(286 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:10.99%(286 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,603 items)
% of updated items containing this field
Datatype:integerPresent:100%
% of values with datatype=integer
Minimum integer value:16
Maximum integer value:5676
Number of unique values:>10
Example:1001
 
Fieldname:name
Path:data/name
Present:100.00%(2,603 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:Brunswick Ashford
 
Fieldname:provisions
Path:data/provisions
Present:100.00%(2,603 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:6.15%(160 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:6.15%(160 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:6.15%(160 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:6.15%(160 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,603 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:Club night every Wednesday during season(September - April) and some Wednesdays during off season.
URLPresent:0%
% 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,603 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,366 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,366 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:Thornbury Cricket Club, 17 Daleside Road, Pudsey, Pudsey
 
Fieldname:availableTables
Path:data/venue/[0]/availableTables
Present:90.90%(2,366 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:2
 
Fieldname:email
Path:data/venue/[0]/email
Present:90.90%(2,366 items)
% of updated items containing this field
Datatypes:NULLPresent:85%
% of values with datatype=NULL
Number of unique values:>10
Example:info@haworthhawks.co.uk
emailPresent:15%
% of values with datatype=email
Minimum email length:11
Maximum email length:42
Number of unique values:>10
Example:bttc.contact@gmail.com
 
Fieldname:facilities
Path:data/venue/[0]/facilities
Present:90.90%(2,366 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.38%(114 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.38%(114 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.38%(114 items)
% of updated items containing this field
Datatype:integerPresent:100%
% of values with datatype=integer
Minimum integer value:1
Maximum integer value:5
Possible values:
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
 
Fieldname:name
Path:data/venue/[0]/facilities/[0]/name
Present:4.38%(114 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,366 items)
% of updated items containing this field
Datatype:integerPresent:100%
% of values with datatype=integer
Minimum integer value:2593
Maximum integer value:5677
Number of unique values:>10
Example:2815
 
Fieldname:lat
Path:data/venue/[0]/lat
Present:90.90%(2,366 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:53.80091
integerPresent:20%
% of values with datatype=integer
Minimum integer value:0
Maximum integer value:0
Number of unique values:>10
Example:51.71229
 
Fieldname:lng
Path:data/venue/[0]/lng
Present:90.90%(2,366 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.69928
integerPresent:20%
% of values with datatype=integer
Minimum integer value:0
Maximum integer value:0
Number of unique values:>10
Example:-1.98793
 
Fieldname:name
Path:data/venue/[0]/name
Present:90.90%(2,366 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:Thornbury Cricket Club
 
Fieldname:phone
Path:data/venue/[0]/phone
Present:90.90%(2,366 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,366 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:LS28 8EX
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,366 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,366 items)
% of updated items containing this field
Datatypes: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
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
 
Fieldname:website
Path:data/venue/[0]/website
Present:90.90%(2,366 items)
% of updated items containing this field
Datatypes:NULLPresent:92%
% of values with datatype=NULL
Number of unique values:>10
Example:http://www.colindeatontta.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.bttc.co.uk
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,603 items)
% of updated items containing this field
Datatypes: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:http://bhpclub.org.uk
stringPresent:1%
% of values with datatype=string
Minimum string length:16
Maximum string length:37
Number of unique values:>10
Example:61 Westhill Road
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,603 items)
% of items containing this field
Datatype:integerPresent:100%
% of values with datatype=integer
Minimum integer value:16
Maximum integer value:5676
Number of unique values:>10
Example:1001
 
Fieldname:kind
Path:kind
Present:100.00%(2,603 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,603 items)
% of items containing this field
Datatype:integerPresent:100%
% of values with datatype=integer
Minimum integer value:332253
Maximum integer value:1864681
Number of unique values:>10
Example:1592784
 
Fieldname:state
Path:state
Present:100.00%(2,603 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

This feed does not appear to have any activities - there is no data/activity field present in any items.

Tools