Open Trade Statistics Database

Description

The Open Trade Statistics initiative was developed to ease access to international trade data by providing downloadable SQL database dumps, a public API, a dashboard, and an R package for data retrieval. This project was born out of the recognition that many academic institutions in Latin America lack access to academic subscriptions and comprehensive datasets like the United Nations Commodity Trade Statistics Database. The OTS project not only offers a solution to this problem regarding international trade data but also emphasizes the importance of reproducibility in data processing. Through the use of open-source tools, the project ensures that its datasets are accessible and easy to use for research and analysis. OTS, based on the official correlation tables, provides a harmonized dataset where the values are converted to HS revision 2012 for the years 1980-2021 and it involved transforming some of the reported data to find equivalent codes between the different classifications. For instance, the HS revision 1992 code '271011' (aviation spirit) does not have a direct equivalent in HS revision 2012 and it can be converted to the more general code '271000' (oils petroleum…

Description from Zenodo, shortened.

Files (8)

• SQLtradestatistics_final_tables.sql757 MB
• SQLtradestatistics_hs_rev1992.sql4.1 GB
• SQLtradestatistics_hs_rev2002.sql3.2 GB
• SQLtradestatistics_hs_rev2007.sql2.5 GB
• SQLtradestatistics_hs_rev2012.sql1.7 GB
• SQLtradestatistics_sitc_rev1.sql1.4 GB
• SQLtradestatistics_sitc_rev2.sql1.8 GB
• SQLtradestatistics_valuation_systems.sql5.9 kB

DataHunter does not store or host these files: every link leads to the original source. Check the license there before using the data.