Whitespace in indicator identifiers

26 views
Skip to first unread message

Sarven Capadisli

unread,
May 23, 2012, 6:58:55 AM5/23/12
to world-b...@googlegroups.com
Hi, just an FYI, you may or may not be interest in removing the
whitespace for some of the indicator ids:

$ grep -E "id=\".*\s+\"" indicators.xml
<wb:indicator id="DT.ODA.DACD.HIV.CNTRL.CD ">
<wb:indicator id="DT.ODA.DACD.HIV.MITI.CD ">
<wb:indicator id="DT.ODA.MULTI.HIV.CNTRL.CD ">
<wb:indicator id="DT.ODA.MULTI.HIV.MITI.CD ">
<wb:indicator id="IC.DCP.COST ">
<wb:indicator id="IC.DCP.PROC ">
<wb:indicator id="IC.DCP.TIME ">
<wb:indicator id="IC.EC.COST ">
<wb:indicator id="IC.EC.PROC ">
<wb:indicator id="IC.EC.TIME ">
<wb:indicator id="IC.EXP.COST.EXP ">
<wb:indicator id="IC.EXP.COST.IMP ">
<wb:indicator id="IC.EXP.DOCS.IMP ">
<wb:indicator id="IC.EXP.TIME.EXP ">
<wb:indicator id="IC.EXP.TIME.IMP ">
<wb:indicator id="IC.FRM.CORR.CORR1 ">
<wb:indicator id="IC.FRM.CORR.CORR10 ">
<wb:indicator id="IC.FRM.CORR.CORR11 ">
<wb:indicator id="IC.FRM.CORR.CORR2 ">
<wb:indicator id="IC.FRM.CORR.CORR3 ">
<wb:indicator id="IC.FRM.CORR.CORR4 ">
<wb:indicator id="IC.FRM.CORR.CORR6 ">
<wb:indicator id="IC.FRM.CORR.CORR7 ">
<wb:indicator id="IC.FRM.CORR.CORR8 ">
<wb:indicator id="IC.FRM.CORR.CORR9 ">
<wb:indicator id="IC.FRM.CORR.CRIME9 ">
<wb:indicator id="IC.FRM.CORR.GRAFT2 ">
<wb:indicator id="IC.FRM.CRM.CRIME1 ">
<wb:indicator id="IC.FRM.CRM.CRIME2 ">
<wb:indicator id="IC.FRM.CRM.CRIME2_C ">
<wb:indicator id="IC.FRM.CRM.CRIME3 ">
<wb:indicator id="IC.FRM.CRM.CRIME3_C ">
<wb:indicator id="IC.FRM.CRM.CRIME5 ">
<wb:indicator id="IC.FRM.CRM.CRIME8 ">
<wb:indicator id="IC.FRM.FCHAR.CAR1 ">
<wb:indicator id="IC.FRM.FCHAR.CAR2 ">
<wb:indicator id="IC.FRM.FCHAR.CAR3 ">
<wb:indicator id="IC.FRM.FCHAR.CAR4 ">
<wb:indicator id="IC.FRM.FCHAR.CAR6 ">
<wb:indicator id="IC.FRM.FCHAR.LFORM1 ">
<wb:indicator id="IC.FRM.FCHAR.LFORM2 ">
<wb:indicator id="IC.FRM.FCHAR.LFORM3 ">
<wb:indicator id="IC.FRM.FCHAR.LFORM4 ">
<wb:indicator id="IC.FRM.FCHAR.LFORM5 ">
<wb:indicator id="IC.FRM.FIN.FIN1 ">
<wb:indicator id="IC.FRM.FIN.FIN10 ">
<wb:indicator id="IC.FRM.FIN.FIN11 ">
<wb:indicator id="IC.FRM.FIN.FIN12 ">
<wb:indicator id="IC.FRM.FIN.FIN13 ">
<wb:indicator id="IC.FRM.FIN.FIN14 ">
<wb:indicator id="IC.FRM.FIN.FIN15 ">
<wb:indicator id="IC.FRM.FIN.FIN16 ">
<wb:indicator id="IC.FRM.FIN.FIN18 ">
<wb:indicator id="IC.FRM.FIN.FIN2 ">
<wb:indicator id="IC.FRM.FIN.FIN20 ">
<wb:indicator id="IC.FRM.FIN.FIN21 ">
<wb:indicator id="IC.FRM.FIN.FIN3 ">
<wb:indicator id="IC.FRM.FIN.FIN4 ">
<wb:indicator id="IC.FRM.FIN.FIN5 ">
<wb:indicator id="IC.FRM.FIN.FIN7 ">
<wb:indicator id="IC.FRM.FIN.FIN8 ">
<wb:indicator id="IC.FRM.FIN.FIN9 ">
<wb:indicator id="IC.FRM.GEN.GEND1 ">
<wb:indicator id="IC.FRM.GEN.GEND2 ">
<wb:indicator id="IC.FRM.GEN.GEND3 ">
<wb:indicator id="IC.FRM.GEN.GEND4 ">
<wb:indicator id="IC.FRM.INFOR.INFOR1 ">
<wb:indicator id="IC.FRM.INFOR.INFOR2 ">
<wb:indicator id="IC.FRM.INFOR.INFOR4 ">
<wb:indicator id="IC.FRM.INFOR.INFOR5 ">
<wb:indicator id="IC.FRM.INFRA.IN1 ">
<wb:indicator id="IC.FRM.INFRA.IN10 ">
<wb:indicator id="IC.FRM.INFRA.IN10_C ">
<wb:indicator id="IC.FRM.INFRA.IN11 ">
<wb:indicator id="IC.FRM.INFRA.IN12 ">
<wb:indicator id="IC.FRM.INFRA.IN14 ">
<wb:indicator id="IC.FRM.INFRA.IN2 ">
<wb:indicator id="IC.FRM.INFRA.IN3 ">
<wb:indicator id="IC.FRM.INFRA.IN3_C ">
<wb:indicator id="IC.FRM.INFRA.IN4 ">
<wb:indicator id="IC.FRM.INFRA.IN6 ">
<wb:indicator id="IC.FRM.INFRA.IN9 ">
<wb:indicator id="IC.FRM.INNOV.T1 ">
<wb:indicator id="IC.FRM.INNOV.T2 ">
<wb:indicator id="IC.FRM.INNOV.T3 ">
<wb:indicator id="IC.FRM.INNOV.T4 ">
<wb:indicator id="IC.FRM.INNOV.T5 ">
<wb:indicator id="IC.FRM.INNOV.T6 ">
<wb:indicator id="IC.FRM.OBS.OBST1 ">
<wb:indicator id="IC.FRM.OBS.OBST10 ">
<wb:indicator id="IC.FRM.OBS.OBST11 ">
<wb:indicator id="IC.FRM.OBS.OBST12 ">
<wb:indicator id="IC.FRM.OBS.OBST13 ">
<wb:indicator id="IC.FRM.OBS.OBST14 ">
<wb:indicator id="IC.FRM.OBS.OBST15 ">
<wb:indicator id="IC.FRM.OBS.OBST2 ">
<wb:indicator id="IC.FRM.OBS.OBST3 ">
<wb:indicator id="IC.FRM.OBS.OBST4 ">
<wb:indicator id="IC.FRM.OBS.OBST5 ">
<wb:indicator id="IC.FRM.OBS.OBST6 ">
<wb:indicator id="IC.FRM.OBS.OBST7 ">
<wb:indicator id="IC.FRM.OBS.OBST8 ">
<wb:indicator id="IC.FRM.OBS.OBST9 ">
<wb:indicator id="IC.FRM.REG.BUS1 ">
<wb:indicator id="IC.FRM.REG.BUS2 ">
<wb:indicator id="IC.FRM.REG.BUS3 ">
<wb:indicator id="IC.FRM.REG.BUS5 ">
<wb:indicator id="IC.FRM.REG.REG1 ">
<wb:indicator id="IC.FRM.REG.REG2 ">
<wb:indicator id="IC.FRM.REG.REG2_C ">
<wb:indicator id="IC.FRM.REG.REG4 ">
<wb:indicator id="IC.FRM.REG.REG5 ">
<wb:indicator id="IC.FRM.TRD.TR1 ">
<wb:indicator id="IC.FRM.TRD.TR10 ">
<wb:indicator id="IC.FRM.TRD.TR11 ">
<wb:indicator id="IC.FRM.TRD.TR14 ">
<wb:indicator id="IC.FRM.TRD.TR15 ">
<wb:indicator id="IC.FRM.TRD.TR2 ">
<wb:indicator id="IC.FRM.TRD.TR4 ">
<wb:indicator id="IC.FRM.TRD.TR5 ">
<wb:indicator id="IC.FRM.TRD.TR6 ">
<wb:indicator id="IC.FRM.TRD.TR7 ">
<wb:indicator id="IC.FRM.TRD.TR8 ">
<wb:indicator id="IC.FRM.TRD.TR9 ">
<wb:indicator id="IC.FRM.WRKF.WK1 ">
<wb:indicator id="IC.FRM.WRKF.WK10 ">
<wb:indicator id="IC.FRM.WRKF.WK11 ">
<wb:indicator id="IC.FRM.WRKF.WK12 ">
<wb:indicator id="IC.FRM.WRKF.WK13 ">
<wb:indicator id="IC.FRM.WRKF.WK2 ">
<wb:indicator id="IC.FRM.WRKF.WK3 ">
<wb:indicator id="IC.FRM.WRKF.WK4 ">
<wb:indicator id="IC.FRM.WRKF.WK6 ">
<wb:indicator id="IC.FRM.WRKF.WK7 ">
<wb:indicator id="IC.FRM.WRKF.WK8 ">
<wb:indicator id="IC.FRM.WRKF.WK9 ">
<wb:indicator id="IC.GE.COST ">
<wb:indicator id="IC.GE.NUM ">
<wb:indicator id="IC.GE.TIME ">
<wb:indicator id="IC.ISV.COST ">
<wb:indicator id="IC.ISV.RECRT ">
<wb:indicator id="IC.LIC.NUM ">
<wb:indicator id="IC.LIC.TIME ">
<wb:indicator id="IC.PI.DIR ">
<wb:indicator id="IC.PI.DISCL ">
<wb:indicator id="IC.PI.INV ">
<wb:indicator id="IC.PI.SHAR ">
<wb:indicator id="IC.REG.CAP ">
<wb:indicator id="IC.REG.COST ">
<wb:indicator id="IC.RP.COST ">
<wb:indicator id="IC.RP.PROC ">
<wb:indicator id="IC.RP.TIME ">
<wb:indicator id="SE.SEC.DURS.LO ">
<wb:indicator id="SE.SEC.ENRR.UP.FE ">
<wb:indicator id="SE.SEC.ENRR.UP.MA ">


