Data and information web links, sources, software, tips and hints and other useful stuff for and from the
Leicester & Leicestershire Housing Market Area Managing and Updating of Data project 2010
The final report for this project is available here Leicester&shire_managing&updating_data_project 2010- finalreport.pdf
Full links are shown, and are direct to the useful pages as far as possible . Nobody knows , or remembers, everything out there, so if you have others you find useful please e mail them to bline@stayfree.co.uk to add to this page, and/or share them on the Communities of Practice site
Data sources
Annual Survey of Hours and Earnings http://www.statistics.gov.uk/StatBase/Product.asp?vlnk=13101 N.B. earnings, not household incomes - not the same as more than one earner in households and benefits; - but as a rule of thumb earnings are generally about 70% of household income, overall average
Census Commissioned tables http://www.statistics.gov.uk/census2001/commissioned.asp if standard Census data doesn't give the combinations of variables you want, try these. There is an Excel table finder to help you
CLG statistics by topic http://www.communities.gov.uk/housing/housingresearch/housingstatistics/housingstatisticsby/
Community Health profiles Public Health Observatories http://www.apho.org.uk/default.aspx?QN=P_HEALTH_PROFILES
CORE - RSL and LAs lettings and sales data https://core.tenantservicesauthority.org/
Council of Mortgage Lender statistics http://www.cml.org.uk/cml/statistics
Department of Works and Pensions ( for benefits data) http://statistics.dwp.gov.uk/asd/statistics.asp
DWP tax/benefit model 2010 - amended for estimating Housing Benefit and affordability for rents http://www.blinehousing.info/files/DWPtaxenefitmodel_affssheet_BLineamended_2010.xls
Health Trends - East Midlands PHO http://www.empho.org.uk/default.aspx
Housing Intelligence for the East Midlands (HI4EM) http://www.hi4em.org.uk/ Use the East Midlands Local Authorities panel on the right to navigate to data for your own LA
Household Projections - CLG 2008 based - general http://www.communities.gov.uk/publications/corporate/statistics/2033household1110
detailed tables for further analysis http://www.communities.gov.uk/housing/housingresearch/housingstatistics/housingstatisticsby/householdestimates/detaileddatadownloads/
Housing Strategy Statistical Appendix ( HSSA - used to be HIP returns - latest data may not be on this link, but should be nearby) http://www.communities.gov.uk/documents/housing/xls/1393618.xls
Housing Benefit claimant numbers http://research.dwp.gov.uk/asd/asd1/hb_ctb/index.php?page=hbctb_arc
Intelligence East Midlands http://www.intelligenceeastmidlands.org.uk/content/view/30/38/ - Housing data http://www.intelligenceeastmidlands.org.uk/component/option,com_docman/task,doc_download/gid,394/Itemid,/
Land Registry - house prices http://www1.landregistry.gov.uk/houseprices/housepriceindex/report/ ( HI4EM now has more detailed data)
Leicestershire Statistics and Research Online http://www.lsr-online.org/
Local reference rents - Valuation Office Agency ( incorporating the Rent Service) http://www.voa.gov.uk/publications/LocalRefRents/index.htm https://lha-direct.voa.gov.uk/Secure/CrystalReports/Default.aspx
Migration Indicator Suite http://www.statistics.gov.uk/statbase/Product.asp?vlnk=15239
Ministry of Justice - repossessions http://www.justice.gov.uk/latest-updates/mortgatelandlordpossession.htm
NOMIS - labour market, employment statistics and more https://www.nomisweb.co.uk/Default.asp
ONS Neighbourhood statistics http://neighbourhood.statistics.gov.uk/dissemination/Download1.do and for 'find for an area' http://neighbourhood.statistics.gov.uk/dissemination/LeadHome.do;jessionid=ac1f930c30d89b8adb6db1344631bb7fe9f6d204fb12?m=0&s=1271496953920&enc=1&nsjs=true&nsck=true&nssvg=true&nswid=978 . Much Census data, but also some more up to date like population estimates and benefits
Open Government data - all sorts - www.data.gov.uk
Output Area Classification - data http://areaclassification.org.uk/data/
PANSI Projecting adult needs information service http://www.poppi.org.uk/
POPPI Projecting Older People Population Information http://www.poppi.org.uk/
PRIVATE SECTOR RENTS - Find a Property - http://www.findaproperty.com/areadetails.aspx?edid=00&salerent=1&areaid=1967
SPclientrecord information collected about clients who enter Supporting People services and outcomes https://www.spclientrecord.org.uk/login.cfm
Survey of English Housing - live tables http://www.communities.gov.uk/housing/housingresearch/housingsurveys/surveyofenglishhousing/sehlivetables/
UCAS Student numbers and institutions http://www.ucas.ac.uk/about_us/stat_services/stats_online/
UK housing review ( CIH) http://www.york.ac.uk/res/ukhr/ukhr0708/compendium.htm
Valuation Office Agency - reports give some information on land values http://www.voa.gov.uk/publications/index.htm
Software and resources - mostly free mapping and applications
On line Output Area Classification mapping http://www.casa.ucl.ac.uk/googlemaps/OAC-super-EngScotWales.html
Geographical Information Systems two completely free ones. Quantum GIS http://qgis.org/ and Mapmaker http://www.mapmaker.com/products.htm
Maybe not powerful enough or acceptable for work, but ok to learn principles on if you are interested. You can get free boundary and postcode point data for them to import in .shp format from the site below:-
Ordnance Survey - digitised boundaries, like local authorities, wards, parishes, postcodes points and more are now free http://data.gov.uk/data/list?keyword=ordnance+survey or http://parlvid.mysociety.org:81/os/
ESTAT - Exploratory Spatio-Temporal Analysis Toolkit for 'parallel co-ordinate plots' = how variables relate to each other, including in different locations if you have GIS boundary (.shp) files http://www.geovista.psu.edu/ESTAT/ .
JRF Housing & Neighbourhoods Monitor http://www.hnm.org.uk/index.html
HI4EM has an online mapping function
Openstat - a free statistical analysis application similar to SPSS available here http://statpages.org/miller/openstat/
Other free statistical software http://en.freestatistics.info/stat.php
Tips and hints
Using data and statistics - Intelligence East Midlands http://www.intelligenceeastmidlands.org.uk/content/view/1075/137
Excel tips http://excel.tips.net/
Sample size calculator Sample sizes increase as a proportion the smaller population or subset of it. http://www.surveysystem.com/sscalc.htm
ONS analysis and guidance http://neighbourhood.statistics.gov.uk/dissemination/Info.do;jessionid=ac1f930cce629344f572bc944abb432da2db65a5f92?m=0&s=1224142661708&enc=1&page=analysisandguidance/analysis.htm&nsjs=true&nsck=true&nssvg=true&nswid=989