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://communities.socrata.com/Health/Minneapolis-Restaurant-Inspections/9jv8-qng3

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
Zip Codes 5 Digit =IF(RIGHT([License Address],5)=”00000″,BLANK(),RIGHT([License Address],5)) Calculated Column
MN Inspections MN Inspections:=DISTINCTCOUNT([Inspection Id]) Calculation
Critical Insp Critical Insp:=CALCULATE([MN Inspections],FILTER(‘Minnesota Restaurants’,[critical]=”Yes”)) Calculation
MN Critical % MN Critical %:=DIVIDE([Critical Insp],[MN Inspections]) Calculation

Examples for Reference

Open Data Bits – Mash Up Minneapolis and New York City Restaurant Inspection Data

Open Data Bits – NYC Restaurant Inspections Results Open Data