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

Upshot OpenActive Data Profile

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

Overview

Total number of items1,303
Last fetched onWed 21st Apr 2021

Number of items by state

StateNumber of items
Updated1,303
Deleted0
Total1,303

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/@context
data/duration
data/endDate
data/eventStatus
data/identifier
data/location
data/location/address
data/location/address/addressCountry
data/location/address/addressLocality
data/location/address/addressRegion
data/location/address/postalCode
data/location/address/streetAddress
data/location/address/type
data/location/geo
data/location/geo/latitude
data/location/geo/longitude
data/location/geo/type
data/location/name
data/location/type
data/location/url
data/name
data/startDate
data/superEvent
data/superEvent/activity
data/superEvent/activity/[0]
data/superEvent/activity/[0]/prefLabel
data/superEvent/activity/[0]/type
data/superEvent/category
data/superEvent/category/[0]
data/superEvent/identifier
data/superEvent/name
data/superEvent/organizer
data/superEvent/organizer/name
data/superEvent/organizer/type
data/superEvent/type
data/type
data/url
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%(1,303 items)
% of updated items containing this field
Datatype:objectPresent:100%
% of values with datatype=object
Minimum number of elements:11
Maximum number of elements:11
 
Fieldname:@context
Path:data/@context
Present:100.00%(1,303 items)
% of updated items containing this field
Datatype:URLPresent:100%
% of values with datatype=URL
Minimum URL length:22
Maximum URL length:22
Possible values:
 
Fieldname:duration
Path:data/duration
Present:100.00%(1,303 items)
% of updated items containing this field
Datatype:stringPresent:100%
% of values with datatype=string
Minimum string length:5
Maximum string length:5
Possible values:
  • PT30M
  • PT60M
 
Fieldname:endDate
Path:data/endDate
Present:100.00%(1,303 items)
% of updated items containing this field
Datatype:datePresent:100%
% of values with datatype=date
Number of unique values:>10
Example:2020-08-03T10:00:00Z
 
Fieldname:eventStatus
Path:data/eventStatus
Present:100.00%(1,303 items)
% of updated items containing this field
Datatype:URLPresent:100%
% of values with datatype=URL
Minimum URL length:33
Maximum URL length:33
Possible values:
 
Fieldname:identifier
Path:data/identifier
Present:100.00%(1,303 items)
% of updated items containing this field
Datatype:stringPresent:100%
% of values with datatype=string
Minimum string length:16
Maximum string length:16
Number of unique values:>10
Example:f548da46d3baf85f
 
Fieldname:location
Path:data/location
Present:100.00%(1,303 items)
% of updated items containing this field
Datatype:objectPresent:100%
% of values with datatype=object
Minimum number of elements:5
Maximum number of elements:5
 
Fieldname:address
Path:data/location/address
Present:100.00%(1,303 items)
% of updated items containing this field
Datatype:objectPresent:100%
% of values with datatype=object
Minimum number of elements:6
Maximum number of elements:6
 
