US Public Schools

Name: US Public Schools
Creator: opendatasoft

APIQuery nowOpen workbench🇫🇷France

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 API base URL Read the docs

Trust score

How is this computed?

poor

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 1 hour 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: 72450 · city: PARAGOULD

{
  "zip": "72450",
  "city": "PARAGOULD",
  "name": "GREENE CO. TECH HIGH SCHOOL",
  "type": "1",
  "zip4": "NOT AVAILABLE",
  "level": "HIGH",
  "state": "AR",
  "county": "GREENE",
  "ncesid": "051308001066",
  "source": "http://nces.ed.gov/GLOBALLOCATOR/sch_info_popup.asp?Type=Public&ID=051308001066",
  "status": "1",
  "address": "5201 W KINGSHIGHWAY",
  "country": "USA",
  "website": "http://www.gctsd.k12.ar.us",
  "latitude": "36.00699505600005",
  "objectid": "30533",
  "st_grade": "10",
  "val_date": "2020-01-09T00:00:00Z",
  "end_grade": "12",
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "Point",
      "coordinates": [
        -90.53046720699996,
        36.00699505600005
      ]
    },
    "properties": {}
  },
  "longitude": "-90.53046720699996",
  "telephone": "(870) 215-4460",
  "countyfips": "05055",
  "districtid": "0513080",
  "enrollment": "826",
  "ft_teacher": "55",
  "naics_code": "611110",
  "naics_desc": "ELEMENTARY AND SECONDARY SCHOOLS",
  "population": "881",
  "shelter_id": "NOT AVAILABLE",
  "sourcedate": "2010-01-29T00:00:00Z",
  "val_method": "IMAGERY/OTHER",
  "geo_point_2d": {
    "lat": 36.00699505600005,
    "lon": -90.53046720699996
  }
}

Record 2zip: 92203 · city: INDIO

{
  "zip": "92203",
  "city": "INDIO",
  "name": "DESERT RIDGE ACADEMY",
  "type": "1",
  "zip4": "9647",
  "level": "ELEMENTARY",
  "state": "CA",
  "county": "RIVERSIDE",
  "ncesid": "061111012396",
  "source": "http://nces.ed.gov/GLOBALLOCATOR/sch_info_popup.asp?Type=Public&ID=061111012396",
  "status": "1",
  "address": "79-767 AVE. 39",
  "country": "USA",
  "website": "http://www.dsusd.k12.ca.us",
  "latitude": "33.76496424800007",
  "objectid": "30690",
  "st_grade": "06",
  "val_date": "2011-09-30T00:00:00Z",
  "end_grade": "08",
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "Point",
      "coordinates": [
        -116.27386018299995,
        33.76496424800007
      ]
    },
    "properties": {}
  },
  "longitude": "-116.27386018299995",
  "telephone": "(760) 393-5500",
  "countyfips": "06065",
  "districtid": "0611110",
  "enrollment": "1059",
  "ft_teacher": "38",
  "naics_code": "611110",
  "naics_desc": "ELEMENTARY AND SECONDARY SCHOOLS",
  "population": "1097",
  "shelter_id": "NOT AVAILABLE",
  "sourcedate": "2011-09-30T00:00:00Z",
  "val_method": "IMAGERY",
  "geo_point_2d": {
    "lat": 33.76496424800007,
    "lon": -116.27386018299995
  }
}

Record 3zip: 48623 · city: FREELAND

