| decisionID |
User-decision identifier, intended to link between Momentary_Decision and Response. However some decisionIDs are associated with different decision points, due to a race condition. Pre-fetched and non-pre-fretched decisions for the same decision point are assigned the same decisionID. Under this form of duplication, the pre-fetch data can be discarded. In a limited number of cases the pre-fetch data are used due to a race condition. |
| userID |
User identifier; assigned gmail account |
| time_stamp |
Date-time string (yyyy-MM-dd HH:mm:ss) for the time at which the decision result is sent to the phone |
| timezone |
Time stamp time zone name, dependent on the phone's localization settings |
| UTC_to_local_delta |
Time stamp offset in hours from GMT/UTC, taking into account daylight savings time |
| time_slot |
Decision time slot type ("morning", "lunch", "afternoon", "evening", "dinner") |
| day_of_week |
Day of week ("Mon"-"Sun" or "") of the decision time slot |
| is_prefetch |
Indicator ("true" or "false") that the decision result is based on prefetched contextual information, retrieved 30 minutes prior to the decision time slot |
| is_randomized |
Randomization status ("true" or "false") |
| notify |
Decision result ("True" or "False"), combining the randomization status and availability |
| returned_message |
Message text sent to the user, converted to ASCII. If the decision result is "false", the string "do_not_notify". To enable consistent linkage between the suggestion-related tables, we further strip all punctuation. |
| snooze_status |
Indicator ("true" or "false") that snooze is enabled at the decision time slot |
| front_end_application |
Android package name of the application that in use at the time stamp. If the screen was turned off, then "NA". |
| recognized_activity |
Google Activity Recognition result; the Detected Activity type with the highest confidence level, evaluated within 90 seconds of the decision time slot |
| valid |
Indicator ("true", "false") that the Google Activity Recognition result is valid |
| calendar |
Calendar busyness ("free" or "busy") up to 60 minutes from the decision time slot |
| gps_coordinate |
GPS coordinate (latitude_longitude) giving the location at the time stamp |
| 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 |
| 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 |
| precipitation_chance |
Precipitation chance (between 0 and 100) up to 60 minutes from the time stamp, based on the GPS coordinate |
| snow |
Snowfall in millimeters, based on the GPS coordinate |