Dataset 401

From Data-gov Wiki

Jump to: navigation, search


RDF data

Sample Data

	<rdf:Description rdf:about="#entry3027">
	<account_name>Service-disabled Veterans Insurance Fund</account_name>
	<agency_name>Department of Veterans Affairs</agency_name>
	<bureau_name>Benefits Programs</bureau_name>
	<subfunction_title>Income security for veterans</subfunction_title>
	<rdf:type rdf:resource=""/>

Sample Query

Sum the budget related to wild fire fighting

tested on TDB Triple Store and Virtuoso Triple Store.

PREFIX rdf: <> 
PREFIX xsd: <>
SELECT ?p  sum(xsd:integer (?o)) ?agency
 # 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 	<> ?account_name.
  ?s  <> ?bureau.
  ?s <> ?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 page  +
92/agency program page  +
92/applicable agency information quality guideline designationOMB
92/categoryFederal Government Finances and Employment  +
92/collection modeperson/computer
92/csv txt access point  +
92/csv txt file size1 MB  +
92/data collection instrumentHttp:// a11 current year a11 toc/  +
92/data dictionary variable list  +
92/data gov data category typeRaw Data Catalog  +
92/data quality certificationYes  +
92/date released2/14/2011  +
92/date updated2/14/2011  +
92/descriptionwarning.png"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." cannot be used as a page name in this wiki.
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 documentation
92/time period1976-2016
92/titlePublic Budget Database - Budget Authority and offsetting receipts 1976-Current  +
92/unique id401  +
92/unit of analysisbudget account
92/url  +
92/xls access pointHttp://  +
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:source  +
Dcterms:subjectBudget  +, Budget Authority  +, OMB  +, Budget Accounts  +, and OMB Accounts  +
Dgtwc:complete data  +, and  +
Dgtwc:linked data entry point  +
Dgtwc:more data  +, and  +
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  +
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:seeAlso  +
Personal tools
internal pages