|
|
|
# Fetcher name
|
|
|
|
|
|
|
|
## Provider
|
|
|
|
|
|
|
|
* **provider_name**: SECO
|
|
|
|
* **provider_longname**: State Secretariat for Economic Affairs, Switzerland
|
|
|
|
* **provider URL**:
|
|
|
|
* **region**: CH
|
|
|
|
* **terms of use**:
|
|
|
|
https://www.admin.ch/gov/en/start/terms-and-conditions.html
|
|
|
|
(requires asking permission to reproduce
|
|
|
|
* **approximate number of datasets**: 7
|
|
|
|
|
|
|
|
|
|
|
|
## Data accessibility
|
|
|
|
|
|
|
|
* **SDMX: (If yes, links and SDMX releases implemented**: no
|
|
|
|
* **REST API**: no
|
|
|
|
* **Bulk Download: (if yes, links and formats**: no
|
|
|
|
* **Account**: no
|
|
|
|
|
|
|
|
## Desired datasets
|
|
|
|
|
|
|
|
* **Description**: quarterly national accounts
|
|
|
|
* **URL**: all 7 files available at
|
|
|
|
https://www.seco.admin.ch/seco/en/home/wirtschaftslage---wirtschaftspolitik/Wirtschaftslage/bip-quartalsschaetzungen-/daten.html
|
|
|
|
|
|
|
|
## Data tree
|
|
|
|
|
|
|
|
* **Existence of a hierachy of datasets on web site**: yes from menus
|
|
|
|
available at https://www.seco.admin.ch/seco/en/home.html
|
|
|
|
* **How to recover the information**: parse html files
|
|
|
|
|
|
|
|
## Datasets
|
|
|
|
|
|
|
|
* **datasetCode**: filename
|
|
|
|
* **datasetName**: anchor text on https://www.seco.admin.ch/seco/en/home/wirtschaftslage---wirtschaftspolitik/Wirtschaftslage/bip-quartalsschaetzungen-/daten.html
|
|
|
|
* **how to get release date**: date in parenthesis in anchor text
|
|
|
|
* **dataset docHref**: https://www.seco.admin.ch/seco/en/home/wirtschaftslage---wirtschaftspolitik/Wirtschaftslage/bip-quartalsschaetzungen-.html
|
|
|
|
* **dataset notes**: no
|
|
|
|
* **dimension_list**:
|
|
|
|
- freq, frequency: Q,quaterly, sheets 2-5; annual: sheets 6-
|
|
|
|
- units: Units: nom, current prices, real, sheets 2, 6, prices of preceding year
|
|
|
|
(reference year 2010), sheets, 3, 7, defl, deflator,sheets 4,8, gc,
|
|
|
|
contribution to real GDP growth, sheets 5, 9
|
|
|
|
- concept, conpet: L: level, GR, growth rate
|
|
|
|
* **use of attributes**: no
|
|
|
|
* **attribute_list**: na
|
|
|
|
* **available frequencies**: Q and A
|
|
|
|
* **availability of previous updates**: https://www.seco.admin.ch/seco/en/home/wirtschaftslage---wirtschaftspolitik/Wirtschaftslage/bip-quartalsschaetzungen-.html
|
|
|
|
* **existence of real time datasets**: see http://www.sjes.ch/papers/2014-IV-3.pdf
|
|
|
|
## Series
|
|
|
|
|
|
|
|
* **Series key**: row 11 + GDP: gross domestic product (col C) '-'
|
|
|
|
units '-' concept '-' freq
|
|
|
|
* **Series name**: row 4-6 '-' units '-' concept '-' freq
|
|
|
|
* **Series docHref**: no
|
|
|
|
* **Series notes**: no
|
|
|
|
* **missing values**: blank
|
|
|
|
* **date format**: yyy q, yyyy
|
|
|
|
* **mixed frequencies in the same dataset**: yes
|
|
|
|
|
|
|
|
## Updates
|
|
|
|
|
|
|
|
* **calendar of future updates**: none
|
|
|
|
* **summary of previous updates**: none
|
|
|
|
* **regular updates**: none
|
|
|
|
* **RSS flow**: https://www.admin.ch/gov/en/start/dokumentation/medienmitteilungen/rss-feeds.html
|
|
|
|
* **best way to monitor updates**: check RSS
|
|
|
|
|
|
|
|
## Special problems
|
|
|
|
|
|
|
|
Excel files have a macro to choose the language and the macro is
|
|
|
|
protected by a password.
|
|
|
|
|
|
|
|
* **Procedure**
|
|
|
|
|
|
|
|
- use ssconvert from gnumerics suite to create a CSV file for each
|
|
|
|
sheet
|
|
|
|
- titles are in German in these CSV file
|
|
|
|
- use the last CSV file to find the corresponding titles in English
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|