CPS Elementary School Progress Report Card 2012-2013

JohnSnowLabs

Files Size Format Created Updated License Source
2 2MB csv zip 1 week ago John Snow Labs Standard License John Snow Labs Data City of Chicago
Download

Data Files

cps-elementary-school-progress-report-card-2012-2013-csv  

This is a preview version. There might be more data in the original version.

Field information

Field Name Order Type (Format) Description
School_ID 1 string A unique identification number for database record for saving school progress report school wise.
School_Short_Name 2 string Short Name of School
School_Name 3 string Name of School registered with Chicago Public Schools
Street_Address 4 string School Street Address
ZIP_Code 5 integer School ZIP Code
Phone_Number 6 string School Contact Phone Number
Website 7 string School Website Link
Managed_By_Network 8 string School managed by company network
Geographic_Network 9 string Geographic Network o fschool
School_Track 10 string School Track
Overall_Rating 11 string The Overall Rating on the school progress report is based on the school’s rating under the 2012-2013 Performance, Remediation and Probation Policy. Level 1 is highest.
Is_On_Probation 12 boolean Is the school on probation
Years_on_Probation 13 integer How many years has the school been on probation
NWEA_or_Scantron 14 string Assessment test used
Growth_Overall_Level 15 string Student growth compared to similar schools nationally
Growth_Overall_Reading_and_Math 16 number Portion of students making expected growth between fall and spring tests
Reading_Growth_Grade_3 17 number Portion of students making expected growth between fall and spring tests. The national average is 0.5.
Reading_Growth_Grade_4 18 number Portion of students making expected growth between fall and spring tests. The national average is 0.5.
Reading_Growth_Grade_5 19 number Portion of students making expected growth between fall and spring tests. The national average is 0.5.
Reading_Growth_Grade_6 20 number Portion of students making expected growth between fall and spring tests. The national average is 0.5.
Reading_Growth_Grade_7 21 number Portion of students making expected growth between fall and spring tests. The national average is 0.5.
Reading_Growth_Grade_8 22 number Portion of students making expected growth between fall and spring tests. The national average is 0.5.
Reading_Growth_All_Grades 23 number Portion of students making expected growth between fall and spring tests. The national average is 0.5.
Math_Growth_Grade_3 24 number Portion of students making expected growth between fall and spring tests. The national average is 0.5.
Math_Growth_Grade_4 25 number Portion of students making expected growth between fall and spring tests. The national average is 0.5.
Math_Growth_Grade_5 26 number Portion of students making expected growth between fall and spring tests. The national average is 0.5.
Math_Growth_Grade_6 27 number Portion of students making expected growth between fall and spring tests. The national average is 0.5.
Math_Growth_Grade_7 28 number Portion of students making expected growth between fall and spring tests. The national average is 0.5.
Math_Growth_Grade_8 29 number Portion of students making expected growth between fall and spring tests. The national average is 0.5.
Math_Growth_All_Grades 30 number Portion of students making expected growth between fall and spring tests. The national average is 0.5.
Student_Performance_Level 31 string Student performance on the test compared to similar schools nationally
Student_Performance_Reading_and_Math 32 number Portion of students performing at or above the national average. Weighted average of reading and math results. The national average is 0.5.
Reading_Performance_Grade_3 33 number Portion of students performing at or above the national average. The national average is 0.5.
Reading_Performance_Grade_4 34 number Portion of students performing at or above the national average. The national average is 0.5.
Reading_Performance_Grade_5 35 number Portion of students performing at or above the national average. The national average is 0.5.
Reading_Performance_Grade_6 36 number Portion of students performing at or above the national average. The national average is 0.5.
Reading_Performance_Grade_7 37 number Portion of students performing at or above the national average. The national average is 0.5.
Reading_Performance_Grade_8 38 number Portion of students performing at or above the national average. The national average is 0.5.
Reading_Performance_All_Grades 39 number Portion of students performing at or above the national average. The national average is 0.5.
Math_Performance_Grade_3 40 number Portion of students performing at or above the national average. The national average is 0.5.
Math_Performance_Grade_4 41 number Portion of students performing at or above the national average. The national average is 0.5.
Math_Performance_Grade_5 42 number Portion of students performing at or above the national average. The national average is 0.5.
Math_Performance_Grade_6 43 number Portion of students performing at or above the national average. The national average is 0.5.
Math_Performance_Grade_7 44 number Portion of students performing at or above the national average. The national average is 0.5.
Math_Performance_Grade_8 45 number Portion of students performing at or above the national average. The national average is 0.5.
Math_Performance_All_Grades 46 number Portion of students performing at or above the national average. The national average is 0.5.
Reading_Growth_African_American 47 number Portion of African American students making expected growth between fall and spring tests. The national average is 0.5. No results are shown if there were fewer than 30 students.
Reading_Growth_Hispanic 48 number Portion of Hispanic students making expected growth between fall and spring tests. The national average is 0.5. No results are shown if there were fewer than 30 students.
Reading_Growth_White 49 number Portion of White students making expected growth between fall and spring tests. The national average is 0.5. No results are shown if there were fewer than 30 students.
Reading_Growth_Students_with_Disabilities 50 number Portion of students with disabilities making expected growth between fall and spring tests. The national average is 0.5. No results are shown if there were fewer than 30 students.
Reading_Growth_English_Language_Learners 51 number Portion of English language learners making expected growth between fall and spring tests. The national average is 0.5. No results are shown if there were fewer than 30 students.
Reading_Growth_Free_and_Reduced_Lunch 52 number Portion of students receiving free or reduced lunch making expected growth between fall and spring tests. The national average is 0.5. No results are shown if there were fewer than 30 students.
Math_Growth_African_American 53 number Portion of African American students making expected growth between fall and spring tests. The national average is 0.5. No results are shown if there were fewer than 30 students.
Math_Growth_Hispanic 54 number Portion of Hispanic students making expected growth between fall and spring tests. The national average is 0.5. No results are shown if there were fewer than 30 students.
Math_Growth_White 55 number Portion of White students making expected growth between fall and spring tests. The national average is 0.5. No results are shown if there were fewer than 30 students.
Math_Growth_Students_with_Disabilities 56 number Portion of students with disabilities making expected growth between fall and spring tests. The national average is 0.5. No results are shown if there were fewer than 30 students.
Math_Growth_English_Language_Learners 57 number Portion of English language learners making expected growth between fall and spring tests. The national average is 0.5. No results are shown if there were fewer than 30 students.
Math_Growth_Free_and_Reduced_Lunch 58 number Portion of students receiving free or reduced lunch making expected growth between fall and spring tests. The national average is 0.5. No results are shown if there were fewer than 30 students.
Overall_Foundation 59 string Overall status from the "My Voice, My School" survey completed by teachers and 6th-12th grade students.
Involved_Families 60 string Does the school partner with families and communities
Supportive_Environment 61 string Is the school safe and supportive with high expectations
Ambitious_Instruction 62 string Is instruction focused, challenging, and engaging
Effective_Leaders 63 string Does leadership focus on results and school improvement
Collaborative_Teachers 64 string Do teachers work well together and strive for excellence
Safety 65 string Do students feel safe and does the school support positive behavior
Misconducts_Resulting_in_Suspensions_2011_to_Percent 66 string Number of misconducts resulting in suspension divided by the number of misconducts reported.
Misconducts_Resulting_in_Suspensions_2012_to_Percent 67 number Number of misconducts resulting in suspension divided by the number of misconducts reported.
Average_Days_of_Suspension_2011 68 number Average length of suspensions, in days, divided by the number of suspensions.
Average_Days_of_Suspension_2012 69 number Average length of suspensions, in days, divided by the number of suspensions.
Student_Attendance_2011_to_Percent 70 number Average daily attendance of students -- the number of days in which students were present divided by the number of days in which students were scheduled to attend.
Student_Attendance_2012_to_Percent 71 number Average daily attendance of students -- the number of days in which students were present divided by the number of days in which students were scheduled to attend.
Teacher_Attendance_2011_to_Percent 72 number Average daily attendance of teachers -- the number of days in which teachers were present divided by the number of days they were scheduled to work.
Teacher_Attendance_2012_to_Percent 73 number Average daily attendance of teachers -- the number of days in which teachers were present divided by the number of days they were scheduled to work.
Healthy_School_Certified 74 string Is the school certified by the USDA’s Healthier US School Challenge
Is_Blue_Ribbon_Award 75 boolean Did the school win a U.S. Department of Education Blue Ribbon
Blue_Ribbon_Award_Year 76 date (%Y-%m-%d) Year in which the school won a U.S. Department of Education Blue Ribbon.
X_Coordinate 77 number X Coordiante of School
Y_Coordinate 78 number Y Coordiante of School
Latitude 79 number School Latitude Location
Longitude 80 number School Latitude Location

