User query examples


Example user queries that a data feed would need to be able to answer:

Below are some example user queries that a data feed would ideally be able to answer. These are reasonably straightforward to start with and could help evaluate ONS' SDMX proof of concept work?

It would also be interesting to ask more complex queries of the feed - e.g. user defined polygons or previously disclosive cross-tabs like industry/ethnic group for larger geographies - and see how it would cope.

Name of requester: Alan Lewis (SASPAC)

Query: Details on the economic activity (employed/self-employed…etc) of the UK population for electoral ward/division geographies.

Population base: Resident population aged 16 to 74

Variables: Key Statistics table KS009, variables KS0090001 to KS0090015

Geography: LAU-2 (UK electoral wards/divisions) England, Wales, Scotland and Northern Ireland

Format: XML


Name of requester: Alan Lewis (SASPAC)

Query: Details of the method of travel to work for custom workplace population geographies.

Population base: Employed people aged 16 to 74

Variables: Special Workplace Statistics, variables SWS3010001 to SWS3010036

Geography: Custom workplace geography built from an aggregation of 2001 Census Output Areas

Format: MS Excel (1997-2003 or 2007)


Name of requester: Alan Lewis (SASPAC)

Query: Pre-school aged population profile of residents within 2 miles of a school?

Population base: Resident population

Variables: Population weighted Easting/Northing and Census Area Statistics table CS001

Geography: Selection of 2001 Census Output Area population centroids

Format: HTML


In all cases here the request would provide the queried varaiables along with the appropriate metadata.


Add a New Comment

Suggestions for new pages, created: 18 May 2011 18:56

Metadata, created: 25 Mar 2010 10:56

Cube design & sparsity, created: 25 Mar 2010 10:54

EDINA Development progress, created: 24 Mar 2010 10:47

GROS Development progress, created: 24 Mar 2010 10:43


Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License