Fieldname:addressCountry
Path:data/location/address/addressCountry
Present:100.00%(1,303 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:
  • GB
 
Fieldname:addressLocality
Path:data/location/address/addressLocality
Present:100.00%(1,303 items)
% of updated items containing this field
Datatype:stringPresent:100%
% of values with datatype=string
Minimum string length:5
Maximum string length:10
Possible values:
  • Deeside
  • London
  • Nottingham
  • Online
  • Phone
 
Fieldname:addressRegion
Path:data/location/address/addressRegion
Present:100.00%(1,303 items)
% of updated items containing this field
Datatype:stringPresent:100%
% of values with datatype=string
Minimum string length:5
Maximum string length:10
Possible values:
  • Deeside
  • London
  • Nottingham
  • Online
  • Phone
 
Fieldname:postalCode
Path:data/location/address/postalCode
Present:100.00%(1,303 items)
% of updated items containing this field
Datatype:stringPresent:100%
% of values with datatype=string
Minimum string length:7
Maximum string length:8
Possible values:
  • CH5 4BR
  • NG2 3NG
  • SW1V 3AL
  • W10 4QH
  • W10 6DZ
  • W12 7FW
 
Fieldname:streetAddress
Path:data/location/address/streetAddress
Present:100.00%(1,303 items)
% of updated items containing this field
Datatype:stringPresent:100%
% of values with datatype=string
Minimum string length:5
Maximum string length:32
Possible values:
  • 67 Ilbert St,
  • Kelsterton Road, Connah’s Quay
  • London
  • Loxley House, Station Street
  • Online
  • Phone
  • Pimlico
  • Shepherd's Bush,
 
Fieldname:type
Path:data/location/address/type
Present:100.00%(1,303 items)
% of updated items containing this field
Datatype:stringPresent:100%
% of values with datatype=string
Minimum string length:13
Maximum string length:13
Possible values:
  • PostalAddress
 
Fieldname:geo
Path:data/location/geo
Present:100.00%(1,303 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:latitude
Path:data/location/geo/latitude
Present:100.00%(1,303 items)
% of updated items containing this field
Datatype:doublePresent:100%
% of values with datatype=double
Minimum double value:51.486582617586
Maximum double value:53.22598312267
Possible values:
  • 51.486582617586
  • 51.509981002437
  • 51.522361990563
  • 51.528863944305
  • 52.948147719854
  • 53.22598312267
 
Fieldname:longitude
Path:data/location/geo/longitude
Present:100.00%(1,303 items)
% of updated items containing this field
Datatype:doublePresent:100%
% of values with datatype=double
Minimum double value:-3.078355379546
Maximum double value:-0.14257752108791
Possible values:
  • -3.078355379546
  • -1.1446044133627
  • -0.22621816250996
  • -0.21721799781802
  • -0.21075036906095
  • -0.14257752108791
 
Fieldname:type
Path:data/location/geo/type
Present:100.00%(1,303 items)
% of updated items containing this field
Datatype:stringPresent:100%
% of values with datatype=string
Minimum string length:14
Maximum string length:14
Possible values:
  • GeoCoordinates
 
Fieldname:name
Path:data/location/name
Present:100.00%(1,303 items)
% of updated items containing this field
Datatype:stringPresent:100%
% of values with datatype=string
Minimum string length:5
Maximum string length:39
Possible values:
  • BBC/ Hammersmith Park
  • COVID Trips
  • Churchill Gardens pitch
  • Coleg Cambria – Deeside
  • Nottingham City Council - This Girl Can
  • Online
  • Phone
  • Queens Park Gardens
 
Fieldname:type
Path:data/location/type
Present:100.00%(1,303 items)
% of updated items containing this field
Datatype:stringPresent:100%
% of values with datatype=string
Minimum string length:5
Maximum string length:5
Possible values:
  • Place
 
Fieldname:url
Path:data/location/url
Present:100.00%(1,303 items)
% of updated items containing this field
Datatype:URLPresent:100%
% of values with datatype=URL
Minimum URL length:27
Maximum URL length:27
Possible values:
 
Fieldname:name
Path:data/name
Present:100.00%(1,303 items)
% of updated items containing this field
Datatype:stringPresent:100%
% of values with datatype=string
Minimum string length:9
Maximum string length:45
Number of unique values:>10
Example:Ballet Monday
 
Fieldname:startDate
Path:data/startDate
Present:100.00%(1,303 items)
% of updated items containing this field
Datatype:datePresent:100%
% of values with datatype=date
Number of unique values:>10
Example:2020-08-03T09:00:00Z
 
Fieldname:superEvent
Path:data/superEvent
Present:100.00%(1,303 items)
% of updated items containing this field
Datatype:objectPresent:100%
% of values with datatype=object
Minimum number of elements:6
Maximum number of elements:6
 
Fieldname:activity
Path:data/superEvent/activity
Present:100.00%(1,303 items)
% of updated items containing this field
Datatype:arrayPresent:100%
% of values with datatype=array
Minimum number of elements:1
Maximum number of elements:1
 
Fieldname:[0](denotes one or more array elements)
Path:data/superEvent/activity/[0]
Present:100.00%(1,303 items)
% of updated items containing this field
Datatype:objectPresent:100%
% of values with datatype=object
Minimum number of elements:2
Maximum number of elements:2
 
Fieldname:prefLabel
Path:data/superEvent/activity/[0]/prefLabel
Present:100.00%(1,303 items)
% of updated items containing this field
Datatype:stringPresent:100%
% of values with datatype=string
Minimum string length:9
Maximum string length:42
Number of unique values:>10
Example:Ballet Monday
 
Fieldname:type
Path:data/superEvent/activity/[0]/type
Present:100.00%(1,303 items)
% of updated items containing this field
Datatype:stringPresent:100%
% of values with datatype=string
Minimum string length:7
Maximum string length:7
Possible values:
  • Concept
 
Fieldname:category
Path:data/superEvent/category
Present:100.00%(1,303 items)
% of updated items containing this field
Datatype:arrayPresent:100%
% of values with datatype=array
Minimum number of elements:1
Maximum number of elements:1
 
Fieldname:[0](denotes one or more array elements)
Path:data/superEvent/category/[0]
Present:100.00%(1,303 items)
% of updated items containing this field
Datatype:stringPresent:100%
% of values with datatype=string
Minimum string length:8
Maximum string length:48
Possible values:
  • Covid-19
  • Exercise class
  • Volunteering / Employability / Coaching delivery
 
Fieldname:identifier
Path:data/superEvent/identifier
Present:100.00%(1,303 items)
% of updated items containing this field
Datatype:integerPresent:100%
% of values with datatype=integer
Minimum integer value:153636
Maximum integer value:166634
Number of unique values:>10
Example:154066
 
Fieldname:name
Path:data/superEvent/name
Present:100.00%(1,303 items)
% of updated items containing this field
Datatype:stringPresent:100%
% of values with datatype=string
Minimum string length:9
Maximum string length:42
Number of unique values:>10
Example:Ballet Monday
 
Fieldname:organizer
Path:data/superEvent/organizer
Present:100.00%(1,303 items)
% of updated items containing this field
Datatype:objectPresent:100%
% of values with datatype=object
Minimum number of elements:2
Maximum number of elements:2
 
Fieldname:name
Path:data/superEvent/organizer/name
Present:100.00%(1,303 items)
% of updated items containing this field
Datatype:stringPresent:100%
% of values with datatype=string
Minimum string length:8
Maximum string length:39
Possible values:
  • Active Cambria
  • Nottingham City Council - This Girl Can
  • Open Age
 
Fieldname:type
Path:data/superEvent/organizer/type
Present:100.00%(1,303 items)
% of updated items containing this field
Datatype:stringPresent:100%
% of values with datatype=string
Minimum string length:12
Maximum string length:12
Possible values:
  • Organization
 
Fieldname:type
Path:data/superEvent/type
Present:100.00%(1,303 items)
% of updated items containing this field
Datatype:stringPresent:100%
% of values with datatype=string
Minimum string length:11
Maximum string length:11
Possible values:
  • EventSeries
 
Fieldname:type
Path:data/type
Present:100.00%(1,303 items)
% of updated items containing this field
Datatype:stringPresent:100%
% of values with datatype=string
Minimum string length:5
Maximum string length:5
Possible values:
  • Event
 
Fieldname:url
Path:data/url
Present:100.00%(1,303 items)
% of updated items containing this field
Datatype:URLPresent:100%
% of values with datatype=URL
Minimum URL length:69
Maximum URL length:70
Number of unique values:>10
Example:https://app.upshot.org.uk/calendar/sessions/c00d87c5/#calendar/2020-8
 
Fieldname:id
Path:id
Present:100.00%(1,303 items)
% of items containing this field
Datatype:stringPresent:100%
% of values with datatype=string
Minimum string length:16
Maximum string length:16
Number of unique values:>10
Example:f548da46d3baf85f
 
Fieldname:kind
Path:kind
Present:100.00%(1,303 items)
% of items containing this field
Datatype:stringPresent:100%
% of values with datatype=string
Minimum string length:7
Maximum string length:7
Possible values:
  • session
 
Fieldname:modified
Path:modified
Present:100.00%(1,303 items)
% of items containing this field
Datatype:integerPresent:100%
% of values with datatype=integer
Minimum integer value:1595579843700030
Maximum integer value:1618838715391649
Number of unique values:>10
Example:1602172158535061
 
Fieldname:state
Path:state
Present:100.00%(1,303 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/superEvent/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
Junior Athletics54
Fit Steps Thursday38
Pilates Friday37
Soca Wednesday36
Boxing Fitness Thursday36
Chi Gong Friday36
Yoga Monday36
Bolder not Older36
Pilates Tuesday35
Ballet Monday35
Step up from Steady Friday35
Chair Exercise - Monday35
Keep Fit Tuesday34
Pilates - Wednesday34
Chair Exercise Thursday34
Yoga Tuesday34
Stretch & Tone Friday34
Kundalini Yoga Tuesday33
Chi Gong Wednesday33
Yoga Wednesday33
Osteo Blast Monday 2:30pm32
Osteo Blast Thursday 11am32
Pilates Monday31
Steady & Stable Monday 10:30am31
Zumba Tuesday30
Steady & Stable (Telephone) Tuesday 2:00pm30
Steady & Stable Tuesday 10:30am30
Steady & Stable Wednesday 2:30pm30
Chair Exercise - Phone (Thurs)28
Exercise to Music Wednesday28
Steady & Stable Thursday 2:30pm25
Chair Exercise - Wednesday25
Latin Dance Monday23
Pilates - Thursday22
Steady & Stable Friday 2:30pm19
Steady & Stable Monday 2:30pm19
Tai Chi on Zoom18
Yoga on Zoom (Thurs)18
Stretch and Tone Tuesday14
Osteo Pro12
Zumba Friday12
Osteo Blast Fridays 11am11
Westminster Exercise to Music7
Brent Falls (Group 3)6
Selena PT6
H&F Keep Fit6
Brent Falls (Group 2)6
H&F Awareness through Movement6
Westminster outdoor Keep Fit Trials5
Indian Dance4
Outdoor Walks4
Soccercise4
Outdoors Keep Fit (SW)3
H+F Outdoor Keep Fit Trials3
Open Health talks Friday2
Seated SOSA2
Cricket and Bowls Monday1
Total

1,303

Tools