CPS Elementary School Progress Report Card 2013-2014

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-2013-2014-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_Name 2 string Name of School
Street_Address 3 string School Street Address
ZIP_Code 4 integer School ZIP Code
Phone_Number 5 string School Contact Phone Number
Website 6 string School Website Link
Blue_Ribbon_Award 7 date (%Y-%m-%d) School win a U.S. Department of Education Blue Ribbon in Year
CPS_Performance_Policy_Level 8 string Chicago Public School Policy Level
CPS_Performance_Policy_Status 9 string Chicago Public School Policy Status
Probation_Length 10 integer The number of years a school has been placed on probation. The value is only present if "CPS Performance Policy Status" is listed as "ON PROBATION".
My_School_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.
Student_Response_Rate 12 number Rate of Students Response
Teacher_Response_Rate 13 number Rate of Teacher Response
Involved_Family 14 string Does the school partner with families and communities
Supportive_Environment 15 string Is the school safe and supportive with high expectations
Ambitious_Instruction 16 string Is instruction focused, challenging, and engaging
Effective_Leaders 17 string Does leadership focus on results and school improvement
Collaborative_Teachers 18 string Do teachers work well together and strive for excellence
Safe 19 string Do students feel safe and does the school support positive behavior
School_Community 20 string School Community
Parent_Teacher_Partnership 21 string Parent Teacher Partnership
Quality_of_Facilities 22 string Facilities Quality
Healthy_Schools_Certification 23 string School Healthy Certification
Creative_Schools_Certification 24 string School Creative Certification
NWEA_Reading_Growth_Percentile_All_Grades 25 integer Northwest Evaluation Association Percentage Reading Growth for All Grades
NWEA_Reading_Growth_Percentile_Grade_3 26 integer Northwest Evaluation Association Percentage Reading Growth for Grades 3
NWEA_Reading_Growth_Percentile_Grade_4 27 integer Northwest Evaluation Association Percentage Reading Growth for Grades 4
NWEA_Reading_Growth_Percentile_Grade_5 28 integer Northwest Evaluation Association Percentage Reading Growth for Grades 5
NWEA_Reading_Growth_Percentile_Grade_6 29 integer Northwest Evaluation Association Percentage Reading Growth for Grades 6
NWEA_Reading_Growth_Percentile_Grade_7 30 integer Northwest Evaluation Association Percentage Reading Growth for Grades 7
NWEA_Reading_Growth_Percentile_Grade_8 31 integer Northwest Evaluation Association Percentage Reading Growth for Grades 8
NWEA_Math_Growth_Percentile_All_Grades 32 integer Northwest Evaluation Association Percentage Math Growth for All Grades
NWEA_Math_Growth_Percentile_Grade_3 33 integer Northwest Evaluation Association Percentage Math Growth for Grades 3
NWEA_Math_Growth_Percentile_Grade_4 34 integer Northwest Evaluation Association Percentage Math Growth for Grades 4
NWEA_Math_Growth_Percentile_Grade_5 35 integer Northwest Evaluation Association Percentage Math Growth for Grades 5
NWEA_Math_Growth_Percentile_Grade_6 36 integer Northwest Evaluation Association Percentage Math Growth for Grades 6
NWEA_Math_Growth_Percentile_Grade_7 37 integer Northwest Evaluation Association Percentage Math Growth for Grades 7
NWEA_Math_Growth_Percentile_Grade_8 38 integer Northwest Evaluation Association Percentage Math Growth for Grades 8
NWEA_Reading_Attainment_Percentile_All_Grades 39 integer Northwest Evaluation Association Attainment Growth for All Grades
NWEA_Reading_Attainment_Percentile_Grade_2 40 integer Northwest Evaluation Association Attainment Growth for Grades 3
NWEA_Reading_Attainment_Percentile_Grade_3 41 integer Northwest Evaluation Association Attainment Growth for Grades 4
NWEA_Reading_Attainment_Percentile_Grade_4 42 integer Northwest Evaluation Association Attainment Growth for Grades 4
NWEA_Reading_Attainment_Percentile_Grade_5 43 integer Northwest Evaluation Association Attainment Growth for Grades 5
NWEA_Reading_Attainment_Percentile_Grade_6 44 integer Northwest Evaluation Association Attainment Growth for Grades 6
NWEA_Reading_Attainment_Percentile_Grade_7 45 integer Northwest Evaluation Association Attainment Growth for Grades 7
NWEA_Reading_Attainment_Percentile_Grade_8 46 integer Northwest Evaluation Association Attainment Growth for Grades 8
NWEA_Math_Attainment_Percentile_All_Grades 47 integer Northwest Evaluation Association Math Attainment Growth for All Grades
NWEA_Math_Attainment_Percentile_Grade_2 48 integer Northwest Evaluation Association Math Attainment Growth for Grades 2
NWEA_Math_Attainment_Percentile_Grade_3 49 integer Northwest Evaluation Association Math Attainment Growth for Grades 3
NWEA_Math_Attainment_Percentile_Grade_4 50 integer Northwest Evaluation Association Math Attainment Growth for Grades 4
NWEA_Math_Attainment_Percentile_Grade_5 51 integer Northwest Evaluation Association Math Attainment Growth for Grades 5
NWEA_Math_Attainment_Percentile_Grade_6 52 integer Northwest Evaluation Association Math Attainment Growth for Grades 6
NWEA_Math_Attainment_Percentile_Grade_7 53 integer Northwest Evaluation Association Math Attainment Growth for Grades 7
NWEA_Math_Attainment_Percentile_Grade_8 54 integer Northwest Evaluation Association Math Attainment Growth for Grades 8
Suspensions_Per_100_Students_2013 55 number Students suspension in year 2013 per 100 records
Suspensions_Per_100_Students_2012 56 number Students suspension in year 2012 per 100 records
Percentage_Misconducts_Resulting_in_Suspension_2013 57 number Percentage Misconducts Resulting in Suspension Year 2013
Percentage_Misconducts_Resulting_in_Suspension_2012 58 number Percentage Misconducts Resulting in Suspension Year 2012
Average_Length_of_Suspensions_2013 59 number Average Length of Suspensions Year 2013
Average_Length_of_Suspension_2012 60 number Average Length of Suspensions Year 2013
Student_Attendance_Percentage_2013 61 number Percentage of Students Attendance in Year 2013
Student_Attendance_Percentage_2012 62 number Percentage of Students Attendance in Year 2012
Teacher_Attendance_Percentage_2013 63 number Percentage of Teacher Attendance in Year 2013
Teacher_Attendance_Percentage_2012 64 number Percentage of Teacher Attendance in Year 2012
Grade_3_to_8_On_Track_Percentage_2013 65 number Percentage of On Track Grade from 3 to 8
One_Year_Drop_Out_Rate_Percentage_2013 66 number Drop Out Percentage in 2013
X_Coordinate 67 number X Coordiante of School
Y_Coordinate 68 number Y Coordiante of School
Longitude 69 number School Latitude Location
Latitude 70 number School Latitude Location

cps-elementary-school-progress-report-card-2013-2014_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-2013-2014/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-2013-2014/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-2013-2014/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-2013-2014/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-2013-2014/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