Language data by location in Scotland, 1911-1961.

Table ID:
S_LANG     (6567034)
Contents:
Language data by location in Scotland, 1911-1961.
Approx. number of rows:
264
Table type:
Raw Data
Documentation Author:
Paula Aucott
Chronology:
The data cover the period 1881 to 1911.
Dates and times are identified by:
   Year

Sources:

  1. Taken from the Census Reports of Scotland. See individual tables for sources.


Notes:

  1. Digitised in belfast by the Centre for Data Digitisation and Analysis at Queen's University, Belfast.
  2. Data transcribed for the census years 1911, 1921, 1931, 1951, 1961. 1901 includes Gaelic speaker statistics in more general tables. 1911 also has separate tables for English only speakers and Both English and Gaelic speakers.
  3. Looks like this table attempts to combine separate tables s_lang_1911, s_lang_1921, s_lang_1931, s_lang_1951, s_lang_1961. Not much work done on it. The table sources given need to be checked and the data compared to what is in the individual tables.


Checking:

  1. No checking has been done, other than visual check.
  2. No matching to the AUO gazetteer has been attempted. These files have been altered to run on Postgres, but otherwise are exactly the same as they were on the oracle server.


Indices:

IndexTypeColumn(s) indexed
s_lang_pkey Primary key rec_num
s_lang_idx Unique year, sco_cnty, rec_num


Constraints:

The table has the following associated constraints:

ConstraintTypeDetails
s_lang_pkey Primary Key See details above for primary key index



Columns within table:

ColumnTypeContents
year Integer number. Year.
nation Text string (max.len.=24). Containing nation
sco_cnty Text string (max.len.=44). Name of Scottish County.
sco_type Text string (max.len.=10). Identifying cities.
lang Text string (max.len.=44). [No description available]
tot_pop_en_m_f Integer number. Numbers enumerated in each County. Total, both sexes
pop_en_m_0_19 Integer number. Numbers enumerated in each County. Males. Under 20 years.
pop_en_m_20_up Integer number. Numbers enumerated in each County. Males. 20 years and upwards.
pop_en_f_0_19 Integer number. Numbers enumerated in each County. Females. Under 20 years.
pop_en_f_20_up Integer number. Numbers enumerated in each County. Females. 20 years and upwards.
tot_pop_born_m_f Integer number. Numbers born in each County. Total, both sexes
pop_born_m_0_19 Integer number. Numbers born in each County. Males. Under 20 years.
pop_born_m_20_up Integer number. Numbers born in each County. Males. 20 years and upwards.
pop_born_f_0_19 Integer number. Numbers born in each County. Females. Under 20 years.
pop_born_f_20_up Integer number. Numbers born in each County. Females. 20 years and upwards.
pop_enm_g_m Integer number. All Gaelic-Speaking persons. Number enumerated in each County. Males
pop_enm_g_f Integer number. All Gaelic-Speaking persons. Number enumerated in each County. Females.
pop_born_g_m Integer number. All Gaelic-Speaking persons. Number born in each County. Males.
pop_born_g_f Integer number. All Gaelic-Speaking persons. Number born in each County. Females.
pop_enm_g_only_m Integer number. Gaelic only. Number enumerated in each County. Males.
pop_enm_g_only_f Integer number. Gaelic only. Number enumerated in each County. Females.
pop_born_g_only_m Integer number. Gaelic only. Number born in each County. Males. Gaelic-speaking persons born outwith Scotland were not shown in 1921.
pop_born_g_only_f Integer number. Gaelic only. Number born in each County. Females. Gaelic-speaking persons born outwith Scotland were not shown in 1921.
pop_enm_g_e_m Integer number. Gaelic and English. Number enumerated in each County. Males.
pop_enm_g_e_f Integer number. Gaelic and English. Number enumerated in each County. Females.
pop_born_g_e_m Integer number. [No description available]
pop_born_g_e_f Integer number. [No description available]
pop_g_m Integer number. All Gaelic-Speaking persons. Number enumerated in each County. Males
pop_g_f Integer number. All Gaelic-Speaking persons. Number enumerated in each County. Females.
pop_g_only_m Integer number. Gaelic only. Number enumerated in each County. Males.
pop_g_only_f Integer number. Gaelic only. Number enumerated in each County. Females.
pop_g_e_m Integer number. Gaelic and English. Number enumerated in each County. Males.
pop_g_e_f Integer number. Gaelic and English. Number enumerated in each County. Females.
tot_pop Integer number. Total population
pop_g_only Integer number. Speaking Gaelic only.
pop_g_e Integer number. Speaking Gaelic and English.
pop_g_only_perc Floating point number. Speaking Gaelic only. Percentage of total population.
pop_g_e_perc Floating point number. Speaking Gaelic and English. Percentage of total population.
rec_num Integer number. Unique number identifying row in table.