cps-elementary-school-progress-report-card-2012-2013_zip  

This is a preview version. There might be more data in the original version.

Read me

Import into your tool

If you are using R here's how to get the data you want quickly loaded:

install.packages("jsonlite")
library("jsonlite")

json_file <- "http://datahub.io/JohnSnowLabs/cps-elementary-school-progress-report-card-2012-2013/datapackage.json"
json_data <- fromJSON(paste(readLines(json_file), collapse=""))

# access csv file by the index starting from 1
path_to_file = json_data$resources$path[1][1]
data <- read.csv(url(path_to_file))
print(data)

In order to work with Data Packages in Pandas you need to install the Frictionless Data data package library and the pandas extension:

pip install datapackage
pip install jsontableschema-pandas

To get the data run following code:

import datapackage

data_url = "http://datahub.io/JohnSnowLabs/cps-elementary-school-progress-report-card-2012-2013/datapackage.json"

# to load Data Package into storage
storage = datapackage.push_datapackage(data_url, 'pandas')

# data frames available (corresponding to data files in original dataset)
storage.buckets

# you can access datasets inside storage, e.g. the first one:
storage[storage.buckets[0]]

For Python, first install the `datapackage` library (all the datasets on DataHub are Data Packages):

pip install datapackage

To get Data Package into your Python environment, run following code:

