This is a tutorial/demo on how to use the Datamart REST API.¶

[
  {
    "name": "FSI dataset",
    "description": "data downloaded from FSI",
    "url": "https://fragilestatesindex.org",
    "dataset_id": "FSI"
  },
  {
    "name": "OECD dataset",
    "description": "data downloaded from OECD",
    "url": "https://data.oecd.org",
    "dataset_id": "OECD"
  },
  {
    "name": "UAZ Indicators",
    "description": "Collection of indicators, including indicators from FAO, WDI, FEWSNET, CLiMIS, UNICEF, ieconomics.com, UNHCR, DSSAT, WHO, IMF, WHP, ACLDE, World Bank and IOM-DTM",
    "url": "https://github.com/ml4ai/delphi",
    "dataset_id": "UAZ"
  },
  {
    "name": "WGI dataset",
    "description": "Worldwide Governance Indicators",
    "url": "https://databank.worldbank.org/source/worldwide-governance-indicators",
    "dataset_id": "WGI"
  },
  {
    "name": "WDI dataset",
    "description": "World Development Indicators",
    "url": "https://databank.worldbank.org/source/world-development-indicators",
    "dataset_id": "WDI"
  },
  {
    "name": "Corruption Perceptions Index",
    "description": "Transparency International  Corruption Perceptions Index The CPI scores and ranks countries/territories based on how corrupt a country\u2019s public sector is perceived to be by experts and business executives. It is a composite index, a combination of 13 surveys and assessments of corruption, collected by a variety of reputable institutions. The CPI is the most widely used indicator of corruption worldwide.",
    "url": "https://www.transparency.org/",
    "dataset_id": "TICPI"
  },
  {
    "name": "SIPRI Military Expenditure",
    "description": "Military expenditure by country, in millions of US$ at current prices and exchange rates, 1949-2018 - SIPRI 2019",
    "url": "https://sipri.org/databases/milex",
    "dataset_id": "SIPRI"
  },
  {
    "name": "economic fitness dataset",
    "description": "EconomicFitness",
    "url": "https://databank.banquemondiale.org/source/economic-fitness",
    "dataset_id": "EconomicFitness"
  },
  {
    "name": "Agricultural Market Information System (AMIS)",
    "description": "The Agricultural Market Information System (AMIS) is an inter-agency platform to enhance food market transparency and policy response for food security. It was launched in 2011 by the G20 Ministers of Agriculture following the global food price hikes in 2007/08 and 2010. Bringing together the principal trading countries of agricultural commodities, AMIS assesses global food supplies (focusing on wheat, maize, rice and soybeans) and provides a platform to coordinate policy action in times of market uncertainty.",
    "url": "http://www.amis-outlook.org",
    "dataset_id": "AMIS"
  },
  {
    "name": "test test test",
    "description": "testy test",
    "url": "https://test.com",
    "dataset_id": "TEST000"
  },
  {
    "name": "World Press Freedom Index",
    "description": "Published every year since 2002 by Reporters Without Borders (RSF), the World Press Freedom Index is an important advocacy tool based on the principle of emulation between states. The Index ranks 180 countries and regions\u00a0according to the level of freedom available to journalists.",
    "url": "https://rsf.org/en",
    "dataset_id": "WPFI"
  },
  {
    "name": "Poverty Rate Global DP",
    "description": "Poverty Rate Global DP",
    "url": "http://url",
    "dataset_id": "DPPoverty"
  }
]

[
  {
    "name": "WDI dataset",
    "description": "World Development Indicators",
    "url": "https://databank.worldbank.org/source/world-development-indicators",
    "dataset_id": "WDI"
  }
]

[
  {
    "name": "_2005 PPP conversion factor, GDP (LCU per international $)",
    "variable_id": "_2005_ppp_conversion_factor_gdp_lcu_per_international",
    "dataset_id": "WDI"
  },
  {
    "name": "_2005 PPP conversion factor, private consumption (LCU per international $)",
    "variable_id": "_2005_ppp_conversion_factor_private_consumption_lcu_per_international",
    "dataset_id": "WDI"
  },
  {
    "name": "Access to clean fuels and technologies for cooking (% of population)",
    "variable_id": "access_to_clean_fuels_and_technologies_for_cooking_of_population",
    "dataset_id": "WDI"
  },
  {
    "name": "Access to electricity (% of population)",
    "variable_id": "access_to_electricity_of_population",
    "dataset_id": "WDI"
  }
]

