= Townsend

Tags: [[Data_Category]]

== Heading

Building of the Postcode_Townsend_Scores

First I downloaded and imported the Townsend_Scores and LSOA data
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]]

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