OECD.Stat Web Browser User Guide
Contents
1. Figure 16 Before using the Hide Empty Rows and Columns options Login Version fran aise Contact Us User Guide Home ORGANISATION FOR ECONOMIC td t AND DEVELOPMENT E Dataset Reference Series i Current data selection Country 39 44 Subject 52 59 Time amp Frequency 10 D amp RE hh amp data extracted on 2008 09 16 17 27 from OECD Stat y Frequency Annual EE 2001 2002 2003 2004 2005 20 AF A AT AF AF 19 153 00 19 413 00 19 653 00 19 898 00 20 133 00 20 400 00 6 18 4 90 4 75 4 90 5 48 6 31 5 62 5 84 a 5 59 100 00 103 16 100 17 3 05 111 70 J ji J L 14 552 93 T 369 63 15 617 18 f 39 158 11 1 84 1 84 54 1 36 1 31 14 377 00 15 307 20 23 143 40 28 438 20 103 41 Figure 17 Dataset view with empty rows and columns hidden 09 2008 21 39 OECD Stat Web Browser User Guide Exporting to Excel Click on the Export to Excel button ER to export your data selection to a MS Excel file You will be 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 it2. OECD Stat sec OECD Stat Web Browser User Guide Release 1 1a September 2008 OECD Stat Web Browser User Guide Table of Contents ACROGUCTION i et an oo 4 OECD Stat CONCEDES wassetivndecias annee nsc icone tenennten sentent tenu e peaa daa 4 Data OFGdNISAUON sicchsasseadrtaseivetaacdstadrecaarrtres mms A EEE E AS 4 Reference SENES inti coh sasverattieotiiver asunder ena teertaei meted eee armenian OS 5 D Es RO ctcrgnsse A E adie tla een an oes aces one E ard ea NG catia See ana ede 5 The OECD Stat Web BrowSelr ccscsccccuercccnsnecccueecarereacusnpeceuvecdeurinenensevensueesrivessensns 5 User Guide nation 6 Getting Started Page sisi sise n es ste seins eur acs denses shuseaadscuessedenconeds 6 LANGUAGE SeleCtiON semences conne inondation une 7 Locating Data through the OECD Stat Search cccccssssseeeeeeeecesesesennnseeeeeeeseeenenenaas 8 Locating Data by Browsing Themes sssssssss2us22222222222222222222200u2uu2uunnunnunnnnnnnnnnnn 9 Locating a dataset or a query in the theme list cccsssseeeeeeeeccesssesnnneeeeeeeeeeesenes 10 Using the Table Features ransis renino na a a aa aa aaa aa 11 Selecting Dimensions and their Variables RS 12 Changing Ene Time DIMENSION ceirar Ra nee a N amas 14 Rotating Dimensions by Adjusting the Dataset View ssseserrsrerrsrsrerrsrrrrsrerrrrerene 17 FOlMa ECO OLIOl Sk priri e aa a r a a a E AA N a 19 EX DOING TO EX Celis td nn ie nine im dard 22 E
3. wo oO e 5 gt 5 F amp EM LE LE ELLE LEE oO T T T T T T T T T T T T T T T T T T T T T T T T T 1980 1982 1984 1986 1988 1990 1992 1994 1996 1998 2000 2002 2004 2006 1981 1983 1985 1987 1989 1991 1993 1995 1997 1999 2001 2003 2005 2007 ff Denmark Finland Frane M Germany Greece Figure 23 Charting Line chart 09 2008 26 39 OECD Stat Web Browser 09 2008 Na oe FER D C are Jatt me Annual gt Industrial Production RE SE lt 2000 100 sa p i i 160 1980 1982 1984 1986 1988 1990 1992 1994 1996 1998 2000 2002 2004 2006 1981 1983 1985 1987 1989 1991 1993 1995 1997 1999 2001 2003 2005 2007 Date BH Canada M Czech Republic Denmark Figure 24 Charting Bar chart Download This Ven MX a iek E Annual gt Consumer Price Index FR PE 2000 100 2007 112 52 E Canada p France Germany E Italy i Japan E United Kingdom United States Figure 25 Charting Pie chart User Guide 271 39 OECD Stat Web Browser User Guide Viewing Metadata Metadata can be viewed at all levels from the dataset level abstract down through to cell level footnotes The presence of metadata is flagged by a small red i Login Version fran aise Contact Us User Guide Home E OECD Stat Dataset Reference Series i Metadata Current data selection Country 39 41 Subject 52 59 Time amp Frequency 17 Reference Series FAR ix Ey nh ES Fe Hoa 0 K
4. 39 OECD Stat Web Browser User Guide Other selections Country 39 41 Subject 52 59 ease seen Tine Paros sonion Expand All Collapse All Select all Clear all B Time 12009 a 12008 v Q1 2008 M Feb 2008 M Jan 2008 3 V 2007 3 F 04 2007 Dec 2007 12007 2007 Nov 2007 Oct 2007 3 M03 2007 Sep 2007 Aug 2007 Jul 2007 M Q2 2007 vl Q1 2007 Figure 11 Time Period Selection Note It is advisable to select a general range of dates using the Date Range Selection first and then include or exclude individual time periods using the Time Period Selection screen The inverse making changes to a Time Period Selection using the Date Range Selection screen may result in some of the individual time periods selected being lost as the Date Range Selection screen is only able to manage continuous non broken series of dates 09 2008 16 39 OECD Stat Web Browser User Guide Rotating Dimensions by Adjusting the Dataset View 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 either click once on the name of the dimension within the table itself or click the Pivot Dimensions button above the table A dialog box will pop up that allows you to visually drag and drop a dimension to the desired location Pivot Dimensions Please move the dimensions to the
5. buttons at the top of the window Welcome Karl Right Click to print table using the web Population statistics 2 browser print angeo options Metadata J Concepts amp Classifications J Key statistical concept Time amp Frequency 17 ALFS Population Census based Population include all nationals present in temporarily absent from the country and alid permanently settled in the country Includes f following categories national armed ford stationed abroad merchant seamen at sea Country diplomatic personnel located abroad civili aliens resident in the country displacd Frequency Anua v persons resident in the country Excludes t following categories foreign armed force 2006 2 stationed in the country foreign diploma av personnel located in the country civilian alisd temporarily in the country Data ff population may be compiled following t Click to print out concepts Present in area populatio facto i e persons actually present in the displayed metadata on the date of the census p population or de jure i e Persons regularly zi domiciled in the country on the date of the b 100 i census Except where otherwise indicated data refer to the actual territory of the country considered pnal units per US Dollari 5 09 5 99 A AQ wwe 161 50 he 41 451 29 P Preview 1 33 Refresh 35 617 70 illions US Dollars sai Append to existing PDF B
6. click once again on the Merge Query button Click View in the Merged Queries panel to see the modified query Remove a Selection To remove one of the selections in a Merged Query click the name of the dataset in the Merged Queries panel and then click Remove Click View in the Merged Queries panel to see the modified query Saving a Multi Dataset Query You can save your Multi Dataset Query by clicking Save in the Merged Queries panel typing a name and then clicking Save once again 09 2008 32 39 OECD Stat Web Browser User Guide Viewing Frequently Requested and Saved Queries You have access to a set of public pre defined queries through the Browse Queries panel There you will also find your saved queries Welcome Version GON 3 OEC D St t fran aise Contact Us User Guide Home MEN y cl Beta version E x Open a public pre Merged Queries ET current Query defined query from Browse Queries 2 ase here Frequently Requested Tables Cirrent data selection Cour e amp Frequency 7 CT Reference Series ly at Fe Eg Gi Ea FE i i sini ib aaa data extracted on 2008 09 30 16 17 from OECD Stat Subject Gross Domestic Product Annual in millions of Curent Prices National Cummency My Query Manager Frequency Annual 2001 2002 A T AT Browse Themes Country Find in Themes Reset Australis QI 875 841 35 897 642 S87 454 Austria Click here to access bz 123 302 334 232 781 783 244 45
7. from there cet ER a Ee This feature generates a Microsoft spreadsheet version XP 2002 or later for small sized selections lt 100 000 data points The current table layout is preserved but if your table includes drop down lists then only the data related to the currently displayed items will be exported To export the data related to all tems in the drop down lists you can drag and drop the corresponding dimensions to the vertical or horizontal axis in order to include all ka items i in the table or export the data in a text format using the Text Format feature The text format does notos l Data feds Saved J include extra columns for flags as Excel footnotes lf you have an Excel version earlier than XPY2002 then you could still use our Excel extraction by doing the following Download and install OpenOffice This product is free Do not open your extracted excel file immediately with Excel but save i to the disk The default file extension xls should be changed to m Use OpenOffice Cale to open the saved Excel file by specifying the file type Microsoft Excel 2003 XML xml Save the file to a new file with type Microsoft Excel 5 0 xls Microsoft Excel 95 xls or Microsoft Excel 97 2000 P xls which should then be compatible with your own version of Microsoft Excel Figure 18 Using the Export to Excel option to save data in Excel format Exporting to a CSV file Larger tables can be save
8. location you want Filter dimension s Visual identification when a dimension is selected to be moved A place holder outline will assist in dropping the dimension Figure 12 Moving a dimension to rotate the data view If a dimension for which more than one item has been selected is placed into the filter area at the top of the page a drop down list will become available To change the filter currently applied to the data simply select the appropriate value in the drop down list If the dimension in question does not have a drop down list then only one item has been selected To include other items click on the dimension name in the Current Data Selection box on the left and follow the instructions provided above to select more items 09 2008 17 39 OECD Stat Web Browser User Guide Login Version fran aise Contact Us User Guide Home ORGANISATION 1 FOR ECONOMIC OEC D tat CO OPERATION AND DEVELOPMENT E Dataset Reference Series i Current data selection Country 39 41 Subject 52 59 Time amp Frequency 17 data extracted on 2008 09 16 16 58 from OECD Stat le rose Australia Al Austria Belgium Canada Czech Republic Denmark GE tte Norway Poland Portugal M Slovak Republic W Spain i Sweden Ma Switzerland Wi Turkey United Kingdom i United Stat CRT Sere i New Zealand Figure 13 Changing the view using Country
9. or download related ready made files e click on the Chart button ai to dynamically graph the displayed data e click the Merge Queries button E8 to add your current table view as a query for further work You will need to login first to take full advantage of all query features 09 2008 11 39 OECD Stat Web Browser User Guide Selecting Dimensions and their Variables The items selected for each dimension often referred to as dimension members can be modified by clicking on the button to Select Dimensions at the top of a table Other selections Country 39 41 Time amp Frequency 17 Expand Branch Collapse Branch Select Branch Clear Branch Help E 9 i Demographic and Population Statistics M i Population Statistics Population mid year estimates Total Annual 000 B i Financial Statistics 3 i Interest rates i Short term interest rates Monthly Per cent per annum i Long term interest rates Monthly Per cent per annum i Share Prices i Share Prices Monthly Index base 2000 100 i Balance of Payments Current Accounts Balance Monthly in millions US Dollars sa M i Exchange Rates Currency exchange rates Monthly National units per US Dollar Official Reserves M i Reserve Assets Monthly SDR millions B i Industry and Service Statistics E i Industry Figure 7 Using the Dimension Selector To select or deselect an item click the check box to the left of the item In hierarchical dimensio
10. the objective is to 5 Net interest and non interest incom include all institutions which conduct ordinary Cental Government Debt ae ne ee banking business namely institutions which gel is primarily take deposits from the public and S Statistical population Financial indicators MEI we Ifa eet oo ke Figure 4 Browsing through themes to view data 09 2008 9 39 OECD Stat Web Browser User Guide Locating a dataset or a query in the theme list At the top of the Browse Themes panel click the text box and enter a key term to search for within the theme and data set list Click the gt gt sign or press Enter to execute the search All found entries will be highlighted in yellow To start over simply click Reset to the right of the text box and click the text box again in order to enter a new key term Login Version fran aise Contact Us Pon E A C User Guide Home CO OPERATION OECD Stat Beta version a m mN Search LT Merged Queries 2 4 Welcome Browse Queries KE Browse Themes eee migration fd Reset A Enter a key term and search among the themes and data sets in the u Demography and Population theme panel Results will o MER Statistics be highlighted in the L International Migration Database pa n el i Population Statistics Sy keyword Using search By theme in the left hand menu By accessing your saved queries under browse queries By country via the selection
11. to Text file button The file will be created and an e mail sent to you informing you how to retrieve it The file will not be included as an attachment to the e mail as it could potentially be very large Instead the e mail will contain a link allowing you to download the file Downloading related files and large data selections Any number of documents related to a given dataset may be available for download through the data browser To view the list of files click on the dataset name either in the Browse Themes list on the left or in the list of recently updated datasets visible in the centre of the Getting Started page 09 2008 23 39 OECD Stat Web Browser User Guide Login Version fran aise Contact Us User Guide Home ORGANISATION FOR ECONOMIC tat AND DEVELOPMENT L i Dataset ALFS Summary tables i Current data selection Country 34 32 Subject 33 3 Time amp Frequency 8 GE w af m BO B data extracted on 2008 09 16 17 34 Related Files fat Country Australia Frequency Annual AY aF av Time 4 19 153 0 19 413 019 653 0119 898 0 20 400 0 20 701 0121 017 0 1000 1014 1026 1039 1051 1065 108 1 1097 _ 98480 9783 0 9 898 0 10 020 0 10 134 0 10 285 0 10 411 0 10 588 0 9505 0 9631 0 9755 0 9878 0 9 999 0 10 135 0 10 290 0 10 452 0 tz 808 0 12 991 013 175 012 266 0 13 544 0113 743 013 984 014 184 0 s e s 670 6721 ova 674 ors 675 63
12. 3 088 a your Saved Queries eus and view Recent rue Queries Denmark TT S72 737 1 488 180 Time Finland i 139 268 42974 152 345 France i 1 497 185 1584814 1 880 183 Germany i i 2113 180 2 143 180 2 163 300 2 210 900 2 243 200 Greece i i 146 200 157 586 171 258 165 224549541 128 609 Hungary i i 15 270 128 17 180 804 15 940 742 20 718 120 22 042 476 Iceland i i Fr1 33 57 7816 B16 557 187086 841 463 400857 926 666 390801 1 026 250 619394 Ireland a i 116 939 0905823 4 586103 139 413 458334 148 501 709197 181 497 778081 Industry and Services 1 Italy i i 1 248 648 102885 t95 225 7182741 335 353 7218041 391 530 161606 1 428 375 429053 lt gt we ml Oe ee ML ee OPE LL Figure 32 Using the Browse Queries panel to select a frequently requested table Clicking on My Query Manager in the left panel displays the list of all queries which you have personally saved together with a list of recent queries This feature requires the user to login 09 2008 33 39 OECD Stat Web Browser User Guide My Query Manager A Your Queries Your Queries Order Name Date gt MDO STAN and R amp D 09 30 2008 03 40 35 PM p Population and Labour Force for GT countries 030 2008 01 07 56 PM p STAN R and D Expenditure in Industry US CAN FRA 09 30 2008 03 36 30 PM STAN automobile production in US CAN FRA 09 30 2008 02 41 22 PM gt Total population from Demography theme 0922 2008 02 43 18 PM p Total po
13. 840 64810 65710 6668 0 6 755 0 68550 6 963 0 70720 64240 6510 0 6604 0 6698 0 6 788 0 6888 0 7 001 0 7 113 0 iniii st Conan dns n i 96414 9 801 8 9 957 110 142 2 10 296 0 10 574 9 10 765 0 11 000 4 Technolo sa 505 507 510 511 518 520 523 a 9590 5 9752 0 9 906 8 10 092 2 10 244 0 10 524 010 714 010 948 2 100 0 1017 103 3 105 2 1068 1097 1117 1142 4216 8 4317 0 4394 5 4512 8 4572 8 4730 5 4825 7 4938 7 5373 6 5435 0 5512 3 5579 4 5671 2 57925 5888 3 6009 4 9039 5 9 140 7 9321 0 9 531 3 9729 110 028 110 240 910 522 1 4000 104 1 1110 1133 1164 International Trade and Balance of Payments Figure 20 Finding files related to a dataset The Related Files button Ea at the top of the table will be displayed Click on it to view a list of files related to the dataset Exports EE This feature allows downloading ready made files of any size possibly including 1 000 000 data points Download Files Population and Labour Force Please click on the name of the file to download it Name File type File name File size KB Date created d
14. E e oE EO es oo a paneer pec Demography and Population E Development O 591 963 592093 598 578 u Economic Projections E E ener tt nce ee ITS denial Pro Torey Educati 1 Trainin Metadata 108 1337 109 9291 Reference Series EEE a 4 404864133580 296 0732319404 62 a Globalisation 3 Database Specific BE Health J Purpose 5 8188107108 51 587 0494108495 58 The Reference Series dataset comprises the data series that are the most frequently used as denominators for the calculation of ratios and indicators An initial list of Reference Series has been obtained through consultation with analysts throughout the OECD The list contains the following statistics main Information and Communication Technology International Trade and Balance of 588253422828 729 02282109082 7 a 468395 A FOOT FE 72163 3 Payments aggregates of national accounts with history RE PP dec ot RE LL Ne eanvaeeresuesG and forecasts labour market and population E sbour data exchange rates purchasing power PE ree etre ctr ree E T parities and price indices 614 848 000 514 723 700 N97 319535384 91 7667037 4437 9 E Productivity ne Public Sector Taxation and Market ea a Regulation Regional Statistics a ais 5 Science Technology and Patents E 5 Social and Welfare Statistics mary aes Others DOCDE All ighis esemed Terre amp Conditions Privacy Po
15. XDOrING TO a COV TGs Run cat nia dti sta dant alba an oran dr entier da rats 22 Downloading related files and large data selections ccc cece cece ee eee eee eeeesenenneeenees 23 EXDOLHIHO TO PE SAXIS TO DIE aies doses drama os 25 CHANDA eas wrath nai te bi int oi ones done 26 VieWing Metadatdissss om dnointooon 28 Other Related Mela Aa ER Reno tonte en ren 28 BE LOS TL 28 Working With QUCHIES su antaanniotnameuamummrn tarots 29 SM A QUELY e aE rabt abrite a de de ne Tele Lt on el 29 Merde QUerIes orinar a Aaaa 30 Creating amp Merge QUEN rarena PR traite a ean a 30 VIEWING the OUG Verinen a aa A E E a EE Sea 31 CHANGING N QUC V rere e n dec a A a AR a 32 Savno a Mull Dataset OQUE Vrne mere ao SAE 32 Viewing Frequently Requested and Saved Queries snnnnnnnnnnnnenennmnnnnnuss 33 Viewing the Country Statistical Profiles sssssssssnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn 34 Printing Data from the BrowsSer ssssssssnnnnunnnnnnnnnnnnunnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn 37 Providing F edDatK sisi na ist aAa 38 09 2008 3 39 OECD Stat Web Browser User Guide Introduction OECD Stat provides a single online platform where users can discover and access statistical databases from the OECD You will be able to build tables and extract data from across databases as well as work within individual databases Use Browse Themes or Search to find the statistical information you need Each database includes deta
16. ase click k For issues related to the OECD Stat Data Content please click here Figure 39 Creating an E mail to the OECD Stat Project Team 09 2008 38 39 OECD Stat Web Browser Table Figure 1 Figure 2 Figure 3 Figure 4 Figure 5 Figure 6 Figure 7 Figure 8 Figure 9 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 Figure 35 Figure 36 Figure 37 Figure 38 Figure 39 09 2008 User Guide of Figures used in this Guide OECD Stat Browser Getting Started page US 6 Changing the language of the browser 7 Results from the search ranked in order of relevance ccc ccc cceeceeeeeeeeeeeeeeeeeees 8 Browsing through themes to view data 9 Find a THEME OF data Seins armani tintin ni 10 Default dataset view and Current Selection values 11 Using the Dimension Selector asistencii Mises a oreo soins 12 Searching in the dimension selector Rs 13 Results of a Search in the dimension selector eee eeeeeeeeseeeeeeeees 14 Date Range Selection iisseeesisseeeeees 15 Time Period Selection iisssi esa siainne ent mdieiteai ha metiers titi ah 16 Moving a dimension to rotate the data view 17 Changing the view usin
17. b Browser 37 Creating an E mail to the OECD Stat Project Team 38 39 39 Tools to access Merged Queries Saved Dimension Selection Tools Selecting Variables Moving Dimensions Data Viewing Options Queries and Frequently Requested Tables Data Export Tools MS Excel CSV Text format Full Text Search tool Search themes datasets and Dynamic Data Graphics Tool data queries exactly as they appear in the theme panel Query Management Tools Merge Query Save Query Help User Guide PEPON sar Version fran aise Contact Us User Guide Home 2 OECD Stat Merg ed Queries ee Dataset Reference Seres i z Qurrent data selection Qountry 96 44 Subject 99 59 Time A Frequency 17 Browse Queries 2 l CE Frequently Requested Tables iy la x i ni Te 9 Reference Series ata extrac on 2008 10 13 15 38 from D Stat C Refe S d ted on 2008 10 13 15 38 from OECD S O Gross Domestic Product A008 2007 My Query Manager K Time 04 2006 01 2007 22 2007 03 2007 Ay Ay ay ay Browse Themes 3 Find in Themes Reset 0 4218 0 5392 0 801 0 7251 General Statistics 1 684333 1 658 1 783 1 894687 Key Economic Indicators KEI Ie E Reference Series i 104 7986 111 7742 112 2458 106 2863 Country statistical profiles 2008 Country statistical profiles 2007 47 854 43 50 323 75 52 871 78 Dai E Agriculture and Fisheries
18. d metadata window in the right hand area of the screen The window can be moved around and closed by clicking on the x in the top right corner of the window Other Related Metadata If there are other metadata available in the data sets which are closely related to the metadata displayed on screen a set of links to these other metadata will appear in the metadata window below the metadata text Flags Certain pieces of metadata which are recurrent within the dataset are treated differently by the system and referred to as flags These flags appear as letters in parentheses in the cell alongside the piece of data to which they correspond Below any data table containing flags will appear a legend explaining the meaning of each letter used as a flag in the table 09 2008 28 39 OECD Stat Web Browser User Guide 1 038 652 00 830 261 28 125 10 735 330 28 782 135 14 35 452 98 37 709 62 112 63 Legend ec E Estimated value Figure 27 Viewing the Data Flag Legend Working with Queries Saving a Query When working with queries most features require you to log in e g the Save Query button is only displayed when you logged in via the Login link at the top right of the page Once logged in your name will be displayed at the top right of the page Your data selection or query can be saved at any time by clicking the Save Query button AA above the table typing the name of the query and then clicking the Sa
19. d mm yyyy Annual Labour Force Statistics gi poplab zip 1365 20 12 2007 1960 2006 Population and labour force s fay CSV 09 2008 24 39 OECD Stat Web Browser User Guide Figure 21 Selecting a file to download The list of files may contain documents in any format or large prepared selections of the data in text format Click on the name of a file to begin downloading Exporting to PC Axis Table Click on the Export to PC Axis button to export your data selection to a PC Axis table file You will be prompted to either save the table 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 Exports Se eee Use this method to generate a PC Axis table For more information on the PC Axis product please visit the PC 4xis home page at http w ww pc axis 2cb 2e The PC Axis browser can be freely downloaded from here PC Axis 2007 version without Sql Figure 22 Exporting to PC Axis table 09 2008 25 39 OECD Stat Web Browser User Guide Charting Data The OECD Stat web browser includes a dynamic charting feature ath enabling the display and animation of line charts bar charts and pie charts based on the current data selection The navigation options of the chart dialog box include a button to animate the displayed chart advancing it in even intervals W o H H o
20. d to a CSV file to do so simply click on the Other Export button Eh above the table 09 2008 22 39 OECD Stat Web Browser User Guide Exports Excel Text Format Ready made Files PC Axis This feature generates a text file for medium sized selections lt 1 000 data points The current table layout is not preserved all dimensions are moved to the vertical axis Please provide your email below Your request is queued and when the extraction has completed then a link to download the text file will be sent to you normally within the next two hours Click Export to text file to start the data extraction Dimension label format Column separator D Code only Comma f Code separator English label separator French label D Pipe J D Code separator English label D Tab D Code separator French label English label French label code English label Code French label You may edit your email address here john dose abc com Your email address will remain confidential Figure 19 Using the Other Export option to save data as a CSV file You will be prompted to select a dimension label format and a column separator The dimension label format determines what information will be included in your file for each country variable etc The column separator determines which character will be used to separate columns in the file Enter your e mail address in the box in the middle of the dialog box and click the Export
21. data extracted on 2008 09 16 17 20 from GECD Stat 5 Database Specific ES Purpose Annua IR pein a cag rnp data series that are the most frequently used as denominators for the calculation of ratios and indicators An initial list of Reference p Series has been obtained through consultation Subject with analysts throughout the OECD The list Time Population Statisticsi Population mid year estimates Total Annual i 20 701 00 contains the following statistics main aggregates of national accounts with history Short term interest rates Monthly Per cent per anne and forecasts labour market and population Long term interest rates Monthly Per cent per annumi li 5 59 data exchange rates purchasing power F 3 parities and price indices Shane Pricesi qre Prices Monthly Index base 2000 10013 161 50 5 99 scounts Balance Monthly in millions US 40 144 84 units per US 1 33 Click on metadata a indicator to open pees window displaying International Trade in m eta d ata urrent Prices _ Goods i z 35 617 70 DOO 100 105 55 10 276 31 Total Imports of Goods Monthly in millions Cument Prices _ RENE i US Dollars sai Total Exports less Imports of Goods Monthly in millions Curent Prices US Dollars sai Labour Force Population 15 84 Annual 000 13 984 00 14 184 00 11 050 45 774 14 Figure 26 Footnotes and Dataset level metadata Clicking on the red i will bring up the relate
22. drop down list 09 2008 18 39 OECD Stat Web Browser User Guide Formatting Options A set of options is available to allow you to format the view of the displayed table e g you can select the number of digits after the decimal point to be displayed or select a scaling which allows you to display the figures in unit value hundreds thousands hundredths thousandths etc Options Data bars Scaling C Show data bars Multiply the values in the table by a xl Rows and Columns with no Data Hierarchies Hide rows with no Hide columns with no data data E Hide row hierarchies Hide column hierarchies E Fully Fil Page Dimension Member Labels Aggregation Columns oO Use codes Use full descriptions Decimals Number of decimal places 2 ml Other Options Show empty axes Make data columns sortable Figure 14 Formatting Options Panel Showing Codes Instead of Names All datasets dimensions and dimension members have short codes as well as names If it is useful the codes can be displayed instead of names by ticking the option Use Codes instead of full descriptions 09 2008 19 39 OECD Stat Web Browser User Guide Login Version fran aise Contact Us User Guide Home QOROGANIS ATION FOR ECONOMIC tat AND DEVELOPMENT i E Dataset Reference Series i Current data selection Country 39 41 Subject 52 59 Time amp Frequency 17 GE RE th B data extracted on 2008 09 16 17 20 f
23. e Period Selection method Date Range Selection All frequencies available for the selected dataset are shown on the screen If the data is only annual for example the controls for selecting quarters semesters and months will not appear First tick the boxes next to the frequencies to be included in the selection Then choose either a specific range of dates from 1980 to 2000 for 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 Select 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 ticking the box next to Latest Available Data 09 2008 14 39 OECD Stat Web Browser User Guide Other selections Country 39 41 Subject 52 59 Select date range Select latest data To llatest available data Select last Annual M 4 v years Quarterly M quarters Monthly M v months Figure 10 Date Range Selection Time Period Selection It is also possible to select individual years quarters months etc by ticking the box next to each item This is necessary if the selection of dates you wish to include is not a continuous series but instead contains breaks or time periods outside the main date range This works in a manner identical to the general dimension selector described above 09 2008 15
24. es panel in the left hand area of the screen and click View to see the combined data table 09 2008 31 39 OECD Stat Web Browser User Guide Welcome Karl DOLL Version fran aise Contact Us User Guide OECD Stat a z Merged Queries 2 X E STAN Database for Structural Analysis _ Research and Development Expenditure in Industry data extracted on 2008 03 20 22 04 from OECD Stat 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 ime Edit Remove Save jew AT AT AT AY AY AY AY AT AT AT AY variable industry country Dataset STAN Database for Structural Analysis gt PROD c34 Canadai Browse Queries Sarpe e i 43012 41 043 45 421 58 868 67356 75089 75 910 81 340 88 212 112 019 115 061 10 gross output vehicles Browse Themes ae trailers United pric i and Statesi semi trailers Variable Industry Country Dataset Research and Development Expenditure in Industryi Business C34 Cansdsi enterprise Motor expenditures vehicles in Research trailers United amp and Statesi Development semi US dollar trailers PPP i Industry and Services Industry and Service Statistics MEI Figure 31 Viewing a Merge Query Changing the Query Modify a selection To modify any of the selections of data in the view click the name of the dataset in the Merged Queries panel and then click Edit The selection will appear on screen in the same format as a single dataset query Make your changes and
25. g Country drop down list 18 Forinattind ObtIONS Palaiseau ain trance ee 19 Table showing codes instead of names 20 Before using the Hide Empty Rows and Columns options 21 Dataset view with empty rows and columns hidden 21 Using the Export to Excel option to save data in Excel format 22 Using the Other Export option to save data as a CSV file 23 Finding files related to a dataset 24 Selecting a file to download RS 25 EXDOFrting to PE AXIS taple sen annee ad ton rie tan s nu tata ia mera 25 Chain LME CHASSER sew cece tt ee art wees 26 Charing Bac ait SR SR Ni a tr ail 27 Charting PIS CAE aa ne dagen meta A en hese ey 27 Footnotes and Dataset level Metadata 4 28 Viewing the Data Flag Legend 29 Savile Que ny re a aa Eu ion eue Aie 29 Saving a query with optional renaming cess eeeeeeeeeeeeeeeeeeeeeeas 30 Adding a selection of data to a Multi Dataset Query ccc cccceeee eee ee ee eeees 31 Viewing a Merge Query inn dre anoi ii anneuivedesveateiharenmndenais locales tit 32 Using the Browse Queries panel to select a frequently requested table 33 Viewing Saved and recent queries issues 34 Sharing Saved QUEE Si 6e inner cac A trash ho anne 34 Viewing a Country Statistical Profile 35 Viewing the comparative country chart 35 Viewing the comparative country table 36 Printing data and other information from the We
26. h to expand or collapse the respective panel Information and Communication Click on question mark for Technology contextual help cs pil bf key indicators in Country International Trade and Balance of dynamic graphic for your data CSV print your Payments selection query or save it The previous version of the browser is available here for later use more help National Accounts Figure 1 OECD Stat Browser Getting Started page 09 2008 6 39 OECD Stat Web Browser User Guide Language Selection The interface and data can be viewed in English or French The language can be changed by clicking on the language option located at the top of the screen ORGANIS ATION DE ogir glish Version Contactez nous SOOPERATION E E D t t Guide Utilisateur Home DE DEVEL PEM S E E E E CONE Lo QUES Version b ta Requ tes Fusionn es ES 4 Bienvenue Rechercher une Requ te ia Parcourir les themes eS Trouver dans les Them Beg Annuler Quatre mani res d acc der aux donn es Figure 2 Changing the language of the browser 09 2008 7 39 OECD Stat Web Browser User Guide Locating Data through the OECD Stat Search Data can be located by entering keywords in the OECD Stat Search box at the top right of the page This will return a list of links giving the name of each dataset in which the keywords were found and providing further details as to where the keywords are present within each dataset The mos
27. iled metadata to help you understand the numbers OECD Stat offers a number of opportunities for improving data management in particular in the following areas General data identification taxonomy and classification Data accessibility and security Data relevance by the provision of related metadata Fostering coherency of statistical data and metadata Eliminating duplication of effort by maintaining a single copy of key series It also provides a common platform for future development and implementation of standards for statistical data and metadata across the OECD OECD Stat Concepts OECD Stat features the following main concepts e Catalogues of information on themes datasets dimensions dimension members and reference series e Storage of metadata at all levels from dataset through to cell level e Storage of numeric data figures as well as cell level flags e A data warehouse searching mechanism Data Organisation Datasets Within OECD Stat statistical data are organised in the form of datasets A dataset is a collection of numerical values and their associated textual information with all values sharing a common set of dimensions Each dataset is attached to a specific statistical activity or sub activity Dimensions The dimensions of a dataset are the axes on which the data are described Country and year are two common examples of dimensions Dimensions can be presented as either a flat list or as a hierarchy Dimen
28. isplayed along the vertical axis underneath section headings indicating which dataset they come from Creating a Merge Query To create a Merge Query first create a customized view in one dataset Then click the Merge Query button E8 above the table to put this query into your data basket 09 2008 30 39 OECD Stat Web Browser User Guide Welcome Version CAL OECD St t fran aise Contact Us User Guide Home NO D MENT a Gi L Beta version Merged Queries re A Dataset STAN Database for Structural Analysis i Current data selection Country 3 24 Variable 1 30 Industry 1 106 Time olee RAB SH B Browse Queries B data extracted on 2008 09 30 13 22 from OECD Stat Browse Themes _ E l ee 115 067 000 000 108 757000 000 110 833 000 000 105 084 000 000 107 525 000 000 ca 85 769 000 000 91 224 000 000 93 613 000 000 89 097 000 000 92 619 000 000 91 147 466 209 000 000 420 242 000 000 463 549 000 000 487 026 000 000 487 807 000 000 494 570 Industry and Services Industry and Service Statistics ME Structural Analysis STAN Databases 7 STAN Bilateral Trade Database i ed 2006 a STAN Database for Structural Analysis TI STAN Database for Stuchesl Anslesia Figure 30 Adding a selection of data to a Multi Dataset Query Repeat this for each dataset that you wish to include in the multi dataset query Viewing the Query When all selections of data have been added expand the Merged Queri
29. k to view second column provide links to the sources of the data where more up to date data and longer time series can be found data extracted on 2008 09 16 17 59 from OECD Stat Page 1 m2 compa rative Canada graphs and Year AT AT 20 689 035 31 878 077 31 989 454 22 299 496 2262349 288121 BS 0 9378968 0 9673732 098931759 0 96920066 1 00309305 0 57944724 EH 1 49 1 53 1 53 1 53 61 10555447 4 147 77823926 Macroeconomic trends Economic growth Evolution of GOP Real GDP growth Avarage annual growth in percentage 1992 2005 H HHNH LULLELLEEETEEEEEEEEERETEEELEEEEEEEE Lif IPM ILE ELEM SERLS SIE GEOG 3 x E g ar F e SE eo 30 2109 31 8343 214 428 Figure 36 Viewing the comparative country chart 09 2008 35 39 OECD Stat Web Browser User Guide 1990 1991 0 3 3 3 i 2 7 2 2 0 3 0 9 2 9 2 2 24 0 6 1 5 1 6 3 8 45 1 3 5 4 1 7 8 7 42 3 7 0 3 0 1 5 3 2 9 NNA NN ee PS D NN Ready 36 2391 ME 31 8343 43 4471 2222712 2402457 273 4234 214 436 or lt lt ee Figure 37 Viewing the comparative country table 09 2008 36 39 OECD Stat Web Browser User Guide Printing Data from the Browser Without exporting data as an MS Excel spreadsheet the OECD Stat Web Browser allows the printing of a table via the Print command of the contextual menu right click The metadata window features a dedicated print option via one of the
30. lable Search A text based search facility which searches through dataset names dimension names dimension member names and metadata can be used to quickly locate relevant datasets and view tables The OECD Stat Web Browser The OECD Stat Web Browser provides the online user environment to access OECD statistical information The browser has been designed to allow both experienced and new users to rapidly locate and retrieve statistical data and related metadata Main features include e Links to frequently requested tables access the latest versions of the most frequently requested OECD Reference Series data Exchange rates GDP figures etc e Table View view data flags and metadata from a table that includes a number of features for customising the layout of the data e Data Basket save data queries for later viewing and share them with others e Merge Queries combine queries to allow cross dataset comparisons along common dimension s e Metadata access access all metadata from dataset level down to series footnotes and data flags e Microdata viewer access transaction level microdata in addition to aggregate macrodata e Full Text Search rapidly locate series across data sets data dimensions and metadata e Dynamic graphics visualize data dynamically in a line chart bar chart or pie chart 09 2008 D 1 59 OECD Stat Web Browser User Guide User Guide The OECD Stat Web Browser has been de
31. licy Welkome Version fan aig Contact Us User Guide Home TT lt llapsible Movable M Collapsible Theme panel with drill down Collapsible Movable Metadata window list of themes and datasets Data View panel www SourceOECD org database OECDStat
32. lysis Administration of DEETYA Department of Employment Education Training and Youth Affairs olateterritory expenditure Adult migrant education programme tuition costs State Territory expenditure Training f Expenditure by nature and resource category i Found in dsteseinane Expenditure by nature and resource category Found in membemame pre primary education Primary education Lower secondary education Upper secondary education Post secondary non tertiary education Tertiary type B education All level of education not allocated by level Information and Communication Technology Found in dimensionname RME ae a ae Level of education Nature of expenditure Payments Expenditure by funding source and transaction type i Found in dsteseinams Expenditure by funding source and transaction type Found in membemame pre primary education Primary education Lower secondary education Upper secondary Figure 3 Results from the search ranked in order of relevance 09 2008 8 39 OECD Stat Web Browser User Guide Locating Data by Browsing Themes In the Browse Themes panel click a theme title click a sub theme title and so forth until you can select a dataset Datasets can be recognised by the table icon in front of their name A pre defined default view of the table will open Thi
33. nd E France Fi Germany E Greece Egh Hungary E Iceland Legh Ireland lgh Italy ak Jacan Subject Population Statistica Interest rates i Share Prices i Balance of Payments i Exchange Rates Official Reserves Industry Population mid year estimates _ Total Annual 000 z Short term interest rates Monthly Per cent per annum i i Long term interest rates Monthly Per cent per annum i z Share Prices Monthly Index base 2000 10014 Current Accounts Balance Monthly in millions US Dollars sai Cumency exchange rates Monthly National units per US i Dollari Reserwe Assets Monthly SDR millicnsi Industrial Production Index Monthly base 2000 100 UU 20 701 00 F FC di 161 50 40 144 84 21 017 00 Figure 6 Default dataset view and Current Selection values The Current Data Selection information shows the dimensions of the dataset with an indication in parentheses of the number of items or members selected in each dimension If you click a dimension title a list of the members you can chose from will be shown Once you have made your data selection you can e click on one of the several option buttons to customize the layout E eat and or display E of the current table e click the Export to Excel button ER to save your selection as an MS Excel file e click the Other Export button Eh to save your selection as a CSV file PC Axis table
34. ns a plus or minus will appear next to parent level items Clicking on this symbol will allow you to show or hide the child items At the top of the screen a series of options appear To apply your modified selection of items for the current dimension and see a table of data corresponding to this new selection click View Data Alternatively after changing the selection for one dimension you can click on another dimension to modify before viewing the new table of data For hierarchical dimensions clicking on Expand Branch or Collapse Branch will show or hide all the child level items of the dimension Note If all members of a hierarchical dimension are selected the resulting table could contain empty rows or columns corresponding to the higher levels see below Dimension Member Colour Coding The OECD Stat Web Browser uses colour coding to help you identify for which dimension members data exists This is especially important for sparse datasets where data can be found in only a small proportion of dimension combinations This function has been provided to save time by avoiding searching for non existent data 09 2008 12 39 OECD Stat Web Browser User Guide The colours for each dimension member indicate the following Based on the current selection for all other dimensions Dark Blue The item has data Blue The item has no data but some of its children have data Green Item has no data at any level Remember The col
35. of key indicators in Country statistical profiles 2008 New features and releases Information and Communication Use the chart icon W to display a dynamic graphic for your Technology data selection International Trade and Balance of The previous version of the browser is available here Payments Figure 5 Find a theme or data set This search routine will look for exact matches of the entered text string including spaces but irrelevant of miniscule or majuscule characters This method also allows a quick lookup for well known OECD data sets by their acronym e g MEI STAN ITCS etc 09 2008 10 39 OECD Stat Web Browser User Guide Using the Table Features When a dataset is first opened a table in a default view is presented This default data selection can be modified using the features found atop the table Login Version frangaise ContactUs User Guide Home lt lt OECD Stat me a Merged Queries Browse Queries aS Browse Themes 2 gt co General Statistics Dataset Reference Series i Current data selection Country F9 41 Subject 52 59 Time amp Frequency 17 ly ait Ex mi E i data extracted on 2008 09 16 16 12 from OECD Stat HE 2006 A F Key Economic Indicators KEI E Reference Series Time amp Country statistical profiles 2008 C Country statistical profiles 2008 FR Australia FER Austria lg Belgium pp Canada gp Czech Republic E Denmark gh Finla
36. our coding takes into account the current selection for all other members In other words the colours indicate the existence of data for the countries years etc currently selected Another option is to search in the dimension selector to display dimension members matching the search criteria Other selections Country 39 41 Time amp Frequency 17 gross domestic E Exact wording or phrase Expand Branch Collapse Branch Select Branch Clear Branch Help Subject E i Demographic and Population Statistics E i Population Statistics Population mid year estimates Total Annual 000 B i Financial Statistics E i Interest rates i Shortterm interest rates Monthly Per cent per annum i Long term interest rates Monthly Per cent per annum a i Share Prices i Share Prices Monthly Index base 2000 100 i Balance of Payments Current Accounts Balance Monthly in millions US Dollars sa a i Exchange Rates Currency exchange rates Monthly National units per US Dollar a Official Reserves i Reserve Assets Monthly SDR millions B J i Industry and Service Statistics E i Industry Figure 8 Searching in the dimension selector All matching dimension members will be displayed and automatically selected 09 2008 13 39 OECD Stat Web Browser User Guide Other selections Country 39 44 Subject 52 59 Time amp Frequency 17 Select All Clear All full text search is done on dimension member Subject For your sea
37. pulation all Ctrs from Education theme 09222008 12 22 04 PM Recent Queries P Fishing Fleet 1140 2005 11 20 00 AM P Gross Domestic Product 10 05 2005 05 27 50 PH p STAN Research and Development Expenditure in Industry 0211242007 03 48 00 PM Figure 33 Viewing saved and recent queries The Query Manager allows you to re sort and save the list of queries as well as open and delete any of them p 6 Total population all Ctra from Education theme Figure 34 Sharing Saved Queries Additionally clicking the Share button displays a reference URL pointing to your saved query which can be shared with colleagues e g sent via email Appropriate access rights will be required to view the query Viewing the Country Statistical Profiles The Country Statistical Profiles are a special set of data that can be accessed through the General Statistics theme The data tables for these datasets include links on the right hand side to comparative views graphs and tables with other OECD countries 09 2008 34 39 OECD Stat Web Browser User Guide Login Version fran aise Contact Us User Guide Home 2 OECD Stat Search B Current Query Canada Dataset Country statistical profiles 2008 i Current data selection Subject 428 428 Country 1 112 Year 6 Ty a B x amp mi Ts This statistical profile updated yearly is a snapshot of data selected from more than 40 statistical databases available on Sf Clic
38. rch on gross domestic 14 results found Gross Domestic Product Annual in millions of Current Prices National Currrency Gross Domestic Product Annual in millions of Constant 2000 Prices National Currency Gross Domestic Product Annual Deflator base 2000 100 Gross Domestic Product Annual in milions of Current Prices and Current PPPs fin USD Gross Domestic Product Annual in millions of Current Prices and Current Exchange Rates in USD Gross Domestic Product Per Capita Annual Current Prices and Current PPPs in USD Gross Domestic Product Per Capita Annual Current Prices and Current Exchange rate in USD Gross Domestic Product Per Capita Annual Current Prices and Current PPPs OECD 100 Gross Domestic Product Quarterly in millions of Current Prices National Currrency Gross Domestic Product Quarterly in millions of Constant 2000 Prices National Currrency Gross Domestic Product Quarterly Deflator base 2000 100 Gross Domestic Product Annual Current Prices National Currency Gross Domestic Product Annual Constant Prices National Currency Gross Domestic Product Annual Deflator national base year 1 00 Figure 9 Results of a Search in the dimension selector Changing the Time Dimension The options available for changing the selected dates of a time dimension are different from those presented for other dimensions Dates can be selected either using the Date Range Selection method or the Tim
39. rom OECD Stat ___tocanion 0S FREQUENCY 20 20 701 00 21 017 00 5 99 5 59 161 50 494 88 40 144 64 55 489 39 1 33 10 276 31 11 740 11 i 11 050 45 13 098 77 o p 774 14 1 358 66 13 964 00 14 184 00 10 240 91 10 522 10 40 189 91 10 489 87 52405 47829 4 79 4 37 Figure 15 Table showing codes instead of names Hiding Empty Rows or Columns If a table of data 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 09 2008 20 39 OECD Stat Web Browser User Guide Login Version fran aise Contact Us User Guide Home ORGANISATION FOR ECONOMIG tat CO OPERATION S Search E AND DEVELOPMENT i E Dataset Reference Series i Current data selection Country 39 44 Subject 62 59 Time amp Frequency 10 Pepe RE mm B B data extracted on 2008 09 16 17 26 from OECD Stat Country rts SSCS Annual E Frequency 2000 2001 2002 2003 2004 2005 AF Ay AF 19 153 00 19 413 00 19 898 00 39 158 11 40 8864 12
40. s view can be customized see next section Login Version frangaise ContactUs User Guide Home OECD Stat ms 3 Merged Queries Dataset Income Statement and Balance Sheet i Metadata 4 z Current data selection Item 57 434 Bank F 4d Browse Queries 3w Income Statement and Balance Sheet Find in Themes Cancel Navigate through themes and Peers sub themes down to a dataset Contact person organisation Click the dataset title once to open the default view Data Characteristics A Unit of measure used Statistics are reported at current prices in millions of national currency and in millions of Euros for OECD countries which are members of the Eure zone Pen enr nr Austria Belgium Finland France Germany Finance 1 Greece Ireland Italy Luxembourg Netherlands Portugal and Spain B Bank Profitability Statistics SESS FOJA An pain _ Classification of Bank Assets and 4 Net non 4 3 Fees and _ Mon financial data sre given in units Liabilities interest income commissions receivable E Income Statement and Balance Sheet 0 Fees ang J Population amp Scope New BOUT ons cavabls E Income Statement and Balance Sheet ki financial operations Bank profitability statistics are based on E Stat tan Balance Sheet Sa ae oe j financial statements of banks in each Member E SEERA eT NES 24 country and are presented in the standard T Structure of the Financial System E a OECD framework Although
41. se 2000 100 sai Convert to Adobe PDF ions Current Prices US Dollars 10 278 21 Export to Microsoft Excel Bi ele ete p ets bete air br 105 66 m Total Imports of Goods Monthly in millions Current Prices US Dollars Properties 11 050 45 sai ji Total Exports less Imports of Goods Monthly in millions Current Prices a 77444 US Dollars sai Figure 38 Printing data and other information from the Web Browser 09 2008 37 39 OECD Stat Web Browser User Guide Providing Feedback The OECD Stat Project Team can be contacted via E mail using the Contact Us link at the top of the screen Please note that in order to address your concerns in a timely manner we have set up two separate e mail accounts The first address OECDdotStat oecd org is accessible by clicking the upper link of the contacts page This address should be used for any technical questions or bugs that you encounter The second address OECDdotContent oecd org can be contacted by the second link on this page This address will provide responses to questions regarding the actual data content of OECD Stat e g Do you have data on shoe manufacturing What units are your data on domestic animal sales provided in Contact Online Assistance We will respond to your query as promptly as we can please note that OECD working hours are 8h30 18h00 Monday to Friday Paris time For issues related to the OECD Stat Web Browser ple
42. signed to be straightforward and intuitive in use It does however contain a number of advanced features which reflect the diversity of the Organization s statistical resources This User Guide has been prepared to help acquaint first time users with these features by stepping through them with the aid of selected screen shots Getting Started Page From the Getting Started page the user has the option of finding OECD statistical data and metadata through a number of different avenues Data can be located in various ways e OECD Stat Search Search e Browse Themes Browse Themes 2 e Browse Queries Browse Queries ee Each of these options will be explained in more detail in the remainder of the User Guide The browser is best used in full screen view at 1024x768 pixel screen resolution or higher Login Version frangaise Contact Us User d OECD Stat 1 e Lo L Beta Version Merged Queries Click here to open close left Welcome panel Browse Queries Browse Themes Four ways to access the data SELECT a dataset in the left hand OECD Stat includes data and metadata for OECD countries and menu selected non member economies feedback CREATE and customize your table by clicking on current data By keyword using search selection y theme in the left hand menu ies under browse queries RESHAPE your table using pivot dimensions to move rows and columns Click on arrow das
43. sion Members Every dimension contains a pre defined list of items called dimension members In the country dimension for example the dimension members are the individual countries Metadata 09 2008 4 39 OECD Stat Web Browser User Guide Qualitative data attached to the quantitative data in OECD Stat is called metadata Metadata can be found at various levels ranging from an abstract found at the level of an entire dataset country or series level footnotes which apply to a broad selection of data within a dataset and down to the level of a single cell Flags When a qualitative note is recurrent in a dataset and the exact same note can be attached to many individual data figures this may be stored as a flag A flag is a letter which appears alongside the numerical data in any table cell where it applies A legend appears beneath the table explaining the signification of each flag present in the table Flags are frequently used to note general data properties such as confidential provisional and estimated Reference Series A number of data series identified by the OECD Statistics Directorate as being generally useful in the calculation of 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 in order to ensure that the Reference Series contain the most recent data avai
44. t relevant links are shown first based on the frequency with which the keywords appear in each dataset and at which level they were found A keyword found in the name of a dataset is considered more relevant than a keyword found only in one of the dimension members of a dimension of the dataset or in the metadata Clicking on the link will open the dataset with the default view If a country has been entered as a keyword the results will be filtered to reflect this The tables resulting from a search will contain any references to the search keywords entered that could be found in the data These tables can be modified and used as a Starting point to find data related to the keywords entered Login Version frangaise ContactUs User Guide Home T _ OECD S ta t Search education expenditure iy M d z ee A full text search is done on dataset names dimension members and metadata The results are not the lerged Queries variables themselves but rather a list of datasets where the search terms exist and a query for each Browse Queries FA dataset amp proposed taking the search termes into account Browse Themes 2 For your search on education expenditure 46 results found Find in Themes Social Expenditure Detailed data i Found in datsseiname Social Expenditure Detailed data Found in membemame Child care pre primary education Pre school education Labour market and education ana
45. ve Query button in the centre area of the screen On subsequent visits to the browser this saved query can be opened to view the latest data available within the selection Current Query Gross Domestic Product Dataset Reference Series i H Current data selection Country 36 41 Subject 1 59 Time amp Frequency T m fy fa E Ix Ey Co E data extracted on 2008 09 30 16 17 from OQECD Stat Save as new Query Subject Gross Domestic Product Annual in millions of Curent Prices National Currency Se i 2005 AT AT AT Te 675 241 351 297 G42 SET 454 1 046 365 I I Figure 28 Saving a Query 09 2008 29 39 OECD Stat Web Browser User Guide Save Save Query Please be aware that Saved Queries are personal to OECD users and are not visible to other users If you provide a query with a name that already exists the previous query will be overwritten You can delete queries that you created Personal query Please name this query English Population and Labour Force for G7 countries Please name this query French Population et population active Figure 29 Saving a query with optional renaming Merge Queries Data from two or more datasets can be viewed in a combined table using the Merge Query function Any common 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 d
Download Pdf Manuals
Related Search