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

Simple get dataset endpoint

This endpoint returns dataset's data in pivot table format.

Input

DatasetId is unique identifier for dataset, dimensionId - unique identifier for dataset dimension and key1,key2,key3 - array of dimension members.
Time is the optional parameter, if it's missing, the result will contain the rows between 2000 year till current date.

NameType Description
DatasetIdString Unique identifier for dataset.
DimensionIdString Unique Identifier for dimension.

Result

The output of this endpoint is array of tuples. For each header/stub dimension there will be corresponding tuple field and also value field. Stub fields will be included in the order of their definition in request followed by header fields in the order of their definition in request. Tuples will follow the value order defined in request, i.e. tuples for values listed first will be followed by tuples for values listed later.

Name Type Description
Dataset string Unique dataset id
Header object Dimension details and members of header
Contains array of
  • Dimension: Dimension id
  • Members: Distinct sorted values of dimension members
Stub Object Dimension details and members of stub
Contains array of
  • Dimension: Dimension id
  • Members: Distinct sorted values of dimension members
Filter ObjectDimension details of members which are used as a filter. This can
contain only one member.
DataobjectTuples describing each data point.
consists
  • Time: Date of observation
  • Value : contains the significand/mantissa of observation value.
    Should be multiplied with scale for observation data.
  • Unit: Unit associated with value
  • Scale: Value's multiplication factor.

Example

