Demo: Agency Budget Summary

From Data-gov Wiki

Jump to: navigation, search

Infobox (legacy demo) edit with form
  • name: Demo: Agency Budget Summary

  • description: Timeline for an agency's aggregated budget from 1976 to 2014. At most three sources will be plotted, and the data.gov catalog was linked to get the title of sources.
  • creator(s): Li Ding,Sarah Magidson
  • created: December 12,2009
  • modified: 2010-5-17

live demo here

Facts about this Demonstration

Live Demo(s)
Video Demo(s)
Data.gov Data source(s)
Other Data source(s)
Technology Used
Related SPARQL
Related Demo(s)


interesting observations

This uses SPARQL to combine data from dataset 401, dataset 402, dataset 401 and dataset 92 which show the budget authority (money allocated by Congress), outlays (actual expenses), recipient by various government accounts from 1976 to 2014, respectively (values from the present to 2014 are projected). This visualization shows budget authority and outlays for the selected agency, with each line labeled according to its source data file.

Technology highlights

A SPARQL query can get the name of a dataset from Dataset 92 (Data.gov Catalog - Complete, Executive Office of the President):

PREFIX dgp92:  <http://data-gov.tw.rpi.edu/vocab/p/92/>
PREFIX dgp401: <http://data-gov.tw.rpi.edu/vocab/p/401/>
PREFIX dc:     <http://purl.org/dc/elements/1.1/>

SELECT distinct ?graph ?title ?url
WHERE {  
  GRAPH ?graph {	
         ?s     dc:source          ?source .
         ?entry dgp401:bureau_name "National Science Foundataion" .
  }
  GRAPH <http://data-gov.tw.rpi.edu/vocab/Dataset_92> {
         ?aa dgp92:csv_txt_access_point ?source;
             dgp92:title                ?title;
             dgp92:url                  ?url .
  }
}
Personal tools
internal pages