{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["ALL FIELD DESCRIPTIONS"],"read":"whole","date_system":"1900"}

{"sheet":"ALL FIELD DESCRIPTIONS","index":0,"n_rows":106,"n_cols":2,"rows_kept":106}
["Field","New Description"]
["ais_timestamp","Date and time of last AIS transmission from vessel"]
["anchorage_load_pre_start","Date and time of arrival at anchorage prior to loading"]
["anchorage_load_pre_end","Date and time of departure from anchorage prior to loading"]
["anchorage_offtake_pre_start","Date and time of arrival at anchorage prior to discharge"]
["anchorage_offtake_pre_end","Date and time of departure from anchorage prior to discharge"]
["api","Gravity in degrees API"]
["area","Grade production area"]
["bbls","Bbls_nominal * Probability"]
["bbls_nominal","Total volume on board"]
["bill","Bill of lading number or code"]
["bill_date","Bill of lading date"]
["bill_description","Raw, unparsed description of grade on bill of lading"]
["bill_port","Declared port on bill of lading"]
["bill_week","Week of the bill of lading date"]
["bill_weight_declared","Weight declared on bill of lading"]
["bill_weight_unit","Unit of weight declared on bill of lading"]
["charterer","Company reported to have chartered the vessel"]
["condensate","Flag to differentiate condensate from crude oil based on gravity"]
["consignee","Company reported as consignee or receiver on bill of lading"]
["course","Current course of vessel in degrees (0-360)"]
["csv_update_time","Date and time the file was published"]
["date","Bill of lading date"]
["declared_dest","Destination declared by the vessel in its AIS transmission"]
["density","Total weight of the grade in metric tons divided by the volume in cubic meters"]
["description","Raw, unparsed description of grade on bill of lading"]
["discharge_city_declared","City declared on bill of lading as port where vessel will discharge"]
["discharge_country_declared","Country declared on bill of lading as port where vessel will discharge"]
["distance_traveled","Distance in nautical mile between load and discharge or between load and current location for vessels in transit"]
["dom_exp","Flag to differentiate intra-Country moves from exports"]
["draught","Draught reported by the vessel in its AIS transmission"]
["early_bill","Flag to highlight bills with a bill date earlier than offtake date"]
["grade","Grade carried on board"]
["grade_api","Gravity in degrees API"]
["grade_country","Grade production country"]
["grade_region","Grade production region"]
["grade_subtype","Grade subtype"]
["grade_sulfur","Sulfur content in wt%"]
["grade_type","Grade type"]
["imo","IMO"]
["lat","Position reported in degrees latitude by the vessel in its AIS tansmission"]
["lightering_vessel","Vessel into which volume is transferred"]
["load_area","Abbreviation of load area, using shipping area conventions"]
["load_area_descr","Long name of load area, using shipping area conventions"]
["load_city_declared","City declared on bill of lading as port where vessel loaded"]
["load_country","Country where cargo loaded"]
["load_date","Date laden vessel left dock"]
["load_datetime","Date and time laden vessel left dock"]
["load_end_time","Date and time laden vessel left dock"]
["load_owner","Parent of company owning dock"]
["load_padd","PADD of port"]
["load_point","Terminal where vessel loaded"]
["load_port","Port where vessel loaded"]
["load_port_bill","Port declared on bill of lading as port where vessel loaded"]
["load_region","Region where vessel loaded using petroleum market convention"]
["load_start_time","Date and time ballast vessel arrived at dock"]
["load_state","US State where vessel loaded"]
["load_sts_imo","IMO of vessel that transfers its cargo to larger ship"]
["load_sts_vessel","Name of vessel that transfers its cargo to larger ship"]
["lon","Position reported in degrees Longitude by the vessel in its AIS tansmission"]
["m3","Volume on board in cubic meters * probability"]
["m3_nominal","Total volume on board in cubic meters"]
["mt","Weight of cargo on board * probability in metric tons"]
["mt_nominal","Total weight of cargo on board in metric tons"]
["notification","Company to be notified when cargo discharged declared on bill of lading"]
["offtake_area","Abbreviation of discharge area, using shipping area conventions"]
["offtake_area_descr","Long name of discharge area, using shipping area conventions"]
["offtake_country","Country where cargo discharged or expected to discharge"]
["offtake_date","Date when vessel discharged"]
["offtake_datetime","Date and time laden vessel arrived at dock"]
["offtake_end_time","Date and time ballast vessel left dock"]
["offtake_owner","Parent of company owning dock"]
["offtake_padd","PADD of port"]
["offtake_point","Terminal where vessel discharged"]
["offtake_port","Port where vessel discharged"]
["offtake_port_bill","Port declared on bill of lading as port where vessel discharged"]
["offtake_region","Region where vessel discharged using petroleum market convention"]
["offtake_start_time","Date and time laden vessel arrived at dock"]
["offtake_state","US State where vessel discharged"]
["offtake_sts_imo","IMO of larger vessel to which cargo is transferred"]
["offtake_sts_vessel","Name of larger vessel to which cargo is transferred"]
["opec_nopec","Flag for Opec membership of producer of grade"]
["probability","Probability of vessel going to particular area combined with probability of projected grade"]
["probability_group","Classification of probabilities (0-25, 26-50, 51-75, 76-100)"]
["projection","Flag to differentiate completed voyages from vessels in transit"]
["record_id","Unique id for row"]
["route","Route ship took on journey"]
["shipper","Company reported as shipper or supplier on bill of lading"]
["source","Source for the cargo information"]
["speed","Speed reported by vessel in its AIS transmission"]
["storage","Flag to designate vessels currently idle in a storage zone"]
["storage_zone","Areas where vessels anchor or drift when being used for floating storage"]
["sub_area","Sub area where grade is produced"]
["sulfur","Sulfur content in wt%"]
["ton_miles","mt_nominal*distance_traveled"]
["update_time","Date the data record was last updated"]
["update_time_arr","Date the data file was generated"]
["update_type","Indicator to determine if new record or changed record"]
["vessel","Name of vessel"]
["vessel_class","Class of vessel"]
["vessel_dwt","DWT of Vessel (deadweight tonnage)"]
["vessel_flag","Flag of vessel"]
["vessel_utilization","Percentage of vessel volume used"]
["voyage_in_progress","Flag for vessels in transit"]
["weight_kg","Weight declared on bill of lading in kg"]
["weight_mt","Weight declared on bill of lading in mt"]