= Townsend

Tags: [[Data_Category]]

== Heading

Building of the Postcode_Townsend_Scores

First I downloaded and imported the Townsend_Scores and LSOA data for Scores based on 2001 census
From [[http://www.apho.org.uk/resource/item.aspx?RID=47506|Public Health England]]
Then I downloaded and imported the LSOA to Postcode lookup CSV file 
From [[https://geoportal.statistics.gov.uk/geoportal/catalog/search/resource/details.page?uuid=%7B18444B52-47C2-40FE-8003-92230C344598%7D|Office for National Statistics]]
[[br]]
----
> ''Note: There are scripts which may be useful in generating the Scores based on 2011 Census available form [[https://github.com/philmikejones/townsendr|GitHub]] [[br]]
> However these are written in R programming language, Chris in the Stats team is familiar with R and may be able to help get the scripts going. For now we'll go with the 2001 scores and revisit that later.''[[br]]
----

Once imported to UHLSQLPRIME01\UHLBRICCSDB.reporting database as tables TownsendScores and PC_LSOA I created a View joining the both with the distinct listing of postcodes within the Genvasc study.



.dbo.Postcode_Townsend_Scores
Then I joined then to match up the lot :-)

 
[[BackLinks]]