How Does The Queen Get Her Money

Queen visits Scotland

Queen Elizabeth Two during a visit to Culloden Battleground visitors centre near Inverness. Photograph: Danny Lawson/PA

The Queen is running out of money - your coin, that is. Co-ordinate to the latest figures, published today, her reserve of public funds is set to run out by 2012. This has raised expectations that the regime will be asked to increase the civil listing, which pays for the running of the regal household.

The figures are published every year by Buckingham Palace in the least attainable format they tin manage - so we've got them here for you in a way you can do something with.

The key stuff to look out for is where it comes from. The master two sources of her country income are:
• Civil list That's the money the queen gets from the state to cover things like staff costs
• Grant-in-help This covers things like royal trips and maintaining the palaces

Check out the spreadsheet downloadable below equally information technology gives you loads of interesting info, including every royal trip costing over £x,000.

Data: download the full details as a spreadsheet

• Can you do something with this data?
Flickr Please post your visualisations and mash-ups on our Flickr group or mail service u.s. at datastore@guardian.co.united kingdom of great britain and northern ireland

• Go the A-Z of data
• More than at the Datastore directory
• Follow us on Twitter

THE QUEEN'S State FUNDING

Figures in £yard. Click headings to sort
Type of funding	2008, £g	2009, £m	% Alter
SOURCE: BUCKINGHAM PALACE
Civil list	12.7	thirteen.9	9%
Parliamentary annuities	0.4	0.iv	0%
Grants in aid	22	22.half dozen	3%
Government depts	4.9	iv.vi	-6%
Full	40	41.5	iv%

WHERE SHE SPENDS Information technology

Figures in £m. Click headings to sort
Type	2007, £m	2008, £one thousand	% Modify
SOURCE: BUCKINGHAM PALACE
Salaries	9.1	9.nine	9%
Catering and hospitality	1.2	1.1	-8%
Executive & admin	1.2	ane.5	25%
Housekeeping & furnishings	0.6	0.7	17%
Ceremonial functions	0.2	0.4	100%
Other	0.4	0.iii	-25%
Total	12.vii	thirteen.nine	9%

Peak TRAVELING ROYALS

Click headings to sort
Flights over £10,000, royal and staff	COST, £
SOURCE: BUCKINGHAM PALACE
Prince of Wales/Duchess of Cornwall	1651826
Knuckles of York	434543
Queen/Duke of Edinburgh	406140
Duke and Duchess of Gloucester	185988
Princess Majestic	89517
Earl and Countess of Wessex	24470

SPENDING ON GARDEN PARTIES AND PROCESSIONS

Click headings to sort
Cost	2008, £m	2007, £m
SOURCE: BUCKINGHAM PALACE
Garden parties	0.6	0.7
Food and kitchens	0.5	0.5
Recruitment and preparation	0.3	0.iii
Depreciation	0.3	0.iii
Jotter, printing and binding	0.ii	0.one
Computers and data systems	0.4	0.2
Legal communication and other professional person services	0.2	0.two
Travel	0.1	0.i
Housekeeping	0.three	0.3
Furnishings/equipment	0.4	0.3
Carriage processions	0.1
Uniforms/protective habiliment	0.ii	0.i
Motor vehicles	0.ane	0.1