Student Weight Status Category Reporting Results: Beginning 2010

The Student Weight Status Category Reporting System (SWSCR) collects weight status category data (underweight, healthy weight, overweight or obese, based on BMI-for-age percentile). The dataset includes separate estimates of the percent of students overweight, obese and overweight or obese for all reportable grades within the county and/or region and by grade groups (elementary and middle/high). The rates of overweight and obesity reported are percentages based on counts of students in selected grades (Pre-K, K, 2, 4, 7, 10) reported to the NYSDOH. Because these rates reflect a broad range of factors that vary by school district, to make comparisons about observed differences in the rates of obesity and overweight between school districts requires the use of multivariate statistics. For more information check out http://www.health.ny.gov/prevention/obesity/, see our Instruction Guide on How to Create Visualizations https://health.data.ny.gov/api/assets/6490BDA9-AE4D-406F-BA5A-703793526B9F or go to the "About" tab. This data set is available at: https://health.data.ny.gov/Health/Student-Weight-Status-Category-Reporting-Results-B/es3k-2aus

Getting Started

All communication with the API is done through HTTPS, and errors are communicated through HTTP response codes. Available response types include JSON, XML, and CSV, which are selectable by the "extension" on API requests or by HTTP Accepts headers.

This documentation also includes inline, runable examples. Click on any link that contains a gear symbol next to it to run that example live against the Student Weight Status Category Reporting Results: Beginning 2010 API.

App Tokens

All requests should include an app token that identifies your application, and each application should have its own unique app token. A limited number of requests can be made without an app token, but they are subject to much lower throttling limits than request that do include one. If you don't have an app token yet, click the button to the right to sign up for one.

Once you have an app token, you can include it with your request either by using the X-App-Token HTTP header, or by passing it via the $app_token parameter on your URL.

Response Codes

One of the following response codes will be returned with every request:

  1. 200Successful request.
  2. 202Request processing. You can retry your request, and when it's complete, you'll get a 200 instead.
  3. 400Bad request
  4. 401Unauthorized. You're not authorized to access this resource.
  5. 404Not found. The resource requested doesn't exist.
  6. 429Too Many Requests. The client has made too many requests and is currently being rate limited.
  7. 500Server errors. Our bad!

Code Samples

#!/usr/bin/env ruby

require 'net/https'
uri = URI('https://health.data.ny.gov/resource/student-weight-status-category-reporting-results-beginning-2010.json?recall_id=94')

http = Net::HTTP.new(uri.host, uri.port)
http.use_ssl = true
http.verify_mode = OpenSSL::SSL::VERIFY_PEER

request = Net::HTTP::Get.new(uri.request_uri)
request.add_field('X-App-Token', ARGV[0])

response = http.request(request)
puts response.code
puts response.body
#!/usr/bin/env python

import sys
import requests

r = requests.get('https://health.data.ny.gov/resource/student-weight-status-category-reporting-results-beginning-2010.json?recall_id=94', headers={'X-App-Token': sys.argv[1]})
print r.status_code
print r.text
request = require 'request'
options = uri: 'https://health.data.ny.gov/resource/student-weight-status-category-reporting-results-beginning-2010.json?$$app_token=APP_TOKEN&recall_id=94'
request options, (err, response, body) ->  console.log body
#!/bin/sh 

curl --header "X-App-Token: $1" "https://health.data.ny.gov/resource/student-weight-status-category-reporting-results-beginning-2010.json?recall_id=94"

Fields

The following fields are available on the Student Weight Status Category Reporting Results: Beginning 2010 API.

location_code

Human Name: LOCATION CODE
Type: text
6-digit code identifying the location type. For school districts, this is the 6-digit NYSED district BEDS code. For counties, this is the 6-digit NYSED county code. Regional codes range from 100000 – 700000. Statewide = 000000.

Examples

Retrieve all records with location_code equal to 700000:

Retrieve all records where location_code is within 1 kilometer of Seattle, WA (47.598177,-122.33448):

