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

Examples

  1. Download monthly (M) exchange rates (EXR) of Swiss franc (CHF) from the European Central Bank (ECB)
    sdmx-dl fetch data ECB EXR M.CHF.EUR.SP00.A
  2. Same as 1 with saving into a file
    sdmx-dl fetch data ECB EXR M.CHF.EUR.SP00.A -o filename.csv
  3. Same as 1 with saving into a compressed file
    sdmx-dl fetch data ECB EXR M.CHF.EUR.SP00.A -o filename.csv.gz -z
  4. Same as 1 with displaying as human-readable table (PowerShell example)
    sdmx-dl fetch data ECB EXR M.CHF.EUR.SP00.A | ConvertFrom-Csv | Select-Object -First 3 | Format-Table
    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
    
  5. Same as 1 with displaying as human-readable table (xsv example)
    sdmx-dl fetch data ECB EXR M.CHF.EUR.SP00.A | xsv slice -l 3 | xsv table
    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
    
  6. Same as 1 with displaying as human-readable table (Miller example)
    sdmx-dl fetch data ECB EXR M.CHF.EUR.SP00.A | mlr --c2p head -n 3 
    Series           ObsAttributes           ObsPeriod           ObsValue
    M.CHF.EUR.SP00.A OBS_STATUS=A,OBS_CONF=F 1999-01-01T00:00:00 1.605495
    M.CHF.EUR.SP00.A OBS_STATUS=A,OBS_CONF=F 1999-02-01T00:00:00 1.59785
    M.CHF.EUR.SP00.A OBS_STATUS=A,OBS_CONF=F 1999-03-01T00:00:00 1.5954304347826
    
  7. Same as 1 with US dollar (USD) alongside Swiss franc
    sdmx-dl fetch data ECB EXR M.CHF+USD.EUR.SP00.A
  8. Same as 1 for every available currencies
    sdmx-dl fetch data ECB EXR M..EUR.SP00.A
  9. Download available series in a dataset
    sdmx-dl fetch keys ECB EXR .CHF.EUR.SP00.A
  1. List available datasets from the European Central Bank (ECB)
    sdmx-dl list flows ECB
  2. List dimensions of the exchange rates (EXR)
    sdmx-dl list dimensions ECB EXR
  3. List codes of the frequency dimension (FREQ)
    sdmx-dl list codes ECB EXR FREQ