finance icon

Finance Python Library

From the CORGIS Dataset Project

By Austin Cory Bart acbart@vt.edu, Joung Min Choi joungmin@vt.edu, Bo Guan jasonguan0107@vt.edu
Version 3.0.0, created 10/7/2021
Tags: finance, government, expenditure, charges, money, united states, us

Overview

The Annual Survey of State Government Finances provides a comprehensive summary of the annual survey findings for state governments, as well as data for individual states. The data contain detail of revenue by source, expenditure by object and function, indebtedness by term, and assets by purpose. This data goes back for almost two decades across every date. (1992 - 2019)

https://www.census.gov/programs-surveys/state.html

Explore Structure

Each row represents Government finance report for each state in a given year.

Index Type Example Value
0 dict { }
1 dict (same structure)
2 dict (same structure)
... ... ...
Key Type Example Value Description
"State" str "ALABAMA" The state that this report was made for (full name, not the two letter abbreviation).
"Year" int 1992 The year that this report was made for.
"Totals" dict { }
"Details" dict { }
Key Type Example Value Description
"Capital outlay" int 664748 Direct expenditure for contract or force account construction of buildings,grounds, and other improvements, and purchase of equipment, land, and existing structures. Includes amounts for additions, replacements, and major alterations to fixed works and structures. However, expenditure for repairs to such works and structures is classified as current operation expenditure.
"Revenue" int 10536166 All amounts of money received by a government from external sources--net of refunds and other correcting transactions--other than from issuance of debt, liquidation of investments, and as agency and private trust transactions. Note that revenue excludes noncash transactions such as receipt of services, commodities, or other "receipts in kind."
"Expenditure" int 9650515 All amounts of money paid out by a government--net of recoveries and other correcting transactions--other than for retirement of debt, investment in securities, extension of credit, or as agency transactions. Note that expenditure includes only external transactions of a government and excludes non-cash transactions such as the provision of perquisites or other payments in kind.
"General expenditure" int 8788293 Amounts paid to other governments as fiscal aid in the form of shared revenues and grants-in-aid, as reimbursements for performance of general government activities and for specific services for the paying government, or in lieu of taxes. Excludes amounts paid to other governments for purchase of commodities, property, or utility services, any tax imposed and paid as such, and employer contributions for social insurance - e.g., contributions to the Federal Government for Old Age, Survivors', Disability, and Health Insurance for government employees.
"General revenue" int 8910315 All government revenue except Liquor stores revenue, Insurance trust revenue, and Utility revenue. The basis for distinction is not the fund or administrative unit receiving particular amounts, but rather the nature of the revenue sources concerned.
"Insurance trust revenue" int 1473217 Revenue from contributions required of employers and employees for financing social insurance programs operated by the government (see Insurance trust system, below) and earnings on assets held for such systems. Excludes any contributions by a government - either as employer contributions or for general financial support - to a social insurance system it administers. Note that tax proceeds, donations, and any forms of revenue other than those enumerated above are classified as general revenue, even though such amounts may be received specifically for insurance trust purposes.
"Intergovernmental" int 2737180 Amounts received from other governments as fiscal aid in the form of shared revenues and grants-in -aid, as reimbursements for performance of general government functions and specific services for the paying government (e.g., care of prisoners or contractual research), or in lieu of taxes, Excludes amounts received from other governments for sale of property, commodities, and utility services. All intergovernmental revenue is classified as General revenue.
"License tax" int 395202 Taxes exacted (either for revenue raising or for regulation) as a condition to the exercise of a business or nonbusiness privilege, at a flat rate or measured by such bases as capital stock, capital surplus, number of business units, or capacity. Excludes taxes measured directly by transactions, gross or net income, or value of property except those to which only nominal rates apply. "License" based on these latter measures, other than those at nominal rates, are classified according to the measure concerned. Includes "fees" related to licensing activities - automobile inspection, gasoline and oil inspection, professional examinations and licenses, etc. - as well as license taxes producing substantial revenue.
"Selective sales tax" int 1103368 Sales and gross receipts taxes imposed on sales of particular commodities or services or gross receipts of particular businesses, separately and apart from the application of general sales and gross receipts taxes. Specific selective sales taxes included are alcoholic beverages, amusements, insurance, motor fuels, parimutuels, public utilities, tobacco products, and others.
"Tax" int 4217916 Compulsory contributions exacted by a government for public purposes except employee and employee assessments for retirement and social insurance purposes, which are classified as insurance trust revenue. All tax revenue is classified as general revenue and comprises amounts received (including interest and penalties but excluding protested amounts and refunds) from all taxes imposed by a government. Note that local government tax revenue excludes any amounts from shares of state-imposed and collected taxes, which are classified as Intergovernmental revenue.
" Debt at end of fiscal year" int 4128724 Amount of debt in the 12-month period at the end of which the government or any government agency determines its financial condition and the results of its operations and closes its books
Key Type Example Value Description
"Correction" dict { }
"Education" dict { }
"Financial Aid" dict { }
"Health" dict { }
"Intergovernmental" dict { }
"Natural Resources" dict { }
"Utilities" dict { }
"Welfare" dict { }
"Transportation" dict { }
"Insurance benefits and repayments" int 724852 Amount of social insurance payments to beneficiaries, employee-retirement annuities and other benefits, and withdrawals of insurance or employee retirement contributions
"Interest on debt" int 280179 Amount of interest from all the debt
"Interest on general debt" int 280179 Amount of interest from all debt other than that identified as having been issued specifically for utility purposes
"Miscellaneous general revenue" int 607453 General revenue other than taxes and intergovernmental revenue
"Other taxes" int 205227 Amount of taxes not listed separately
"Police protection" int 77789 Amounts of money spent on preservation of law and order and traffic safety
Key Type Example Value Description
"Correction Total" int 182698 Total amount spent on correctional purposes, such as prisons.
Key Type Example Value Description
"Education Total" int 3570524 Total amount spent on schools, colleges, and other educational institutions (e.g., for blind, deaf, and other handicapped individuals), and educational programs for adults, veterans, and other special classes. State institutions of higher education includes activities of institutions operated by the state, except that agricultural extension services and experiment stations are classified under Natural resources and hospitals serving the public are classified under Hospitals. Revenue and expenditure for dormitories, cafeterias, athletic events, bookstores, and other auxiliary enterprises financed mainly through charges for services are reported on a gross basis.
Key Type Example Value Description
"Assistance and Subsidies" int 273050 Total amount spent on cash contributions and subsidies to persons, not in payments for goods or services or claims against the government. For local governments, this object category comprises only direct cash assistance payments to public welfare recipients. For states, it includes also veterans' bonuses and direct cash grants for tuition, scholarships, and aid to nonpublic education institutions.
"Cash and Securities Total" int 14594322 Total amount spent on cash and deposits and governmental and private securities (bonds, notes, mortgages, corporate stocks, etc., including loans and other credit paper held by state loan and investment funds) except holdings of agency and private trust funds. Includes fund investments in securities issued by government concerned but does not include interfund loans, receivables, and the value of real property and other fixed assets.
Key Type Example Value Description
"Health Total Expenditure" int 394119 Total amount spent on outpatient health services, other than hospital care, including: public health administration; research and education; categorical health programs; treatment and immunization clinics; nursing; environmental health activities such as air and water pollution control; ambulance service if provided separately from fire protection services, and other general public health activities such as mosquito abatement. School health services provided by health agencies (rather than school agencies) are included here. Sewage treatment operations are classified under Sewerage.
Key Type Example Value Description
"Intergovernmental Expenditure" int 2143312 Money paid overall.
"Intergovernmental to Combined and Unallocable" int 518611 Other kinds of money.
Key Type Example Value Description
"Natural Resources Construction" int 151432 Total amount spent on construction for the support of natural resources.
"Parks" dict { }
Key Type Example Value Description
"Utilities Current Operation" int 5564374 Amount spent on current operation of government owned and operated water supply, electric light and power, gas supply, or transit system. Government revenue, expenditure, and debt relating to utility facilities leased to other governments or persons, and other commercial type activities of governments, such as port facilities, airports, housing projects, radio stations, steam plants, ferries, abattoirs, etc., are classified as general government activities.
Key Type Example Value Description
"Welfare Institution Total Expenditure" int 1853436 Total amount spent on welfare institutions.
Key Type Example Value Description
"Parks Total Expenditure" int 9728 Total amount spent on provision and support of recreational and cultural-scientific facilities and activities including golf courses, play fields, playgrounds, public beaches, swimming pools, tennis courts, parks, auditoriums, stadiums, auto camps, recreation piers, marinas, botanical gardens, galleries, museums, and zoos. Also includes building and operation of convention centers and exhibition halls. Public libraries are included under Libraries.
Key Type Example Value Description
"Highways" dict { }
Key Type Example Value Description
"Highways Total Expenditure" int 694874 Total amount spent on the support of construction, maintenance, and operation of highways, streets, and related structures, including toll highways, bridges, tunnels, ferries, street lighting and snow and ice removal. However, highway policing and traffic control are classed under Police protection.

Downloads

Download all of the following files.

  1. finance.py
  2. finance.data

Usage

import finance
record = finance.get_record()

Documentation

get_record()
Returns a list of dictionaries representing record.