Partilhar via

SchoolDigger (Independent Publisher) (Preview)

  • Reference

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

Operation ID:
Districts_GetDistrict2

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

Body
APIDistrict12

Get a district ranking list

Operation ID:
DistrictRanking

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

Body
APIDistrictListRank2

Get a ranking list

Operation ID:
RankingGet

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

Body
APISchoolListRank2

Get a school

Operation ID:
Schools_GetSchool20

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

Body
APISchool20Full

Get districts

Operation ID:
Districts_GetAllDistricts2

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

Body
APIDistrictList2

Get schools

Operation ID:
Autocomplete_GetSchools

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

Body
APIAutocompleteSchoolResult

Get schools

Operation ID:
Schools_GetAllSchools20

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

Body
APISchoolList2

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)