Sdílet prostřednictvím


SchoolDigger (Independent Publisher) (Preview)

Get detailed data on over 120,000 schools and 18,500 districts in the United States.

This connector is available in the following products and regions:

Service Class Regions
Logic Apps Standard All Logic Apps regions except the following:
     -   Azure Government regions
     -   Azure China regions
     -   US Department of Defense (DoD)
Power Automate Premium All Power Automate regions except the following:
     -   US Government (GCC)
     -   US Government (GCC High)
     -   China Cloud operated by 21Vianet
     -   US Department of Defense (DoD)
Power Apps Premium All Power Apps regions except the following:
     -   US Government (GCC)
     -   US Government (GCC High)
     -   China Cloud operated by 21Vianet
     -   US Department of Defense (DoD)
Contact
Name Troy Taylor
URL https://www.hitachisolutions.com
Email ttaylor@hitachisolutions.com
Connector Metadata
Publisher Troy Taylor
Website https://www.schooldigger.com/
Privacy policy https://www.schooldigger.com/privacy.aspx
Categories Data

Creating a connection

The connector supports the following authentication types:

Default Parameters for creating connection. All regions Not shareable

Default

Applicable: All regions

Parameters for creating connection.

This is not shareable connection. If the power app is shared with another user, another user will be prompted to create new connection explicitly.

Name Type Description Required
API Key securestring The API Key for this API. True
APP ID securestring The APP ID for this API. True

Throttling Limits

Name Calls Renewal Period
API calls per connection 100 60 seconds

Actions

Get a district

Retrieve a single district record from the SchoolDigger database.

Get a district ranking list

Retrieves a SchoolDigger ranking list for a district.

Get a ranking list

Retrieves a SchoolDigger ranking list for a state.

Get a school

Retrieve a school record from the SchoolDigger database.

Get districts

Search the SchoolDigger database for districts. You may use any combination of criteria as query parameters.

Get schools

Returns a simple and quick list of schools.

Get schools

Search the SchoolDigger database for schools. You may use any combination of criteria as query parameters.

Get a district

Retrieve a single district record from the SchoolDigger database.

Parameters

Name Key Required Type Description
ID
id True string

The 7 digit District ID (e.g. 0642150).

Returns

Get a district ranking list

Retrieves a SchoolDigger ranking list for a district.

Parameters

Name Key Required Type Description
State
st True string

Two character state (e.g. 'CA').

Year
year integer

The ranking year (leave blank for most recent year).

Page
page integer

Page number to retrieve (optional, default: 1).

Per Page
perPage integer

Number of districts to retrieve on a page (50 max) (optional, default: 10).

Returns

Get a ranking list

Retrieves a SchoolDigger ranking list for a state.

Parameters

Name Key Required Type Description
State
st True string

Two character state (e.g. 'CA').

Year
year integer

The ranking year (leave blank for most recent year).

Level
level string

Level of ranking: 'Elementary', 'Middle', or 'High'.

Page
page integer

Page number to retrieve (optional, default: 1).

Per Page
perPage integer

Number of schools to retrieve on a page (50 max) (optional, default: 10).

Returns

Get a school

Retrieve a school record from the SchoolDigger database.

Parameters

Name Key Required Type Description
ID
id True string

The 12 digit School ID (e.g. 064215006903).

Returns

Get districts

Search the SchoolDigger database for districts. You may use any combination of criteria as query parameters.

Parameters

Name Key Required Type Description
State
st True string

Two character state (e.g. 'CA') - required.

Query
q string

Search term - note: will match district name or city (optional).

City
city string

Search for districts in this city (optional).

Zip
zip string

Search for districts in this 5-digit zip code (optional).

Near Latitude
nearLatitude double

Search for districts within (distanceMiles) of (nearLatitude)/(nearLongitude) (e.g. 44.982560) (optional) (Pro, Enterprise API levels only. Enterprise API level will flag districts that include lat/long in its attendance boundary.).

Near Longitude
nearLongitude double

Search for districts within (distanceMiles) of (nearLatitude)/(nearLongitude) (e.g. -124.289185) (optional) (Pro, Enterprise API levels only. Enterprise API level will flag districts that include lat/long in its attendance boundary.).

Boundary Address
boundaryAddress string

Full U.S. address: flag returned districts that include this address in its attendance boundary. Example: '123 Main St. AnyTown CA 90001' (optional) (Enterprise API level only).

Distance Miles
distanceMiles integer

Search for districts within (distanceMiles) of (nearLatitude)/(nearLongitude) (Default 50 miles) (optional) (Pro, Enterprise API levels only).

