1. Regulatory Content System Guide
  2. Sample Raw HSN Master Data

Sample Raw HSN Master Data

Sample Raw HSN Master Data from the Downloaded Files

mstr_id||hscode||language_id||country_id||full_desc||part_id||iso_language||iso_country||data_type||uom1||uom2||sitc||enduse_cd||asusda_flag||naics||hitech||eff_beg_dt||eff_end_dt||uom3||oga1||oga2||oga3||oga4||add_flag||cvd_flag||quota_ind||short_desc||AES_Export_Allowed||LACEY||notes||section_number||chapter||OUom1||OUom2||OUom3||OUom4||OUom5
MX_HS_01_00||I||128||141||Live Animals; Animal Products||MX_HS_01_00||EN||MX||HS||||||||||||||||||||||||||||||||||||||||||There are no notes for this section.||I||||||||||||
MX_HS_01_01||01||128||141||Live animals||MX_HS_01_01||EN||MX||HS||||||||||||||||||||||||||||||||||||||||||No information on this Chapter.||I||01||||||||||
MX_HS_01_0101||0101||128||141||Live animals: Live horses, asses, mules and hinnies.||MX_HS_01_0101||EN||MX||HS||||||||||||||||||||||||||||||||||||||||||||I||01||||||||||
MX_HS_01_01012||01012||128||141||Live animals: Live horses, asses, mules and hinnies.: Horses||MX_HS_01_01012||EN||MX||HS||||||||||||||||||||||||||||||||||||||||||||I||01||||||||||
MX_HS_01_010121||010121||128||141||Live animals: Live horses, asses, mules and hinnies.: Horses: Pure-bred breeding animals||MX_HS_01_010121||EN||MX||HS||||||||||||||||||||||||||||||||||||||||||||I||01||||||||||
MX_HS_01_0101210100||0101210100||128||141||Live animals: Live horses, asses, mules and hinnies.: Horses: Pure-bred breeding animals: Pure-bred breeding animals||MX_HS_01_0101210100||EN||MX||HS||Cbza||||||||||||||12/28/2020 12:00:00 AM||||||||||||||||||||||||||||I||01||||||||||
MX_HS_01_010129||010129||128||141||Live animals: Live horses, asses, mules and hinnies.: Horses: Other||MX_HS_01_010129||EN||MX||HS||||||||||||||||||||||||||||||||||||||||||||I||01||||||||||
MX_HS_01_0101290200||0101290200||128||141||Live animals: Live horses, asses, mules and hinnies.: Horses: Other: Without pedigree, for breeding.||MX_HS_01_0101290200||EN||MX||HS||Pza||||||||||||||12/28/2020 12:00:00 AM||||||||||||||||||||||||||||I||01||||||||||
MX_HS_01_0101290300||0101290300||128||141||Live animals: Live horses, asses, mules and hinnies.: Horses: Other: For supply, import made by Federal Inspection type of packers.||MX_HS_01_0101290300||EN||MX||HS||Pza||||||||||||||12/28/2020 12:00:00 AM||||||||||||||||||||||||||||I||01||||||||||
MX_HS_01_01012999||01012999||128||141||Live animals: Live horses, asses, mules and hinnies.: Horses: Other: Other||MX_HS_01_01012999||EN||MX||HS||||||||||||||||||||||||||||||||||||||||||||I||01||||||||||
MX_HS_01_0101299901||0101299901||128||141||Live animals: Live horses, asses, mules and hinnies.: Horses: Other: Other: For jumping or running.||MX_HS_01_0101299901||EN||MX||HS||Pza||||||||||||||12/28/2020 12:00:00 AM||||||||||||||||||||||||||||I||01||||||||||
MX_HS_01_0101299999||0101299999||128||141||Live animals: Live horses, asses, mules and hinnies.: Horses: Other: Other: Other||MX_HS_01_0101299999||EN||MX||HS||Pza||||||||||||||12/28/2020 12:00:00 AM||||||||||||||||||||||||||||I||01||||||||||
MX_HS_01_010130||010130||128||141||Live animals: Live horses, asses, mules and hinnies.: Asses||MX_HS_01_010130||EN||MX||HS||||||||||||||||||||||||||||||||||||||||||||I||01||||||||||
Note: In this sample, columns which have no value have the delimiter '||'. However, you can also have ',' (comma) as a delimiter.
Note: You should remove all of the leading and trailing white spaces as well as newline and carriage return and tab characters from the notes and description columns.

