Version 1 (modified by 8 years ago) ( diff ) | ,
---|
Townsend
Tags: Data_Category
Heading
Building of the Postcode_Townsend_Scores
First I downloaded and imported the Townsend_Scores and LSOA data From Public Health England Then I downloaded and imported the LSOA to Postcode lookup CSV file From 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 :-)
Note:
See TracWiki
for help on using the wiki.