Total number of variables in dataset: WDI is 1429

{
  "name": "Access to electricity (% of population)",
  "variable_id": "access_to_electricity_of_population",
  "dataset_id": "WDI",
  "description": "Access to electricity (% of population) in WDI",
  "corresponds_to_property": "PWDI-005",
  "qualifier": [
    {
      "identifier": "P585",
      "name": "point in time"
    },
    {
      "identifier": "P248",
      "name": "stated in"
    }
  ]
}

[
  {
    "variable_id": "road_fatalities",
    "name": " Road Fatalities",
    "rank": 0.0759909,
    "dataset_id": "OECD"
  },
  {
    "variable_id": "mortality_caused_by_road_traffic_injury_per_100_000_people",
    "name": " Mortality caused by road traffic injury (per 100,000 people)",
    "rank": 0.0759909,
    "dataset_id": "WDI"
  },
  {
    "variable_id": "VUAZ-8054",
    "name": " WDI: Mortality caused by road traffic injury[per 100,000 people]",
    "rank": 0.0607927,
    "dataset_id": "UAZ"
  }
]

[
  {
    "variable_id": "road_fatalities",
    "name": " Road Fatalities",
    "rank": 0.334428,
    "dataset_id": "OECD"
  }
]

[
  {
    "variable_id": "road_fatalities",
    "name": " Road Fatalities",
    "rank": 0.0759909,
    "dataset_id": "OECD"
  },
  {
    "variable_id": "mortality_caused_by_road_traffic_injury_per_100_000_people",
    "name": " Mortality caused by road traffic injury (per 100,000 people)",
    "rank": 0.0379954,
    "dataset_id": "WDI"
  },
  {
    "variable_id": "VUAZ-8054",
    "name": " WDI: Mortality caused by road traffic injury[per 100,000 people]",
    "rank": 0.0303964,
    "dataset_id": "UAZ"
  },
  {
    "variable_id": "VUAZ-8136",
    "name": " Conflict fatalities[number of cases]",
    "rank": 0.0303964,
    "dataset_id": "UAZ"
  }
]

{
  "name": "Test Dataset 01",
  "description": "Test Dataset 01",
  "url": "http://test01.com/test",
  "dataset_id": "TEST01"
}

[
  {
    "name": "FSI dataset",
    "description": "data downloaded from FSI",
    "url": "https://fragilestatesindex.org",
    "dataset_id": "FSI"
  },
  {
    "name": "OECD dataset",
    "description": "data downloaded from OECD",
    "url": "https://data.oecd.org",
    "dataset_id": "OECD"
  },
  {
    "name": "UAZ Indicators",
    "description": "Collection of indicators, including indicators from FAO, WDI, FEWSNET, CLiMIS, UNICEF, ieconomics.com, UNHCR, DSSAT, WHO, IMF, WHP, ACLDE, World Bank and IOM-DTM",
    "url": "https://github.com/ml4ai/delphi",
    "dataset_id": "UAZ"
  },
  {
    "name": "WGI dataset",
    "description": "Worldwide Governance Indicators",
    "url": "https://databank.worldbank.org/source/worldwide-governance-indicators",
    "dataset_id": "WGI"
  },
  {
    "name": "WDI dataset",
    "description": "World Development Indicators",
    "url": "https://databank.worldbank.org/source/world-development-indicators",
    "dataset_id": "WDI"
  },
  {
    "name": "Corruption Perceptions Index",
    "description": "Transparency International  Corruption Perceptions Index The CPI scores and ranks countries/territories based on how corrupt a country\u2019s public sector is perceived to be by experts and business executives. It is a composite index, a combination of 13 surveys and assessments of corruption, collected by a variety of reputable institutions. The CPI is the most widely used indicator of corruption worldwide.",
    "url": "https://www.transparency.org/",
    "dataset_id": "TICPI"
  },
  {
    "name": "SIPRI Military Expenditure",
    "description": "Military expenditure by country, in millions of US$ at current prices and exchange rates, 1949-2018 - SIPRI 2019",
    "url": "https://sipri.org/databases/milex",
    "dataset_id": "SIPRI"
  },
  {
    "name": "economic fitness dataset",
    "description": "EconomicFitness",
    "url": "https://databank.banquemondiale.org/source/economic-fitness",
    "dataset_id": "EconomicFitness"
  },
  {
    "name": "Agricultural Market Information System (AMIS)",
    "description": "The Agricultural Market Information System (AMIS) is an inter-agency platform to enhance food market transparency and policy response for food security. It was launched in 2011 by the G20 Ministers of Agriculture following the global food price hikes in 2007/08 and 2010. Bringing together the principal trading countries of agricultural commodities, AMIS assesses global food supplies (focusing on wheat, maize, rice and soybeans) and provides a platform to coordinate policy action in times of market uncertainty.",
    "url": "http://www.amis-outlook.org",
    "dataset_id": "AMIS"
  },
  {
    "name": "test test test",
    "description": "testy test",
    "url": "https://test.com",
    "dataset_id": "TEST000"
  },
  {
    "name": "World Press Freedom Index",
    "description": "Published every year since 2002 by Reporters Without Borders (RSF), the World Press Freedom Index is an important advocacy tool based on the principle of emulation between states. The Index ranks 180 countries and regions\u00a0according to the level of freedom available to journalists.",
    "url": "https://rsf.org/en",
    "dataset_id": "WPFI"
  },
  {
    "name": "Poverty Rate Global DP",
    "description": "Poverty Rate Global DP",
    "url": "http://url",
    "dataset_id": "DPPoverty"
  },
  {
    "name": "Test Dataset 01",
    "description": "Test Dataset 01",
    "url": "http://test01.com/test",
    "dataset_id": "TEST01"
  }
]

