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