For a tutorial video that walks you through the process of using the Open Data Bits library of documentation to build your own open data mashups, we have created a video that can be watched by clicking here.

Data Source Link

https://data.cityofchicago.org/Public-Safety/Crimes-2001-to-present/ijzp-q8t2

Available Access Formats

API OData CSV JSON RSS XLS XLXS XML

Sources and Modeling

Row Color Derived Column
Row Color Column Not Used by Open Data Bits

Logical Model

Calculated Columns & Calculations

Name DAX Expression Type
Date Key =DATE(YEAR([Date]),MONTH([Date]),DAY([Date])) Calculated Column
Date Time Key =TIME(HOUR([Date]),MINUTE([Date]),SECOND([Date])) Calculated Column
Crime Count Crime Count:=COUNTROWS(‘Crimes_2001_to_present’) Calculation
Arrest % Arrest %:=DIVIDE(CALCULATE([Crime Count],FILTER(‘Crimes_2001_to_present’,[Arrest]=”true”)),[Crime Count]) Calculation
Domestic % Domestic %:=DIVIDE(CALCULATE([Crime Count],FILTER(‘Crimes_2001_to_present’,[Domestic]=”true”)),[Crime Count]) Calculation

Examples for Reference

Open Data Bits – City of Chicago Crime Data Now Featured at Open Data Bits

Open Data Bits video – Combine Chicago Crime Data with Census Data for New Insights

Open Data Bits video – Instructional Video to Mashup Chicago and San Francisco Crime and Police Open Data