https://health.data.ny.gov/resource/student-weight-status-category-reporting-results-beginning-2010.json?$where=within_circle(location_code, 47.598177,-122.33448, 1000)

county

Human Name: COUNTY
Type: text
NYS county

area_name

Human Name: AREA NAME
Type: text
School district, county, or region name

Examples

Retrieve all records with area_name equal to YORKTOWN CENTRAL SCHOOL:

Retrieve all records where area_name is within 1 kilometer of Seattle, WA (47.598177,-122.33448):

https://health.data.ny.gov/resource/student-weight-status-category-reporting-results-beginning-2010.json?$where=within_circle(area_name, 47.598177,-122.33448, 1000)

region

Human Name: REGION
Type: text
NYS region

Examples

Retrieve all records with region equal to WESTERN NEW YORK:

Retrieve all records where region is within 1 kilometer of Seattle, WA (47.598177,-122.33448):

https://health.data.ny.gov/resource/student-weight-status-category-reporting-results-beginning-2010.json?$where=within_circle(region, 47.598177,-122.33448, 1000)

school_years

Human Name: SCHOOL YEARS
Type: text
School years covered by reporting cycle

Examples

Retrieve all records with school_years equal to 2010-2012:

Retrieve all records where school_years is within 1 kilometer of Seattle, WA (47.598177,-122.33448):

https://health.data.ny.gov/resource/student-weight-status-category-reporting-results-beginning-2010.json?$where=within_circle(school_years, 47.598177,-122.33448, 1000)

overweight_1

Human Name: NO. OVERWEIGHT
Type: number
Number of students in 85th to 94th percentile (Overweight). For children aged 2-19 years of age, overweight and obese are defined by plotting calculated Body-Mass Index (BMI) for age on sex-specific growth curves BMI = (weight in kilograms)/(height in meters)2. Overweight is defined as BMI for age at or above the 85th percentile and lower than the 95th percentile.

Examples

Retrieve all records with overweight_1 equal to 77813:

Retrieve all records where overweight_1 is within 1 kilometer of Seattle, WA (47.598177,-122.33448):

https://health.data.ny.gov/resource/student-weight-status-category-reporting-results-beginning-2010.json?$where=within_circle(overweight_1, 47.598177,-122.33448, 1000)

overweight_2

Human Name: PCT OVERWEIGHT
Type: percent
Percentage of students in 85th to 94th percentile (Overweight). For children aged 2-19 years of age, overweight and obese are defined by plotting calculated Body-Mass Index (BMI)for age on sex-specific growth curves BMI = (weight in kilograms)/(height in meters)2. Overweight is defined as BMI for age at or above the 85th percentile and lower than the 95th percentile.

Examples

Retrieve all records with overweight_2 equal to 70.6:

Retrieve all records where overweight_2 is within 1 kilometer of Seattle, WA (47.598177,-122.33448):

https://health.data.ny.gov/resource/student-weight-status-category-reporting-results-beginning-2010.json?$where=within_circle(overweight_2, 47.598177,-122.33448, 1000)

obese_1

Human Name: NO. OBESE
Type: number
Number of students at or above the 95th percentile (Obese). For children aged 2-19 years of age, overweight and obese are defined by plotting calculated Body-Mass Index (BMI)for age on sex-specific growth curves BMI = (weight in kilograms)/(height in meters)2. Overweight is defined as BMI for age at or above the 85th percentile and lower than the 95th percentile. Obesity is defined as BMI for age at or above the 95th percentile.

obese_2

Human Name: PCT OBESE
Type: percent
Percentage of students at or above the 95th percentile (Obese). For children aged 2-19 years of age, overweight and obese are defined by plotting calculated Body-Mass Index (BMI) for age on sex-specific growth curves BMI = (weight in kilograms)/(height in meters)2. Overweight is defined as BMI for age at or above the 85th percentile and lower than the 95th percentile. Obesity is defined as BMI for age at or above the 95th percentile.

overweight_or_obese_1