Is In Boundary Only
isInBoundaryOnly boolean

Return only the districts that include given location (nearLatitude/nearLongitude) or (boundaryAddress) in its attendance boundary (Enterprise API level only).

Box Latitude NW
boxLatitudeNW double

Search for districts within a 'box' defined by (BoxLatitudeNW/BoxLongitudeNW) to (BoxLongitudeSE/BoxLatitudeSE) (optional).

Box Longitude NW
boxLongitudeNW double

Search for districts within a 'box' defined by (BoxLatitudeNW/BoxLongitudeNW) to (BoxLongitudeSE/BoxLatitudeSE) (optional).

Box Latitude SE
boxLatitudeSE double

Search for districts within a 'box' defined by (BoxLatitudeNW/BoxLongitudeNW) to (BoxLongitudeSE/BoxLatitudeSE) (optional).

Box Longitude SE
boxLongitudeSE double

Search for districts within a 'box' defined by (BoxLatitudeNW/BoxLongitudeNW) to (BoxLongitudeSE/BoxLatitudeSE) (optional).

Page
page integer

Page number to retrieve (optional, default: 1).

Per Page
perPage integer

Number of districts to retrieve on a page (50 max) (optional, default: 10).

Sort By
sortBy string

Sort list. Values are: districtname, distance, rank.

Include Unranked Districts in Rank Sort
includeUnrankedDistrictsInRankSort boolean

If sortBy is 'rank', this boolean determines if districts with no rank are included in the result (optional, default: false).

Returns

Get schools

Returns a simple and quick list of schools.

Parameters

Name Key Required Type Description
Query
q True string

Search term for autocomplete (e.g. 'Lincoln') (required).

Query City and State
qSearchCityStateName boolean

Extend the search term to include city and state (e.g. 'Lincoln el paso' matches Lincoln Middle School in El Paso) (optional).

State
st string

Two character state (e.g. 'CA') (optional -- leave blank to search entire U.S.).

Level
level string

Search for schools at this level only. Valid values: 'Elementary', 'Middle', 'High', 'Alt', 'Private' (optional - leave blank to search for all schools).

Box Latitude NW
boxLatitudeNW double

Search within a 'box' defined by (BoxLatitudeNW/BoxLongitudeNW) to (BoxLongitudeSE/BoxLatitudeSE) (optional. Pro, Enterprise API levels only.).

Box Longitude NW
boxLongitudeNW double

Search within a 'box' defined by (BoxLatitudeNW/BoxLongitudeNW) to (BoxLongitudeSE/BoxLatitudeSE) (optional. Pro, Enterprise API levels only.).

Box Latitude SE
boxLatitudeSE double

Search within a 'box' defined by (BoxLatitudeNW/BoxLongitudeNW) to (BoxLongitudeSE/BoxLatitudeSE) (optional. Pro, Enterprise API levels only.).

Box Longitude SE
boxLongitudeSE double

Search within a 'box' defined by (BoxLatitudeNW/BoxLongitudeNW) to (BoxLongitudeSE/BoxLatitudeSE) (optional. Pro, Enterprise API levels only.).

Return Count
returnCount integer

Number of schools to return. Valid values: 1-20. (default: 10).

Returns

Get schools

Search the SchoolDigger database for schools. You may use any combination of criteria as query parameters.

Parameters

Name Key Required Type Description
State
st True string

Two character state (e.g. 'CA') - required.

Query
q string

Search term - note: will match school name or city (optional).

Query School Name Only
qSearchSchoolNameOnly boolean

For parameter 'q', only search school names instead of school and city (optional).

District ID
districtID string

Search for schools within this district (7 digit district id) (optional).

Level
level string

Search for schools at this level. Valid values: 'Elementary', 'Middle', 'High', 'Alt', 'Public', 'Private' (optional). 'Public' returns all Elementary, Middle, High and Alternative schools.

City
city string

Search for schools in this city (optional).

Zip
zip string

Search for schools in this 5-digit zip code (optional).

Is Magnet
isMagnet boolean

True = return only magnet schools, False = return only non-magnet schools (optional) (Pro, Enterprise API levels only).

Is Charter
isCharter boolean

True = return only charter schools, False = return only non-charter schools (optional) (Pro, Enterprise API levels only).

Is Virtual
isVirtual boolean

True = return only virtual schools, False = return only non-virtual schools (optional) (Pro, Enterprise API levels only).

Is Title I
isTitleI boolean

