CPS Elementary School Progress Report Card 2013-2014

JohnSnowLabs

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

Data Files

File Description Size Last changed Download
cps-elementary-school-progress-report-card-2013-2014-csv 212kB csv (212kB) , json (1MB)
cps-elementary-school-progress-report-card-2013-2014_zip Compressed versions of dataset. Includes normalized CSV and JSON data with original data and datapackage.json. 248kB zip (248kB)

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

Import into your tool

Data-cli or just data is the program to get and post your data with the datahub.
Use data with the datahub.io almost like you use git with the github. Here are installation instructions.

data get https://datahub.io/JohnSnowLabs/cps-elementary-school-progress-report-card-2013-2014
tree JohnSnowLabs/cps-elementary-school-progress-report-card-2013-2014
# Get a list of dataset's resources
curl -L -s https://datahub.io/JohnSnowLabs/cps-elementary-school-progress-report-card-2013-2014/datapackage.json | grep path

# Get resources

curl -L https://datahub.io/JohnSnowLabs/cps-elementary-school-progress-report-card-2013-2014/r/0.csv

curl -L https://datahub.io/JohnSnowLabs/cps-elementary-school-progress-report-card-2013-2014/r/1.zip

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

install.packages("jsonlite", repos="https://cran.rstudio.com/")
library("jsonlite")

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

# get list of all resources:
print(json_data$resources$name)

# print all tabular data(if exists any)
for(i in 1:length(json_data$resources$datahub$type)){
  if(json_data$resources$datahub$type[i]=='derived/csv'){
    path_to_file = json_data$resources$path[i]
    data <- read.csv(url(path_to_file))
    print(data)
  }
}

Note: You might need to run the script with root permissions if you are running on Linux machine

Install the Frictionless Data data package library and the pandas itself:

pip install datapackage
pip install pandas

Now you can use the datapackage in the Pandas:

import datapackage
import pandas as pd

data_url = 'https://datahub.io/JohnSnowLabs/cps-elementary-school-progress-report-card-2013-2014/datapackage.json'

# to load Data Package into storage
package = datapackage.Package(data_url)

# to load only tabular data
resources = package.resources
for resource in resources:
    if resource.tabular:
        data = pd.read_csv(resource.descriptor['path'])
        print (data)

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('https://datahub.io/JohnSnowLabs/cps-elementary-school-progress-report-card-2013-2014/datapackage.json')

# print list of all resources:
print(package.resource_names)

# print processed tabular data (if exists any)
for resource in package.resources:
    if resource.descriptor['datahub']['type'] == 'derived/csv':
        print(resource.read())

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 = 'https://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 list of all resources:
  for (const id in dataset.resources) {
    console.log(dataset.resources[id]._descriptor.name)
  }
  // get all tabular data(if exists any)
  for (const id in dataset.resources) {
    if (dataset.resources[id]._descriptor.format === "csv") {
      const file = dataset.resources[id]
      // Get a raw stream
      const stream = await file.stream()
      // entire file as a buffer (be careful with large files!)
      const buffer = await file.buffer
      // print data
      stream.pipe(process.stdout)
    }
  }
})()
Datapackage.json