Community Health: Obesity and Diabetes Related Indicators

This Obesity and Diabetes Related Indicators dataset provides a subset of data (40 indicators) for the two topics: Obesity and Diabetes. The dataset includes percentage or rate for Cirrhosis/Diabetes and Obesity and Related Indicators, where available, for all counties, regions and state. New York State Community Health Indicator Reports (CHIRS) were developed in 2012, and annually updated to provide data for over 300 health indicators, organized by 15 health topic and data for all counties, regions and state are presented in table format with links to trend graphs and maps (http://www.health.ny.gov/statistics/chac/indicators/). Most recent county and state level data are provided. Multiple year combined data offers stable estimates for the burden and risk factors for these two health topics. For more information, check out: http://www.health.ny.gov/statistics/chac/indicators/ or go to the “About” tab. This dataset is available at: https://health.data.ny.gov/Health/Community-Health-Obesity-and-Diabetes-Related-Indi/tchg-ruva

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 Community Health: Obesity and Diabetes Related Indicators 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/community-health-obesity-and-diabetes-related-indicators.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/community-health-obesity-and-diabetes-related-indicators.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/community-health-obesity-and-diabetes-related-indicators.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/community-health-obesity-and-diabetes-related-indicators.json?recall_id=94"

Fields

The following fields are available on the Community Health: Obesity and Diabetes Related Indicators API.

county_name

Human Name: County Name
Type: text
Full county/region name

Examples

Retrieve all records with county_name equal to Yates:

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

https://health.data.ny.gov/resource/community-health-obesity-and-diabetes-related-indicators.json?$where=within_circle(county_name, 47.598177,-122.33448, 1000)

county_code

Human Name: County Code
Type: number
County code (1-62, 101-108, 888,999)

Examples

Retrieve all records with county_code equal to 999:

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

https://health.data.ny.gov/resource/community-health-obesity-and-diabetes-related-indicators.json?$where=within_circle(county_code, 47.598177,-122.33448, 1000)

region_name

Human Name: Region Name
Type: text
Full region name

Examples

Retrieve all records with region_name equal to Western New York:

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

https://health.data.ny.gov/resource/community-health-obesity-and-diabetes-related-indicators.json?$where=within_circle(region_name, 47.598177,-122.33448, 1000)

indicator_number

Human Name: Indicator Number
Type: text
Unique indicator identifier

Examples

Retrieve all records with indicator_number equal to h5a:

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

https://health.data.ny.gov/resource/community-health-obesity-and-diabetes-related-indicators.json?$where=within_circle(indicator_number, 47.598177,-122.33448, 1000)

indicator

Human Name: Indicator
Type: text
Full text description of the health indicator

Examples

Retrieve all records with indicator equal to Percentage overweight or obese (85th percentile or higher) - Middle and high school students:
Retrieve all records with indicator equal to Percentage overweight or obese (85th percentile or higher) - Middle and high school students:

Retrieve all records that are greater than Age-adjusted cardiovascular disease hospitalization rate per 10,000:

Retrieve all records with indicator equal to Percentage overweight or obese (85th percentile or higher) - Middle and high school students:

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

https://health.data.ny.gov/resource/community-health-obesity-and-diabetes-related-indicators.json?$where=within_circle(indicator, 47.598177,-122.33448, 1000)

total_event_counts

Human Name: Total Event Counts
Type: number
Total event counts for the time period, used for rate computations (numerators)

Examples

Retrieve all records with total_event_counts equal to 1461651:

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

https://health.data.ny.gov/resource/community-health-obesity-and-diabetes-related-indicators.json?$where=within_circle(total_event_counts, 47.598177,-122.33448, 1000)

denominator

Human Name: Denominator
Type: number
Denominator for rate computations, often the annual average population for the time period

Examples

Retrieve all records with denominator equal to 19461584:

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

https://health.data.ny.gov/resource/community-health-obesity-and-diabetes-related-indicators.json?$where=within_circle(denominator, 47.598177,-122.33448, 1000)

denominator_note

Human Name: Denominator Note
Type: text
Notice of the total population or average annual population denominator for the time period

Examples

Retrieve all records with denominator_note equal to Average annual population:

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

https://health.data.ny.gov/resource/community-health-obesity-and-diabetes-related-indicators.json?$where=within_circle(denominator_note, 47.598177,-122.33448, 1000)

measure_unit

Human Name: Measure Unit
Type: text
Result type, rate or percentage

Examples

Retrieve all records with measure_unit equal to Rate:

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

https://health.data.ny.gov/resource/community-health-obesity-and-diabetes-related-indicators.json?$where=within_circle(measure_unit, 47.598177,-122.33448, 1000)

percentage_rate

Human Name: Percentage/Rate
Type: number
Numerical indicator value estimate

Examples

Retrieve all records with percentage_rate equal to 466.6:

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

https://health.data.ny.gov/resource/community-health-obesity-and-diabetes-related-indicators.json?$where=within_circle(percentage_rate, 47.598177,-122.33448, 1000)

_95_ci

Human Name: 95% CI
Type: text
95% Confidence Intervals for percentage estimates from survey data

Examples

Retrieve all records with _95_ci equal to (9.6-16.8):

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

https://health.data.ny.gov/resource/community-health-obesity-and-diabetes-related-indicators.json?$where=within_circle(_95_ci, 47.598177,-122.33448, 1000)

data_comments

Human Name: Data Comments
Type: text
Indicate when the county data is unstable or suppressed due to small number of events

Examples

Retrieve all records with data_comments equal to Unstable Estimate:

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

https://health.data.ny.gov/resource/community-health-obesity-and-diabetes-related-indicators.json?$where=within_circle(data_comments, 47.598177,-122.33448, 1000)

data_years

Human Name: Data Years
Type: text
Time period for raw data used in indicator computation

Examples

Retrieve all records with data_years equal to 2010-2012:

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

https://health.data.ny.gov/resource/community-health-obesity-and-diabetes-related-indicators.json?$where=within_circle(data_years, 47.598177,-122.33448, 1000)

data_sources

Human Name: Data Sources
Type: text
Data sources for the raw data used in indicator computation

Examples

Retrieve all records with data_sources equal to 2010-2012 Student Weight Status Category Reporting System Data as of July, 2013:
Retrieve all records with data_sources equal to 2010-2012 Student Weight Status Category Reporting System Data as of July, 2013:

Retrieve all records that are greater than 2008-2009 NYS Expanded Behavioral Risk Factor Surveillance System Data as of 2010:

Retrieve all records with data_sources equal to 2010-2012 Student Weight Status Category Reporting System Data as of July, 2013:

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

https://health.data.ny.gov/resource/community-health-obesity-and-diabetes-related-indicators.json?$where=within_circle(data_sources, 47.598177,-122.33448, 1000)

quartile

Human Name: Quartile
Type: text
Quartile(s) that indicator estimate falls within

Examples

Retrieve all records with quartile equal to Data do not meet reporting criteria:

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

https://health.data.ny.gov/resource/community-health-obesity-and-diabetes-related-indicators.json?$where=within_circle(quartile, 47.598177,-122.33448, 1000)

mapping_distribution

Human Name: Mapping Distribution
Type: number
Grouping of county rates for color shades in the map (value of "1" indicates the best group and "3" indicates the worst group)

Examples

Retrieve all records with mapping_distribution equal to 3:

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

https://health.data.ny.gov/resource/community-health-obesity-and-diabetes-related-indicators.json?$where=within_circle(mapping_distribution, 47.598177,-122.33448, 1000)

location

Human Name: Location
Type: location
Lat/Long decimal degree coordinates for the region covered by the indicator, for use in mapping

Examples

Retrieve all records with location equal to longitude: -73.119032, latitude: 40.820237:

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

https://health.data.ny.gov/resource/community-health-obesity-and-diabetes-related-indicators.json?$where=within_circle(location, 47.598177,-122.33448, 1000)