Difference between revisions of "SDMX-CSV Data"

From FMR Knowledge Base
Jump to navigation Jump to search
(Created page with "Category:SdmxDataFormat =Overview= The SDMX-CSV Data format is an official SDMX format described on the [https://github.com/sdmx-twg/sdmx-csv/tree/master/data-message SDM...")
 
(Example)
Line 10: Line 10:
 
=Example=
 
=Example=
  
An example data
+
An example dataset with IDs only, spaces have been added to this example to assist readability.
 +
<pre>
 +
DATAFLOW,    REF_AREA, INDICATOR, SUB_INDICATOR, FREQ, TIME_PERIOD, OBS_VALUE
 +
WB:GCI(1.0), GHA,      GCI,      RANK,          A,    2008,        102
 +
WB:GCI(1.0), GHA,      GCI,      RANK,          A,    2009,        114
 +
WB:GCI(1.0), GHA,      GCI,      RANK,          A,    2010,        114
 +
WB:GCI(1.0), GHA,      GCI,      RANK,          A,    2011,        114
 +
WB:GCI(1.0), GHA,      GCI,      RANK,          A,    2012,        103
 +
WB:GCI(1.0), GHA,      GCI,      RANK,          A,    2013,        114
 +
WB:GCI(1.0), GHA,      GCI,      RANK,          A,    2014,        111
 +
</pre>

Revision as of 14:17, 19 March 2020


Overview

The SDMX-CSV Data format is an official SDMX format described on the SDMX GitHub Repository.

The format is comma separated format where each row describes a single Observation value. The columns describe each component of the Observation value, reflecting the Components in the Data Structure Definition.

The dataset can contain both Code labels, in addition to the Code IDs. The order of the columns is not important, however each column header will contain the ID of the corresponding Component. The first column must be called Dataflow where each value contains the URN postfix of the Dataflow that dataset is for.

Example

An example dataset with IDs only, spaces have been added to this example to assist readability.

DATAFLOW,    REF_AREA, INDICATOR, SUB_INDICATOR, FREQ, TIME_PERIOD, OBS_VALUE
WB:GCI(1.0), GHA,      GCI,       RANK,          A,    2008,        102
WB:GCI(1.0), GHA,      GCI,       RANK,          A,    2009,        114
WB:GCI(1.0), GHA,      GCI,       RANK,          A,    2010,        114
WB:GCI(1.0), GHA,      GCI,       RANK,          A,    2011,        114
WB:GCI(1.0), GHA,      GCI,       RANK,          A,    2012,        103
WB:GCI(1.0), GHA,      GCI,       RANK,          A,    2013,        114
WB:GCI(1.0), GHA,      GCI,       RANK,          A,    2014,        111