from datapackage import Package

package = Package('http://datahub.io/JohnSnowLabs/cps-elementary-school-progress-report-card-2012-2013/datapackage.json')

# get list of resources:
resources = package.descriptor['resources']
resourceList = [resources[x]['name'] for x in range(0, len(resources))]
print(resourceList)

data = package.resources[0].read()
print(data)

If you are using JavaScript, please, follow instructions below:

Install data.js module using npm:

  $ npm install data.js

Once the package is installed, use the following code snippet:

const {Dataset} = require('data.js')

const path = 'http://datahub.io/JohnSnowLabs/cps-elementary-school-progress-report-card-2012-2013/datapackage.json'

// We're using self-invoking function here as we want to use async-await syntax:
(async () => {
  const dataset = await Dataset.load(path)

  // Get the first data file in this dataset
  const file = dataset.resources[0]
  // Get a raw stream
  const stream = await file.stream()
  // entire file as a buffer (be careful with large files!)
  const buffer = await file.buffer
})()

Install the datapackage library created specially for Ruby language using gem:

gem install datapackage

Now get the dataset and read the data:

require 'datapackage'

path = 'http://datahub.io/JohnSnowLabs/cps-elementary-school-progress-report-card-2012-2013/datapackage.json'

package = DataPackage::Package.new(path)
# So package variable contains metadata. You can see it:
puts package

# Read data itself:
resource = package.resources[0]
data = resource.read
puts data
Datapackage.json