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:7:\"warning\";s:8:\"%message\";s:40:\"Creating default object from empty value\";s:5:\"%file\";s:57:\"/data/www/html/drupal/modules/taxonomy/taxonomy.pages.inc\";s:5:\"%line\";i:33;}', 3, '', 'https://logd.tw.rpi.edu/category/keywords/budget', '', '10.0.1.254', 1571025175) in /data/www/html/drupal/includes/database.mysqli.inc on line 134

budget

Interactive Government Receipts Timeline

Description: 
Timelines for comparing government agencies' account earnings from 1962 to 2014
Contributor:

Interesting Observations

The user chooses one or more government account names from a checklist (see Figure 1), and the application will display a timeline of their earnings from 1962 to the present and projected values through 2014 (see Figure about). The data and the accounts on the checklist come from dataset 403, published by the Office of Management and Budget.
Figure 1. The checklist of accounts, the first thing that appears in this demo.
Potential uses of this app include (but of course are not limited to) seeing how much revenue a particular tax or program is generating, how effective it has been over time, comparing programs, or seeing how much money certain government-funded foundations have received.

Technology Highlights

US Agency Budget Browser

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

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: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> 
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
SELECT ?p  sum(xsd:integer (?o)) ?g 
WHERE 
{GRAPH ?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 <http://data-gov.tw.rpi.edu/vocab/p/401/agency_name> "Department of the Interior" . 
  ?s <http://data-gov.tw.rpi.edu/vocab/p/401/bureau_name> "Departmental Offices" . 
  ?s 	<http://data-gov.tw.rpi.edu/vocab/p/401/account_name> ?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: 
Thumbnail: 
Syndicate content

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:333:\"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;budget&#039;, &#039;taxonomy/term/38&#039;, &#039;&#039;, &#039;10.0.1.254&#039;, 0, &#039;dmu6ucbs1rjfefodmkkiqlfpd1&#039;, 62, 1571025175)\";s:5:\"%file\";s:58:\"/data/www/html/drupal/modules/statistics/statistics.module\";s:5:\"%line\";i:63;}', 3, '', 'https://logd.tw.rpi.edu/category/keywords/budget', '' in /data/www/html/drupal/includes/database.mysqli.inc on line 134