A look into death row inmates of Texas, USA.
The data is from https://github.com/zmjones/deathpenalty
Which is put together from Texas Department of Criminal Justice
Year by Race Stacked Bar Chart:
Year by Age Scatter Chart:
Year by Race Area Chart:
Last Words – Word Cloud generated by Tagul. Click to enlarge
By County over 5
Ruby Used for Scatter Chart:
Ruby Used for Stacked Race By Year:
In this post I visualize the player salaries of a few select teams of interest, and the top player salaries across all teams.
The data is from a post i found on /r/datasets This post
NBA Salaries by Player, Team, and Agent 2013-2019
Chicago Bulls
Miami Heat
Charlotte Bobcats
Orlando Magic
Brooklyn Nets
Toronto Raptors
All players over $10 Million USD
Ruby used to parse CSV Data for all players:
Once again, the data is from City of Chicago Data portal
The dataset details 2014 Budget Recommendations, which is the line-item budget document proposed by the Mayor to the City Council for approval. Budgeted expenditures are identified by department, appropriation account, and funding type: Local, Community Development Block Grant Program (CDBG), and other Grants. “Local” funds refer to those line items that are balanced with locally-generated revenue sources, including but not limited to the Corporate Fund, Water Fund, Midway and O’Hare Airport funds, Vehicle Tax Fund, Library Fund and General Obligation Bond funds. Owner: Budget and Management. Frequency: Data is updated annually. For more information about the budget process, visit the Budget Documents page:
Here is a breakdown of the 2014 recommendations compared with revised 2013 appropriations by department.
Over 10 million dollars and excluding Finance General
Here’s Financial General
Breakdown of Financial General
Police Breakdown excluding Corporate Fund
Police Corporate Fund
Department of Transportation
Office of the Mayor
City of Chicago Budget – 2014 Budget Recommendations vs 2013 Revised Appropriations OFFICE OF INSPECTOR GENERAL (APPROPRIATION AUTHORITY) by APPROPRIATION ACCOUNT DESCRIPTION
Ruby example used to parse the data
Data is from https://nycopendata.socrata.com
All 311 Service Requests from 2010 to present. This information is automatically updated daily.
These are all the complaint types and their counts for NYPD.
These are a couple of heatmaps for all noise related calls :
“Noise – Commercial”, “Noise – Street/Sidewalk”, “Noise – House of Worship”, “Noise – Vehicle”, “Noise – Park”
NYC NOISE
Homeless Encampments
Ruby
The data is from https://data.cityofchicago.org/
This dataset is a listing of all current City of Chicago employees, complete with full names, departments, positions, and annual salaries. For hourly employees the annual salary is estimated. Data Owner: Human Resources. Frequency: Data is updated quarterly.
POLICE
FIRE
HEALTH
AVIATION
MAYOR’S OFFICE
How the Data was parsed and formatted.
Data is from City of Chicago Data Portal
This dataset displays location for vehicles that have been towed and impounded by the City of Chicago within the last 90 days. Illegally parked vehicles, abandoned vehicles and vehicles used for illegal activities may be towed by the Chicago Police Department, the Department of Streets and Sanitation, the Department of Revenue, Aviation and the office of the City Clerk.
TIME RANGE 06/25/2013 – 09/23/2013 (90 Days)
VEHICLE COLOR
VEHICLE BRAND
Ruby Code used to parse and manicure data.
JAIL DATA!
Data is from
National Archive of Criminal Justice Data
http://www.icpsr.umich.edu/icpsrweb/NACJD/studies/33722
Use the dataset’s cookbook file to make sense of specific headers
states are coded as number, create a hash for all numbers
Create a hash table for each race with the State as the Key. Then Parse the file, and populate each hash with the inmate count.
Export JSON in GoogleCharts Acceptable format
Here’s a Stacked Column Chart
This morning I discovered an interesting data set
Historical Data About Every Reported United States Drone Strike
from http://dronestre.am/
THIS DATA WAS ACCESSED 8/31/2013
So I decided to make some quick visualizations using Google api.
The Data can be downloaded in JSON format and looks like this:
Parse out the coordinates of each strike using ruby:
Accumulate strike totals by country:
Code to display the date of a strike, and its attributes; deaths, civilians, injuries, and children.
Reported US Drone Strikes 2012 – 2013 stacked chart
Entire Time Range of drone.am dataset accessed 8/31/2013
http://projecteuler.net/problem=11
Largest product in a grid
What is the greatest product of four adjacent numbers in the same direction (up, down, left, right, or diagonally) in the 20
20 grid?
Each crime report contains latitude and longitude coordinates. I used ruby to parse out each coordinate from this source : https://data.cityofchicago.org. Then I appended those points into a heat map.
Update: This dataset has been expanded on, in this post DataViz: Visualizing Chicago Narcotics Crime Data.
Chicago DECEPTIVE PRACTICE – 8/8/2012 to 8/8/2013
Chicago ALL CRIMES – 8/8/2012 to 8/8/2013
Chicago NARCOTICS – 8/8/2012 to 8/8/2013
Chicago HOMICIDE – 8/8/2012 to 8/8/2013
Ruby example to parse all coordinates for Primary Crime Type: DECEPTIVE PRACTICE
Output
