Data Share Usage Example Q1: How can I select the top 1,000 imports in 2019 from UN Comtrade with HS Codes?
select top 1000 *
from panjivaMacroUNComtrade un
join panjivaHSCodes hs on hs.keyHS = un.keyHS
join panjivaMacroComtradeUnit cu
on cu.keyMacroComtradeUnit = un.keyMacroC
Data Share Usage Example SQL1 Last Tested: January 1, 1970
Related Company: S&P Global Market Intelligence
Data Share Overview:
Panjiva Macroeconomics data offers import and export coverage for 170+ countries. Sourced from UN Comtrade, with this data you can:
– Expand your insights on global trade due to broader coverage than shipment-level records available in many geographies with access to the largest repository of international trade data
– Leverage HS Codes to analyze aggregate trade flows between countries at the commodity level
– Access aggregate metrics for dollar value, weight, and volume of shipments from over 170 countries
– Receive access to the raw data underlying Panjiva’s trendspotting tool
Dataset Overview:
– Primary Entity Type: Commodity
– Coverage Count: 5,600+
– Geographic Coverage: Global
– Industry Coverage: Consumer, Healthcare, Industrials, Materials, Technology, Media & Telecommunications
– History Initiated: 2009
– Data Source: Panjiva / UN Comtrade