Fiscal Research Center Data Collections

The Fiscal Research Center (FRC) collects and maintains a variety of data sets that are used by our research associates, affiliated faculty and graduate students. This data may be of interest to students, faculty, as well as policymakers, and many external organizations. Below is a list of the data sets maintained by the FRC, as well as information about confidentiality and accessibility. Please contact Lakshmi Pandey at lpandey@gsu.edu with further questions about access to this data.

About: This data set contains case and client level information collected by Georgia Department of Human Services about recipients of Assistance to Families with Dependent Children/Temporary Assistance for Needy Families (AFDC/TANF) and Supplemental Nutritional Assistance Program (SNAP), formerly known as food stamps. Data are compiled from the client application forms. AFDC/TANF is a monthly dataset from March 1998 to the present. We receive updates every few months. SNAP data extends from January 2000 to the present.

The data is broken into three parts: 1. Issuance data containing date of issuance, usually the first of the month, and amount; 2. Case data containing demographic information such as address, county, etc. and household earned and unearned income; and 3. Client data containing age, sex, race, ethnicity, individual income earned and unearned and expenses like day care, etc. A detailed data dictionary is available.

Access: For confidentiality reasons, access is limited to approved FRC staff; however, extracts such as aggregated graphs and tables are available upon request. More detailed extracts with encrypted IDs must receive approval through the Department of Human Services.

Snapshot: Following is a case load and average monthly payment received by AFDC/TANF and SNAP recipients:

SNAP May 2016

About: FRC has all the available summary tables and public use microdata (PUMS) of each centennial census 1990, 2000, and 2010 for all states. We also have annual data from American Community Survey from 2007 to present, and the Tiger data files for 1990, 2000 and 2010 datasets which allow geo-coding of Census data. The FRC has also purchased data from GeoLytics which recodes data from the 1980 census to year 2000 census boundaries to allow geographic comparisons over time.

Access: This is a public access data set in part purchased and in part assembled by the FRC. Andrew Young School students, faculty, or external organizations wishing to use this data can make a request for access from Lakshmi Pandey at the FRC. Please know that the FRC reserves the right to charge a nominal fee for external access as a way to defray the costs of data purchase, assembly and maintenance.

About: The Consumer Expenditure Survey (CE) program consists of two surveys, the Quarterly Interview Survey and the Diary Survey, that provide information on the buying habits of American consumers, including data on their expenditures, income, and consumer unit (families and single consumers) characteristics. The survey data are collected for the Bureau of Labor Statistics by the U.S. Census Bureau. The CE is important because it is the only federal survey to provide information on the complete range of consumers' expenditures and incomes, as well as the characteristics of those consumers.

It is used by economic policymakers examining the impact of policy changes on economic groups, the Census Bureau as the source of thresholds for the Supplemental Poverty Measure, businesses and academic researchers studying consumers' spending habits and trends, other federal agencies, and, perhaps most importantly, to regularly revise the Consumer Price Index market basket of goods and services and their relative importance.

Access: This is public use data, and FRC has the latest 2012 Public-Use Micro Data in SAS format.

About: This is a quarterly data set from Georgia Department Labor. Employment and Wage ES-202 (also referred to as Quarterly Census of Employment and Wages, QCEW) data are derived from reports filed by all employers subject to state and federal unemployment compensation laws. Industry employment and payroll information is produced quarterly. Employment and wage data are available from first quarter of 1977 to the last quarter of 2014.

The data has industry classification codes SIC (Standard Industrial Classification) through 2003 and NAICS (North American Industry Classification System) codes after this year. Typical variables are employer ID, SIC or NAICS, federal; state or private employers; employment in each month of a quarter; and total wages paid against those employees in a quarter. It also has physical location of establishments and two thirds of these addresses can be geocoded in a given quarter. More recently the data has started to include latitude and longitude of the establishment location.

Individual Wages data has just three variables: worker’s SSN, employer ID (as in the ES-202) file and quarterly wages received by that person from that employer. We have this data starting from second quarter of 1986 to fourth quarter of 2014.

