Ping! OpenActive Data Profile

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

Overview

Total number of items845
Last fetched onMon 21st Jan 2019

Number of items by state

StateNumber of items
Updated845
Deleted0
Total845

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/address
data/country
data/county
data/indoor_outdoor
data/lat
data/lng
data/name
data/postcode
data/static
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%(845 items)
% of updated items containing this field
Datatype:objectPresent:100%
% of values with datatype=object
Minimum number of elements:9
Maximum number of elements:9
 
Fieldname:address
Path:data/address
Present:100.00%(845 items)
% of updated items containing this field
Datatype:stringPresent:100%
% of values with datatype=string
Minimum string length:0
Maximum string length:116
Number of unique values:>10
Example:Lillie Road, London
 
Fieldname:country
Path:data/country
Present:100.00%(845 items)
% of updated items containing this field
Datatype:stringPresent:100%
% of values with datatype=string
Minimum string length:2
Maximum string length:2
Possible values:
  • uk
 
Fieldname:county
Path:data/county
Present:100.00%(845 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:indoor_outdoor
Path:data/indoor_outdoor
Present:100.00%(845 items)
% of updated items containing this field
Datatype:stringPresent:100%
% of values with datatype=string
Minimum string length:0
Maximum string length:17
Number of unique values:>10
Example:Indoor
 
Fieldname:lat
Path:data/lat
Present:100.00%(845 items)
% of updated items containing this field
Datatype:stringPresent:100%
% of values with datatype=string
Minimum string length:0
Maximum string length:18
Number of unique values:>10
Example:51.48270614512216
 
Fieldname:lng
Path:data/lng
Present:100.00%(845 items)
% of updated items containing this field
Datatype:stringPresent:100%
% of values with datatype=string
Minimum string length:0
Maximum string length:22
Number of unique values:>10
Example:-0.21767672911380487
 
Fieldname:name
Path:data/name
Present:100.00%(845 items)
% of updated items containing this field
Datatype:stringPresent:100%
% of values with datatype=string
Minimum string length:3
Maximum string length:71
Number of unique values:>10
Example:000 Test Table
 
Fieldname:postcode
Path:data/postcode
Present:100.00%(845 items)
% of updated items containing this field
Datatype:stringPresent:100%
% of values with datatype=string
Minimum string length:0
Maximum string length:8
Number of unique values:>10
Example:SW6 7PD
 
Fieldname:static
Path:data/static
Present:100.00%(845 items)
% of updated items containing this field
Datatype:stringPresent:100%
% of values with datatype=string
Minimum string length:0
Maximum string length:18
Number of unique values:>10
Example:Static
 
Fieldname:id
Path:id
Present:100.00%(845 items)
% of items containing this field
Datatype:integerPresent:100%
% of values with datatype=integer
Minimum integer value:66
Maximum integer value:5544
Number of unique values:>10
Example:66
 
Fieldname:kind
Path:kind
Present:100.00%(845 items)
% of items containing this field
Datatype:stringPresent:100%
% of values with datatype=string
Minimum string length:27
Maximum string length:27
Possible values:
  • table_tennis_table_location
 
Fieldname:modified
Path:modified
Present:100.00%(845 items)
% of items containing this field
Datatype:integerPresent:100%
% of values with datatype=integer
Minimum integer value:1516196164
Maximum integer value:1546871848
Number of unique values:>10
Example:1516196164
 
Fieldname:state
Path:state
Present:100.00%(845 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