Welsh skills language data for Local Authorities in Wales in 2011

Table ID:
LANG_2011_W     (6565824)
Contents:
Welsh skills language data for Local Authorities in Wales in 2011
Approx. number of rows:
22
Table type:
Raw Data
Documentation Author:
Paula Aucott
Geography:
Reporting units are identified by:
   Local Government District Type
Chronology:
The data cover the period 1881 to 1911.

Sources:

  1. These data were obtained from table "KS207WA - Welsh Language Skills" for Local Authorities from the 2011 Census of Population. The data was downloaded on 22nd October 2015 in spreadsheet format from the Census part of the Topics section on the Neighbourhood Statistics website operated by the Office for National Statistics. The data are under Crown Copyright, but are made available for use under an Open Government Licence.


Notes:

  1. The data contained a caveat about accuracy due to data protection. This may affect results from the check sums: "In order to protect against disclosure of personal information from the 2011 Census, there has been swapping of records in the Census database between different geographic areas, and so some counts will be affected. In the main, the greatest effects will be at the lowest geographies, since the record swapping is targeted towards those households with unusual characteristics in small areas. More details on the ONS Census disclosure control strategy may be found at Census Results / Statistical Disclosure Control.
  2. This data only relates to Wales


Checking:

  1. The statistical data have not been checked.
  2. The geographical units have been cross-checked against the GBHGIS administrative unit gazetteer to ensure that all units are correctly identified. The unit names and types have been standardised. Each unit has a unique unit ID assigned to it and this can be used to cross-reference against other data-sets.


Indices:

IndexTypeColumn(s) indexed
lang_2011_w_pkey Primary key rec_num
lang_2011_w_g_unit_idx Unique g_unit, rec_num
lang_2011_w_lau_idx Unique g_name, lg_type, rec_num


Constraints:

The table has the following associated constraints:

ConstraintTypeDetails
lang_2011_w_pkey Primary Key See details above for primary key index



Columns within table:

ColumnTypeContents
lau_code Text string (max.len.=24). ONS Code for the Local Authority as it appeared in the original table.
lau_name Text string (max.len.=104). Name of the Local Authority as it appeared in the original table.
lg_type Text string (max.len.=16). Type of unit.
g_unit Integer number. Unique ID number for local authority unit from the auo gazetteer.
g_name Text string (max.len.=104). Standardised name of local authority (preferred English name as given in the auo gazetteer).
tot_3_up Integer number. Count of All Usual Residents Aged 3 and Over.
no_welsh Integer number. Count of persons with No Skills in Welsh.
no_welsh_pc Floating point number. Percentage of persons with No Skills in Welsh.
understands_welsh Integer number. Count of persons who Can Understand Spoken Welsh Only.
understands_welsh_pc Floating point number. Percentage of persons who Can Understand Spoken Welsh Only.
speaks_welsh Integer number. Count of persons who Can Speak Welsh.
speaks_welsh_pc Floating point number. Percentage of persons who Can Speak Welsh.
speaks_welsh_nototh Integer number. Count of persons Can Speak but cannot Read or Write Welsh.
speaks_welsh_nototh_pc Floating point number. Percentage of persons who Can Speak but cannot Read or Write Welsh.
reads_welsh Integer number. Count of persons who Can Speak and Read but cannot Write Welsh.
reads_welsh_pc Floating point number. Percentage of persons who Can Speak and Read but cannot Write Welsh.
writes_welsh Integer number. Count of persons who Can Speak, Read and Write Welsh.
writes_welsh_pc Floating point number. Percentage of persons who Can Speak, Read and Write Welsh.
other_welsh Integer number. Count of persons with Other Combination of Skills in Welsh.
other_welsh_pc Floating point number. Percentage of persons with Other Combination of Skills in Welsh.
rec_num Integer number. Unique number identifying row in table.