Sample Raw HSN Attributes Data from the Downloaded Files

mstr_id||hscode||attribute||value||description
MX_HS_01_0306110100||0306110100||MX NOM||NOM-051-SCFI/SSA1-2010||Especificaciones generales de etiquetado para alimentos y bebidas no alcohólicas preenvasados-Información comercial y sanitaria.
MX_HS_01_0306120100||0306120100||MX NOM||NOM-051-SCFI/SSA1-2010||Especificaciones generales de etiquetado para alimentos y bebidas no alcohólicas preenvasados-Información comercial y sanitaria.
MX_HS_01_0306140100||0306140100||MX NOM||NOM-051-SCFI/SSA1-2010||Especificaciones generales de etiquetado para alimentos y bebidas no alcohólicas preenvasados-Información comercial y sanitaria.
MX_HS_01_0306150100||0306150100||MX NOM||NOM-051-SCFI/SSA1-2010||Especificaciones generales de etiquetado para alimentos y bebidas no alcohólicas preenvasados-Información comercial y sanitaria.
MX_HS_01_0306160100||0306160100||MX NOM||NOM-051-SCFI/SSA1-2010||Especificaciones generales de etiquetado para alimentos y bebidas no alcohólicas preenvasados-Información comercial y sanitaria.
MX_HS_01_0306170100||0306170100||MX NOM||NOM-051-SCFI/SSA1-2010||Especificaciones generales de etiquetado para alimentos y bebidas no alcohólicas preenvasados-Información comercial y sanitaria.
MX_HS_01_0306199900||0306199900||MX NOM||NOM-051-SCFI/SSA1-2010||Especificaciones generales de etiquetado para alimentos y bebidas no alcohólicas preenvasados-Información comercial y sanitaria.
MX_HS_01_0306310100||0306310100||MX NOM||NOM-051-SCFI/SSA1-2010||Especificaciones generales de etiquetado para alimentos y bebidas no alcohólicas preenvasados-Información comercial y sanitaria.
MX_HS_01_0306320100||0306320100||MX NOM||NOM-051-SCFI/SSA1-2010||Especificaciones generales de etiquetado para alimentos y bebidas no alcohólicas preenvasados-Información comercial y sanitaria.

Sample Raw HSN UOMs Data from the Downloaded Files

mstr_id||Column1||name||oracle_unit_code||country_specific_UOM
NZ_HS_01_0101210010E||0101210010E||REPORTING UOM 1||NUM OR UN||NMB
NZ_HS_01_0101210015F||0101210015F||REPORTING UOM 1||NUM OR UN||NMB
NZ_HS_01_0101210017B||0101210017B||REPORTING UOM 1||NUM OR UN||NMB
NZ_HS_01_0101210019J||0101210019J||REPORTING UOM 1||NUM OR UN||NMB
NZ_HS_01_0101210023G||0101210023G||REPORTING UOM 1||NUM OR UN||NMB
NZ_HS_01_0101210027K||0101210027K||REPORTING UOM 1||NUM OR UN||NMB

Sample Raw HSN Parts Data from the Downloaded Files

part_id||language_id||country_id||part_desc||part_hscode||parent_id||old_parent_id||iso_language||iso_country||section||rn
MX_HS_01_00||128||141||Live Animals; Animal Products||I||0||0||EN||MX||01||0
MX_HS_01_01||128||141||Live animals||01||MX_HS_01_00||0||EN||MX||01||1
MX_HS_01_0101||128||141||Live horses, asses, mules and hinnies.||0101||MX_HS_01_01||306155818||EN||MX||01||2
MX_HS_01_01012||128||141||Horses:||01012||MX_HS_01_0101||306155819||EN||MX||01||3
MX_HS_01_010121||128||141||Pure-bred breeding animals||010121||MX_HS_01_01012||306155820||EN||MX||01||4
MX_HS_01_0101210100||128||141||Pure-bred breeding animals||0101210100||MX_HS_01_010121||306155821||EN||MX||01||5
MX_HS_01_010129||128||141||Other||010129||MX_HS_01_01012||306155820||EN||MX||01||6
MX_HS_01_0101290200||128||141||Without pedigree, for breeding.||0101290200||MX_HS_01_010129||306155823||EN||MX||01||7
MX_HS_01_0101290300||128||141||For supply, import made by Federal Inspection type of packers.||0101290300||MX_HS_01_010129||306155823||EN||MX||01||8
MX_HS_01_01012999||128||141||Other||01012999||MX_HS_01_010129||306155823||EN||MX||01||9