True = return only Title I schools, False = return only non-Title I schools (optional) (Pro, Enterprise API levels only).

Is Title I Schoolwide
isTitleISchoolwide boolean

True = return only -Title I school-wide schools, False = return only non-Title I school-wide schools (optional) (Pro, Enterprise API levels only).

Near Latitude
nearLatitude double

Search for schools within (distanceMiles) of (nearLatitude)/(nearLongitude) (e.g. 44.982560) (optional) (Pro, Enterprise API levels only.).

Near Longitude
nearLongitude double

Search for schools within (distanceMiles) of (nearLatitude)/(nearLongitude) (e.g. -124.289185) (optional) (Pro, Enterprise API levels only.).

Near Address
nearAddress string

Search for schools within (distanceMiles) of this address. Example: '123 Main St. AnyTown CA 90001' (optional) (Pro, Enterprise API level only) IMPORTANT NOTE: If you have the lat/long of the address, use nearLatitude and nearLongitude instead for much faster response times.

Distance Miles
distanceMiles integer

Search for schools within (distanceMiles) of (nearLatitude)/(nearLongitude) (Default 5 miles) (optional) (Pro, Enterprise API levels only).

Boundary Latitude
boundaryLatitude double

Search for schools that include this (boundaryLatitude)/(boundaryLongitude) in its attendance boundary (e.g. 44.982560) (optional) (Requires School Boundary API Plan add-on. Calls with this parameter supplied will count toward your monthly call limit.).

Boundary Latitude
boundaryLongitude double

