Dataset 401

From Data-gov Wiki

Jump to: navigation, search

NOTES: .

Metadata
  • Title: Public_Budget_Database_-_Budget_Authority_and_offsetting_receipts_1976-Current
  • Publisher: Executive Office of the President
  • Description: This file contains historical budget authority and offsetting receipts for 1976 through the current budget year, as well as four years of projections. It can be used to reproduce many of the totals published in the Budget and examine unpublished details below the levels of aggregation published in the Budget.
  • Keywords: Budget, Budget Authority, OMB, Budget Accounts, OMB Accounts
  • Homepage: http://www.data.gov/details/401
  • Source: http://data-gov.tw.rpi.edu/raw/92/data-92.rdf#entry401
  • Parent Dataset:
RDF data
Links

Sample Data

	<rdf:Description rdf:about="#entry3027">
	<account_code>4012</account_code>
	<account_name>Service-disabled Veterans Insurance Fund</account_name>
	<agency_code>29</agency_code>
	<agency_name>Department of Veterans Affairs</agency_name>
	<bea_category>Mandatory</bea_category>
	<bureau_code>25</bureau_code>
	<bureau_name>Benefits Programs</bureau_name>
	<on_or_off_budget>On-budget</on_or_off_budget>
	<subfunction_code>701</subfunction_code>
	<subfunction_title>Income security for veterans</subfunction_title>
	<treasury_agency_code>36</treasury_agency_code>
	<tq>0</tq>
	<num1976>0</num1976>
	<num1977>0</num1977>
	<num1978>0</num1978>
	<num1979>0</num1979>
	<num1980>0</num1980>
	<num1981>0</num1981>
	<num1982>0</num1982>
	<num1983>0</num1983>
	<num1984>0</num1984>
	<num1985>0</num1985>
	<num1986>0</num1986>
	<num1987>0</num1987>
	<num1988>0</num1988>
	<num1989>0</num1989>
	<num1990>0</num1990>
	<num1991>0</num1991>
	<num1992>0</num1992>
	<num1993>0</num1993>
	<num1994>0</num1994>
	<num1995>0</num1995>
	<num1996>0</num1996>
	<num1997>0</num1997>
	<num1998>0</num1998>
	<num1999>-10000</num1999>
	<num2000>7000</num2000>
	<num2001>8000</num2001>
	<num2002>5000</num2002>
	<num2003>0</num2003>
	<num2004>0</num2004>
	<num2005>0</num2005>
	<num2006>0</num2006>
	<num2007>0</num2007>
	<num2008>0</num2008>
	<num2009>0</num2009>
	<num2010>0</num2010>
	<num2011>1000</num2011>
	<num2012>0</num2012>
	<num2013>0</num2013>
	<num2014>0</num2014>
	<rdf:type rdf:resource="http://data-gov.tw.rpi.edu/2009/data-gov-twc.rdf#DataEntry"/>
</rdf:Description>

Sample Query

Sum the budget related to wild fire fighting

