联合国商品贸易统计数据库使用方法Uncomtrade

1、选择Data Query > Basic Selection的步骤是这样的：第一步是选择Commodity:1 .首先要确保HS选项中，选才? As reported,这个意思是商品的HS编码按照数 据报告国的选择。比如有些国家用的是 07年的，有些是12年的，也许会有 不同。Step 1. Select ClassificationHS: ® As reported 092 096 Oc2 007 O 12 O BEC2 .在 stepl. Select Sources,选择 Commodities Search 在 Step2. Select Items中， 填4410 （

2、刨花板的HS码），然后点Search,你会得到下图。然后，点开 44 前面的加号，就可以看到4410编码。Enter Commodity CodesCommodities SearchvStep 2. Select ItemsSearch / Select then Add刈41。 inHS 白弓 reported Search一| DaH comnnoclitiesHere are the results: Indude the childrenTOTAL - ALL COMMODITIESs - 44 and artidas af cod w口ad 由（+1 4410 - Pmrti匚I巳

3、tmani similac hnagh Muadjligneous nndt巳/己-dd R-nriQ | Remc1vhe 丽ExcludeSave selections to favorites3.选中4410 （这个过程要稍微等一下，需要几秒，等加载完成），点Add,这 个商品就已经选择成功了。如下图：Selected Items里的就是选定的商品。Enter Commodity CodesStep 1. Select SourceSelected ItemsCommodities Searchy4410 - Partici.Step 2. Select ItemsSearch / Se

4、lect then Add然后可以按照这个步骤，再添加 4411和4412,如果想删除Selected Items里的 商品，只需要选中后，点 Remove,全删是Remove All就可以了。第二步是选择Reporter：这个您的操作是没问题的，只是要确保点了Add,将World (Aggregate)填入Selected ItemsStep 2. Enter Selection ItemsStep 1. Select sourceSetected ItemsMy Country GroupsWorld (Aggregate)Step 2, Select ItemsSefect and do

5、uble clickOther America Caribb曰mnSACUSADCWorld (Aggregate)第三步是选择Partners：选才? All和World是不一样的，All返回的是所有国家的数据， World返回的是 整体数据。如果您需要世界整体出口数据，那选择World就可以了。CommoditiesReportersPartnersOthersStep 1. Select SourceSelected ItemsPartners List"WorldStep 2. Select ItemsSelect and d口ubl日 click(AH)WorldAfgha

6、nistanAfrica CAMEU regionnesAlbaniaAlgeriaAmerican SamoaAdd Remove RerTtOve Air-Save selections to favorites第四步是选择年份，与 Partners相同Commodities I Reporters P a rtn2£ YearsOthersSelect and double dickSelected Items(AH)人 2013 pm?最后是Others,可以选择进口或者出口、数据范围和输出的格式。| CornfTiocIrtiesReportersPartnersYears

7、OthersSelect Trade FlowExports figures always include Re-ewports; Re-exports should be used ony to distinguish between Domestic exports and Re-exports, import !3 Export O re-Export re-importFilter Trade ValueGredter Thmn Equal Select Sort Order-None-Select Aggregation OptionKeep quantity unit differ

8、ences ,：l Ignore quantity unit differences所有都选好后，应该就没有别的问题了。得到这样的数据：这里面第一行的数据是所需要的，说实话，我还弄不清后两行的数据是什么意思 Quantity Unit 是8,代表kg, Flag是数字6,代表数量和重量都有估计。I.,Selected classification: HS as reportedSelected commodities: 4410Selected reporters: World (Aggregate)Selected years: 2013Selected partners: WorldSel

