1 / 4

Eurostat main tables and graphs

Eurostat main tables and graphs. Nordic webseminar, Stockholm, 16.-17. February 2010. The contents of the Eurostat tables. The tables in the database are presented according to the grouping of topics used in Official Statistics of Finland (OSF)

Download Presentation

Eurostat main tables and graphs

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Eurostat main tables and graphs Nordic webseminar, Stockholm, 16.-17. February 2010

  2. The contents of the Eurostat tables • The tables in the database are presented according to the grouping of topics used in Official Statistics of Finland (OSF) • At the moment all tables are in English, but translating the titles of the tables to Finnish is under consideration • Eurostat has added new tables to the predifined table set almost weekly • The automatic script downloads new tables as they are added to the ES service

  3. Downloading the data Markku Huttunen • SF has made a script to automatically download the ES tables • ES home > Statistics > Bulk download > Bulk download facility (>) • Bulk download area contains both predefined and database tables • All tables are downloaded but only predefined tables are used to create px-tables and PX-Web database • Data and all metadata are stored in different files: data files, dictionary files and table of contents • table of contents -> contents of the data files -> dictionary files -> PC-Axis files • The tables are downloaded from the ES site as they are • System consists of three scripts • a python script of 550 rows parses data and metadata into valid px-files • the file containing the python code: eurostat_pdt.py 16.2.2010 3

  4. Internet-dissemination with PX-Web and Verti PXWEB1 DMZ Dissemination area Internet PXWEB Internal dissemination and development area PXWEB StatFin (+ about 15 dissemination data bases) PXWEB2 VERTI test PXWEB PXWEB Automatic updating system PC-Axis -files Findicator VERTI1 PXWEB VERTI develop- ment VERTI2 PXWEB VERTI vevelop- ment VERTI runtime VERTI runtime Other graph and table needs VERTIh1* Feedback service for data providers ….. PXWEB VERTIh* develop- ment VERTIh* runtime VERTIh* runtime VERTIh = data bases for confidential information TP/PaTu/DB/Hans Baumgartner 2.1.2020 4

More Related