[R-br] Ler arquivo JSON com diversos outros JSONs dentro dele

classic Classic list List threaded Threaded
9 messages Options
Reply | Threaded
Open this post in threaded view
|

[R-br] Ler arquivo JSON com diversos outros JSONs dentro dele

R-br mailing list
Boa tarde colegas listeiros, como vão?

Ultimamente venho encontrando certa dificuldade para trabalhar com arquivos JSON que contém outros JSON dentro deles.
Sempre que precisei trabalhar com esse tipo de arquivo utilizei a expressão:

library(jsonlite)
raiz= ('C:\\Users\\Desktop\\')
a = fromJSON(paste0(raiz,'document.json'))

Dessa forma eu obtenho uma lista e consigo selecionar os valores dos campos que quero.
Mas quando tento aplicar a mesma lógica para um JSON que contém diversos outros JSONs, o código quebra e retorna:
Error in parse_con(txt, bigint_as_char) : parse error: trailing garbage
          99809265137         }       },       {         "_index": "ch
                     (right here) ------^

Meu interesse é acessar apenas as informações de alguns campos desses JSONs e construir uma tabela, onde nas colunas eu terei os campos que desejo e nas linhas eu terei os valores de cada um dos JSONs. 
A seguir, estou colando no corpo da mensagem um pedaço de um desses arquivos que estou tentando lidar no R.

Desde já, agradeço pela ajuda e atenção.

Att


{
        "_index": "busca",
        "_type": "data_point",
        "_id": "interpolation:699646|mgper-0-20|2018-06-22|5x21sxq1km3b",
        "_score": 1,
        "_source": {
          "name": "Mg% 0-20",
          "data_type": "interpolation",
          "attribute": "Mg%",
          "farm_id": 22706,
          "depth": "0-20",
          "location": [
            -48.91500982855756,
            -22.293821593345108
          ],
          "inceres_id": 699646,
          "date_created": "2018-06-22T14:06:13.587631-03:00",
          "slug": "mgper-0-20",
          "quantity": 10.565964698791504
        }
      },
      {
        "_index": "busca",
        "_type": "data_point",
        "_id": "interpolation:701809|ph-20-40|2018-06-22|5x21uc94cc55",
        "_score": 1,
        "_source": {
          "name": "ph 20-40",
          "data_type": "interpolation",
          "attribute": "ph",
          "farm_id": 22706,
          "depth": "20-40",
          "location": [
            -48.90241501215151,
            -22.28980716917012
          ],
          "inceres_id": 701809,
          "date_created": "2018-06-22T14:06:35.183784-03:00",
          "slug": "ph-20-40",
          "quantity": 4.381259918212891
        }
      },
      {
        "_index": "busca",
        "_type": "data_point",
        "_id": "interpolation:699646|mgper-0-20|2018-06-22|5x21sz1rcjp5",
        "_score": 1,
        "_source": {
          "name": "Mg% 0-20",
          "data_type": "interpolation",
          "attribute": "Mg%",
          "farm_id": 22706,
          "depth": "0-20",
          "location": [
            -48.915268161911925,
            -22.289490533842073
          ],
          "inceres_id": 699646,
          "date_created": "2018-06-22T14:06:13.587631-03:00",
          "slug": "mgper-0-20",
          "quantity": 8.669662475585938
        }
      },
      {
        "_index": "busca",
        "_type": "data_point",
        "_id": "interpolation:701809|ph-20-40|2018-06-22|5x21uc3097d7",
        "_score": 1,
        "_source": {
          "name": "ph 20-40",
          "data_type": "interpolation",
          "attribute": "ph",
          "farm_id": 22706,
          "depth": "20-40",
          "location": [
            -48.904161243141765,
            -22.289829735373146
          ],
          "inceres_id": 701809,
          "date_created": "2018-06-22T14:06:35.183784-03:00",
          "slug": "ph-20-40",
          "quantity": 4.352087497711182
        }
      }


Yury Duarte
Engenheiro Agrônomo - ESALQ/USP

_______________________________________________
R-br mailing list
[hidden email]
https://listas.inf.ufpr.br/cgi-bin/mailman/listinfo/r-br
Leia o guia de postagem (http://www.leg.ufpr.br/r-br-guia) e forne�a c�digo m�nimo reproduz�vel.
Reply | Threaded
Open this post in threaded view
|

Re: [R-br] Ler arquivo JSON com diversos outros JSONs dentro dele

R-br mailing list
Oi Yuri,

Tem algum outro sistema que gera esse arquivo para você, ou você tem controle de como ele é gerado?

Não sei se é a solução que você procura, mas talvez colocar [ no início do arquivo e ] no final pode fazer a biblioteca jsonlite reconhecer como uma lista de objetos.

Sds,
Rodrigo

On Mon, Jun 25, 2018 at 2:44 PM Yury Duarte via R-br <[hidden email]> wrote:
Boa tarde colegas listeiros, como vão?

Ultimamente venho encontrando certa dificuldade para trabalhar com arquivos JSON que contém outros JSON dentro deles.
Sempre que precisei trabalhar com esse tipo de arquivo utilizei a expressão:

library(jsonlite)
raiz= ('C:\\Users\\Desktop\\')
a = fromJSON(paste0(raiz,'document.json'))

Dessa forma eu obtenho uma lista e consigo selecionar os valores dos campos que quero.
Mas quando tento aplicar a mesma lógica para um JSON que contém diversos outros JSONs, o código quebra e retorna:
Error in parse_con(txt, bigint_as_char) : parse error: trailing garbage
          99809265137         }       },       {         "_index": "ch
                     (right here) ------^

Meu interesse é acessar apenas as informações de alguns campos desses JSONs e construir uma tabela, onde nas colunas eu terei os campos que desejo e nas linhas eu terei os valores de cada um dos JSONs. 
A seguir, estou colando no corpo da mensagem um pedaço de um desses arquivos que estou tentando lidar no R.

Desde já, agradeço pela ajuda e atenção.

Att


{
        "_index": "busca",
        "_type": "data_point",
        "_id": "interpolation:699646|mgper-0-20|2018-06-22|5x21sxq1km3b",
        "_score": 1,
        "_source": {
          "name": "Mg% 0-20",
          "data_type": "interpolation",
          "attribute": "Mg%",
          "farm_id": 22706,
          "depth": "0-20",
          "location": [
            -48.91500982855756,
            -22.293821593345108
          ],
          "inceres_id": 699646,
          "date_created": "2018-06-22T14:06:13.587631-03:00",
          "slug": "mgper-0-20",
          "quantity": 10.565964698791504
        }
      },
      {
        "_index": "busca",
        "_type": "data_point",
        "_id": "interpolation:701809|ph-20-40|2018-06-22|5x21uc94cc55",
        "_score": 1,
        "_source": {
          "name": "ph 20-40",
          "data_type": "interpolation",
          "attribute": "ph",
          "farm_id": 22706,
          "depth": "20-40",
          "location": [
            -48.90241501215151,
            -22.28980716917012
          ],
          "inceres_id": 701809,
          "date_created": "2018-06-22T14:06:35.183784-03:00",
          "slug": "ph-20-40",
          "quantity": 4.381259918212891
        }
      },
      {
        "_index": "busca",
        "_type": "data_point",
        "_id": "interpolation:699646|mgper-0-20|2018-06-22|5x21sz1rcjp5",
        "_score": 1,
        "_source": {
          "name": "Mg% 0-20",
          "data_type": "interpolation",
          "attribute": "Mg%",
          "farm_id": 22706,
          "depth": "0-20",
          "location": [
            -48.915268161911925,
            -22.289490533842073
          ],
          "inceres_id": 699646,
          "date_created": "2018-06-22T14:06:13.587631-03:00",
          "slug": "mgper-0-20",
          "quantity": 8.669662475585938
        }
      },
      {
        "_index": "busca",
        "_type": "data_point",
        "_id": "interpolation:701809|ph-20-40|2018-06-22|5x21uc3097d7",
        "_score": 1,
        "_source": {
          "name": "ph 20-40",
          "data_type": "interpolation",
          "attribute": "ph",
          "farm_id": 22706,
          "depth": "20-40",
          "location": [
            -48.904161243141765,
            -22.289829735373146
          ],
          "inceres_id": 701809,
          "date_created": "2018-06-22T14:06:35.183784-03:00",
          "slug": "ph-20-40",
          "quantity": 4.352087497711182
        }
      }


Yury Duarte
Engenheiro Agrônomo - ESALQ/USP
_______________________________________________
R-br mailing list
[hidden email]
https://listas.inf.ufpr.br/cgi-bin/mailman/listinfo/r-br
Leia o guia de postagem (http://www.leg.ufpr.br/r-br-guia) e forneça código mínimo reproduzível.

_______________________________________________
R-br mailing list
[hidden email]
https://listas.inf.ufpr.br/cgi-bin/mailman/listinfo/r-br
Leia o guia de postagem (http://www.leg.ufpr.br/r-br-guia) e forne�a c�digo m�nimo reproduz�vel.
Reply | Threaded
Open this post in threaded view
|

Re: [R-br] Ler arquivo JSON com diversos outros JSONs dentro dele

R-br mailing list
Corrigindo: Yury.

Escrevi seu nome errado. Me desculpe.

On Mon, Jun 25, 2018 at 5:19 PM Rodrigo Ângelo <[hidden email]> wrote:
Oi Yuri,

Tem algum outro sistema que gera esse arquivo para você, ou você tem controle de como ele é gerado?

Não sei se é a solução que você procura, mas talvez colocar [ no início do arquivo e ] no final pode fazer a biblioteca jsonlite reconhecer como uma lista de objetos.

Sds,
Rodrigo

On Mon, Jun 25, 2018 at 2:44 PM Yury Duarte via R-br <[hidden email]> wrote:
Boa tarde colegas listeiros, como vão?

Ultimamente venho encontrando certa dificuldade para trabalhar com arquivos JSON que contém outros JSON dentro deles.
Sempre que precisei trabalhar com esse tipo de arquivo utilizei a expressão:

library(jsonlite)
raiz= ('C:\\Users\\Desktop\\')
a = fromJSON(paste0(raiz,'document.json'))

Dessa forma eu obtenho uma lista e consigo selecionar os valores dos campos que quero.
Mas quando tento aplicar a mesma lógica para um JSON que contém diversos outros JSONs, o código quebra e retorna:
Error in parse_con(txt, bigint_as_char) : parse error: trailing garbage
          99809265137         }       },       {         "_index": "ch
                     (right here) ------^

Meu interesse é acessar apenas as informações de alguns campos desses JSONs e construir uma tabela, onde nas colunas eu terei os campos que desejo e nas linhas eu terei os valores de cada um dos JSONs. 
A seguir, estou colando no corpo da mensagem um pedaço de um desses arquivos que estou tentando lidar no R.

Desde já, agradeço pela ajuda e atenção.

Att


{
        "_index": "busca",
        "_type": "data_point",
        "_id": "interpolation:699646|mgper-0-20|2018-06-22|5x21sxq1km3b",
        "_score": 1,
        "_source": {
          "name": "Mg% 0-20",
          "data_type": "interpolation",
          "attribute": "Mg%",
          "farm_id": 22706,
          "depth": "0-20",
          "location": [
            -48.91500982855756,
            -22.293821593345108
          ],
          "inceres_id": 699646,
          "date_created": "2018-06-22T14:06:13.587631-03:00",
          "slug": "mgper-0-20",
          "quantity": 10.565964698791504
        }
      },
      {
        "_index": "busca",
        "_type": "data_point",
        "_id": "interpolation:701809|ph-20-40|2018-06-22|5x21uc94cc55",
        "_score": 1,
        "_source": {
          "name": "ph 20-40",
          "data_type": "interpolation",
          "attribute": "ph",
          "farm_id": 22706,
          "depth": "20-40",
          "location": [
            -48.90241501215151,
            -22.28980716917012
          ],
          "inceres_id": 701809,
          "date_created": "2018-06-22T14:06:35.183784-03:00",
          "slug": "ph-20-40",
          "quantity": 4.381259918212891
        }
      },
      {
        "_index": "busca",
        "_type": "data_point",
        "_id": "interpolation:699646|mgper-0-20|2018-06-22|5x21sz1rcjp5",
        "_score": 1,
        "_source": {
          "name": "Mg% 0-20",
          "data_type": "interpolation",
          "attribute": "Mg%",
          "farm_id": 22706,
          "depth": "0-20",
          "location": [
            -48.915268161911925,
            -22.289490533842073
          ],
          "inceres_id": 699646,
          "date_created": "2018-06-22T14:06:13.587631-03:00",
          "slug": "mgper-0-20",
          "quantity": 8.669662475585938
        }
      },
      {
        "_index": "busca",
        "_type": "data_point",
        "_id": "interpolation:701809|ph-20-40|2018-06-22|5x21uc3097d7",
        "_score": 1,
        "_source": {
          "name": "ph 20-40",
          "data_type": "interpolation",
          "attribute": "ph",
          "farm_id": 22706,
          "depth": "20-40",
          "location": [
            -48.904161243141765,
            -22.289829735373146
          ],
          "inceres_id": 701809,
          "date_created": "2018-06-22T14:06:35.183784-03:00",
          "slug": "ph-20-40",
          "quantity": 4.352087497711182
        }
      }


Yury Duarte
Engenheiro Agrônomo - ESALQ/USP
_______________________________________________
R-br mailing list
[hidden email]
https://listas.inf.ufpr.br/cgi-bin/mailman/listinfo/r-br
Leia o guia de postagem (http://www.leg.ufpr.br/r-br-guia) e forneça código mínimo reproduzível.

_______________________________________________
R-br mailing list
[hidden email]
https://listas.inf.ufpr.br/cgi-bin/mailman/listinfo/r-br
Leia o guia de postagem (http://www.leg.ufpr.br/r-br-guia) e forne�a c�digo m�nimo reproduz�vel.
Reply | Threaded
Open this post in threaded view
|

Re: [R-br] Ler arquivo JSON com diversos outros JSONs dentro dele

R-br mailing list
In reply to this post by R-br mailing list
Olá Rodrigo, como vai?

Tranquilo, normal essa troca de letras no nome!
hehe

Infelizmente não tenho controle sobre o formato das saídas. Elas sempre chegam nesse formato .jason.
Vou tentar utilizar os colchetes no inicio e final do arquivo pra ver o que acontece com a saida.

Mais uma vez, agradeço pela atenção de todos!

Att 

Yury Duarte
Engenheiro Agrônomo - ESALQ/USP

Em 25 de junho de 2018 17:19, Rodrigo Ângelo <[hidden email]> escreveu:
Oi Yuri,

Tem algum outro sistema que gera esse arquivo para você, ou você tem controle de como ele é gerado?

Não sei se é a solução que você procura, mas talvez colocar [ no início do arquivo e ] no final pode fazer a biblioteca jsonlite reconhecer como uma lista de objetos.

Sds,
Rodrigo

On Mon, Jun 25, 2018 at 2:44 PM Yury Duarte via R-br <[hidden email]> wrote:
Boa tarde colegas listeiros, como vão?

Ultimamente venho encontrando certa dificuldade para trabalhar com arquivos JSON que contém outros JSON dentro deles.
Sempre que precisei trabalhar com esse tipo de arquivo utilizei a expressão:

library(jsonlite)
raiz= ('C:\\Users\\Desktop\\')
a = fromJSON(paste0(raiz,'document.json'))

Dessa forma eu obtenho uma lista e consigo selecionar os valores dos campos que quero.
Mas quando tento aplicar a mesma lógica para um JSON que contém diversos outros JSONs, o código quebra e retorna:
Error in parse_con(txt, bigint_as_char) : parse error: trailing garbage
          99809265137         }       },       {         "_index": "ch
                     (right here) ------^

Meu interesse é acessar apenas as informações de alguns campos desses JSONs e construir uma tabela, onde nas colunas eu terei os campos que desejo e nas linhas eu terei os valores de cada um dos JSONs. 
A seguir, estou colando no corpo da mensagem um pedaço de um desses arquivos que estou tentando lidar no R.

Desde já, agradeço pela ajuda e atenção.

Att


{
        "_index": "busca",
        "_type": "data_point",
        "_id": "interpolation:699646|mgper-0-20|2018-06-22|5x21sxq1km3b",
        "_score": 1,
        "_source": {
          "name": "Mg% 0-20",
          "data_type": "interpolation",
          "attribute": "Mg%",
          "farm_id": 22706,
          "depth": "0-20",
          "location": [
            -48.91500982855756,
            -22.293821593345108
          ],
          "inceres_id": 699646,
          "date_created": "2018-06-22T14:06:13.587631-03:00",
          "slug": "mgper-0-20",
          "quantity": 10.565964698791504
        }
      },
      {
        "_index": "busca",
        "_type": "data_point",
        "_id": "interpolation:701809|ph-20-40|2018-06-22|5x21uc94cc55",
        "_score": 1,
        "_source": {
          "name": "ph 20-40",
          "data_type": "interpolation",
          "attribute": "ph",
          "farm_id": 22706,
          "depth": "20-40",
          "location": [
            -48.90241501215151,
            -22.28980716917012
          ],
          "inceres_id": 701809,
          "date_created": "2018-06-22T14:06:35.183784-03:00",
          "slug": "ph-20-40",
          "quantity": 4.381259918212891
        }
      },
      {
        "_index": "busca",
        "_type": "data_point",
        "_id": "interpolation:699646|mgper-0-20|2018-06-22|5x21sz1rcjp5",
        "_score": 1,
        "_source": {
          "name": "Mg% 0-20",
          "data_type": "interpolation",
          "attribute": "Mg%",
          "farm_id": 22706,
          "depth": "0-20",
          "location": [
            -48.915268161911925,
            -22.289490533842073
          ],
          "inceres_id": 699646,
          "date_created": "2018-06-22T14:06:13.587631-03:00",
          "slug": "mgper-0-20",
          "quantity": 8.669662475585938
        }
      },
      {
        "_index": "busca",
        "_type": "data_point",
        "_id": "interpolation:701809|ph-20-40|2018-06-22|5x21uc3097d7",
        "_score": 1,
        "_source": {
          "name": "ph 20-40",
          "data_type": "interpolation",
          "attribute": "ph",
          "farm_id": 22706,
          "depth": "20-40",
          "location": [
            -48.904161243141765,
            -22.289829735373146
          ],
          "inceres_id": 701809,
          "date_created": "2018-06-22T14:06:35.183784-03:00",
          "slug": "ph-20-40",
          "quantity": 4.352087497711182
        }
      }


Yury Duarte
Engenheiro Agrônomo - ESALQ/USP
_______________________________________________
R-br mailing list
[hidden email]
https://listas.inf.ufpr.br/cgi-bin/mailman/listinfo/r-br
Leia o guia de postagem (http://www.leg.ufpr.br/r-br-guia) e forneça código mínimo reproduzível.


_______________________________________________
R-br mailing list
[hidden email]
https://listas.inf.ufpr.br/cgi-bin/mailman/listinfo/r-br
Leia o guia de postagem (http://www.leg.ufpr.br/r-br-guia) e forne�a c�digo m�nimo reproduz�vel.
Reply | Threaded
Open this post in threaded view
|

Re: [R-br] Ler arquivo JSON com diversos outros JSONs dentro dele

R-br mailing list
In reply to this post by R-br mailing list
Rodrigo, 

segundo os testes que fiz, num arquivo com número reduzido de JSONs (testei com 4) dentro de um outro JSON, a solução dos colchetes funcionou e me retornou uma lista com 4 campos, onde cada campo continha as informações de todos os JSONs.
Entretanto, quando apliquei essa mesma lógica para um dos meus arquivos na integra (cada arquivo tem, em média, 200 mil linhas...isso deve dar uns 10 mil JSONs diferentes), o comando me retorna o mesmo erro de antes:
Error in parse_con(txt, bigint_as_char) : 
  parse error: after array element, I expect ',' or ']'
          uantity": 5         } }      },       {         "_index": "c
                     (right here) ------^

Será que existe alguma solução praticável no R para trabalhar com um arquivo dessa magnitude?

Mais uma vez, agradeço a atenção de todos!

Att

Yury Duarte
Engenheiro Agrônomo - ESALQ/USP

Em 25 de junho de 2018 17:21, Rodrigo Ângelo <[hidden email]> escreveu:
Corrigindo: Yury.

Escrevi seu nome errado. Me desculpe.

On Mon, Jun 25, 2018 at 5:19 PM Rodrigo Ângelo <[hidden email]> wrote:
Oi Yuri,

Tem algum outro sistema que gera esse arquivo para você, ou você tem controle de como ele é gerado?

Não sei se é a solução que você procura, mas talvez colocar [ no início do arquivo e ] no final pode fazer a biblioteca jsonlite reconhecer como uma lista de objetos.

Sds,
Rodrigo

On Mon, Jun 25, 2018 at 2:44 PM Yury Duarte via R-br <[hidden email]> wrote:
Boa tarde colegas listeiros, como vão?

Ultimamente venho encontrando certa dificuldade para trabalhar com arquivos JSON que contém outros JSON dentro deles.
Sempre que precisei trabalhar com esse tipo de arquivo utilizei a expressão:

library(jsonlite)
raiz= ('C:\\Users\\Desktop\\')
a = fromJSON(paste0(raiz,'document.json'))

Dessa forma eu obtenho uma lista e consigo selecionar os valores dos campos que quero.
Mas quando tento aplicar a mesma lógica para um JSON que contém diversos outros JSONs, o código quebra e retorna:
Error in parse_con(txt, bigint_as_char) : parse error: trailing garbage
          99809265137         }       },       {         "_index": "ch
                     (right here) ------^

Meu interesse é acessar apenas as informações de alguns campos desses JSONs e construir uma tabela, onde nas colunas eu terei os campos que desejo e nas linhas eu terei os valores de cada um dos JSONs. 
A seguir, estou colando no corpo da mensagem um pedaço de um desses arquivos que estou tentando lidar no R.

Desde já, agradeço pela ajuda e atenção.

Att


{
        "_index": "busca",
        "_type": "data_point",
        "_id": "interpolation:699646|mgper-0-20|2018-06-22|5x21sxq1km3b",
        "_score": 1,
        "_source": {
          "name": "Mg% 0-20",
          "data_type": "interpolation",
          "attribute": "Mg%",
          "farm_id": 22706,
          "depth": "0-20",
          "location": [
            -48.91500982855756,
            -22.293821593345108
          ],
          "inceres_id": 699646,
          "date_created": "2018-06-22T14:06:13.587631-03:00",
          "slug": "mgper-0-20",
          "quantity": 10.565964698791504
        }
      },
      {
        "_index": "busca",
        "_type": "data_point",
        "_id": "interpolation:701809|ph-20-40|2018-06-22|5x21uc94cc55",
        "_score": 1,
        "_source": {
          "name": "ph 20-40",
          "data_type": "interpolation",
          "attribute": "ph",
          "farm_id": 22706,
          "depth": "20-40",
          "location": [
            -48.90241501215151,
            -22.28980716917012
          ],
          "inceres_id": 701809,
          "date_created": "2018-06-22T14:06:35.183784-03:00",
          "slug": "ph-20-40",
          "quantity": 4.381259918212891
        }
      },
      {
        "_index": "busca",
        "_type": "data_point",
        "_id": "interpolation:699646|mgper-0-20|2018-06-22|5x21sz1rcjp5",
        "_score": 1,
        "_source": {
          "name": "Mg% 0-20",
          "data_type": "interpolation",
          "attribute": "Mg%",
          "farm_id": 22706,
          "depth": "0-20",
          "location": [
            -48.915268161911925,
            -22.289490533842073
          ],
          "inceres_id": 699646,
          "date_created": "2018-06-22T14:06:13.587631-03:00",
          "slug": "mgper-0-20",
          "quantity": 8.669662475585938
        }
      },
      {
        "_index": "busca",
        "_type": "data_point",
        "_id": "interpolation:701809|ph-20-40|2018-06-22|5x21uc3097d7",
        "_score": 1,
        "_source": {
          "name": "ph 20-40",
          "data_type": "interpolation",
          "attribute": "ph",
          "farm_id": 22706,
          "depth": "20-40",
          "location": [
            -48.904161243141765,
            -22.289829735373146
          ],
          "inceres_id": 701809,
          "date_created": "2018-06-22T14:06:35.183784-03:00",
          "slug": "ph-20-40",
          "quantity": 4.352087497711182
        }
      }


Yury Duarte
Engenheiro Agrônomo - ESALQ/USP
_______________________________________________
R-br mailing list
[hidden email]
https://listas.inf.ufpr.br/cgi-bin/mailman/listinfo/r-br
Leia o guia de postagem (http://www.leg.ufpr.br/r-br-guia) e forneça código mínimo reproduzível.


_______________________________________________
R-br mailing list
[hidden email]
https://listas.inf.ufpr.br/cgi-bin/mailman/listinfo/r-br
Leia o guia de postagem (http://www.leg.ufpr.br/r-br-guia) e forne�a c�digo m�nimo reproduz�vel.
Reply | Threaded
Open this post in threaded view
|

Re: [R-br] Ler arquivo JSON com diversos outros JSONs dentro dele

R-br mailing list
Yury,

Então eu não sei como faz no R. Talvez outra pessoa da lista possa te ajudar.

Sds,
Rodrigo

On Mon, Jun 25, 2018 at 5:49 PM Yury Duarte <[hidden email]> wrote:
Rodrigo, 

segundo os testes que fiz, num arquivo com número reduzido de JSONs (testei com 4) dentro de um outro JSON, a solução dos colchetes funcionou e me retornou uma lista com 4 campos, onde cada campo continha as informações de todos os JSONs.
Entretanto, quando apliquei essa mesma lógica para um dos meus arquivos na integra (cada arquivo tem, em média, 200 mil linhas...isso deve dar uns 10 mil JSONs diferentes), o comando me retorna o mesmo erro de antes:
Error in parse_con(txt, bigint_as_char) : 
  parse error: after array element, I expect ',' or ']'
          uantity": 5         } }      },       {         "_index": "c
                     (right here) ------^

Será que existe alguma solução praticável no R para trabalhar com um arquivo dessa magnitude?

Mais uma vez, agradeço a atenção de todos!

Att

Yury Duarte
Engenheiro Agrônomo - ESALQ/USP

Em 25 de junho de 2018 17:21, Rodrigo Ângelo <[hidden email]> escreveu:
Corrigindo: Yury.

Escrevi seu nome errado. Me desculpe.

On Mon, Jun 25, 2018 at 5:19 PM Rodrigo Ângelo <[hidden email]> wrote:
Oi Yuri,

Tem algum outro sistema que gera esse arquivo para você, ou você tem controle de como ele é gerado?

Não sei se é a solução que você procura, mas talvez colocar [ no início do arquivo e ] no final pode fazer a biblioteca jsonlite reconhecer como uma lista de objetos.

Sds,
Rodrigo

On Mon, Jun 25, 2018 at 2:44 PM Yury Duarte via R-br <[hidden email]> wrote:
Boa tarde colegas listeiros, como vão?

Ultimamente venho encontrando certa dificuldade para trabalhar com arquivos JSON que contém outros JSON dentro deles.
Sempre que precisei trabalhar com esse tipo de arquivo utilizei a expressão:

library(jsonlite)
raiz= ('C:\\Users\\Desktop\\')
a = fromJSON(paste0(raiz,'document.json'))

Dessa forma eu obtenho uma lista e consigo selecionar os valores dos campos que quero.
Mas quando tento aplicar a mesma lógica para um JSON que contém diversos outros JSONs, o código quebra e retorna:
Error in parse_con(txt, bigint_as_char) : parse error: trailing garbage
          99809265137         }       },       {         "_index": "ch
                     (right here) ------^

Meu interesse é acessar apenas as informações de alguns campos desses JSONs e construir uma tabela, onde nas colunas eu terei os campos que desejo e nas linhas eu terei os valores de cada um dos JSONs. 
A seguir, estou colando no corpo da mensagem um pedaço de um desses arquivos que estou tentando lidar no R.

Desde já, agradeço pela ajuda e atenção.

Att


{
        "_index": "busca",
        "_type": "data_point",
        "_id": "interpolation:699646|mgper-0-20|2018-06-22|5x21sxq1km3b",
        "_score": 1,
        "_source": {
          "name": "Mg% 0-20",
          "data_type": "interpolation",
          "attribute": "Mg%",
          "farm_id": 22706,
          "depth": "0-20",
          "location": [
            -48.91500982855756,
            -22.293821593345108
          ],
          "inceres_id": 699646,
          "date_created": "2018-06-22T14:06:13.587631-03:00",
          "slug": "mgper-0-20",
          "quantity": 10.565964698791504
        }
      },
      {
        "_index": "busca",
        "_type": "data_point",
        "_id": "interpolation:701809|ph-20-40|2018-06-22|5x21uc94cc55",
        "_score": 1,
        "_source": {
          "name": "ph 20-40",
          "data_type": "interpolation",
          "attribute": "ph",
          "farm_id": 22706,
          "depth": "20-40",
          "location": [
            -48.90241501215151,
            -22.28980716917012
          ],
          "inceres_id": 701809,
          "date_created": "2018-06-22T14:06:35.183784-03:00",
          "slug": "ph-20-40",
          "quantity": 4.381259918212891
        }
      },
      {
        "_index": "busca",
        "_type": "data_point",
        "_id": "interpolation:699646|mgper-0-20|2018-06-22|5x21sz1rcjp5",
        "_score": 1,
        "_source": {
          "name": "Mg% 0-20",
          "data_type": "interpolation",
          "attribute": "Mg%",
          "farm_id": 22706,
          "depth": "0-20",
          "location": [
            -48.915268161911925,
            -22.289490533842073
          ],
          "inceres_id": 699646,
          "date_created": "2018-06-22T14:06:13.587631-03:00",
          "slug": "mgper-0-20",
          "quantity": 8.669662475585938
        }
      },
      {
        "_index": "busca",
        "_type": "data_point",
        "_id": "interpolation:701809|ph-20-40|2018-06-22|5x21uc3097d7",
        "_score": 1,
        "_source": {
          "name": "ph 20-40",
          "data_type": "interpolation",
          "attribute": "ph",
          "farm_id": 22706,
          "depth": "20-40",
          "location": [
            -48.904161243141765,
            -22.289829735373146
          ],
          "inceres_id": 701809,
          "date_created": "2018-06-22T14:06:35.183784-03:00",
          "slug": "ph-20-40",
          "quantity": 4.352087497711182
        }
      }


Yury Duarte
Engenheiro Agrônomo - ESALQ/USP
_______________________________________________
R-br mailing list
[hidden email]
https://listas.inf.ufpr.br/cgi-bin/mailman/listinfo/r-br
Leia o guia de postagem (http://www.leg.ufpr.br/r-br-guia) e forneça código mínimo reproduzível.


_______________________________________________
R-br mailing list
[hidden email]
https://listas.inf.ufpr.br/cgi-bin/mailman/listinfo/r-br
Leia o guia de postagem (http://www.leg.ufpr.br/r-br-guia) e forne�a c�digo m�nimo reproduz�vel.
Reply | Threaded
Open this post in threaded view
|

Re: [R-br] Ler arquivo JSON com diversos outros JSONs dentro dele

R-br mailing list
Bom dia, Rodrigo!

Obrigado pelas dicas! 
Vamos aguardar, acredito que logo uma solução irá aparecer. Caso eu encontre uma saída, postarei aqui as linhas de comando que usei.
Se alguém quiser testar na integra o arquivo JSON que estou tentando abrir, segue o link do Google drive para download:
https://drive.google.com/open?id=14TzdtllxDULkG22QVMVNaDWnwLaBPkBj

Mais uma vez, agradeço pela atenção de todos!

Att 

Yury Duarte
Engenheiro Agrônomo - ESALQ/USP

Em 26 de junho de 2018 09:30, Rodrigo Ângelo <[hidden email]> escreveu:
Yury,

Então eu não sei como faz no R. Talvez outra pessoa da lista possa te ajudar.

Sds,
Rodrigo

On Mon, Jun 25, 2018 at 5:49 PM Yury Duarte <[hidden email]> wrote:
Rodrigo, 

segundo os testes que fiz, num arquivo com número reduzido de JSONs (testei com 4) dentro de um outro JSON, a solução dos colchetes funcionou e me retornou uma lista com 4 campos, onde cada campo continha as informações de todos os JSONs.
Entretanto, quando apliquei essa mesma lógica para um dos meus arquivos na integra (cada arquivo tem, em média, 200 mil linhas...isso deve dar uns 10 mil JSONs diferentes), o comando me retorna o mesmo erro de antes:
Error in parse_con(txt, bigint_as_char) : 
  parse error: after array element, I expect ',' or ']'
          uantity": 5         } }      },       {         "_index": "c
                     (right here) ------^

Será que existe alguma solução praticável no R para trabalhar com um arquivo dessa magnitude?

Mais uma vez, agradeço a atenção de todos!

Att

Yury Duarte
Engenheiro Agrônomo - ESALQ/USP

Em 25 de junho de 2018 17:21, Rodrigo Ângelo <[hidden email]> escreveu:
Corrigindo: Yury.

Escrevi seu nome errado. Me desculpe.

On Mon, Jun 25, 2018 at 5:19 PM Rodrigo Ângelo <[hidden email]> wrote:
Oi Yuri,

Tem algum outro sistema que gera esse arquivo para você, ou você tem controle de como ele é gerado?

Não sei se é a solução que você procura, mas talvez colocar [ no início do arquivo e ] no final pode fazer a biblioteca jsonlite reconhecer como uma lista de objetos.

Sds,
Rodrigo

On Mon, Jun 25, 2018 at 2:44 PM Yury Duarte via R-br <[hidden email]> wrote:
Boa tarde colegas listeiros, como vão?

Ultimamente venho encontrando certa dificuldade para trabalhar com arquivos JSON que contém outros JSON dentro deles.
Sempre que precisei trabalhar com esse tipo de arquivo utilizei a expressão:

library(jsonlite)
raiz= ('C:\\Users\\Desktop\\')
a = fromJSON(paste0(raiz,'document.json'))

Dessa forma eu obtenho uma lista e consigo selecionar os valores dos campos que quero.
Mas quando tento aplicar a mesma lógica para um JSON que contém diversos outros JSONs, o código quebra e retorna:
Error in parse_con(txt, bigint_as_char) : parse error: trailing garbage
          99809265137         }       },       {         "_index": "ch
                     (right here) ------^

Meu interesse é acessar apenas as informações de alguns campos desses JSONs e construir uma tabela, onde nas colunas eu terei os campos que desejo e nas linhas eu terei os valores de cada um dos JSONs. 
A seguir, estou colando no corpo da mensagem um pedaço de um desses arquivos que estou tentando lidar no R.

Desde já, agradeço pela ajuda e atenção.

Att


{
        "_index": "busca",
        "_type": "data_point",
        "_id": "interpolation:699646|mgper-0-20|2018-06-22|5x21sxq1km3b",
        "_score": 1,
        "_source": {
          "name": "Mg% 0-20",
          "data_type": "interpolation",
          "attribute": "Mg%",
          "farm_id": 22706,
          "depth": "0-20",
          "location": [
            -48.91500982855756,
            -22.293821593345108
          ],
          "inceres_id": 699646,
          "date_created": "2018-06-22T14:06:13.587631-03:00",
          "slug": "mgper-0-20",
          "quantity": 10.565964698791504
        }
      },
      {
        "_index": "busca",
        "_type": "data_point",
        "_id": "interpolation:701809|ph-20-40|2018-06-22|5x21uc94cc55",
        "_score": 1,
        "_source": {
          "name": "ph 20-40",
          "data_type": "interpolation",
          "attribute": "ph",
          "farm_id": 22706,
          "depth": "20-40",
          "location": [
            -48.90241501215151,
            -22.28980716917012
          ],
          "inceres_id": 701809,
          "date_created": "2018-06-22T14:06:35.183784-03:00",
          "slug": "ph-20-40",
          "quantity": 4.381259918212891
        }
      },
      {
        "_index": "busca",
        "_type": "data_point",
        "_id": "interpolation:699646|mgper-0-20|2018-06-22|5x21sz1rcjp5",
        "_score": 1,
        "_source": {
          "name": "Mg% 0-20",
          "data_type": "interpolation",
          "attribute": "Mg%",
          "farm_id": 22706,
          "depth": "0-20",
          "location": [
            -48.915268161911925,
            -22.289490533842073
          ],
          "inceres_id": 699646,
          "date_created": "2018-06-22T14:06:13.587631-03:00",
          "slug": "mgper-0-20",
          "quantity": 8.669662475585938
        }
      },
      {
        "_index": "busca",
        "_type": "data_point",
        "_id": "interpolation:701809|ph-20-40|2018-06-22|5x21uc3097d7",
        "_score": 1,
        "_source": {
          "name": "ph 20-40",
          "data_type": "interpolation",
          "attribute": "ph",
          "farm_id": 22706,
          "depth": "20-40",
          "location": [
            -48.904161243141765,
            -22.289829735373146
          ],
          "inceres_id": 701809,
          "date_created": "2018-06-22T14:06:35.183784-03:00",
          "slug": "ph-20-40",
          "quantity": 4.352087497711182
        }
      }


Yury Duarte
Engenheiro Agrônomo - ESALQ/USP
_______________________________________________
R-br mailing list
[hidden email]
https://listas.inf.ufpr.br/cgi-bin/mailman/listinfo/r-br
Leia o guia de postagem (http://www.leg.ufpr.br/r-br-guia) e forneça código mínimo reproduzível.



_______________________________________________
R-br mailing list
[hidden email]
https://listas.inf.ufpr.br/cgi-bin/mailman/listinfo/r-br
Leia o guia de postagem (http://www.leg.ufpr.br/r-br-guia) e forne�a c�digo m�nimo reproduz�vel.
Reply | Threaded
Open this post in threaded view
|

[R-br] Criando variáveis

R-br mailing list
In reply to this post by R-br mailing list
Prezados, tenho um conjunto de dados como segue abaixo:

dados<-structure(list(IndicatorName = structure(c(323L, 713L, 713L,
55L, 185L, 293L, 291L, 832L, 834L, 720L, 715L, 186L, 710L, 294L,
735L, 323L, 187L, 55L, 49L, 1112L, 414L, 944L, 709L, 715L, 723L
), .Label = c("2005 PPP conversion factor, GDP (LCU per international $)",
"2005 PPP conversion factor, private consumption (LCU per international
$)",
"Access to electricity (% of population)", "Access to electricity, rural
(% of rural population)",
"Access to electricity, urban (% of urban population)", "Access to
non-solid fuel (% of population)",
"Access to non-solid fuel, rural (% of rural population)", "Access to
non-solid fuel, urban (% of urban population)",
"Adequacy of social insurance programs (% of total welfare of
beneficiary households)",
"Adequacy of social protection and labor programs (% of total welfare of
beneficiary households)",
"Adequacy of social safety net programs (% of total welfare of
beneficiary households)",
"Adequacy of unemployment benefits and ALMP (% of total welfare of
beneficiary households)",
"Adjusted net enrolment rate, primary, both sexes (%)", "Adjusted net
enrolment rate, primary, female (%)",
"Adjusted net enrolment rate, primary, male (%)", "Adjusted net national
income (annual % growth)",
"Adjusted net national income (constant 2005 US$)", "Adjusted net
national income (current US$)",
"Adjusted net national income per capita (annual % growth)",
"Adjusted net national income per capita (constant 2005 US$)",
"Adjusted net national income per capita (current US$)", "Adjusted net
savings, excluding particulate emission damage (% of GNI)",
"Adjusted net savings, excluding particulate emission damage (current
US$)",
"Adjusted net savings, including particulate emission damage (% of GNI)",
"Adjusted net savings, including particulate emission damage (current
US$)",
"Adjusted savings: carbon dioxide damage (% of GNI)", "Adjusted savings:
carbon dioxide damage (current US$)",
"Adjusted savings: consumption of fixed capital (% of GNI)",
"Adjusted savings: consumption of fixed capital (current US$)",
"Adjusted savings: education expenditure (% of GNI)", "Adjusted savings:
education expenditure (current US$)",
"Adjusted savings: energy depletion (% of GNI)", "Adjusted savings:
energy depletion (current US$)",
"Adjusted savings: gross savings (% of GNI)", "Adjusted savings: mineral
depletion (% of GNI)",
"Adjusted savings: mineral depletion (current US$)", "Adjusted savings:
natural resources depletion (% of GNI)",
"Adjusted savings: net forest depletion (% of GNI)", "Adjusted savings:
net forest depletion (current US$)",
"Adjusted savings: net national savings (% of GNI)", "Adjusted savings:
net national savings (current US$)",
"Adjusted savings: particulate emission damage (% of GNI)", "Adjusted
savings: particulate emission damage (current US$)",
"Adolescent fertility rate (births per 1,000 women ages 15-19)",
"Adult literacy rate, population 15+ years, both sexes (%)",
"Adult literacy rate, population 15+ years, female (%)", "Adult literacy
rate, population 15+ years, male (%)",
"Age dependency ratio (% of working-age population)", "Age dependency
ratio, old (% of working-age population)",
"Age dependency ratio, young (% of working-age population)",
"Agricultural irrigated land (% of total agricultural land)",
"Agricultural land (% of land area)", "Agricultural land (sq. km)",
"Agricultural machinery, tractors", "Agricultural machinery, tractors
per 100 sq. km of arable land",
"Agricultural methane emissions (% of total)", "Agricultural methane
emissions (thousand metric tons of CO2 equivalent)",
"Agricultural nitrous oxide emissions (% of total)", "Agricultural
nitrous oxide emissions (thousand metric tons of CO2 equivalent)",
"Agricultural raw materials exports (% of merchandise exports)",
"Agricultural raw materials imports (% of merchandise imports)",
"Agriculture value added per worker (constant 2005 US$)", "Agriculture,
value added (% of GDP)",
"Agriculture, value added (annual % growth)", "Agriculture, value added
(constant 2005 US$)",
"Agriculture, value added (constant LCU)", "Agriculture, value added
(current LCU)",
"Agriculture, value added (current US$)", "Air transport, freight
(million ton-km)",
"Air transport, passengers carried", "Air transport, registered carrier
departures worldwide",
"All education staff compensation, primary (% of total expenditure in
primary public institutions)",
"All education staff compensation, secondary (% of total expenditure in
secondary public institutions)",
"All education staff compensation, tertiary (% of total expenditure in
tertiary public institutions)",
"All education staff compensation, total (% of total expenditure in
public institutions)",
"Alternative and nuclear energy (% of total energy use)", "Annual
freshwater withdrawals, agriculture (% of total freshwater withdrawal)",
"Annual freshwater withdrawals, domestic (% of total freshwater
withdrawal)",
"Annual freshwater withdrawals, industry (% of total freshwater
withdrawal)",
"Annual freshwater withdrawals, total (% of internal resources)",
"Annual freshwater withdrawals, total (billion cubic meters)",
"Annualized average growth rate in per capita real survey mean
consumption or income, bottom 40% of population (%)",
"Annualized average growth rate in per capita real survey mean
consumption or income, total population (%)",
"Arable land (% of land area)", "Arable land (hectares per person)",
"Arable land (hectares)", "Armed forces personnel (% of total labor
force)",
"Armed forces personnel, total", "Arms exports (SIPRI trend indicator
values)",
"Arms imports (SIPRI trend indicator values)", "Automated teller
machines (ATMs) (per 100,000 adults)",
"Average grace period on new external debt commitments (years)",
"Average grace period on new external debt commitments, official (years)",
"Average grace period on new external debt commitments, private (years)",
"Average grant element on new external debt commitments (%)",
"Average grant element on new external debt commitments, official (%)",
"Average grant element on new external debt commitments, private (%)",
"Average interest on new external debt commitments (%)", "Average
interest on new external debt commitments, official (%)",
"Average interest on new external debt commitments, private (%)",
"Average maturity on new external debt commitments (years)",
"Average maturity on new external debt commitments, official (years)",
"Average maturity on new external debt commitments, private (years)",
"Average precipitation in depth (mm per year)", "Average time to clear
exports through customs (days)",
"Average working hours of children, study and work, ages 7-14 (hours per
week)",
"Average working hours of children, study and work, female, ages 7-14
(hours per week)",
"Average working hours of children, study and work, male, ages 7-14
(hours per week)",
"Average working hours of children, working only, ages 7-14 (hours per
week)",
"Average working hours of children, working only, female, ages 7-14
(hours per week)",
"Average working hours of children, working only, male, ages 7-14 (hours
per week)",
"Bank capital to assets ratio (%)", "Bank liquid reserves to bank assets
ratio (%)",
"Bank nonperforming loans to total gross loans (%)", "Battle-related
deaths (number of people)",
"Benefits incidence in poorest quintile (%) - All Labor Market",
"Benefits incidence in poorest quintile (%) - All Social Assistance",
"Benefits incidence in poorest quintile (%) - All Social Insurance",
"Benefits incidence in poorest quintile (%) -All Social Protection and
Labor",
"Binding coverage, all products (%)", "Binding coverage, manufactured
products (%)",
"Binding coverage, primary products (%)", "Bird species, threatened",
"Birth rate, crude (per 1,000 people)", "Births attended by skilled
health staff (% of total)",
"Borrowers from commercial banks (per 1,000 adults)", "Bound rate,
simple mean, all products (%)",
"Bound rate, simple mean, manufactured products (%)", "Bound rate,
simple mean, primary products (%)",
"Bribery incidence (% of firms experiencing at least one bribe payment
request)",
"Broad money (% of GDP)", "Broad money (current LCU)", "Broad money
growth (annual %)",
"Broad money to total reserves ratio", "Burden of customs procedure, WEF
(1=extremely inefficient to 7=extremely efficient)",
"Business extent of disclosure index (0=less disclosure to 10=more
disclosure)",
"Cash surplus/deficit (% of GDP)", "Cash surplus/deficit (current LCU)",
"Cause of death, by communicable diseases and maternal, prenatal and
nutrition conditions (% of total)",
"Cause of death, by injury (% of total)", "Cause of death, by
non-communicable diseases (% of total)",
"Central government debt, total (% of GDP)", "Central government debt,
total (current LCU)",
"Cereal production (metric tons)", "Cereal yield (kg per hectare)",
"Changes in inventories (constant LCU)", "Changes in inventories
(current LCU)",
"Changes in inventories (current US$)", "Charges for the use of
intellectual property, payments (BoP, current US$)",
"Charges for the use of intellectual property, receipts (BoP, current
US$)",
"Chemicals (% of value added in manufacturing)", "Child employment in
agriculture (% of economically active children ages 7-14)",
"Child employment in agriculture, female (% of female economically
active children ages 7-14)",
"Child employment in agriculture, male (% of male economically active
children ages 7-14)",
"Child employment in manufacturing (% of economically active children
ages 7-14)",
"Child employment in manufacturing, female (% of female economically
active children ages 7-14)",
"Child employment in manufacturing, male (% of male economically active
children ages 7-14)",
"Child employment in services (% of economically active children ages
7-14)",
"Child employment in services, female (% of female economically active
children ages 7-14)",
"Child employment in services, male (% of male economically active
children ages 7-14)",
"Children in employment, female (% of female children ages 7-14)",
"Children in employment, male (% of male children ages 7-14)",
"Children in employment, self-employed (% of children in employment,
ages 7-14)",
"Children in employment, self-employed, female (% of female children in
employment, ages 7-14)",
"Children in employment, self-employed, male (% of male children in
employment, ages 7-14)",
"Children in employment, study and work (% of children in employment,
ages 7-14)",
"Children in employment, study and work, female (% of female children in
employment, ages 7-14)",
"Children in employment, study and work, male (% of male children in
employment, ages 7-14)",
"Children in employment, total (% of children ages 7-14)", "Children in
employment, unpaid family workers (% of children in employment, ages
7-14)",
"Children in employment, unpaid family workers, female (% of female
children in employment, ages 7-14)",
"Children in employment, unpaid family workers, male (% of male children
in employment, ages 7-14)",
"Children in employment, work only (% of children in employment, ages
7-14)",
"Children in employment, work only, female (% of female children in
employment, ages 7-14)",
"Children in employment, work only, male (% of male children in
employment, ages 7-14)",
"Claims on central government (annual growth as % of broad money)",
"Claims on central government, etc. (% GDP)", "Claims on other sectors
of the domestic economy (% of GDP)",
"Claims on other sectors of the domestic economy (annual growth as % of
broad money)",
"Claims on private sector (annual growth as % of broad money)",
"CO2 emissions (kg per 2005 US$ of GDP)", "CO2 emissions (kg per 2011
PPP $ of GDP)",
"CO2 emissions (kg per PPP $ of GDP)", "CO2 emissions (kt)",
"CO2 emissions (metric tons per capita)", "CO2 emissions from
electricity and heat production, total (% of total fuel combustion)",
"CO2 emissions from gaseous fuel consumption (% of total)", "CO2
emissions from gaseous fuel consumption (kt)",
"CO2 emissions from liquid fuel consumption (% of total)", "CO2
emissions from liquid fuel consumption (kt)",
"CO2 emissions from manufacturing industries and construction (% of
total fuel combustion)",
"CO2 emissions from other sectors, excluding residential buildings and
commercial and public services (% of total fuel combustion)",
"CO2 emissions from residential buildings and commercial and public
services (% of total fuel combustion)",
"CO2 emissions from solid fuel consumption (% of total)", "CO2 emissions
from solid fuel consumption (kt)",
"CO2 emissions from transport (% of total fuel combustion)",
"CO2 intensity (kg per kg of oil equivalent energy use)", "Coal rents (%
of GDP)",
"Combustible renewables and waste (% of total energy)", "Commercial bank
branches (per 100,000 adults)",
"Commercial banks and other lending (PPG + PNG) (NFL, current US$)",
"Commercial service exports (current US$)", "Commercial service imports
(current US$)",
"Commitments, IBRD (COM, current US$)", "Commitments, IDA (COM, current
US$)",
"Commitments, official creditors (COM, current US$)", "Commitments,
private creditors (COM, current US$)",
"Commitments, public and publicly guaranteed (COM, current US$)",
"Communications, computer, etc. (% of service exports, BoP)",
"Communications, computer, etc. (% of service imports, BoP)",
"Community health workers (per 1,000 people)", "Compensation of
employees (% of expense)",
"Compensation of employees (current LCU)", "Completeness of birth
registration (%)",
"Completeness of death registration with cause-of-death information (%)",
"Completeness of infant death reporting (% of reported infant deaths to
estimated infant deaths)",
"Completeness of total death reporting (% of reported total deaths to
estimated total deaths)",
"Computer, communications and other services (% of commercial service
exports)",
"Computer, communications and other services (% of commercial service
imports)",
"Concessional debt (% of total external debt)", "Consumer price index
(2010 = 100)",
"Consumption of iodized salt (% of households)", "Container port traffic
(TEU: 20 foot equivalent units)",
"Contraceptive prevalence (% of women ages 15-49)", "Contributing family
workers, female (% of females employed)",
"Contributing family workers, male (% of males employed)", "Contributing
family workers, total (% of total employed)",
"Cost of business start-up procedures (% of GNI per capita)",
"Cost to export (US$ per container)", "Cost to import (US$ per container)",
"Coverage (%) - All Labor Market", "Coverage (%) - All Social Assistance",
"Coverage (%) - All Social Insurance", "Coverage (%) -All Social
Protection and Labor",
"Crop production index (2004-2006 = 100)", "Currency composition of PPG
debt, all other currencies (%)",
"Currency composition of PPG debt, Deutsche mark (%)", "Currency
composition of PPG debt, Euro (%)",
"Currency composition of PPG debt, French franc (%)", "Currency
composition of PPG debt, Japanese yen (%)",
"Currency composition of PPG debt, Multiple currencies (%)",
"Currency composition of PPG debt, Pound sterling (%)", "Currency
composition of PPG debt, SDR (%)",
"Currency composition of PPG debt, Swiss franc (%)", "Currency
composition of PPG debt, U.S. dollars (%)",
"Current account balance (% of GDP)", "Current account balance (BoP,
current US$)",
"Current education expenditure, primary (% of total expenditure in
primary public institutions)",
"Current education expenditure, secondary (% of total expenditure in
secondary public institutions)",
"Current education expenditure, tertiary (% of total expenditure in
tertiary public institutions)",
"Current education expenditure, total (% of total expenditure in public
institutions)",
"Customs and other import duties (% of tax revenue)", "Customs and other
import duties (current LCU)",
"Death rate, crude (per 1,000 people)", "Debt buyback (current US$)",
"Debt forgiveness grants (current US$)", "Debt forgiveness or reduction
(current US$)",
"Debt service (PPG and IMF only, % of exports of goods, services and
primary income)",
"Debt service on external debt, long-term (TDS, current US$)",
"Debt service on external debt, private nonguaranteed (PNG) (TDS,
current US$)",
"Debt service on external debt, public and publicly guaranteed (PPG)
(TDS, current US$)",
"Debt service on external debt, total (TDS, current US$)", "Debt stock
reduction (current US$)",
"Debt stock rescheduled (current US$)", "DEC alternative conversion
factor (LCU per US$)",
"Delay in obtaining an electrical connection (days)", "Deposit interest
rate (%)",
"Depositors with commercial banks (per 1,000 adults)", "Depth of credit
information index (0=low to 8=high)",
"Diabetes prevalence (% of population ages 20 to 79)", "Diarrhea
treatment (% of children under 5 who received ORS packet)",
"Disaster risk reduction progress score (1-5 scale; 5=best)",
"Disbursements on external debt, long-term (DIS, current US$)",
"Disbursements on external debt, long-term + IMF (DIS, current US$)",
"Disbursements on external debt, private nonguaranteed (PNG) (DIS,
current US$)",
"Disbursements on external debt, public and publicly guaranteed (PPG)
(DIS, current US$)",
"Discrepancy in expenditure estimate of GDP (constant LCU)",
"Discrepancy in expenditure estimate of GDP (current LCU)", "Distance to
frontier score (0=lowest performance to 100=frontier)",
"Documents to export (number)", "Documents to import (number)",
"Domestic credit provided by financial sector (% of GDP)", "Domestic
credit to private sector (% of GDP)",
"Domestic credit to private sector by banks (% of GDP)", "Droughts,
floods, extreme temperatures (% of population, average 1990-2009)",
"Ease of doing business index (1=most business-friendly regulations)",
"EBRD, private nonguaranteed (NFL, current US$)", "Electric power
consumption (kWh per capita)",
"Electric power transmission and distribution losses (% of output)",
"Electricity production from coal sources (% of total)", "Electricity
production from hydroelectric sources (% of total)",
"Electricity production from natural gas sources (% of total)",
"Electricity production from nuclear sources (% of total)", "Electricity
production from oil sources (% of total)",
"Electricity production from oil, gas and coal sources (% of total)",
"Electricity production from renewable sources, excluding hydroelectric
(% of total)",
"Electricity production from renewable sources, excluding hydroelectric
(kWh)",
"Emigration rate of tertiary educated (% of total tertiary educated
population)",
"Employers, female (% of employment)", "Employers, male (% of employment)",
"Employers, total (% of employment)", "Employment in agriculture (% of
total employment)",
"Employment in agriculture, female (% of female employment)",
"Employment in agriculture, male (% of male employment)", "Employment in
industry (% of total employment)",
"Employment in industry, female (% of female employment)", "Employment
in industry, male (% of male employment)",
"Employment in services (% of total employment)", "Employment in
services, female (% of female employment)",
"Employment in services, male (% of male employment)", "Employment to
population ratio, 15+, female (%) (modeled ILO estimate)",
"Employment to population ratio, 15+, female (%) (national estimate)",
"Employment to population ratio, 15+, male (%) (modeled ILO estimate)",
"Employment to population ratio, 15+, male (%) (national estimate)",
"Employment to population ratio, 15+, total (%) (modeled ILO estimate)",
"Employment to population ratio, 15+, total (%) (national estimate)",
"Employment to population ratio, ages 15-24, female (%) (modeled ILO
estimate)",
"Employment to population ratio, ages 15-24, female (%) (national
estimate)",
"Employment to population ratio, ages 15-24, male (%) (modeled ILO
estimate)",
"Employment to population ratio, ages 15-24, male (%) (national estimate)",
"Employment to population ratio, ages 15-24, total (%) (modeled ILO
estimate)",
"Employment to population ratio, ages 15-24, total (%) (national
estimate)",
"Energy imports, net (% of energy use)", "Energy intensity level of
primary energy (MJ/$2011 PPP GDP)",
"Energy related methane emissions (% of total)", "Energy use (kg of oil
equivalent per capita)",
"Energy use (kg of oil equivalent) per $1,000 GDP (constant 2011 PPP)",
"Enrolment in primary education, both sexes (number)", "Enrolment in
secondary education, both sexes (number)",
"Enrolment in secondary general, both sexes (number)", "Enrolment in
secondary vocational, both sexes (number)",
"Exclusive breastfeeding (% of children under 6 months)", "Expenditure
on education as % of total government expenditure (%)",
"Expenditure on primary as % of government expenditure on education (%)",
"Expenditure on secondary as % of government expenditure on education (%)",
"Expenditure on tertiary as % of government expenditure on education (%)",
"Expense (% of GDP)", "Expense (current LCU)", "Export value index (2000
= 100)",
"Export volume index (2000 = 100)", "Exports as a capacity to import
(constant LCU)",
"Exports of goods and services (% of GDP)", "Exports of goods and
services (annual % growth)",
"Exports of goods and services (BoP, current US$)", "Exports of goods
and services (constant 2005 US$)",
"Exports of goods and services (constant LCU)", "Exports of goods and
services (current LCU)",
"Exports of goods and services (current US$)", "Exports of goods,
services and primary income (BoP, current US$)",
"External balance on goods and services (% of GDP)", "External balance
on goods and services (constant LCU)",
"External balance on goods and services (current LCU)", "External
balance on goods and services (current US$)",
"External debt stocks (% of exports of goods, services and primary
income)",
"External debt stocks (% of GNI)", "External debt stocks, concessional
(DOD, current US$)",
"External debt stocks, long-term (DOD, current US$)", "External debt
stocks, long-term private sector (DOD, current US$)",
"External debt stocks, long-term public sector (DOD, current US$)",
"External debt stocks, private nonguaranteed (PNG) (DOD, current US$)",
"External debt stocks, public and publicly guaranteed (PPG) (DOD,
current US$)",
"External debt stocks, short-term (DOD, current US$)", "External debt
stocks, total (DOD, current US$)",
"External debt stocks, variable rate (DOD, current US$)", "External
resources for health (% of total expenditure on health)",
"Female legislators, senior officials and managers (% of total)",
"Fertility rate, total (births per woman)", "Fertilizer consumption (%
of fertilizer production)",
"Fertilizer consumption (kilograms per hectare of arable land)",
"Final consumption expenditure (constant 2005 US$)", "Final consumption
expenditure (constant LCU)",
"Final consumption expenditure (current LCU)", "Final consumption
expenditure (current US$)",
"Final consumption expenditure, etc. (% of GDP)", "Final consumption
expenditure, etc. (annual % growth)",
"Final consumption expenditure, etc. (constant 2005 US$)", "Final
consumption expenditure, etc. (constant LCU)",
"Final consumption expenditure, etc. (current LCU)", "Final consumption
expenditure, etc. (current US$)",
"Firms competing against unregistered firms (% of firms)", "Firms
expected to give gifts in meetings with tax officials (% of firms)",
"Firms formally registered when operations started (% of firms)",
"Firms offering formal training (% of firms)", "Firms that do not report
all sales for tax purposes (% of firms)",
"Firms using banks to finance investment (% of firms)", "Firms using
banks to finance working capital (% of firms)",
"Firms with female participation in ownership (% of firms)",
"Firms with female top manager (% of firms)", "Fish species, threatened",
"Fixed broadband subscriptions", "Fixed broadband subscriptions (per 100
people)",
"Fixed telephone subscriptions", "Fixed telephone subscriptions (per 100
people)",
"Food exports (% of merchandise exports)", "Food imports (% of
merchandise imports)",
"Food production index (2004-2006 = 100)", "Food, beverages and tobacco
(% of value added in manufacturing)",
"Foreign direct investment, net (BoP, current US$)", "Foreign direct
investment, net inflows (% of GDP)",
"Foreign direct investment, net inflows (BoP, current US$)",
"Foreign direct investment, net outflows (% of GDP)", "Forest area (% of
land area)",
"Forest area (sq. km)", "Forest rents (% of GDP)", "Fossil fuel energy
consumption (% of total)",
"Fuel exports (% of merchandise exports)", "Fuel imports (% of
merchandise imports)",
"GDP (constant LCU)", "GDP (current LCU)", "GDP at market prices
(constant 2005 US$)",
"GDP at market prices (current US$)", "GDP deflator (base year varies by
country)",
"GDP growth (annual %)", "GDP per capita (constant 2005 US$)",
"GDP per capita (constant LCU)", "GDP per capita (current LCU)",
"GDP per capita (current US$)", "GDP per capita growth (annual %)",
"GDP per capita, PPP (constant 2011 international $)", "GDP per capita,
PPP (current international $)",
"GDP per person employed (constant 1990 PPP $)", "GDP per unit of energy
use (constant 2011 PPP $ per kg of oil equivalent)",
"GDP per unit of energy use (PPP $ per kg of oil equivalent)",
"GDP, PPP (constant 2011 international $)", "GDP, PPP (current
international $)",
"GEF benefits index for biodiversity (0 = no biodiversity potential to
100 = maximum)",
"General government final consumption expenditure (% of GDP)",
"General government final consumption expenditure (annual % growth)",
"General government final consumption expenditure (constant 2005 US$)",
"General government final consumption expenditure (constant LCU)",
"General government final consumption expenditure (current LCU)",
"General government final consumption expenditure (current US$)",
"GHG net emissions/removals by LUCF (Mt of CO2 equivalent)",
"GINI index (World Bank estimate)", "GNI (constant 2005 US$)",
"GNI (constant LCU)", "GNI (current LCU)", "GNI (current US$)",
"GNI growth (annual %)", "GNI per capita (constant 2005 US$)",
"GNI per capita (constant LCU)", "GNI per capita (current LCU)",
"GNI per capita growth (annual %)", "GNI per capita, Atlas method
(current US$)",
"GNI per capita, PPP (constant 2011 international $)", "GNI per capita,
PPP (current international $)",
"GNI, Atlas method (current US$)", "GNI, PPP (constant 2011
international $)",
"GNI, PPP (current international $)", "Goods and services expense (% of
expense)",
"Goods and services expense (current LCU)", "Goods exports (BoP, current
US$)",
"Goods imports (BoP, current US$)", "Government expenditure on education
as % of GDP (%)",
"Government expenditure per primary student as % of GDP per capita (%)",
"Government expenditure per secondary student as % of GDP per capita (%)",
"Government expenditure per tertiary student as % of GDP per capita (%)",
"Grants and other revenue (% of revenue)", "Grants and other revenue
(current LCU)",
"Grants, excluding technical cooperation (BoP, current US$)",
"Gross capital formation (% of GDP)", "Gross capital formation (annual %
growth)",
"Gross capital formation (constant 2005 US$)", "Gross capital formation
(constant LCU)",
"Gross capital formation (current LCU)", "Gross capital formation
(current US$)",
"Gross domestic income (constant 2005 US$)", "Gross domestic income
(constant LCU)",
"Gross domestic savings (% of GDP)", "Gross domestic savings (constant
LCU)",
"Gross domestic savings (current LCU)", "Gross domestic savings (current
US$)",
"Gross enrolment ratio, pre-primary, both sexes (%)", "Gross enrolment
ratio, pre-primary, female (%)",
"Gross enrolment ratio, pre-primary, male (%)", "Gross enrolment ratio,
primary and secondary, gender parity index (GPI)",
"Gross enrolment ratio, primary, both sexes (%)", "Gross enrolment
ratio, primary, female (%)",
"Gross enrolment ratio, primary, gender parity index (GPI)",
"Gross enrolment ratio, primary, male (%)", "Gross enrolment ratio,
secondary, both sexes (%)",
"Gross enrolment ratio, secondary, female (%)", "Gross enrolment ratio,
secondary, gender parity index (GPI)",
"Gross enrolment ratio, secondary, male (%)", "Gross enrolment ratio,
tertiary, both sexes (%)",
"Gross enrolment ratio, tertiary, female (%)", "Gross enrolment ratio,
tertiary, gender parity index (GPI)",
"Gross enrolment ratio, tertiary, male (%)", "Gross fixed capital
formation (% of GDP)",
"Gross fixed capital formation (annual % growth)", "Gross fixed capital
formation (constant 2005 US$)",
"Gross fixed capital formation (constant LCU)", "Gross fixed capital
formation (current LCU)",
"Gross fixed capital formation (current US$)", "Gross fixed capital
formation, private sector (% of GDP)",
"Gross fixed capital formation, private sector (current LCU)",
"Gross intake ratio to Grade 1 of primary education, both sexes (%)",
"Gross intake ratio to Grade 1 of primary education, female (%)",
"Gross intake ratio to Grade 1 of primary education, male (%)",
"Gross national expenditure (% of GDP)", "Gross national expenditure
(constant 2005 US$)",
"Gross national expenditure (constant LCU)", "Gross national expenditure
(current LCU)",
"Gross national expenditure (current US$)", "Gross national expenditure
deflator (base year varies by country)",
"Gross savings (% of GDP)", "Gross savings (% of GNI)", "Gross savings
(current LCU)",
"Gross savings (current US$)", "Gross value added at factor cost
(constant 2005 US$)",
"Gross value added at factor cost (constant LCU)", "Gross value added at
factor cost (current LCU)",
"Gross value added at factor cost (current US$)", "Health expenditure
per capita (current US$)",
"Health expenditure per capita, PPP (constant 2011 international $)",
"Health expenditure, private (% of GDP)", "Health expenditure, public (%
of GDP)",
"Health expenditure, public (% of government expenditure)", "Health
expenditure, public (% of total health expenditure)",
"Health expenditure, total (% of GDP)", "HFC gas emissions (thousand
metric tons of CO2 equivalent)",
"High-technology exports (% of manufactured exports)", "High-technology
exports (current US$)",
"Hospital beds (per 1,000 people)", "Household final consumption
expenditure (annual % growth)",
"Household final consumption expenditure (constant 2005 US$)",
"Household final consumption expenditure (constant LCU)", "Household
final consumption expenditure (current LCU)",
"Household final consumption expenditure (current US$)", "Household
final consumption expenditure per capita (constant 2005 US$)",
"Household final consumption expenditure per capita growth (annual %)",
"Household final consumption expenditure, etc. (% of GDP)", "Household
final consumption expenditure, etc. (annual % growth)",
"Household final consumption expenditure, etc. (constant 2005 US$)",
"Household final consumption expenditure, etc. (constant LCU)",
"Household final consumption expenditure, etc. (current LCU)",
"Household final consumption expenditure, etc. (current US$)",
"Household final consumption expenditure, PPP (constant 2011
international $)",
"Household final consumption expenditure, PPP (current international $)",
"IBRD loans and IDA credits (DOD, current US$)", "ICT goods exports (%
of total goods exports)",
"ICT goods imports (% total goods imports)", "ICT service exports (% of
service exports, BoP)",
"ICT service exports (BoP, current US$)", "IDA grants (current US$)",
"IFC, private nonguaranteed (NFL, current US$)", "IMF charges (INT,
current US$)",
"IMF purchases (DIS, current US$)", "IMF repurchases (AMT, current US$)",
"IMF repurchases and charges (TDS, current US$)", "Immunization, DPT (%
of children ages 12-23 months)",
"Immunization, measles (% of children ages 12-23 months)", "Import value
index (2000 = 100)",
"Import volume index (2000 = 100)", "Imports of goods and services (% of
GDP)",
"Imports of goods and services (annual % growth)", "Imports of goods and
services (BoP, current US$)",
"Imports of goods and services (constant 2005 US$)", "Imports of goods
and services (constant LCU)",
"Imports of goods and services (current LCU)", "Imports of goods and
services (current US$)",
"Imports of goods, services and primary income (BoP, current US$)",
"Improved sanitation facilities (% of population with access)",
"Improved sanitation facilities, rural (% of rural population with
access)",
"Improved sanitation facilities, urban (% of urban population with
access)",
"Improved water source (% of population with access)", "Improved water
source, rural (% of rural population with access)",
"Improved water source, urban (% of urban population with access)",
"Incidence of tuberculosis (per 100,000 people)", "Income share held by
fourth 20%",
"Income share held by highest 10%", "Income share held by highest 20%",
"Income share held by lowest 10%", "Income share held by lowest 20%",
"Income share held by second 20%", "Income share held by third 20%",
"Industrial nitrous oxide emissions (thousand metric tons of CO2
equivalent)",
"Industry, value added (% of GDP)", "Industry, value added (annual %
growth)",
"Industry, value added (constant 2005 US$)", "Industry, value added
(constant LCU)",
"Industry, value added (current LCU)", "Industry, value added (current
US$)",
"Inflation, consumer prices (annual %)", "Inflation, GDP deflator
(annual %)",
"Informal payments to public officials (% of firms)", "Insurance and
financial services (% of commercial service exports)",
"Insurance and financial services (% of commercial service imports)",
"Insurance and financial services (% of service exports, BoP)",
"Insurance and financial services (% of service imports, BoP)",
"Intentional homicides (per 100,000 people)", "Interest arrears,
long-term DOD (US$)",
"Interest arrears, official creditors (current US$)", "Interest arrears,
private creditors (current US$)",
"Interest forgiven (current US$)", "Interest payments (% of expense)",
"Interest payments (% of revenue)", "Interest payments (current LCU)",
"Interest payments on external debt (% of exports of goods, services and
primary income)",
"Interest payments on external debt (% of GNI)", "Interest payments on
external debt, long-term (INT, current US$)",
"Interest payments on external debt, private nonguaranteed (PNG) (INT,
current US$)",
"Interest payments on external debt, public and publicly guaranteed
(PPG) (INT, current US$)",
"Interest payments on external debt, short-term (INT, current US$)",
"Interest payments on external debt, total (INT, current US$)",
"Interest rate spread (lending rate minus deposit rate, %)",
"Interest rescheduled (capitalized) (current US$)", "Interest
rescheduled, official (current US$)",
"Interest rescheduled, private (current US$)", "Internally displaced
persons (number, high estimate)",
"Internally displaced persons (number, low estimate)", "International
migrant stock (% of population)",
"International migrant stock, total", "International tourism,
expenditures (% of total imports)",
"International tourism, expenditures (current US$)", "International
tourism, expenditures for passenger transport items (current US$)",
"International tourism, expenditures for travel items (current US$)",
"International tourism, number of arrivals", "International tourism,
number of departures",
"International tourism, receipts (% of total exports)", "International
tourism, receipts (current US$)",
"International tourism, receipts for passenger transport items (current
US$)",
"International tourism, receipts for travel items (current US$)",
"Internationally-recognized quality certification (% of firms)",
"Internet users (per 100 people)", "Investment in energy with private
participation (current US$)",
"Investment in telecoms with private participation (current US$)",
"Investment in transport with private participation (current US$)",
"Investment in water and sanitation with private participation (current
US$)",
"Labor force participation rate for ages 15-24, female (%) (modeled ILO
estimate)",
"Labor force participation rate for ages 15-24, female (%) (national
estimate)",
"Labor force participation rate for ages 15-24, male (%) (modeled ILO
estimate)",
"Labor force participation rate for ages 15-24, male (%) (national
estimate)",
"Labor force participation rate for ages 15-24, total (%) (modeled ILO
estimate)",
"Labor force participation rate for ages 15-24, total (%) (national
estimate)",
"Labor force participation rate, female (% of female population ages
15-64) (modeled ILO estimate)",
"Labor force participation rate, female (% of female population ages
15+) (modeled ILO estimate)",
"Labor force participation rate, female (% of female population ages
15+) (national estimate)",
"Labor force participation rate, male (% of male population ages 15-64)
(modeled ILO estimate)",
"Labor force participation rate, male (% of male population ages 15+)
(modeled ILO estimate)",
"Labor force participation rate, male (% of male population ages 15+)
(national estimate)",
"Labor force participation rate, total (% of total population ages
15-64) (modeled ILO estimate)",
"Labor force participation rate, total (% of total population ages 15+)
(modeled ILO estimate)",
"Labor force participation rate, total (% of total population ages 15+)
(national estimate)",
"Labor force with primary education (% of total)", "Labor force with
primary education, female (% of female labor force)",
"Labor force with primary education, male (% of male labor force)",
"Labor force with secondary education (% of total)", "Labor force with
secondary education, female (% of female labor force)",
"Labor force with secondary education, male (% of male labor force)",
"Labor force with tertiary education (% of total)", "Labor force with
tertiary education, female (% of female labor force)",
"Labor force with tertiary education, male (% of male labor force)",
"Labor force, female (% of total labor force)", "Labor force, total",
"Labor tax and contributions (% of commercial profits)", "Land area (sq.
km)",
"Land area where elevation is below 5 meters (% of total land area)",
"Land under cereal production (hectares)", "Lead time to export, median
case (days)",
"Lead time to import, median case (days)", "Lending interest rate (%)",
"Life expectancy at birth, female (years)", "Life expectancy at birth,
male (years)",
"Life expectancy at birth, total (years)", "Lifetime risk of maternal
death (%)",
"Lifetime risk of maternal death (1 in: rate varies by country)",
"Liner shipping connectivity index (maximum value in 2004 = 100)",
"Listed domestic companies, total", "Livestock production index
(2004-2006 = 100)",
"Logistics performance index: Ability to track and trace consignments
(1=low to 5=high)",
"Logistics performance index: Competence and quality of logistics
services (1=low to 5=high)",
"Logistics performance index: Ease of arranging competitively priced
shipments (1=low to 5=high)",
"Logistics performance index: Efficiency of customs clearance process
(1=low to 5=high)",
"Logistics performance index: Frequency with which shipments reach
consignee within scheduled or expected time (1=low to 5=high)",
"Logistics performance index: Overall (1=low to 5=high)", "Logistics
performance index: Quality of trade and transport-related infrastructure
(1=low to 5=high)",
"Long-term unemployment (% of total unemployment)", "Long-term
unemployment, female (% of female unemployment)",
"Long-term unemployment, male (% of male unemployment)", "Losses due to
theft, robbery, vandalism, and arson (% sales)",
"Low-birthweight babies (% of births)", "Lower secondary completion
rate, both sexes (%)",
"Lower secondary completion rate, female (%)", "Lower secondary
completion rate, male (%)",
"Machinery and transport equipment (% of value added in manufacturing)",
"Mammal species, threatened", "Manufactures exports (% of merchandise
exports)",
"Manufactures imports (% of merchandise imports)", "Manufacturing, value
added (% of GDP)",
"Manufacturing, value added (annual % growth)", "Manufacturing, value
added (constant 2005 US$)",
"Manufacturing, value added (constant LCU)", "Manufacturing, value added
(current LCU)",
"Manufacturing, value added (current US$)", "Marine protected areas (%
of territorial waters)",
"Market capitalization of listed domestic companies (% of GDP)",
"Market capitalization of listed domestic companies (current US$)",
"Maternal mortality ratio (modeled estimate, per 100,000 live births)",
"Maternal mortality ratio (national estimate, per 100,000 live births)",
"Merchandise exports (current US$)", "Merchandise exports by the
reporting economy (current US$)",
"Merchandise exports by the reporting economy, residual (% of total
merchandise exports)",
"Merchandise exports to developing economies in East Asia & Pacific (%
of total merchandise exports)",
"Merchandise exports to developing economies in Europe & Central Asia (%
of total merchandise exports)",
"Merchandise exports to developing economies in Latin America & the
Caribbean (% of total merchandise exports)",
"Merchandise exports to developing economies in Middle East & North
Africa (% of total merchandise exports)",
"Merchandise exports to developing economies in South Asia (% of total
merchandise exports)",
"Merchandise exports to developing economies in Sub-Saharan Africa (% of
total merchandise exports)",
"Merchandise exports to developing economies outside region (% of total
merchandise exports)",
"Merchandise exports to developing economies within region (% of total
merchandise exports)",
"Merchandise exports to economies in the Arab World (% of total
merchandise exports)",
"Merchandise exports to high-income economies (% of total merchandise
exports)",
"Merchandise imports (current US$)", "Merchandise imports by the
reporting economy (current US$)",
"Merchandise imports by the reporting economy, residual (% of total
merchandise imports)",
"Merchandise imports from developing economies in East Asia & Pacific (%
of total merchandise imports)",
"Merchandise imports from developing economies in Europe & Central Asia
(% of total merchandise imports)",
"Merchandise imports from developing economies in Latin America & the
Caribbean (% of total merchandise imports)",
"Merchandise imports from developing economies in Middle East & North
Africa (% of total merchandise imports)",
"Merchandise imports from developing economies in South Asia (% of total
merchandise imports)",
"Merchandise imports from developing economies in Sub-Saharan Africa (%
of total merchandise imports)",
"Merchandise imports from developing economies outside region (% of
total merchandise imports)",
"Merchandise imports from developing economies within region (% of total
merchandise imports)",
"Merchandise imports from economies in the Arab World (% of total
merchandise imports)",
"Merchandise imports from high-income economies (% of total merchandise
imports)",
"Merchandise trade (% of GDP)", "Methane emissions (kt of CO2 equivalent)",
"Methane emissions in energy sector (thousand metric tons of CO2
equivalent)",
"Methodology assessment of statistical capacity (scale 0 - 100)",
"Military expenditure (% of central government expenditure)",
"Military expenditure (% of GDP)", "Military expenditure (current LCU)",
"Mineral rents (% of GDP)", "Mobile cellular subscriptions",
"Mobile cellular subscriptions (per 100 people)", "Money (current LCU)",
"Money and quasi money (M2) (current LCU)", "Money and quasi money (M2)
as % of GDP",
"Money and quasi money (M2) to total reserves ratio", "Money and quasi
money growth (annual %)",
"Mortality rate, adult, female (per 1,000 female adults)", "Mortality
rate, adult, male (per 1,000 male adults)",
"Mortality rate, infant (per 1,000 live births)", "Mortality rate,
infant, female (per 1,000 live births)",
"Mortality rate, infant, male (per 1,000 live births)", "Mortality rate,
neonatal (per 1,000 live births)",
"Mortality rate, under-5 (per 1,000)", "Mortality rate, under-5, female
(per 1,000 live births)",
"Mortality rate, under-5, male (per 1,000 live births)", "Multilateral
debt (% of total external debt)",
"Multilateral debt service (% of public and publicly guaranteed debt
service)",
"Multilateral debt service (TDS, current US$)", "Natural gas rents (% of
GDP)",
"Net barter terms of trade index (2000 = 100)", "Net bilateral aid flows
from DAC donors, Australia (current US$)",
"Net bilateral aid flows from DAC donors, Austria (current US$)",
"Net bilateral aid flows from DAC donors, Belgium (current US$)",
"Net bilateral aid flows from DAC donors, Canada (current US$)",
"Net bilateral aid flows from DAC donors, Czech Republic (current US$)",
"Net bilateral aid flows from DAC donors, Denmark (current US$)",
"Net bilateral aid flows from DAC donors, European Union institutions
(current US$)",
"Net bilateral aid flows from DAC donors, Finland (current US$)",
"Net bilateral aid flows from DAC donors, France (current US$)",
"Net bilateral aid flows from DAC donors, Germany (current US$)",
"Net bilateral aid flows from DAC donors, Greece (current US$)",
"Net bilateral aid flows from DAC donors, Ireland (current US$)",
"Net bilateral aid flows from DAC donors, Italy (current US$)",
"Net bilateral aid flows from DAC donors, Japan (current US$)",
"Net bilateral aid flows from DAC donors, Korea, Rep. (current US$)",
"Net bilateral aid flows from DAC donors, Luxembourg (current US$)",
"Net bilateral aid flows from DAC donors, Netherlands (current US$)",
"Net bilateral aid flows from DAC donors, New Zealand (current US$)",
"Net bilateral aid flows from DAC donors, Norway (current US$)",
"Net bilateral aid flows from DAC donors, Poland (current US$)",
"Net bilateral aid flows from DAC donors, Portugal (current US$)",
"Net bilateral aid flows from DAC donors, Slovak Republic (current US$)",
"Net bilateral aid flows from DAC donors, Slovenia (current US$)",
"Net bilateral aid flows from DAC donors, Spain (current US$)",
"Net bilateral aid flows from DAC donors, Sweden (current US$)",
"Net bilateral aid flows from DAC donors, Switzerland (current US$)",
"Net bilateral aid flows from DAC donors, Total (current US$)",
"Net bilateral aid flows from DAC donors, United Kingdom (current US$)",
"Net bilateral aid flows from DAC donors, United States (current US$)",
"Net capital account (BoP, current US$)", "Net change in interest
arrears (current US$)",
"Net current transfers from abroad (constant LCU)", "Net current
transfers from abroad (current LCU)",
"Net current transfers from abroad (current US$)", "Net domestic credit
(current LCU)",
"Net enrolment rate, primary, both sexes (%)", "Net enrolment rate,
primary, female (%)",
"Net enrolment rate, primary, male (%)", "Net enrolment rate, secondary,
both sexes (%)",
"Net enrolment rate, secondary, female (%)", "Net enrolment rate,
secondary, male (%)",
"Net errors and omissions (BoP, current US$)", "Net financial account
(BoP, current US$)",
"Net financial flows, bilateral (NFL, current US$)", "Net financial
flows, IBRD (NFL, current US$)",
"Net financial flows, IDA (NFL, current US$)", "Net financial flows, IMF
concessional (NFL, current US$)",
"Net financial flows, IMF nonconcessional (NFL, current US$)",
"Net financial flows, multilateral (NFL, current US$)", "Net financial
flows, others (NFL, current US$)",
"Net financial flows, RDB concessional (NFL, current US$)", "Net
financial flows, RDB nonconcessional (NFL, current US$)",
"Net flows on external debt, long-term (NFL, current US$)", "Net flows
on external debt, private nonguaranteed (PNG) (NFL, current US$)",
"Net flows on external debt, public and publicly guaranteed (PPG) (NFL,
current US$)",
"Net flows on external debt, short-term (NFL, current US$)",
"Net flows on external debt, total (NFL, current US$)", "Net foreign
assets (current LCU)",
"Net income from abroad (constant LCU)", "Net income from abroad
(current LCU)",
"Net income from abroad (current US$)", "Net incurrence of liabilities,
domestic (% of GDP)",
"Net incurrence of liabilities, domestic (current LCU)", "Net incurrence
of liabilities, foreign (% of GDP)",
"Net incurrence of liabilities, foreign (current LCU)", "Net intake rate
to Grade 1 of primary education, both sexes (%)",
"Net intake rate to Grade 1 of primary education, female (%)",
"Net intake rate to Grade 1 of primary education, male (%)",
"Net migration", "Net ODA received (% of central government expense)",
"Net ODA received (% of GNI)", "Net ODA received (% of gross capital
formation)",
"Net ODA received (% of imports of goods, services and primary income)",
"Net ODA received per capita (current US$)", "Net official aid received
(constant 2012 US$)",
"Net official aid received (current US$)", "Net official development
assistance and official aid received (constant 2012 US$)",
"Net official development assistance and official aid received (current
US$)",
"Net official development assistance received (constant 2012 US$)",
"Net official development assistance received (current US$)",
"Net official flows from UN agencies, IAEA (current US$)", "Net official
flows from UN agencies, IFAD (current US$)",
"Net official flows from UN agencies, UNAIDS (current US$)",
"Net official flows from UN agencies, UNDP (current US$)", "Net official
flows from UN agencies, UNFPA (current US$)",
"Net official flows from UN agencies, UNHCR (current US$)", "Net
official flows from UN agencies, UNICEF (current US$)",
"Net official flows from UN agencies, UNTA (current US$)", "Net official
flows from UN agencies, WFP (current US$)",
"Net primary income (BoP, current US$)", "Net secondary income (BoP,
current US$)",
"Net taxes on products (constant LCU)", "Net taxes on products (current
LCU)",
"Net taxes on products (current US$)", "Net trade in goods (BoP, current
US$)",
"Net trade in goods and services (BoP, current US$)", "Net transfers on
external debt, long-term (NTR, current US$)",
"Net transfers on external debt, private nonguaranteed (PNG) (NTR,
current US$)",
"Net transfers on external debt, public and publicly guaranteed (PPG)
(NTR, current US$)",
"Net transfers on external debt, total (NTR, current US$)", "New
business density (new registrations per 1,000 people ages 15-64)",
"New businesses registered (number)", "Nitrous oxide emissions (thousand
metric tons of CO2 equivalent)",
"Nitrous oxide emissions in energy sector (thousand metric tons of CO2
equivalent)",
"Nitrous oxide emissions in industrial and energy processes (% of total
nitrous oxide emissions)",
"Number of infant deaths", "Number of maternal deaths", "Number of
neonatal deaths",
"Number of under-five deaths", "Number of visits or required meetings
with tax officials",
"Nurses and midwives (per 1,000 people)", "Official entrance age to
lower secondary education (years)",
"Official entrance age to primary education (years)", "Official exchange
rate (LCU per US$, period average)",
"Oil rents (% of GDP)", "Ores and metals exports (% of merchandise
exports)",
"Ores and metals imports (% of merchandise imports)", "Other expense (%
of expense)",
"Other expense (current LCU)", "Other greenhouse gas emissions, HFC, PFC
and SF6 (thousand metric tons of CO2 equivalent)",
"Other manufacturing (% of value added in manufacturing)", "Other taxes
(% of revenue)",
"Other taxes (current LCU)", "Other taxes payable by businesses (% of
commercial profits)",
"Out-of-pocket health expenditure (% of private expenditure on health)",
"Out-of-pocket health expenditure (% of total expenditure on health)",
"Out-of-school children of primary school age, both sexes (number)",
"Out-of-school children of primary school age, female (number)",
"Out-of-school children of primary school age, male (number)",
"Overall level of statistical capacity (scale 0 - 100)", "Part time
employment, female (% of total female employment)",
"Part time employment, female (% of total part time employment)",
"Part time employment, male (% of total male employment)", "Part time
employment, total (% of total employment)",
"Patent applications, nonresidents", "Patent applications, residents",
"Percentage of enrolment in primary education in private institutions (%)",
"Percentage of enrolment in secondary education in private institutions
(%)",
"Percentage of female teachers in primary education who are trained,
female (%)",
"Percentage of male teachers in primary education who are trained, male
(%)",
"Percentage of repeaters in primary education, all grades, both sexes (%)",
"Percentage of repeaters in primary education, all grades, female (%)",
"Percentage of repeaters in primary education, all grades, male (%)",
"Percentage of repeaters in secondary general education, all grades,
both sexes (%)",
"Percentage of repeaters in secondary general education, all grades,
female (%)",
"Percentage of repeaters in secondary general education, all grades,
male (%)",
"Percentage of students in primary education who are female (%)",
"Percentage of students in secondary education who are female (%)",
"Percentage of students in secondary general education who are female (%)",
"Percentage of students in secondary vocational education who are female
(%)",
"Percentage of teachers in primary education who are female (%)",
"Percentage of teachers in primary education who are trained, both sexes
(%)",
"Percentage of teachers in secondary education who are female (%)",
"Percentage of teachers in tertiary education who are female (%)",
"Periodicity and timeliness assessment of statistical capacity (scale 0
- 100)",
"Permanent cropland (% of land area)", "Personal remittances, paid
(current US$)",
"Personal remittances, received (% of GDP)", "Personal remittances,
received (current US$)",
"Personal transfers, receipts (BoP, current US$)", "PFC gas emissions
(thousand metric tons of CO2 equivalent)",
"Physicians (per 1,000 people)", "Plant species (higher), threatened",
"PM2.5 air pollution, mean annual exposure (micrograms per cubic meter)",
"PM2.5 air pollution, population exposed to levels exceeding WHO
guideline value (% of total)",
"PNG, bonds (AMT, current US$)", "PNG, bonds (DIS, current US$)",
"PNG, bonds (DOD, current US$)", "PNG, bonds (INT, current US$)",
"PNG, bonds (NFL, current US$)", "PNG, bonds (NTR, current US$)",
"PNG, bonds (TDS, current US$)", "PNG, commercial banks and other
creditors (AMT, current US$)",
"PNG, commercial banks and other creditors (DIS, current US$)",
"PNG, commercial banks and other creditors (DOD, current US$)",
"PNG, commercial banks and other creditors (INT, current US$)",
"PNG, commercial banks and other creditors (NFL, current US$)",
"PNG, commercial banks and other creditors (NTR, current US$)",
"PNG, commercial banks and other creditors (TDS, current US$)",
"Point-of-sale terminals (per 100,000 adults)", "Population ages 65 and
above (% of total)",
"Population density (people per sq. km of land area)", "Population
growth (annual %)",
"Population in largest city", "Population in the largest city (% of
urban population)",
"Population in urban agglomerations of more than 1 million",
"Population in urban agglomerations of more than 1 million (% of total
population)",
"Population living in areas where elevation is below 5 meters (% of
total population)",
"Population, ages 0-14 (% of total)", "Population, ages 15-64 (% of
total)",
"Population, female (% of total)", "Population, total", "Portfolio
equity, net inflows (BoP, current US$)",
"Portfolio investment, bonds (PPG + PNG) (NFL, current US$)",
"Portfolio Investment, net (BoP, current US$)", "Poverty gap at $1.90 a
day (2011 PPP) (%)",
"Poverty gap at $3.10 a day (2011 PPP) (%)", "Poverty headcount ratio at
$1.90 a day (2011 PPP) (% of population)",
"Poverty headcount ratio at $3.10 a day (2011 PPP) (% of population)",
"Poverty headcount ratio at national poverty lines (% of population)",
"Power outages in firms in a typical month (number)", "PPG, bilateral
(AMT, current US$)",
"PPG, bilateral (DIS, current US$)", "PPG, bilateral (DOD, current US$)",
"PPG, bilateral (INT, current US$)", "PPG, bilateral (NTR, current US$)",
"PPG, bilateral (TDS, current US$)", "PPG, bilateral concessional (AMT,
current US$)",
"PPG, bilateral concessional (DIS, current US$)", "PPG, bilateral
concessional (DOD, current US$)",
"PPG, bilateral concessional (INT, current US$)", "PPG, bilateral
concessional (NFL, current US$)",
"PPG, bilateral concessional (NTR, current US$)", "PPG, bilateral
concessional (TDS, current US$)",
"PPG, bonds (AMT, current US$)", "PPG, bonds (DIS, current US$)",
"PPG, bonds (DOD, current US$)", "PPG, bonds (INT, current US$)",
"PPG, bonds (NFL, current US$)", "PPG, bonds (NTR, current US$)",
"PPG, bonds (TDS, current US$)", "PPG, commercial banks (AMT, current
US$)",
"PPG, commercial banks (DIS, current US$)", "PPG, commercial banks (DOD,
current US$)",
"PPG, commercial banks (INT, current US$)", "PPG, commercial banks (NFL,
current US$)",
"PPG, commercial banks (NTR, current US$)", "PPG, commercial banks (TDS,
current US$)",
"PPG, IBRD (AMT, current US$)", "PPG, IBRD (DIS, current US$)",
"PPG, IBRD (DOD, current US$)", "PPG, IBRD (INT, current US$)",
"PPG, IBRD (NTR, current US$)", "PPG, IBRD (TDS, current US$)",
"PPG, IDA (AMT, current US$)", "PPG, IDA (DIS, current US$)",
"PPG, IDA (DOD, current US$)", "PPG, IDA (INT, current US$)",
"PPG, IDA (NTR, current US$)", "PPG, IDA (TDS, current US$)",
"PPG, multilateral (AMT, current US$)", "PPG, multilateral (DIS, current
US$)",
"PPG, multilateral (DOD, current US$)", "PPG, multilateral (INT, current
US$)",
"PPG, multilateral (NTR, current US$)", "PPG, multilateral concessional
(AMT, current US$)",
"PPG, multilateral concessional (DIS, current US$)", "PPG, multilateral
concessional (DOD, current US$)",
"PPG, multilateral concessional (INT, current US$)", "PPG, multilateral
concessional (NFL, current US$)",
"PPG, multilateral concessional (NTR, current US$)", "PPG, multilateral
concessional (TDS, current US$)",
"PPG, official creditors (AMT, current US$)", "PPG, official creditors
(DIS, current US$)",
"PPG, official creditors (DOD, current US$)", "PPG, official creditors
(INT, current US$)",
"PPG, official creditors (NFL, current US$)", "PPG, official creditors
(NTR, current US$)",
"PPG, official creditors (TDS, current US$)", "PPG, other private
creditors (AMT, current US$)",
"PPG, other private creditors (DIS, current US$)", "PPG, other private
creditors (DOD, current US$)",
"PPG, other private creditors (INT, current US$)", "PPG, other private
creditors (NFL, current US$)",
"PPG, other private creditors (NTR, current US$)", "PPG, other private
creditors (TDS, current US$)",
"PPG, private creditors (AMT, current US$)", "PPG, private creditors
(DIS, current US$)",
"PPG, private creditors (DOD, current US$)", "PPG, private creditors
(INT, current US$)",
"PPG, private creditors (NFL, current US$)", "PPG, private creditors
(NTR, current US$)",
"PPG, private creditors (TDS, current US$)", "PPP conversion factor, GDP
(LCU per international $)",
"PPP conversion factor, private consumption (LCU per international $)",
"Pregnant women receiving prenatal care (%)", "Present value of external
debt (% of exports of goods, services and primary income)",
"Present value of external debt (% of GNI)", "Present value of external
debt (current US$)",
"Prevalence of anemia among children (% of children under 5)",
"Prevalence of anemia among non-pregnant women (% of women ages 15-49)",
"Prevalence of anemia among pregnant women (%)", "Prevalence of HIV,
female (% ages 15-24)",
"Prevalence of HIV, male (% ages 15-24)", "Prevalence of HIV, total (%
of population ages 15-49)",
"Prevalence of overweight, weight for height (% of children under 5)",
"Prevalence of overweight, weight for height, female (% of children
under 5)",
"Prevalence of overweight, weight for height, male (% of children under
5)",
"Prevalence of severe wasting, weight for height (% of children under 5)",
"Prevalence of severe wasting, weight for height, female (% of children
under 5)",
"Prevalence of severe wasting, weight for height, male (% of children
under 5)",
"Prevalence of stunting, height for age (% of children under 5)",
"Prevalence of stunting, height for age, female (% of children under 5)",
"Prevalence of stunting, height for age, male (% of children under 5)",
"Prevalence of underweight, weight for age (% of children under 5)",
"Prevalence of underweight, weight for age, female (% of children under
5)",
"Prevalence of underweight, weight for age, male (% of children under 5)",
"Prevalence of wasting, weight for height (% of children under 5)",
"Prevalence of wasting, weight for height, female (% of children under 5)",
"Prevalence of wasting, weight for height, male (% of children under 5)",
"Price level ratio of PPP conversion factor (GDP) to market exchange rate",
"Primary completion rate, both sexes (%)", "Primary completion rate,
female (%)",
"Primary completion rate, male (%)", "Primary income on FDI, payments
(current US$)",
"Primary income payments (BoP, current US$)", "Primary income receipts
(BoP, current US$)",
"Primary to secondary general education transition rate, both sexes (%)",
"Primary to secondary general education transition rate, female (%)",
"Primary to secondary general education transition rate, male (%)",
"Principal arrears, long-term DOD (US$)", "Principal arrears, official
creditors (current US$)",
"Principal arrears, private creditors (current US$)", "Principal
forgiven (current US$)",
"Principal repayments on external debt, long-term (AMT, current US$)",
"Principal repayments on external debt, long-term + IMF (AMT, current
US$)",
"Principal repayments on external debt, private nonguaranteed (PNG)
(AMT, current US$)",
"Principal repayments on external debt, public and publicly guaranteed
(PPG) (AMT, current US$)",
"Principal rescheduled (current US$)", "Principal rescheduled, official
(current US$)",
"Principal rescheduled, private (current US$)", "Private credit bureau
coverage (% of adults)",
"Procedures to build a warehouse (number)", "Procedures to register
property (number)",
"Profit tax (% of commercial profits)", "Proportion of seats held by
women in national parliaments (%)",
"Public and publicly guaranteed debt service (% of exports of goods,
services and primary income)",
"Public and publicly guaranteed debt service (% of GNI)", "Public credit
registry coverage (% of adults)",
"Pump price for diesel fuel (US$ per liter)", "Pump price for gasoline
(US$ per liter)",
"Pupil-teacher ratio in primary education (headcount basis)",
"Pupil-teacher ratio in secondary education (headcount basis)",
"Quality of port infrastructure, WEF (1=extremely underdeveloped to
7=well developed and efficient by international standards)",
"Quasi money (current LCU)", "Rail lines (total route-km)", "Railways,
goods transported (million ton-km)",
"Railways, passengers carried (million passenger-km)", "Ratio of female
to male labor force participation rate (%) (modeled ILO estimate)",
"Ratio of female to male labor force participation rate (%) (national
estimate)",
"Real effective exchange rate index (2010 = 100)", "Real interest rate
(%)",
"Refugee population by country or territory of asylum", "Refugee
population by country or territory of origin",
"Renewable electricity output (% of total electricity output)",
"Renewable energy consumption (% of total final energy consumption)",
"Renewable internal freshwater resources per capita (cubic meters)",
"Renewable internal freshwater resources, total (billion cubic meters)",
"Research and development expenditure (% of GDP)", "Researchers in R&D
(per million people)",
"Reserves and related items (BoP, current US$)", "Residual, debt
stock-flow reconciliation (current US$)",
"Revenue, excluding grants (% of GDP)", "Revenue, excluding grants
(current LCU)",
"Risk premium on lending (lending rate minus treasury bill rate, %)",
"Rural population", "Rural population (% of total population)",
"Rural population growth (annual %)", "S&P Global Equity Indices (annual
% change)",
"Scientific and technical journal articles", "Secondary income receipts
(BoP, current US$)",
"Secondary income, other sectors, payments (BoP, current US$)",
"Secure Internet servers", "Secure Internet servers (per 1 million
people)",
"Self-employed, female (% of females employed)", "Self-employed, male (%
of males employed)",
"Self-employed, total (% of total employed)", "Service exports (BoP,
current US$)",
"Service imports (BoP, current US$)", "Services, etc., value added (% of
GDP)",
"Services, etc., value added (annual % growth)", "Services, etc., value
added (constant 2005 US$)",
"Services, etc., value added (constant LCU)", "Services, etc., value
added (current LCU)",
"Services, etc., value added (current US$)", "SF6 gas emissions
(thousand metric tons of CO2 equivalent)",
"Share of tariff lines with international peaks, all products (%)",
"Share of tariff lines with international peaks, manufactured products
(%)",
"Share of tariff lines with international peaks, primary products (%)",
"Share of tariff lines with specific rates, all products (%)",
"Share of tariff lines with specific rates, manufactured products (%)",
"Share of tariff lines with specific rates, primary products (%)",
"Share of women in wage employment in the nonagricultural sector (% of
total nonagricultural employment)",
"Share of youth not in education, employment, or training, female (% of
female youth population)",
"Share of youth not in education, employment, or training, male (% of
male youth population)",
"Share of youth not in education, employment, or training, total (% of
youth population)",
"Short-term debt (% of exports of goods, services and primary income)",
"Short-term debt (% of total external debt)", "Short-term debt (% of
total reserves)",
"Smoking prevalence, females (% of adults)", "Smoking prevalence, males
(% of adults)",
"Social contributions (% of revenue)", "Social contributions (current
LCU)",
"Source data assessment of statistical capacity (scale 0 - 100)",
"Start-up procedures to register a business (number)", "Stocks traded,
total value (% of GDP)",
"Stocks traded, total value (current US$)", "Stocks traded, turnover
ratio of domestic shares (%)",
"Strength of legal rights index (0=weak to 12=strong)", "Subsidies and
other transfers (% of expense)",
"Subsidies and other transfers (current LCU)", "Surface area (sq. km)",
"Survey mean consumption or income per capita, bottom 40% of population
(2011 PPP $ per day)",
"Survey mean consumption or income per capita, total population (2011
PPP $ per day)",
"Survival rate to Grade 5 of primary education, both sexes (%)",
"Survival rate to Grade 5 of primary education, female (%)",
"Survival rate to Grade 5 of primary education, male (%)", "Survival
rate to the last grade of primary education, both sexes (%)",
"Survival rate to the last grade of primary education, female (%)",
"Survival rate to the last grade of primary education, male (%)",
"Survival to age 65, female (% of cohort)", "Survival to age 65, male (%
of cohort)",
"Tariff rate, applied, simple mean, all products (%)", "Tariff rate,
applied, simple mean, manufactured products (%)",
"Tariff rate, applied, simple mean, primary products (%)", "Tariff rate,
applied, weighted mean, all products (%)",
"Tariff rate, applied, weighted mean, manufactured products (%)",
"Tariff rate, applied, weighted mean, primary products (%)",
"Tariff rate, most favored nation, simple mean, all products (%)",
"Tariff rate, most favored nation, simple mean, manufactured products (%)",
"Tariff rate, most favored nation, simple mean, primary products (%)",
"Tariff rate, most favored nation, weighted mean, all products (%)",
"Tariff rate, most favored nation, weighted mean, manufactured products
(%)",
"Tariff rate, most favored nation, weighted mean, primary products (%)",
"Tax payments (number)", "Tax revenue (% of GDP)", "Tax revenue (current
LCU)",
"Taxes on exports (% of tax revenue)", "Taxes on exports (current LCU)",
"Taxes on goods and services (% of revenue)", "Taxes on goods and
services (% value added of industry and services)",
"Taxes on goods and services (current LCU)", "Taxes on income, profits
and capital gains (% of revenue)",
"Taxes on income, profits and capital gains (% of total taxes)",
"Taxes on income, profits and capital gains (current LCU)", "Taxes on
international trade (% of revenue)",
"Taxes on international trade (current LCU)", "Teachers in primary
education, both sexes (number)",
"Teachers in secondary education, both sexes (number)", "Teachers in
secondary education, female (number)",
"Technical cooperation grants (BoP, current US$)", "Technicians in R&D
(per million people)",
"Teenage mothers (% of women ages 15-19 who have had children or are
currently pregnant)",
"Terms of trade adjustment (constant LCU)", "Terrestrial and marine
protected areas (% of total territorial area)",
"Terrestrial protected areas (% of total land area)", "Textiles and
clothing (% of value added in manufacturing)",
"Theoretical duration of primary education (years)", "Theoretical
duration of secondary education (years)",
"Time required to build a warehouse (days)", "Time required to enforce a
contract (days)",
"Time required to get electricity (days)", "Time required to obtain an
operating license (days)",
"Time required to register property (days)", "Time required to start a
business (days)",
"Time spent dealing with the requirements of government regulations (%
of senior management time)",
"Time to export (days)", "Time to import (days)", "Time to prepare and
pay taxes (hours)",
"Time to resolve insolvency (years)", "Total amount of debt rescheduled
(current US$)",
"Total change in external debt stocks (current US$)", "Total debt
service (% of exports of goods, services and primary income)",
"Total debt service (% of GNI)", "Total natural resources rents (% of
GDP)",
"Total reserves (% of total external debt)", "Total reserves (includes
gold, current US$)",
"Total reserves in months of imports", "Total reserves minus gold
(current US$)",
"Total tax rate (% of commercial profits)", "Trade (% of GDP)",
"Trade in services (% of GDP)", "Trademark applications, direct
nonresident",
"Trademark applications, direct resident", "Trademark applications, total",
"Transport services (% of commercial service exports)", "Transport
services (% of commercial service imports)",
"Transport services (% of service exports, BoP)", "Transport services (%
of service imports, BoP)",
"Travel services (% of commercial service exports)", "Travel services (%
of commercial service imports)",
"Travel services (% of service exports, BoP)", "Travel services (% of
service imports, BoP)",
"Tuberculosis case detection rate (%, all forms)", "Tuberculosis
treatment success rate (% of new cases)",
"Undisbursed external debt, official creditors (UND, current US$)",
"Undisbursed external debt, private creditors (UND, current US$)",
"Undisbursed external debt, total (UND, current US$)", "Unemployment
with primary education (% of total unemployment)",
"Unemployment with primary education, female (% of female unemployment)",
"Unemployment with primary education, male (% of male unemployment)",
"Unemployment with secondary education (% of total unemployment)",
"Unemployment with secondary education, female (% of female unemployment)",
"Unemployment with secondary education, male (% of male unemployment)",
"Unemployment with tertiary education (% of total unemployment)",
"Unemployment with tertiary education, female (% of female unemployment)",
"Unemployment with tertiary education, male (% of male unemployment)",
"Unemployment, female (% of female labor force)", "Unemployment, female
(% of female labor force) (national estimate)",
"Unemployment, male (% of male labor force)", "Unemployment, male (% of
male labor force) (national estimate)",
"Unemployment, total (% of total labor force)", "Unemployment, total (%
of total labor force) (national estimate)",
"Unemployment, youth female (% of female labor force ages 15-24)
(modeled ILO estimate)",
"Unemployment, youth female (% of female labor force ages 15-24)
(national estimate)",
"Unemployment, youth male (% of male labor force ages 15-24) (modeled
ILO estimate)",
"Unemployment, youth male (% of male labor force ages 15-24) (national
estimate)",
"Unemployment, youth total (% of total labor force ages 15-24) (modeled
ILO estimate)",
"Unemployment, youth total (% of total labor force ages 15-24) (national
estimate)",
"Unmet need for contraception (% of married women ages 15-49)",
"Urban population", "Urban population (% of total)", "Urban population
growth (annual %)",
"Use of IMF credit (DOD, current US$)", "Value lost due to electrical
outages (% of sales)",
"Vulnerable employment, female (% of female employment)", "Vulnerable
employment, male (% of male employment)",
"Vulnerable employment, total (% of total employment)", "Wage and
salaried workers, female (% of females employed)",
"Wage and salaried workers, total (% of total employed)", "Wage and
salary workers, male (% of males employed)",
"Wanted fertility rate (births per woman)", "Water productivity, total
(constant 2005 US$ GDP per cubic meter of total freshwater withdrawal)",
"Wholesale price index (2010 = 100)", "Women's share of population ages
15+ living with HIV (%)",
"Youth literacy rate, population 15-24 years, both sexes (%)",
"Youth literacy rate, population 15-24 years, female (%)", "Youth
literacy rate, population 15-24 years, gender parity index (GPI)",
"Youth literacy rate, population 15-24 years, male (%)"), class =
"factor"),
     Year = c(1960L, 1962L, 1963L, 1965L, 1968L, 1965L, 1965L,
     1968L, 1962L, 1964L, 1962L, 1965L, 1964L, 1962L, 1960L, 1962L,
     1968L, 1965L, 1965L, 1967L, 1966L, 1965L, 1963L, 1964L, 1961L
     )), class = "data.frame", row.names = c("34", "6299", "9798",
"16849", "28474", "16882", "16880", "28573", "6325", "13377",
"6301", "16863", "13369", "6245", "85", "6249", "28476", "16849.1",
"16844", "24689", "20818", "16981", "9795", "13373", "3031"))

