sdmx-dl
GitHub Toggle Dark/Light/Auto mode Toggle Dark/Light/Auto mode Toggle Dark/Light/Auto mode Back to homepage

Usage

By default, all commands print the result on the standard output.
Most commands produce RFC4180 compliant CSV content.

Command arguments are composed of options and positional parameters. Options have a name, positional parameters are usually the values that follow the options, but they may be mixed. The general pattern is:

sdmx-dl fetch data ECB EXR M.CHF.EUR.SP00.A -o chf.csv
         command         parameters          options

All commands share the following options:

Commands summary

The commands follow a verb+noun hierarchy.

%%{init:{'themeVariables': {'textColor': '#fdf6e3', 'fontSize': '12px'},'flowchart':{'nodeSpacing': 5, 'rankSpacing': 30}}}%%
flowchart TB
    r{{sdmx-dl}}
    r --- f([fetch]) --- data & meta & keys
    r --- l([list]) --- sources & databases & flows & dimensions & attributes & codes & availability & features & plugins
    r --- c([check]) --- status & access & config & xsources[sources]
    r --- s([setup]) --- completion & launcher

    classDef default fill:#93a1a1,stroke-width:0px 
    linkStyle default stroke:#93a1a1
 
    classDef fx fill:#dc322f
    class f,data,meta,keys fx;
    click f "#fetch" "fetch command"
    click data "#fetch-data" "fetch data command"
    click meta "#fetch-meta" "fetch meta command"
    click keys "#fetch-keys" "fetch keys command"
   
    classDef lx fill:#859900
    class l,sources,databases,flows,dimensions,attributes,codes,availability,features,plugins lx;
    click l "#list" "list command"
    click sources "#list-sources" "list sources command"
    click databases "#list-databases" "list databases command"
    click flows "#list-flows" "list flows command"
    click dimensions "#list-dimensions" "list dimensions command"
    click attributes "#list-attributes" "list attributes command"
    click codes "#list-codes" "list codes command"
    click availability "#list-availability" "list availability command"
    click features "#list-features" "list features command"
    click plugins "#list-plugins" "list plugins command"
   
    classDef cx fill:#268bd2
    class c,status,access,config,xsources cx;
    click c "#check" "check command"
    click status "#check-status" "check status command"
    click access "#check-access" "check access command"
    click config "#check-config" "check config command"
    click xsources "#check-sources" "check sources command"
    
    classDef sx fill:#b58900
    class s,completion,launcher sx;
    click s "#setup" "setup command"
    click completion "#setup-completion" "setup completion command"
    click launcher "#setup-launcher" "setup launcher command"

Download time series.

Subcommands: data, meta, keys

Examples

List resources and structural metadata.

Subcommands: sources, databases, flows, dimensions, attributes, codes, availability, features, plugins

Examples

Check resources and services.

Subcommands: status, access, config, sources

Setup sdmx-dl.

Subcommands: completion, launcher

Commands details

Download time series observations.

Example: sdmx-dl fetch data ECB EXR M.USD+CHF.EUR.SP00.A

  1. source - Data source name.
  2. flow - Data flow reference.
  3. key - Data key.

Main options:

Other options: CSV, Network

Series ObsAttributes ObsPeriod ObsValue
M.CHF.EUR.SP00.A OBS_STATUS=A 1999-01-01T00:00:00 1.605495
M.CHF.EUR.SP00.A OBS_STATUS=A 1999-02-01T00:00:00 1.59785
M.CHF.EUR.SP00.A OBS_STATUS=A 1999-03-01T00:00:00 1.595430434782609
M.CHF.EUR.SP00.A OBS_STATUS=A 1999-04-01T00:00:00 1.601531818181818

Download time series metadata.

Example: sdmx-dl fetch meta ECB EXR M.USD+CHF.EUR.SP00.A

  1. source - Data source name.
  2. flow - Data flow reference.
  3. key - Data key.

Main options:

Other options: CSV, Network

Series Concept Value
M.CHF.EUR.SP00.A COLLECTION A
M.CHF.EUR.SP00.A UNIT CHF
M.CHF.EUR.SP00.A DECIMALS 4
M.CHF.EUR.SP00.A SOURCE_AGENCY 4F0
M.CHF.EUR.SP00.A UNIT_MULT 0
M.CHF.EUR.SP00.A TITLE Swiss franc/Euro

Download time series keys.

Example: sdmx-dl fetch keys ECB EXR M.USD+CHF.EUR.SP00.A

  1. source - Data source name.
  2. flow - Data flow reference.
  3. key - Data key.

Main options:

Other options: CSV, Network

CSV columns:

  1. Series:key
Series
A.CHF.EUR.SP00.A
D.CHF.EUR.SP00.A
H.CHF.EUR.SP00.A
M.CHF.EUR.SP00.A

