Time and Place Examples

The File menu of the Time And Place application contains references to a number of example series, organized into statistics about US States and statistics of the World's countries. Click on the link to launch the application to bring up the examples described below.

Some of the examples are only slightly modified from the original source, others were computed using other series as inputs and are marked with a '[=]' in the menu. Use the File/Properties menu to see the sources of the data and how they were formed.

US Series

Most of these examples are from the original SGI Demograph program and the US Bureau of Economic Analysis (BEA).

        US Presidential Vote 
                Democratic Vote - SGI
                Republican Vote - SGI
                Difference between Democratic and Republican Vote [=]
                Sum of Democratic and Republican Vote [=]

                Democratic Vote, original - SGI
                Republican Vote, original - SGI
                Sum of SGI Democratic and Republican Vote, original [=]

Current events quiz: explain what you see for the vote in 1948 looking at the sum of Democratic and Republican Vote percentage.

The last example above shows the errors in the original SGI vote data (with one lost blank restored) by adding the Republican and Democratic percentage vote. You can see the errors easily by sorting the entries by value and ungrouping them. The obvious errors were corrected in the other SGI vote examples. Notice it is not possible to compute meaningful values for regions of states here since we do not have the voting population for each state.

        US Population
                Population - SGI - 1770:1990
                Population - BEA - 1929:2001

Excercise for the student: create a new series to compare the two estimates of population.

        US Income
                Income, per capita - SGI
                Product of SGI per capita Income and SGI Population [=]
                
                Personal Income - BEA
                Personal Income, per capita - BEA
                Product of BEA per capita Personal Income and BEA Population [=]
                Ratio of BEA Personal Income to BEA Population [=]
                
                Disposable Income - BEA
                Disposable Income, per capita  - BEA
                Product of BEA per capita Disposable Income and BEA Population [=]
                Ratio of BEA Disposable Income to BEA Population [=]
                
                Comparison of BEA's per capita income with SGI's as absolute difference [=]
                Comparison of BEA's per capita income with SGI's as percentage difference of BEA figure [=]
                Comparison of BEA's Personal Income with SGI's per capita income*population as percentage of BEA's figure [=]
                 

There were only a few changes to the files downloaded from the BEA. The BEA data allows cross checks on the per capita calculations since they include the totals for each state, the per capita data, and the population.

The first Comparison example shows that BEA estimates for per capita Income tend to be larger than SGI's. You might want to compare the difference with BEA's Disposable Income to see if SGI's figures are perhaps related more to Disposable income.

The second Comparison example normalizes the difference to a percentage of the BEA estimate to help in visualizing how large or small the difference is in comparison to the typical per capita income of the time.

The third Comparison example shows a number of striking differences which seem to be outliers rather than systematic differences. Are they perhaps errors?

World Series
The world data is drawn from the
US Census Bureau, the World Resource Institute, the Economic Analysis Institute, the US Dept of State, previously from the Arms Control and Disarmament Agency, Statistics Canada, and the Stockholm International Peace Research Institute.
        World Population
                Population - Census - 1950:2050
                Population - WRI - 1950:2003
                Population - WMEAT99 - 1988:1999
                Area - CIA

The Census data for world population uses one grouping file and has projections to the year 2050, while the other two use a grouping file from the WMEAT99 data. They each treat temporal changes in political boundaries differently, so be aware when using them for per capita computations. All have entries primarily for countries that existed at the time the data was prepared, although a few historical entries are present. Check on the entries for East and West Germany, USSR, Czechoslovakia and Yugoslavia in particular.

The Census department's data has entries for current countries from 1950:2050, with values provided for years even when the region was not a country.

Similarly, the WRI data has entries for current countries with values provided for all years from 1950:2003.

The WMeat data has entries for current countries, with not-a-number values supplied for years when the region was not yet a country and covers 1989:1999. The entry for Germany is for West Germany and the combined Germany, and the entry for Yugoslavia is for years prior to the breakup.

