{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Licences_dataset"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Licences_dataset","index":0,"n_rows":48,"n_cols":6,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
["Long_Name","Short_Name","Display_Name","Description","Date Changed","Description of change"]
["DATA_POINT_ID","DATAPID","Data Point ID","ID of the data point"]
["LOCATION","LOCATION","Offshore or Onshore","Field to filter between onshore and offshore licences"]
["ACTUAL_LICENCE_NO","LICNO","Actual Licence Number","The numerical portion of the licence number "]
["LICENCE_TYPE_PREFIX","LICPREFIX","Licence Type Code","The licence type code"]
["LICENCE_TYPE","LICTYPE","Licence Type","The full licence type description denoted by the licence type prefix "]
["LICENCE_NUMBER","LICREF","Licence No.","The full licence number including prefix","2021-05-03","Change to value - Where licence subtype was 'Subtype Unavailable' is now blank"]
["LICENCE_STATUS","LICSTATUS","Licence Status","The status of the licence"]
["LIST_OF_BLOCKS","BLOCKREF","Licence Blocks","A comma separated list of blocks covered under the licence"]
["LIST_OF_FIELDS","FIELDS","Licence Fields","A comma separated list of fields covered under the licence","2021-05-03","New Attribute"]
["LIST_OF_LICENSEES","LICORG","Licensees","A comma separated list of licensees of the licence"]
["LIST_OF_LICENSEE_GROUPS","LICORGGRP","Licensee Group Names","A comma separated list of the group names of the licensees of the licence"]
["LIST_OF_SUBAREA_OPERATORS","SUBOPORG","Licence Sub Area Operators","A comma separated list of subarea operators of the licence"]
["LIST_OF_SUBAREA_OPERATOR_GRPS","SUBOPGRPS","Licence Sub Area Operator Group Names","A comma separated list of the group names of the subarea operators of the licence"]
["LIST_OF_REGIONS","REGIONS","Licence Regions","A comma seperated list of regions that are covered by the licence","2021-05-03","New Attribute"]
["LICENCE_START_DATE","LICSTARTDT","Licence Start Date","The initial defined licence start date"]
["LICENCE_END_DATE","LICENDDT","Licence End Date","The actual date a licence ended"]
["LICENCE_EXPIRY_DATE","LICEXPDT","Licence Expiry Date","The anticipated end date of a licence, as defined within its licence schedule"]
["LICENCE_SCHEDULE_START_DATE","LICSCHSTTD","Licence Schedule Start Date","The start date of the licence schedule. The date on which licence anniversaries will fall (e.g. to be used in fee calculations).","2021-05-03","New Attribute"]
["SCHEDULED_EVENTS","SCHEVENTS","Scheduled events","Schedule of events for the licence"]
["AGREED_KM2","AGREED_KM2","Agreed km2","Area agreed in the licence document"]
["CALCULATED_KM2","CALC_KM2","Calculated (actual) km2","Area calculated from geometry"]
["PHASE_A_START_DATE","PH_A_START","Phase A Start Date","That date on which the licence enters Phase A of its schedule","2021-05-03","New Attribute"]
["PHASE_A_END_DATE","PH_A_END","Phase A End Date","That date on which the licence completes Phase A of its schedule (phase ends the midnight before this date)","2021-05-03","New Attribute"]
["PHASE_B_START_DATE","PH_B_START","Phase B Start Date","That date on which the licence enters Phase B of its schedule","2021-05-03","New Attribute"]
["PHASE_B_END_DATE","PH_B_END","Phase B End Date","That date on which the licence completes Phase B of its schedule  (phase ends the midnight before this date)","2021-05-03","New Attribute"]
["PHASE_C_START_DATE","PH_C_START","Phase C Start Date","That date on which the licence enters Phase C of its schedule","2021-05-03","New Attribute"]
["PHASE_C_END_DATE","PH_C_END","Phase C End Date","That date on which the licence completes Phase C of its schedule (phase ends the midnight before this date)","2021-05-03","New Attribute"]
["TERM_1_START_DATE","TM_1_START","Term 1 Start Date","That date on which the licence enters Term 1 of its schedule (term ends the midnight before this date)","2021-05-03","New Attribute"]
["TERM_1_END_DATE","TM_1_END","Term 1 End Date","That date on which the licence completes Term 1 of its schedule (term ends the midnight before this date)","2021-05-03","Changed Attribute Name - Previously called 'INITENDDT'"]
["TERM_2_START_DATE","TM_2_START","Term 2 Start Date","That date on which the licence enters Term 2 of its schedule","2021-05-03","New Attribute"]
["TERM_2_END_DATE","TM_2_END","Term 2 End Date","That date on which the licence completes Term 2 of its schedule (term ends the midnight before this date)","2021-05-03","Changed Attribute Name - Previously called 'SECENDDT'"]
["TERM_3_START_DATE","TM_3_START","Term 3 Start Date","That date on which the licence enters Term 3 of its schedule","2021-05-03","New Attribute"]
["TERM_3_END_DATE","TM_3_END","Term 3 End Date","That date on which the licence completes Term 3 of its schedule  (term ends the midnight before this date)","2021-05-03","New Attribute"]
["NO_INITIAL_TERM_EXTENSIONS","NO_EXTNS","No. of Initial Term Extensions","The number of times an extension has been applied to the initial term of the licences schedule","2021-05-03","New Attribute"]
["HAS_TERM_1","HASTM1","Has Initial Term","Does this licence have an initial term?","2021-05-03","New Attribute"]
["ROUND_TYPE","RNDTYPE","Round Type","The round type"]
["ROUND_NUMBER","RNDNO","Round Number","The round number","2021-05-03","Changed value - Value previously 0 is now blank"]
["ROUND_OOR_REFERENCE","RNDOORREF","Out Of Round Reference Code","The reference code for an out of round bidding process","2021-05-03","New Attribute"]
["ROUND_ANNOUNCE_DATE","RNDSTARTDT","Round Announced Date","The date the round was formally announced"]
["ROUND_CLOSING_DATE","RNDENDDT","Round Closing Date","The date the round was closed"]
["ADMIN_ORG_CURRENT_NAME","ADMORG","Admin Name","The current company name of the administrator"]
["ADMIN_ORG_HISTORICAL_NAME","ADMHISTNME","Admin Historical Name","The Company Name of the administrator at point-in-time in history","2021-05-03","New Attribute"]
["ADMIN_ORG_PREVIOUS_NAMES","ADMPRVNAMS","Admin Previous Names","A semi-colon-separated list of the administrator's previous company names.","2021-05-03","New Attribute"]
["ADMIN_ORG_NUMBER","ADMORGNO","Admin Registered No.","This is the administrator companies House no.","2021-05-03","New Attribute"]
["ADMIN_ORG_GROUP_NAME","ADMORGGRP","Admin Group Name","Group Name of the administrator company"]
["URL","URL","PDF Link","The PDF Link to the licence document"]
["PDF_DATE_ADDED","PDFDATEADD","PDF Added","The date the PDF was added"]