Column | Type | Contents |
g_unit |
Integer number. |
Unique ID number for local government district unit.
|
area_code |
Text string (max.len.=18). |
Alphanumeric ID for district as used by the census offices.
|
area_name |
Text string (max.len.=40). |
Name of the district or region.
|
area_type |
Text string (max.len.=16). |
This column identifies the geographical level:
- DISTRICT, i.e. an individual local authority.
- MOD_CNTY, i.e. an English county.
- GOR, i.e. computed total for a Government Office Region
(or Wales).
- NATIONAL, i.e. an overall total for England and Wales,
Scotland or Great Britain.
The nat_source column records how such totals were obtained.
|
nation |
Text string (max.len.=6). |
One or two-letter code identifying the part of the UK.
|
nat_source |
Text string (max.len.=28). |
Appears only for rows which are national totals, and then identifies how it was derived.
This will ideally be "Reported_total".
|
geogcode_1991 |
Text string (max.len.=13). |
This column holds the census office identifier for the district
as used in 1991, but only if we know the district had the same boundaries in 1991 and 2011.
This is currently set only for the London Boroughs.
|
year |
Integer number. |
Year in which census was taken.
|
area_h |
Floating point number. |
Area of the unit in hectares.
NB this is inserted into rows for all years,
but is always the area as reported by the 2011
census, as listed in our tables lau_2011_ew and lau_2011_s.
|
tot_pop |
Floating point number. |
Total population.
|
tot_male |
Floating point number. |
Total male population.
|
m_0 |
Floating point number. |
Males aged under 1.
|
m_1 |
Floating point number. |
Males aged between 1 and 2.
|
m_2 |
Floating point number. |
Males aged between 2 and 3.
|
m_3 |
Floating point number. |
Males aged between 3 and 4.
|
m_4 |
Floating point number. |
Males aged between 4 and 5.
|
m_0_4 |
Floating point number. |
Males aged 0 to 4.
|
m_5_9 |
Floating point number. |
Males aged 5 to 9.
|
m_10_14 |
Floating point number. |
Males aged 10 to 14.
|
m_15_19 |
Floating point number. |
Males aged 15 to 19.
|
m_20_24 |
Floating point number. |
Males aged 20 to 24.
|
m_25_29 |
Floating point number. |
Males aged 25 to 29.
|
m_30_34 |
Floating point number. |
Males aged 30 to 34.
|
m_35_39 |
Floating point number. |
Males aged 35 to 39.
|
m_40_44 |
Floating point number. |
Males aged 40 to 44.
|
m_45_49 |
Floating point number. |
Males aged 45 to 49.
|
m_50_54 |
Floating point number. |
Males aged 50 to 54.
|
m_55_59 |
Floating point number. |
Males aged 55 to 59.
|
m_60_64 |
Floating point number. |
Males aged 60 to 64.
|
m_65_69 |
Floating point number. |
Males aged 65 to 69.
|
m_70_74 |
Floating point number. |
Males aged 70 to 74.
|
m_75_79 |
Floating point number. |
Males aged 75 to 79.
|
m_80_84 |
Floating point number. |
Males aged 80 to 84.
|
m_85_up |
Floating point number. |
Males aged 85 and over.
|
m_0_14 |
Floating point number. |
Derived value: Summed males aged 0 to 14.
|
m_15_64 |
Floating point number. |
Derived value: Summed males aged 15 to 64.
|
m_65_up |
Floating point number. |
Derived value: Summed males aged 65 and over.
|
tot_fem |
Floating point number. |
Total female population.
|
f_0 |
Floating point number. |
Females aged under 1.
|
f_1 |
Floating point number. |
Females aged between 1 and 2.
|
f_2 |
Floating point number. |
Females aged between 2 and 3.
|
f_3 |
Floating point number. |
Females aged between 3 and 4.
|
f_4 |
Floating point number. |
Females aged between 4 and 5.
|
f_0_4 |
Floating point number. |
Females aged 0 to 4.
|
f_5_9 |
Floating point number. |
Females aged 5 to 9.
|
f_10_14 |
Floating point number. |
Females aged 10 to 14.
|
f_15_19 |
Floating point number. |
Females aged 15 to 19.
|
f_20_24 |
Floating point number. |
Females aged 20 to 24.
|
f_25_29 |
Floating point number. |
Females aged 25 to 29.
|
f_30_34 |
Floating point number. |
Females aged 30 to 34.
|
f_35_39 |
Floating point number. |
Females aged 35 to 39.
|
f_40_44 |
Floating point number. |
Females aged 40 to 44.
|
f_45_49 |
Floating point number. |
Females aged 45 to 49.
|
f_50_54 |
Floating point number. |
Females aged 50 to 54.
|
f_55_59 |
Floating point number. |
Females aged 55 to 59.
|
f_60_64 |
Floating point number. |
Females aged 60 to 64.
|
f_65_69 |
Floating point number. |
Females aged 65 to 69.
|
f_70_74 |
Floating point number. |
Females aged 70 to 74.
|
f_75_79 |
Floating point number. |
Females aged 75 to 79.
|
f_80_84 |
Floating point number. |
Females aged 80 to 84.
|
f_85_up |
Floating point number. |
Females aged 85 and over.
|
f_0_14 |
Floating point number. |
Derived value: Summed females aged 0 to 14.
|
f_15_64 |
Floating point number. |
Derived value: Summed females aged 15 to 64.
|
f_65_up |
Floating point number. |
Derived value: Summed females aged 65 and over.
|
f_fertile |
Floating point number. |
Derived value: Summed females aged 20 to 49.
|
g_data_status |
Text string (max.len.=6). |
Flag indicating access status.
Current set to P for Public for all rows.
|
g_data_precision |
Text string (max.len.=8). |
Flag indicating basis for calculation.
Currently GBR for all rows except 2011 and
those 1991 rows for which geogcode_1991 is not null.
|
rec_num |
Integer number. |
Sequence number created as rows were inserted into the table.
|