Get Raw Data

Endpoint: http://data.gov.om/api/1.0/data/details

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. DimensionId: Id of the dimension Members: array of members 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://data.gov.om/api/1.1/data/details

{
   "Filter": [
      {
         "DimensionId": "Time",
         "Members": [
            "2005"
         ],
         "DimensionName": "Time",
         "UiMode": "singleMember"
      },
      {
         "DimensionId": "indicator",
         "Members": [
            "1000010"
         ],
         "DimensionName": "Indicators"
      },
      {
         "DimensionId": "periodic-release",
         "Members": [
            "1000000"
         ],
         "DimensionName": "Periodic release"
      },
      {
         "DimensionId": "program-quality",
         "Members": [
            "1000000"
         ],
         "DimensionName": "Program quality"
      }
   ],
   "Frequencies": [
      "A"
   ],
   "FoldDimension": null,
   "Dataset": "OMINF2016"
}

Ouput

{
   "columns":[
      {
         "id":"date",
         "name":"Date",
         "type":"Date",
         "status":"Date",
         "dimensionId":null,
         "fieldId":null
      },
      {
         "id":"indicator",
         "name":"Indicators",
         "type":"Text",
         "status":"Dimension",
         "dimensionId":"indicator",
         "fieldId":null,
         "detailColumns":[
            {
               "id":"arabic-full-name",
               "name":"الاسم الكامل",
               "type":"Text",
               "status":"Dimension",
               "dimensionId":"indicator",
               "fieldId":"u1575u1604u1575u1587u1605-u1575u1604u1603u1575u1605u1604"
            },
            {
               "id":"arabic-name",
               "name":"اسم",
               "type":"Text",
               "status":"Dimension",
               "dimensionId":"indicator",
               "fieldId":"u1575u1587u1605"
            },
            {
               "id":"arabic-unit",
               "name":"الوحدة",
               "type":"Text",
               "status":"Dimension",
               "dimensionId":"indicator",
               "fieldId":"u1575u1604u1608u1581u1583u1577"
            },
            {
               "id":"description",
               "name":"Description",
               "type":"Text",
               "status":"Dimension",
               "dimensionId":"indicator",
               "fieldId":"description"
            },
            {
               "id":"frequencies",
               "name":"Frequencies",
               "type":"Text",
               "status":"Dimension",
               "dimensionId":"indicator",
               "fieldId":"frequencies"
            },
            {
               "id":"full-name",
               "name":"Full Name",
               "type":"Text",
               "status":"Dimension",
               "dimensionId":"indicator",
               "fieldId":"full-name"
            },
            {
               "id":"id",
               "name":"Id",
               "type":"Text",
               "status":"Dimension",
               "dimensionId":"indicator",
               "fieldId":"id"
            },
            {
               "id":"methodology",
               "name":"Methodology",
               "type":"Text",
               "status":"Dimension",
               "dimensionId":"indicator",
               "fieldId":"methodology"
            },
            {
               "id":"short-description",
               "name":"Short description",
               "type":"Text",
               "status":"Dimension",
               "dimensionId":"indicator",
               "fieldId":"short-description"
            },
            {
               "id":"short-name",
               "name":"Short name",
               "type":"Text",
               "status":"Dimension",
               "dimensionId":"indicator",
               "fieldId":"short-name"
            },
            {
               "id":"source-link",
               "name":"Source link",
               "type":"Text",
               "status":"Dimension",
               "dimensionId":"indicator",
               "fieldId":"source-link"
            },
            {
               "id":"source-name",
               "name":"Source name",
               "type":"Text",
               "status":"Dimension",
               "dimensionId":"indicator",
               "fieldId":"source-name"
            },
            {
               "id":"unit",
               "name":"Unit",
               "type":"Text",
               "status":"Dimension",
               "dimensionId":"indicator",
               "fieldId":"unit"
            }
         ]
      },
      {
         "id":"periodic-release",
         "name":"Periodic release",
         "type":"Text",
         "status":"Dimension",
         "dimensionId":"periodic-release",
         "fieldId":null,
         "detailColumns":[
            {
               "id":"arabic-name",
               "name":"اسم",
               "type":"Text",
               "status":"Dimension",
               "dimensionId":"periodic-release",
               "fieldId":"u1575u1587u1605"
            },
            {
               "id":"id",
               "name":"Id",
               "type":"Text",
               "status":"Dimension",
               "dimensionId":"periodic-release",
               "fieldId":"id"
            },
            {
               "id":"اسم",
               "name":"اسم",
               "type":"Text",
               "status":"Dimension",
               "dimensionId":"periodic-release",
               "fieldId":"اسم"
            }
         ]
      },
      {
         "id":"program-quality",
         "name":"Program quality",
         "type":"Text",
         "status":"Dimension",
         "dimensionId":"program-quality",
         "fieldId":null,
         "detailColumns":[
            {
               "id":"arabic-name",
               "name":"اسم",
               "type":"Text",
               "status":"Dimension",
               "dimensionId":"program-quality",
               "fieldId":"u1575u1587u1605"
            },
            {
               "id":"id",
               "name":"Id",
               "type":"Text",
               "status":"Dimension",
               "dimensionId":"program-quality",
               "fieldId":"id"
            },
            {
               "id":"اسم",
               "name":"اسم",
               "type":"Text",
               "status":"Dimension",
               "dimensionId":"program-quality",
               "fieldId":"اسم"
            }
         ]
      },
      {
         "id":"region",
         "name":"Regions",
         "type":"Text",
         "status":"Dimension",
         "dimensionId":"region",
         "fieldId":null
      },
      {
         "id":"regionid",
         "name":"Regions",
         "type":"Text",
         "status":"Dimension",
         "dimensionId":"region",
         "fieldId":null,
         "detailColumns":[
            {
               "id":"arabic-name",
               "name":"اسم",
               "type":"Text",
               "status":"Dimension",
               "dimensionId":"region",
               "fieldId":"u1575u1587u1605"
            },
            {
               "id":"description",
               "name":"Description",
               "type":"Text",
               "status":"Dimension",
               "dimensionId":"region",
               "fieldId":"description"
            },
            {
               "id":"id",
               "name":"Id",
               "type":"Text",
               "status":"Dimension",
               "dimensionId":"region",
               "fieldId":"id"
            },
            {
               "id":"iso",
               "name":"ISO",
               "type":"Text",
               "status":"Dimension",
               "dimensionId":"region",
               "fieldId":"iso"
            }
         ]
      },
      {
         "id":"value",
         "name":"Value",
         "type":"Number",
         "status":"Measure",
         "dimensionId":null,
         "fieldId":null
      }
   ],
   "filter":[
 
   ],
   "datasetName":"Information",
   "data":[
      {
         "date":{
            "value":"01/01/2002",
            "frequency":"A"
         },
         "indicator":{
            "arabic-full-name":"التلفزيون و الاذاعة ( حكومي )\اجمالي ساعات الارسال التلفزيوني والاذاعي اليومي- عدد",
            "arabic-name":"اجمالي ساعات الارسال التلفزيوني والاذاعي اليومي- عدد",
            "arabic-unit":"عدد",
            "description":"",
            "frequencies":"",
            "full-name":"Television & Radio (Governmental)\Grand Total - Transmission & Broadcasting Hours :Daily - No.",
            "id":"17166863",
            "methodology":"",
            "name":"Grand Total - Transmission & Broadcasting Hours :Daily - No",
            "short-description":"",
            "short-name":"",
            "source-link":"",
            "source-name":"",
            "unit":"Number"
         },
         "periodic-release":{
            "arabic-name":"الاجمالي",
            "id":"17166693",
            "name":"Total",
            "اسم":null
         },
         "program-quality":{
            "arabic-name":"الاجمالي",
            "id":"17166783",
            "name":"Total",
            "اسم":null
         },
         "region":"Oman",
         "regionid":{
            "arabic-name":"عمان",
            "description":"",
            "id":"1",
            "iso":"OM",
            "name":"Oman"
         },
         "value":65
      },
      {
         "date":{
            "value":"01/01/2003",
            "frequency":"A"
         },
         "indicator":{
            "arabic-full-name":"التلفزيون و الاذاعة ( حكومي )\اجمالي ساعات الارسال التلفزيوني والاذاعي اليومي- عدد",
            "arabic-name":"اجمالي ساعات الارسال التلفزيوني والاذاعي اليومي- عدد",
            "arabic-unit":"عدد",
            "description":"",
            "frequencies":"",
            "full-name":"Television & Radio (Governmental)\Grand Total - Transmission & Broadcasting Hours :Daily - No.",
            "id":"17166863",
            "methodology":"",
            "name":"Grand Total - Transmission & Broadcasting Hours :Daily - No",
            "short-description":"",
            "short-name":"",
            "source-link":"",
            "source-name":"",
            "unit":"Number"
         },
         "periodic-release":{
            "arabic-name":"الاجمالي",
            "id":"17166693",
            "name":"Total",
            "اسم":null
         },
         "program-quality":{
            "arabic-name":"الاجمالي",
            "id":"17166783",
            "name":"Total",
            "اسم":null
         },
         "region":"Oman",
         "regionid":{
            "arabic-name":"عمان",
            "description":"",
            "id":"1",
            "iso":"OM",
            "name":"Oman"
         },
         "value":80
      },
...
      {
         "date":{
            "value":"01/01/2004",
            "frequency":"A"
         },
         "indicator":{
            "arabic-full-name":"التلفزيون و الاذاعة ( حكومي )\اجمالي ساعات الارسال التلفزيوني والاذاعي اليومي- عدد",
            "arabic-name":"اجمالي ساعات الارسال التلفزيوني والاذاعي اليومي- عدد",
            "arabic-unit":"عدد",
            "description":"",
            "frequencies":"",
            "full-name":"Television & Radio (Governmental)\Grand Total - Transmission & Broadcasting Hours :Daily - No.",
            "id":"17166863",
            "methodology":"",
            "name":"Grand Total - Transmission & Broadcasting Hours :Daily - No",
            "short-description":"",
            "short-name":"",
            "source-link":"",
            "source-name":"",
            "unit":"Number"
         },
         "periodic-release":{
            "arabic-name":"الاجمالي",
            "id":"17166693",
            "name":"Total",
            "اسم":null
         },
         "program-quality":{
            "arabic-name":"الاجمالي",
            "id":"17166783",
            "name":"Total",
            "اسم":null
         },
         "region":"Oman",
         "regionid":{
            "arabic-name":"عمان",
            "description":"",
            "id":"1",
            "iso":"OM",
            "name":"Oman"
         },
         "value":85
      },
      "periodic-release":{
         "arabic-name":"الاجمالي",
         "id":"17166693",
         "name":"Total",
         "اسم":null
      },
      "program-quality":{
         "arabic-name":"الاجمالي",
         "id":"17166783",
         "name":"Total",
         "اسم":null
      },
      "region":"Oman",
      "regionid":{
         "arabic-name":"عمان",
         "description":"",
         "id":"1",
         "iso":"OM",
         "name":"Oman"
      },
      "value":0
   }
]
}
 