Changes between Version 1 and Version 2 of Townsend Deprivation Index


Ignore:
Timestamp:
07/18/16 12:17:27 (8 years ago)
Author:
dan.lawday
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • Townsend Deprivation Index

    v1 v2  
    77Building of the Postcode_Townsend_Scores
    88
    9 First I downloaded and imported the Townsend_Scores and LSOA data
     9First I downloaded and imported the Townsend_Scores and LSOA data for Scores based on 2001 census
    1010From [[http://www.apho.org.uk/resource/item.aspx?RID=47506|Public Health England]]
    1111Then I downloaded and imported the LSOA to Postcode lookup CSV file
    1212From [[https://geoportal.statistics.gov.uk/geoportal/catalog/search/resource/details.page?uuid=%7B18444B52-47C2-40FE-8003-92230C344598%7D|Office for National Statistics]]
     13[[br]]
     14----
     15> ''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]]
     16> 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]]
     17----
    1318
    1419Once 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.