Skip Navigation
small NCES header image
Common Core of Data (CCD)

About Public School Name and Address File


Introduction

This file contains the names, addresses, telephone numbers, and enrollment (membership) of the public schools in the 50 states, District of Columbia, five outlying areas, the Department of Defense and Bureau of Indian Affairs schools for the 2009-10 school year. Also included for each record are various codes to help subset the file for targeting mailouts. These codes comprise school type, lowest and highest grades taught, school locale, and a derived variable for grades taught (primary, middle, and high schools), and school status.

The CSV files have been grouped by state and split into three smaller files to facilitate their use in older versions of Excel:

  • sc091aai.csv – schools for Alabama through Iowa
  • sc091akn.csv – school for Kansas through North Dakaota
  • sc091aow.csv – school for Ohio through Virgin Islands

If you need additional information about the data records or definitions, contact Patrick.Keaton.

The text files are comma delimited. They can be opened in MS Excel or imported into most other applications. The file layout and variables are described below.

Position Variable Position Variable
1 NCES School ID 2 School name
3 Street address 4 City
5 State 6 Zip code
7 Zip4 8 Enrollment
9 Phone Number 10 Locale code
11 School type 12 School level
13 Lowest grade taught 14 Highest grade taught
15 Status    

Top

Code and Variable Definitions

Missing and Not Applicable Data
Missing values (where a value was expected, but none was measured) are represented as an "M" in alphanumeric fields and a "-1" in numeric fields. Non-applicable values (where a value was neither expected nor measured) are represented as an "N" in alphanumeric fields and a "-2" in numeric fields.

NCES School ID
This field displays the 12 digit school identification number. This number can be used to link the school to the district on the school district address file. The first 7 digits of the 12 digit school ID are the district ID, the last five are the school ID, put together, they make a 12 digit unique code for each school.

Membership
This field displays the total number of students (membership). It represents the sum of ungraded and PK thru 12 students.

NCES urban-centric locale code and Definition
The locale code is a definition of how the school is situated in a particular location relative to populous areas, based on the school's location address. No Locale Codes have been assigned to Puerto Rico.

Starting in 2006-07, CCD data files contain a new locale code system that is based on the urbanity of the school location. In prior years, the locale was assigned based on a school's metro status.

The locale code translations are as follows:

Locale Code Locale Type Definition
11 City, Large Territory inside an urbanized area and inside a principal city with population of 250,000 or more.
12 City, Mid-size Territory inside an urbanized area and inside a principal city with a population less than 250,000 and greater than or equal to 100,000.
13 City, Small Territory inside an urbanized area and inside a principal city with a population less than 100,000.
21 Suburb, Large Territory outside a principal city and inside an urbanized area with population of 250,000 or more.
22 Suburb, Mid-size Territory outside a principal city and inside an urbanized area with a population less than 250,000 and greater than or equal to 100,000.
23 Suburb, Small Territory outside a principal city and inside an urbanized area with a population less than 100,000.
31 Town, Fringe Territory inside an urban cluster that is less than or equal to 10 miles from an urbanized area.
32 Town, Distant Territory inside an urban cluster that is more than 10 miles and less than or equal to 35 miles from an urbanized area.
33 Town, Remote Territory inside an urban cluster that is more than 35 miles from an urbanized area.
41 Rural, Fringe Census-defined rural territory that is less than or equal to 5 miles from an urbanized area, as well as rural territory that is less than or equal to 2.5 miles from an urban cluster.
42 Rural, Distant Census-defined rural territory that is more than 5 miles but less than or equal to 25 miles from an urbanized area, as well as rural territory that is more than 2.5 miles but less than or equal to 10 miles from an urban cluster.

Top

School Type


School Code School Type Definition
1 Regular elementary and secondary schools A public elementary/secondary school that does not focus primarily on vocational, special, or alternative education.
2 Special education schools Public elementary/secondary school that focuses primarily on the following: hard of hearing, deaf, speech-impaired, health-impaired, orthopedically impaired, mentally retarded, seriously emotionally disturbed, multi-handicapped, visually handicapped, deaf and blind, and adapts curriculum, materials or instruction for students served.
3 Vocational/technical schools Public elementary/secondary school that focuses primarily on vocational education, provides education in one or more semi-skilled technical operations.
4 Other (not elsewhere classified) schools A public elementary/secondary school that addresses the needs of students which typically cannot be met in a regular school, provides nontraditional education, serves as an adjunct to a regular school, and falls outside of the categories of regular, special education, vocational education.
5 Reportable program A program within a school that may be self-contained, but does not have its own principal, and is not a school according to the CCD definition of a school.

Top


School Level


School Level Code School Level Low Grade High Grade
1 Primary Prekindergarten through 03 up to 08
2 Middle grade 04 through 07 04 through 09
3 High grade 07 through 12 12 only
4 Other any other configuration not falling within the above three, including ungraded schools

Top


Lowest/Highest Grade Level

Use these fields to identify schools by the highest or lowest grade level taught in the school. The following codes are used:

  • PK = PreKindergarten
  • KG = Kindergarten
  • 01-12 = First through 12th grade
  • UG = Ungraded
  • 00 = School had no students reported

UG and 00 each occurs only in isolation from other codes. When one of these does occur, it is both the lowest and highest grade.

Status


Status Status Code Definition
1 Operational School was operational at the time of the last report and is currently operational.
2 Closed School has closed since the time of the last report.
3 New School has been opened since the time of the last report.
4 Not previously reported Reported school was operational at the time of the last report but was not on the CCD list at that time.
5 Changed agency School was listed in previous year’s CCD school universe as being affiliated with a different education agency.
6 Temporarily closed School is temporarily closed and may reopen within 3 years.
7 Future school School is scheduled to be operational within 2 years.
8 Reopened School was closed on previous year’s file but has reopened.


 CCD Address Files

Top


Would you like to help us improve our products and website by taking a short survey?

YES, I would like to take the survey

or

No Thanks

The survey consists of a few short questions and takes less than one minute to complete.