The Use of Force Report is an interactive data visualization summarizing most use of force Incidents by Portland Police Bureau members. This tool is built to provide custom analyses of use of force data to interested members of the community.
The data used in this report is collected on use of force templates submitted following a use of force incident as mandated by Portland Police Directive 1010.00. The report only contains information on Category 2, 3, and 4 force events as Category 1 - Deadly Force Events are reported in a separate report. The report will be updated 45 days following the end of each quarter.
2. Technical Specifications
The report has been customized to work on personal computers, smart phones and tablets. For the best experience, it is recommended you use a desktop or laptop computer.
3. Interactive Dashboard Features
The Force Audit Report is an interactive data visualization. This interactivity allows users to filter the information based on the questions they are hoping to answer with this dataset. An overview of the pre-built filters is included below.
a. Dashboard Selection
The Force Audit Report contains 5 interactive dashboards (and an accompanying definitions sheet) that provide multiple analyses and presentations on use of force subjects and incidents. To navigate between the different reports, utilize the tab toolbar near the top of the page.
b. Dropdown Filters
Selected filters are included throughout the dashboard to assist in narrowing the scope of the data. Dropdown filters, such as the "Report Date" filter found on every page of the dashboard, are used by clicking on the down arrow and selecting the desired data element. Some dropdowns, such as the "Officer Precincts" filter on the Demographics and Time of Day dashboards allow multiple items to be selected. For these dropdowns, make your selection(s) and then click "Apply" at the bottom of the filter. Click the down arrow again to hide the menu.
Available dropdown filters include:
Summary - Report Date
Demographics - Report Date, Officer Precincts, and Subject Age Ranges
Call Types - Report Date
Time of Day - Report Date, Officer Precincts, Mental Health Crisis?, Transient?, Armed?, and Drugs or Alcohol?
Force Type - Report Date
b. Radio Button Filters
Radio Button Filters are single-option filters that divide the data by the selected item. To filter, simply select the desired item. All radio filters default to (All). Available radio filters include:
Demographics - Subject Mental Health Crisis?, Subject Transient?, Subject Armed?, and Subject Drug or Alcohol?
c. Using the Visualizations as Filters.
Many of the charts and filters within the different dashboards can also be used as filters. Charts that can be used as a filter are indicated in the chart's title.
To use the visualization as a filter, select a header (either above or below) the chart. To make multiple selections within the same graph, hold down the 'Ctrl' button on your keyboard or drag your mouse cursor while clicking the left button.
The data visualization has built in Tooltips to provide additional context, information, and assistance in understanding use of force data. To display this information, hove the mouse cursor on top of an icon or data point.
The ( i ) icon provides definitions or context about the data and/or filters.
The < ! > icon provides general advice and caution for interpreting and understanding the data.
The horizontal lines with circles, resembling an abacus, provides tips for using the interactive dashboard functionality.
The toolbar, located at the bottom of the visualization, contains several buttons that assist in the analysis of the data.
The “Undo” and “Redo” buttons become active when the above filters are applied to the report. They operate just like the Undo and Redo buttons in other programs such as Microsoft Word.
The “Reset” button reverts all filters back to their original setting when you first visited the page. This is a great way to start with a “clean slate” after clicking several filters.
Tableau is the name of the software used to create this report visualization.
The “Download” button allows users to save a static version of the visualization. This option is great for printing out copies of the map to share at meetings or to include in a presentation.
“Get the App” takes you to a download page to acquire a Free Trial of Tableau Desktop. This is not necessary, or recommended, to fully analyze and view the report.
“Tableau Workbook” allows you to download a file that works with the full version of Tableau Desktop, mentioned above. This is not necessary or recommended.
“PDF” allows users to export the report, with all of the filters you set, as a PDF. The options dialogue allows custom scaling and paper size options. When choosing to export as PDF, make sure to keep the layout as portrait and content as “this dashboard.”
The "Crosstab" and "Data" options are unavailable for use on the workbook's main page.
“Image” creates a .png file of the report with all of the selected filters.
4. Dashboard Walkthrough
The Force Audit Report contains 5 interactive dashboards (and an accompanying definitions sheet) that provide multiple analyses and presentations on use of force subjects and incidents. Each tab of the visualization presents the data in a slightly different way, depending on the focus of interest.
I. Executive Summary
The Executive Summary provides a quick overview of the basic facts and statistics on use of force incidents from Portland Police Bureau members. Hover your mouse cursor over the "Definitions and Additional Info" icons provide detail on the definitions, methodology and caution for use of force data.
II. Subject & Application of Force Summary
The report's second dashboard (titled "Demographics" on the tab) provides basic information on the subjects involved in force incidents and the type of force used.
The "Subject of Uses of Force Table" is a distinct count of subjects against whom force was used. For example, if two officers applied force to one subject, that subject is only counted once in the table.
The "Applications of Force Table" is a count of the total applications of force used by all officers for the designated reporting period. For example, if two officers applied one force application to one subject, there would be a total of two force applications described in the table.
III. Dispatch Call Types & Precinct Breakdown
The "Top Initial Dispatch Call Types, by Case, Resulting in Force" bar chart lists the Top 13 Call Types where force was applied during the incident. The call type is defined by Bureau of Emergency Communications dispatchers and call takers when dispatching officers to the incident. The call types are sorted by the unique count of cases where force is applied, with the dark color in the stacked bar chart signaling Category 2 and 3 force events with the lighter color signaling Category 4 force events.
The "FDCRs by precinct and Month" chart is a total count of all Force Data Collection Reports (FDCRs) submitted in each month within the reporting timeframe. The precinct signifies the officer's precinct assignment and does not necessarily indicate the location of the force incident.
IV. Time of Day & Subject Age Group Summaries
The report's fourth dashboard provides an overview of when force incidents are occurring and additional information on the subjects of force incidents.
The "Uses of Force by Day and Time of the Application" chart is a heat map of the weekday and time of day that force was applied, as reported by officers on completed FCDRs. All times are reported on the 24-hour clock, with all "P.M." times occurring after 12:00 hours.
The "Unique Subjects of Force by Age" bar chart is distinct count of subjects against whom force was used, aggregated by age. Age range categories are defined by the National Incident Based Reporting System (NIBRS).
V. Force Type Breakdown
The "Force Type by Demographics" heap map is a count of each unique force type used on each subject for each incident, by the combined sex / race of the subject. Use scroll bar on the bottom of the chart to view additional sex / race groupings.
Example 1: If three separate officers applied a "takedown" on the same white male subject in the same incident, it is only counted once in the table.
Example 2: Three officers are involved in a use of force incident with a Hispanic Female. Two officers apply a "vehicle ram", while the other officer applies a "PIT". In the table, one "vehicle ram" will be counted for Hispanic Female and one "PIT" will also be counted for the Hispanic Female.
The "Force Type by Armed Subject Weapon Type" is a count of each unique force type used on each armed subject, by the type of weapon possessed by the subject. If the subject was in possession of more than one weapon, they are counted once for each weapon.
Example 3: A subject armed with "Needle / Bodily Fluids" and a "Knife / Edged Weapon / Stabbing Instrument" is the subjected to a "takedown" by one officer. The incident is counted in both the "Needle / Bodily Fluids" column and "Knife / Edged Weapon / Stabbing Instrument" column.
VI. Download Open Data
The Portland Police Bureau is a proud member of the Police Data Initiative. Open Data provides an opportunity to improve the relationship between the community and the PPB by increasing transparency, building community trust, and strengthening accountability.
The Download Open Data tab of this report was custom-built to meet the Bureau’s Open Data goals. The dataset includes one row of data per officer use of deadly force. The Open Data contains additional data points associated with the cases. To download a copy of the data for custom analyses and presentation, follow these steps:
1. Click on the Download Open Data tab at the top of the report.
2. Click on the "Download" button on the toolbar in the lower-right corner of the report. See the above section for more information on the toolbar.
3. Click on "Data."
4. A new window will pop up that shows only the first 200 rows of data. Click on the blue link that says "Download all rows as a text file."
5. Once downloaded, the file can be imported to Microsoft Excel or other data analysis programs.
The "Appendix" contains the full definitions for each force type.