Projects/Where Does My Money Go/Data/PESA

= PESA =

Overview

 * 2008 PESA in Google Docs with notes: http://spreadsheets.google.com/ccc?key=rzL54KB4Krsd3Xu74P-lKDA
 * Ditto for 2009-2010 Departmental Budgets: http://spreadsheets.google.com/ccc?key=tAVBxSUFofUc7a_pv7R7rbg

Guides to PESA data:
 * http://www.hm-treasury.gov.uk/d/pesa09_intro.pdf - EXCELLENT
 * p.13 gives a visual guide to data in PESA tables
 * Useful info on acronyms etc: http://www.hm-treasury.gov.uk/spend_plancontrol.htm

See also National Accounts:
 * http://www.statistics.gov.uk/statbase/Product.asp?vlnk=1143&More=N
 * Blue Book: http://www.statistics.gov.uk/downloads/theme_economy/BB08.pdf
 * p.174 has Central Government (basic income and expenditure accounts including total taxes, wages etc)

Plan 2009-07
Started creating tickets on the trac here: http://knowledgeforge.net/okfn/tasks/ (wdmmg component)


 * go through PESA and find out if anything interesting
 * where could we find tax information
 * Look at a specific area: e.g. research subsidies for business (whether in form of tax breaks or direct payment)
 * Investigate a particular department
 * Home Office
 * Work and Pensions
 * Immigration
 * Education

PESA
PESA does not give a very detailed breakdown. For example no answer to:


 * How much did government spend on building hospitals last year
 * How much did they spend on doctors' and managers' salaries
 * Best we get is Medical services / Health research / Central and other health services (Table 6.2)
 * Note we do get street-lights (though only for central govt which isn't very useful)
 * How much does government spend on IT
 * How much contracting did govt do with a particular company last year
 * How much is spent on police officers last year

I think the reason PESA doesn't give a very detailed breakdown is becasue the function are defined by COFOG. COFOG maps to function in PESA as seen in Table 2 here http://www.hm-treasury.gov.uk/d/3(5).pdf for 2004.

The COFOG functions are a mixture of central government spending and local government and so are difficult to break down spending into easy to understand groups. This also makes it tricky to map the COFOG and PESA functions to government departments.

Here is a government explanation of spending by function. http://www.hm-treasury.gov.uk/pes_function.htm

There is a breakdown of what the cofog functions cover in a excel file I have attached to this document.

So there are a few choices about how continue with this project to show government spending:


 * 1) explain Function categories well using a key.
 * 2) rename function to be more friendly.
 * 3) drill down to get more detail so it becomes more relevant at a lower level, but getting down to these levels is difficult/ might not be possible from PESA function categories as it is unclear if they map to department well.
 * 4) Go to the source of the PESA data and see if it can be arranged better:
 * 5) * There is also a government spending databank http://www.hm-treasury.gov.uk/psf_databank.htm that shows givers receipts, expendature, borrowing and debt. The PESA data is taken directly from
 * 6) * the Treasury’s public expenditure A.2 database
 * 7) * the Combined Online Information System (COINS). Departments and the devolved administrations maintain up to nine years of live data depending on the year of the latest Spending Review. This is taken from the first part of http://www.hm-treasury.gov.uk/d/pesa09_annexes.pdf
 * 8) * The people who made the COINS database are http://s15277249.onlinehome-server.info:8081/informationedge/
 * 9) * There is a case study of this work here http://s15277249.onlinehome-server.info:8081/informationedge/index.php?option=com_content&view=article&id=64&Itemid=76
 * 10) To get a detailed breakdown need to move to investigation of individual departments.

Departments
There is a PDF of the Supplementary Budgetary Information (SBI) for every government department at: http://www.hm-treasury.gov.uk/d/sbi0910_fulldoc.pdf (cached here and here) which comes from this page: http://www.hm-treasury.gov.uk/psr_estimates_sbi09-10.htm

This gives accounts and budgets up to 2010 for each department, that seem to be more detailed and humanly understandable than PESA.

I have email requested the tables in this PDF in Excel format.

Work and Pensions

 * Could not find anything useful on DWP site
 * Really good 10 page breakdown of DWP budget: http://www.hm-treasury.gov.uk/d/sbi37_dwp.pdf
 * Unfortunately all in PDF

Education
("Identifiable expenditure on services by function or programme, country and region for 2006-07 (£ million)")
 * http://www.dcsf.gov.uk/aboutus/reports/pdfs/7493-DCSF-AnnualReport.pdf
 * p. 113 more detailed accounts (unfortunately in pdf)
 * p. 119 DCSF broken down by geo, function/subfunction


 * http://www.dcsf.gov.uk/rsgateway/catego.shtml#m1_2_1
 * lots of detailed stuff usually in nice excel. However no obvious budget material

Looking at a Specific Subject Area

 * Energy subsidies
 * http://www.greenpeace.org/raw/content/international/press/reports/SubsidiesReport.pdf - not that relevant as mainly EU related
 * Nothing that simple here (GP stuff not that useful)

Account objects
Based on an analysis of PESA data have the following 'objects':


 * Entities: Central Government, Local Government, Public Corporations
 * Central Government splits into depts
 * Expenditure types:
 * By service/function and subfunctions (using COFOG UN Classifications of Functions of Government mainly)
 * By region/country
 * Spending/Accounting limits for entities:
 * DEL: Dept Exp Limit
 * AME: Annually Managed Expenditure
 * TME: total managed expenditure
 * Procurement spending (what is this?) and many more ...
 * Time (which period is this for ...)