Access: Detailed access is limited to approved FRC staff and the data sits on a standalone workstation. A selected aggregate extracts (not individual employer of individual person records) can be provided upon request and also after approval by GADOL. Interested persons should send an email request to lpandey@gsu.edu with his or her information, as well as a brief paragraph about the proposed project for which this data will be used. An extraction free applies to non-FRC staff/affiliated faculty.

Snapshot: The following is a chart of yearly average number of jobs from ES-202 and number of people (unique personal ID) having jobs in Georgia from the Individual Wages data.

ES 202 data

About: The FRC has purchased a data set of federal fund awards by 30 federal agencies.  These agencies are responsible for virtually all financial assistance awards to non-federal government entities including private, and non-profit organizations and in aggregate, to individuals. Awards include grants (such as wastewater treatment grants), direct payments (such as Social Security payments), loans (such as small business and student loans), and insurance commitments (such as for crops and home mortgages).

Exclusions include international transactions, federal wages and salaries, and goods or services purchased for federal government use. Fields include award recipients, assisted projects and financing. Data for recipients include name and geographic location. Data for projects include assistance program name, Catalog of Federal Domestic Assistance (CFDA) number and purpose, and data for financing include amounts of federal and non-federal funding. Most data are presented by type of recipient (such as governments, private organizations and individuals) and summarized by recipient location (such as state or county area).

Access: This is a public access data set purchased by the FRC. Andrew Young School students, faculty or external organizations wishing to use this data can make a request for access from Lakshmi Pandey at the FRC. Please know that the FRC reserves the right to charge a nominal fee for external access as a way to defray the costs of data purchase and maintenance.

About:The Federal Funds Information for the States provides information on federal grants to the states organized by subject category from 1998 to current. The data set focuses on grant-in-aid to state governments but is much cleaner than FAADS or CFFR data. FFIS also provides regular policy updates on federal funding policies that affect these grant in aid programs for the states.

Access: FFIS is a proprietary data service purchased by the Fiscal Research Center. Pursuant to our agreement with FFIS, the data is available only to Andrew Young School students and faculty upon request. However, other state agencies or state employees may be able to access this data through a State of Georgia contract with FFIS.

About: The FRC has collected and organized the Georgia Department of Education DE46 data revenue and expenditure files. The revenue files include disaggregated Georgia school district revenue amounts by fund code, revenue source and educational program. The corresponding expenditure files provide disaggregated expenditure amounts by fund code, function, object purchased and educational program. The school years of 2001 through 2013, provided by the Georgia Department of Education are available. These data allow for both isolating very specific Georgia district revenues and expenditures or for the aggregation of revenue or expenditure categories defined by the user.

Access: This is a public access data set assembled by the FRC. Andrew Young School students, faculty or external organizations wishing to use this data can make a request for access from Lakshmi Pandey at the FRC. Please know that the FRC reserves the right to charge a nominal fee for external access as a way to defray the costs of data purchase and maintenance.

About: FRC has C and S CORP data from 2005 to 2011 (latest complete year). Variables in this data set follow Georgia corporate tax return form 600. Individual income tax data is from 1995 to 2011 (latest complete year) and variables follow Georgia individual tax return form 500. Individual and spouse in case of filing jointly IDs are encrypted, but same encryption method is used for different years of data. Part A and B sales tax data is for the years 2010, 2011 and 2012.

Access: For confidentiality reasons, access is limited to approved FRC staff; however, extracts such as aggregated graphs and tables are available upon request. More detailed extracts with encrypted IDs must receive approval through the Department of Revenue.

About: The Georgia Property Tax Database provides unique information about state and local property tax data as it affects individuals. Until now, the only data available has been that from the Georgia Tax Digest. The digest provides aggregate data on property tax revenues, number of assessed properties, and aggregate assessed values by jurisdiction. Default millage rates are also available from 1990. However, those data provide only a partial picture of the property tax landscape in Georgia. In particular, they do not provide data on the variability in homestead exemptions across local jurisdictions, nor do they provide data on such exemptions as they vary within a jurisdiction by individual characteristics, including age, disability status, veteran status and income.

