|
Federal, State, and Local Governments
Public Elementary-Secondary Education Finance Data
Selected Data as Displayed in Statistical Tables
Technical Documentation (2000 and 2001)
|
|
Contents
|
| |
| 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: 1999-2000 and 2000-2001. 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 introduction and
appendices that accompany the statistical tables.
|
| |
|
Unlike the statistical tables, these files include all elementary-secondary
school systems from the complete data file, regardless of enrollment size.
|
| |
| top |
| |
|
|
| |
|
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.
|
| |
| |
| top |
| |
|
Data File Names and Sizes
|
|
| |
| The 2000 and 2001 files may be downloaded from the Census Bureau's web site under Public Elementary-Secondary Education
Finance Data.
|
FY 2001 Self-extracting file: 01esetdt.exe (2.0 MB)
Data files: 01tal-ma.txt (1.7 MB)
01tmi-nd.txt (1.4 MB)
01toh-wy.txt (1.5 MB)
FY 2000 Self-extracting file: 00esetdt.exe (1.9 MB)
Data files: 00tal-ma.txt (1.7 MB)
00tmi-nd.txt (1.4 MB)
00toh-wy.txt (1.5 MB)
|
| |
| top |
| |
|
|
| |
| 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 1999 (FY 2000),
October 2000 (FY 2001).. 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.
|
| |
| top |
| |
|
TABLE 15 DATA
|
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
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
|
|
(back to top of file layout)
|
| |
|
TABLE 16 DATA
|
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
|
| |
| (back to top of file layout) |
| |
| |
| TABLE 17 DATA |
| |
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
|
| |
| (back to top of file layout) |
| |
|
|
| |
| Fiscal year of data: |
2000 |
2001 |
|---|
| Release Date: |
5/23/2002 |
3/11/2003 |
|---|
| Date of last revision: |
7/10/2002 |
none |
|---|
|
| |
| top |
| |
