Federal, State, and Local Governments
Public Elementary-Secondary Education Finance Data
Selected Data as Displayed in Statistical Tables
Technical Documentation (1997-1999)
| Main | Back To Education Finances |
Contents
| Introduction |
The files described below contain financial information for public elementary-secondary school systems as displayed in Tables 15, 16, and 17 of the the Statistical Tables for Public Elementary-Secondary Education Finances: 1997-98, 1998-99, and the 1997 Census of Governments publication Volume 4, No. 1, Public Education Finances. Table 15 provides revenue, expenditure, debt, and enrollment data, Table 16 provides percent distribution of revenues, and Table 17 provides 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.
Unlike the statistical tables, these files include all elementary-secondary school systems from the complete data file, regardless of enrollment size.
| Data File Formats |
The files are comma delimited ASCII files, with alphanumeric data enclosed in double quotes ["]. The first record in each file contains the field names referenced below in the RECORD LAYOUT section.
The data have been divided into three files to limit the number of records in each file. This will enable users to easily import data into most spreadsheet or database software packages. These files are divided by state as follows:
- Alabama through Massachusetts (including the District of Columbia)
- Michigan through North Dakota
- Ohio through Wyoming
When importing the comma delimited files into a spreadsheet or database, data users should specify the format of the following fields as 'text' (rather than 'general' or 'numeric'): GOVSID and FIPS.
| Data File Names and Sizes |
The files may be downloaded from the Census Bureau's web site under Public Elementary-Secondary Education Finance Data. The size of each self-extracting file is 1.9 megabytes (MB).
FY 1999 Data files: 99tal-ma.txt (1.7 MB)
99tmi-nd.txt (1.4 MB)
99toh-wy.txt (1.5 MB)
FY 1998 Data files: 98tal-ma.txt (1.6 MB)
98tmi-nd.txt (1.4 MB)
98toh-wy.txt (1.5 MB)
FY 1997 Data files: 97tal-ma.txt (1.7 MB)
97tmi-nd.txt (1.4 MB)
97toh-wy.txt (1.5 MB)
| Record Layout |
An asterisk (*) next to the position denotes an alphanumeric character string; all other 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 expressed in whole numbers.
Table 15 | Table 16 | Table 17
SCHOOL SYSTEM DESCRIPTIVE INFORMATION:
Same data
Table, Field in larger
F-33 Item Description Column Name file
School System Identification Number...... GOVSID *
FIPS Codes............................... FIPS * \1
State (characters 1 - 2)
County (characters 3 - 5)
SMSA (characters 6 - 9)
CMSA (characters 10 - 11)
School System Name....................... NAME * X
Fall Membership, October 1996 (FY 1997),
October 1997 (FY 1998),
and October 1998 (FY 1999).. 15,1 ENROLL X
17,1
\1 - Information about matching counties to their Federal Information Processing System
or FIPS codes is available from the Census Bureau's web site under State and County Demographic
and Economic Profiles.
Same data
Table, Field in larger
Item Description Column Name file
TOTAL ELEMENTARY-SECONDARY REVENUE....... 15,2 TOTALREV X
Total Revenue from Federal Sources....... 15,3 TFEDREV X
Title I grants......................... 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 ELEMENTARY-SECONDARY EXPENDITURE... 15,21 TOTALEXP X
Total Current Spending................... 15,22 TCURSPND 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
Other and nonspecified................. 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, Field
Item Description Column Name
TOTAL ELEMENTARY-SECONDARY REVENUE....... 16,1 PCTTOTAL
Total Revenue from Federal Sources..... 16,2 PCTFTOT
Title I grants....................... 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, Field
Item Description Column Name
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
| Summary |
| Fiscal year of data: | 1997 | 1998 | 1999 |
|---|---|---|---|
| Release Date: | 6/21/2000 | 6/30/2001 | X/XX/2001 |
| Date of last revision: | none | none | none |