GET http://data.gov.om/api/1.0/data/OMINF2016?region=1000000&indicator=1000010,1000020&periodic-release=1000000&program-quality=1000000
 
   header:[ 
      
         dimensionId:"Time",
         filterText:null,
         members:[ 
            "2002",
            "2003",
            "2004",
            "2005",
            "2006",
            "2007",
            "2008",
            "2009",
            "2010",
            "2011",
            "2012",
            "2013",
            "2014",
            "2015",
            "2016"
         ],
         metadataFields:[ 
 
         ]
      }
   ],
   stub:[ 
      
         dimensionId:"region",
         filterText:null,
         members:[ 
            "Oman"
         ],
         metadataFields:[ 
 
         ]
      },
      
         dimensionId:"indicator",
         filterText:null,
         members:[ 
            "Grand Total - Transmission & Broadcasting Hours :Daily - No",
            "No. Total Television Broadcasting Hours- Daily"
         ],
         metadataFields:[ 
 
         ]
      },
      
         dimensionId:"periodic-release",
         filterText:null,
         members:[ 
            "Total"
         ],
         metadataFields:[ 
 
         ]
      },
      
         dimensionId:"program-quality",
         filterText:null,
         members:[ 
            "Total"
         ],
         metadataFields:[ 
 
         ]
      }
   ],
   filter:[ 
 
   ],
   datasetName:"Information",
   dataset:"OMINF2016",
   keys:{ 
      header:[ 
         
            dimensionId:"Time",
            filterText:null,
            members:[ 
               "2002",
               "2003",
               "2004",
               "2005",
               "2006",
               "2007",
               "2008",
               "2009",
               "2010",
               "2011",
               "2012",
               "2013",
               "2014",
               "2015",
               "2016"
            ],
            metadataFields:[ 
 
            ]
         }
      ],
      stub:[ 
         
            dimensionId:"region",
            filterText:null,
            members:[ 
               "1000000"
            ],
            metadataFields:[ 
 
            ]
         },
         
            dimensionId:"indicator",
            filterText:null,
            members:[ 
               "1000010",
               "1000020"
            ],
            metadataFields:[ 
 
            ]
         },
         
            dimensionId:"periodic-release",
            filterText:null,
            members:[ 
               "1000000"
            ],
            metadataFields:[ 
 
            ]
         },
         
            dimensionId:"program-quality",
            filterText:null,
            members:[ 
               "1000000"
            ],
            metadataFields:[ 
 
            ]
         }
      ],
      filter:[ 
 
      ]
   },
   data:[ 
      
         Time:"2002-01-01T00:00:00Z",
         program-quality:"Total",
         periodic-release:"Total",
         indicator:"Grand Total - Transmission & Broadcasting Hours :Daily - No",
         region:"Oman",
         RegionId:"OM",
         Frequency:"A",
         Value:65,
         Unit:"Number",
         Scale:1
      },
      
         Time:"2003-01-01T00:00:00Z",
         program-quality:"Total",
         periodic-release:"Total",
         indicator:"Grand Total - Transmission & Broadcasting Hours :Daily - No",
         region:"Oman",
         RegionId:"OM",
         Frequency:"A",
         Value:80,
         Unit:"Number",
         Scale:1
      },
      
         Time:"2004-01-01T00:00:00Z",
         program-quality:"Total",
         periodic-release:"Total",
         indicator:"Grand Total - Transmission & Broadcasting Hours :Daily - No",
         region:"Oman",
         RegionId:"OM",
         Frequency:"A",
         Value:85,
         Unit:"Number",
         Scale:1
      },
      
         Time:"2005-01-01T00:00:00Z",
         program-quality:"Total",
         periodic-release:"Total",
         indicator:"Grand Total - Transmission & Broadcasting Hours :Daily - No",
         region:"Oman",
         RegionId:"OM",
         Frequency:"A",
         Value:102,
         Unit:"Number",
         Scale:1
      },
      
         Time:"2006-01-01T00:00:00Z",
         program-quality:"Total",
         periodic-release:"Total",
         indicator:"Grand Total - Transmission & Broadcasting Hours :Daily - No",
         region:"Oman",
         RegionId:"OM",
         Frequency:"A",
         Value:101,
         Unit:"Number",
         Scale:1
      },
      
         Time:"2007-01-01T00:00:00Z",
         program-quality:"Total",
         periodic-release:"Total",
         indicator:"Grand Total - Transmission & Broadcasting Hours :Daily - No",
         region:"Oman",
         RegionId:"OM",
         Frequency:"A",
         Value:117,
         Unit:"Number",
         Scale:1
      },
      
         Time:"2008-01-01T00:00:00Z",
         program-quality:"Total",
         periodic-release:"Total",
         indicator:"Grand Total - Transmission & Broadcasting Hours :Daily - No",
         region:"Oman",
         RegionId:"OM",
         Frequency:"A",
         Value:111,
         Unit:"Number",
         Scale:1
      },
      
         Time:"2009-01-01T00:00:00Z",
         program-quality:"Total",
         periodic-release:"Total",
         indicator:"Grand Total - Transmission & Broadcasting Hours :Daily - No",
         region:"Oman",
         RegionId:"OM",
         Frequency:"A",
         Value:111,
         Unit:"Number",
         Scale:1
      },
      
         Time:"2010-01-01T00:00:00Z",
         program-quality:"Total",
         periodic-release:"Total",
         indicator:"Grand Total - Transmission & Broadcasting Hours :Daily - No",
         region:"Oman",
         RegionId:"OM",
         Frequency:"A",
         Value:111,
         Unit:"Number",
         Scale:1
      },
      
         Time:"2011-01-01T00:00:00Z",
         program-quality:"Total",
         periodic-release:"Total",
         indicator:"Grand Total - Transmission & Broadcasting Hours :Daily - No",
         region:"Oman",
         RegionId:"OM",
         Frequency:"A",
         Value:129,
         Unit:"Number",
         Scale:1
      },
      
         Time:"2012-01-01T00:00:00Z",
         program-quality:"Total",
         periodic-release:"Total",
         indicator:"Grand Total - Transmission & Broadcasting Hours :Daily - No",
         region:"Oman",
         RegionId:"OM",
         Frequency:"A",
         Value:140,
         Unit:"Number",
         Scale:1
      },
      
         Time:"2013-01-01T00:00:00Z",
         program-quality:"Total",
         periodic-release:"Total",
         indicator:"Grand Total - Transmission & Broadcasting Hours :Daily - No",
         region:"Oman",
         RegionId:"OM",
         Frequency:"A",
         Value:143,
         Unit:"Number",
         Scale:1
      },
      
         Time:"2014-01-01T00:00:00Z",
         program-quality:"Total",
         periodic-release:"Total",
         indicator:"Grand Total - Transmission & Broadcasting Hours :Daily - No",
         region:"Oman",
         RegionId:"OM",
         Frequency:"A",
         Value:158,
         Unit:"Number",
         Scale:1
      },
      
         Time:"2015-01-01T00:00:00Z",
         program-quality:"Total",
         periodic-release:"Total",
         indicator:"Grand Total - Transmission & Broadcasting Hours :Daily - No",
         region:"Oman",
         RegionId:"OM",
         Frequency:"A",
         Value:187,
         Unit:"Number",
         Scale:1
      },
      
         Time:"2016-01-01T00:00:00Z",
         program-quality:"Total",
         periodic-release:"Total",
         indicator:"Grand Total - Transmission & Broadcasting Hours :Daily - No",
         region:"Oman",
         RegionId:"OM",
         Frequency:"A",
         Value:0,
         Unit:"Number",
         Scale:1
      },
      
         Time:"2002-01-01T00:00:00Z",
         program-quality:"Total",
         periodic-release:"Total",
         indicator:"No. Total Television Broadcasting Hours- Daily",
         region:"Oman",
         RegionId:"OM",
         Frequency:"A",
         Value:24,
         Unit:"Number",
         Scale:1
      },
      
         Time:"2003-01-01T00:00:00Z",
         program-quality:"Total",
         periodic-release:"Total",
         indicator:"No. Total Television Broadcasting Hours- Daily",
         region:"Oman",
         RegionId:"OM",
         Frequency:"A",
         Value:31,
         Unit:"Number",
         Scale:1
      },
      
         Time:"2004-01-01T00:00:00Z",
         program-quality:"Total",
         periodic-release:"Total",
         indicator:"No. Total Television Broadcasting Hours- Daily",
         region:"Oman",
         RegionId:"OM",
         Frequency:"A",
         Value:31,
         Unit:"Number",
         Scale:1
      },
      
         Time:"2005-01-01T00:00:00Z",
         program-quality:"Total",
         periodic-release:"Total",
         indicator:"No. Total Television Broadcasting Hours- Daily",
         region:"Oman",
         RegionId:"OM",
         Frequency:"A",
         Value:48,
         Unit:"Number",
         Scale:1
      },
      
         Time:"2006-01-01T00:00:00Z",
         program-quality:"Total",
         periodic-release:"Total",
         indicator:"No. Total Television Broadcasting Hours- Daily",
         region:"Oman",
         RegionId:"OM",
         Frequency:"A",
         Value:48,
         Unit:"Number",
         Scale:1
      },
      
         Time:"2007-01-01T00:00:00Z",
         program-quality:"Total",
         periodic-release:"Total",
         indicator:"No. Total Television Broadcasting Hours- Daily",
         region:"Oman",
         RegionId:"OM",
         Frequency:"A",
         Value:57,
         Unit:"Number",
         Scale:1
      },
      
         Time:"2008-01-01T00:00:00Z",
         program-quality:"Total",
         periodic-release:"Total",
         indicator:"No. Total Television Broadcasting Hours- Daily",
         region:"Oman",
         RegionId:"OM",
         Frequency:"A",
         Value:33,
         Unit:"Number",
         Scale:1
      },
      
         Time:"2009-01-01T00:00:00Z",
         program-quality:"Total",
         periodic-release:"Total",
         indicator:"No. Total Television Broadcasting Hours- Daily",
         region:"Oman",
         RegionId:"OM",
         Frequency:"A",
         Value:33,
         Unit:"Number",
         Scale:1
      },
      
         Time:"2010-01-01T00:00:00Z",
         program-quality:"Total",
         periodic-release:"Total",
         indicator:"No. Total Television Broadcasting Hours- Daily",
         region:"Oman",
         RegionId:"OM",
         Frequency:"A",
         Value:33,
         Unit:"Number",
         Scale:1
      },
      
         Time:"2011-01-01T00:00:00Z",
         program-quality:"Total",
         periodic-release:"Total",
         indicator:"No. Total Television Broadcasting Hours- Daily",
         region:"Oman",
         RegionId:"OM",
         Frequency:"A",
         Value:34,
         Unit:"Number",
         Scale:1
      },
      
         Time:"2012-01-01T00:00:00Z",
         program-quality:"Total",
         periodic-release:"Total",
         indicator:"No. Total Television Broadcasting Hours- Daily",
         region:"Oman",
         RegionId:"OM",
         Frequency:"A",
         Value:40,
         Unit:"Number",
         Scale:1
      },
      
         Time:"2013-01-01T00:00:00Z",
         program-quality:"Total",
         periodic-release:"Total",
         indicator:"No. Total Television Broadcasting Hours- Daily",
         region:"Oman",
         RegionId:"OM",
         Frequency:"A",
         Value:43,
         Unit:"Number",
         Scale:1
      },
      
         Time:"2014-01-01T00:00:00Z",
         program-quality:"Total",
         periodic-release:"Total",
         indicator:"No. Total Television Broadcasting Hours- Daily",
         region:"Oman",
         RegionId:"OM",
         Frequency:"A",
         Value:48,
         Unit:"Number",
         Scale:1
      },
      
         Time:"2015-01-01T00:00:00Z",
         program-quality:"Total",
         periodic-release:"Total",
         indicator:"No. Total Television Broadcasting Hours- Daily",
         region:"Oman",
         RegionId:"OM",
         Frequency:"A",
         Value:72,
         Unit:"Number",
         Scale:1
      },
      
         Time:"2016-01-01T00:00:00Z",
         program-quality:"Total",
         periodic-release:"Total",
         indicator:"No. Total Television Broadcasting Hours- Daily",
         region:"Oman",
         RegionId:"OM",
         Frequency:"A",
         Value:0,
         Unit:"Number",
         Scale:1
      }
   ]
}