Search for schools that include this (boundaryLatitude)/(boundaryLongitude) in its attendance boundary (e.g. -124.289185) (optional) (Requires School Boundary API Plan add-on. Calls with this parameter supplied will count toward your monthly call limit.

Boundary Address
boundaryAddress string

Full U.S. address: flag returned schools that include this address in its attendance boundary. Example: '123 Main St. AnyTown CA 90001' (optional) (Requires School Boundary API Plan add-on. Calls with this parameter supplied will count toward your monthly call limit.) IMPORTANT NOTE: If you have the lat/long of the address, use boundaryLatitude and boundaryLongitude instead for much faster response times.

Is In Boundary Only
isInBoundaryOnly boolean

Return only the schools that include given location (boundaryLatitude/boundaryLongitude) or (boundaryAddress) in its attendance boundary (Requires School Boundary API Plan add-on.).

Box Latitude NW
boxLatitudeNW double

Search for schools within a 'box' defined by (boxLatitudeNW/boxLongitudeNW) to (boxLongitudeSE/boxLatitudeSE) (optional).

Box Longitude NW
boxLongitudeNW double

Search for schools within a 'box' defined by (boxLatitudeNW/boxLongitudeNW) to (boxLongitudeSE/boxLatitudeSE) (optional).

Box Latitude SE
boxLatitudeSE double

Search for schools within a 'box' defined by (boxLatitudeNW/boxLongitudeNW) to (boxLongitudeSE/boxLatitudeSE) (optional).

Box Longitude SE
boxLongitudeSE double

Search for schools within a 'box' defined by (boxLatitudeNW/boxLongitudeNW) to (boxLongitudeSE/boxLatitudeSE) (optional).

Page
page integer

Page number to retrieve (optional, default: 1).

Per Page
perPage integer

Number of schools to retrieve on a page (50 max) (optional, default: 10).

Sort By
sortBy string

Sort list. Values are: schoolname, distance, rank.

Include Unranked Schools
includeUnrankedSchoolsInRankSort boolean

If sortBy is 'rank', this boolean determines if schools with no rank are included in the result (optional, default: false).

Returns

Definitions

APIAutocompleteSchoolResult

Name Path Type Description
schoolMatches
schoolMatches array of APISchoolAC

List of the schools that match the query

APISchoolAC

Name Path Type Description
schoolid
schoolid string

SchoolDigger School ID Number (12 digits). Use /schools/{schoolID} to retrieve the full school record

schoolName
schoolName string

School name

city
city string

School location city

state
state string

School location state

zip
zip string

School location zip code

schoolLevel
schoolLevel string

The level of school (Elementary, Middle, High, Private, Alternative)

lowGrade
lowGrade string

The low grade served by this school (PK = Prekindergarten, K = Kindergarten)

highGrade
highGrade string

The high grade served by this school

latitude
latitude double

School location latitude

longitude
longitude double

School location longitude

hasBoundary
hasBoundary boolean

States whether there is an attendance boundary available for this school

rank
rank integer

Statewide rank of this School

rankOf
rankOf integer

Count of schools ranked at this state/level

rankStars
rankStars integer

The number of stars SchoolDigger awarded in the ranking of the school (0-5, 5 is best)

APIDistrictList2

Name Path Type Description
numberOfDistricts
numberOfDistricts integer

The total count of districts that match your query

numberOfPages
numberOfPages integer

The total count of pages in your query list based on given per_page value

districtList
districtList array of APIDistrict2Summary

APIDistrict2Summary

Name Path Type Description
districtID
districtID string

SchoolDigger District ID Number (7 digits). Use /districts/{districtID} to retrieve the entire district record

districtName
districtName string

District name

phone
phone string

District phone number

url
url string

SchoolDigger URL for this district

address
address APILocation

The physical address

locationIsWithinBoundary
locationIsWithinBoundary boolean

Indicates whether this school's boundary includes the specified location from nearLatitude/nearLongitude or boundaryAddress (Enterprise API level)

hasBoundary
hasBoundary boolean

Indicates that an attendance boundary is available for this district. (To retrieve, look up district with /districts/{id})

distance
distance double

Distance from nearLatitude/nearLongitude (if supplied)

isWithinBoundary
isWithinBoundary boolean

Indicates whether this district's boundary includes the specified location from nearLatitude/nearLongitude

county
county APICounty

The county.

lowGrade
lowGrade string

The low grade served by this district (PK = Prekindergarten, K = Kindergarten)

highGrade
highGrade string

The high grade served by this district

numberTotalSchools
numberTotalSchools integer

Count of schools in the district

numberPrimarySchools
numberPrimarySchools integer

Count of schools designated as primary schools

numberMiddleSchools
numberMiddleSchools integer

Count of schools designated as middle schools

numberHighSchools
numberHighSchools integer

Count of schools designated as high schools

numberAlternativeSchools
numberAlternativeSchools integer

Count of schools designated as other/alternative schools

rankHistory
rankHistory array of APILEARankHistory

SchoolDigger yearly rank history of the district

districtYearlyDetails
districtYearlyDetails array of APILEAYearlyDetail

District yearly metrics

APILocation

The physical address

Name Path Type Description
latLong
latLong APILatLong

The Latitude and Longitude.

street
street string
city
city string
state
state string
stateFull
stateFull string

Full state name (WA = Washington)

zip
zip string
zip4
zip4 string
cityURL
cityURL string

SchoolDigger URL for schools in this city

zipURL
zipURL string

SchoolDigger URL for schools in this zip code

html
html string

HTML formatted address

APICounty

The county.

Name Path Type Description
countyName
countyName string

County in which the school or district is located

countyURL
countyURL string

SchoolDigger URL for all schools in this county

APILEARankHistory

Name Path Type Description
year
year integer

School year (2017 - 2016-17)

rank
rank integer

Statewide rank of this district

rankOf
rankOf integer

Count of district ranked in this state

rankStars
rankStars integer

The number of stars SchoolDigger awarded in the ranking of the district (0-5, 5 is best)

rankStatewidePercentage
rankStatewidePercentage double

Percentile of this district's rank (e.g. this district performed better than (x)% of this state's districts)

rankScore
rankScore double