Sample Raw HSN Trade Program Types Data from the Downloaded Files

COUNTRY_CODE2||TRADE_PROGRAM_TYPE||TRADE_PROGRAM_TYPE_DESCRIPTION
MX||GEN||GENERAL
MX||MFN||MOST FAVORED NATION
MX||SPI||SPECIAL PROGRAM INDICATOR ( IE: FTAS )
MX||QSP||SPECIAL PROGRAMS UNDER QUOTA
MX||NQO||NORMAL RATE UNDER QUOTA (IE GENERAL QUOTA)
MX||PEN||PENALTY RATE
MX||CTL||IMPORT CONTROL
MX||CVD||COUNTERVAILING DUTY
MX||ADD||ANTI DUMPING DUTY
MX||PRO||PROHIBITED GOODS

Sample Raw HSN Trade Programs Data from the Downloaded Files

COUNTRY_CODE2||TRADE_PROGRAM_ID||SHORT_NAME||NAME||FTA_ID||IS_INCLUDED||TRADE_PROGRAM_TYPE_ID||IS_DEFAULT_TRADE_PROGRAM||TRADE_PREFERENCE
MX||3||CO||COLOMBIA RATE||||YES||SPI||||CO
MX||4||PAR4 - VE||LATIN AMERICAN INTEGRATION ASSOCIATION PREFERENTIAL REGIONAL RATE (AR.PAR4)||||YES||SPI||||
MX||5||CR||COSTA RICA RATE||MX-CR||YES||SPI||||CR
MX||6||BO||BOLIVIA RATE||MX-BO||YES||SPI||||BO
MX||7||CL||CHILE RATE||MX-CL||YES||SPI||||CL
MX||9||EU||EUROPEAN COMMUNITY RATE (EU)||EU-MX||YES||SPI||||EU
MX||10||IL||ISRAEL RATE||MX-IL||YES||SPI||||IL
MX||11||GENERAL||GENERAL RATE||||NO||GEN||1||
MX||12||PAR4 - AR||LATIN AMERICAN INTEGRATION ASSOCIATION PREFERENTIAL REGIONAL RATE (AR.PAR4)||MX-AR||YES||SPI||||

Sample Raw HSN Tariff Countries Data from the Downloaded Files

COUNTRY_CODE2||TRADE_PROGRAM_ID||ORIGIN_COUNTRY_CD
MX||12||AR
MX||55||ar
MX||68||AR
MX||85||AR
MX||9||AT
MX||105||AU
MX||9||BE
MX||9||bg
MX||64||BO

Sample Raw HSN Tariff Rates Data from the Downloaded Files

COUNTRY_CODE2||CLASSIFICATION_CODE||TRADE_PROGRAM_ID||ADDVALOREM_RATE||PER_UNIT_CHARGE||UNIT_CODE||CALCULATION_METHOD||NotesCode1||NotesCode2||formulaid
MX||0101210100||3||0.00000000||0.00000000||NA||10||||||
MX||0101210100||4||7.20000000||0.00000000||NA||10||||||
MX||0101210100||5||0.00000000||0.00000000||NA||10||||||
MX||0101210100||6||0.00000000||0.00000000||NA||10||||||
MX||0101210100||7||0.00000000||0.00000000||NA||10||||||
MX||0101210100||9||0.00000000||0.00000000||NA||10||||||
MX||0101210100||11||10.00000000||0.00000000||NA||10||||||

Sample Raw HSN Trade Agreements Data from the Downloaded Files

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||