Human Name: NO. OVERWEIGHT OR OBESE
Type: number
Number of students at or above the 85th percentile (Overweight or obese). For children aged 2-19 years of age, overweight and obese are defined by plotting calculated Body-Mass Index (BMI) for age on sex-specific growth curves BMI = (weight in kilograms)/(height in meters)2. Overweight is defined as BMI for age at or above the 85th percentile and lower than the 95th percentile.Obesity is defined as BMI for age at or above the 95th percentile.

Examples

Retrieve all records with overweight_or_obese_1 equal to 162391:

Retrieve all records where overweight_or_obese_1 is within 1 kilometer of Seattle, WA (47.598177,-122.33448):

https://health.data.ny.gov/resource/student-weight-status-category-reporting-results-beginning-2010.json?$where=within_circle(overweight_or_obese_1, 47.598177,-122.33448, 1000)

overweight_or_obese_2

Human Name: PCT OVERWEIGHT OR OBESE
Type: percent
Percentage of students at or above the 85th percentile (Overweight or obese). For children aged 2-19 years of age, overweight and obese are defined by plotting calculated Body-Mass Index (BMI) for age on sex-specific growth curves BMI = (weight in kilograms)/(height in meters)2. Overweight is defined as BMI for age at or above the 85th percentile and lower than the 95th percentile.Obesity is defined as BMI for age at or above the 95th percentile.

Examples

Retrieve all records with overweight_or_obese_2 equal to 70.6:

Retrieve all records where overweight_or_obese_2 is within 1 kilometer of Seattle, WA (47.598177,-122.33448):

https://health.data.ny.gov/resource/student-weight-status-category-reporting-results-beginning-2010.json?$where=within_circle(overweight_or_obese_2, 47.598177,-122.33448, 1000)

grade_category

Human Name: GRADE LEVEL
Type: text
Grade category (Elementary (grades Pre-K, K, 2 & 4); Middle/high (grades 7 & 10); or District total (grades Pre-K, K, 2, 4, 7 & 10))

Examples

Retrieve all records with grade_category equal to MIDDLE/HIGH:

Retrieve all records where grade_category is within 1 kilometer of Seattle, WA (47.598177,-122.33448):

https://health.data.ny.gov/resource/student-weight-status-category-reporting-results-beginning-2010.json?$where=within_circle(grade_category, 47.598177,-122.33448, 1000)

area_type

Human Name: AREA TYPE
Type: text
Area type definition (Statewide, excluding NYC; Region; County; School District)

Examples

Retrieve all records with area_type equal to STATEWIDE (EXCLUDING NYC):

Retrieve all records where area_type is within 1 kilometer of Seattle, WA (47.598177,-122.33448):

https://health.data.ny.gov/resource/student-weight-status-category-reporting-results-beginning-2010.json?$where=within_circle(area_type, 47.598177,-122.33448, 1000)

street_address

Human Name: STREET ADDRESS
Type: text
Street address of school district home office

Examples

Retrieve all records with street_address equal to S 5120 ORCHARD AVE:

Retrieve all records where street_address is within 1 kilometer of Seattle, WA (47.598177,-122.33448):

https://health.data.ny.gov/resource/student-weight-status-category-reporting-results-beginning-2010.json?$where=within_circle(street_address, 47.598177,-122.33448, 1000)

city

Human Name: CITY
Type: text
City of school district home office

state

Human Name: STATE
Type: text
State of school district home office

zip_code

Human Name: ZIP CODE
Type: text
Zip code of school district home office

location_1

Human Name: Location 1
Type: location
Latitude and longitude of district home or county (blank for region and statewide)

Examples

Retrieve all records with location_1 equal to longitude: -77.078311, latitude: 42.634338:

Retrieve all records where location_1 is within 1 kilometer of Seattle, WA (47.598177,-122.33448):

https://health.data.ny.gov/resource/student-weight-status-category-reporting-results-beginning-2010.json?$where=within_circle(location_1, 47.598177,-122.33448, 1000)