{
  "zip": "48623",
  "city": "FREELAND",
  "name": "FREELAND MIDDLE SCHOOLHIGH SCHOOL",
  "type": "1",
  "zip4": "8445",
  "level": "ELEMENTARY",
  "state": "MI",
  "county": "SAGINAW",
  "ncesid": "261506005188",
  "source": "http://nces.ed.gov/GLOBALLOCATOR/sch_info_popup.asp?Type=Public&ID=261506005188",
  "status": "1",
  "address": "8250 WEBSTER RD",
  "country": "USA",
  "website": "http://www.freelandschools.net",
  "latitude": "43.528410259000054",
  "objectid": "30726",
  "st_grade": "07",
  "val_date": "2010-08-27T00:00:00Z",
  "end_grade": "12",
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "Point",
      "coordinates": [
        -84.10883520799996,
        43.528410259000054
      ]
    },
    "properties": {}
  },
  "longitude": "-84.10883520799996",
  "telephone": "(989) 695-2586",
  "countyfips": "26145",
  "districtid": "2615060",
  "enrollment": "899",
  "ft_teacher": "41",
  "naics_code": "611110",
  "naics_desc": "ELEMENTARY AND SECONDARY SCHOOLS",
  "population": "940",
  "shelter_id": "10783327",
  "sourcedate": "2010-01-29T00:00:00Z",
  "val_method": "IMAGERY",
  "geo_point_2d": {
    "lat": 43.528410259000054,
    "lon": -84.10883520799996
  }
}

Record 4zip: 55126 · city: NORTH OAKS

{
  "zip": "55126",
  "city": "NORTH OAKS",
  "name": "CHIPPEWA MIDDLE SCHOOL",
  "type": "1",
  "zip4": "1226",
  "level": "HIGH",
  "state": "MN",
  "county": "RAMSEY",
  "ncesid": "272295001115",
  "source": "http://nces.ed.gov/GLOBALLOCATOR/sch_info_popup.asp?Type=Public&ID=272295001115",
  "status": "1",
  "address": "5000 HODGSON RD",
  "country": "USA",
  "website": "http://www.moundsviewschools.org/chippewa",
  "latitude": "45.092078180000044",
  "objectid": "30728",
  "st_grade": "06",
  "val_date": "2010-05-19T00:00:00Z",
  "end_grade": "08",
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "Point",
      "coordinates": [
        -93.12393459799995,
        45.092078180000044
      ]
    },
    "properties": {}
  },
  "longitude": "-93.12393459799995",
  "telephone": "(651) 621-6400",
  "countyfips": "27123",
  "districtid": "2722950",
  "enrollment": "1114",
  "ft_teacher": "48",
  "naics_code": "611110",
  "naics_desc": "ELEMENTARY AND SECONDARY SCHOOLS",
  "population": "1162",
  "shelter_id": "NOT AVAILABLE",
  "sourcedate": "2010-01-29T00:00:00Z",
  "val_method": "IMAGERY",
  "geo_point_2d": {
    "lat": 45.092078180000044,
    "lon": -93.12393459799995
  }
}

Record 5zip: 13209 · city: SOLVAY

{
  "zip": "13209",
  "city": "SOLVAY",
  "name": "SOLVAY ELEMENTARY SCHOOL",
  "type": "1",
  "zip4": "2099",
  "level": "ELEMENTARY",
  "state": "NY",
  "county": "ONONDAGA",
  "ncesid": "362715003698",
  "source": "http://nces.ed.gov/GLOBALLOCATOR/sch_info_popup.asp?Type=Public&ID=362715003698",
  "status": "1",
  "address": "701 WOODS RD",
  "country": "USA",
  "website": "http://www.solvayschools.org",
  "latitude": "43.057658428000025",
  "objectid": "30734",
  "st_grade": "KG",
  "val_date": "2010-08-23T00:00:00Z",
  "end_grade": "04",
  "geo_shape": {
    "type": "Feature",
    "geometry": {
      "type": "Point",
      "coordinates": [
        -76.20837635499998,
        43.057658428000025
      ]
    },
    "properties": {}
  },
  "longitude": "-76.20837635499998",
  "telephone": "(315) 488-5422",
  "countyfips": "36067",
  "districtid": "3627150",
  "enrollment": "484",
  "ft_teacher": "40",
  "naics_code": "611110",
  "naics_desc": "ELEMENTARY AND SECONDARY SCHOOLS",
  "population": "524",
  "shelter_id": "10801714",
  "sourcedate": "2010-01-29T00:00:00Z",
  "val_method": "IMAGERY",
  "geo_point_2d": {
    "lat": 43.057658428000025,
    "lon": -76.20837635499998
  }
}

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

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 1 hour 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.