|
|
|
# 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
|
|
|
|
- Economic indicators http://www.bcb.gov.br/pec/Indeco/Ingl/ie-20180509i.zip
|
|
|
|
|
|
|
|
|
|
|
|
## 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
|
|
|
|
|
|
|
|
|