BCB

Provider

• provider_name: BCB
• provider_longname: Banco Central do Brasil
• provider URL: http://www.bcb.gov.br
• region: Brasil
• terms of use: http://www.bcb.gov.br/htms/RightsReserved.asp
• approximate number of datasets:

Data accessibility

• SDMX: (If yes, links and SDMX releases implemented: NO
• REST API: SOAP https://www3.bcb.gov.br/sgspub/JSP/sgsgeral/FachadaWSSGS.wsdl. See https://gist.github.com/arademaker/1550651, but I don't know how to get the dataset list
• Bulk Download: (if yes, links and formats: NO
• Account: NO

Desired datasets

• Description:

• Balance of payments http://www.bcb.gov.br/ingles/economic/seriehist_i_bpm6.asp
• Economic indicators http://www.bcb.gov.br/pec/Indeco/Ingl/indecoi.asp

Data tree

• Existence of a hierachy of datasets on web site: No. Use "Balance of payments" and "Economic indicators" and then hierarchy for Economic indicators
• How to recover the information:

Datasets

Balance of payments

• URL: http://www.bcb.gov.br/ftp/notaecon/balpaya.zip, http://www.bcb.gov.br/ftp/notaecon/balpayq.zip, http://www.bcb.gov.br/ftp/notaecon/balpaym.zip
• Frequencies: A, Q, M
• Use only Table II of second sheet of Excel file (rows 1 to 59(
• The file format is the same for the three frequencies: we can use a single dataset with three frequencies
• Dataset code: BPII
• Dataset name: Balance of payments - Table II in million US$
• Series name: column A. "Debt securities - public", "Debt securities - private", "Direct loan", "Other loans" must be preceeded by "Disbursement" and "Amortization" to distinguish them
• Series codes: use a scheme exploiting the indentation:

    S1   Current account
    S11    Balance on goods - Balance of Payments
    S111      Exports
    S112      Imports
    S12    Services
    S121      Travel
    S122      Transportation
    S123      Operational leasing
    S124      Other
    S13    Primary income
    S131      Compensation of employees
    S132      Interest
    S133      Dividends
    S14    Secondary income
    
    S2  Capital account
    
    S3  Financial account
    S31    Investments - assets
    S311      Direct investment assets
    S312      Bank assets
    S313      Other assets
    S32    Investments - liabilities
    S321      Direct investment liabities
    S322      Equity and investmets fund shares
    S323      Debt securities issued in Brazil
    S324      Long-term loans and debt securities issued abroad
    S3241          Disbursements 
    S32411            Disbursements Debt securities - public
    S32412            Disbursements Debt securities - private
    S32413            Disbursements Direct loans
    S32414            Disbursements Other loans
    S3242          Amortizations 
    S32421            Amortizations Debt securities - public
    S32422            Amortizations Debt securities - private
    S32423            Amortizations Direct loans
    S32424            Amortizations Other loans
    S325      Short-term loans and debt securities issued abroad
    S326      Other liabilities
    S33    Financial derivatives - assets and liabilities
    S34    Reserve assets
    S4  Errors and omissions

• Be careful about dash that isn't an ASCII character

• how to get release date: Excel file property "Modified"
• dataset docHref: no
• dataset notes: no
• dimension_list: frequency
• use of attributes: no
• attribute_list:
• available frequencies: A Q M
• availability of previous updates: NO
• existence of real time datasets: NO

Economic indicators

• URL: http://www.bcb.gov.br/pec/Indeco/Ingl/indecoi.asp
• Datasets: http://www.bcb.gov.br/pec/Indeco/Ingl/ie-20180509i.zip
• Category tree as in http://www.bcb.gov.br/pec/Indeco/Ingl/indecoi.asp
• Use each Excel file as a dataset
• Dataset code: Sheet name
• Dataset name: A3
• Series Code: number of data column
• Series Name: column header. Merge line when necessary. Duplicate part of name that span several columns
• Frequency: years and months in same column
• Ignore summary lines after the dates
• Some files like I.1 have several panels. Use "Percentage change in 12 months", "Percentage change in the year", "Percentage change in the month" as value of "Concept" dimension

• how to get release date: Excel file property "Modified"
• dataset docHref: no
• dataset notes: no
• dimension_list: frequency + ??
• use of attributes: yes
• attribute_list: see on last lines
• available frequencies: A M
• availability of previous updates: NO
• existence of real time datasets: NO

Series

• Series key: see above
• Series name: see above
• Series docHref: no
• Series notes: yes (see notes on lines 53, 54, 55
• missing values: "-"
• date format: AAAA; AAAA I II III IVl AAAA Jan Feb ....
• mixed frequencies in the same dataset: yes

Updates

• calendar of future updates: if yes, provide URL
• summary of previous updates: no
• regular updates: Econonimc indicators: on Wednesday
• RSS flow:no
• best way to monitor updates: check release date of files for pattern

Special problems