Undocumented Table: EDU_REDISTRICTED_NEW

Table ID:
EDU_REDISTRICTED_NEW     (6562552)
Contents:
[No description available]
Approx. number of rows:
2,580
Table type:
Derived
Documentation Author:
Humphrey Southall
Chronology:
The data cover the period 1851 to 2011.
Dates and times are identified by:
   Year

Notes:

  1. The data available on education varies greatly between dates, so comparisons over time are hard. See below for 1851, but for later dates the data cover the adult population and record EITHER the age at which they left education OR the highest level of qualification they obtained. To make the two different measures comparable, we assume here that persons who finished their education before age 16 left without formal qualifications, and that those who left at age 20 or later obtained a degree.
  2. Provided data for the two sexes are available separately in the original tables, they have been redistricted separately, then added together to create the counts of persons. For now, seperate data for males and females is included for 2001, 1991, 1961 and, only for Scotland, in 1951. Unfortunately, the 1951 England and Wales census provided data only for males in districts with under 50,000 population. For now, therefore, for districts in England and Wales in 1951 ONLY we copy the male data into the "persons" columns. The 1971 Small Area Statistics used here do not permit a breakdown by sex.
  3. The table has been designed to hold data on the proportion of children remaining in education beyond the compulsory school leaving age, but those columns are currently used to hold only data for 1851, which come from a separate census of schools, so provide numbers of children CURRENTLY attending school, either ordinary Day Schools or Sunday School. In order to calculate rates, total numbers of children ages 5 to 14 in 1851 have been added from census age structure data.


Checking:

  1. This table holds purely derived data.


Indices:

IndexTypeColumn(s) indexed
edu_redistricted_new_pk Primary key g_unit, year


Constraints:

The table has the following associated constraints:

ConstraintTypeDetails
edu_redistricted_new_pk Primary Key See details above for primary key index



Columns within table:

ColumnTypeContents
row_type Text string (max.len.=14). [No description available]
area_code Text string (max.len.=18). [No description available]
nation Text string (max.len.=6). [No description available]
area_name Text string (max.len.=40). [No description available]
g_unit Integer number. [No description available]
year Integer number. [No description available]
geogcode_1991 Text string (max.len.=9). [No description available]
p_total Integer number. [No description available]
p_qual_none Integer number. [No description available]
p_qual_degree Integer number. [No description available]
p_eligible_vol Integer number. [No description available]
p_attending_vol Integer number. [No description available]
p_attending_sunday Integer number. [No description available]
m_total Integer number. [No description available]
m_qual_none Integer number. [No description available]
m_qual_degree Integer number. [No description available]
m_eligible_vol Integer number. [No description available]
m_attending_vol Integer number. [No description available]
m_attending_sunday Integer number. [No description available]
f_total Integer number. [No description available]
f_qual_none Integer number. [No description available]
f_qual_degree Integer number. [No description available]
f_eligible_vol Integer number. [No description available]
f_attending_vol Integer number. [No description available]
f_attending_sunday Integer number. [No description available]
g_authority Text string (max.len.=24). [No description available]
g_auth_note Text string (max.len.=404). [No description available]
g_data_precision Text string (max.len.=12). [No description available]
g_data_status Text string (max.len.=9). [No description available]
rec_num Integer number. [No description available]