US Agency Budget Browser

browse an agency's budget data (summary and account details) using three Public Budget datasets.

interesting observations

This demo uses SPARQL to combine data from dataset 401 budget authority (money allocated by Congress), dataset 402 budget outlays (actual expenses) and dataset 403 recipient by various government accounts from 1976 to 2014 (values from the present to 2014 are projected).
  • not all agencies show up in all datasets, and a lot of them are not mentioned in Dataset 403 (Public Budget Database - Governmental receipts 1962-2015, Executive Office of the President).
  • there are both positive and negative figures in the budget, further investigations are needed

Example 1
Reforms and Recoveries for Elementary and Secondary Education

Technology highlights

SPARQL queries were used to aggregate data from three datasets
PREFIX rdf: <> 
PREFIX xsd: <>
SELECT ?p  sum(xsd:integer (?o)) ?g 
 # match the specific BGP first, then filter based on account_name. 
 # only join with the completely unbound triple pattern after the filter so that the intermediate result size isn't large.
  ?s <> "Department of the Interior" . 
  ?s <> "Departmental Offices" . 
  ?s 	<> ?account_name.
  filter (regex(?p,"num"))
 ?s ?p ?o.
group by ?g ?p 

Uses Dataset: 
Uses Dataset: 
Uses Dataset: 
Uses Technology: 
Uses Technology: 
Uses Technology: 
Uses Technology: 
No votes yet

Warning: Table './drupal/watchdog' is marked as crashed and last (automatic?) repair failed query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:345:\"Table &#039;./drupal/accesslog&#039; is marked as crashed and last (automatic?) repair failed\nquery: INSERT INTO accesslog (title, path, url, hostname, uid, sid, timer, timestamp) values(&#039;US Agency Budget Browser&#039;, &#039;node/65&#039;, &#039;&#039;, &#039;;, 0, &#039;nu9o6dp5d8c4muhgm5e07agcc4&#039;, 46, 1618685681)\";s:5:\"%file\";s:58:\"/data/www/html/drupal/modules/statistics/statistics.module\";s:5:\"%line\";i:63;}', 3, '', '� in /data/www/html/drupal/includes/ on line 134