US Public Schools

Name: US Public Schools
Creator: opendatasoft

APIJoinable5/7Query nowOpen workbench Subscribe🇫🇷France

This dataset lists public elementary and secondary education facilities across the United States, based on the Common Core of Data (CCD) maintained by the National Center for Education Statistics (NCES), part of the US Department of Education. It includes geolocated records for public schools nationwide, covering attributes such as school name, address, and administrative details as defined by the CCD. The dataset is published via the Opendatasoft public data portal and is intended for mapping, analysis, and research on the distribution and characteristics of public schools across US states and districts.This Public Schools feature dataset is composed of all Public elementary and secondary education facilities in the United States as defined by the Common Core of Data (CCD, https://nces.ed.gov/ccd/ ), National Center for Education Statistics (NCES, https://nces.ed.gov ), US Department of Educatio...

⬇ Export CSV List records Select & filter Run verified request Read the docs

Trust score

How is this computed?

fair

Weighted across five axes. Tap a ring for what it measures.

Data schema (33 fields)

Filterable via the API (31)

objectidncesidnameaddresscitystatezipzip4telephonetypestatuspopulationcountycountyfipscountrylatitudelongitudenaics_codenaics_descsourcesourcedateval_methodval_datewebsitelevelenrollmentst_gradeend_gradedistrictidft_teachershelter_id

Click a field to see example values.

Fill	Field	Type	Description
—	geo_point_2dGeo Point	geo_point_2d	—
—	geo_shapeShape	geo_shape	—
—	objectid	text	—
—	ncesid	text	—
—	name	text	—
—	address	text	—
—	city	text	—
—	state	text	—
—	zip	text	—
—	zip4	text	—
100%	telephone	text	—
100%	type	text	—
100%	status	text	—
100%	population	text	—
100%	county	text	—
100%	countyfips	text	—
100%	country	text	—
100%	latitudeLatitude	text	—
100%	longitudeLongitude	text	—
100%	naics_codeNaics code	text	—
100%	naics_descNaics desc	text	—
100%	source	text	—
100%	sourcedate	text	—
100%	val_methodVal method	text	—
100%	val_dateVal date	text	—
100%	website	text	—
94.8%	level	text	—
100%	enrollment	text	—
100%	st_gradeSt grade	text	—
100%	end_gradeEnd grade	text	—
100%	districtid	text	—
100%	ft_teacherFt teacher	text	—
100%	shelter_idShelter id	text	—

Schema captured from opendatasoft 6 days ago.

Query the data

Pick columns and a sort, then fetch a live preview straight from the source. Choose an API-filterable column (marked ▾) under “Where” to pick from its list of values.

Where=

Sort by

Sample data (5 records)

Record 1zip: 90275 · city: RANCHO PALOS VERDES

{
  "zip": "90275",
  "city": "RANCHO PALOS VERDES",
  "name": "CRESTWOOD STREET ELEMENTARY",
  "type": "1",
  "zip4": "1302",
  "level": "ELEMENTARY",
  "state": "CA",
  "county": "LOS ANGELES",
  "ncesid": "062271002943",
  "source": "http://nces.ed.gov/GLOBALLOCATOR/sch_info_popup.asp?Type=Public&ID=062271002943",
  "status": "1",
  "address": "1946 W. CRESTWOOD ST.",
  "country": "USA",
  "website": "http://www.crestwood-lausd-ca.schoolloop.com",
  "latitude": "33.749409582000055",
  "objectid": "95867",
  "st_grade": "KG",
  "val_date": "2016-02-16T00:00:00Z",
  "end_grade": "05",
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "Point",
      "coordinates": [
        -118.312418117,
        33.749409582000055
      ]
    },
    "properties": {}
  },
  "longitude": "-118.31241811699999",
  "telephone": "(310) 832-8130",
  "countyfips": "06037",
  "districtid": "0622710",
  "enrollment": "356",
  "ft_teacher": "16",
  "naics_code": "611110",
  "naics_desc": "ELEMENTARY AND SECONDARY SCHOOLS",
  "population": "372",
  "shelter_id": "NOT AVAILABLE",
  "sourcedate": "2009-10-13T00:00:00Z",
  "val_method": "IMAGERY",
  "geo_point_2d": {
    "lat": 33.749409582000055,
    "lon": -118.312418117
  }
}

Record 2zip: 65349 · city: SLATER

{
  "zip": "65349",
  "city": "SLATER",
  "name": "OREARVILLE ELEM.",
  "type": "1",
  "zip4": "0013",
  "level": "ELEMENTARY",
  "state": "MO",
  "county": "SALINE",
  "ncesid": "292745001682",
  "source": "http://nces.ed.gov/GLOBALLOCATOR/sch_info_popup.asp?Type=Public&ID=292745001682",
  "status": "1",
  "address": "32524 E HIGHWAY P",
  "country": "USA",
  "website": "http://OREARVILLETIGERS.K12.MO.US",
  "latitude": "39.17140296000008",
  "objectid": "97627",
  "st_grade": "KG",
  "val_date": "2017-10-31T00:00:00Z",
  "end_grade": "08",
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "Point",
      "coordinates": [
        -93.06893823899998,
        39.17140296000008
      ]
    },
    "properties": {}
  },
  "longitude": "-93.06893823899998",
  "telephone": "(660) 529-2481",
  "countyfips": "29195",
  "districtid": "2927450",
  "enrollment": "52",
  "ft_teacher": "9",
  "naics_code": "611110",
  "naics_desc": "ELEMENTARY AND SECONDARY SCHOOLS",
  "population": "61",
  "shelter_id": "NOT AVAILABLE",
  "sourcedate": "2010-01-29T00:00:00Z",
  "val_method": "IMAGERY/OTHER",
  "geo_point_2d": {
    "lat": 39.17140296000008,
    "lon": -93.06893823899998
  }
}

