Schools Data Table
points, locations, schools, learning sites, public schools, charter schools, middle school, elementary school, grade school, high school, secondary school, school districts, Arizona Department of Education, ADE, education, statewide, AZ, Arizona
Point locations and basic information for preschools, K-12 schools, and district offices in the state Arizona. The data are created to serve as base information for use in GIS systems for a variety of planning and analysis purposes. These data do not represent a legal record.
MAG develops annually updated point locations and basic information for preschools, K-12 schools, and district offices in the state Arizona. The dataset includes public and private PreK-12 school locations. While some preschools are included, this is not a comprehensive statewide dataset for preschools. The dataset was built in collaboration with Arizona Department of Education (ADE), Arizona Department of Environmental Quality (ADEQ), and Maricopa Association of Governments (MAG). The dataset is a general reference for schools or "learning sites" in the state of Arizona.
- Use this URL https://azreportcards.azed.gov/api/Entity/GetEntityList?fiscalYear=xxxx
- Change Fiscal Year to desired year [.../GetEntityList?fiscalyear=xxxx] - ex: xxxx = 2020
Arizona Department of Education (ADE), Arizona Department of Environmental Quality (ADEQ), and Maricopa Association of Governments (MAG)
Data may be used only by the licensee and only for the non-commercial purposes stated in such licensee's request. Data is provided on an "as is" basis, with no warranties, express or implied, including, but not limited to, any warranties of accuracy, merchantability or fitness for a particular purpose. The licensee shall be solely responsible, and MAG shall have no liability, for the accuracy, selection, installation, use, efficiency and suitability of any data or documentation provided to licensee by MAG. In no event shall MAG be liable to the licensee for any damages arising from or related to any use or loss of the data. The licensee is advised to use the data with caution and to independently verify accuracy. For information regarding commercial use of the data, see Arizona Revised Statutes section 39-121.03.
| MAG Column Name | Geography | Definition & Values | Data Type |
|---|---|---|---|
| EntityID | State, County, District, School | The unique identifying number given to the registered LEA, District, Charter Holder, or School. This number should be unique and not duplicated in this column.
|
Double |
| CountyEntityID | State, County, District, School |
|
Double |
| DistrictEntityID | State, County, District, School | The unique identifying number given to the registered LEA, District or Charter Holder | Double |
| SchoolEntityID | State, County, District, School | The unique identifying number given to the registered School or Charter School – This number should be unique and not duplicated in this column | Double |
| DistrictCTDS | State, County, District, School | Nine (9) digit number that the Arizona Department of Education uses to identify Arizona public LEA, districts, charter holder districts. CTDS is an acronym for County Type District School. | Text, 9 |
| SchoolCTDS | State, County, District, School | Nine (9) digit number that the Arizona Department of Education uses to identify Arizona public schools and charter schools. CTDS is an acronym for County Type District School. | Text, 9 |
| NCES_DID | State, County, District, School | The unique identifying number given to the LEA, District or Charter Holder by the National Center for Education Statistics (NCES). This field displays the 7 digit school district identification number. The first 2 digits of the 7 digit school district ID identify the state and the last 5 identify the district ID. Put together, they make a 7 digit unique ID code for each school district. | Text, 7 |
| NCES_SID | State, County, District, School | The unique identifying number given to the School or Charter School by the National Center for Education Statistics (NCES). This field displays the 5 digit school identification number. When combined with the NCES School District ID, the two codes comprise a unique 12 digit code for each school. The first 7 digits of the 12 digit school ID are the district ID, and the last five are the school ID. | Text, 12 |
| ADEQ_ID | State, County, District, School | The unique identifying number given to the educational site by the Arizona Department of Environmental Quality (ADEQ) | Double |
| PreID | State, County, District, School | The unique identifying number given to a preschool site. | Double |
| MAGSCHID | State, County, District, School | Maricopa Association of Governments (MAG) unique school ID | Double |
| MAGEMPID | State, County, District, School | Maricopa Association of Governments (MAG) unique Employer database ID | Double |
| CountyName | State, County, District, School | The name of county in which a LEA, district or school is located. - i.e. Maricopa | Text, 25 |
| DistrictName | State, County, District, School | Name of LEA, District or charter holder | Text, 100 |
| SchoolName | State, County, District, School | Name of school | Text, 100 |
| ALT_NAME | State, County, District, School | Alternative Name of school | Text, 100 |
| EntityClass | State, County, District, School | Defines the classification of the overall record.
|
Text, 25 |
| EntityType | State, County, District, School | Defines the entity type of the overall record.
|
Text, 25 |
| DistrictType | State, County, District, School | District Types
|
Text, 25 |
| SchoolType | State, County, District, School | School Types
|
Text, 25 |
| Model | School | What ADE A-F Letter grade model is used to determine schools letter grade. Model |
Text, 15 |
| PAddress | The physical location address where the school is located - i.e. 302 N 1st Ave | Text, 75 | |
| PCity | The physical city where the school is located – i.e. Phoenix | Text, 50 | |
| PState | The physical state where the school is located – i.e. AZ | Text, 2 | |
| ZIP5 | The physical ZIP code where the school is located – i.e. 85003 | Text, 5 | |
| ZIP4 | The physical ZIP code plus 4 digits where the school is located – i.e. XXXX | Text, 4 | |
| GradeLevels | List of all the grade levels offered in the school or district. | Text, 50 | |
| MinGrade | Minimum grade level offered in the school or district. | Text, 3 | |
| MaxGrade | Maximum grade level offered in the school or district. | Text, 3 | |
| GradesServed | The lowest and highest grade level offered in the school or district. | Text, 25 | |
| KinderType | What type of if any Kindergarten programs are available.
|
Text, 30 | |
| PreK | Whether a school has a preK school grade program, [0,1] | Short | |
| Elem | Whether a school has a elementary school grade program (kg-5), [0,1] | Short | |
| Midd | Whether a school has a middle school grade program (6-8), [0,1] | Short | |
| High | Whether a school has a high school grade program (9-12), [0,1] | Short | |
| Phone | The phone number of the physical location. (xxx) xxx-xxxx | Text, 14 | |
| Website | Entity Website | Text, 255 | |
| NCES_Code | The NCES locale framework number classification | Short | |
| NCES_Locale | The NCES locale framework was designed to provide a general indicator of the type of geographic area where a school is located.
|
Text, 25 | |
| Urban_Rural | Whether the LEA, District or School is classified as Urban or Rural | Text, 5 | |
| maplit | Indicates whether the school should be included on the mapLIT site [0 = No,1 = Yes] | Sort | |
| Display | Indicates whether the school should be included on the Schools site [0 = No,1 = Yes] | Sort | |
| Status | Whether the LEA, District or School is open or closed | Text, 6 | |
| ADD_YEAR | What year the information was added to database | Short | |
| DEL_YEAR | What year the information was deleted from database | Short | |
| DEL_REASON | Reason for information being deleted from database | Text, 255 | |
| SOURCE | Where the database information came from | Text, 50 | |
| QA_QC | Date information was quality checked, (XXXX) | Short | |
| Loc | Whether the site was located, (Y/N) | Text, 1 | |
| lat | latitude, decimal degrees | Double | |
| lon | longitude, decimal degrees | Double | |
| PSS_School_ID | Text, 8 | ||
| Charter | Indicates whether the LEA, District or School is classified as a Charter | Text, 1 | |
| Alternative | Indicates whether the LEA, District or School is classified as an Alternative School | Text, 1 |
- Schools Data Table
- Schools Data Schema
- Assessment Data Schema
- MOWR Benchmark Data Schema
- Chronic Absence Data Schema
- TSG Data Schema
- FRL Data Schema
- Title I Master
- Title I Data Schema
- Enrollment by Grade Schema
- Enrollment by Race Schema
- Redaction Guidelines
- Abbreviations and Terms
- Data Summary Table
- County Data Dictionary
- Entity Class
- Entity Type
- District Type
- School Type
- School Class
- Model
- FAY Status
- Content Area
- Test Level Info
- Subgroup
- AzMERIT Info
- AzSci Info
- Achievement Profile
- NCES Locale Codes
- A-F Letter Grades
- Grade Levels
- TSG Data Info
- School Locations from ADE School Finance
- School Locations from NCES
- LRE SPED Data Schema
- LRE Codes
- First Things First Reference
- Read On Reference
- Child Care Gap
- Early Learning Reference
- Grade Cohort