{
  "name": "test variable for test dataset",
  "variable_id": "TEST01-01",
  "dataset_id": "TEST01",
  "corresponds_to_property": "PTEST01-TEST01-01"
}

[
  {
    "name": "test variable for test dataset",
    "variable_id": "TEST01-01",
    "dataset_id": "TEST01"
  }
]

[
  {
    "Error": "Missing required column: 'main_subject'",
    "Line Number": 1,
    "Column": "main_subject",
    "Description": "The uploaded file is missing a required column: main_subject. Please add the missing column and upload again."
  }
]

[
  {
    "Error": "Value Error: 'fifty'",
    "Line Number": 2,
    "Column": "value",
    "Description": "'fifty' is not a valid number"
  },
  {
    "Error": "Illegal precision value: 'blah'",
    "Line Number": 2,
    "Column": "time_precision",
    "Description": "Legal precision values are: 'billion years,hundred million years,million years,hundred thousand years,ten thousand years,millennium,century,decade,year,month,day,hour,minute,second'"
  },
  {
    "Error": "Could not wikify: 'shdjshduihskdj'",
    "Line Number": 2,
    "Column": "main_subject",
    "Description": "Could not find a Wikidata Qnode for the main subject: 'shdjshduihskdj.' Please check for spelling mistakes in the country name."
  },
  {
    "Error": "Dataset ID in the file: 'FAO' is not same as Dataset ID in the url : 'TEST01'",
    "Line Number": 2,
    "Column": "dataset_id",
    "Description": "Dataset IDs in the input file should match the Dataset Id in the API url"
  },
  {
    "Error": "Variable ID in the file: 'fake_gdp_growth' is not same as Variable ID in the url : 'TEST01-01'",
    "Line Number": 2,
    "Column": "variable_id",
    "Description": "Variable IDs in the input file should match the Variable Id in the API url"
  },
  {
    "Error": "Invalid datetime format: '20-01-01T00:00:00Z'",
    "Line Number": 2,
    "Column": "time",
    "Description": "Invalid format to specify time. Valid format: '%Y-%m-%dT%H:%M:%SZ' Explanation:  %Y - Year with century as a decimal number (2010, 2020 etc). %m - Month as a zero-padded decimal number(01, 02,..,12). %d - Day of the month as a zero-padded decimal number. (01,02,..,31). %H - Hour (24-hour clock) as a zero-padded decimal number. (00, 01,..,23). %M - Minute as a zero-padded decimal number.(00, 01,...,59). %S - Second as a zero-padded decimal number.(00, 01,...,59). A valid date: '2020-02-27T13:45:44Z'"
  },
  {
    "Error": "Could not wikify: 'shdjshduihskdj'",
    "Line Number": 3,
    "Column": "country",
    "Description": "Could not find a Wikidata Qnode for the country:  'shdjshduihskdj'. Please check for spelling mistakes in the country name."
  }
]

2 rows imported!