This unique data set provides these data for the state and for local jurisdictions from 1938 to 2013. In practice, it covers an even longer period, as we verified that there were no state or included local exemptions before 1938, at least back to 1913. Merged with data on millage rates, these data allow one to simulate how much property tax an individual household of a given demographic category would pay in property taxes in a given jurisdiction in a given year in a property with a specified assessed value (assuming the household takes advantage of all exemptions available).

We have this data in STATA and SAS format. Download the brief description and data dictionary.

Access: Fiscal Research Center staff have access to the data. Others should make a request with a brief description of what the data will be used for. Interested persons should send an email request to lpandey@gsu.edu.

FRC has monthly vital statistics data for the period of 1994-2002 from the Department of Human Services. Variables include information about mothers and infants including age, race, ethnicity and pregnancy period. The data was collected from hospital records and has very little about fathers. A data dictionary is available.

Access: For confidentiality reasons, access is limited to approved FRC staff; however, extracts such as aggregated graphs and tables are available upon request. More detailed extracts with encrypted IDs must receive approval through the Department of Human Services.

Snapshot: Following is a chart of live births in Georgia. SNAPSHOTBIRTHS

About: Using classic input-output analysis in combination with regional specific Social Accounting Matrices and Multiplier Models, IMPLAN (IMpact analysis for PLANning) provides a model examining economic interconnections between industries. An example of its use would be to estimate the “multiplier” effects of different public policies. FRC has the latest 2012 data for these states: Alabama, Tennessee, North and South Carolina, Florida and Georgia. The FRC also has data for all the counties in Georgia.

Access: This is a proprietary data model purchased by the FRC, and it is installed on a computer that requires authentication to use the data. Because of the proprietary nature of the data set, external access is limited.

About:

The Fiscal Research Center has purchased the Mergent Municipal Securities Database, which includes daily data updates. This database provides terms and conditions on more than 3.6 million Untied States municipal securities. Due to contractual obligations, this data is kept on a server with limited access that is managed by the Fiscal Research Center. Georgia State University faculty, staff, and students may request extract or access to the Mergent Database by signing the required statement of use.

Georgia State University also has obtained a license to use the CUSIP numbering system for securities, which is the unique identifier code for issuers of securities -- a precondition for the Mergent and Municipal Securities Rulemaking Board (MSRB) databases.

Access:

  • For obtaining access to the Mergent Database, please contact Lakshmi Pandey at lpandey@gsu.edu.
  • For substantive questions about the Mergent Database and the Bloomberg Terminal, please contact Konul Amrahova at kamrahova1@student.gsu.edu.
  • Bart Hildreth serves as the faculty advisor for the municipal securities laboratory. He can be reached at BartHildreth@gsu.edu.

About: Walls & Associates converts Dun & Bradstreet (D&B) archival establishment data into a time-series database of establishment information in the National Establishment Time-Series (NETS) Database. The NETS Database provides longitudinal data on various dynamics in the United States economy that include establishment job creation and loss, sales growth performance, survivability of business startups, mobility patterns, changes in primary markets, corporate affiliations, and historical D&B credit and payment ratings. This data also has information about firms relocating to and from Georgia.

Access: This is a proprietary data set purchased by the FRC. However, extracts or reports based on this information can be generated upon request, and Andrew Young School students or faculty wishing to use this data can make a request for access from the FRC. Interested persons should send an email request to lpandey@gsu.edu  with his or her information, as well as a brief paragraph about the proposed project for which this data will be used. Because of the proprietary nature of the data set, external use is restricted.

About: The Tax Model Files are public use samples of U.S. federal individual income tax returns, with individual identifiers removed and the remaining data sufficiently rounded and blurred to prevent the identification of individual taxpayers. These have been issued since 1960, and they are of special interest to researchers studying the income tax and the distribution of income. The files are poor in demographic information (no age, race or sex variables) but are rich in income information, especially for higher income taxpayers whose incomes are not likely to be accurately covered in survey data. FRC has SOI data for the period of 2006, 2007 and 2008, county level data for 2011 and ZIP code level data for the years 2007, 2008 and 2011. We also have some data on migration information.

Access: For confidentiality reasons, access is limited to approved FRC staff; however, extracts such as aggregated graphs and tables may be available upon request with approval of Georgia Department of Revenue. More detailed extracts with encrypted IDs must receive approval through the Department of Revenue.