Updates
* Adds dyadic distances table (ots_distances
) for gravity modelling
Breaking changes The API now returns Parquet files instead of JSON for all the cases (except for available years and tables) All the tests were adapted to reflect changes in the DB (i.e., the test "multiple country match = error" no longer returns an error because there are no two codes for Germany in 2002-2020) The command use_localhost was removed because the Shiny app now connects directly to PostgreSQL (i.e., this saves resources) The column EU-28 member was removed from the countries table (i.e., avoid UK confusion after Brexit)
Updates Uses GDP deflator to convert dollars from one year to another (previously it used reported inflation) Breaking changes New port for local instance (8080 -> 4949)
Updates Provides ysrpc table to visualize products, replacing yc tables. The new default option is to download imputed data, as there is no direct API access to raw data. A new method to correct import/exports mismatches was applied and the datasets now start from 1980 until I test enough the model results for older years. Drops yr-sections and yr-groups tables Drops 'group' columns in the final data (and replaces it for 'section' columns) Allows to access both raw and imputed data from the API Allows to search for special codes in the API (i.e., e-490 and other codes) All these changes have resulted in large speedups with both data downloading and the Open Trade Statistics dashboard
Breaking changes * Most of the tables in the API were renamed, as now I made available an imputation method to remove transportation costs (and correct mismatching flows)
Minor fixes * Adds attributes to parquet tables (i.e., it now does the joins to add product name, section color, etc.)
Updates * Uses "_name" instead of "_fullname_english" in final tables colnames
Updates Allows to obtain tables in Parquet format from the API, giving a speed-up of ~50% for the final user. Uses tibble instead of DT to produce lighter vignettes
Updates * Adds section colors data for visualization, this is taken from the palette used in shiny.tradestatistics.io
Updates Removes all references to tables using communities or short names (both unofficial), reflecting changes in the API The functionality remains the same, but now the end user functions don't add a 21-colors palette to the data (i.e. see the data section)
Data
Updates
Updates
Updates
yrpc-ga
, yrpc-sa
, yrc-ga
and yr-sa
tables reflecting API
updatesinclude_groups
option)Updates
yrp_short
option reflecting last DB changesUpdates
Updates
Updates
Updates
ots_create_tidy_data()
to allow multiple countries as
arguments, in line with API changes from September 2019Updates
product_code_length
Updates
Fixes
Adds
Fixes
yrp_short
to available tablesuse_localhost
option for our own server or users who want to clone the
database locally, therefore avoid having a separate branh for server
installationAny scripts or data that you put into this service are public.
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.