[an error occurred while processing this directive]

DOCUMENTATION FOR
ELEMENTARY-SECONDARY SCHOOL SYSTEM FINANCE DATA FILES
SELECTED DATA AS DISPLAYED IN STATISTICAL TABLES
FOR FISCAL YEARS 1993-1996

(UTILIZING U.S. CENSUS BUREAU FORM F-33)

back to Public Education Finances page

The files described below contain financial information for public elementary-secondary school systems as displayed in tables 15, 16, and 17 of the Statistical Tables for Public Elementary-Secondary Education Finances: 1993-94, 1994-95, and 1995-96 (available only directly through Census Bureau's Governments Division or via the Internet) and in tables 21, 22, and 23 in the Census Bureau publication 'Public Education Finances: 1992-93' (GF/93-10).

Table 15 (21 in 1993) provides revenue, expenditure, debt, and enrollment data, while tables 16 and 17 (22 and 23 in 1993) provide percent distribution of revenues and per pupil expenditure data.

This documentation provides a brief identification of the data items, their location in the tables, and field names. For complete information about public elementary-secondary school system file data, please see the complete file documentation and the introductory and explanatory text that accompanies the statistical tables. Following the file layout description, formulas show the data items from the complete data file used to calculate the selected data items contained in these files.

Unlike the statistical tables, these files include all elementary-secondary school systems from the complete data file, regardless of enrollment size.

Federal Information Processing System (FIPS) geographic information is provided in these files. Information about matching counties to their codes is available from the Census Bureau's web site under State and County Demographic and Economic Profiles.

For further information about these files or the survey by which these data are collected, contact the F-33 staff by e-mail at elsec@census.gov, by telephone at 1-800-622-6193, or by regular mail at:

Elementary-Secondary Education Statistics Branch
Governments Division
U.S. Census Bureau
Washington, DC 20233-6800
            ******************************************


DATA FILE FORMAT

The files are comma delimited ASCII files, with alphanumeric data 
enclosed in double quotes ["].  The first record of each file contains
the field names referenced in the FILE LAYOUT section below. 

The data have been divided into three files to limit the number of 
records in each file, which should allow users to import data into 
most spreadsheet or database software packages.  These files are 
divided as follows: 
     Alabama through Massachusetts (including the District of Columbia)
     Michigan through North Dakota
     Ohio through Wyoming

If possible when importing the comma delimited files into a spreadsheet
or database, specify the format of the following fields as 'text' 
(rather than 'numeric'):  GOVSID and FIPS.

            ******************************************


DATA FILE NAMES AND SIZES
 
  FY 1993 Data files:  94tal-ma.txt  (1.5 MB)
                       94tmi-nd.txt  (1.3 MB)
                       94toh-wy.txt  (1.3 MB)

  FY 1994 Data files:  94tal-ma.txt  (1.3 MB)
                       94tmi-nd.txt  (1.3 MB)
                       94toh-wy.txt  (1.3 MB)
 
  FY 1995 Data files:  95tal-ma.txt  (1.6 MB)
                       95tmi-nd.txt  (1.4 MB)
                       95toh-wy.txt  (1.5 MB)

  FY 1996 Data files:  96tal-ma.txt  (1.6 MB)
                       96tmi-nd.txt  (1.4 MB)
                       96toh-wy.txt  (1.5 MB)


            ******************************************


FILE LAYOUT

An asterisk (*) next to the field name denotes an alphanumeric 
character string; all others items are numeric.  With the exception of fall 
membership, data for table 15 are expressed in thousands of dollars, 
table 16 in percent, and table 17 in dollars.  Fall membership 
(enrollment) data are in whole numbers. 

                                                             Same data
                                          Table,   Field     in larger
F-33 Item Description                     Column   Name        file

School System Identification Number......          GOVSID *      
FIPS Codes...............................          FIPS   *  
  State (characters 1 - 2) 
  County (characters 3 - 5)
  SMSA (characters 6 - 9)
  CMSA (characters 10 - 11)
School System Name.......................          NAME   *      X

Fall Membership..........................  15,1    ENROLL        X
                                           17,1
 
TABLE 15 DATA
(Data are shown as thousands of dollars)

TOTAL GENERAL REVENUE....................  15,2    TOTALREV      X

Total Revenue from Federal Sources.......  15,3    TFEDREV       X
  Federal Chapter 1 Revenue..............  15,4    FEDRCOMP
  Children with disabilities.............  15,5    FEDRHAND
  Child Nutrition Act....................  15,6    FEDRNUTR
  All other federal aid..................  15,7    FEDROTHR

Total Revenue from State Sources.........  15,8    TSTREV        X
  General formula assistance.............  15,9    STRFORM
  Special education programs.............  15,10   STRHAND
  Transportation programs................  15,11   STRTRANS
  All other State revenue................  15,12   STROTHR

Total Revenue from Local Sources.........  15,13   TLOCREV       X
  All taxes..............................  15,14   LOCRTAX
    Property taxes.......................  15,15   LOCRPROP
  Parent government contributions........  15,16   LOCRPAR
  Revenue from cities and counties.......  15,17   LOCRCICO
  Revenue from other school systems......  15,18   LOCROSCH
  Charges................................  15,19   LOCRCHAR
  Other local revenues...................  15,20   LOCROTHR


TOTAL GENERAL EXPENDITURE................  15,21   TOTALEXP      X

Total Current Spending...................  15,22   TCURELSC      X

Salary Exhibits
(Included in Current Spending Above)
  Total salaries and wages...............  15,23   TSALWAGE
  Total employee benefit payments........  15,24   TEMPBENE  


Total Current Spending for Instruction...  15,25   TCURINST      X
  Salaries and Wages for Instruction.....  15,26   TCURISAL
  Employee Benefits for Instruction......  15,27   TCURIBEN

Total Current Spending for Support Svcs..  15,28   TCURSSVC      X
  Pupil support..........................  15,29   TCURSPUP 
  Instructional staff support............  15,30   TCURSSTA 
  General administration.................  15,31   TCURSGEN 
  School administration..................  15,32   TCURSSCH 
  Operation and maintenance of plant.....  15,33   TCURSOTH 

Other Current Spending...................  15,34   TCURONON


Total Capital Outlay Expenditure.........  15,35   TCAPOUT       X

Payments to other governments............  15,36   TPAYOTH

Interest on school system indebtedness...  15,37   TINTRST


DEBT  (LONG TERM)
Outstanding at end of the fiscal year....  15,38   DEBTOUT
  Issued during the fiscal year..........  15,39   LONGISSU
  Retired during the fiscal year.........  15,40   LONGRET
 

TABLE 16 DATA
(Data are shown as percent of total general revenue)

TOTAL GENERAL REVENUE....................  16,1    PCTTOTAL
  Total Revenue from Federal Sources.....  16,2    PCTFTOT
    Federal Chapter 1 Revenue............  16,3    PCTFCOMP
  Total Revenue from State Sources.......  16,4    PCTSTOT
    General formula assistance...........  16,5    PCTSFORM
  Total Revenue from Local Sources.......  16,6    PCTLTOT
    Taxes & parent govt contributions....  16,7    PCTLTAXP
    Revenue from other governments.......  16,8    PCTLOTHG
    Charges..............................  16,9    PCTLCHAR


TABLE 17 DATA
(Data are shown as dollars per pupil)

Total Current Spending (Elem-Sec)........  17,2    PPCSTOT
  Total salaries and wages...............  17,3    PPSALWG
  Total employee benefit payments........  17,4    PPEMPBEN  
  Total Current Spending for Instruction.  17,5    PPITOTAL 
    Salaries and Wages...................  17,6    PPISALWG
    Employee Benefits....................  17,7    PPIEMBEN
  Total Current Spending for Support Svcs  17,8    PPSTOTAL 
    Pupil support........................  17,9    PPSPUPIL 
    Instructional staff support..........  17,10   PPSSTAFF 
    General administration...............  17,11   PPSGENAD 
    School administration................  17,12   PPSSCHAD 

             ******************************************
Fiscal year of data: 1993 1994 1995 1996
Release Date: 10/31/1996 2/28/1997 8/13/1998 6/14/1999
Date of last revision: none 6/4/97 none none

(back to top)

Source: U.S. Census Bureau, Governments Division,
Elementary-Secondary Education Statistics Branch

Created: 05-24-2000
Last revised: October 19 2011