The rank score calculated by SchoolDigger (see https://www.schooldigger.com/aboutranking.aspx)

APILEAYearlyDetail

Name Path Type Description
year
year integer

School year (2018 = 2017-18)

numberOfStudents
numberOfStudents integer

Number of students enrolled in the district

numberOfSpecialEdStudents
numberOfSpecialEdStudents integer

The number of students having a written Individualized Education Program (IEP) under the Individuals With Disabilities Education Act (IDEA)

numberOfEnglishLanguageLearnerStudents
numberOfEnglishLanguageLearnerStudents integer

The number of English language learner (ELL) students served in appropriate programs

numberOfTeachers
numberOfTeachers double

Number of full-time equivalent teachers employed by the district

numberOfTeachersPK
numberOfTeachersPK double

Number of full-time equivalent pre-kindergarten teachers employed by the district

numberOfTeachersK
numberOfTeachersK double

Number of full-time equivalent kindergarten teachers employed by the district

numberOfTeachersElementary
numberOfTeachersElementary double

Number of full-time equivalent elementary teachers employed by the district

numberOfTeachersSecondary
numberOfTeachersSecondary double

Number of full-time equivalent secondary teachers employed by the district

numberOfAids
numberOfAids double

Number of full-time equivalent instructional aids employed by the district

numberOfCoordsSupervisors
numberOfCoordsSupervisors double

Number of full-time equivalent instructional coordinators/supervisors employed by the district

numberOfGuidanceElem
numberOfGuidanceElem double

Number of full-time equivalent elementary guidance counselors employed by the district

numberOfGuidanceSecondary
numberOfGuidanceSecondary double

Number of full-time equivalent secondary guidance counselors employed by the district

numberOfGuidanceTotal
numberOfGuidanceTotal double

Total number of full-time equivalent guidance counselors employed by the district

numberOfLibrarians
numberOfLibrarians double

Number of full-time equivalent librarians/media specialists employed by the district

numberOfLibraryStaff
numberOfLibraryStaff double

Number of full-time equivalent librarians/media support staff employed by the district

numberOfLEAAdministrators
numberOfLEAAdministrators double

Number of full-time equivalent LEA administrators employed by the district (LEA)

numberOfLEASupportStaff
numberOfLEASupportStaff double

Number of full-time equivalent LEA administrative support staff employed by the district (LEA)

numberOfSchoolAdministrators
numberOfSchoolAdministrators double

Number of full-time equivalent school administrators employed by the district (LEA)

numberOfSchoolAdminSupportStaff
numberOfSchoolAdminSupportStaff double

Number of full-time equivalent school administrative support staff employed by the district (LEA)

numberOfStudentSupportStaff
numberOfStudentSupportStaff double

Number of full-time equivalent student support services staff employed by the district (LEA)

numberOfOtherSupportStaff
numberOfOtherSupportStaff double

Number of full-time equivalent all other support staff employed by the district (LEA)

APILatLong

The Latitude and Longitude.

Name Path Type Description
latitude
latitude double
longitude
longitude double

APIDistrict12

Name Path Type Description
districtID
districtID string

SchoolDigger District ID Number (7 digits)

districtName
districtName string

District name

phone
phone string

District phone number

url
url string

SchoolDigger URL for this district

address
address APILocation

The physical address

boundary
boundary APIBoundary12

Attendance boundary (Pro, Enterprise levels only)

isWithinBoundary
isWithinBoundary boolean

Indicates whether this district's boundary includes the specified location from nearLatitude/nearLongitude

county
county APICounty

The county.

lowGrade
lowGrade string

The low grade served by this district (PK = Prekindergarten, K = Kindergarten)

highGrade
highGrade string

The high grade served by this district

numberTotalSchools
numberTotalSchools integer
numberPrimarySchools
numberPrimarySchools integer
numberMiddleSchools
numberMiddleSchools integer
numberHighSchools
numberHighSchools integer
numberAlternativeSchools
numberAlternativeSchools integer
rankHistory
rankHistory array of APILEARankHistory

SchoolDigger yearly rank history of the district

districtYearlyDetails
districtYearlyDetails array of APILEAYearlyDetail

District yearly metrics

testScores
testScores array of APITestScoreWrapper

Test scores (district and state) -- requires Pro or Enterprise level API subscription

APIBoundary12

Attendance boundary (Pro, Enterprise levels only)

Name Path Type Description
polylineCollection
polylineCollection array of APIPolyline

Collection of one or more polylines that can be used to create the boundary on a map. NOTE: this value is JSON encoded. Specifically, backslashes will be returned escaped (two backslashes). Make sure to decode the polyline before you use it

polylines
polylines string

Collection of latitude/longitude vertices to form a polygon representing the boundary

hasBoundary
hasBoundary boolean

States whether there is a boundary available

APITestScoreWrapper

Name Path Type Description
test
test string

The name of the state-administered test

subject
subject string

Test subject

year
year integer

Year test was administered (2018 = 2017-18)

grade
grade string
schoolTestScore
schoolTestScore APITestScore

The test score.

districtTestScore
districtTestScore APITestScore

The test score.

stateTestScore
stateTestScore APITestScore

The test score.

tier1
tier1 string

Tier 1 test score description (Enterprise API level only)

tier2
tier2 string

Tier 2 test score description (Enterprise API level only)

tier3
tier3 string

Tier 3 test score description (Enterprise API level only)

tier4
tier4 string

Tier 4 test score description (Enterprise API level only)

tier5
tier5 string

Tier 5 test score description (Enterprise API level only)

APIPolyline

Name Path Type Description
polylineOverlayEncodedPoints
polylineOverlayEncodedPoints string

Polyline for use with Google Maps or other mapping software. NOTE: this value is JSON encoded. Specifically, backslashes will be returned escaped (two backslashes). Make sure to decode the polyline before you use it

numberEncodedPoints
numberEncodedPoints integer

Number of encoded points in polyline

APITestScore

The test score.

Name Path Type Description
studentsEligible
studentsEligible integer

Count of students eligible to take test

studentsTested
studentsTested integer

Count of students tested

meanScaledScore
meanScaledScore float

Mean scale score

percentMetStandard
percentMetStandard float

Percent of students meeting state standard

numberMetStandard
numberMetStandard float

Count of students meeting state standard

numTier1
numTier1 integer

Count of students performing at tier 1 (Enterprise API level only)

numTier2
numTier2 integer

Count of students performing at tier 2 (Enterprise API level only)

numTier3
numTier3 integer

Count of students performing at tier 3 (Enterprise API level only)

numTier4
numTier4 integer

Count of students performing at tier 4 (Enterprise API level only)

numTier5
numTier5 integer

Count of students performing at tier 5 (Enterprise API level only)

percentTier1
percentTier1 float

Percent of students performing at tier 1 (Enterprise API level only)

percentTier2
percentTier2 float

Percent of students performing at tier 2 (Enterprise API level only)

percentTier3
percentTier3 float

Percent of students performing at tier 3 (Enterprise API level only)

percentTier4
percentTier4 float

Percent of students performing at tier 4 (Enterprise API level only)

percentTier5
percentTier5 float

Percent of students performing at tier 5 (Enterprise API level only)

APISchoolListRank2

Name Path Type Description
rankYear
rankYear integer

Year this ranking list represents (2018 = 2017-18)

rankYearCompare
rankYearCompare integer

Year rankings returned for comparison (2018 = 2017-18)

rankYearsAvailable
rankYearsAvailable array of integer

The years for which SchoolDigger rankings are available for this state and level

numberOfSchools
numberOfSchools integer

The total count of schools in this ranking list

numberOfPages
numberOfPages integer

The total count of pages this ranking list based on given per_page value

schoolList
schoolList array of APISchool2Summary

APISchool2Summary

APISchool2Summary: A summary of a school record. For the full school record, call /schools/{id}

Name Path Type Description
schoolid
schoolid string

SchoolDigger School ID Number (12 digits)

schoolName
schoolName string

School name

phone
phone string

School phone number

url
url string

SchoolDigger URL for this school

urlCompare
urlCompare string

SchoolDigger URL for comparing this school to nearby schools

address
address APILocation

The physical address

distance
distance double

Distance from nearLatitude/nearLongitude, boundaryLatitude/boundaryLongitude, or boundaryAddress (if supplied)

locale
locale string

NCES Locale of school (https://nces.ed.gov/ccd/rural_locales.asp)

lowGrade
lowGrade string

The low grade served by this school (PK = Prekindergarten, K = Kindergarten)

highGrade
highGrade string

The high grade served by this school

schoolLevel
schoolLevel string

The level of school (Elementary, Middle, High, Private, Alternative)

isCharterSchool
isCharterSchool string

Indicates if school is a charter school (Yes/No/n-a)

isMagnetSchool
isMagnetSchool string

Indicates if school is a magnet school (Yes/No/n-a)

isVirtualSchool
isVirtualSchool string

Indicates if school is a virtual school (Yes/No/n-a)

isTitleISchool
isTitleISchool string

Indicates if school is a Title I school (Yes/No/n-a)

isTitleISchoolwideSchool
isTitleISchoolwideSchool string

Indicates if a school-wide Title I school (Yes/No/n-a)

hasBoundary
hasBoundary boolean

Indicates that an attendance boundary is available for this school.

locationIsWithinBoundary
locationIsWithinBoundary boolean

Indicates whether this school's boundary includes the specified location from boundaryLatitude/boundaryLongitude or boundaryAddress. (School Boundary Add-on Package required)

district
district APIDistrictSum

District Summary

county
county APICounty

The county.

rankHistory
rankHistory array of APIRankHistory

SchoolDigger yearly rank history of the school. To retrieve all years, call /schools/{id}.

rankMovement
rankMovement integer

Returns the movement of rank for this school between current and previous year

schoolYearlyDetails
schoolYearlyDetails array of APIYearlyDemographics

School Yearly metrics. To retrieve all years, call /schools/{id}.

isPrivate
isPrivate boolean

Indicates if school is a private school (Yes/No)

privateDays
privateDays integer

Days in the school year (private schools only)

privateHours
privateHours double

Hours in the school day (private schools only)

privateHasLibrary
privateHasLibrary boolean

Indicates if the school has a library (private schools only)

privateCoed
privateCoed string

Coed/Boys/Girls (private schools only)

privateOrientation
privateOrientation string

Affiliation of the school (private schools only)

APIDistrictSum

District Summary

Name Path Type Description
districtID
districtID string

The 7 digit SchoolDigger District id number

districtName
districtName string
url
url string

The URL to see the district details on SchoolDigger

rankURL
rankURL string

The URL to see the district in the SchoolDigger ranking list

APIRankHistory

Name Path Type Description
year
year integer

School year (2017 - 2016-17)

rank
rank integer

Statewide rank of this School

rankOf
rankOf integer

Count of schools ranked at this state/level

rankStars
rankStars integer

The number of stars SchoolDigger awarded in the ranking of the school (0-5, 5 is best)

rankLevel
rankLevel string

The level for which this school is ranked (Elementary, Middle, High)

rankStatewidePercentage
rankStatewidePercentage double

Percentile of this school's rank (e.g. this school performed better than (x)% of this state's elementary schools)

averageStandardScore
averageStandardScore double

The Average Standard score calculated by SchoolDigger (see: https://www.schooldigger.com/aboutrankingmethodology.aspx)

APIYearlyDemographics

Name Path Type Description
year
year integer

School year (2018 = 2017-18)

numberOfStudents
numberOfStudents integer

Count of students attending the school

percentFreeDiscLunch
percentFreeDiscLunch double

Percent of students receiving a free or discounted lunch in the National School Lunch Program

percentofAfricanAmericanStudents
percentofAfricanAmericanStudents double
percentofAsianStudents
percentofAsianStudents double
percentofHispanicStudents
percentofHispanicStudents double
percentofIndianStudents
percentofIndianStudents double
percentofPacificIslanderStudents
percentofPacificIslanderStudents double
percentofWhiteStudents
percentofWhiteStudents double
percentofTwoOrMoreRaceStudents
percentofTwoOrMoreRaceStudents double
percentofUnspecifiedRaceStudents
percentofUnspecifiedRaceStudents double
teachersFulltime
teachersFulltime double

Number of full-time equivalent teachers employed at the school

pupilTeacherRatio
pupilTeacherRatio double

Number of students / number of full-time equivalent teachers

numberofAfricanAmericanStudents
numberofAfricanAmericanStudents integer

NCES definition: A person having origins in any of the black racial groups of Africa. (https://nces.ed.gov/statprog/2002/std1_5.asp)

numberofAsianStudents
numberofAsianStudents integer

NCES definition: A person having origins in any of the original peoples of the Far East, Southeast Asia, or the Indian subcontinent, including, for example, Cambodia, China, India, Japan, Korea, Malaysia, Pakistan, the Philippine Islands, Thailand, and Vietnam. (https://nces.ed.gov/statprog/2002/std1_5.asp)

numberofHispanicStudents
numberofHispanicStudents integer

NCES definition: A person of Cuban, Mexican, Puerto Rican, South or Central American, or other Spanish culture or origin, regardless of race. (https://nces.ed.gov/statprog/2002/std1_5.asp)

numberofIndianStudents
numberofIndianStudents integer

NCES definition: A person having origins in any of the original peoples of the Far East, Southeast Asia, or the Indian subcontinent, including, for example, Cambodia, China, India, Japan, Korea, Malaysia, Pakistan, the Philippine Islands, Thailand, and Vietnam. (https://nces.ed.gov/statprog/2002/std1_5.asp)

numberofPacificIslanderStudents
numberofPacificIslanderStudents integer

NCES definition: A person having origins in any of the original peoples of Hawaii, Guam, Samoa, or other Pacific Islands. (https://nces.ed.gov/statprog/2002/std1_5.asp)

numberofWhiteStudents
numberofWhiteStudents integer

NCES definition: A person having origins in any of the original peoples of Europe, the Middle East, or North Africa. (https://nces.ed.gov/statprog/2002/std1_5.asp)

numberofTwoOrMoreRaceStudents
numberofTwoOrMoreRaceStudents integer

NCES definition: Includes any combination of two or more races and not Hispanic/Latino ethnicity. (https://nces.ed.gov/statprog/2002/std1_5.asp)

numberofUnspecifiedRaceStudents
numberofUnspecifiedRaceStudents integer

APIDistrictListRank2

Name Path Type Description
rankYear
rankYear integer

Year this ranking list represents (2018 = 2017-18)

rankYearCompare
rankYearCompare integer

Year rankings returned for comparison (2018 = 2017-18)

rankYearsAvailable
rankYearsAvailable array of integer

The years for which SchoolDigger district rankings are available for this state

numberOfDistricts
numberOfDistricts integer

The total count of districts in the entire rank list

numberOfPages
numberOfPages integer

The total count of pages in your query list based on given per_page value

districtList
districtList array of APIDistrict2Summary
rankCompareYear
rankCompareYear integer

APISchoolList2

Name Path Type Description
numberOfSchools
numberOfSchools integer

The total count of schools that match your query

numberOfPages
numberOfPages integer

The total count of pages in your query list based on given per_page value

schoolList
schoolList array of APISchool2Summary

APISchool20Full

Name Path Type Description
schoolid
schoolid string

SchoolDigger School ID Number (12 digits)

schoolName
schoolName string

School name

phone
phone string

School phone number

url
url string

URL of the school's public website

urlSchoolDigger
urlSchoolDigger string

SchoolDigger URL for this school

urlCompareSchoolDigger
urlCompareSchoolDigger string

SchoolDigger URL for comparing this school to nearby schools

address
address APILocation

The physical address

locale
locale string

NCES Locale of school (https://nces.ed.gov/ccd/rural_locales.asp)

lowGrade
lowGrade string

The low grade served by this school (PK = Prekindergarten, K = Kindergarten)

highGrade
highGrade string

The high grade served by this school

schoolLevel
schoolLevel string

The level of school (Elementary, Middle, High, Private, Alternative)

isCharterSchool
isCharterSchool string

Indicates if school is a charter school (Yes/No/n-a)

isMagnetSchool
isMagnetSchool string

Indicates if school is a magnet school (Yes/No/n-a)

isVirtualSchool
isVirtualSchool string

Indicates if school is a virtual school (Yes/No/n-a)

isTitleISchool
isTitleISchool string

Indicates if school is a Title I school (Yes/No/n-a)

isTitleISchoolwideSchool
isTitleISchoolwideSchool string

Indicates if a school-wide Title I school (Yes/No/n-a)

isPrivate
isPrivate boolean

Indicates if school is a private school (Yes/No)

privateDays
privateDays integer

Days in the school year (private schools only)

privateHours
privateHours double

Hours in the school day (private schools only)

privateHasLibrary
privateHasLibrary boolean

Indicates if the school has a library (private schools only)

privateCoed
privateCoed string

Coed/Boys/Girls (private schools only)

privateOrientation
privateOrientation string

Affiliation of the school (private schools only)

district
district APIDistrictSum

District Summary

county
county APICounty

The county.

reviews
reviews array of APISchoolReview

List of reviews for this school submitted by SchoolDigger site visitors

finance
finance array of APISchoolFinance

School finance (Pro and Enterprise API level only)

rankHistory
rankHistory array of APIRankHistory

SchoolDigger yearly rank history of the school

rankMovement
rankMovement integer

Returns the movement of rank for this school between current and previous year

testScores
testScores array of APITestScoreWrapper

Test scores (including district and state) -- requires Pro or Enterprise level API subscription

schoolYearlyDetails
schoolYearlyDetails array of APIYearlyDemographics

School Yearly metrics

APISchoolReview

Name Path Type Description
submitDate
submitDate string

The date the review was submitted (mm/dd/yyyy)

numberOfStars
numberOfStars integer

Number of stars - 1 (poor) to 5 (excellent)

comment
comment string

Comment left by reviewer (html encoded)

submittedBy
submittedBy string

Reviewer type (parent, student, teacher, principal, citizen)

APISchoolFinance

Name Path Type Description
year
year integer

Fiscal School year (2021 = 2020-2021 year)

spendingPerStudent
spendingPerStudent float

Total spending per student from all funds (Pro or Enterprise level only)

spendingFederalPersonnel
spendingFederalPersonnel float

Spending per student for Personnel at the Federal Level (Enterprise level only)

spendingFederalNonPersonnel
spendingFederalNonPersonnel float

Spending per student for Non-personnel at the Federal Level (Enterprise level only)

spendingStateLocalPersonnel
spendingStateLocalPersonnel float

Spending per student for Personnel at the State and Local Level (Enterprise level only)

spendingStateLocalNonPersonnel
spendingStateLocalNonPersonnel float

Spending per student for Non-personnel at the State and Local Level (Enterprise level only)

spendingPerStudentFederal
spendingPerStudentFederal float

Spending per student at the Federal Level (Enterprise level only)

spendingPerStudentStateLocal
spendingPerStudentStateLocal float

Spending per student at the State and Local Level (Enterprise level only)