Record 3zip: 19132 · city: PHILADELPHIA

{
  "zip": "19132",
  "city": "PHILADELPHIA",
  "name": "WRIGHT RICHARD R SCH",
  "type": "1",
  "zip4": "4638",
  "level": "HIGH",
  "state": "PA",
  "county": "PHILADELPHIA",
  "ncesid": "421899005188",
  "source": "http://nces.ed.gov/GLOBALLOCATOR/sch_info_popup.asp?Type=Public&ID=421899005188",
  "status": "1",
  "address": "2700 W DAUPHIN ST",
  "country": "USA",
  "website": "NOT AVAILABLE",
  "latitude": "39.99023068300005",
  "objectid": "98275",
  "st_grade": "PK",
  "val_date": "2010-03-18T00:00:00Z",
  "end_grade": "05",
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "Point",
      "coordinates": [
        -75.17756450599995,
        39.99023068300005
      ]
    },
    "properties": {}
  },
  "longitude": "-75.17756450599995",
  "telephone": "(215) 400-7030",
  "countyfips": "42101",
  "districtid": "4218990",
  "enrollment": "326",
  "ft_teacher": "27",
  "naics_code": "611110",
  "naics_desc": "ELEMENTARY AND SECONDARY SCHOOLS",
  "population": "353",
  "shelter_id": "NOT AVAILABLE",
  "sourcedate": "2010-01-29T00:00:00Z",
  "val_method": "IMAGERY",
  "geo_point_2d": {
    "lat": 39.99023068300005,
    "lon": -75.17756450599995
  }
}

Record 4zip: 60424 · city: GARDNER

{
  "zip": "60424",
  "city": "GARDNER",
  "name": "GARDNER ELEM SCHOOL",
  "type": "1",
  "zip4": "7050",
  "level": "ELEMENTARY",
  "state": "IL",
  "county": "GRUNDY",
  "ncesid": "171623001941",
  "source": "http://nces.ed.gov/GLOBALLOCATOR/sch_info_popup.asp?Type=Public&ID=171623001941",
  "status": "1",
  "address": "598 N ELM ST",
  "country": "USA",
  "website": "http://www.ggs.72.org",
  "latitude": "41.193785167000044",
  "objectid": "64249",
  "st_grade": "PK",
  "val_date": "2010-06-04T00:00:00Z",
  "end_grade": "08",
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "Point",
      "coordinates": [
        -88.30582160399996,
        41.193785167000044
      ]
    },
    "properties": {}
  },
  "longitude": "-88.30582160399996",
  "telephone": "(815) 237-2313",
  "countyfips": "17063",
  "districtid": "1716230",
  "enrollment": "163",
  "ft_teacher": "-999",
  "naics_code": "611110",
  "naics_desc": "ELEMENTARY AND SECONDARY SCHOOLS",
  "population": "163",
  "shelter_id": "10775429",
  "sourcedate": "2010-01-29T00:00:00Z",
  "val_method": "IMAGERY/OTHER",
  "geo_point_2d": {
    "lat": 41.193785167000044,
    "lon": -88.30582160399996
  }
}

Record 5zip: 13473 · city: TURIN

{
  "zip": "13473",
  "city": "TURIN",
  "name": "SOUTH LEWIS MIDDLE SCHOOL",
  "type": "1",
  "zip4": "0070",
  "level": "HIGH",
  "state": "NY",
  "county": "LEWIS",
  "ncesid": "362736001137",
  "source": "http://nces.ed.gov/GLOBALLOCATOR/sch_info_popup.asp?Type=Public&ID=362736001137",
  "status": "1",
  "address": "4264 EAST RD",
  "country": "USA",
  "website": "http://www.southlewis.org",
  "latitude": "43.63589617000008",
  "objectid": "65316",
  "st_grade": "05",
  "val_date": "2011-01-21T00:00:00Z",
  "end_grade": "08",
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "Point",
      "coordinates": [
        -75.39370735899996,
        43.63589617000008
      ]
    },
    "properties": {}
  },
  "longitude": "-75.39370735899996",
  "telephone": "(315) 348-2570",
  "countyfips": "36049",
  "districtid": "3627360",
  "enrollment": "253",
  "ft_teacher": "29",
  "naics_code": "611110",
  "naics_desc": "ELEMENTARY AND SECONDARY SCHOOLS",
  "population": "282",
  "shelter_id": "10805123",
  "sourcedate": "2009-10-13T00:00:00Z",
  "val_method": "IMAGERY",
  "geo_point_2d": {
    "lat": 43.63589617000008,
    "lon": -75.39370735899996
  }
}

Live sample captured at profiling time — values may have changed upstream.

Verification Status

Using the API

Configuration

Base URL: https://public.opendatasoft.com/api/explore/v2.1/catalog/datasets/us-public-schools

License

Terms stated by the source (not a recognized license):

https://en.wikipedia.org/wiki/Public_domain

Query examples

curl -s 'https://public.opendatasoft.com/api/explore/v2.1/catalog/datasets/us-public-schools/records?limit=20' -H 'Accept: application/json'

First 20 records of the dataset as JSON.

Uses the Opendatasoft Explore v2.1 syntax — supports select, where, group_by and order_by.

Full API documentation ↗

Rate limits

10 000 000 req/day

per ipmeasured

observed 6 days ago

Dataset

Volume & freshness

Records

107k

107299

Update cadence

Irregular

declared upstream

Last upstream update

4 years ago

2023-01-06

License

No license declared upstream.

○ Documentation○ Data dictionary○ Versioning

Source: opendatasoft

Machine-readable & source

JSON

Embed this badge in a README or wiki — it always shows the latest verification state and quality tier.