Organization
For over 500 years we’ve been based in the London boroughs of Lambeth and Southwark. We focus on tackling complex health issues that are prevalent locally but also relevant to other urban areas across the UK and internationally.
How we do it:
Working in partnership – from grassroots organisations to public sector bodies and commercial businesses, we work with a range of partners to tackle major health challenges in urban areas. We take a place-based approach by supporting and layering up different projects and ideas at varying scales. We co-produce projects, bring in experts, and provide financial, strategic and practical support to learn what works, test solutions and share knowledge.
Supporting Guy's and St Thomas' NHS Foundation Trust to provide exceptional care – we fundraise to help ensure staff are supported to be the very best, and that patients have a world-class experience.
https://www.gsttcharity.org.uk/
Project Information
We need beautifully designed dashboards that can explain the nature and causes of childhood obesity in the UK, with a focus on Lambeth and Southwark
Call-to-Action
Background
Guy's and St Thomas' Charity is an independent, place-based foundation working to improve the health of people in the London boroughs of Lambeth and Southwark. To achieve this, they are concentrating on a small number of programmes focused on key health issues. They want to test and demonstrate how the coordinated layering of interventions within a geography can have a step-change impact.
In this project we are focusing on childhood obesity in Lambeth and Southwark.
What is our childhood obesity programme?
We are running a ten-year programme to improve children’s health in urban areas by tackling childhood obesity.
Childhood obesity is a complex global issue and a major challenge in London, which has the highest rates of any global city. It is also a particular issue in the London boroughs of Lambeth and Southwark – where we work – which have some of the highest rates in the country. Still, although the issue is complex, we believe solutions don't have to be.
How does our programme work in practice?
We partner with other organisations to deliver projects, conduct research and amplify our results.
As food environments are influenced by businesses, government and our own communities, creating change requires working with a wide range of partners. In practice, this means we layer up different activities and work with a range of organisations to test and run projects that can tackle the issue from many angles. Given the clear link between an area’s average income and obesity, we focus our efforts in the areas with lower average incomes, where childhood obesity rates are highest.
The projects and activities within our programme focus on three areas to make sure children and families can live healthy lives: streets, schools and homes. This means that we work across these different environments in order to make an impact on closing the childhood obesity inequality gap.
Why we need help Viz for Social Good?
The aim of this project is for Guy’s & St Thomas’ Charity to understand where to target its resources and which areas to fund in the London boroughs of Lambeth and Southwark, to help childhood obesity levels and its effects. This will involve:
• identifying places most (and least) affected by childhood obesity
• identifying who lives in the areas, using a range of socio demographic data
• identifying what the contributing factors are. e.g. by exploring pollutant concentration levels, emissions data and sources of emissions with a particular focus on traffic and time
• identifying how the childhood obesity has evolved over time
• Identifying neighborhoods across the UK that have similar characteristics to neighborhoods in Lambeth and Southwark with high obesity rates.
Audience
The aim of this project is for Guy’s & St Thomas’ Charity to understand where to target its resources and which areas to fund in the London boroughs of Lambeth and Southwark.
The audience are therefore key decision makers within the charity and other organizations – private, public and social - that we might partner with.
Use of Data Visualization
Selected visualisations will be shared internally using Tableau Online and externally through our website, social media and Tableau Public. (We are welcome any tools in addition to Tableau.)
Data
There are 3 tables, one contains a lot of data on the sociodemographic side while the other 2 contain Year 6 & Reception obesity rates over time. There is a preference for them to use Year 6, but you are welcome to explore either.
All the data is a row per LSOA - These are UK statistical areas used and defined during the census, they are approx. 1000 people. It should be noted that some data has been aggregated down, and that explains the duplicates. This is from MSOA, which is the next level of the Hierarchy. LSOAs fit perfectly into MSOA, and can be traced to each other. For example, Southwark 003A (LSOA) is within Southwark 003 that is within Southwark. All the data is within England.
Within the Viz for Social good Table, all columns are different fields. Whereas the obesity data, each field is a year. The fields are all explained in the corresponding data dictionary that is also attached
The data is 170,000 rows by 118 Columns. The Obesity data is 7000 by 42. The obesity data currently contains a few different measurements for years though
The Main sociodemographics data's years are all in the Data Dictionary, it should be noted that these don't really matter as they are the most up to date version of those that exist currently.
All the data is CSV.
How to Participate
Sign up as a volunteer, if you haven’t.
Use the hashtag #VizforSocialGood on Twitter (or Linkedin) to submit your visualization(s) and a link (if applicable).
Mention @VizFSG and @GSTTCharity.
Deadline
12/31/2019 (11:59 pm PST).