Preciso a partir de cada nível da variável IndicatorName criar uma nova
variável com os valores de Value:
Por exempo:
o nível da variável IndicatorName=='Mobile cellular subscriptions' seria
uma nova variável:

v1<-dado$Value[dados$IndicatorName=='Mobile cellular subscriptions']
  e assi por diante para cada um dos outros níveis que a variável
IndicatorName recebe.

Como posso fazer isso de uma vez só?

Obrigado!

_______________________________________________
R-br mailing list
[hidden email]
https://listas.inf.ufpr.br/cgi-bin/mailman/listinfo/r-br
Leia o guia de postagem (http://www.leg.ufpr.br/r-br-guia) e fornea cdigo mnimo reproduzvel.
Reply | Threaded
Open this post in threaded view
|

Re: [R-br] Criando variáveis

R-br mailing list
Consegui da seguinte forma:


library(tidyverse)

new<-dados %>%spread(key=IndicatorName,value=Value)


Em 16/08/2018 21:13, Felipe escreveu:

> Prezados, tenho um conjunto de dados como segue abaixo:
>
> dados<-structure(list(IndicatorName = structure(c(323L, 713L, 713L,
> 55L, 185L, 293L, 291L, 832L, 834L, 720L, 715L, 186L, 710L, 294L,
> 735L, 323L, 187L, 55L, 49L, 1112L, 414L, 944L, 709L, 715L, 723L
> ), .Label = c("2005 PPP conversion factor, GDP (LCU per international
> $)",
> "2005 PPP conversion factor, private consumption (LCU per
> international $)",
> "Access to electricity (% of population)", "Access to electricity,
> rural (% of rural population)",
> "Access to electricity, urban (% of urban population)", "Access to
> non-solid fuel (% of population)",
> "Access to non-solid fuel, rural (% of rural population)", "Access to
> non-solid fuel, urban (% of urban population)",
> "Adequacy of social insurance programs (% of total welfare of
> beneficiary households)",
> "Adequacy of social protection and labor programs (% of total welfare
> of beneficiary households)",
> "Adequacy of social safety net programs (% of total welfare of
> beneficiary households)",
> "Adequacy of unemployment benefits and ALMP (% of total welfare of
> beneficiary households)",
> "Adjusted net enrolment rate, primary, both sexes (%)", "Adjusted net
> enrolment rate, primary, female (%)",
> "Adjusted net enrolment rate, primary, male (%)", "Adjusted net
> national income (annual % growth)",
> "Adjusted net national income (constant 2005 US$)", "Adjusted net
> national income (current US$)",
> "Adjusted net national income per capita (annual % growth)",
> "Adjusted net national income per capita (constant 2005 US$)",
> "Adjusted net national income per capita (current US$)", "Adjusted net
> savings, excluding particulate emission damage (% of GNI)",
> "Adjusted net savings, excluding particulate emission damage (current
> US$)",
> "Adjusted net savings, including particulate emission damage (% of GNI)",
> "Adjusted net savings, including particulate emission damage (current
> US$)",
> "Adjusted savings: carbon dioxide damage (% of GNI)", "Adjusted
> savings: carbon dioxide damage (current US$)",
> "Adjusted savings: consumption of fixed capital (% of GNI)",
> "Adjusted savings: consumption of fixed capital (current US$)",
> "Adjusted savings: education expenditure (% of GNI)", "Adjusted
> savings: education expenditure (current US$)",
> "Adjusted savings: energy depletion (% of GNI)", "Adjusted savings:
> energy depletion (current US$)",
> "Adjusted savings: gross savings (% of GNI)", "Adjusted savings:
> mineral depletion (% of GNI)",
> "Adjusted savings: mineral depletion (current US$)", "Adjusted
> savings: natural resources depletion (% of GNI)",
> "Adjusted savings: net forest depletion (% of GNI)", "Adjusted
> savings: net forest depletion (current US$)",
> "Adjusted savings: net national savings (% of GNI)", "Adjusted
> savings: net national savings (current US$)",
> "Adjusted savings: particulate emission damage (% of GNI)", "Adjusted
> savings: particulate emission damage (current US$)",
> "Adolescent fertility rate (births per 1,000 women ages 15-19)",
> "Adult literacy rate, population 15+ years, both sexes (%)",
> "Adult literacy rate, population 15+ years, female (%)", "Adult
> literacy rate, population 15+ years, male (%)",
> "Age dependency ratio (% of working-age population)", "Age dependency
> ratio, old (% of working-age population)",
> "Age dependency ratio, young (% of working-age population)",
> "Agricultural irrigated land (% of total agricultural land)",
> "Agricultural land (% of land area)", "Agricultural land (sq. km)",
> "Agricultural machinery, tractors", "Agricultural machinery, tractors
> per 100 sq. km of arable land",
> "Agricultural methane emissions (% of total)", "Agricultural methane
> emissions (thousand metric tons of CO2 equivalent)",
> "Agricultural nitrous oxide emissions (% of total)", "Agricultural
> nitrous oxide emissions (thousand metric tons of CO2 equivalent)",
> "Agricultural raw materials exports (% of merchandise exports)",
> "Agricultural raw materials imports (% of merchandise imports)",
> "Agriculture value added per worker (constant 2005 US$)",
> "Agriculture, value added (% of GDP)",
> "Agriculture, value added (annual % growth)", "Agriculture, value
> added (constant 2005 US$)",
> "Agriculture, value added (constant LCU)", "Agriculture, value added
> (current LCU)",
> "Agriculture, value added (current US$)", "Air transport, freight
> (million ton-km)",
> "Air transport, passengers carried", "Air transport, registered
> carrier departures worldwide",
> "All education staff compensation, primary (% of total expenditure in
> primary public institutions)",
> "All education staff compensation, secondary (% of total expenditure
> in secondary public institutions)",
> "All education staff compensation, tertiary (% of total expenditure in
> tertiary public institutions)",
> "All education staff compensation, total (% of total expenditure in
> public institutions)",
> "Alternative and nuclear energy (% of total energy use)", "Annual
> freshwater withdrawals, agriculture (% of total freshwater withdrawal)",
> "Annual freshwater withdrawals, domestic (% of total freshwater
> withdrawal)",
> "Annual freshwater withdrawals, industry (% of total freshwater
> withdrawal)",
> "Annual freshwater withdrawals, total (% of internal resources)",
> "Annual freshwater withdrawals, total (billion cubic meters)",
> "Annualized average growth rate in per capita real survey mean
> consumption or income, bottom 40% of population (%)",
> "Annualized average growth rate in per capita real survey mean
> consumption or income, total population (%)",
> "Arable land (% of land area)", "Arable land (hectares per person)",
> "Arable land (hectares)", "Armed forces personnel (% of total labor
> force)",
> "Armed forces personnel, total", "Arms exports (SIPRI trend indicator
> values)",
> "Arms imports (SIPRI trend indicator values)", "Automated teller
> machines (ATMs) (per 100,000 adults)",
> "Average grace period on new external debt commitments (years)",
> "Average grace period on new external debt commitments, official
> (years)",
> "Average grace period on new external debt commitments, private (years)",
> "Average grant element on new external debt commitments (%)",
> "Average grant element on new external debt commitments, official (%)",
> "Average grant element on new external debt commitments, private (%)",
> "Average interest on new external debt commitments (%)", "Average
> interest on new external debt commitments, official (%)",
> "Average interest on new external debt commitments, private (%)",
> "Average maturity on new external debt commitments (years)",
> "Average maturity on new external debt commitments, official (years)",
> "Average maturity on new external debt commitments, private (years)",
> "Average precipitation in depth (mm per year)", "Average time to clear
> exports through customs (days)",
> "Average working hours of children, study and work, ages 7-14 (hours
> per week)",
> "Average working hours of children, study and work, female, ages 7-14
> (hours per week)",
> "Average working hours of children, study and work, male, ages 7-14
> (hours per week)",
> "Average working hours of children, working only, ages 7-14 (hours per
> week)",
> "Average working hours of children, working only, female, ages 7-14
> (hours per week)",
> "Average working hours of children, working only, male, ages 7-14
> (hours per week)",
> "Bank capital to assets ratio (%)", "Bank liquid reserves to bank
> assets ratio (%)",
> "Bank nonperforming loans to total gross loans (%)", "Battle-related
> deaths (number of people)",
> "Benefits incidence in poorest quintile (%) - All Labor Market",
> "Benefits incidence in poorest quintile (%) - All Social Assistance",
> "Benefits incidence in poorest quintile (%) - All Social Insurance",
> "Benefits incidence in poorest quintile (%) -All Social Protection and
> Labor",
> "Binding coverage, all products (%)", "Binding coverage, manufactured
> products (%)",
> "Binding coverage, primary products (%)", "Bird species, threatened",
> "Birth rate, crude (per 1,000 people)", "Births attended by skilled
> health staff (% of total)",
> "Borrowers from commercial banks (per 1,000 adults)", "Bound rate,
> simple mean, all products (%)",
> "Bound rate, simple mean, manufactured products (%)", "Bound rate,
> simple mean, primary products (%)",
> "Bribery incidence (% of firms experiencing at least one bribe payment
> request)",
> "Broad money (% of GDP)", "Broad money (current LCU)", "Broad money
> growth (annual %)",
> "Broad money to total reserves ratio", "Burden of customs procedure,
> WEF (1=extremely inefficient to 7=extremely efficient)",
> "Business extent of disclosure index (0=less disclosure to 10=more
> disclosure)",
> "Cash surplus/deficit (% of GDP)", "Cash surplus/deficit (current LCU)",
> "Cause of death, by communicable diseases and maternal, prenatal and
> nutrition conditions (% of total)",
> "Cause of death, by injury (% of total)", "Cause of death, by
> non-communicable diseases (% of total)",
> "Central government debt, total (% of GDP)", "Central government debt,
> total (current LCU)",
> "Cereal production (metric tons)", "Cereal yield (kg per hectare)",
> "Changes in inventories (constant LCU)", "Changes in inventories
> (current LCU)",
> "Changes in inventories (current US$)", "Charges for the use of
> intellectual property, payments (BoP, current US$)",
> "Charges for the use of intellectual property, receipts (BoP, current
> US$)",
> "Chemicals (% of value added in manufacturing)", "Child employment in
> agriculture (% of economically active children ages 7-14)",
> "Child employment in agriculture, female (% of female economically
> active children ages 7-14)",
> "Child employment in agriculture, male (% of male economically active
> children ages 7-14)",
> "Child employment in manufacturing (% of economically active children
> ages 7-14)",
> "Child employment in manufacturing, female (% of female economically
> active children ages 7-14)",
> "Child employment in manufacturing, male (% of male economically
> active children ages 7-14)",
> "Child employment in services (% of economically active children ages
> 7-14)",
> "Child employment in services, female (% of female economically active
> children ages 7-14)",
> "Child employment in services, male (% of male economically active
> children ages 7-14)",
> "Children in employment, female (% of female children ages 7-14)",
> "Children in employment, male (% of male children ages 7-14)",
> "Children in employment, self-employed (% of children in employment,
> ages 7-14)",
> "Children in employment, self-employed, female (% of female children
> in employment, ages 7-14)",
> "Children in employment, self-employed, male (% of male children in
> employment, ages 7-14)",
> "Children in employment, study and work (% of children in employment,
> ages 7-14)",
> "Children in employment, study and work, female (% of female children
> in employment, ages 7-14)",
> "Children in employment, study and work, male (% of male children in
> employment, ages 7-14)",
> "Children in employment, total (% of children ages 7-14)", "Children
> in employment, unpaid family workers (% of children in employment,
> ages 7-14)",
> "Children in employment, unpaid family workers, female (% of female
> children in employment, ages 7-14)",
> "Children in employment, unpaid family workers, male (% of male
> children in employment, ages 7-14)",
> "Children in employment, work only (% of children in employment, ages
> 7-14)",
> "Children in employment, work only, female (% of female children in
> employment, ages 7-14)",
> "Children in employment, work only, male (% of male children in
> employment, ages 7-14)",
> "Claims on central government (annual growth as % of broad money)",
> "Claims on central government, etc. (% GDP)", "Claims on other sectors
> of the domestic economy (% of GDP)",
> "Claims on other sectors of the domestic economy (annual growth as %
> of broad money)",
> "Claims on private sector (annual growth as % of broad money)",
> "CO2 emissions (kg per 2005 US$ of GDP)", "CO2 emissions (kg per 2011
> PPP $ of GDP)",
> "CO2 emissions (kg per PPP $ of GDP)", "CO2 emissions (kt)",
> "CO2 emissions (metric tons per capita)", "CO2 emissions from
> electricity and heat production, total (% of total fuel combustion)",
> "CO2 emissions from gaseous fuel consumption (% of total)", "CO2
> emissions from gaseous fuel consumption (kt)",
> "CO2 emissions from liquid fuel consumption (% of total)", "CO2
> emissions from liquid fuel consumption (kt)",
> "CO2 emissions from manufacturing industries and construction (% of
> total fuel combustion)",
> "CO2 emissions from other sectors, excluding residential buildings and
> commercial and public services (% of total fuel combustion)",
> "CO2 emissions from residential buildings and commercial and public
> services (% of total fuel combustion)",
> "CO2 emissions from solid fuel consumption (% of total)", "CO2
> emissions from solid fuel consumption (kt)",
> "CO2 emissions from transport (% of total fuel combustion)",
> "CO2 intensity (kg per kg of oil equivalent energy use)", "Coal rents
> (% of GDP)",
> "Combustible renewables and waste (% of total energy)", "Commercial
> bank branches (per 100,000 adults)",
> "Commercial banks and other lending (PPG + PNG) (NFL, current US$)",
> "Commercial service exports (current US$)", "Commercial service
> imports (current US$)",
> "Commitments, IBRD (COM, current US$)", "Commitments, IDA (COM,
> current US$)",
> "Commitments, official creditors (COM, current US$)", "Commitments,
> private creditors (COM, current US$)",
> "Commitments, public and publicly guaranteed (COM, current US$)",
> "Communications, computer, etc. (% of service exports, BoP)",
> "Communications, computer, etc. (% of service imports, BoP)",
> "Community health workers (per 1,000 people)", "Compensation of
> employees (% of expense)",
> "Compensation of employees (current LCU)", "Completeness of birth
> registration (%)",
> "Completeness of death registration with cause-of-death information (%)",
> "Completeness of infant death reporting (% of reported infant deaths
> to estimated infant deaths)",
> "Completeness of total death reporting (% of reported total deaths to
> estimated total deaths)",
> "Computer, communications and other services (% of commercial service
> exports)",
> "Computer, communications and other services (% of commercial service
> imports)",
> "Concessional debt (% of total external debt)", "Consumer price index
> (2010 = 100)",
> "Consumption of iodized salt (% of households)", "Container port
> traffic (TEU: 20 foot equivalent units)",
> "Contraceptive prevalence (% of women ages 15-49)", "Contributing
> family workers, female (% of females employed)",
> "Contributing family workers, male (% of males employed)",
> "Contributing family workers, total (% of total employed)",
> "Cost of business start-up procedures (% of GNI per capita)",
> "Cost to export (US$ per container)", "Cost to import (US$ per
> container)",
> "Coverage (%) - All Labor Market", "Coverage (%) - All Social
> Assistance",
> "Coverage (%) - All Social Insurance", "Coverage (%) -All Social
> Protection and Labor",
> "Crop production index (2004-2006 = 100)", "Currency composition of
> PPG debt, all other currencies (%)",
> "Currency composition of PPG debt, Deutsche mark (%)", "Currency
> composition of PPG debt, Euro (%)",
> "Currency composition of PPG debt, French franc (%)", "Currency
> composition of PPG debt, Japanese yen (%)",
> "Currency composition of PPG debt, Multiple currencies (%)",
> "Currency composition of PPG debt, Pound sterling (%)", "Currency
> composition of PPG debt, SDR (%)",
> "Currency composition of PPG debt, Swiss franc (%)", "Currency
> composition of PPG debt, U.S. dollars (%)",
> "Current account balance (% of GDP)", "Current account balance (BoP,
> current US$)",
> "Current education expenditure, primary (% of total expenditure in
> primary public institutions)",
> "Current education expenditure, secondary (% of total expenditure in
> secondary public institutions)",
> "Current education expenditure, tertiary (% of total expenditure in
> tertiary public institutions)",
> "Current education expenditure, total (% of total expenditure in
> public institutions)",
> "Customs and other import duties (% of tax revenue)", "Customs and
> other import duties (current LCU)",
> "Death rate, crude (per 1,000 people)", "Debt buyback (current US$)",
> "Debt forgiveness grants (current US$)", "Debt forgiveness or
> reduction (current US$)",
> "Debt service (PPG and IMF only, % of exports of goods, services and
> primary income)",
> "Debt service on external debt, long-term (TDS, current US$)",
> "Debt service on external debt, private nonguaranteed (PNG) (TDS,
> current US$)",
> "Debt service on external debt, public and publicly guaranteed (PPG)
> (TDS, current US$)",
> "Debt service on external debt, total (TDS, current US$)", "Debt stock
> reduction (current US$)",
> "Debt stock rescheduled (current US$)", "DEC alternative conversion
> factor (LCU per US$)",
> "Delay in obtaining an electrical connection (days)", "Deposit
> interest rate (%)",
> "Depositors with commercial banks (per 1,000 adults)", "Depth of
> credit information index (0=low to 8=high)",
> "Diabetes prevalence (% of population ages 20 to 79)", "Diarrhea
> treatment (% of children under 5 who received ORS packet)",
> "Disaster risk reduction progress score (1-5 scale; 5=best)",
> "Disbursements on external debt, long-term (DIS, current US$)",
> "Disbursements on external debt, long-term + IMF (DIS, current US$)",
> "Disbursements on external debt, private nonguaranteed (PNG) (DIS,
> current US$)",
> "Disbursements on external debt, public and publicly guaranteed (PPG)
> (DIS, current US$)",
> "Discrepancy in expenditure estimate of GDP (constant LCU)",
> "Discrepancy in expenditure estimate of GDP (current LCU)", "Distance
> to frontier score (0=lowest performance to 100=frontier)",
> "Documents to export (number)", "Documents to import (number)",
> "Domestic credit provided by financial sector (% of GDP)", "Domestic
> credit to private sector (% of GDP)",
> "Domestic credit to private sector by banks (% of GDP)", "Droughts,
> floods, extreme temperatures (% of population, average 1990-2009)",
> "Ease of doing business index (1=most business-friendly regulations)",
> "EBRD, private nonguaranteed (NFL, current US$)", "Electric power
> consumption (kWh per capita)",
> "Electric power transmission and distribution losses (% of output)",
> "Electricity production from coal sources (% of total)", "Electricity
> production from hydroelectric sources (% of total)",
> "Electricity production from natural gas sources (% of total)",
> "Electricity production from nuclear sources (% of total)",
> "Electricity production from oil sources (% of total)",
> "Electricity production from oil, gas and coal sources (% of total)",
> "Electricity production from renewable sources, excluding
> hydroelectric (% of total)",
> "Electricity production from renewable sources, excluding
> hydroelectric (kWh)",
> "Emigration rate of tertiary educated (% of total tertiary educated
> population)",
> "Employers, female (% of employment)", "Employers, male (% of
> employment)",
> "Employers, total (% of employment)", "Employment in agriculture (% of
> total employment)",
> "Employment in agriculture, female (% of female employment)",
> "Employment in agriculture, male (% of male employment)", "Employment
> in industry (% of total employment)",
> "Employment in industry, female (% of female employment)", "Employment
> in industry, male (% of male employment)",
> "Employment in services (% of total employment)", "Employment in
> services, female (% of female employment)",
> "Employment in services, male (% of male employment)", "Employment to
> population ratio, 15+, female (%) (modeled ILO estimate)",
> "Employment to population ratio, 15+, female (%) (national estimate)",
> "Employment to population ratio, 15+, male (%) (modeled ILO estimate)",
> "Employment to population ratio, 15+, male (%) (national estimate)",
> "Employment to population ratio, 15+, total (%) (modeled ILO estimate)",
> "Employment to population ratio, 15+, total (%) (national estimate)",
> "Employment to population ratio, ages 15-24, female (%) (modeled ILO
> estimate)",
> "Employment to population ratio, ages 15-24, female (%) (national
> estimate)",
> "Employment to population ratio, ages 15-24, male (%) (modeled ILO
> estimate)",
> "Employment to population ratio, ages 15-24, male (%) (national
> estimate)",
> "Employment to population ratio, ages 15-24, total (%) (modeled ILO
> estimate)",
> "Employment to population ratio, ages 15-24, total (%) (national
> estimate)",
> "Energy imports, net (% of energy use)", "Energy intensity level of
> primary energy (MJ/$2011 PPP GDP)",
> "Energy related methane emissions (% of total)", "Energy use (kg of
> oil equivalent per capita)",
> "Energy use (kg of oil equivalent) per $1,000 GDP (constant 2011 PPP)",
> "Enrolment in primary education, both sexes (number)", "Enrolment in
> secondary education, both sexes (number)",
> "Enrolment in secondary general, both sexes (number)", "Enrolment in
> secondary vocational, both sexes (number)",
> "Exclusive breastfeeding (% of children under 6 months)", "Expenditure
> on education as % of total government expenditure (%)",
> "Expenditure on primary as % of government expenditure on education (%)",
> "Expenditure on secondary as % of government expenditure on education
> (%)",
> "Expenditure on tertiary as % of government expenditure on education
> (%)",
> "Expense (% of GDP)", "Expense (current LCU)", "Export value index
> (2000 = 100)",
> "Export volume index (2000 = 100)", "Exports as a capacity to import
> (constant LCU)",
> "Exports of goods and services (% of GDP)", "Exports of goods and
> services (annual % growth)",
> "Exports of goods and services (BoP, current US$)", "Exports of goods
> and services (constant 2005 US$)",
> "Exports of goods and services (constant LCU)", "Exports of goods and
> services (current LCU)",
> "Exports of goods and services (current US$)", "Exports of goods,
> services and primary income (BoP, current US$)",
> "External balance on goods and services (% of GDP)", "External balance
> on goods and services (constant LCU)",
> "External balance on goods and services (current LCU)", "External
> balance on goods and services (current US$)",
> "External debt stocks (% of exports of goods, services and primary
> income)",
> "External debt stocks (% of GNI)", "External debt stocks, concessional
> (DOD, current US$)",
> "External debt stocks, long-term (DOD, current US$)", "External debt
> stocks, long-term private sector (DOD, current US$)",
> "External debt stocks, long-term public sector (DOD, current US$)",
> "External debt stocks, private nonguaranteed (PNG) (DOD, current US$)",
> "External debt stocks, public and publicly guaranteed (PPG) (DOD,
> current US$)",
> "External debt stocks, short-term (DOD, current US$)", "External debt
> stocks, total (DOD, current US$)",
> "External debt stocks, variable rate (DOD, current US$)", "External
> resources for health (% of total expenditure on health)",
> "Female legislators, senior officials and managers (% of total)",
> "Fertility rate, total (births per woman)", "Fertilizer consumption (%
> of fertilizer production)",
> "Fertilizer consumption (kilograms per hectare of arable land)",
> "Final consumption expenditure (constant 2005 US$)", "Final
> consumption expenditure (constant LCU)",
> "Final consumption expenditure (current LCU)", "Final consumption
> expenditure (current US$)",
> "Final consumption expenditure, etc. (% of GDP)", "Final consumption
> expenditure, etc. (annual % growth)",
> "Final consumption expenditure, etc. (constant 2005 US$)", "Final
> consumption expenditure, etc. (constant LCU)",
> "Final consumption expenditure, etc. (current LCU)", "Final
> consumption expenditure, etc. (current US$)",
> "Firms competing against unregistered firms (% of firms)", "Firms
> expected to give gifts in meetings with tax officials (% of firms)",
> "Firms formally registered when operations started (% of firms)",
> "Firms offering formal training (% of firms)", "Firms that do not
> report all sales for tax purposes (% of firms)",
> "Firms using banks to finance investment (% of firms)", "Firms using
> banks to finance working capital (% of firms)",
> "Firms with female participation in ownership (% of firms)",
> "Firms with female top manager (% of firms)", "Fish species, threatened",
> "Fixed broadband subscriptions", "Fixed broadband subscriptions (per
> 100 people)",
> "Fixed telephone subscriptions", "Fixed telephone subscriptions (per
> 100 people)",
> "Food exports (% of merchandise exports)", "Food imports (% of
> merchandise imports)",
> "Food production index (2004-2006 = 100)", "Food, beverages and
> tobacco (% of value added in manufacturing)",
> "Foreign direct investment, net (BoP, current US$)", "Foreign direct
> investment, net inflows (% of GDP)",
> "Foreign direct investment, net inflows (BoP, current US$)",
> "Foreign direct investment, net outflows (% of GDP)", "Forest area (%
> of land area)",
> "Forest area (sq. km)", "Forest rents (% of GDP)", "Fossil fuel energy
> consumption (% of total)",
> "Fuel exports (% of merchandise exports)", "Fuel imports (% of
> merchandise imports)",
> "GDP (constant LCU)", "GDP (current LCU)", "GDP at market prices
> (constant 2005 US$)",
> "GDP at market prices (current US$)", "GDP deflator (base year varies
> by country)",
> "GDP growth (annual %)", "GDP per capita (constant 2005 US$)",
> "GDP per capita (constant LCU)", "GDP per capita (current LCU)",
> "GDP per capita (current US$)", "GDP per capita growth (annual %)",
> "GDP per capita, PPP (constant 2011 international $)", "GDP per
> capita, PPP (current international $)",
> "GDP per person employed (constant 1990 PPP $)", "GDP per unit of
> energy use (constant 2011 PPP $ per kg of oil equivalent)",
> "GDP per unit of energy use (PPP $ per kg of oil equivalent)",
> "GDP, PPP (constant 2011 international $)", "GDP, PPP (current
> international $)",
> "GEF benefits index for biodiversity (0 = no biodiversity potential to
> 100 = maximum)",
> "General government final consumption expenditure (% of GDP)",
> "General government final consumption expenditure (annual % growth)",
> "General government final consumption expenditure (constant 2005 US$)",
> "General government final consumption expenditure (constant LCU)",
> "General government final consumption expenditure (current LCU)",
> "General government final consumption expenditure (current US$)",
> "GHG net emissions/removals by LUCF (Mt of CO2 equivalent)",
> "GINI index (World Bank estimate)", "GNI (constant 2005 US$)",
> "GNI (constant LCU)", "GNI (current LCU)", "GNI (current US$)",
> "GNI growth (annual %)", "GNI per capita (constant 2005 US$)",
> "GNI per capita (constant LCU)", "GNI per capita (current LCU)",
> "GNI per capita growth (annual %)", "GNI per capita, Atlas method
> (current US$)",
> "GNI per capita, PPP (constant 2011 international $)", "GNI per
> capita, PPP (current international $)",
> "GNI, Atlas method (current US$)", "GNI, PPP (constant 2011
> international $)",
> "GNI, PPP (current international $)", "Goods and services expense (%
> of expense)",
> "Goods and services expense (current LCU)", "Goods exports (BoP,
> current US$)",
> "Goods imports (BoP, current US$)", "Government expenditure on
> education as % of GDP (%)",
> "Government expenditure per primary student as % of GDP per capita (%)",
> "Government expenditure per secondary student as % of GDP per capita
> (%)",
> "Government expenditure per tertiary student as % of GDP per capita (%)",
> "Grants and other revenue (% of revenue)", "Grants and other revenue
> (current LCU)",
> "Grants, excluding technical cooperation (BoP, current US$)",
> "Gross capital formation (% of GDP)", "Gross capital formation (annual
> % growth)",
> "Gross capital formation (constant 2005 US$)", "Gross capital
> formation (constant LCU)",
> "Gross capital formation (current LCU)", "Gross capital formation
> (current US$)",
> "Gross domestic income (constant 2005 US$)", "Gross domestic income
> (constant LCU)",
> "Gross domestic savings (% of GDP)", "Gross domestic savings (constant
> LCU)",
> "Gross domestic savings (current LCU)", "Gross domestic savings
> (current US$)",
> "Gross enrolment ratio, pre-primary, both sexes (%)", "Gross enrolment
> ratio, pre-primary, female (%)",
> "Gross enrolment ratio, pre-primary, male (%)", "Gross enrolment
> ratio, primary and secondary, gender parity index (GPI)",
> "Gross enrolment ratio, primary, both sexes (%)", "Gross enrolment
> ratio, primary, female (%)",
> "Gross enrolment ratio, primary, gender parity index (GPI)",
> "Gross enrolment ratio, primary, male (%)", "Gross enrolment ratio,
> secondary, both sexes (%)",
> "Gross enrolment ratio, secondary, female (%)", "Gross enrolment
> ratio, secondary, gender parity index (GPI)",
> "Gross enrolment ratio, secondary, male (%)", "Gross enrolment ratio,
> tertiary, both sexes (%)",
> "Gross enrolment ratio, tertiary, female (%)", "Gross enrolment ratio,
> tertiary, gender parity index (GPI)",
> "Gross enrolment ratio, tertiary, male (%)", "Gross fixed capital
> formation (% of GDP)",
> "Gross fixed capital formation (annual % growth)", "Gross fixed
> capital formation (constant 2005 US$)",
> "Gross fixed capital formation (constant LCU)", "Gross fixed capital
> formation (current LCU)",
> "Gross fixed capital formation (current US$)", "Gross fixed capital
> formation, private sector (% of GDP)",
> "Gross fixed capital formation, private sector (current LCU)",
> "Gross intake ratio to Grade 1 of primary education, both sexes (%)",
> "Gross intake ratio to Grade 1 of primary education, female (%)",
> "Gross intake ratio to Grade 1 of primary education, male (%)",
> "Gross national expenditure (% of GDP)", "Gross national expenditure
> (constant 2005 US$)",
> "Gross national expenditure (constant LCU)", "Gross national
> expenditure (current LCU)",
> "Gross national expenditure (current US$)", "Gross national
> expenditure deflator (base year varies by country)",
> "Gross savings (% of GDP)", "Gross savings (% of GNI)", "Gross savings
> (current LCU)",
> "Gross savings (current US$)", "Gross value added at factor cost
> (constant 2005 US$)",
> "Gross value added at factor cost (constant LCU)", "Gross value added
> at factor cost (current LCU)",
> "Gross value added at factor cost (current US$)", "Health expenditure
> per capita (current US$)",
> "Health expenditure per capita, PPP (constant 2011 international $)",
> "Health expenditure, private (% of GDP)", "Health expenditure, public
> (% of GDP)",
> "Health expenditure, public (% of government expenditure)", "Health
> expenditure, public (% of total health expenditure)",
> "Health expenditure, total (% of GDP)", "HFC gas emissions (thousand
> metric tons of CO2 equivalent)",
> "High-technology exports (% of manufactured exports)",
> "High-technology exports (current US$)",
> "Hospital beds (per 1,000 people)", "Household final consumption
> expenditure (annual % growth)",
> "Household final consumption expenditure (constant 2005 US$)",
> "Household final consumption expenditure (constant LCU)", "Household
> final consumption expenditure (current LCU)",
> "Household final consumption expenditure (current US$)", "Household
> final consumption expenditure per capita (constant 2005 US$)",
> "Household final consumption expenditure per capita growth (annual %)",
> "Household final consumption expenditure, etc. (% of GDP)", "Household
> final consumption expenditure, etc. (annual % growth)",
> "Household final consumption expenditure, etc. (constant 2005 US$)",
> "Household final consumption expenditure, etc. (constant LCU)",
> "Household final consumption expenditure, etc. (current LCU)",
> "Household final consumption expenditure, etc. (current US$)",
> "Household final consumption expenditure, PPP (constant 2011
> international $)",
> "Household final consumption expenditure, PPP (current international $)",
> "IBRD loans and IDA credits (DOD, current US$)", "ICT goods exports (%
> of total goods exports)",
> "ICT goods imports (% total goods imports)", "ICT service exports (%
> of service exports, BoP)",
> "ICT service exports (BoP, current US$)", "IDA grants (current US$)",
> "IFC, private nonguaranteed (NFL, current US$)", "IMF charges (INT,
> current US$)",
> "IMF purchases (DIS, current US$)", "IMF repurchases (AMT, current US$)",
> "IMF repurchases and charges (TDS, current US$)", "Immunization, DPT
> (% of children ages 12-23 months)",
> "Immunization, measles (% of children ages 12-23 months)", "Import
> value index (2000 = 100)",
> "Import volume index (2000 = 100)", "Imports of goods and services (%
> of GDP)",
> "Imports of goods and services (annual % growth)", "Imports of goods
> and services (BoP, current US$)",
> "Imports of goods and services (constant 2005 US$)", "Imports of goods
> and services (constant LCU)",
> "Imports of goods and services (current LCU)", "Imports of goods and
> services (current US$)",
> "Imports of goods, services and primary income (BoP, current US$)",
> "Improved sanitation facilities (% of population with access)",
> "Improved sanitation facilities, rural (% of rural population with
> access)",
> "Improved sanitation facilities, urban (% of urban population with
> access)",
> "Improved water source (% of population with access)", "Improved water
> source, rural (% of rural population with access)",
> "Improved water source, urban (% of urban population with access)",
> "Incidence of tuberculosis (per 100,000 people)", "Income share held
> by fourth 20%",
> "Income share held by highest 10%", "Income share held by highest 20%",
> "Income share held by lowest 10%", "Income share held by lowest 20%",
> "Income share held by second 20%", "Income share held by third 20%",
> "Industrial nitrous oxide emissions (thousand metric tons of CO2
> equivalent)",
> "Industry, value added (% of GDP)", "Industry, value added (annual %
> growth)",
> "Industry, value added (constant 2005 US$)", "Industry, value added
> (constant LCU)",
> "Industry, value added (current LCU)", "Industry, value added (current
> US$)",
> "Inflation, consumer prices (annual %)", "Inflation, GDP deflator
> (annual %)",
> "Informal payments to public officials (% of firms)", "Insurance and
> financial services (% of commercial service exports)",
> "Insurance and financial services (% of commercial service imports)",
> "Insurance and financial services (% of service exports, BoP)",
> "Insurance and financial services (% of service imports, BoP)",
> "Intentional homicides (per 100,000 people)", "Interest arrears,
> long-term DOD (US$)",
> "Interest arrears, official creditors (current US$)", "Interest
> arrears, private creditors (current US$)",
> "Interest forgiven (current US$)", "Interest payments (% of expense)",
> "Interest payments (% of revenue)", "Interest payments (current LCU)",
> "Interest payments on external debt (% of exports of goods, services
> and primary income)",
> "Interest payments on external debt (% of GNI)", "Interest payments on
> external debt, long-term (INT, current US$)",
> "Interest payments on external debt, private nonguaranteed (PNG) (INT,
> current US$)",
> "Interest payments on external debt, public and publicly guaranteed
> (PPG) (INT, current US$)",
> "Interest payments on external debt, short-term (INT, current US$)",
> "Interest payments on external debt, total (INT, current US$)",
> "Interest rate spread (lending rate minus deposit rate, %)",
> "Interest rescheduled (capitalized) (current US$)", "Interest
> rescheduled, official (current US$)",
> "Interest rescheduled, private (current US$)", "Internally displaced
> persons (number, high estimate)",
> "Internally displaced persons (number, low estimate)", "International
> migrant stock (% of population)",
> "International migrant stock, total", "International tourism,
> expenditures (% of total imports)",
> "International tourism, expenditures (current US$)", "International
> tourism, expenditures for passenger transport items (current US$)",
> "International tourism, expenditures for travel items (current US$)",
> "International tourism, number of arrivals", "International tourism,
> number of departures",
> "International tourism, receipts (% of total exports)", "International
> tourism, receipts (current US$)",
> "International tourism, receipts for passenger transport items
> (current US$)",
> "International tourism, receipts for travel items (current US$)",
> "Internationally-recognized quality certification (% of firms)",
> "Internet users (per 100 people)", "Investment in energy with private
> participation (current US$)",
> "Investment in telecoms with private participation (current US$)",
> "Investment in transport with private participation (current US$)",
> "Investment in water and sanitation with private participation
> (current US$)",
> "Labor force participation rate for ages 15-24, female (%) (modeled
> ILO estimate)",
> "Labor force participation rate for ages 15-24, female (%) (national
> estimate)",
> "Labor force participation rate for ages 15-24, male (%) (modeled ILO
> estimate)",
> "Labor force participation rate for ages 15-24, male (%) (national
> estimate)",
> "Labor force participation rate for ages 15-24, total (%) (modeled ILO
> estimate)",
> "Labor force participation rate for ages 15-24, total (%) (national
> estimate)",
> "Labor force participation rate, female (% of female population ages
> 15-64) (modeled ILO estimate)",
> "Labor force participation rate, female (% of female population ages
> 15+) (modeled ILO estimate)",
> "Labor force participation rate, female (% of female population ages
> 15+) (national estimate)",
> "Labor force participation rate, male (% of male population ages
> 15-64) (modeled ILO estimate)",
> "Labor force participation rate, male (% of male population ages 15+)
> (modeled ILO estimate)",
> "Labor force participation rate, male (% of male population ages 15+)
> (national estimate)",
> "Labor force participation rate, total (% of total population ages
> 15-64) (modeled ILO estimate)",
> "Labor force participation rate, total (% of total population ages
> 15+) (modeled ILO estimate)",
> "Labor force participation rate, total (% of total population ages
> 15+) (national estimate)",
> "Labor force with primary education (% of total)", "Labor force with
> primary education, female (% of female labor force)",
> "Labor force with primary education, male (% of male labor force)",
> "Labor force with secondary education (% of total)", "Labor force with
> secondary education, female (% of female labor force)",
> "Labor force with secondary education, male (% of male labor force)",
> "Labor force with tertiary education (% of total)", "Labor force with
> tertiary education, female (% of female labor force)",
> "Labor force with tertiary education, male (% of male labor force)",
> "Labor force, female (% of total labor force)", "Labor force, total",
> "Labor tax and contributions (% of commercial profits)", "Land area
> (sq. km)",
> "Land area where elevation is below 5 meters (% of total land area)",
> "Land under cereal production (hectares)", "Lead time to export,
> median case (days)",
> "Lead time to import, median case (days)", "Lending interest rate (%)",
> "Life expectancy at birth, female (years)", "Life expectancy at birth,
> male (years)",
> "Life expectancy at birth, total (years)", "Lifetime risk of maternal
> death (%)",
> "Lifetime risk of maternal death (1 in: rate varies by country)",
> "Liner shipping connectivity index (maximum value in 2004 = 100)",
> "Listed domestic companies, total", "Livestock production index
> (2004-2006 = 100)",
> "Logistics performance index: Ability to track and trace consignments
> (1=low to 5=high)",
> "Logistics performance index: Competence and quality of logistics
> services (1=low to 5=high)",
> "Logistics performance index: Ease of arranging competitively priced
> shipments (1=low to 5=high)",
> "Logistics performance index: Efficiency of customs clearance process
> (1=low to 5=high)",
> "Logistics performance index: Frequency with which shipments reach
> consignee within scheduled or expected time (1=low to 5=high)",
> "Logistics performance index: Overall (1=low to 5=high)", "Logistics
> performance index: Quality of trade and transport-related
> infrastructure (1=low to 5=high)",
> "Long-term unemployment (% of total unemployment)", "Long-term
> unemployment, female (% of female unemployment)",
> "Long-term unemployment, male (% of male unemployment)", "Losses due
> to theft, robbery, vandalism, and arson (% sales)",
> "Low-birthweight babies (% of births)", "Lower secondary completion
> rate, both sexes (%)",
> "Lower secondary completion rate, female (%)", "Lower secondary
> completion rate, male (%)",
> "Machinery and transport equipment (% of value added in manufacturing)",
> "Mammal species, threatened", "Manufactures exports (% of merchandise
> exports)",
> "Manufactures imports (% of merchandise imports)", "Manufacturing,
> value added (% of GDP)",
> "Manufacturing, value added (annual % growth)", "Manufacturing, value
> added (constant 2005 US$)",
> "Manufacturing, value added (constant LCU)", "Manufacturing, value
> added (current LCU)",
> "Manufacturing, value added (current US$)", "Marine protected areas (%
> of territorial waters)",
> "Market capitalization of listed domestic companies (% of GDP)",
> "Market capitalization of listed domestic companies (current US$)",
> "Maternal mortality ratio (modeled estimate, per 100,000 live births)",
> "Maternal mortality ratio (national estimate, per 100,000 live births)",
> "Merchandise exports (current US$)", "Merchandise exports by the
> reporting economy (current US$)",
> "Merchandise exports by the reporting economy, residual (% of total
> merchandise exports)",
> "Merchandise exports to developing economies in East Asia & Pacific (%
> of total merchandise exports)",
> "Merchandise exports to developing economies in Europe & Central Asia
> (% of total merchandise exports)",
> "Merchandise exports to developing economies in Latin America & the
> Caribbean (% of total merchandise exports)",
> "Merchandise exports to developing economies in Middle East & North
> Africa (% of total merchandise exports)",
> "Merchandise exports to developing economies in South Asia (% of total
> merchandise exports)",
> "Merchandise exports to developing economies in Sub-Saharan Africa (%
> of total merchandise exports)",
> "Merchandise exports to developing economies outside region (% of
> total merchandise exports)",
> "Merchandise exports to developing economies within region (% of total
> merchandise exports)",
> "Merchandise exports to economies in the Arab World (% of total
> merchandise exports)",
> "Merchandise exports to high-income economies (% of total merchandise
> exports)",
> "Merchandise imports (current US$)", "Merchandise imports by the
> reporting economy (current US$)",
> "Merchandise imports by the reporting economy, residual (% of total
> merchandise imports)",
> "Merchandise imports from developing economies in East Asia & Pacific
> (% of total merchandise imports)",
> "Merchandise imports from developing economies in Europe & Central
> Asia (% of total merchandise imports)",
> "Merchandise imports from developing economies in Latin America & the
> Caribbean (% of total merchandise imports)",
> "Merchandise imports from developing economies in Middle East & North
> Africa (% of total merchandise imports)",
> "Merchandise imports from developing economies in South Asia (% of
> total merchandise imports)",
> "Merchandise imports from developing economies in Sub-Saharan Africa
> (% of total merchandise imports)",
> "Merchandise imports from developing economies outside region (% of
> total merchandise imports)",
> "Merchandise imports from developing economies within region (% of
> total merchandise imports)",
> "Merchandise imports from economies in the Arab World (% of total
> merchandise imports)",
> "Merchandise imports from high-income economies (% of total
> merchandise imports)",
> "Merchandise trade (% of GDP)", "Methane emissions (kt of CO2
> equivalent)",
> "Methane emissions in energy sector (thousand metric tons of CO2
> equivalent)",
> "Methodology assessment of statistical capacity (scale 0 - 100)",
> "Military expenditure (% of central government expenditure)",
> "Military expenditure (% of GDP)", "Military expenditure (current LCU)",
> "Mineral rents (% of GDP)", "Mobile cellular subscriptions",
> "Mobile cellular subscriptions (per 100 people)", "Money (current LCU)",
> "Money and quasi money (M2) (current LCU)", "Money and quasi money
> (M2) as % of GDP",
> "Money and quasi money (M2) to total reserves ratio", "Money and quasi
> money growth (annual %)",
> "Mortality rate, adult, female (per 1,000 female adults)", "Mortality
> rate, adult, male (per 1,000 male adults)",
> "Mortality rate, infant (per 1,000 live births)", "Mortality rate,
> infant, female (per 1,000 live births)",
> "Mortality rate, infant, male (per 1,000 live births)", "Mortality
> rate, neonatal (per 1,000 live births)",
> "Mortality rate, under-5 (per 1,000)", "Mortality rate, under-5,
> female (per 1,000 live births)",
> "Mortality rate, under-5, male (per 1,000 live births)", "Multilateral
> debt (% of total external debt)",
> "Multilateral debt service (% of public and publicly guaranteed debt
> service)",
> "Multilateral debt service (TDS, current US$)", "Natural gas rents (%
> of GDP)",
> "Net barter terms of trade index (2000 = 100)", "Net bilateral aid
> flows from DAC donors, Australia (current US$)",
> "Net bilateral aid flows from DAC donors, Austria (current US$)",
> "Net bilateral aid flows from DAC donors, Belgium (current US$)",
> "Net bilateral aid flows from DAC donors, Canada (current US$)",
> "Net bilateral aid flows from DAC donors, Czech Republic (current US$)",
> "Net bilateral aid flows from DAC donors, Denmark (current US$)",
> "Net bilateral aid flows from DAC donors, European Union institutions
> (current US$)",
> "Net bilateral aid flows from DAC donors, Finland (current US$)",
> "Net bilateral aid flows from DAC donors, France (current US$)",
> "Net bilateral aid flows from DAC donors, Germany (current US$)",
> "Net bilateral aid flows from DAC donors, Greece (current US$)",
> "Net bilateral aid flows from DAC donors, Ireland (current US$)",
> "Net bilateral aid flows from DAC donors, Italy (current US$)",
> "Net bilateral aid flows from DAC donors, Japan (current US$)",
> "Net bilateral aid flows from DAC donors, Korea, Rep. (current US$)",
> "Net bilateral aid flows from DAC donors, Luxembourg (current US$)",
> "Net bilateral aid flows from DAC donors, Netherlands (current US$)",
> "Net bilateral aid flows from DAC donors, New Zealand (current US$)",
> "Net bilateral aid flows from DAC donors, Norway (current US$)",
> "Net bilateral aid flows from DAC donors, Poland (current US$)",
> "Net bilateral aid flows from DAC donors, Portugal (current US$)",
> "Net bilateral aid flows from DAC donors, Slovak Republic (current US$)",
> "Net bilateral aid flows from DAC donors, Slovenia (current US$)",
> "Net bilateral aid flows from DAC donors, Spain (current US$)",
> "Net bilateral aid flows from DAC donors, Sweden (current US$)",
> "Net bilateral aid flows from DAC donors, Switzerland (current US$)",
> "Net bilateral aid flows from DAC donors, Total (current US$)",
> "Net bilateral aid flows from DAC donors, United Kingdom (current US$)",
> "Net bilateral aid flows from DAC donors, United States (current US$)",
> "Net capital account (BoP, current US$)", "Net change in interest
> arrears (current US$)",
> "Net current transfers from abroad (constant LCU)", "Net current
> transfers from abroad (current LCU)",
> "Net current transfers from abroad (current US$)", "Net domestic
> credit (current LCU)",
> "Net enrolment rate, primary, both sexes (%)", "Net enrolment rate,
> primary, female (%)",
> "Net enrolment rate, primary, male (%)", "Net enrolment rate,
> secondary, both sexes (%)",
> "Net enrolment rate, secondary, female (%)", "Net enrolment rate,
> secondary, male (%)",
> "Net errors and omissions (BoP, current US$)", "Net financial account
> (BoP, current US$)",
> "Net financial flows, bilateral (NFL, current US$)", "Net financial
> flows, IBRD (NFL, current US$)",
> "Net financial flows, IDA (NFL, current US$)", "Net financial flows,
> IMF concessional (NFL, current US$)",
> "Net financial flows, IMF nonconcessional (NFL, current US$)",
> "Net financial flows, multilateral (NFL, current US$)", "Net financial
> flows, others (NFL, current US$)",
> "Net financial flows, RDB concessional (NFL, current US$)", "Net
> financial flows, RDB nonconcessional (NFL, current US$)",
> "Net flows on external debt, long-term (NFL, current US$)", "Net flows
> on external debt, private nonguaranteed (PNG) (NFL, current US$)",
> "Net flows on external debt, public and publicly guaranteed (PPG)
> (NFL, current US$)",
> "Net flows on external debt, short-term (NFL, current US$)",
> "Net flows on external debt, total (NFL, current US$)", "Net foreign
> assets (current LCU)",
> "Net income from abroad (constant LCU)", "Net income from abroad
> (current LCU)",
> "Net income from abroad (current US$)", "Net incurrence of
> liabilities, domestic (% of GDP)",
> "Net incurrence of liabilities, domestic (current LCU)", "Net
> incurrence of liabilities, foreign (% of GDP)",
> "Net incurrence of liabilities, foreign (current LCU)", "Net intake
> rate to Grade 1 of primary education, both sexes (%)",
> "Net intake rate to Grade 1 of primary education, female (%)",
> "Net intake rate to Grade 1 of primary education, male (%)",
> "Net migration", "Net ODA received (% of central government expense)",
> "Net ODA received (% of GNI)", "Net ODA received (% of gross capital
> formation)",
> "Net ODA received (% of imports of goods, services and primary income)",
> "Net ODA received per capita (current US$)", "Net official aid
> received (constant 2012 US$)",
> "Net official aid received (current US$)", "Net official development
> assistance and official aid received (constant 2012 US$)",
> "Net official development assistance and official aid received
> (current US$)",
> "Net official development assistance received (constant 2012 US$)",
> "Net official development assistance received (current US$)",
> "Net official flows from UN agencies, IAEA (current US$)", "Net
> official flows from UN agencies, IFAD (current US$)",
> "Net official flows from UN agencies, UNAIDS (current US$)",
> "Net official flows from UN agencies, UNDP (current US$)", "Net
> official flows from UN agencies, UNFPA (current US$)",
> "Net official flows from UN agencies, UNHCR (current US$)", "Net
> official flows from UN agencies, UNICEF (current US$)",
> "Net official flows from UN agencies, UNTA (current US$)", "Net
> official flows from UN agencies, WFP (current US$)",
> "Net primary income (BoP, current US$)", "Net secondary income (BoP,
> current US$)",
> "Net taxes on products (constant LCU)", "Net taxes on products
> (current LCU)",
> "Net taxes on products (current US$)", "Net trade in goods (BoP,
> current US$)",
> "Net trade in goods and services (BoP, current US$)", "Net transfers
> on external debt, long-term (NTR, current US$)",
> "Net transfers on external debt, private nonguaranteed (PNG) (NTR,
> current US$)",
> "Net transfers on external debt, public and publicly guaranteed (PPG)
> (NTR, current US$)",
> "Net transfers on external debt, total (NTR, current US$)", "New
> business density (new registrations per 1,000 people ages 15-64)",
> "New businesses registered (number)", "Nitrous oxide emissions
> (thousand metric tons of CO2 equivalent)",
> "Nitrous oxide emissions in energy sector (thousand metric tons of CO2
> equivalent)",
> "Nitrous oxide emissions in industrial and energy processes (% of
> total nitrous oxide emissions)",
> "Number of infant deaths", "Number of maternal deaths", "Number of
> neonatal deaths",
> "Number of under-five deaths", "Number of visits or required meetings
> with tax officials",
> "Nurses and midwives (per 1,000 people)", "Official entrance age to
> lower secondary education (years)",
> "Official entrance age to primary education (years)", "Official
> exchange rate (LCU per US$, period average)",
> "Oil rents (% of GDP)", "Ores and metals exports (% of merchandise
> exports)",
> "Ores and metals imports (% of merchandise imports)", "Other expense
> (% of expense)",
> "Other expense (current LCU)", "Other greenhouse gas emissions, HFC,
> PFC and SF6 (thousand metric tons of CO2 equivalent)",
> "Other manufacturing (% of value added in manufacturing)", "Other
> taxes (% of revenue)",
> "Other taxes (current LCU)", "Other taxes payable by businesses (% of
> commercial profits)",
> "Out-of-pocket health expenditure (% of private expenditure on health)",
> "Out-of-pocket health expenditure (% of total expenditure on health)",
> "Out-of-school children of primary school age, both sexes (number)",
> "Out-of-school children of primary school age, female (number)",
> "Out-of-school children of primary school age, male (number)",
> "Overall level of statistical capacity (scale 0 - 100)", "Part time
> employment, female (% of total female employment)",
> "Part time employment, female (% of total part time employment)",
> "Part time employment, male (% of total male employment)", "Part time
> employment, total (% of total employment)",
> "Patent applications, nonresidents", "Patent applications, residents",
> "Percentage of enrolment in primary education in private institutions
> (%)",
> "Percentage of enrolment in secondary education in private
> institutions (%)",
> "Percentage of female teachers in primary education who are trained,
> female (%)",
> "Percentage of male teachers in primary education who are trained,
> male (%)",
> "Percentage of repeaters in primary education, all grades, both sexes
> (%)",
> "Percentage of repeaters in primary education, all grades, female (%)",
> "Percentage of repeaters in primary education, all grades, male (%)",
> "Percentage of repeaters in secondary general education, all grades,
> both sexes (%)",
> "Percentage of repeaters in secondary general education, all grades,
> female (%)",
> "Percentage of repeaters in secondary general education, all grades,
> male (%)",
> "Percentage of students in primary education who are female (%)",
> "Percentage of students in secondary education who are female (%)",
> "Percentage of students in secondary general education who are female
> (%)",
> "Percentage of students in secondary vocational education who are
> female (%)",
> "Percentage of teachers in primary education who are female (%)",
> "Percentage of teachers in primary education who are trained, both
> sexes (%)",
> "Percentage of teachers in secondary education who are female (%)",
> "Percentage of teachers in tertiary education who are female (%)",
> "Periodicity and timeliness assessment of statistical capacity (scale
> 0 - 100)",
> "Permanent cropland (% of land area)", "Personal remittances, paid
> (current US$)",
> "Personal remittances, received (% of GDP)", "Personal remittances,
> received (current US$)",
> "Personal transfers, receipts (BoP, current US$)", "PFC gas emissions
> (thousand metric tons of CO2 equivalent)",
> "Physicians (per 1,000 people)", "Plant species (higher), threatened",
> "PM2.5 air pollution, mean annual exposure (micrograms per cubic meter)",
> "PM2.5 air pollution, population exposed to levels exceeding WHO
> guideline value (% of total)",
> "PNG, bonds (AMT, current US$)", "PNG, bonds (DIS, current US$)",
> "PNG, bonds (DOD, current US$)", "PNG, bonds (INT, current US$)",
> "PNG, bonds (NFL, current US$)", "PNG, bonds (NTR, current US$)",
> "PNG, bonds (TDS, current US$)", "PNG, commercial banks and other
> creditors (AMT, current US$)",
> "PNG, commercial banks and other creditors (DIS, current US$)",
> "PNG, commercial banks and other creditors (DOD, current US$)",
> "PNG, commercial banks and other creditors (INT, current US$)",
> "PNG, commercial banks and other creditors (NFL, current US$)",
> "PNG, commercial banks and other creditors (NTR, current US$)",
> "PNG, commercial banks and other creditors (TDS, current US$)",
> "Point-of-sale terminals (per 100,000 adults)", "Population ages 65
> and above (% of total)",
> "Population density (people per sq. km of land area)", "Population
> growth (annual %)",
> "Population in largest city", "Population in the largest city (% of
> urban population)",
> "Population in urban agglomerations of more than 1 million",
> "Population in urban agglomerations of more than 1 million (% of total
> population)",
> "Population living in areas where elevation is below 5 meters (% of
> total population)",
> "Population, ages 0-14 (% of total)", "Population, ages 15-64 (% of
> total)",
> "Population, female (% of total)", "Population, total", "Portfolio
> equity, net inflows (BoP, current US$)",
> "Portfolio investment, bonds (PPG + PNG) (NFL, current US$)",
> "Portfolio Investment, net (BoP, current US$)", "Poverty gap at $1.90
> a day (2011 PPP) (%)",
> "Poverty gap at $3.10 a day (2011 PPP) (%)", "Poverty headcount ratio
> at $1.90 a day (2011 PPP) (% of population)",
> "Poverty headcount ratio at $3.10 a day (2011 PPP) (% of population)",
> "Poverty headcount ratio at national poverty lines (% of population)",
> "Power outages in firms in a typical month (number)", "PPG, bilateral
> (AMT, current US$)",
> "PPG, bilateral (DIS, current US$)", "PPG, bilateral (DOD, current US$)",
> "PPG, bilateral (INT, current US$)", "PPG, bilateral (NTR, current US$)",
> "PPG, bilateral (TDS, current US$)", "PPG, bilateral concessional
> (AMT, current US$)",
> "PPG, bilateral concessional (DIS, current US$)", "PPG, bilateral
> concessional (DOD, current US$)",
> "PPG, bilateral concessional (INT, current US$)", "PPG, bilateral
> concessional (NFL, current US$)",
> "PPG, bilateral concessional (NTR, current US$)", "PPG, bilateral
> concessional (TDS, current US$)",
> "PPG, bonds (AMT, current US$)", "PPG, bonds (DIS, current US$)",
> "PPG, bonds (DOD, current US$)", "PPG, bonds (INT, current US$)",
> "PPG, bonds (NFL, current US$)", "PPG, bonds (NTR, current US$)",
> "PPG, bonds (TDS, current US$)", "PPG, commercial banks (AMT, current
> US$)",
> "PPG, commercial banks (DIS, current US$)", "PPG, commercial banks
> (DOD, current US$)",
> "PPG, commercial banks (INT, current US$)", "PPG, commercial banks
> (NFL, current US$)",
> "PPG, commercial banks (NTR, current US$)", "PPG, commercial banks
> (TDS, current US$)",
> "PPG, IBRD (AMT, current US$)", "PPG, IBRD (DIS, current US$)",
> "PPG, IBRD (DOD, current US$)", "PPG, IBRD (INT, current US$)",
> "PPG, IBRD (NTR, current US$)", "PPG, IBRD (TDS, current US$)",
> "PPG, IDA (AMT, current US$)", "PPG, IDA (DIS, current US$)",
> "PPG, IDA (DOD, current US$)", "PPG, IDA (INT, current US$)",
> "PPG, IDA (NTR, current US$)", "PPG, IDA (TDS, current US$)",
> "PPG, multilateral (AMT, current US$)", "PPG, multilateral (DIS,
> current US$)",
> "PPG, multilateral (DOD, current US$)", "PPG, multilateral (INT,
> current US$)",
> "PPG, multilateral (NTR, current US$)", "PPG, multilateral
> concessional (AMT, current US$)",
> "PPG, multilateral concessional (DIS, current US$)", "PPG,
> multilateral concessional (DOD, current US$)",
> "PPG, multilateral concessional (INT, current US$)", "PPG,
> multilateral concessional (NFL, current US$)",
> "PPG, multilateral concessional (NTR, current US$)", "PPG,
> multilateral concessional (TDS, current US$)",
> "PPG, official creditors (AMT, current US$)", "PPG, official creditors
> (DIS, current US$)",
> "PPG, official creditors (DOD, current US$)", "PPG, official creditors
> (INT, current US$)",
> "PPG, official creditors (NFL, current US$)", "PPG, official creditors
> (NTR, current US$)",
> "PPG, official creditors (TDS, current US$)", "PPG, other private
> creditors (AMT, current US$)",
> "PPG, other private creditors (DIS, current US$)", "PPG, other private
> creditors (DOD, current US$)",
> "PPG, other private creditors (INT, current US$)", "PPG, other private
> creditors (NFL, current US$)",
> "PPG, other private creditors (NTR, current US$)", "PPG, other private
> creditors (TDS, current US$)",
> "PPG, private creditors (AMT, current US$)", "PPG, private creditors
> (DIS, current US$)",
> "PPG, private creditors (DOD, current US$)", "PPG, private creditors
> (INT, current US$)",
> "PPG, private creditors (NFL, current US$)", "PPG, private creditors
> (NTR, current US$)",
> "PPG, private creditors (TDS, current US$)", "PPP conversion factor,
> GDP (LCU per international $)",
> "PPP conversion factor, private consumption (LCU per international $)",
> "Pregnant women receiving prenatal care (%)", "Present value of
> external debt (% of exports of goods, services and primary income)",
> "Present value of external debt (% of GNI)", "Present value of
> external debt (current US$)",
> "Prevalence of anemia among children (% of children under 5)",
> "Prevalence of anemia among non-pregnant women (% of women ages 15-49)",
> "Prevalence of anemia among pregnant women (%)", "Prevalence of HIV,
> female (% ages 15-24)",
> "Prevalence of HIV, male (% ages 15-24)", "Prevalence of HIV, total (%
> of population ages 15-49)",
> "Prevalence of overweight, weight for height (% of children under 5)",
> "Prevalence of overweight, weight for height, female (% of children
> under 5)",
> "Prevalence of overweight, weight for height, male (% of children
> under 5)",
> "Prevalence of severe wasting, weight for height (% of children under
> 5)",
> "Prevalence of severe wasting, weight for height, female (% of
> children under 5)",
> "Prevalence of severe wasting, weight for height, male (% of children
> under 5)",
> "Prevalence of stunting, height for age (% of children under 5)",
> "Prevalence of stunting, height for age, female (% of children under 5)",
> "Prevalence of stunting, height for age, male (% of children under 5)",
> "Prevalence of underweight, weight for age (% of children under 5)",
> "Prevalence of underweight, weight for age, female (% of children
> under 5)",
> "Prevalence of underweight, weight for age, male (% of children under
> 5)",
> "Prevalence of wasting, weight for height (% of children under 5)",
> "Prevalence of wasting, weight for height, female (% of children under
> 5)",
> "Prevalence of wasting, weight for height, male (% of children under 5)",
> "Price level ratio of PPP conversion factor (GDP) to market exchange
> rate",
> "Primary completion rate, both sexes (%)", "Primary completion rate,
> female (%)",
> "Primary completion rate, male (%)", "Primary income on FDI, payments
> (current US$)",
> "Primary income payments (BoP, current US$)", "Primary income receipts
> (BoP, current US$)",
> "Primary to secondary general education transition rate, both sexes (%)",
> "Primary to secondary general education transition rate, female (%)",
> "Primary to secondary general education transition rate, male (%)",
> "Principal arrears, long-term DOD (US$)", "Principal arrears, official
> creditors (current US$)",
> "Principal arrears, private creditors (current US$)", "Principal
> forgiven (current US$)",
> "Principal repayments on external debt, long-term (AMT, current US$)",
> "Principal repayments on external debt, long-term + IMF (AMT, current
> US$)",
> "Principal repayments on external debt, private nonguaranteed (PNG)
> (AMT, current US$)",
> "Principal repayments on external debt, public and publicly guaranteed
> (PPG) (AMT, current US$)",
> "Principal rescheduled (current US$)", "Principal rescheduled,
> official (current US$)",
> "Principal rescheduled, private (current US$)", "Private credit bureau
> coverage (% of adults)",
> "Procedures to build a warehouse (number)", "Procedures to register
> property (number)",
> "Profit tax (% of commercial profits)", "Proportion of seats held by
> women in national parliaments (%)",
> "Public and publicly guaranteed debt service (% of exports of goods,
> services and primary income)",
> "Public and publicly guaranteed debt service (% of GNI)", "Public
> credit registry coverage (% of adults)",
> "Pump price for diesel fuel (US$ per liter)", "Pump price for gasoline
> (US$ per liter)",
> "Pupil-teacher ratio in primary education (headcount basis)",
> "Pupil-teacher ratio in secondary education (headcount basis)",
> "Quality of port infrastructure, WEF (1=extremely underdeveloped to
> 7=well developed and efficient by international standards)",
> "Quasi money (current LCU)", "Rail lines (total route-km)", "Railways,
> goods transported (million ton-km)",
> "Railways, passengers carried (million passenger-km)", "Ratio of
> female to male labor force participation rate (%) (modeled ILO
> estimate)",
> "Ratio of female to male labor force participation rate (%) (national
> estimate)",
> "Real effective exchange rate index (2010 = 100)", "Real interest rate
> (%)",
> "Refugee population by country or territory of asylum", "Refugee
> population by country or territory of origin",
> "Renewable electricity output (% of total electricity output)",
> "Renewable energy consumption (% of total final energy consumption)",
> "Renewable internal freshwater resources per capita (cubic meters)",
> "Renewable internal freshwater resources, total (billion cubic meters)",
> "Research and development expenditure (% of GDP)", "Researchers in R&D
> (per million people)",
> "Reserves and related items (BoP, current US$)", "Residual, debt
> stock-flow reconciliation (current US$)",
> "Revenue, excluding grants (% of GDP)", "Revenue, excluding grants
> (current LCU)",
> "Risk premium on lending (lending rate minus treasury bill rate, %)",
> "Rural population", "Rural population (% of total population)",
> "Rural population growth (annual %)", "S&P Global Equity Indices
> (annual % change)",
> "Scientific and technical journal articles", "Secondary income
> receipts (BoP, current US$)",
> "Secondary income, other sectors, payments (BoP, current US$)",
> "Secure Internet servers", "Secure Internet servers (per 1 million
> people)",
> "Self-employed, female (% of females employed)", "Self-employed, male
> (% of males employed)",
> "Self-employed, total (% of total employed)", "Service exports (BoP,
> current US$)",
> "Service imports (BoP, current US$)", "Services, etc., value added (%
> of GDP)",
> "Services, etc., value added (annual % growth)", "Services, etc.,
> value added (constant 2005 US$)",
> "Services, etc., value added (constant LCU)", "Services, etc., value
> added (current LCU)",
> "Services, etc., value added (current US$)", "SF6 gas emissions
> (thousand metric tons of CO2 equivalent)",
> "Share of tariff lines with international peaks, all products (%)",
> "Share of tariff lines with international peaks, manufactured products
> (%)",
> "Share of tariff lines with international peaks, primary products (%)",
> "Share of tariff lines with specific rates, all products (%)",
> "Share of tariff lines with specific rates, manufactured products (%)",
> "Share of tariff lines with specific rates, primary products (%)",
> "Share of women in wage employment in the nonagricultural sector (% of
> total nonagricultural employment)",
> "Share of youth not in education, employment, or training, female (%
> of female youth population)",
> "Share of youth not in education, employment, or training, male (% of
> male youth population)",
> "Share of youth not in education, employment, or training, total (% of
> youth population)",
> "Short-term debt (% of exports of goods, services and primary income)",
> "Short-term debt (% of total external debt)", "Short-term debt (% of
> total reserves)",
> "Smoking prevalence, females (% of adults)", "Smoking prevalence,
> males (% of adults)",
> "Social contributions (% of revenue)", "Social contributions (current
> LCU)",
> "Source data assessment of statistical capacity (scale 0 - 100)",
> "Start-up procedures to register a business (number)", "Stocks traded,
> total value (% of GDP)",
> "Stocks traded, total value (current US$)", "Stocks traded, turnover
> ratio of domestic shares (%)",
> "Strength of legal rights index (0=weak to 12=strong)", "Subsidies and
> other transfers (% of expense)",
> "Subsidies and other transfers (current LCU)", "Surface area (sq. km)",
> "Survey mean consumption or income per capita, bottom 40% of
> population (2011 PPP $ per day)",
> "Survey mean consumption or income per capita, total population (2011
> PPP $ per day)",
> "Survival rate to Grade 5 of primary education, both sexes (%)",
> "Survival rate to Grade 5 of primary education, female (%)",
> "Survival rate to Grade 5 of primary education, male (%)", "Survival
> rate to the last grade of primary education, both sexes (%)",
> "Survival rate to the last grade of primary education, female (%)",
> "Survival rate to the last grade of primary education, male (%)",
> "Survival to age 65, female (% of cohort)", "Survival to age 65, male
> (% of cohort)",
> "Tariff rate, applied, simple mean, all products (%)", "Tariff rate,
> applied, simple mean, manufactured products (%)",
> "Tariff rate, applied, simple mean, primary products (%)", "Tariff
> rate, applied, weighted mean, all products (%)",
> "Tariff rate, applied, weighted mean, manufactured products (%)",
> "Tariff rate, applied, weighted mean, primary products (%)",
> "Tariff rate, most favored nation, simple mean, all products (%)",
> "Tariff rate, most favored nation, simple mean, manufactured products
> (%)",
> "Tariff rate, most favored nation, simple mean, primary products (%)",
> "Tariff rate, most favored nation, weighted mean, all products (%)",
> "Tariff rate, most favored nation, weighted mean, manufactured
> products (%)",
> "Tariff rate, most favored nation, weighted mean, primary products (%)",
> "Tax payments (number)", "Tax revenue (% of GDP)", "Tax revenue
> (current LCU)",
> "Taxes on exports (% of tax revenue)", "Taxes on exports (current LCU)",
> "Taxes on goods and services (% of revenue)", "Taxes on goods and
> services (% value added of industry and services)",
> "Taxes on goods and services (current LCU)", "Taxes on income, profits
> and capital gains (% of revenue)",
> "Taxes on income, profits and capital gains (% of total taxes)",
> "Taxes on income, profits and capital gains (current LCU)", "Taxes on
> international trade (% of revenue)",
> "Taxes on international trade (current LCU)", "Teachers in primary
> education, both sexes (number)",
> "Teachers in secondary education, both sexes (number)", "Teachers in
> secondary education, female (number)",
> "Technical cooperation grants (BoP, current US$)", "Technicians in R&D
> (per million people)",
> "Teenage mothers (% of women ages 15-19 who have had children or are
> currently pregnant)",
> "Terms of trade adjustment (constant LCU)", "Terrestrial and marine
> protected areas (% of total territorial area)",
> "Terrestrial protected areas (% of total land area)", "Textiles and
> clothing (% of value added in manufacturing)",
> "Theoretical duration of primary education (years)", "Theoretical
> duration of secondary education (years)",
> "Time required to build a warehouse (days)", "Time required to enforce
> a contract (days)",
> "Time required to get electricity (days)", "Time required to obtain an
> operating license (days)",
> "Time required to register property (days)", "Time required to start a
> business (days)",
> "Time spent dealing with the requirements of government regulations (%
> of senior management time)",
> "Time to export (days)", "Time to import (days)", "Time to prepare and
> pay taxes (hours)",
> "Time to resolve insolvency (years)", "Total amount of debt
> rescheduled (current US$)",
> "Total change in external debt stocks (current US$)", "Total debt
> service (% of exports of goods, services and primary income)",
> "Total debt service (% of GNI)", "Total natural resources rents (% of
> GDP)",
> "Total reserves (% of total external debt)", "Total reserves (includes
> gold, current US$)",
> "Total reserves in months of imports", "Total reserves minus gold
> (current US$)",
> "Total tax rate (% of commercial profits)", "Trade (% of GDP)",
> "Trade in services (% of GDP)", "Trademark applications, direct
> nonresident",
> "Trademark applications, direct resident", "Trademark applications,
> total",
> "Transport services (% of commercial service exports)", "Transport
> services (% of commercial service imports)",
> "Transport services (% of service exports, BoP)", "Transport services
> (% of service imports, BoP)",
> "Travel services (% of commercial service exports)", "Travel services
> (% of commercial service imports)",
> "Travel services (% of service exports, BoP)", "Travel services (% of
> service imports, BoP)",
> "Tuberculosis case detection rate (%, all forms)", "Tuberculosis
> treatment success rate (% of new cases)",
> "Undisbursed external debt, official creditors (UND, current US$)",
> "Undisbursed external debt, private creditors (UND, current US$)",
> "Undisbursed external debt, total (UND, current US$)", "Unemployment
> with primary education (% of total unemployment)",
> "Unemployment with primary education, female (% of female unemployment)",
> "Unemployment with primary education, male (% of male unemployment)",
> "Unemployment with secondary education (% of total unemployment)",
> "Unemployment with secondary education, female (% of female
> unemployment)",
> "Unemployment with secondary education, male (% of male unemployment)",
> "Unemployment with tertiary education (% of total unemployment)",
> "Unemployment with tertiary education, female (% of female
> unemployment)",
> "Unemployment with tertiary education, male (% of male unemployment)",
> "Unemployment, female (% of female labor force)", "Unemployment,
> female (% of female labor force) (national estimate)",
> "Unemployment, male (% of male labor force)", "Unemployment, male (%
> of male labor force) (national estimate)",
> "Unemployment, total (% of total labor force)", "Unemployment, total
> (% of total labor force) (national estimate)",
> "Unemployment, youth female (% of female labor force ages 15-24)
> (modeled ILO estimate)",
> "Unemployment, youth female (% of female labor force ages 15-24)
> (national estimate)",
> "Unemployment, youth male (% of male labor force ages 15-24) (modeled
> ILO estimate)",
> "Unemployment, youth male (% of male labor force ages 15-24) (national
> estimate)",
> "Unemployment, youth total (% of total labor force ages 15-24)
> (modeled ILO estimate)",
> "Unemployment, youth total (% of total labor force ages 15-24)
> (national estimate)",
> "Unmet need for contraception (% of married women ages 15-49)",
> "Urban population", "Urban population (% of total)", "Urban population
> growth (annual %)",
> "Use of IMF credit (DOD, current US$)", "Value lost due to electrical
> outages (% of sales)",
> "Vulnerable employment, female (% of female employment)", "Vulnerable
> employment, male (% of male employment)",
> "Vulnerable employment, total (% of total employment)", "Wage and
> salaried workers, female (% of females employed)",
> "Wage and salaried workers, total (% of total employed)", "Wage and
> salary workers, male (% of males employed)",
> "Wanted fertility rate (births per woman)", "Water productivity, total
> (constant 2005 US$ GDP per cubic meter of total freshwater withdrawal)",
> "Wholesale price index (2010 = 100)", "Women's share of population
> ages 15+ living with HIV (%)",
> "Youth literacy rate, population 15-24 years, both sexes (%)",
> "Youth literacy rate, population 15-24 years, female (%)", "Youth
> literacy rate, population 15-24 years, gender parity index (GPI)",
> "Youth literacy rate, population 15-24 years, male (%)"), class =
> "factor"),
>     Year = c(1960L, 1962L, 1963L, 1965L, 1968L, 1965L, 1965L,
>     1968L, 1962L, 1964L, 1962L, 1965L, 1964L, 1962L, 1960L, 1962L,
>     1968L, 1965L, 1965L, 1967L, 1966L, 1965L, 1963L, 1964L, 1961L
>     )), class = "data.frame", row.names = c("34", "6299", "9798",
> "16849", "28474", "16882", "16880", "28573", "6325", "13377",
> "6301", "16863", "13369", "6245", "85", "6249", "28476", "16849.1",
> "16844", "24689", "20818", "16981", "9795", "13373", "3031"))
>
> Preciso a partir de cada nível da variável IndicatorName criar uma
> nova variável com os valores de Value:
> Por exempo:
> o nível da variável IndicatorName=='Mobile cellular subscriptions'
> seria uma nova variável:
>
> v1<-dado$Value[dados$IndicatorName=='Mobile cellular subscriptions']
>  e assi por diante para cada um dos outros níveis que a variável
> IndicatorName recebe.
>
> Como posso fazer isso de uma vez só?
>
> Obrigado!
>

_______________________________________________
R-br mailing list
[hidden email]
https://listas.inf.ufpr.br/cgi-bin/mailman/listinfo/r-br
Leia o guia de postagem (http://www.leg.ufpr.br/r-br-guia) e fornea cdigo mnimo reproduzvel.