List data source names and properties.

Example: sdmx-dl list sources

  • no parameters

Main options:

Other options: CSV

Name Description Aliases Driver Confidentiality Endpoint Properties Website Monitor MonitorWebsite Languages
ABS Australian Bureau of Statistics ri:abs PUBLIC https://stat.data.abs.gov.au/restsdmx/sdmx.ashx https://stat.data.abs.gov.au upptime:/nbbrd/sdmx-upptime/ABS https://nbbrd.github.io/sdmx-upptime/history/abs en
ECB European Central Bank ri:sdmx21 PUBLIC https://sdw-wsrest.ecb.europa.eu/service detailSupported=true https://sdw.ecb.europa.eu upptime:/nbbrd/sdmx-upptime/ECB https://nbbrd.github.io/sdmx-upptime/history/ecb en
ESTAT Eurostat EUROSTAT connectors:eurostat PUBLIC https://ec.europa.eu/eurostat/SDMX/diss-web/rest https://ec.europa.eu/eurostat/data/database upptime:/nbbrd/sdmx-upptime/ESTAT https://nbbrd.github.io/sdmx-upptime/history/estat en,de,fr

List databases.

Example: sdmx-dl list databases STATFI

  1. source - Data source name.

Main options:

Other options: CSV, Network

CSV columns:

  1. Id:string
  2. Name:string
Id Name

List data flows.

Example: sdmx-dl list flows ECB

  1. source - Data source name.

Main options:

Other options: CSV, Network

Ref Name Description
ECB:AME(1.0) AMECO
ECB:BKN(1.0) Banknotes statistics
ECB:BLS(1.0) Bank Lending Survey Statistics

List data flow dimensions.

Example: sdmx-dl list dimensions ECB EXR

  1. source - Data source name.
  2. flow - Data flow reference.

Main options:

Other options: CSV, Network

Name Label Coded Index
FREQ Frequency true 0
CURRENCY Currency true 1
CURRENCY_DENOM Currency denominator true 2
EXR_TYPE Exchange rate type true 3
EXR_SUFFIX Series variation - EXR context true 4

List data flow attributes.

Example: sdmx-dl list attributes ECB EXR

  1. source - Data source name.
  2. flow - Data flow reference.

Main options:

Other options: CSV, Network

Concept Label Coded Relationship
TIME_FORMAT Time format code false SERIES
OBS_STATUS Observation status true OBSERVATION
DECIMALS Decimals true GROUP

List codes from data flow concept.

Example: sdmx-dl list codes ECB EXR FREQ

  1. source - Data source name.
  2. flow - Data flow reference.
  3. concept - Concept name.

Main options:

Other options: CSV, Network

CSV columns:

  1. Code:string
  2. Label:string
Code Label
A Annual
Q Quarterly
B Daily - businessweek

List available dimension codes.

Example: sdmx-dl list availability ECB EXR M.CHF… 4

  1. source - Data source name.
  2. flow - Data flow reference.
  3. key - Data key.
  4. index - Zero-based index of key dimension.

Main options:

Other options: CSV, Network

CSV columns:

  1. Code:string
Code
A
E

List supported features of a data source.

Example: sdmx-dl list features ECB

  1. source - Data source name.

Main options:

Other options: CSV, Network

CSV columns:

  1. SupportedFeature:enum
SupportedFeature
SERIES_KEYS_ONLY

List plugin names and properties.

Example: sdmx-dl list plugins

  • no parameters

Main options:

Other options: CSV

Type Id Properties
REGISTRY RI_REGISTRY sdmxdl.registry.sourcesFile

Check service availability.

Example: sdmx-dl check status ECB

  1. sources - Data source names.

Main options:

Other options: CSV, Network

Source Status UptimeRatio AverageResponseTime ErrorMessage
ECB UP 99.691

Check service accessibility.

Example: sdmx-dl check access ECB

  1. sources - Data source names.

Main options:

Other options: CSV, Network

Source Accessible DurationInMillis ErrorMessage
ECB YES 726

Check sdmx-dl configuration.

Example: sdmx-dl check config

  • no parameters

Main options:

  • no options

Other options: CSV

Scope PropertyKey PropertyValue Category
SYSTEM sources C:\temp\some-sources.xml WIDE_OPTION
SYSTEM org.fusesource.jansi.Ansi.disable true OTHER
GLOBAL sources C:\Users\ABC\other-sources.xml WIDE_OPTION
LOCAL sdmx-dl.check.status.verbose true NARROW_OPTION

Check sources configuration.

Example: sdmx-dl check sources all

  1. sources - Data source names.

Main options:

Other options: CSV, Network

CSV columns:

  1. ID:string
  2. Issue:string
ID Issue
ECB No problem