9、ected trade flows: EsportSort Order Yemr;Fkjw;RT|j;CumE；T己deV己I; v RefreshDiteH DOW酊(日Cj SDMX DwilQWll Ffin拍削日 FcifmMFlag refers to quantity/netweight estimation:0 no estimationH 2 工 auantity, 4 = netweiqht, 6 - both quantity and netweiqht选择Data Query > Express Selection的步骤是这样的:1 .首先还是要确保HS选项中，选择

10、As reportedHome Data Query Data Availability Metadata & Reference Subscription & Support Fast tracks Home * D加 Query * Express SelectionStep 1. SeJect ClassificadonHS： ® As reported 092 C'9B Ooz C o7 012 C- BECSITC: C'As reported O Rev,l O Rev,2 C > Rev,3 O Rev.42 .然后填写这几个输入框

11、。Enter Commodity Codes / Text 商品编码Enter Reporters Codes / Text Repoter的编码Enter Partners Codes / Text Partners的编码Enter Years 年份Select Trade Flow 贸易流向（如果不知道某种商品的编码，或者某个国家的编码，就点相应输入框后面的Lookup,进行选择）Step 2, Enter CtJitimodities, Reporters, Partners, Years and Select Trade FlowBasic Items AAxansd ItemsEnt

12、er Commodity Codes / TextSpecial Codes ; AN目一孔G8 (aggregate level) and LF (leaf). Use - to Exclude. Wild characters : * (Any string of zero or more characters) and ? (Any single character)441GSav日垣口 Ku 口Enter Reporters Codes / TextSeparated by comma. Special code:闻L Minus sign is not applicable.wodd

13、Save/ Luciku口Enter Partners Codes / TextSeparated by comma. Special code: HW. Minu5 sign is not applicable.worldEmLnciku 口Enter YearsSeparated by comma. Special code:阳.Minus sign is not applicable.2013§期0Lnoku白Select Trade FlowEwport5 figures always include Re-esports; Re-experts shnufd be used

14、 only to distinguish between Domestic exports and Re-exports.IZ2I Import H Export O re-Export Q re-importSubmit Query Go to Comtrade Explorer如果像上图一样，Reporter和Partner都填World ,就会返回庞大的数据，所以网 站不建议在页面显示，可以下载下来。Basic Query Results:Ttie query will return 2022 records.It's net recornitiended to view it

15、on screen (1000 records limit).Please rnodify your query (pr select additional selection from below) or dick* To improve performance, Direct Download ignore any defined sort order.Estimated file size: 0.25 MB.Please select addional setection from the following:Partner： Hof杷Quick I filter 0声可ch C1已百I

16、 刖的Selected ciassification: HS as ne portedSelected comnnodities： 441 口Seiected reporters： AllSelected years:之口33Selected partners: AllSelected trade flows： ExportDon't like the default download foirnnat? Get your own farrnt at here.irBMDuwnlgd SC)MX 口丽门如日6Mcidi惟Se旧ction玷卧 G.蹈口 11 f .Mir 加副.匚即a口

17、更虹/上出犯w 旧w 口-8¥小曰"归一口可依Estimated quantity/netweight shown in italicsRag refers to qua nt it y/n et we i g ht estimaton： = no estintionj 2 = qudntity4 = netweighty 8 = both quantity 己nd netweight但我们如果只需要世界整体的数据，那有个办法，点上图中的View Graph & Map, 就能得到下面的数据：不光有总体数据，还有前五国的排名，如果电脑的显示允许的话，还能看到饼状 图

18、。Selected classification: HS as reportedSelected commodities: 441DSe【邑ct白d reporters: AllSelected years: 2口13SeEscted partners: AllSelected trade flows: Export-Furth21r RE5Erch -H Indude other category in calculationFW日加 F3mmiReporter TitleTMde ValueC己门日dm$1,472,603,417Germ日门¥$791593,709Romania

19、542,459,457France$48%392J16BH 卬口m$425,615 晔Qt面日口 口磔5$3,205,771.919Top Exporters in the selection 也叵立处亚)Total Export; $6,930,425,650如果想看每一个国家的出口额，就在Partners里填0,0代表整个世界，但跟World 的返回还不一样。事实上，All、World和0都代表世界，在Reporter和Partner里都能填，但返回 的数据不同，您可以多尝试一些，就能找到规律。Basic items Ads日口c：电d ItgrriuEnter Commodity Cod

20、es / TextSpecial Codes : R队 AGO.AG1, . AG6 (aggregate level) and LF (leaf), Use - to exclude. Wild characters : * (Any string of zero or more characters) and ? (Any single character)4410Save7LLCJkU 口Enter Reporters Codes / TextSeparated by comma. Special code;* Minus sign is not applicable.worldLlqK

21、u口Enter Partners Codes / TextSeparated by comma, Special code:闺L Minus sign is not applicable.CSav日LflOKu口Enter YearsSeparated by comma. Special code:同L Minus sign 15 not appiicable.20134S秘函i-Lciku 口Select Trade FlowExports figures always include Re-exports; Re-exports should be used only to disting

22、uish between Domestic exports and Re-exports. Import 0Export reexport d re-ImpartSelected classification: HS as reportedSelected commodities: 4410Selected reporters: AllSelected years: 2013Selected partners: WorldSelected trade flows: ExportSort Order Year; Flow; Rep; CommjTradeVal; I RefreshDirect

23、Download SDMX Download Printable FormatModi" Selection View Graph View Explanatory Notes View Not-Available-Data 丁一 ：丁1，12 3 4WB OMMPeriodHow ReporterPartneir CodeTrade ValueNetWeight (kg)Quantity UnitTrade QuantityFlag2013Export AlbaniaWorld4410$1,4541,73081,73002013Export ArmeniaWorld4410$39260086000