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.
Usage
import finance
record = finance.get_record()
Documentation
- get_record()
- Returns a list of dictionaries representing record.