Sample Raw ROO Data

Sample Raw Trade Agreements Data from the Downloaded Files

fta_id||roo_id||shortname||fta_name||FTA_TYPE||Effective_Date||Expiration_Date
fta_id||shortname||fta_name||FTA_TYPE||Effective_Date||Expiration_Date
EU-GB||EU-GB||FTA between EU and GB.||PREFERENTIAL||1/21/2021 12:00:00 AM||
EU-SG||EU-SG||FTA between EU and Singapore||PREFERENTIAL||||
KR-EU||KR-EU||FTA between EU and South Korea||PREFERENTIAL||||
GB-TR||GB-TR||FTA between GB and TR (Replaces interim agreement that followed revised PEM)||PREFERENTIAL||4/14/2021 12:00:00 AM||
GB-MX||GB-MX||FTA between Great Britain and Mexico||PREFERENTIAL||||
USMCA||USMCA||FTA between US, CA, and MX||PREFERENTIAL||7/1/2020 12:00:00 AM||

Sample Raw ROO Trade Agreement Partners Data from the Downloaded Files

Roo_Id||FTA_Id||Partner_Name||Iso_Country_Cd
EU-GB||EU-GB||EUROPEAN UNION||AT
EU-GB||EU-GB||EUROPEAN UNION||BE
EU-GB||EU-GB||EUROPEAN UNION||BG
EU-GB||EU-GB||GREAT BRITAIN||GG
EU-GB||EU-GB||GREAT BRITAIN||IM
 EU-GB||EU-GB||GREAT BRITAIN||JE

Sample Raw ROO Header Data from the Downloaded Files

ROO_id||FTA_ID||shortname||name||Rule_Type||Version_Number||Version_Release_Date||End_Dt||Partner_Name
EU-GB||EU-GB||EU-GB||Preference Rules for EU-GB||PREFERENTIAL RULES||00005||6/2/2021 12:00:00 AM||||EUROPEAN UNION

Sample Raw ROO PSRules Data from the Downloaded Files

Roo_Id||Hs_Start||Hs_end||suffix||Ex||Attribute||Rule_Expression
EU-GB||0101||0106||||||||{Cond:[9441]}
EU-GB||0201||0210||||||||({Cond:[10797]} OR ({Excl:01} AND {Excl:02})) OR ({Cond:[11962]})
EU-GB||0301||0308||||||||{Cond:[11950]}
EU-GB||0401||0410||||||||({Cond:[11284]} AND {Cond:[11803]}) OR ({Cond:[11962]})
EU-GB||0501||0511||||||||({Incl_100EQ:01-99}) OR ({Cond:[11962]})

Sample Raw ROO PSRule Codes Data from the Downloaded Files

Roo_Id||Rule||Rule_Type||HS_Start||HS_End||Percentage||Operator||Basis
EU-GB||DMN_10LE||DEMIN||||||10||<=||
EU-GB||SOG_15LE||SETSOFGOODS||||||15||<=||
EU-GB||MOP_00EQ||MINOPS||||||0||=||
EU-GB||Cond:[10797]||CONDITION||||||||||
EU-GB||Cond:[11093]||CONDITION||||||||||
EU-GB||Cond:[11131]||CONDITION||||||||||

Sample Raw ROO PSRule Code Descriptions Data from the Downloaded Files

Roo_Id||Rule||language||Text
EU-GB||DMN_10LE||EN||
EU-GB||SOG_15LE||EN||
EU-GB||MOP_00EQ||EN||
EU-GB||Cond:[10797]||EN||Production in which all the materials of Chapters 1 and 2 used are wholly obtained
EU-GB||Cond:[11093]||EN||Production in which biodiesel is obtained through transesterification, esterification or hydro-treatment
EU-GB||Cond:[11131]||EN||Each item in the set shall satisfy the rule which would apply to it if it were not included in the set
EU-GB||Cond:[11165]||EN||Weaving (Section note: For definitions of terms used for tolerances applicable to certain products made of textile materials, see Notes 67 and 8 of Annex ORIG-1)

Sample Raw ROO Base Rules Data from the Downloaded Files

roo_id||BASE_RULE_TYPE_ID||BASE_RULE_TYPE_NAME||BASE_RULE_CODE
EU-GB||4||DEMIN||{DMN_10LE}
EU-GB||3||SETS||{SOG_15LE}
EU-GB||2||MINOPS||{MOP_00EQ}