Demo: Agency Budget Summary

From Data-gov Wiki

live demo here

Facts about this Demonstration

Live Demo(s)	http://data-gov.tw.rpi.edu/demo/linked/demo-401-budget-summary.php
Video Demo(s)
Data.gov Data source(s)	Dataset 401 Dataset 402 (Public Budget Database - Outlays and offsetting receipts 1962-Current, Executive Office of the President) Dataset 403 (Public Budget Database - Governmental receipts 1962-Current, Executive Office of the President) Dataset 92 (Data.gov Catalog - Complete, Executive Office of the President)
Other Data source(s)
Technology Used	RDF SPARQL SparqlProxy Google Visualization API
Related SPARQL	http://data-gov.tw.rpi.edu/demo/linked/demo-401-budget-summary-sparql.php?agency=National+Science+Foundataion http://data-gov.tw.rpi.edu/demo/linked/demo-401-budget-summary-info-sparql.php?agency=National+Science+Foundataion
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 .
  }
}