cellname.md

fields/CELLNAME

The CELLNAME field can be found in the codelist_cube_description table. When used in conjuction with GL_EXTENTS and INFUSE_TABLE_NAME, relevant data can be found.

The CELLNAME field indicates the field you need when querying the relevent data. For example, let's say you have:

• INFUSE_TABLE_NAME: QS402_0_EW_MRG_RCD_AGG
• CELLNAME: QS402EW0009

You can the perform the following query:

SELECT GEOCODEID, CL_ID, QS402EW0009 FROM QS402_0_EW_MRG_RCD_AGG;

GEOCODEID	CL_ID	QS402EW0009
3	2002	860207
4	2003	834083
5	2003	5340
6	2003	41668
7	2003	26124
8	2004	24264
9	2004	59284
...	...	...

We can now use this table to determine that for where the GL_EXTENTS is 2003:5, the value is 5340.

Working back from this, because we know that CELLNAME relates to the IS_ID of 2, and that:

SELECT CL_CODE FROM codelist_cube_description WHERE IS_ID = 2;

CL_CODE
ACCTYP:10,UNIT:1964

SELECT ID, DESCRP FROM infuse2011.codes  WHERE ID IN (10, 1964);

ID	DESCRP
10	Part of a converted or shared house (including bed-sits)
1964	Households

We now that the the value 5340 represents the amount of households (1964) that are converted or shared housing (10) in Northern Ireland (2003:5)