| decisionID |
User-decision identifier, intended to link between Response and Momentary_Decision. However some decisionIDs are associated with different decision points, due to a race condition. |
| userID |
User identifier; assigned gmail account |
| notified_time |
Date-time string (yyyy-MM-dd HH:mm:ss) for the suggestion notification time |
| responded_time |
Date-time string (yyyy-MM-dd HH:mm:ss) for the time at which the user either rated the message (thumbs up/down, snooze) or the notification timed out |
| timezone |
Responded time zone name, dependent on the phone's localization settings |
| UTC_to_local_delta |
Responded time offset in hours from GMT/UTC, taking into account daylight savings time |
| notification_message |
Suggestion message text converted to ASCII, with the conversion inconsistent from the returned_message in Momentary_Decision. To enable consistent linkage between the suggestion-related tables, we further strip all punctuation. |
| response |
Suggestion message rating ("no_response", "good", "bad", "snoozed_for_X_hours") |
| interaction_count |
Number of times the phone screen was turned on before the responded time |
| time_lag |
Time lag in seconds between the suggestion notification and either the user rating or the notification time out |
| recognized_activity |
Google Activity Recognition result; the Detected Activity type with the highest confidence level, evaluated within 90 seconds of the decision time slot |
| calendar |
Calendar busyness ("free" or "busy") up to 60 minutes from the responded time |
| gps_coordinate |
GPS coordinate (latitude_longitude) giving the location at the responded time |
| city |
City name corresponding to the GPS coordinate |
| location_exact |
Location description ("work", "home", or establishment name) based on the GPS coordinate |
| location_category |
Location category ("work", "home" or the Google Place Type) based on the GPS coordinate |
| distance |
Distance in meters from the location category |
| home |
GPS coordinate (latitude_longitude) the home address |
| work |
GPS coordinate (latitude_longitude) the work address |
| snow |
Snowfall in millimeters, based on the GPS coordinate |
| precipitation_chance |
Precipitation chance (between 0 and 100) up to 60 minutes |
| weather_condition |
Current weather condition classification from Weather Underground's API, based on the GPS coordinate |
| temperature |
Temperature in celsius, based on the GPS coordinate |
| windspeed |
Wind speed in miles per hour, based on the GPS coordinate |