Just to ask a quick question on data availability: does anyone know where I can find EMBI spread data in monthly/quarterly frequency? I know I can access to yearly data at the World Bank through DBnomics WB/GEM | DBnomics. But it seems like the World Bank has more frequent data that I can’t see at DBnomics: Global Economic Monitor (GEM) | DataBank (worldbank.org).
Hi @mk1564 and welcome to the DBnomics forum!
We are currently rewriting the DBnomics fetcher for the World Bank, because of a rewrite of the World Bank’s web API. Maybe that data is not on DBnomics because the current fetcher has not been able to run for a couple of weeks.
I need to look further and I’ll keep you informed here.
Thanks @cbenz for your reply! Got it. I will wait until it is written. FYI: I am using Julia.
The World Bank fetcher has been upgraded and deployed in the previous days, and data has been updated also. GEM is part of the update.
@mk1564 You can check that here: WB/GEM | DBnomics
Thanks for your patience and please ask for further details if needed
Thanks for the update! @cbenz
I just checked EMBI+ series at DBnomics, but it seems like quarterly or monthly data is still unavailable? For example, there is just one series for Colombia, which is a yearly series: WB/GEM | DBnomics. But WB/GEM does have those series for Colombia at Global Economic Monitor (GEM) | DataBank (worldbank.org).
Wow, I think I understand now… thanks for insisting! After a couple of hours I could find out a solution. Below are the details.
Actually after double checking the download script of the WB fetcher, it seems that it calls the API endpoint called “aggretate” (cf docs). But besides exists another API endpoint called"advanced data query" which is described in the advanced docs page.
For example here are 2 URLs for comparing:
In the second API endpoint, there are monthly, quarterly and annual series all together.
I’m going to update the WB download script again to take advantage of that new API endpoint, sort the series by frequency, inject a new FREQ dimension, and make this available.
Now I wonder why the databank UI does not offer annual series (cf GEM on databank) in the “time” panel… but that’s not really a blocking question.
Thanks @cbenz for your replay! Yes, it does seem like the WB databank UI does not separate out the data frequencies (yearly/quarterly/monthly) in the Time panel. I hope this does not make the update too complicated. Thank you so much again!
Dear @mk1564, I could retrieve the other frequencies we talked about.
Here is the monthly series I mentioned in my previous post, now on DBnomics, as an example: WB/GEM/M-EMBIG-COL | DBnomics
Please tell me if it’s OK for you now
Thank you so much for this update! Yes, I checked that I can download monthly series for EMBIG. This is great!
One thing that may be related to WB part of update: the usual Julia command does not work. For example, in the examples in DBnomics.jl.
# Fetch several values of several dimensions from dataset 'Doing business' (DB) of World Bank :
df3 = rdb("WB", "DB", dimensions = Dict(:country => ["DZ", "PE"], :indicator => ["ENF.CONT.COEN.COST.ZS", "IC.REG.COST.PC.FE.ZS"]));
df3 = rdb("WB", "DB", dimensions = (country = ["DZ", "PE"], indicator = ["ENF.CONT.COEN.CO
do not work anymore.
Maybe there is an updated way to fetch multiple series with dimensions for WB data?
Correct, the error is due the change of some codes:
- the dataset code
DB was updated to
DBS (by the World Bank)
- the addition of the new dimension named “frequency” (by me following our discussion)
- the changes of the country codes from 2 letters to 3 letters (by the World Bank)
I did not realize that this particular dataset was used as an example in the README!
I proposed a pull request to the author of the package, cf #12.
Thanks for the pull request! I checked that the revised version of the example code with new country code and dataset code works fine in Julia with
However, one thing I just found is that the fetching code for
WDI part of WB data has not been revised? For example, you can see that the data series can not be searched for along the frequency dimension in the webpage of WB/WDI | DBnomics.
Maybe this is why I cannot get the data by using a similarly revised code like below?
julia> rdb("WB","WDI", dimensions = (country = ["KOR"], frequency = ["A"], indicator = ["NE.CON.GOVT.ZS"]))
┌ Warning: No data series found.
└ @ DBnomics C:\Users\Min\.julia\packages\DBnomics\otwZO\src\dot_rdb.jl:49
*Update: This issue has been already reported. See WDI and error from frequency code - #2 by cbenz.
Yes, you’re right ! I updated the other forum post you mentioned and fixed the issue.
Thanks again for the report!
This is great. Thank you so much!