####################### Meta Data Part ############################# Column Name Data Type Description Label Validation Text Unit 1 EXPEDITION Numeric expedition number Expedition expedition number (Int. 1 - 99999), required key field <>0 # 2 SITE Numeric site identifier, max. number between 1 and 9999 Site site identifier (num 4), required key field <>0 # 3 HOLE text hole identifier, A-Z Hole hole identifier (max. 1 chars, A-Z), required key field LIKE ('[A-Z]') # 4 CORE Numeric core identifier Core please enter a number between 1 and 99999 between 1 and 99999 # 5 CORE_TYPE Text type of core, piston, gravity.... Core Type core type(max. 1 char), required field <>'' # 6 TOP_DEPTH Double top depth of core Top Depth top depth (float), required field >=0.0 >=0.0 m 7 DRILLED_LENGTH Double drilled length of the current core run Drilled Length (m) real value >=0.0 >=0.0 m 8 BOTTOM_DEPTH Double bottom depth of core Bottom Depth bottom depth (float), required field >=0.0 >=0.0 m 9 MCD_OFFSET Double offset of composite depth for core MCD Offset # # # 12 CORE_RECOVERY Double length of recovered core Core Recovery (m) real value >=0.0 # m 13 CORE_RECOVERY_PC Double percentage of core recovery Core Recovery (%) real value >=0.0 >=0.0 % 14 CORE_ONDECK Date date and time core comes on deck On Deck core on deck, (date UTC), required field <>0 <>0 # 15 ORIENTED Text is core oriented ? true or false Core Oriented ? oriented yes or no ? IN ( 'yes','no') or is Null # 16 LAST_SECTION Integer number of last section of core Section Count section count, required, between 0 and 99 BETWEEN 0 and 99 # 17 CORE_CATCHER Text core has catcher section ? CC core catcher (yes or no ), required field IN ( 'yes','no') # 18 ANALYST Text initials of data operator / Curator Curator, (fmax. 5 chars), required field <>'' # 19 REMARKS Text additional remarks, free text Remarks # # # 20 DIAMETER Integer core diameter in mm Core Diameter core diameter in mm, integer # # 21 IGSN Text IGSN IGSN text string of max. 15 characters # # ####################### Data Part ############################# EXPEDITION SITE HOLE CORE CORE_TYPE TOP_DEPTH DRILLED_LENGTH BOTTOM_DEPTH MCD_OFFSET MCD_TOP MCD_BOTTOM CORE_RECOVERY CORE_RECOVERY_PC CORE_ONDECK ORIENTED LAST_SECTION CORE_CATCHER ANALYST REMARKS DIAMETER IGSN 5029 4 B 1 Z 3,068.700 5.400 3,074.100 0 3,068.700 3,074.100 0 0 19-Sep-2016 12:30 no 0 yes GOF Coring started on 18th of September at 21:40 and ended on 19th of September at 05:00. No core retrieved. 100 ICDP5029ECRK101 5029 4 B 2 Z 3,177.600 1.400 3179 0 3,177.600 3179 0 0 05-Oct-2016 23:30 no 0 yes GOF Coring started on 4th of October at 20:00 and ended on 4th of October at 22:00. No core retrieved. 100 ICDP5029ECTK101 5029 4 B 3 Z 3648 0.900 3,648.900 0 3648 3,648.900 0.520 57.778 31-Oct-2016 10:30 no 1 yes RZ Coring started on 30th of October at 09:00 and ended on 30th of October at 14:00. Few loose rock fragments from 1cm to 7cm in diameter at the top of the core (depth uncertain). 100 ICDP5029ECUK101 5029 4 B 4 Z 3,648.900 1.800 3,650.700 0 3,648.900 3,650.700 0 0 03-Nov-2016 01:30 no 1 yes RZ 100 ICDP5029ECVK101 5029 4 B 5 Z 3,865.500 4.300 3,869.800 0 3,865.500 3,869.800 3.850 89.535 11-Nov-2016 22:00 no 1 yes RZ two teeth of the core bit was damaged. 100 ICDP5029ECWK101 5029 4 B 6 Z 3,869.800 0.400 3,870.200 0 3,869.800 3,870.200 0.150 37.500 13-Nov-2016 01:00 no 1 yes RZ Core bit was damaged. 100 ICDP5029ECXK101 5029 4 B 7 Z 4,089.500 1.100 4,090.600 0 4,089.500 4,090.600 0.120 10.909 23-Nov-2016 06:30 no 1 yes RZ coring started on 22 November at 3:30 and ended at 05:45. 12 cm of core and loose rock fragments on top of the core retrieved. 100 ICDP5029ECYK101 5029 4 B 8 Z 4,254.300 1 4,255.300 0 4,254.300 4,255.300 0.200 20 29-Nov-2016 10:00 no 1 yes RZ 100 ICDP5029ECZK101 5029 4 B 9 Z 4,308.700 1.200 4,309.900 0 4,308.700 4,309.900 0 0 06-Dec-2016 08:45 no 0 yes RZ 100 ICDP5029EC1L101 5029 4 B 10 Z 4,309.900 1.300 4,311.200 0 4,309.900 4,311.200 0.230 17.692 08-Dec-2016 12:00 no 1 no RZ 23cm of fractured core was recovered. 100 ICDP5029EC3L101 5029 4 B 11 Z 4,634.200 8.600 4,642.800 0 4,634.200 4,642.800 7.580 88.140 16-Jan-2017 18:30 no 5 yes GOF 67 ICDP5029EC6L101 5029 4 B 12 Z 4,642.800 9.200 4652 0 4,642.800 4652 9 97.826 18-Jan-2017 15:00 no 6 yes GOF 67 ICDP5029EC7L101 5029 4 B 13 Z 4652 7 4659 0 4652 4659 5.580 79.714 19-Jan-2017 20:00 no 4 yes GOF 67 ICDP5029EC8L101