BPD Court Overtime Analysis

[vc_row][vc_column width=”1/1″][vc_custom_heading heading_semantic=”h1″ text_size=”h1″]BPD Court Overtime Analysis[/vc_custom_heading][vc_column_text]This repository lists the entire portfolio of interactive visualizations created by the BU Spark! Lab in their analysis of Boston Police court overtime data from 2014-2019. The final report, submitted as testimony to the Boston City Council Ways & Means Hearing on BPD overtime on November 16, is available here. Visualizations include the following categories:

General Analysis
Court Appearance Type
BPD Units and Districts
Individual Officers
Rank and Demographics
Time in Court

For other projects, visit the BU Spark! public Tableau profile.

Click on a chart thumbnail to open an interactive page in Tableau.[/vc_column_text][/vc_column][/vc_row]

[vc_row][vc_column width=”1/1″][vc_custom_heading]General Analysis[/vc_custom_heading][vc_row_inner][vc_column_inner width=”1/3″][vc_single_image media=”69927″ media_width_percent=”100″ media_link=”url:https%3A%2F%2Fpublic.tableau.com%2Fprofile%2Fbuspark1953%23!%2Fvizhome%2FYoYCourtOTPaidvs_Waste%2FYoYOTPaidvs_Waste|||”][/vc_column_inner][vc_column_inner width=”1/3″][vc_single_image media=”69926″ media_width_percent=”100″ media_link=”url:https%3A%2F%2Fpublic.tableau.com%2Fprofile%2Fbuspark1953%23!%2Fvizhome%2FOTHoursWorkedvs_OTHoursPaid%2FOTHoursWorkedvs_OTHoursPaid|||”][/vc_column_inner][vc_column_inner width=”1/3″][vc_single_image media=”69925″ media_width_percent=”100″ media_link=”url:https%3A%2F%2Fpublic.tableau.com%2Fprofile%2Fbuspark1953%23!%2Fvizhome%2FYoYUtilizationChange%2FYoYUtilizationChange|||”][/vc_column_inner][/vc_row_inner][vc_row_inner][vc_column_inner width=”1/3″][vc_single_image media=”69962″ media_width_percent=”100″ media_link=”url:https%3A%2F%2Fpublic.tableau.com%2Fprofile%2Fbuspark1953%23!%2Fvizhome%2FAverageOTasaofRegularSalary%2FAverageOTasaofRegularSalary|||”][/vc_column_inner][vc_column_inner width=”1/3″][vc_single_image media=”69968″ media_width_percent=”100″ media_link=”url:https%3A%2F%2Fpublic.tableau.com%2Fprofile%2Fbuspark1953%23!%2Fvizhome%2FAverageOTasaofTotalEarnings%2FAverageOTasaofTotalEarnings|||”][/vc_column_inner][vc_column_inner width=”1/3″][/vc_column_inner][/vc_row_inner][/vc_column][/vc_row][vc_row][vc_column width=”1/1″][vc_custom_heading]Court Appearance Type[/vc_custom_heading][vc_row_inner][vc_column_inner width=”1/3″][vc_single_image media=”69929″ media_width_percent=”100″ media_link=”url:https%3A%2F%2Fpublic.tableau.com%2Fprofile%2Fbuspark1953%23!%2Fvizhome%2FCourtAppearancebyType2014-2019%2FCourtAppearancebyType2014-2019|||”][/vc_column_inner][vc_column_inner width=”1/3″][vc_single_image media=”69930″ media_width_percent=”100″ media_link=”url:https%3A%2F%2Fpublic.tableau.com%2Fprofile%2Fbuspark1953%23!%2Fvizhome%2FYoYChangeperHearingType%2FYoYChangeperHearingType|||”][/vc_column_inner][vc_column_inner width=”1/3″][vc_single_image media=”69931″ media_width_percent=”100″ media_link=”url:https%3A%2F%2Fpublic.tableau.com%2Fprofile%2Fbuspark1953%23!%2Fvizhome%2FTypeofHearingbyYearStackBarchart%2FTypeofHearingbyYearSTACK|||”][/vc_column_inner][/vc_row_inner][vc_row_inner][vc_column_inner width=”1/3″][vc_single_image media=”69932″ media_width_percent=”100″ media_link=”url:https%3A%2F%2Fpublic.tableau.com%2Fprofile%2Fbuspark1953%23!%2Fvizhome%2FYoYUtilizationChangeforCourtAppearanceTypes%2FYoYUtilizationChangeforCourtAppearanceTypes|||”][/vc_column_inner][vc_column_inner width=”1/3″][vc_single_image media=”69933″ media_width_percent=”100″ media_link=”url:https%3A%2F%2Fpublic.tableau.com%2Fprofile%2Fbuspark1953%23!%2Fvizhome%2FUtilizationperCourtAppearanceType%2FUtilizationperCourtAppearanceType|||”][/vc_column_inner][vc_column_inner width=”1/3″][vc_single_image media=”69934″ media_width_percent=”100″ media_link=”url:https%3A%2F%2Fpublic.tableau.com%2Fprofile%2Fbuspark1953%23!%2Fvizhome%2FCountofDescriptions%2FCountofDescriptions|||”][/vc_column_inner][/vc_row_inner][vc_row_inner][vc_column_inner width=”1/3″][vc_single_image media=”69935″ media_width_percent=”100″ media_link=”url:https%3A%2F%2Fpublic.tableau.com%2Fprofile%2Fbuspark1953%23!%2Fvizhome%2FPretrialasofallOTbyPoliceSquad_16054148437110%2FPretrialAppearancevsOther|||”][/vc_column_inner][vc_column_inner width=”1/3″][vc_single_image media=”69936″ media_width_percent=”100″ media_link=”url:https%3A%2F%2Fpublic.tableau.com%2Fprofile%2Fbuspark1953%23!%2Fvizhome%2FPretrialasofallOTbyPoliceSquad%2FPretrialHoursvsOther|||”][/vc_column_inner][vc_column_inner width=”1/3″][/vc_column_inner][/vc_row_inner][/vc_column][/vc_row][vc_row][vc_column width=”1/1″][vc_custom_heading]BPD Units and Districts[/vc_custom_heading][vc_row_inner][vc_column_inner width=”1/3″][vc_single_image media=”69937″ media_width_percent=”100″ media_link=”url:https%3A%2F%2Fpublic.tableau.com%2Fprofile%2Fbuspark1953%23!%2Fvizhome%2FVolumebyPoliceDistrict2014-2019%2FVolumebyPoliceDistrict2014-2019|||”][/vc_column_inner][vc_column_inner width=”1/3″][vc_single_image media=”69938″ media_width_percent=”100″ media_link=”url:https%3A%2F%2Fpublic.tableau.com%2Fprofile%2Fbuspark1953%23!%2Fvizhome%2FDistrictbyYearStackBarchart%2FDistrictbyYearSTACK|||”][/vc_column_inner][vc_column_inner width=”1/3″][vc_single_image media=”69939″ media_width_percent=”100″ media_link=”url:https%3A%2F%2Fpublic.tableau.com%2Fprofile%2Fbuspark1953%23!%2Fvizhome%2FPolicePresencebyDistrict%2FPolicePresence|||”][/vc_column_inner][/vc_row_inner][vc_row_inner][vc_column_inner width=”1/3″][vc_single_image media=”69940″ media_width_percent=”100″ media_link=”url:https%3A%2F%2Fpublic.tableau.com%2Fprofile%2Fbuspark1953%23!%2Fvizhome%2FRatioofPolicePresencebyDistrict%2FRatio|||”][/vc_column_inner][vc_column_inner width=”1/3″][vc_single_image media=”69941″ media_width_percent=”100″ media_link=”url:https%3A%2F%2Fpublic.tableau.com%2Fprofile%2Fbuspark1953%23!%2Fvizhome%2FUtilizationbyUnit%2FUtilizationbyUnit|||”][/vc_column_inner][vc_column_inner width=”1/3″][vc_single_image media=”69942″ media_width_percent=”100″ media_link=”url:https%3A%2F%2Fpublic.tableau.com%2Fprofile%2Fbuspark1953%23!%2Fvizhome%2FOTHoursbyChargedgroup%2FOTHOURS|||”][/vc_column_inner][/vc_row_inner][vc_row_inner][vc_column_inner width=”1/3″][vc_single_image media=”69943″ media_width_percent=”100″ media_link=”url:https%3A%2F%2Fpublic.tableau.com%2Fprofile%2Fbuspark1953%23!%2Fvizhome%2FOTWastehoursChargedgroup%2FOTWASTE|||”][/vc_column_inner][vc_column_inner width=”1/3″][vc_single_image media=”69964″ media_width_percent=”100″ media_link=”url:https%3A%2F%2Fpublic.tableau.com%2Fprofile%2Fbuspark1953%23!%2Fvizhome%2FAverageOTbyUnit%2FAverageOTbyUnit|||”][/vc_column_inner][vc_column_inner width=”1/3″][vc_single_image media=”69965″ media_width_percent=”100″ media_link=”url:https%3A%2F%2Fpublic.tableau.com%2Fprofile%2Fbuspark1953%23!%2Fvizhome%2FAverageOTbyDistrict%2FAverageOTbyDistrict|||”][/vc_column_inner][/vc_row_inner][/vc_column][/vc_row][vc_row][vc_column width=”1/1″][vc_custom_heading]Individual Officers[/vc_custom_heading][vc_row_inner][vc_column_inner width=”1/3″][vc_single_image media=”69944″ media_width_percent=”100″ media_link=”url:https%3A%2F%2Fpublic.tableau.com%2Fprofile%2Fbuspark1953%23!%2Fvizhome%2FTop10CourtOThours%2FTop10CourtOThours|||”][/vc_column_inner][vc_column_inner width=”1/3″][vc_single_image media=”69945″ media_width_percent=”100″ media_link=”url:https%3A%2F%2Fpublic.tableau.com%2Fprofile%2Fbuspark1953%23!%2Fvizhome%2FCourtOTWastedollarsbyOfficer%2FCourtOTWastebyOfficer|||”][/vc_column_inner][vc_column_inner width=”1/3″][/vc_column_inner][/vc_row_inner][/vc_column][/vc_row][vc_row][vc_column width=”1/1″][vc_custom_heading]Rank and Demographics[/vc_custom_heading][vc_row_inner][vc_column_inner width=”1/3″][vc_single_image media=”69946″ media_width_percent=”100″ media_link=”url:https%3A%2F%2Fpublic.tableau.com%2Fprofile%2Fbuspark1953%23!%2Fvizhome%2FRankbyYearStackBarchart%2FRankbyYearSTACK|||”][/vc_column_inner][vc_column_inner width=”1/3″][vc_single_image media=”69947″ media_width_percent=”100″ media_link=”url:https%3A%2F%2Fpublic.tableau.com%2Fprofile%2Fbuspark1953%23!%2Fvizhome%2FVolumebyRank2014-2019%2FVolumebyRank2014-2019|||”][/vc_column_inner][vc_column_inner width=”1/3″][vc_single_image media=”69963″ media_width_percent=”100″ media_link=”url:https%3A%2F%2Fpublic.tableau.com%2Fprofile%2Fbuspark1953%23!%2Fvizhome%2FOvertimeEarningsbyRank%2FOvertimeEarningsbyRank|||”][/vc_column_inner][/vc_row_inner][vc_row_inner][vc_column_inner width=”1/3″][vc_single_image media=”69966″ media_width_percent=”100″ media_link=”url:https%3A%2F%2Fpublic.tableau.com%2Fprofile%2Fbuspark1953%23!%2Fvizhome%2FOvertimeEarningsbyGender%2FOvertimeEarningsbyGender|||”][/vc_column_inner][vc_column_inner width=”1/3″][vc_single_image media=”69967″ media_width_percent=”100″ media_link=”url:https%3A%2F%2Fpublic.tableau.com%2Fprofile%2Fbuspark1953%23!%2Fvizhome%2FOvertimeEarningsbyEthnicGroup%2FOvertimeEarningsbyEthnicGroup|||”][/vc_column_inner][vc_column_inner width=”1/3″][/vc_column_inner][/vc_row_inner][/vc_column][/vc_row][vc_row][vc_column width=”1/1″][vc_custom_heading]Time Spent in Court[/vc_custom_heading][vc_row_inner][vc_column_inner width=”1/3″][vc_single_image media=”69948″ media_width_percent=”100″ media_link=”url:https%3A%2F%2Fpublic.tableau.com%2Fprofile%2Fbuspark1953%23!%2Fvizhome%2FDaysinCourtHistogram%2FDaysinCourtHistogram|||”][/vc_column_inner][vc_column_inner width=”1/3″][vc_single_image media=”69949″ media_width_percent=”100″ media_link=”url:https%3A%2F%2Fpublic.tableau.com%2Fprofile%2Fbuspark1953%23!%2Fvizhome%2FAmountofCourtHoursperDayperOfficerinCourtthatDay%2FAverageinCourtperOfficer|||”][/vc_column_inner][vc_column_inner width=”1/3″][vc_single_image media=”69950″ media_width_percent=”100″ media_link=”url:https%3A%2F%2Fpublic.tableau.com%2Fprofile%2Fbuspark1953%23!%2Fvizhome%2FAmountofCourtHoursOTperDay%2FAverageCourtOTHoursperday|||”][/vc_column_inner][/vc_row_inner][vc_row_inner][vc_column_inner width=”1/3″][vc_single_image media=”69951″ media_width_percent=”100″ media_link=”url:https%3A%2F%2Fpublic.tableau.com%2Fprofile%2Fbuspark1953%23!%2Fvizhome%2FDaysinCourtbyOfficer%2FDaysinCourtbyOfficer|||”][/vc_column_inner][vc_column_inner width=”1/3″][/vc_column_inner][vc_column_inner width=”1/3″][/vc_column_inner][/vc_row_inner][/vc_column][/vc_row][vc_row][vc_column][vc_column_text]
[/vc_column_text][/vc_column][/vc_row][vc_row][vc_column][vc_column_text]

[/vc_column_text][/vc_column][/vc_row]