A04_Specifications.docx

The U.S. Geological Survey National Minerals Information Center (NMIC) has a need for access to import and export data from a comprehensive online database that contains official merchandise trade statistics under the Harmonized System (HS) classification of goods for countries all over the world.

General Requirements

· Online database access to all HS codes for all users within the NMIC.

· The user interface shall provide unrestricted ability to query, extract, and download data in various formats that include Excel, Text, and comma-separated values (CSV).

· Data extracts shall be unrestricted in both number of queries/extracts as well as volume/number of data points.

· Ability to extract data directly without need for third party software (e.g. via use of an API).

· As a minimum, data fields shall include Reporting Country, Partner Country, ISO Reporter and Partner Codes, HS Code, HS Description, Quantity (reported), Customs Value, and Unit Value.

· When available, dataset shall include:

· First and second quantity.

· General imports and imports for consumption (quantity and value).

· Domestic exports and foreign (re-exports) (quantity and value).

· Optional customized data reports.

· Data set shall include search access to detailed country specific HS Codes and descriptions.

· Data set shall include all country specific HS codes. The HS comprises approximately 5,300 article/product descriptions that appear as headings and subheadings, arranged in 99 chapters, grouped in 21 sections.

Data Coverage

· The data provided should be the most detailed available Harmonized Schedule (HS) information.

· District/port/province/region level data shall be provided when available.

· As a minimum access to district/port/province/region level data should include Australia, Brazil, Canada, China, Chile, the European Union, India, Japan, Mexico, Republic of Korea, the Russian Federation, the United Kingdom, and the United States.

· The database shall include officially-sourced (i.e. customs agencies or national statistical offices) data for at least 90 reporting countries.

· Monthly data shall be provided for at least 80 countries with country specific HS detail of 8 digits or greater.

· As a minimum, the data set shall include import and export trade flows for the following countries: Albania, Argentina, Australia, Austria, Bahrain, Belarus, Belgium, Belize, Bolivia, Bosnia & Herzegovina, Botswana, Brazil, Brunei, Bulgaria, Canada, Chile, China, Colombia, Costa Rica, Cote d'Ivoire, Croatia, Cyprus, Czech Republic, Denmark, Dominican Republic, Ecuador, Egypt, El Salvador, Estonia, Ethiopia, Finland, France, Georgia, Germany, Ghana, Greece, Guatemala, Honduras, Hong Kong, Hungary, Iceland, India, Indonesia, Iran, Ireland, Israel, Italy, Japan, Jordan, Kazakhstan, Kenya, Kosovo, Latvia, Lithuania, Luxembourg, Macau, Macedonia, Malaysia, Malta, Mauritius, Mexico, Montenegro, Morocco, Mozambique, the Netherlands, New Zealand, Nicaragua, Nigeria, Norway, Pakistan, Panama, Paraguay, Peru, Philippines, Poland, Portugal, Qatar, Romania, Russia, Saudi Arabia, Senegal, Serbia, Singapore, Slovakia, Slovenia, South Africa, the Republic of Korea, Spain, Sri Lanka, Sweden, Switzerland, Taiwan, Thailand, Turkey, Ukraine, United Kingdom, United States, Uruguay and Vietnam.

· As a minimum, the following countries shall have historical data extending back to year specified in parenthesis or earlier: Argentina (2002), Australia (2005), Austria (2004), Belgium (1999), Brazil (2002), Canada (1995), China (2000), Chile (2011), Colombia (2007), Denmark (1997), Ecuador (2010), Egypt (2010), Finland (2002), France (2003), Georgia (2010), Germany (2002), Ghana (2010), Greece (1997), Hong Kong (2006), Hungary (2000), Iceland (2010), India (2009), Ireland (2004), Israel (2009), Italy (2004), Japan (1994), Korea (Republic of) (2000), Latvia (2000), Lithuania (2000), Luxembourg (1999), Malaysia (2009), Mexico (2000), Mozambique (2014), Netherlands (1997), New Zealand (2007), Norway (2010), Pakistan (2010), Panama (2010), Philippines (2007), Poland (2000), Portugal (1997), Romania (2000), Russian Federation (2013), Slovakia (2000), Slovenia (2000), South Africa (2010), Spain (1997), Sweden (1997), Switzerland (2002), Taiwan (2007), Thailand (2007), Turkey (2013), Ukraine (2003), United Kingdom (2004), United States (1990), and Uruguay (2010).

Functionality shall include

· On-screen abilities:

· Reporting of least three years of annual data.

· Convert reported units to metric ton/kilogram and U.S. dollars.

· Aggregate monthly data to quarterly and annual totals.

· Toggle between imports and exports for a specific country and/or HS code.

· View reverse trade statistics (for example, view all countries' reported imports of an item from a specific partner country).

· Functionality to drill down through the user interface from 2-digit into the most detailed HS codes available.

· HS code and data search by commodity or keyword within description or HS.

· Display results with ability to download results in various formats and export charts.

· Select multiple HS Codes, Product Groups, and Partner Countries.

· Include HS descriptions and select multiple levels of HS detail in a single report for drill-down.

· Selectable fields for data retrieval shall include:

· Reporters

· Trade Direction

· Partner

· Product: one or multiple selectable HS codes with incorporated search function by code or keywords.

· Frequency: Monthly, Year to date, or annual

· List order: Selectable by Product, Reporter, Trade Partner

· Search Criteria shall include:

· Create multiple commodities and groups in a single search.

· Ability to directly change criteria without restarting a search.

· Search capabilities for HS Codes, and keywords.

· Ability to save specialized queries.

· User interface Functionality to drill down into most detailed HS codes available.

· Display results on screen or download in Excel or CSV format

· Customized aggregation of data by country or HS codes.

· Create and save HS and county groups.

· The user interface shall provide access to imports, exports, and trade balance.

Customer Support

· Consulting and customer service at no extra charge, response with 24 hours.

· Data shall be updated monthly with an average time lag of less than 3 months.