The IDB tables by region program is designed to allow the display of selected demographic measures for selected years and selected regions and/or countries of the world. The program has a series of built-in regions, but a user-defined region can be created by selecting a series of countries. Several predefined regions can be selected and the desired tables can be generated either for each region separately or for one super region that consists of all the countries in the regions selected. In either case the results can be shown for region(s) only, countries only, or both regions and countries.
The first step is to select a table and output type. The default output type is Display Mode. This is useful for quick browsing of data. The Spreadsheet Mode gives you more control over the format of the output which might be useful for loading into a spreadsheet or other program. The User Configurable option gives you even more formatting options, including an option to put all the stub information on each line of output (e.g. country, year, age group). This is useful if you want to sort the data in different ways. After selecting the table and output type, press the Submit Query button. For all of the Output types [access methods] you must select:
and then "press" the submit button near the bottom of the form. For the "Spreadsheet" and "User Configurable" access methods you can also make choices regarding the format of the output.When using windows-based browsers, you must use the scroll-bar at the far right to see further options (e.g. countries, years, SUBMIT button). When selecting regions, countries, or years, use the scroll bar next to the list of options to see all the possibilities.
To select more than one country (or region or year) using a windows-based browser like Netscape or Internet Explorer:
Point to one country and click then either
Point to the item that is selected, hold down the Ctrl key and click. The shading that indicates selection should then disappear. To make sure there are no selections remaining in a selection box, click on an item and then deselect it.
These options describe how you want the aggregations to be performed.
You can find the countries included in a predefined region by selecting the Treat each region separately and the Both region and country data options. Then select one or more of the predefined regions. You can also see the countries in each region by selecting the desired region(s) below and pressing the "Show countries in regions" button.
Your responses in this area define the regions and/or countries that you want to aggregate.
In the first part, "Select one or more regions," you can select one or more predefined regions to use in your aggregations.
In the second part, "Select one or more countries ...," you can create your own region by selecting one or more countries.
If you have selected "Treat each region separately," then any predefined regions will be processed, and any countries selected will become an additional region. Be sure to enter a name for your region in the field labeled User region name.
If you have selected "Combine all countries and regions ...," then the program will create one region that contains all the countries in the predefined regions you select with any countries selected separately. In this case the "User Region Name" should describe the region composed of all predefined regions plus countries selected.
To deselect a region or country, hold the Ctrl key down while clicking on the item selected.
In this section, indicate the year or years for which you wish to get aggregated data.
In the first part, "Select one or more years...," you can select one or more years to use in your aggregations. The first two options are all available years and latest available year are provided to allow quick access to all or the most current years of data. Years selected in this first part of the year selection section will be combined with any year ranges.
In the second part, "Year range ...," you can specify and initial year ("From") and ending year ("To") and a year interval ("By"). Thus, for example if you wish to look at data for every fifth year from 1960 to 2025 your form would look like this:
From: 1960 To: 2025 By: 5
Remember that these years will be combined with any years selected in the first section.
If the "Predefined age groups" do not show the groupings that you want (e.g. you want a single 5-year age group or a broader grouping that is not covered there) you can define your own age groupings in this section.
The following codes are used to designate age groups:
A. Using "Spreadsheet mode" (this should work with all versions of Excel):
If you would like to sort the data in different ways than the default display (e.g. by year then country rather than country then year), use the "spreadsheet" or "user configurable" mode. After selecting the countries, regions, years scroll down to the last section "Stub processing" and select the option "Present all stub information on each data line." You can then use method A or B above to transfer the data to Excel.
