1961 Educational Statistics in England and Wales (age at termination of education)

Table ID:
EDU_1961_EW     (6562504)
Contents:
1961 Educational Statistics in England and Wales (age at termination of education)
Approx. number of rows:
2,934
Table type:
Raw Data
Documentation Author:
Paula Aucott
Geography:
Reporting units are identified by:
   Administrative County
   Local Government District
   Local Government District Type
Chronology:
The data cover the period 1881 to 1911.

Sources:

  1. The data are taken from table 4, 'Population aged 25 and over by 7 Terminal Age groups' for 'Counties, Local Authority Areas, Conurbation Centres, New Towns (10 per cent sample)' (pp.67-111) in the Education Tables volume of the 1961 census reports.


Notes:

  1. These data are from a 10% sample of all households.
  2. Unlike the 1951 data, these data cover both sexes, with two rows for each district distinguished by the 'sex' column.
  3. This data covers only England and Wales.
  4. This table was originally called edu_1961. It was amended in January 2010 to be edu_1961_ew to reflect more accurately the area covered by the content


Checking:

  1. The data were checked to ensure that the figures for the total population aged over 25 equalled the total for all terminal ages plus the number not stated; and that the individual terminal ages summed to the total for all terminal ages (see constraints below).
  2. The data have been cross-checked against the 1961 age structure data, to ensure that the districts listed are identical.
  3. As the data are for a 10% sample, exact matching with the age structure data is impossible. However, the total aged over 25 has been compared with the equivalent total in the age structure table divided by ten. All but two differences are either under 25 or less than 12.5% of the age total, and those two exceptions are correctly transcribed.
  4. When the file was tranferred and modified to run on Postgres the geographical units were cross-checked against the GBHGIS administrative unit gazetteer to ensure that all units are correctly identified. Each unit has a unique unit ID assigned to it and this can be used to cross-reference against other data-sets. The matching to the AUO is complete.
  5. This data set is now believed to be error free.


Indices:

IndexTypeColumn(s) indexed
edu_1961_ew_pkey Primary key rec_num
edu_1961_ew_idx Unique adm_cnty, lg_dist, lg_type, sex


Constraints:

The table has the following associated constraints:

ConstraintTypeDetails
edu_1961_ew_pkey Primary Key See details above for primary key index
edu_1961_ew_ck_all_ages Check ((((((age_u_15 + age_15) + age_16) + age_17_19) + age_20_up) + edu_cont) = all_ages)
edu_1961_ew_ck_tot_25up Check ((age_ns + all_ages) = tot_25up)



Columns within table:

ColumnTypeContents
adm_cnty Text string (max.len.=30). Name of Administrative County unit containing the district as it appeared in the original report.
lg_dist Text string (max.len.=36). Name of Local Government District unit as it appeared in the original report, i.e. lower case.
lg_type Text string (max.len.=8). Type of Local Government District as it appeared in the original report.
adm_cnty_unit Integer number. Unique ID number for container unit.
g_unit Integer number. Unique ID number for unit.
g_year Integer number. Year Census taken.
sex Text string (max.len.=5). Sex.
tot_25up Integer number. Total population aged 25 and over.
all_ages Integer number. Terminal Education Age: Total (excluding not stated).
age_u_15 Integer number. Terminal Education Age: Under 15.
age_15 Integer number. Terminal Education Age: 15.
age_16 Integer number. Terminal Education Age: 16.
age_17_19 Integer number. Terminal Education Age: 17-19.
age_20_up Integer number. Terminal Education Age: 20 and over.
age_ns Integer number. Terminal Education Age not stated.
edu_cont Integer number. Terminal Education Age: Full time education continuing
rec_num Integer number. Unique number identifying row in table.