-Sarven

Sarven Capadisli

unread,
May 23, 2012, 5:44:07 PM5/23/12
to world-b...@googlegroups.com
Actually, based on the indicators that I've pulled earlier, it's:
-Sarven

Sarven Capadisli

unread,
Nov 21, 2012, 5:07:18 AM11/21/12
to world-b...@googlegroups.com
This issue still exists, and there is one in which a whitespace occurs
in the middle:

<wb:indicator id="FIN14 _SME">

This indicator doesn't exist even if we remove the whitespace:

http://api.worldbank.org/indicator/FIN14_SME

Might be worth to compare with FIN14_SMALL.

-Sarven

Shanmugam Natarajan

unread,
Nov 21, 2012, 2:29:21 PM11/21/12
to world-b...@googlegroups.com
Hi Sarven

The indicator code which contains whitespace at the middle, is fixed. Please check now.
Api call: http://api.worldbank.org/indicator/FIN14_SME

regd. the whitespaces in other indicators which you provided, I couldn't see any whitespaces in those indicators (via API calls)
sample api calls using those indicators,
http://api.worldbank.org/indicator/IC.FRM.FIN.FIN7
http://api.worldbank.org/indicator/IC.FRM.CORR.CRIME9
http://api.worldbank.org/country/usa/indicator/IC.FRM.CORR.CRIME9

