An error occured. Details Hide
You have unsaved pages. Restore Cancel

Get Raw Data

This endpoint returns data in columnar format for all columns (raw data). User can make partial request through this endpoint having provided all the dimension under filter to get aggregated data.
 
Input:
Name  Type  Description 
Filter object Contains list of dimension details which are used as a filter.
  1. DimensionId: Id of the dimension
  2. Members: array of members
  3. DimensionName: Name of dimension
Frequency Char  Frequency of Data required( A= Annual ;S=SemiAnnually; Q=Quarterly; W=Weekly; D=Daily)
FoldDimension string Name of the dimension which has fold applied on the members
Dataset string Unique dataset identifier

Result:

Name  Type  Description 
columns array[columns]

Tuples describing each column.
consists
name: Name of the column
type: type of the column can be:

  • Date
  • Text
  • Number
  • Location
  • Currency

status: Status of column can be:

  • Date
  • Measure
  • Detail
  • Dimension

dimensionId: Id of the dimension
fieldId: field id or metadata id for the column with the status detail.

 

Data object Hold raw data of each column which contains:
  • Value : contains the significand/mantissa of observation value. 
    Should be multiplied with scale for observation data.
  • Frequency: Interval of time between which observation data is recorded. Values can be 'A' -Annual ,'Q' -Quarterly, 'M' -Monthly ,'W' -Weekly
datasetName string Name of the dataset

Example:

Post: http://knoema.com/api/1.0/data/details

{
   "Filter": [
      {
         "DimensionId": "Time",
         "Members": [
            "2005"
         ],
         "DimensionName": "Time",
         "UiMode": "singleMember"
      },
      {
         "DimensionId": "Country",
         "Members": [
            "1000090",
            "1000070"
         ],
         "DimensionName": "Country"
      }
   ],
   "Frequencies": [
      "A"
   ],
   "FoldDimension": null,
   "Dataset": "ADBDMG2011"
}

Ouput

{
   "columns": [
      {
         "name": "Country",
         "type": "Location",
         "status": "Dimension",
         "dimensionId": "Country",
         "fieldId": null
      },
      {
         "name": "Social Group",
         "type": "Text",
         "status": "Dimension",
         "dimensionId": "Social Group",
         "fieldId": null
      },
      {
         "name": "Value",
         "type": "Number",
         "status": "Measure",
         "dimensionId": null,
         "fieldId": null
      },
      {
         "name": "Date",
         "type": "Date",
         "status": "Date",
         "dimensionId": null,
         "fieldId": null
      }
   ],
   "data": [
      "Somalia",
      "Somalie",
      "85",
      "Regional member Country Low income Severely indebted National currency",
      "",
      "SOM",
      "Goal 1: Eradicate extreme poverty and hunger",
      "1",
      "Prevalence of underweight children under-five years of age (%)",
      "Prevalence of (moderately and severely) underweight children",
      "",
      "Women",
      26,
      {
         "value": "01/01/2005",
         "frequency": "A"
      },
      "Kenya",
      "Kenya",
      "85",
      "Regional member Country Low income Moderately indebted National currency",
      "",
      "KEN",
      "Goal 8: Develop a global partnership for development",
      "8",
      "Net ODA to LDCs as a percentage of OECD/DAC donors' GNI (%)",
      "",
      "",
      "Total",
      17.28,
      {
         "value": "01/01/2005",
         "frequency": "A"
      }
   ],
   "filter": [],
   "datasetName": "Africa Millennium Development Goals"
}