Today we have launched our data download and API feature, which can be activated within the app after updating to version 1.1.
This post describes the content of the available raw data formats.
Each row of the Excel and CSV files, and each object of the JSON array, represents one response. They are listed in descending start time order, so the first row or Object corresponds to the most recent response.
The Excel and CSV column headings, and JSON object keys, are as follows:
start_time_epoch
start_time
The time this response began (this is the iPhone’s belief about UK local time). The first variable is the number of seconds since 1 January 1970; the second is a string of the form “2011-03-13 12:11:26 +0000” (for CSV) or “2011/03/13 12:11:26 +0000” (for JSON).
noise_50pc
noise_90pc
Respectively the median of several readings of what the iPhone reports as the ‘average’ noise level, and the 90th percentile of what it reports as the maximum level. These are supposed to be decibel values, and are either negative or zero.
happy
relaxed
awake
The three Feelings slider responses reported as decimal values scaled from 0 (not at all) to 1 (extremely).
in_out
home_work
Responses to the Place questions, each taking one of three possible string values. Respectively these are "in" / "out" / "vehicle" and "home" / "work" / "other".
Like subsequent response variables, these could be missing (null in JSON, or empty Excel or CSV cells) if the response was interrupted.
photo_url
photo_landscape
If a photo was taken then the first is a link to the photo, and the second is an indicator of the photo orientation: 0 for portrait, 1 for landscape. If no photo was taken, both are missing.
time_taken
How long it took from beginning to finishing the response, in seconds.
beep_time_epoch
beep_time
beep_sound
The server’s idea of UK time when the beep was sent (respectively as seconds since 1970 and as a string), and the name of the beep sound sent. If the response was volunteered with no beep having been sent, all three values will be missing.
beep_sound will otherwise take one of the following string values:
Beeps
Bird
Bugle
Chimes
Ding (quieter)
Ding
Doorbell
Referee
Whistle
map_url
If location data is available, a link to a map displaying the data from this response at the appropriate location. Otherwise missing.
latitude
longitude
accuracy_m
altitude
alt_accuracy_m
GPS location parameters. Missing values or values of -1 indicate some form of error.
with_partner
with_children
with_relatives
with_peers
with_clients
with_friends
with_others
0/1 indicators corresponding to the answers to the People responses. If all are 0, either the user tapped ‘Alone or with strangers only’ or the response was interrupted. Otherwise this JSON mapping may be helpful:
{"with_partner":"Spouse, partner, girl/boyfriend",
"with_children":"Children",
"with_relatives":"Other family members",
"with_peers":"Colleagues, classmates",
"with_clients":"Clients, customers",
"with_friends":"Friends",
"with_others":"Other people you know"}
do_work
do_meeting
do_travel
do_cook
do_chores
do_admin
do_shop
do_wait
do_childcare
do_pet
do_care
do_rest
do_sick
do_pray
do_wash
do_love
do_chat
do_eat
do_caffeine
do_alcohol
do_smoke
do_msg
do_net
do_tv
do_music
do_speech
do_read
do_theatre
do_museum
do_match
do_walk
do_sport
do_gardening
do_birdwatch
do_hunt
do_compgame
do_games
do_bet
do_art
do_sing
do_other
do_other2
0/1 indicators corresponding to the Activities responses. If all are zero, the response was interrupted.
do_other is a ‘Something else’ response submitted by app versions before 1.0.2, while do_other2 is a ‘Something else’ response submitted from version 1.0.2 onwards.
The reason for the distinction is that five new activities were introduced in 1.0.2, and ‘Something else’ thus covers a slightly narrower range of something elses. The new activities were do_love, do_caffeine, do_msg, do_net and do_birdwatch.
The following JSON mapping may be helpful:
{"do_work":"Working, studying",
"do_meet":"In a meeting, seminar, class",
"do_travel":"Travelling, commuting",
"do_cook":"Cooking, preparing food",
"do_chores":"Housework, chores, DIY",
"do_admin":"Admin, finances, organising",
"do_shop":"Shopping, errands",
"do_wait":"Waiting, queueing",
"do_child":"Childcare, playing with children",
"do_pet":"Pet care, playing with pets",
"do_care":"Care or help for adults",
"do_rest":"Sleeping, resting, relaxing",
"do_sick":"Sick in bed",
"do_pray":"Meditating, religious activities",
"do_wash":"Washing, dressing, grooming",
"do_love":"Intimacy, making love",
"do_chat":"Talking, chatting, socialising",
"do_eat":"Eating, snacking",
"do_caffeine":"Drinking tea/coffee",
"do_booze":"Drinking alcohol",
"do_smoke":"Smoking",
"do_msg":"Texting, email, social media",
"do_net":"Browsing the Internet",
"do_tv":"Watching TV, film",
"do_music":"Listening to music",
"do_speech":"Listening to speech/podcast",
"do_read":"Reading",
"do_theatre":"Theatre, dance, concert",
"do_museum":"Exhibition, museum, library",
"do_match":"Match, sporting event",
"do_walk":"Walking, hiking",
"do_sport":"Sports, running, exercise",
"do_gardening":"Gardening, allotment",
"do_birdwatch":"Birdwatching, nature watching",
"do_hunt":"Hunting, fishing",
"do_compgame":"Computer games, iPhone games",
"do_game":"Other games, puzzles",
"do_bet":"Gambling, betting",
"do_art":"Hobbies, arts, crafts",
"do_sing":"Singing, performing",
"do_other":"Something else",
"do_other2":"Something else"}
notes
App version 1.1 provides for the entry of free text notes with responses. This variable is a string containing those notes (it is missing for responses from previous app versions, and it may be missing or an empty string if no notes were added).
Feedback
Please don’t hesitate to get in touch with queries or comments, using our contact details on the main website.