|
Version
1.1
Copyright © 2002, IIASA & RAS
All Rights Reserved
|
|
STATISTICS
- Database
Source
Forest Project, IIASA, Land Resources of Russia CD-ROM. The socioeconomic
database originates from GOSCOMSTAT.
Technical Description
Each section of the
socioeconomic description is stored in two different types of tables:
the year-field table and the parameter-field table. In the year-field
table the distinct values of the years (i.e. 1987 through 1993) form the
column names of the data items. In the parameter-field table the data
items are named using the parameter code values as column names. The data
stored in these two table types is the same, the technical layout of the
table differs due to a matrix transformation. Since the number of columns
in a data table is limited, each of the year-field table is broken down
in a number of parameter-field tables.
The data tables
of the socio-economic description have been named using the template of
'PREFIX_BASE_SUFFIX', where:
the 'PREFIX' denotes
the socioeconomic description being 'SE_'.
The 'BASE' identifies the data section with the template 'SXXYY_', where
SXX is the number of the section and YY (optionally only for the parameter-field
tables) is the serial number for the different versions of the tables.
The 'SUFFIX' has four possibilities:
'YF' - marks that the table is a year-field table.
'PF' - marks that the table is a parameter-field table.
'ECN' - marks that the table is a year-field table and the data is aggregated
on an economic region level.
'SEP' - marks that the table is a year-field table and the data is only
for the so called separated regions. The separated regions are administrative
regions that have been divided in the year 1991 in smaller administrative
units. The tables contain the data for the old and for the new regional
units for comparison.
Table Definitions
SE1 |
YEAR
FIELD TABLE |
Tables that
contain the years as column headings |
se_sXX_yf |
Where XX depends
from the theme section: 01- 20. |
1 |
Administrative
region ID |
ID |
Adm_id |
|
2 |
Parameter
code |
code |
Par_code |
See
separate list. |
3 |
Parameter
code value for the year 1987 |
value
in units defined by the parameter code |
D87 |
|
4 |
Parameter
code value for the year 1988 |
value
in units defined by the parameter code |
D88 |
|
5 |
Parameter
code value for the year 1989 |
value
in units defined by the parameter code |
D89 |
|
6 |
Parameter
code value for the year 1990 |
value
in units defined by the parameter code |
D90 |
|
7 |
Parameter
code value for the year 1991 |
value
in units defined by the parameter code |
D91 |
|
8 |
Parameter
code value for the year 1992 |
value
in units defined by the parameter code |
D92 |
|
9 |
Parameter
code value for the year 1993 |
value
in units defined by the parameter code |
D93 |
|
SE2 |
YEAR
FIELD TABLE FOR ECONOMIC REGIONS |
Table that contain
the data as in table SE1, but aggregated for economic regions. |
se_sXX_ecn |
Where XX depends
from the theme section: 01- 20. |
1 |
Economic
region ID |
ID |
Adm_id |
|
2 |
Parameter
code |
code |
Par_code |
See
separate list. |
3 |
Parameter
code value for the year 1987 |
value
in units defined by the parameter code |
D87 |
|
4 |
Parameter
code value for the year 1988 |
value
in units defined by the parameter code |
D88 |
|
5 |
Parameter
code value for the year 1989 |
value
in units defined by the parameter code |
D89 |
|
6 |
Parameter
code value for the year 1990 |
value
in units defined by the parameter code |
D90 |
|
7 |
Parameter
code value for the year 1991 |
value
in units defined by the parameter code |
D91 |
|
8 |
Parameter
code value for the year 1992 |
value
in units defined by the parameter code |
D92 |
|
9 |
Parameter
code value for the year 1993 |
value
in units defined by the parameter code |
D93 |
|
SE3 |
YEAR
FIELD TABLE FOR 'SEPARATED REGIONS' |
Table contains
the 'old' (version 93) and the 'new' (version 95) entries only for
the separated regions. |
se_sXX_sep |
Where XX depends
from the theme section: 01- 20 |
1 |
Status
code |
code |
Status |
|
old |
Data
entry from the delivery in the year 1993 |
|
new |
Data
entry from the delivery in the year 1995 |
|
2 |
Administrative
region ID |
ID |
Adm_id |
The regions
effected: 1101, 1102, 1103, 1104, 1107, 1108, 1121, 1135, 1144, 1191,
1195. |
3 |
Parameter
code |
code |
Par_code |
See
separate list. |
4 |
Parameter
code value for the year 1987 |
value
in units defined by the parameter code |
D87 |
|
5 |
Parameter
code value for the year 1988 |
value
in units defined by the parameter code |
D88 |
|
6 |
Parameter
code value for the year 1989 |
value
in units defined by the parameter code |
D89 |
|
7 |
Parameter
code value for the year 1990 |
value
in units defined by the parameter code |
D90 |
|
8 |
Parameter
code value for the year 1991 |
value
in units defined by the parameter code |
D91 |
|
9 |
Parameter
code value for the year 1992 |
value
in units defined by the parameter code |
D92 |
|
10 |
Parameter
code value for the year 1993 |
value
in units defined by the parameter code |
D93 |
|
SE4 |
PARAMETER
FIELD TABLE |
Tables that
contain the parameter values as column headings. Each of the 20 sections
have been divided into multiple tables. |
se_sXXYY_pf |
Where XX depends
from the theme section: 01- 20, and YY from the sequential number
of the subsection. The table SE2 is a matrix transformation of the
table SE1. |
1 |
Administrative
region ID |
ID |
Adm_id |
|
2 |
Year
code |
code |
Year |
|
3 |
Value
for specific year for parameter code value N |
value
in units defined by the parameter code |
SXXXXXXX |
Where XXXXXXX
depends from the value of the parameter code |
Parameter
Codes by section:
Section
01 - General identification
Section 02 - Population
Section 03 - Labour
and salary
Section 04 - Industry
Section 05 - Agriculture
Section 06 - Capital
construction
Section 07 - Communication
and transport
Section 08 - State
trade and catering
Section 09 - Utilities
and services
Section 10 - Health
care and sport
Section 11 - Education
and culture
Section 12 - Finance
Section 13 - Public
consumption
Section 14 - Industrial
production
Section 15 - Interregional
trade
Section 16 - Labour
resources
Section 17 - Supply
of materials
Section 18 - Environmental
protection
Section 19 - Foreign
trade
Section 20 - Price
indices
Top
of Page
|