cityofnewyork-us/2008-2009-school-progress-reports-all-schools-cgz5-877h
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated almost 2 years ago
Indexed 1 month ago

2008 - 2009 School Progress Reports - All Schools

2008/09 Progress Report results for all schools (data as of 3/23/2010)

Peer indices are calculated differently depending on School Level. Schools are only compared to other schools in the same School Level (e.g., Elementary, K-8, Middle, High, Transfer)

1) Elementary & K-8 - peer index is a value from 0-100. We use a composite demographic statistic based on % ELL, % SpEd, % Title I free lunch, and % Black/Hispanic. Higher values indicate student populations with higher need.

2) Middle & High - peer index is a value from 1.00-4.50. For middle schools, we use the average 4th grade proficiency ratings in ELA and Math for all their students that have 4th grade test scores. For high schools, we use the average 8th grade proficiency ratings in ELA and Math for all their students that have 8th grade test scores, % SpEd, and % Overage. Lower values indicate student populations with higher need.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"cityofnewyork-us/2008-2009-school-progress-reports-all-schools-cgz5-877h\".\"2008_2009_school_progress_reports_all_schools\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • 2008_2009_school_progress_reports_all_schools
     
     
     
     
     
Upstream Metadata