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://nycopendata.socrata.com/Social-Services/311-Service-Requests-from-2010-to-Present/erm2-nwe9

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

Hierarchies

  • agency > agency_name

Calculated Columns & Calculations

Name DAX Expression Type
Created Date Key =DATE(YEAR([created_date]),MONTH([created_date]),DAY([created_date])) Calculated Column
Created Date Time Key =TIME(HOUR([Created Date]),MINUTE([Created Date]),SECOND([Created Date])) Calculated Column
Closed Date Key =DATE(YEAR([closed_date]),MONTH([closed_date]),DAY([closed_date])) Calculated Column
Closed Date Time Key =TIME(HOUR([Closed Date]),MINUTE([Closed Date]),SECOND([Closed Date])) Calculated Column
Due Date Key =DATE(YEAR([due_date]),MONTH([due_date]),DAY([due_date])) Calculated Column
Due Date Time Key =TIME(HOUR([Due Date]),MINUTE([Due Date]),SECOND([Due Date])) Calculated Column
Resolution Action Updated Date Key =DATE(YEAR([resolution_action_updated_date]),MONTH([resolution_action_updated_date]),
DAY([resolution_action_updated_date]))		 Calculated Column
Resolution Action Updated Time Key =TIME(HOUR([Resolution Action Updated Date]),MINUTE([Resolution Action Updated Date]),SECOND([Resolution Action Updated Date])) Calculated Column
NYC 311 Count NYC 311 Count:=COUNTROWS([Table Name]) Calculation

Examples for Reference

Open Data Bits – New York City 311 Service Requests Open Data

Open Data Bits – NYC Restaurant Inspections Results Open Data