OECD.Stat Web Browser User Guide
Contents
1. 112 118 07 62 440 05 42 604 53 1 030 97 Grr 62 146 32 135 675 96 56 2606 11 39 063 64 975 13 676 55 101 95 Figure 15b Dataset view with empty rows and columns hidden May 2013 20 OECD Stat Web Browser User Guide 2013 Exporting to Excel Click on the Export option above the table and then select Excel to export your data selection to a MS Excel file You are prompted to either save the MS Excel file to disk or open it directly As your computer settings may not allow for the file to be directly opened it is recommended that you save the file to your desktop and then open it from there The maximum size of the file is limited to 100 000 data points ey Short Term Economic Indicators p Customise Export amp My queries Subject Industrial p Measure 3 Growth previo Draw chant Subject Industrial production 5 a Measure Growth previous Frequency Annual Quarterly Generate Microsoft Excel XLS file to export File size up to 100 000 data points Preserves current table layout Data flags saved as Excel footnotes _ Include extr col flags Figure 16 Using the Export to Excel option to save data in Excel format May 2013 21 OECD Stat Web Browser User Guide 2013 Exporting to a CSV file Larger tables can be saved to a CSV file Click on the Export option above the table an2. gf 2012 a w Q4 2012 Dec 2012 Nov 2012 Oct 2012 a M Q3 2012 sep 2012 Aug 2012 c Customise tatie optons Figure 10 Time period selection Note It is advisable to first select a general range of dates using the Select Time Range option and then include or exclude individual time periods using the Select Time Period option Similarly you may lose selected individual time periods if you make changes in the Select Time Period option before using the Select Time Range option The Select Time Range option only manages continuous non broken series of dates May 2013 15 OECD Stat Web Browser User Guide 2013 Adjusting the Dataset View by Moving Dimensions The different dimensions of a dataset can be displayed on either the horizontal or vertical axis of a table or in the filter area at the top of the table To move a dimension from one place to another click on the Customise option at the top of the table and then the Layout option from the drop down menu A dialog box pops up that allows you to visually drag and drop a dimension in the desired location Key Short Term Economic Indicators Harmonis GB Customise v export 7 HiDrawchart Y amp My queries edi Selection gt E Select a dimension ees eee ee es to drag and drop it in a different location Use these arrows to arrange dimensions within a Row Column or Page Filter Q po z a ye tio or USD millions Table options
3. Dani C Hide row hierarchies F Hide column hierarchies Dimension Member Labels Use codes Use full Show descriptions Hierarchy Other Options ia L Show empty axes C Show data bars Subject C Country C E Show Timestamp Measure F Frequency F Time C customise you customise selon Figure 13 Customising table options May 2013 18 OECD Stat Web Browser User Guide 2013 Showing Codes Instead of Names All datasets dimensions and variables have short codes as well as names To display codes instead of names in the table click on Customise above the table select 7able options from the drop down menu and then select the option Use codes instead of Use full descriptions To show both codes and full descriptions select both Use codes and Use full descriptions Key Short Term Economic Indicators Key Short Term Economic Indicators Eh Customise export iorawchart amp My Queries EF Customise EgbeExport Minrawchart amp My Queries Measure i Growth previous period Measure i Country Australia Country A Frequency Annual Frequency a 2011 2012 2011 2011 2012 2011 2012 2 Time Time ad 201104 201201 201202 201203 201204 2011 Subject Subject PR PRINTOO jo Production Production Industrial 0 06 os 01 SL SLRTTOO1 GG ps SLRTCRO3 GG 55 OD ODCNPIOS f O 57 production 5 8 Sales i Retail trade Volume 3 a
4. i Customise layout Page gt Country Australia z ans ee Click these arrows to move selected dimensions to a different location Column Country Frequency Time Figure 11 Moving a dimension to change the data table layout May 2013 16 OECD Stat Web Browser User Guide 2013 If there is more than one variable selected for a dimension located in the filter area at the top of the table click on the variable to open a drop down menu displaying all variables To change the filter that is applied to the data select the desired variable from the drop down menu If the dimension in the filter area does not have a drop down menu then only one variable has been se lected To include other variables click on the dimension name to the left of the selected variable and check other desired variables in the pop up box Key Short Term Economic Indicators FX Customise ei Ea Export he Ee Draw chat 7 My Queries Measure i Growth previous period Country Australia 7 Australia TEE Austria Belgium s Time feet Chile Czech Republic 1 Subject Denmark Estonia Finland France Industrial production 8 4 Retail trade Volume 5 4 Greece Hungary Iceland Ireland Israel Italy Japan Korea Passenger car registrations s a Permits issued for dwellings s a Hourly earnings manufacturing 5 4 Consumer prices all items Broad money 8 3 F
5. ssssannsnssnsnsnrannnrsrnnrsnnnrnsrnrnsrsennrsrrerserae 35 Printing data and other information from the web browser 36 Creating an e mail to the OECD Stat Project Team uns sssessenennss 37 38 OECD Stat Web Browser p 10 Search by keyword across themes and datasets p 31 View and save combined queries ORGANISATION p 11 Customise dimensions select variables change table layout view table options p 21 Export data to Excel CSV SDMX P30 p 26 Draw a chart using the current data selection Save and manage queries User Guide 2013 p 8 Full text search tool Version fran aise Contact us User Guide Home Emit Remove Save View Data by theme Popular queries Findin Themes Reset General Statistics Country statistical profiles Factbook Country Statistical Profiles 2013 edition Key Short Term Economic Indicators E Reference Series Li Information and Communication Technology International Trade and Balance of Payments Productivity Collapsible theme panel with expandable list of themes and datasets May 2013 HIDE NAVIGATION Draw chat 7 Subject Financial interest Long term interest rates Li 4571667 Statistics rates Monthly Per cent per annum Share Share Prices Monthly Index 4j 99 24223 Prices base 2005 100 Balance of Current Accounts Balance amp 6 913 567 Payments onthly in millions US Dollars sa
6. 113 227 20 7 2 5 5 196 120 Collapsible metadata p 28 panel http stats oecd org 39
7. Egh Gross domestic product quarterly Meas i ame per Manage Freque 1954 LT HIDE NAVIGATION Egh Central Government Debt Egh Labour Market Statistics i Composite Leading Indicators Australia Austria Country Fs Consumer price indices inflation Egh Monthly Monetary and Financial Belgium Statistics ME eae Eh Agricultural Outlook Chile em Aid Activities Czech Republic lah Health Status Denmark g Bilateral Trade by Industry Estonia Egh Trade in Value Added OECD WTO Finland Figure 29 Using the popular queries panel to select a frequently requested table or a saved table May 2013 33 OECD Stat Web Browser User Guide 2013 Use the Query Manager to sort and save the list of queries as well as to open or delete any query My Queries Order Name Date Sort queries 1 Life expectancy 02 01 2013 10 43 18 PM Delete giaa by typing the 2 Key Short Term Economic Indicators 02 01 2013 05 19 25 PM Delete Share o ene 5 GDP S 01 31 2013 03 12 19 PM f Historical expenditure approach Switzerland 17 31 201 12 1 Delete Share in the box J next to the 4 Balance of Payments MEI 01 31 2013 03 00 52 PM Delete Share query name gt Population 01 28 2013 11 08 09 PM Delete Share Sa DIE 01 28 2013 11 05 27 PM Delete Share Recent Queries Name Date P GDP Total and Expenditure Components 05 17 2011 04 40 41 PM Delete Share P 1 Gross domestic product GDP 09 20 2012 05 48 03 PM Delete
8. O amp CSV Me is nee EEEE EEEE E EEEE EE 22 Downloading related files and large data selections Lines nn sentais ire annees 23 40 6 gai gicice gm 4 OQ dina f D a AA ee Go nus 24 EXO CO Ail Sil TNC aaar EEA EE season ceeuereatecuease osc OET EEE EEE EE EEE 25 chariad PAET a ae de te ad et ae 26 Viewing Metadatdssssssnsssssonessicemsmaisesenuteuniiemicuinionmnaoninmtinnetoaorai 28 Other RSA SMS el as a aan eu eee e R ete 28 SEE EEE 29 Working With QUCFICS si ciccsiiiccscviwdesidetdseie weneivennsivareniecrtensencicmescendeesiesssenvestnsressdenesetiineseseies 30 CN OR ed EEE 30 Combining QUEFIeS ss sssssssvssssmscsertanacmmenussenennsinnnnensnsanisntenssnetenesetenneetessnte denses aa 31 COMING MU IDIS OO ee nn nt Ge ne 31 Viewngthe Query aa a KAEN an nu 32 Changing the QUEI Y cucicccanponuaeuiaareavigncnesicencatiacacuteusptavarisdasnteadataneadevssaadelworrielrmadeapeenienatieslmentaes 32 Saving MU DAS SOON aaa A A A nana ders Guanes ti 32 Viewing Frequently Requested and Saved Queries sssss2s 22222225225u20 20u2u2 2 8 33 Viewing the Country Statistical Profiles nn nnnnnnnnnnnnnnnnnnnnnnnennennnnnnnnnnnnnnennnnnnnnnnnnns 35 Printing Data from the Browser ssissscrmaseumssosecvinuscn snencseumuncisanatessencusenntesaneuenntiuniasnocsaneuciuuves 36 PrOVIGING FECGDACK siticarertsiestesseeiniesres tie e OZ May 2013 3 OECD Stat Web Browser User Guide 2013 Introduction OECD Stat is the statistical online platf
9. Passenger car 55 3 0 l 0 LFEMTTTT registrations LOG LCEAMNOT 0 0 sa CP CPALTTO1 O Orders Permits issued DO 457 ee os WA GMABMBMO1 6 s a 0 SPO spasti O Labour Total employment all persons 5 8 17 XT D XTEXV ADI indicators Labour Hourly earnings 35 Compensation amp manufacturing i sa i BPCRSE01 XTIMVA401 Price Indices Consumer prices Consumer prices 33 147 00 01 05 BPOBSEO1 all items amp NA GN AEXKPON Financial Moneta Broad money 55 DA i 2 as ba i HAEXKPOZ indicators aggregates and a 0 their components HAEXKPO3 Share Prices Share prices G j 4 0 NAEXKPOS Figure 14 Table showing codes instead of names May 2013 19 OECD Stat Web Browser Hiding Empty Rows or Columns User Guide 2013 If a table has many rows or columns containing no data it can be useful to hide these rows or columns in order to condense the table and improve readability To hide empty rows or columns click on Customise above the table select Tab e options from the drop down menu and then select the option Hide empty rows Hide empty columns or both Total flows by donor ODA OOF Private DAC1 GA Customise ba Eg Export s 4 Draw chat 7 Donor Part Fund flows Amount type Year gt Aid type TOTAL OFFICIAL AND PRIVATE FLOWS HIHIHI OFFICIAL DEVELOPMENT ASSISTANCE LA LB 8 LA Bilateral Official Development Assistance by types of aid 14243544
10. Web Browser Charting User Guide 2013 dynamic charting tool allows you to create line charts bar charts and scatter plots using the current data selection The charting engine is limited to work with 20 000 data points limit the data selection in your table before creating a chart The table dimension and variable selections are reflected in the chart you create EX Customise b Ga Export X Key Short Term Economic Indicators amp ndustrial Production Draw chart 8 My queries 7 ct industrial production s a EJ Line TT Growth previous period ss Scatter Plot E Customise EB Export z Draw chart z 8 My queries 7 lt lt Back to table See information on data for Israel different spe Industrial production s a Growth previous period Play changes in the data over time at eds Line Opacity Time Span f Axis Scale Show Distribution Fit to Selection Charting Options Display Mode Panel Show Line Labels Show All Lines Show Time Dots Use Color Map May 2013 Click on the little arrow next to the Y Axis variable to view the charting options panel You can adjust the time span and the scale of the Y Axis You can view the data figures as ab see solute values or as percentage Yearly Change 3 changes Yearly Change NOTE The options available in the charting options panel vary with the chart type eg line chart bar c
11. 009 anacsv2 zip 2803 13 12 2007 A A Figure 18 Finding and downloading files related to a dataset 23 OECD Stat Web Browser User Guide 2013 Exporting to PC Axis Table Click on the Export option above the table and then select PC Axis to export your data selection to a PC Axis table file As your computer setting may not allow you to open the file directly first save the file to your desktop and then open it Export Excel Text file CSV PC Axis SDMX Related Files Generate PC Axis file to export For more information on PC 4XIS and to download the data browser visit http www pc axis 2cbh se For more information on the PC Axie product please visit the PC Axie home page at http www scb se pc axis The PC Axis browser can be freely downloaded from here PC Axis 2007 version without Sal Figure 19 Exporting to PC Axis table May 2013 24 OECD Stat Web Browser User Guide 2013 Exporting to SDMX Click on the Export option above the table and then select SDMX to export your data selection to a XML file The data is available in compact or generic SDMX XML data format The structure of the dataset in cluding the variable codes and labels is available to export via the Data Structure Definition DSD file You are prompted to either save the XML file to disk or open it directly As your computer settings may not allow for the file to be directly opened it is recommended that you save the file to your desktop and
12. 3 227 20 27 2 5 5 196 120 Collapsible metadata p 28 panel OECD Stat Web Browser User Guide 2013 Table of Contents TET OGG COW a aa an na ea ne an 4 OQECD St t CONCEPES ee ee AN REDERE EAE eee ore 4 Dat a roan ea OR E 4 POTONE OR E EA E AEE A E EE E eer eee 5 IS OE CUT L vsiirtitcrctsca snnteinestennenaeteaagaracisedennatngaauanpnberaenaaniatannnedanatuieeminanianderinonanensanaeainedts 6 Getting Started PAG CS vsiciiincceaxdincssnccdenhecnnantinassnadessrveennniesdanndewss tases A ERASE ROAN 6 Language SSlSCUOMN wessscsninaasendnnicsavieseversiventexctsininraveredcasnessacensswendaneiniwintadaesedsnsnnpscscceversesanseweesennt 7 Locating Data through the OECD Stat Search nn nnnnnssnnnnnnnnnnnnnnnennnnnnnnnnnnnnnnnennnnnnnnnnnnns 8 Locating Data by Browsing Themes nn nnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnmnnennnnnnnnnnnnnnnnnnn n 9 Locating a Dataset or a Query in the Theme List nn nnnnnnnnnnnnnnnnnnnnnnnmenennnmnnnnnnnnnnnnnn 10 Using the Table Features s sssssisssssmmmsasssvesmivesnsissscanrentriitennnsaneesiensiinenseniinrtininesnnnniontiiennss 11 Selecting Dimensions and their Variables 5 sinsseni dec boianeasecanesunes daxentiadesmertacas 12 Changing me and FECCUCIICY ccsippacaridanasticinssoneuscavedasstusadevamneoneeueaatesabeiaeoeseaueensseitausanidesaanedasaieadisaaaiet 14 Adjusting the Dataset View by MOVING DIMeNSIONS din li data 16 FOMA CA OURS EA N eee 18 EPON O EKC OI PR PR E E EEEE E EA AI 21 EXPOFLING
13. 45464 74049410 1 Budget support 1 2 Sector budget support 2 Bilateral core contributions amp pooled programmes amp funds 2 1 Core support to NGOs other priv bodies PPPs amp research institutes Li a Core support to national NGOs amp other private bodies amp My Queries To 196 59 4 326 69 36 475 17 1 096 96 616 17 115 03 96 732 97 56 366 76 42 911 52 1 096 31 181 34 126 63 112 116 07 62 440 03 42 604 83 1 030 97 677 62 146 32 135 675 96 36 266 11 39 063 64 975 73 676 55 101 95 b Core support to international NGOs 167 713 32 oO 966 25 41 030 45 Figure 15a Before using the Hide Empty Rows and Columns options otal flows by donor ODA OOF Private DAC1 EE Customise Y ES Export a E Draw chat 7 Donor amp Wy Queries Part Fund flows gt Amount type Year Aid type TOTAL OFFICIAL AND PRIVATE FLOWS I Ie lk IV OFFICIAL DEVELOPMENT ASSISTANCE LA 1B 48 LA Bilateral Official Development Assistance by types of aid 142 3 4 5 0 7 3 9 10 2 1 Core support to NGOs other priv bodies PPPs amp research institutes Li a Core support to national NGOs amp other private bodies b Core support to international NGOs Current Prices 1990 A T F6 196 59 T 326 69 36 475 17 1 096 96 616 17 115 03 1991 A T 96 732 97 oO 3606 76 42 911 52 1 096 31 781 34 126 63 USD millions 1992
14. ATION OW INFORMATION D veloppement Figure 2 Changing the language of the browser May 2013 7 OECD Stat Web Browser User Guide 2013 Locating Data through the OECD Stat Search Enter keywords in the OECD Stat Search box in the top right hand corner of the screen OECD Stat will search through dataset names dimension names variable names and metadata for the keywords you entered You will get a list of search results which includes a link to the dataset where the keywords were found and details of where the keywords appear in the dataset To open a dataset click on the link NOTE Once you click on a link you are not be able to navigate back to the search results Run the search again if you want to click on another link The most relevant links are shown first based on how often the keyword appears in each dataset A keyword in the name of a dataset is considered more relevant than a keyword found only in one of the variables of a dimension in the dataset or in the metadata LNIS ATION Login Version fran aise Contact us User Guide Home ECONOMIC vs bp aga OECD S tat Search social expenditure A full text search is done on dataset names dimension members and metadata The results are not the variables themselves but rather a list of datasets where the search terms exist and a query for each dataset is proposed taking the search terms into account For your search on Social expenditure 114 resu
15. B Reset All Themes v General Statistics Indicator HIDE NAVIGATION Total value of production at farm gate 538 964 27 598 184 67 639 2765 73 662 795 66 727 948 74 Country statistical profiles Total of which share of MPS 12 58 12 33 71 49 11 32 10 52 Wolpe g commodes Oe CeO Laie Figure 27 Adding a selection of data to a multi dataset query Repeat this routine for each dataset that you wish to include in the multi dataset query May 2013 31 OECD Stat Web Browser Viewing the Query User Guide 2013 When you are finished adding queries to the Combine Queries basket expand the Combined Queries panel on the left hand side of the screen and click View to see the combined data table View the combined query Save the combined query ORGANISATION FOR ECONOMIC CO OPERATION AND DEVELOPMENT ombine Querie ss 1 Gross domestic product SDP Population and Labour Force FX Customise T ES Export a ransaction Measure S61G P115 Gross value added at basic prices excluding FISIM BS B1G Gross value added at basic prices total activity B1GA_B Agriculture hunting and forestry fishing amp 61GC_E Industry including energy B1GD of which Manufacturing opulation statistics 000 000 FA Customise ta Subject Total 2 61_GA Gross domestic C National currency current product output approach prices mill
16. ENT Data by theme eri Welcome OECD Stat includes data and metadata for OECD countries and selected non member economies Ways to access the data HIDE NAVIGATION SHOW INFORMATION e By keyword using search e g GDP FDI Health unemployment income population labour education trade finance prices Economic Outlook Government Debt Social expenditure e By selecting data in the left hand menu popular queries or data by theme e By accessing your saved queries under my queries for logged in users Environment Finance Globalisation Information and Communication Technology International Trade and Balance of Payments Figure 1 OECD Stat Browser Welcome Page May 2013 6 OECD Stat Web Browser User Guide 2013 Language Selection You can view the interface and data in English or French To change the language click on the language option located in the top right hand corner of the screen ORGANISATION DE Login English Version Contactez nous Guide Utilisateur Home COOPERATION ET CONOMIQUE Rechercher EY ECONOMIQUES Rechercher Premiers pas dans OCD Parcourir les themes Requ tes populai Bienvenue Trouver dans les Th m ES Annuler Tous les themes n l i 3 aaa nai OECD Stat comprend des donn es et des m tadonn es relatives aux pays de l OCDE et Statistiques g n rales k ea une s lection d conomies non membres Vous avez un acc s facile HIDE NAVIG
17. Exchange Currency exchange rates 0 9545 Rates Monthly National units per US Dollar Official Reserve Assets Monthly 25 419 4 Reserves SDR millions industry Industry industrial Production Index 112 3402 and Service Monthly base 2005 100 Statistics sa Internationalinternational Total Exports of Goods Li 23 823445 Trade Trade in Monthly in billions Current Statistics Goods Prices US Dollars sa Total Imports of Goods Q 20 28514 Monthly in bilions Current Prices US Dollars sa Total Exports less Imports of 3 549301 Goods Monthly in billions Current Prices US Dollars sa Labour Labour Harmonised Harmonised 5 20733766666667 Statistics Force UnemploymentUnemployment Statistics Rates Rates Monthly Monthly Prices and Consumer Consumer Price Index Q 120 2772 amp My Queries 7 a Country er Information Reference Series z amp Database Specific amp Purpose rd 2 The Reference Series dataset comprises the data w series that are the most frequently used as denominators for the calculation of ratios and 41 indicators An initial list of Reference Series has been obtained through consultation with analysts throughout the OECD The list contains the following i statistics main aggregates of national accounts 96 9 with history and forecasts labour market and population data exchange rates purchasing power 91 parities and price indices 0 27
18. OECD Stat Web Browser User Guide 2013 ORGANISATION FOR ECONOMIC CO OPERATION 1 AND DEVELOPMENT OECD Stat Web Browser User Guide May 2013 May 2013 1 OECD Stat Web Browser p 10 Search by keyword across themes and datasets p 31 View and save combined queries ORGANISATION p 11 Customise dimensions select variables change table layout view table options p 21 Export data to Excel CSV SDMX P30 p 26 Draw a chart using the current data selection Save and manage queries User Guide 2013 p 8 Full text search tool Version fran aise Contact us User Guide Home Data by theme Popular queries Findin Themes Reset Aen ye General Statistics Country statistical profiles Factbook Country Statistical Profiles 2013 edition Key Short Term Economic Indicators E Reference Series Q Information and Communication Technology International Trade and Balance of Payments Productivity Collapsible theme panel with expandable list of themes and datasets May 2013 HIDE NAVIGATION Draw chart Y gt Country amp My Queries 7 A Australia gt Subject Financial interest Long term interest rates Li 4 571667 Statistics rates Monthly Per cent per annum Share Share Prices Monthly Index 99 24223 Prices base 2005 100 Balance of Current Accounts Balance 6 913 567 Payments Monthly in millions US Dol
19. Share P Historical GDP expenditure approach 01 24 2013 03 20 50 PM Delete Share Figure 30 Viewing saved and recent queries Click the Share button next to a saved query to display the reference URL Copy and paste the URL to share your saved query with colleagues e g send via email NOTE Bear in mind that the viewer may need subscription access to a particular dataset in order to view it Copy and paste the link to share your query Order Name Date b Life expectancy 02 01 2013 10 43 18 PM Copy and paste this link Figure 31 Sharing saved queries May 2013 34 OECD Stat Web Browser User Guide 2013 Viewing the Country Statistical Profiles The Country Statistical Profiles dataset is useful for cross country comparisons based on key indicators compiled from all other datasets in OECD Stat Click on a pre defined country or region table below the Country Statistical Profiles dataset in the Themes panel Then customise the country table using the Customise option Select the Country Statistical Profiles dataset to explore cross country comparisons OR Select pre defined tables for individual OECD and some non OECD countries and regions roy tronc G OE CD S tq t Login Version fran aise Contact Ei Country statistical profiles Denmark a by theme Popular queries Reset Customise Fa Export Draw chart amp My Queries Page pn 2 Subject HIDE NAVIGATION Population Population Total popu
20. a table corre sponding to this new selection Alternatively after selecting variables for one dimension continue modifying the other dimensions shown across the top of the pop up screen before viewing the new table May 2013 12 OECD Stat Web Browser User Guide 2013 You may also search for variables in the Customise Selection pop up by typing a keyword in the search box for a given dimension All variables containing the keyword will be displayed Enter Customise selection keyword in the search box Other selections Subject 1 43 Country 50 50 Measure 1 3 Time amp Frequency 16 Nu J Subject E Cyclical indicato E Leading Indi GDP ratio to Subject 1 48 Country 50 50 Measure 1 3 Time amp Frequency 16 Customise selection Labour indicato Select Unselect A full text search is done on dimension member Subject For your search on prices 12 results found O Producer prices F Domestic producer prices manufacturing Search results per containing the F Consumer prices all tems keyword are listed in the pop up window A Share Prices O Share prices F Gross domestic product constant prices s a i SOP Private final consumption expenditure constant prices s a E CDP Govern ment consumption expenditure constant prices s a GDP Gross fxed capital formation constant prices s a 3 Exports constant prices s a Ep GDP Imports of goods and services cons
21. ack Contact the OECD Stat Project Team via e mail using the Contact Us link located in the top right hand corner of the screen User Guide 2013 Please fill out the contact form using as much detail as possible to describe your technical or content ques tion The e mail addresses that receive queries from the Contact Us link are e OECDdotStat oecd org for technical problems e OECDdotContent oecd org for content questions 1RGANISATION OR ECONOMIC O OPERATION pi ND DEVELOPMENT e u Central Government Debt F4 Customise hi ES Export E Draw chat My queries Australis Austria Belgium Canada Chile i Czech H Denmar Estonia Finland i France i German Greece Hungar Iceland i relandi Israeli aby i Japani May 2013 Variable Total central government debt of GDP Contact us Frequently Asked Questions FAQs Ask a question or give feedback Ask a question or give feedback My Personal Information Title O Mr O Mrs O Ms Last Name Organization Enterprise fo O OE E mail address fe z My Current Selection Dataset GOV_DEBT View selection 8089 Please select and complete the option that corresponds to your request Content question oO Technical Problem O Feedback Click here to contact the OECD Stat support team Login Version fran aise Cor Search cannot find data Fm looking for the data found doesnt correspond to what expected or have another questi
22. ble to an Excel file the metadata link I is still active in the Excel file Key Short Term Econo EX Customise in ES Export Subject Production Sales amp Orders c Orders Labour indicators Unit Labour Costs Price Indices Consumer prices Financial Monetary aggregates indicators Share Prices i International trade Imports in goods 5 4 m 1 m Data extracted on 08 May 2013 21 36 UTC GMT from OECD Stat Exports in goods 5 8 Click on the i to open the metadata panel on the right side of the screen ic Indicators Draw chan Country gt Measure Frequency Time Industrial production 3 a Retail trade Volume z a 0 Passenger car registrations s a Permits issued for dwellings 2 a 0 Total employment all persons 3 8 Labour Compensation Hoy rly earnings manufacturing s a Unit labour cost business sector trend cycle 5 4 0 Consumer prices all items i Broad money 5 4 and their components Share prices Lim amp My Queries Australia Hide th ide the Scroll through metadata panel the metadata for a full screen panel view of the data table Information Key Short Term Economic Indicators Wa So 2 E Source E contact person organisation 2010 AF 2011 A 2012 A F CO statistics contact STAT Contactoecd ord spulation amp Scope Statistical population The Key Economic Indicators KED da
23. bles LS Layout Q gt Country 50 50 from each amp Table options o Measure 3 3 Quarterly Monthly P RATEN Time amp Frequency 13 table a3 4 ai O 22012 Q3 CH Aug sep Oct Customise selection Other selections Subject 43 43 Country 5050 Measure X3 Time amp Frequency 13 Number of cell currently selected 260500 Country Australia Austria Find in selection B Exact wording or phrase Expand all Collapse all Select all Unselect all Subject E Production Sales amp Orders E 6 Production Industrial production 5 4 a Sales 6 Retail trade Volume s a Passenger car registrations 5 4 a Orders Permits issued for dwellings 5 4 a Cyclical indicators a Leading Indicators Leading indicator amplitude adjusted GDF ratio to trend smoothed a Labour indicators Total employment all persons 5 4 Czech Republic Den mark View sub categories by clicking on the plus or minus symbol Customize layout Customize table options Figure 7 Customise the selection of variables for each dimension To select or unselect a variable click the check box to the left of the variable A plus or minus symbol appears next to the variable name if the variable has a sub category Click on this symbol to show or hide the variables of the sub category Click View Data to apply your selection of variables for the current dimension and to see
24. d then select Text file CSV The maximum size of the file is limited to 1 000 000 data points Select a dimension label format and a column separator The dimension label format determines what information is included in your file for each variable The column separator determines which character is used to separate columns in the file Enter your e mail address and click the Export to Text CSV file button An e mail is sent to you informing you how to retrieve the CSV file The file is not attached to the email as it may be very large Instead the e mail contains a link for downloading the file Export Excel Text file CSV PC Axis SDMX Related Files Generate Delimited Text CSV file to export File size up to 1 000 000 data points Flattens current table layout does not preserve multi dimensional layout The file is being generated and a link will be sent via email This process should take only a few minutes Dimension label format Column separator Code only Comma Enter your email address Code column separator english label column separator french label Pipe 1 to receive the CSV file O Code column separator english label O Tab English label O Code English label You may edit your email address here Your email address will remain confidential Figure 17 Using the Export to CSV option to save data as a CSV file May 2013 22 OECD Stat Web Browser Downloading related files and large
25. data selections User Guide 2013 Documents related to a particular dataset are available for download under the Export option above the table The list of files may contain large prepared selections of data or related documents in any format which is indicated in the File type column Click on the name of a file to download it May 2013 1 Gross domestic product GDP E export Draw chart Excel E Text file CSV PC axis E SDMX XML Related files FA Customise kei amp My queries T Transaction E 51 GA Gross domestic E BiG Gross value adde Ready made files Download Files 1 Gross domestic product GDP Please click on the name of the file to download it Name File type File name Annual national accounts changes See ANAonOECDStat for detailed information on the database structure and codification Annual National Accounts gi of OECD countries Vol 2 Detailed Tables 1970 2007 2008 Prov CSV format Technical Information for gi Annual National Accounts of OECD Countries Vol 2 Annual National Accounts Vol 2 1960 1997 Archives CSV format Annual National Accounts gi Anavol2 zip 1498 13 12 2007 Vol 2 1960 1997 Archives Beyond 20 20 format File size KB Date updated dd mm yyy ANA Changes xls 28 08 11 2012 ANAonDOTSTAT_eng doc 675 08 11 2012 CD_SNAV2_CSV zip 2317 09 07 2009 CD_SNAV2_notes zip 365 09 07 2
26. e Query Canada Please be aware that Saved Queries are personal to OECD users and are not vigible to other users If you provide a query with a name that already exists the previous query will be overwritten Ybu can delete queries that you created Personal query Total broadband Please name this query English Please name this query French total haut d bit hae ao Ao P Personal Query Figure 26 Saving a query with optional renaming May 2013 30 OECD Stat Web Browser User Guide 2013 Combining Queries Use the Combine Query function to view data from two or more datasets in a combined table Any com mon dimensions between the different datasets should be automatically combined provided that the data has been correctly entered into the system Other dimensions will automatically be displayed along the vertical axis underneath section headings indicating which dataset they come from Combining Multiple Queries First customise a table from one dataset Then click on the My queries option above the table and select the Combine option in order to put this query into your data basket The data basket holds queries to be combined Combine Queries 2012 A OECD Estimate of support to agriculture E Customise i EA Export b E Draw chat 7 7 amp My queries 1986 NE Combine aF A Manage Data by theme Popular queries Time Find in Themes
27. hart scatter plot Industrial production s a Growth Figure 21 Charting Line Chart 26 OECD Stat Web Browser May 2013 Total freshwater Total gross abstraction a ao 5 pol 2 8 a k Om gt A Total freshwater hart Software NComWYA English v FN ra 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 y UR 1 1 I 1 1 I 1 I I 1 LN Figure 22 Charting Bar Chart Freshwater abstractions million m3 amp EX Customise Sof EB Export Draw chat 7 amp My queries 7 lt lt Back to table tm See information on data for Israel Size None v Scale WY Japan Mexico Spain France M Korea Australia 20 000 5 8 8 3 T F 4 G 10 000 20 000 30 000 40 000 50 000 60 000 70 000 80 000 2 11 x v eZ Total freshwater Total gross abstraction v W Trails Chart Software NComVA English v CD v 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 Wig 1 0 A i I I I I I I I I 1 LS Figure 23 Charting Scatter Plot User Guide 2013 27 OECD Stat Web Browser Viewing Metadata User Guide 2013 Metadata can be viewed at all levels from the dataset level abstract down to cell level footnotes The presence of metadata is flagged by a small blue circle with a white W Clicking on the I reveals an infor mation panel on the right hand side of the screen When you export a ta
28. ich they correspond Any table that contains flags displays a legend below the table that explains the meaning of each letter P5531 Gross capital formation K251 Acquisitions less disposals of non financial non produced assets K151 Consumption of feed capital B91 Net lending net borrowing Leg end E Estimated value Hover above the flag to learn what it means fr 9 121 180 1 LE 10203 290 8 Estimated value E 40746410 E 45351827 E 41 2142 444 4 E 1 455674 4 Figure 25 Viewing the data flag legend May 2013 29 OECD Stat Web Browser User Guide 2013 Working with Queries Saving a Query Before working with queries log in by clicking on the Login link in the top right hand corner of the screen Once logged in your name appears in the top right hand corner of the screen Your data selection or query can be saved at any time by clicking on the My queries option above the table and then selecting Save In the pop up box type the name of the query and then click the Save as new Query button On subsequent visits to the browser this saved query can be opened to view the latest data available within the selection Broadband database Export E Draw chart Wal H Save Combine Customise amp My querie s 7 Name the query you want to save Save your query D Country Australia Save Austria Belgium Sav
29. ie Refresh Export to Microsoft Excel Properties HIDE INFORMATION Click to print out displayed metadata Information Key Short Term Economic Indicators E Source B Contact person organization OECD statistics contact STAT Contacti oecd org B Population amp Scope B Statistical population The Key Economic Indicators KED database contains monthly and quarterly statistics and associated statistical methodological information for the 34 OECD member and for a selection of non member countries on wide variety of economic indicators namely quarterly national accounts industrial production composite leading indicators business tendency and consumer opinion Surveys retail trade consumer and producer prices hourly earnings employmentlunemployment interest rates monetary aggregates exchange rates international trade and balance of payments B other Aspects EB Recommended uses and limitations Indicators have been prepared by national statistical agencies primarily ta meet the requirements of users within their own country In most instances the indicators are compiled in accordance with international statistical Guidelines and recommendations However national practices may depart from these guidelines and these departures may impact on comparability between countries Figure 33 Printing data and other information from the web browser May 2013 36 OECD Stat Web Browser Providing Feedb
30. iew using Country drop down MISE csccccccenensscescccerensnsevancerersasenseser 17 Customising Tai 6 00 TONS actos es oasnatsaneeatncnasssandesersccedenuscnerertaderensesasieeseewennes 18 Table showing codes instead of NAIMES sccccccscccncccscesceuneceucessununeeucensensneeseeennnns 19 Dataset view with empty rows and columns hidden 20 Using the Export to Excel option to save data in Excel format PA Using the Export to CSV option to save data as a CSV file 22 Finding and downloading files related to a dataset 23 EPO MT OFCA AD ee a EE IENE AEE IEEE 24 ge D al eR Eo D i EEE ae rac E A E A T E A 25 Ce E IDE CO aA EEE A E de PEET E E A 26 Sie aS a E a S g A E E E E E E P ee A AA en re 27 Charung Scatter F10G ne and ma ea ee a a NEEE AACA or ARAARA 27 Dataset and cell level M tAUAEA nie esnareses ses des arrete didier nain ree 28 Viewing the data flag OO aa aa era en a an e c ae aonionacoines 29 Saving a query with ODUONGI T CN aINING exces moe hacrvarse canaris ne iii n ancre 30 Adding a selection of data to a multi dataset query 31 Viewing compined querie S aa EE a da ce es ce on dite 32 Using popular queries panel to select a frequently requested table or saved table 33 Viewing saved and recent querieS ssssssssssrsssrssssssrsssessrssnssesensssenenesensnssnns 34 DOAN Saved GUCH CS eee eee ee EREEREER E sde one 34 Viewing a Country Statistical Profile
31. igure 12 Changing the view using Country drop down list May 2013 17 OECD Stat Web Browser User Guide 2013 Formatting Options To format the view of the displayed table click on Customise above the table and then select Table options from the drop down menu From there you can customise table options Decimals Select the number of decimal points displayed for the data points e Scaling Multiply the data points by unit value hundreds thousands hundredths thousandths etc e Dimension Member Labels View dimension names as codes descriptive titles or both e Empty rows and columns Hide or show rows and columns that contain no data The option to Fully Fill Page only appears when Hide Empty Rows is selected e Hierarchies Hide row hierarchies and or column hierarchies e Other Options Show empty axes show timestamps of when the data was uploaded and or show data bars to more easily visualize the data trends within each cell Key Short Term Economic Indicators FX Customise Fg Export pet E Oraw chart 7 e Selection gt Subject Indust Layout 4 gt Measure rx Fully Fill Page only Table options appears when Hide Empty Rows is selected amp My queries Customise table options Country Decimals Empty rows and dolumns Number of decimal places 1 x Hide empty rows Hide empty columns Belgium y Fully Fill Page Scaling Multiply the values in the table by a
32. ions Population 000 Population under 15 Population 15 64 000 142250 145370 148530 15075 015 256 0 Population over 65 Fa Export E Frequency Annual Country Australiad Frequency Annual 2007 2008 2009 2010 2011 2012 AT a AT a AY AY Dataset 1 Gross domestic product GDPF 6 1175 949 01 252 216 01 293 360 01 401 166 0 1 066 112 01 166 675 01 203 046 01 299 235 0 1 086 112 01 168 875 01 203 046 01 299 285 0 26 700 0 27 721 0 27 356 0 218905 0 249151 0 237 225 0 110 497 0 109403 0 111 654 0 Sex Dataset Population and Labour Force a ee All 210720 214990 219520 22 300 022 621 0 persons 4 054 0 4131 0 4 166 0 4216 0 4261 0 Q 2 764 0 2631 0 2913 0 3 006 0 3 104 0 Figure 28 Viewing combined queries May 2013 32 OECD Stat Web Browser User Guide 2013 Viewing Frequently Requested and Saved Queries Open the Popular Queries panel to access a set of frequently requested pre defined queries If you are logged in you may access and manage your saved queries under My Queries in the Popular Queries panel OR Manage under My Queries above the table IX OECD Stat nn j i 0 C S Ti Lf in i ji eines Popular queries Consumer Prices MEI Consumer prices Annual inflation r l FX Customise E ES Export Hi Draw chat 7 f amp My queries Subj Frequently requested data ig Country statistical profiles Eeh Economic Outlook ig Gross domestic product annual
33. lars sa Exchange Currency exchange rates i 0 9545 Rates Monthly National units per US Dollar Official Reserve Assets Monthly 25 419 4 Reserves SDR millions Industry Industry industrial Production Index 112 3402 and Service Monthly base 2005 100 Statistics sa Q Internationalinternational Total Exports of Goods Li 23 83445 Trade Trade in Monthly in billions Current Statistics Goods Prices US Dollars sa Total Imports of Goods Li 20 28514 Monthly in billions Current Prices US Dollars sa Total Exports less Imports of 3 549201 Goods Monthly in billions Current Prices US Dollars sa Q Labour Labour Harmonised Harmonised 5 20733766666667 Statistics Force UnemploymentUnemployment Statistics Rates Rates Monthly Monthiy Prices and Consumer Consumer Price Index o 120 2772 http stats oecd org Information Reference Series 3 3 B z 2 Database Specific amp Purpose 2 Z The Reference Series dataset comprises the data ws series that are the most frequently used as denominators for the calculation of ratios and 4i indicators An initial list of Reference Series has been obtained through consultation with analysts throughout the OECD The list contains the following statistics main aggregates of national accounts 96 9 with history and forecasts labour market and population data exchange rates purchasing power 91 parities and price indices 0 27 11
34. lation Population levels amp 5 339 615 and migration us Population growth rates 0 0334792787 Total fertility rates i 1 771 Dependent Youth population aged less than 15 E 18 50047 population Ekierty population aged 65 and over E 14 82005 Population by Share of national population in the ten per cent of region regions with the largest population Total population country average Total population metropolitan regions Distribution of the national population into urban regions Distribution of the national population into intermediate regions Distribution of the national population into rural regions Figure 32 Viewing a Country Statistical Profile May 2013 35 OECD Stat Web Browser Printing Data from the Browser User Guide 2013 To print a table directly from OECD Stat right click on the table and select the Print command Print the metadata separately by clicking on the Print icon in the top right hand corner of the metadata panel 012 Juk 2012 7 AF 100 0 99 8 99 6 99 8 96 7 99 4 99 6 100 5 99 1 99 6 99 2 99 4 99 0 100 9 99 9 99 0 100 3 100 2 99 4 100 7 Aug 2014 Ay Right click to print table using the web browser print options Sep 2012 Oct 2012 Nov 2012 27 a Back Forward ave Background AS et as Background Gopy Background Select All Paste Create Shortout Add to Favorites view SOUrFCE Encodno Print Print Prev
35. lts found Social Expenditure Aggregated data Found in datesetname o Social Expenditure Aggregated M A Social Expenditure Aggregated data Found inumembemname Other social policy areas Other social policy areas Income maintenance Other social policy areas Other cash benefits Other social policy areas Social assistance Other social policy areas Other benefits in kind In percentage of Total General Government Expenditure SHOW INFORMATION La La Found in dimensionname Type of Expenditure Social Expenditure Reference series i Found in dateseiname SOCial Expenditure Reference series Social Expenditure Reference series Found in membermame Total general government expenditure at current prices in national currency in millions Health Expenditure and Financing Found in dateseiname Health Expenditure and Financing Found in memberame General government excl social security Territorial government Social security funds Private social insurance Private insurance other than social insurance Cost sharing central government state provincial government Local municipal government Soci Total expenditure HF 1 HF 3 General go 11 Government expenditure by function COFOG amp Found in dsteseiname 11 Government expenditure by fu
36. nction COFOG Found in memberame Social benefits and social transfers in kind for products supplied to hhds Social benefits other than social transfers in Final consumption expenditure Total government expenditure Gross domestic product expenditure Se LA THO praler Ceo Oe Figure 3 Results from the search ranked in order of relevance May 2013 8 OECD Stat Web Browser User Guide 2013 Locating Data by Browsing Themes Browse the Data by Theme panel by clicking on a theme title then on a sub theme title and so forth until you can select a dataset Datasets are marked by the table icon in front of their name When you click on a dataset a default table view opens This view can be customised see next section ORGANISATION a Login Version f FOR ECONOMIC Th Traf CO OPERATION a AND DEVELOPMENT 4 i Data by theme Popular queries We come Find in Themes Reset All Themes OECD Stat includes data and metad General Statistics selected non member economies Demography and Population E Migration Statistics Ways to access the data HIDE NAVIGATION By keyword using search e unemployment income por trade finance prices Econa Debt Social expenditure By selecting data in the left or data by theme By accessing your saved que logged in users Education and Training Figure 4 Browsing through themes to view data Ma
37. on concerning the data More details Fo 156 0 Figure 34 Creating an e mail to the OECD Stat Project Team tting Started 37 OECD Stat Web Browser User Guide 2013 Table of Figures used in this Guide Figure 1 OECD Silat Browser Welcome POUR 2 danse areas bebe Dan cine cn cause ne ianeaiees 6 Figure 2 Changing the language Of the DrOWS F veviriccrntitadcnderentesceved perritancienecenes tie dun eesssnesusss 7 Figure 3 Results from the search ranked in order Of relevance 8 Figure 4 Browsing through themes to view QG dnnsrs centeasmasecenemarees scies euetcensep esaiesee 9 Figure 5 Finding a theme or dataset by KCYWOIG ccccsnccrccncccncennennneerennessneensennnsnnseeneennennnegs 10 Figure 6 Default dataset view and current selection values 11 Figure 7 Customise the selection of variables for each dimension 12 Figure 8 Search variables by keyword when customising dimensions 13 Figure 97 TimMmerange SeleCtON SE a me instanti nahan RANTE a Go EAEEREN 14 Figure 10 Figure 11 Figure 12 Figure 13 Figure 14 Figure 15 Figure 16 Figure 17 Figure 18 Figure 19 Figure 20 Figure 21 Figure 22 Figure 23 Figure 24 Figure 25 Figure 26 Figure 27 Figure 28 Figure 29 Figure 30 Figure 31 Figure 32 Figure 33 Figure 34 May 2013 THC period SC CCE OD ose ae ae ee a an ne ati ie AEREE 15 Moving a dimension to change the data table layout 16 Changing the v
38. orm of the OECD where users can search and access OECD s statistical databases Working across and within individual datasets you will be able to e Build tables by selecting variables and customising the table layout e Extract and download large volumes of data up to 100 000 cells in Excel and 1 000 000 in CSV format e View detailed metadata on methodology and sources OECD Stat Concepts OECD Stat is structured around these main concepts Information catalogued by themes datasets dimensions variables and reference series Storage of metadata ranging from the dataset to the cell level Storage of numeric data figures as well as cell level flags A data warehouse search engine Data Organisation Datasets Within OECD Stat statistical data are organised into datasets A dataset is a collection of numerical values with associated textual information All values share a common set of dimensions Dimensions The dimensions of a dataset are the axes on which the data are labeled Country and year are two common examples of dimensions Dimensions can be presented as either a flat list or as a hierarchy with dimension subsets Variables Every dimension contains a pre defined list of variables In the country dimension for example the variables are the individual countries Metadata Metadata is the qualitative data that describes the empirical data in OECD Stat Metadata can be viewed for datasets dimensions and variables along
39. r example by clicking Select Date Range or indicate that you wish to have the most recent data available last 5 years for example by clicking Se ect Latest Data When selecting a date range it is possible to select a start year quarter month etc and automatically include all available data from that date onward by checking the box next to Latest Available Data Customise selection Other selections Subject A648 Country 50 50 Measure 3 3 Time amp Frequency 13 Number of celle currenth selected 280800 Quarterly and monthly Select time range Select time period ranges are not available for all datasets Select date range Select latest data From To latest available data Select last Annual 201 2013 ka 3 years Quarterly a j quarters Monthly se 6 months cutie tatie optons Figure 9 Time range selection May 2013 14 OECD Stat Web Browser User Guide 2013 Time Period Selection It is also possible to select individual years quarters months etc by checking the box next to each item This is necessary if the selection of dates you wish to include is not a continuous series and contains breaks or time periods outside the main date range Customise selection Other selections Subject 46 46 Country 50 50 Measure X3 Time amp Frequency 13 Number of cel currently selected 260600 Select time range Select time period Expand all Collapse al Select all Unselect all a M 2013 Jan 2013
40. side the table Flags A flag is a letter that appears alongside the numerical data in any table cell where it applies It is a qualitative note that recurs in a dataset for many individual data figures A legend appears beneath the table explain ing the meaning of each flag present in the table Flags frequently indicate general data properties such as confidential provisional and estimated Query A query is a pre defined set of data within a dataset to highlight a certain topical content of the overall data set Queries appear alongside of datasets May 2013 4 OECD Stat Web Browser User Guide 2013 Reference Series number of data series that the OECD Statistics Directorate uses to calculate indicators are available via the Reference Series dataset Data in this dataset are linked dynamically to the source datasets from which they are taken so that there is no duplication of data and that the Reference Series contain the most recent data available May 2013 5 OECD Stat Web Browser User Guide 2013 User Guide This user guide walks you through basic and more advanced features of OECD Stat Getting Started Page The browser is best used in full screen view at 1024x768 pixel screen resolution or higher From the We come page you may find data in the following ways Search OECD Stat by Keyword Browse Themes Search Themes by Keyword ORGANISATION FOR ECONOMIC CO OPERATION AND DEVELOPM
41. tabase contains monthly and quarterly statistics Cand associated statistical methodological information for the 34 OECD member and for a selection of non member countries on wide variety af economic indicators namely quarterly national accounts industrial production composite leading indicators business tendency and consumer opinion Surveys retail trade consumer and producer prices hourly earnings employmentfunemployment interest rates monetary aggregates exchange rates international trade and balance of payments E other Aspects EB Recommended uses and limitations Indicators have been prepared by national statistical agencies primarily to meet the requirements of users within their own country In most instances the indicators are compiled in accordance with international statistical guidelines and recommendations However national practices may depart from these guidelines and these departures may impact on comparability between countries There if an on going process of review and revision of the contents of the database in order to Figure 24 Dataset and cell level metadata Other Related Metadata The metadata panel may contain links to metadata for related datasets as well as contact information May 2013 28 OECD Stat Web Browser Flags Flags represent metadata that recurs frequently within a dataset User Guide 2013 Flags appear as letters in parentheses in the cell alongside the data figures to wh
42. tant prices s a Figure 8 Search variables by keyword when customising dimensions Customise Selection Colour Coding Colour coding helps you see if data exist for a particular variable This way you will not waste time search ing for data that does not exist When modifying dimensions in the Customise Selection window you see that variable names are different colours The colours indicate whether data exist or not for a given variable Based on the current selection for all other variables Dark Blue Data exist for this variable Blue No data exist for this variable but may exist for sub categories of this variable Gray No data exist at any level for this variable Remember The colour coding takes into account the current selection for all other variables In other words the colours indicate the existence of data for the countries years etc currently selected May 2013 13 OECD Stat Web Browser User Guide 2013 Changing the Time Period and Frequency There are two ways to select the time period and frequency variables e Select the time range e Select the time period Time Range Selection All frequencies available for the selected dataset are shown on the screen For example if only annual data are available the option to select quarters and months will not appear First check the boxes next to the frequencies to be included in the selection Then choose either a specific range of dates from 1980 to 2000 fo
43. then open it from there Refer to www sdmx org for more information Note for developers There is a prototype web service which uses the standard SDMX REST API for que ries The technical specification of the RESTful query syntax can be found in the SDMX 2 1 Technical Spec ification Section 7 Web Services Guidelines You may copy and paste the query in from the SDMX Data URL into your own software program In some cases pre authorisation for use of the web service may be required so please contact us see page 37 if you have any questions Export Excel Text file CSV PC Axis SDMX Related Files External Tools Generate SDMX XML file to export Generic Data O Compact Data Export to SDMX file _ Export to DSD SDMX Query lt message QueryMessage xmlns http www SDMX org resources SDMXML schemas v2_0 query xmlns message http www SDMX org resources SDMXML schemas v2_ 0 message xsi schemaLocation http www SDMX org resources SDMXAML schemas v2_0 query nttp www sdmx org docs 2_0 SDMXQuery xsd ittp www SDMX org resources SDMXML schemas v2_0 message SOMA DATA URL ittp vs dotstattest restsdmx sdmx ashx GetData PAC QNA AUS AUI BEL CAN CHL CZE DNK EST FIN FRA DEU GRCHATINATSTATRTATSRATTR STONE ON ET INAMPEN ANT DEN 1 NOR POT PRT Ses SNe F SP4 Sir eCHE STIIRSGRRsITSh SE SDMX Data Structure Definition URL m e m r mi l m J at j Figure 20 Exporting to SDMX May 2013 25 OECD Stat
44. y 2013 9 OECD Stat Web Browser User Guide 2013 Locating a Dataset or a Query in the Theme List Search across themes and datasets by entering a keyword in the text box at the top of the Data by Theme panel All dataset titles that contain the keyword are highlighted in yellow To start over simply click Reset to the right of the text entry box and enter a new keyword in the text entry box ORGANISATION F an FOR ECONOMIC CO OPERATION j i AND DEVELOPMENT Data by theme Popular queries Welcome productivity All Themes E General Statistics Factbook Country Statistical Profiles 2013 edition OECD Stat includes data Ways to access the data HIDE NAVIGATION By keyword using Government Debt By selecting data i e By accessing your Levels and GDP per capita Labour Productivity Total Economy Capital Services by Type of Asset Mutti factor Productivity Productivity by Industry Figure 5 Finding a theme or dataset by keyword This method also allows a quick lookup for well known OECD data sets by their acronym e g MEI STAN ITCS etc May 2013 10 OECD Stat Web Browser User Guide 2013 Using the Table Features When you first open a dataset you see the default table view Use the options at the top of the table to modify the default data selection ORGANISATION FOR ECONOMIC CO OPERATION al AND DEVELOPMENT Key Short Term Economic Indicators Harmonised Unemplo
45. yme Data by theme Popular queries ga Customise Export Draw chart My Queries 7 Find in Themes Reset EY Ea Exp amp My All Themes Subject Harmonised unemployment rate all persons 5 4 Measure i Level ratio or USD millions General Statistics Country statistical profiles Factbook Country Statistical Profiles 2013 edition amp Key Short Term Economic Indicators Country HIDE NAVIGATION Australia Canada Chile Czech Republic Denmark Estonia Finland France Germany Greece Hungary Iceland Figure 6 Default dataset view and current selection values Click on e Customise to select variables for each dimension and change the table layout and display options e Export to download and save your selection as a MS Excel CSV PC Axis or SDMX file e Draw Chart to dynamically graph the displayed data e My Queries to save the current table view as a personal query for further work You need to log in first to take full advantage of all query features May 2013 ti OECD Stat Web Browser User Guide 2013 Selecting Dimensions and their Variables Select variables in each dimension by clicking on the Customise option at the top of the table and then the Selection option from the drop down menu Key Short Term Economic Indicators EX Customise 4 E pert 7 Draw chart amp My queries 7 Selection l Subject 48 48 Select varia
Download Pdf Manuals
Related Search