Balanced International Merchandise Trade Statistics (BIMTS) - HS2017-2D
OECD dataset from agency OECD.SDD.TPS: DSD_BIMTS@DF_BIMTS_HS2017_2D (1995 - 2023)
@oecd.oecd_sdd_tps_dsd_bimts_df_bimts_hs2017_2d_v1_0
OECD dataset from agency OECD.SDD.TPS: DSD_BIMTS@DF_BIMTS_HS2017_2D (1995 - 2023)
@oecd.oecd_sdd_tps_dsd_bimts_df_bimts_hs2017_2d_v1_0
The OECD Balanced International Merchandise Trade Statistics (BIMTS) dataset provides a complete, consistent, and balanced matrix of international merchandise trade statistics. It includes annual bilateral data for approximately 200 reporters and partners, covering around 98 products in HS2017 at the 2-digit level from 1995 to 2023. BIMTS is also available in the HS 2017 classification at 4-digit and 6-digit levels of aggregation currently available via the Related Files (bottom of the page) and also in the Statistical Classification of Products by Activity (CPA 2.1) at the 2-digit level of aggregation.
An important feature of BIMTS is a novel algorithm which identifies re-export flows and reallocates them to the producer countries before the balancing. To avoid double counting of flows between producers and trade hubs (already accounted for in the trade between producers and final users), BIMTS breaks down the final balanced values into a domestic component and a re-exports component. Users will therefore find two different measures of balanced trade flows (under the ‘Adjustment’ dimension):
In this database, the Reference area denotes the exporter , while the Counterpart area denotes the importer. Because the data are balanced, exports from the exporter to the importer equal imports by the importer from the exporter, and the flow is therefore recorded only once. Note that zero trade flows are represented in BIMTS as missing records (marked as “..”). This approach reduces the dataset size and improves processing times in the OECD Data Explorer. For convenience, users can also retrieve data for total merchandise (“_T”, denoting all products) and partner world (“W”).
BIMTS will be regularly updated and continually improved as new data becomes available.
For more information on:
Users are encouraged to send their questions, or to signal any apparent errors, regarding this database to STAT.Contact@oecd.org
CREATE TABLE observations (
"dataflow" VARCHAR,
"ref_area" VARCHAR,
"counterpart_area" VARCHAR,
"trade_flow" VARCHAR,
"product_type" VARCHAR,
"product_cpa" VARCHAR,
"product_hs" VARCHAR,
"freq" VARCHAR,
"unit_measure" VARCHAR,
"adjustment" VARCHAR,
"time_period" BIGINT,
"obs_value" DOUBLE,
"obs_status" VARCHAR,
"methodology_type" VARCHAR,
"unit_mult" BIGINT,
"decimals" BIGINT
);Anyone who has the link will be able to view this.