Data Share Usage Example Q1: How can I select the top 1,000 U.S. import records and include HS Code?
select top 1000 *
from panjivaUSImport usi
join panjivaUSImpHSCode uihs
on uihs.panjivarecordid = usi.panjivaRecordId
join panjivaUSImpGoodsShpd uigs
on u
Leverages machine learning technologies to surface key insights from unstructured customs import & export shipping data and resolves entities to their parent company for your analysis.
– Access coverage spanning approximately 40% of global merchandise traded by dollar value. Over 1 billion shipment records from 17 countries and 13 million company-to-company relationships for a comprehensive view of the global marketplace.
– Explore shipment records that provide information on physical trade transactions between companies, with information on the goods traded, tariff codes, ports, amounts, values and other trade details.
– Utilize entity resolution and tagging created through the use of advanced data science approaches including Machine Learning and NLP.
– Current country coverage available via Snowflake include United States, Uruguay, Peru, Panama, Pakistan.
Dataset Overview:
Primary Entity Type: Company
Coverage Count: 1,000,000
Geographic Coverage: Global
– Industry Coverage: Consumer, Energy and Utilities, Financials, Healthcare, Industrials, Materials, Real Estate, Technology, Media & Telecommunications
– History Initiated: 2007
– Data Source: Publicly available customs declarations and trade bureau statistics