Query LibraryLinks Panjiva Identifiers To Capital IQ DataPANJIVA 供应链情报Links Panjiva Identifiers To Capital IQ DataThe following sample query links Panjiva identifiers to S&P Capital IQ data. Note: Here TOP 100 are shown for better query executionSourceMarket IntelligenceData Packages RequiredPanjiva Company Cross RefMSSQLPostGreSQL请用认证信息登录，可解锁此内容登录Other Queries for this Dataset(s)Panjiva 供应链情报Returns New Customers And HSCodes Imported By A CompanySign In to view codePanjiva 供应链情报Leverages Snowflake Dynamic Scripting To Provide Import Statistics For Specified Companies,Ensuring Consistent Column Handling, Efficient Aggregation And Filtering By Region, Date, And Company,For All Panjiva Import TablesSign In to view codePanjiva 供应链情报Returns First Instance Of The Fully Matching HS Code For A Given PanjivaRecordIdSign In to view codePanjiva 供应链情报Returns Import And Export Shipment Statistics For A Specified Company And Its Subsidiaries Based On CompanyID, Country, Start Date, And EndDate, Including Imports And Exports Of All 19 CountriesSign In to view codePanjiva 供应链情报Returns HS Code And HS Methodology For Panjiva DataSign In to view codePanjiva 供应链情报Data In Countries That Do Not Have A Data SourceSign In to view code123View all Queries for this Dataset(s)