Changes between Initial Version and Version 1 of Townsend Deprivation Index


Ignore:
Timestamp:
07/12/16 11:18:45 (9 years ago)
Author:
dan.lawday
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • Townsend Deprivation Index

    v1 v1  
     1= Townsend
     2
     3Tags: [[Data_Category]]
     4
     5== Heading
     6
     7Building of the Postcode_Townsend_Scores
     8
     9First I downloaded and imported the Townsend_Scores and LSOA data
     10From [[http://www.apho.org.uk/resource/item.aspx?RID=47506|Public Health England]]
     11Then I downloaded and imported the LSOA to Postcode lookup CSV file
     12From [[https://geoportal.statistics.gov.uk/geoportal/catalog/search/resource/details.page?uuid=%7B18444B52-47C2-40FE-8003-92230C344598%7D|Office for National Statistics]]
     13
     14Once 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.
     15
     16
     17
     18.dbo.Postcode_Townsend_Scores
     19Then I joined then to match up the lot :-)
     20
     21 
     22[[BackLinks]]