tested on TDB Triple Store and Virtuoso Triple Store.

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)) ?agency
WHERE 
{GRAPH <http://data-gov.tw.rpi.edu/vocab/Dataset_401>
{
 # 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/account_name> ?account_name.
  ?s  <http://data-gov.tw.rpi.edu/vocab/p/401/bureau_name> ?bureau.
  ?s <http://data-gov.tw.rpi.edu/vocab/p/401/agency_name> ?agency . 
  filter (regex(?account_name,"Wildland Fire"))
 }
 ?s ?p ?o.
}
}
group by ?p ?agency
Facts about Dataset 401RDF feed
92/agencyExecutive Office of the President  +
92/agency data series pagehttp://www.whitehouse.gov/omb/budget/Supplemental/  +
92/agency program pagehttp://www.whitehouse.gov/omb/budget/  +
92/applicable agency information quality guideline designationOMB
92/categoryFederal Government Finances and Employment  +
92/citationHttp://www.whitehouse.gov/omb/budget/  +
92/collection modeperson/computer
92/csv txt access pointhttp://www.whitehouse.gov/sites/default/files/omb/budget/fy2012/assets/budauth.csv  +
92/csv txt file size1 MB  +
92/data collection instrumenthttp://www.whitehouse.gov/omb/circulars_a11_current_year_a11_toc/
92/data dictionary variable listhttp://www.whitehouse.gov/sites/default/files/omb/budget/fy2012/assets/db_guide.pdf  +
92/data gov data category typeRaw Data Catalog  +
92/data quality certificationYes  +
92/date released2/14/2011  +
92/date updated2/14/2011  +
92/descriptionThis file contains historical budget autho This file contains historical budget authority and offsetting receipts for 1976 through the current budget year, as well as four years of projections. It can be used to reproduce many of the totals published in the Budget and examine unpublished details below the levels of aggregation published in the Budget. ls of aggregation published in the Budget.
92/frequencyannual  +
92/geographic coverageNational (US)
92/granularityNational (US)  +
92/keywordsBudget, Budget Authority, OMB, Budget Accounts, OMB Accounts
92/privacy and confidentialityYes  +
92/specialized data category designationAdministrative
92/subagencyOffice of Management and Budget  +
92/technical documentationhttp://www.whitehouse.gov/sites/default/files/omb/budget/fy2012/assets/db_guide.pdf
92/time period1976-2016
92/titlePublic Budget Database - Budget Authority and offsetting receipts 1976-Current  +
92/unique id401  +
92/unit of analysisbudget account
92/urlhttp://www.data.gov/details/401  +
92/xls access pointhttp://www.whitehouse.gov/sites/default/files/omb/budget/fy2012/assets/budauth.xls  +
92/xls file size2 MB  +
Datagov id401  +
Dc:identifierdgtwc401  +
Dcterms:identifierdgtwc401, and datagov401
Dcterms:publisherExecutive Office of the President  +
Dcterms:relationURLSHA1/b9688dc0c1c001c1da44c0930004eb9a01709d7e  +, and URLSHA1/4a51b0a2dc033c3029854bd056bdd193d2014c53  +
Dcterms:sourceHttp://data-gov.tw.rpi.edu/raw/92/data-92.rdf  +
Dcterms:subjectBudget  +, Budget Authority  +, OMB  +, Budget Accounts  +, and OMB Accounts  +
Dgtwc:complete datahttp://data-gov.tw.rpi.edu/raw/401/data-401.nt.gz  +, and http://data-gov.tw.rpi.edu/raw/401/data-401.rdf  +
Dgtwc:linked data entry pointHttp://data-gov.tw.rpi.edu/vocab/Dataset 401  +
Dgtwc:more datahttp://data-gov.tw.rpi.edu/linked/401/agency_40123.rdf  +, and http://data-gov.tw.rpi.edu/linked/us_agencies.rdf  +
Dgtwc:number of entries3,993  +
Dgtwc:number of properties51  +
Dgtwc:number of triples207,513  +
Dgtwc:uses property401/bureau code  +, 401/num1998  +, 401/num2013  +, 401/agency code  +, 401/num1984  +, 401/num2012  +, 401/bureau name  +, 401/num1983  +, 401/on or off budget  +, 401/num1989  +, 401/treasury agency code  +, 401/num2004  +, 401/account code  +, 401/num2003  +, 401/num1995  +, 401/num2008  +, 401/num1994  +, 401/num2007  +, 401/num1977  +, 401/num1980  +, 401/num1976  +, 401/num1986  +, 401/num2014  +, 401/num1985  +, 401/subfunction title  +, 401/agency name  +, 401/num2000  +, 401/tq  +, 401/num2006  +, 401/num1991  +, 401/num2005  +, 401/num1990  +, 401/num1997  +, 401/num2009  +, 401/num1996  +, 401/num1979  +, 401/num2011  +, 401/num1982  +, 401/num1978  +, 401/num2010  +, 401/num1981  +, 401/num1988  +, 401/num1987  +, 401/num2002  +, 401/account name  +, 401/num2001  +, 401/bea category  +, 401/num1993  +, 401/subfunction code  +, 401/num1992  +, and 401/num1999  +
Dgtwc id401  +
Foaf:namePublic_Budget_Database_-_Budget_Authority_and_offsetting_receipts_1976-Current
Has demoDemo: Agency Budget Comparison  +, Demo: Agency Budget Summary  +, Demo: Linking Agency Budgets and New York Times News  +, Demo: Linking USPS Spending and News  +, Demo: Linking Wildland Fire and Government Budget  +, Demo: Supreme Court Justices Decision Making  +, and Demo: US Agency Budget Browser  +
Rdfs:seeAlsoHttp://data-gov.tw.rpi.edu/raw/401/index.rdf  +
Personal tools
internal pages