It would be helpful to investigate further if you could provide the specific api calls which return the indicator codes with whitespaces.
Thank you very much.

Regards,
Shanmugam

Sarven Capadisli

unread,
Nov 21, 2012, 5:50:52 PM11/21/12
to world-b...@googlegroups.com
On 11/21/2012 08:29 PM, Shanmugam Natarajan wrote:
> Hi Sarven
>
> The indicator code which contains whitespace at the middle, is fixed.
> Please check now.
> Api call: http://api.worldbank.org/indicator/FIN14_SME

Great.

> regd. the whitespaces in other indicators which you provided, I couldn't
> see any whitespaces in those indicators (via API calls)
> sample api calls using those indicators,
> http://api.worldbank.org/indicator/IC.FRM.FIN.FIN7
> http://api.worldbank.org/indicator/IC.FRM.CORR.CRIME9
> http://api.worldbank.org/country/usa/indicator/IC.FRM.CORR.CRIME9

> It would be helpful to investigate further if you could provide the
> specific api calls which return the indicator codes with whitespaces.

The API call that I'm issuing is:

http://api.worldbank.org/en/indicators?format=xml&per_page=20000

which gives me the full list of definitions for the indicators.

Similarly I do the same for the other metadata:

http://api.worldbank.org/en/sources?format=xml&per_page=20000
http://api.worldbank.org/en/topics?format=xml&per_page=20000
http://api.worldbank.org/en/regions?format=xml&per_page=20000
http://api.worldbank.org/en/incomeLevels?format=xml&per_page=20000
http://api.worldbank.org/en/lendingTypes?format=xml&per_page=20000
http://api.worldbank.org/en/countries?format=xml&per_page=20000

For specific indicators, I iterate over:

http://api.worldbank.org/en/countries/all/indicators/{indicatorCode}?format=xml&per_page=20000

> Thank you very much.

Thanks.

-Sarven

Sarven Capadisli

unread,
Nov 21, 2012, 6:00:07 PM11/21/12
to world-b...@googlegroups.com
On 11/21/2012 08:29 PM, Shanmugam Natarajan wrote:
> regd. the whitespaces in other indicators which you provided, I couldn't
> see any whitespaces in those indicators (via API calls)
> sample api calls using those indicators,
> http://api.worldbank.org/indicator/IC.FRM.FIN.FIN7
> http://api.worldbank.org/indicator/IC.FRM.CORR.CRIME9

Forgot to mention that, the whitespace for those results exist e.g.,

<wb:indicator id="IC.FRM.FIN.FIN7 ">

-Sarven

Reply all
Reply to author
Forward
0 new messages