It's interesting to compare the difference estimates over the years which are common to all.

The Area series gives the area of countries, independent of time. It is useful for computing densities.

        World Oil
                Oil Consumption - EIA
                Oil Production - EIA
                Oil Production minus Consumption [=]

                Oil Consumption, per capita [=]
                Oil Production, per capita [=]
                Oil Production, per capita minus Consumption [=]

Viewing the difference in Production and Consumption gives a good indication of which countries are heavily dependent on imports.

        World Food and Water

These files on agricultural resources had to have the columns for dates sorted in ascending rather than descending order. The two description lines were combined into one and some fotenotes removed.

                Meat, Consumption - WRI
                Meat, Consumption, per capita - WRI
                Meat, Production, total - WRI
                Meat, Production, Beef - WRI
                Meat, Production, Sheep - WRI
                
                Grain, for Livestock - WRI
                Calories, for Animals - WRI
                Calorie Supply, per capita - WRI

You can observe strong trends over time of animal versus vegtable consumption.

                Cereal, Net Consumption - WRI
                Cereal, Total Production - WRI
                Pulses, Total Production - WRI
                Roots and Tubers, Total Production - WRI
                
                Water, Withdrawals, per capita - WRI
                Water, Agricultural percentage - WRI
                Water, Industrial percentage - WRI
                Water, Domestic percentage - WRI

The data on water was available only for one year.

        Canadian School Enrollment
                Canadian School Enrollment (try View/Show Subseries)	
                Canadian School Enrollment Shown on Grid

The Canadian School Enrollment data from Statistics Canada shows the use of the Show Subseries to display a pie chart of categories in conjunction with a grid namespace for data with no geographic identity.

        World Military Expenses
                Armed Forces - WMEAT99
                Armed Forces, percentage of population [=]
                Armed Forces, per square km of country area [=]

                Military Expenses - WMEAT99
                Military Expenses, constant 1999 dollars - WMEAT99
                Military Expenses, per capita, constant 1999 dollars [=]
 
                Central Gov Expenses, constant 1999 dollars - WMEAT99
                Gross National Product - WMEAT99
                Gross National Product, constant 1999 dollars - WMEAT99
                Military Expenses, percentage of CGE [=]
 

The following series from the Stockholm International Peace Research Institute (SIPRI) have restricted access. You may request access through email to Petter Stålenheim at milexp at sipri dot org.

Note that regional totals in these series are not the same values which are shown for the regional totals in the SIPRI yearbooks.

        SIPRI 2002 World Military Expenses (Access restricted)
                Military Expenses, in constant 1998 US $ - SIPRI 2002 [=]
                Military Expenses, percentage of GDP - SIPRI 2002 [=]

                Military Expenses, per capita - SIPRI 2002 [=]
                Military Expenses, in non-constant US $ - SIPRI 2002 [=]
                Gross Domestic Product (GDP) - SIPRI 2002 [=]

                Military Expenses in local currency - SIPRI 2002
                Local currency scale - SIPRI 2002
                Military Expenses in scaled local currency - SIPRI 2002 [=]

       SIPRI 2003 World Military Expenses (Access restricted)
                Military Expenses, in constant 2000 US $ - SIPRI 2003 [=]
                Military Expenses, percentage of GDP - SIPRI 2003 [=]

                Military Expenses, per capita - SIPRI 2003 [=]
                Military Expenses, in non-constant US $ - SIPRI 2003 [=]
                Gross Domestic Product (GDP) - SIPRI 2003 [=]
                
        SIPRI 2004 World Military Expenses and Top 100 Arms Companies (Access restricted)
                Military Expenses adjusted, in constant 2000 US $ - SIPRI 2004 [=]	
                Total of companies arms and non-arms Sales	
                Total of companies exports and non-exports Sales	
                Company Productivity in Sales/Employee	
                Company Employment

Agile Image Movers home page