The Data

 

Factor Year Provider Links
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)**

data

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].

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s