|Obesity||2013-2015||Public Health England||link|
|Income||2013-2014||Survey of Personal Incomes by HMRC||link|
|Degree Attainment||2015||Greater London Authority||link|
|GCSE||2013-2014||Greater London Authority||link|
|Diet||2006*||Point X and Ordinance Survey||link|
|Green Space||2013||Greenspace Information for Greater London||link|
|Sports Facilities||2015||Active Places Power||link (site)**|
|Sports participation||2014-2015||Sport England||link|
|Population||2014||Greater London Authority||link|
* On their report the copyright of the database is 2006, but the actual data collection date is not mentioned.
** Log in (Free sign up) -> Reports -> Detailed Report -> Facilities
Origin of the data
After much research, we ended up mainly using the London Datastore. This is an open data website, which was created by the Great London Authority (GLA), with the initiative to ‘free London’s data’. Their aim is to make data about London free and as easily accessible to everyone as possibly by publishing data released to them by various institutions. The GLA however will not publish any data that would infringe on the privacy legislation or contractual obligation: it processes personal data in accordance with the Data Protection Act 1998. The London Datastore is an official organization which ensures its partners collecting the data are reliable, thorough in their data extraction and well-respected, making the data trustworthy and sincere. The data used on sports facilities is from Active Places Power, another open data website which holds a great deal of data on sports facilities, management, location, etc. Its aim is to “build an evidence base when identifying and planning where to target intervention,” (3) hence it is used as a guide for sports investment decisions. Active Place Power records are continuously updated and maintained by Adetiq, a UK data entry, capture and analysis company, who are contracted by Sport England. Given the data originates from this company of expertise, it is reliable and up to date, and hence we found it an appropriate source. Finally the number fast food outlet data comes from PointX. PointX is a joint venture company involving Britain’s national mapping agency the Ordnance Survey and Landmark Information Group Ltd. This data has been used by Public Health England and despite some caveats, which are discussed in the Diet section under the Visualisations tab, it should be relatively reliable because it has been checked centrally by Ordinance Survey.
Limitations of the data
We encountered several limitations in the process of finding and choosing our data. At the beginning we were sceptical about finding the data we needed because of the specific nature of the factors we wanted to study, for example the number of sports facilities/ coffee shops/ fast food per borough. We almost assumed that we were not going to be able to find these after a short search online. However, counting these factors our selves using using Google maps and branch finders was going to take far too long, our persistence and patience paid off and we began to find what we were looking for by following reference trails. Despite these successes we were unable to find data on some factors that would have been very interesting to analyse such as preference of super market, contents of average shopping basket/ average spending on different types of food, number of takeaways/ meals out per week and average number or meals cooked at home. The data exists but it wasn’t available to us in detailed raw form. We could only find fragments of what we needed in reports or articles with no lead to the complete and original source. In the few cases where it was available this was only for the whole of the UK or by Region thus were unusable for this particular project because we chose to focus on variations within London. Another obstacle we encountered in selecting our data was consistency. For our results to be reliable and current we needed to find the most recent data possible all from the same year. However, this was not possible unfortunately. Thus we selected data from 2013/14 to 2015, the most current year available.
References (for coding the datatable on this page)
December, J. (2017). Neutrals Hex Color Codes: Hexadecimal codes for named colors used in HTML page features. [online] December.com. Available at: http://www.december.com/html/spec/color0.html [Accessed 18 Jan. 2017].
W3schools.com. (2017). HTML col tag. [online] Available at: http://www.w3schools.com/tags/tag_col.asp [Accessed 18 Jan. 2017].
WordPress tips. (2017). Table coding for wordpress.com users. [online] Available at: https://wpbtips.wordpress.com/2013/04/09/table-coding-for-wordpress-com-users/ [Accessed 18 Jan. 2017].