Julian dates are similar to the Linux epoch format, simply starting from a different date. The Julian date system counts the number of days since noon on January 1st, 4713 BC. The United States Naval Observatory has an excellent Julian date calculator: http://aa.usno.navy.mil/data/docs/JulianDate.php. To obtain the Julian date from the database, simply combine the two columns with a decimal in between, for example:

This would correspond to the Julian date 2457042.46800000. When this value is input to the website, we find out the date the reminder is set for is January 19 2015 at 23:13:55.2 UT. The location_name, latitude, longitude, and location_address columns will be populated if a reminder is set as location-based. Finally, the time_created and time_last_updated columns are the time the note was created, and the time it was last synced with the Google servers, in Linux epoch time.