####################### Meta Data Part ############################# Column Name Data Type Description Validation Text Unit 1 EXPEDITION Numeric expedition number integer value # 2 SITE Numeric site number integer value # 3 HOLE Text code for hole text string of max. 1 character (A_Z) # 4 REPORT_DATE Date date of report date in UTC dd-mmm-yyyy 5 ACTIVITY_ID Integer number of activity for drilling report integer value >=1 # 6 TIME_FROM Text time from time value HH:mm 7 TIME_TO Text time to time value HH:mm 8 TIME_HOURS Double hours real value >0.0 h 9 STARTING_DEPTH Double starting depth of activity real value m 10 ENDING_DEPTH Double ending depth of activity real value m 11 CORE_NUMBER Integer core run number integer value >=1 # 12 DRILLED_LENGTH Double drilled length during activity real value >=0.0 m 13 CORE_RECOVERY Double core recovery during activity real value >=0.0 m 14 CORE_RECOVERY_PC Double core recovery during activity in percentage real value >=0.0 % 15 REMARKS Text remarks text string of max. 255 characters # 16 TOTAL_HOURS Double total duration of all activities in hours real value >0.0 h ####################### Data Part ############################# EXPEDITION SITE HOLE REPORT_DATE REPORT_NUMBER ACTIVITY_ID TIME_FROM TIME_TO TIME_HOURS STARTING_DEPTH ENDING_DEPTH CORE_NUMBER DRILLED_LENGTH CORE_RECOVERY CORE_RECOVERY_PC ROCK_TYPE REMARKS TOTAL_HOURS 5052 1 A 1/22/2011 1 1 10:40 10:45 0.08 30.5 30.7 1 0.2 0.2 100 coring, run 1 0.08 5052 1 A 1/22/2011 1 2 11:22 11:27 0.08 30.7 31 2 0.3 0.3 99.9 coring, run 2 0.16 5052 1 A 1/22/2011 1 3 11:47 11:56 0.15 31 31.4 3 0.4 0.4 100 coring, run 3 0.31 5052 1 A 1/22/2011 1 4 12:13 12:16 0.05 31.4 31.6 4 0.2 0.2 99.9 coring, run 4 0.36 5052 1 A 1/22/2011 1 5 12:28 12:34 0.1 31.6 32.1 5 0.5 0.5 100 coring, run 5 0.46 5052 1 A 1/22/2011 1 6 12:45 12:56 0.18 32.1 32.9 6 0.8 0.8 100 coring, run 6 0.64 5052 1 A 1/22/2011 1 7 01:43 01:56 0.22 32.9 33.4 7 0.5 0.5 100 coring, run 7 0.86 5052 1 A 1/22/2011 1 8 02:28 02:37 0.15 33.4 33.6 8 0.2 0.2 99.9 coring, run 8 1.01 5052 1 A 1/22/2011 1 9 02:52 02:58 0.1 33.6 34.3 9 0.7 0.7 100 coring, run 9 1.11 5052 1 A 1/22/2011 1 10 03:08 03:22 0.23 34.3 35.3 10 1 1 100 coring, run 10 1.34 5052 1 A 1/22/2011 1 11 03:35 03:47 0.2 35.3 36.4 11 1.1 1.1 99.9 coring, run 11 1.54 5052 1 A 1/22/2011 1 12 03:59 04:12 0.22 36.4 37.5 12 1.1 1.1 99.9 coring, run 12 1.76 5052 1 A 1/22/2011 1 13 04:30 04:39 0.15 37.5 38.7 13 1.2 1.2 99.9 coring, run 13 1.91 5052 1 A 1/22/2011 1 14 04:51 05:02 0.18 38.7 40.15 14 1.45 1.45 100 coring, run 14 2.09 5052 1 A 1/22/2011 1 15 05:18 05:23 0.08 40.15 40.5 15 0.35 0.35 99.9 coring, run 15 2.17 5052 1 A 1/22/2011 1 16 05:36 05:43 0.12 40.5 41.4 16 0.9 0.9 100 coring, run 16 2.29 5052 1 A 1/22/2011 1 17 06:11 06:24 0.22 41.4 43 17 1.6 1.6 99.9 coring, run 17 2.51 5052 1 A 1/22/2011 2 1 19:03 19:10 0.12 43 44.1 18 1.1 1.1 99.9 coring, run 18 0.12 5052 1 A 1/22/2011 2 2 19:25 19:28 0.05 44.1 44.3 19 0.2 0.2 100 coring, run 19 0.17 5052 1 A 1/22/2011 2 3 19:41 19:50 0.15 44.3 45.3 20 1 1 100 coring, run 20 0.32 5052 1 A 1/22/2011 2 4 20:12 20:15 0.05 45.3 45.5 21 0.2 0.2 99.9 coring, run 21 0.37 5052 1 A 1/22/2011 2 5 20:31 20:34 0.05 45.5 45.6 22 0.1 0.1 99.9 coring, run 22 0.42 5052 1 A 1/22/2011 2 6 20:50 20:59 0.15 45.6 46.3 23 0.7 0.7 100 coring, run 23 0.57 5052 1 A 1/22/2011 2 7 21:42 22:00 0.3 46.3 47.5 24 1.2 1.2 99.9 coring, run 24 0.87 5052 1 A 1/22/2011 2 8 22:45 23:15 0.5 47.5 49 25 1.5 1.5 100 coring, run 25 1.37 5052 1 A 1/22/2011 2 9 23:35 23:42 0.12 49 49.5 26 0.5 0.5 100 coring, run 26 1.49 5052 1 A 1/22/2011 2 10 00:00 00:15 0.25 49.5 49.6 27 0.1 0.1 99.9 coring, run 27 1.74 5052 1 A 1/22/2011 2 11 00:33 00:40 0.12 49.6 50.2 28 0.6 0.6 99.9 coring, run 28 1.86 5052 1 A 1/22/2011 2 12 01:18 01:30 0.2 50.2 51.8 29 1.6 1.6 100 coring, run 29 2.06 5052 1 A 1/22/2011 2 13 01:50 02:00 0.17 51.8 52.5 30 0.7 0.7 99 coring, run 30 2.23 5052 1 A 1/22/2011 2 14 02:14 02:35 0.35 52.5 53.5 31 1 1 100 coring, run 31 2.58 5052 1 A 1/22/2011 2 15 03:06 03:15 0.15 53.5 54 32 0.5 0.5 100 coring, run 32 2.73 5052 1 A 1/22/2011 2 16 03:48 04:00 0.2 54 54.8 33 0.8 0.8 100 coring, run 33 2.93 5052 1 A 1/22/2011 2 17 04:30 04:45 0.25 54.8 55.5 34 0.7 0.7 99.9 coring, run 34 3.18 5052 1 A 1/22/2011 2 18 05:00 05:15 0.25 55.5 57 35 1.5 1.5 100 coring, run 35 3.43 5052 1 A 1/22/2011 2 19 05:30 05:40 0.17 57 57.5 36 0.5 0.5 100 coring, run 36 3.6 5052 1 A 1/22/2011 2 20 06:05 06:15 0.17 57.5 58.4 37 0.9 0.9 100 coring, run 37 3.77 5052 1 A 1/23/2011 1 1 07:03 07:11 0.13 58.4 59.3 38 0.9 0.9 100 coring, run 38 0.13 5052 1 A 1/23/2011 1 2 07:25 07:28 0.05 59.3 59.4 39 0.1 0.1 99.9 coring, run 39 0.18 5052 1 A 1/23/2011 1 3 07:40 07:48 0.13 59.4 60.2 40 0.8 0.8 99.9 coring, run 40 0.31 5052 1 A 1/23/2011 1 4 08:12 08:21 0.15 60.2 61.5 41 1.3 1.3 100 coring, run 41 0.46 5052 1 A 1/23/2011 1 5 08:33 08:38 0.08 61.5 62.3 42 0.8 0.8 100 coring, run 42 0.54 5052 1 A 1/23/2011 1 6 08:50 09:02 0.2 62.3 63.1 43 0.8 0.8 99 coring, run 43 0.74 5052 1 A 1/23/2011 1 7 09:22 09:29 0.12 63.1 63.8 44 0.7 0.7 100 coring, run 44 0.86 5052 1 A 1/23/2011 1 8 09:44 09:48 0.07 63.8 64.5 45 0.7 0.7 99.9 coring, run 45 0.93 5052 1 A 1/23/2011 1 9 10:02 10:08 0.1 64.5 65.2 46 0.7 0.7 99.9 coring, run 46 1.03 5052 1 A 1/23/2011 1 10 10:23 10:32 0.15 65.2 66.7 47 1.5 1.5 100 coring, run 47 1.18 5052 1 A 1/23/2011 1 11 10:47 10:53 0.1 66.7 67.5 48 0.8 0.8 100 coring, run 48 1.28 5052 1 A 1/23/2011 1 12 11:17 11:28 0.18 67.5 68.8 49 1.3 1.3 100 coring, run 49 1.46 5052 1 A 1/23/2011 1 13 11:38 11:49 0.18 68.8 70.4 50 1.6 1.6 99.9 coring, run 50 1.64 5052 1 A 1/23/2011 1 14 12:00 12:13 0.22 70.4 71.6 51 1.2 1.2 100 coring, run 51 1.86 5052 1 A 1/23/2011 1 15 12:23 12:28 0.08 71.6 72.4 52 0.8 0.8 99.9 coring, run 52 1.94 5052 1 A 1/23/2011 1 16 12:44 12:50 0.1 72.4 73.5 53 1.1 1.1 100 coring, run 53 2.04 5052 1 A 1/23/2011 1 17 13:02 13:12 0.17 73.5 75 54 1.5 1.5 100 coring, run 54 2.21 5052 1 A 1/23/2011 1 18 13:22 13:34 0.2 75 76.5 55 1.5 1.5 100 coring, run 55 2.41 5052 1 A 1/23/2011 1 19 13:49 13:53 0.07 76.5 76.7 56 0.2 0.2 99.9 coring, run 56 2.48 5052 1 A 1/23/2011 1 20 14:12 14:24 0.2 76.7 78 57 1.3 13 1000 coring, run 57 2.68 5052 1 A 1/23/2011 1 21 14:35 14:48 0.22 78 79.4 58 1.4 1.4 99.9 coring, run 58 2.9 5052 1 A 1/23/2011 1 22 14:56 15:07 0.18 79.4 80.5 59 1.1 1.1 10 coring, run 59 3.08 5052 1 A 1/23/2011 1 23 15:19 15:31 0.2 80.5 82.1 60 1.6 1.6 100 coring, run 60 3.28 5052 1 A 1/23/2011 1 24 15:42 15:57 0.25 82.1 83.7 61 1.6 1.6 99 coring, run 61 3.53 5052 1 A 1/23/2011 1 25 16:07 16:18 0.18 83.7 85.2 62 1.5 1.5 100 coring, run 62 3.71 5052 1 A 1/23/2011 1 26 16:32 16:47 0.25 85.2 86.8 63 1.6 1.6 100 coring, run 63 3.96