Skip to Main Content View Text-Only

The City of Portland, Oregon

Police Bureau

Sworn to protect. Dedicated to serve.

Phone: 503-823-0000

Fax: 503-823-0342

Non-Emergency: 503-823-3333

1111 S.W. 2nd Avenue, Portland, OR 97204

Dashboard Walkthrough

The Reported Bias/Hate Crime Statistics dashboard is an interactive data visualization of incidents reported to the Portland Police Bureau (PPB) which meet the FBI's National Incident-Based Reporting System (NIBRS) guidelines for bias motivation. All cases flagged for potential bias motivation are reviewed by a PPB detective specifically assigned to investigate bias crimes.

The dashboard is updated following a review by the bias crime detective at the conclusion of each quarter in April, July, October, and January.


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.

No additional software is required to use this report. The report runs completely within the internet browser using JavaScript. Most modern browsers automatically activate JavaScript; however, it can be turned off based on the security settings of the computer.  For more information on activating JavaScript, refer to the browser’s help section or click here for help on Windows computers or click here for help on Apple computers.


3. Visualization Walkthrough

The Reported Bias/Hate Crime Statistics dashboard is an interactive data visualization. This interactivity allows users to filter the information based on the questions they are hoping to answer using this dataset.

Many of the visualizations and figures in the dashboard can be used as filters by clicking within the charts and graphs. Multiple selections within the same element can be made by holding down the 'Ctrl' button and selecting all relevant values or click and dragging your mouse cursor within the visualization. Multiple filters can be activated simultaneously by clicking among the different charts and graphs in the dashboard.

Several icons are placed throughout the dashboard to provide additional context and direction. Hover over the icon (or click if using a mobile device) for a pop-up to appear with additional text regarding the dashboard.

An overview of the pre-built filters and an explanation of the visualizations are included below.


I. Reported Bias/Hate Crime Statistics

The homepage (and first tab) of the dashboard consists of two sections: (a) the count of all reported bias incidents by review outcome and (b) the bias / hate crime review process.

a. Incident Count by Quarter

The stacked bar graph visualizes the current case status for all reported bias/hate incidents that have been reviewed by the assigned detective. Reported incidents fall into three different categories, depending on whether they meet the FBI's criteria for bias crime. Cases with outstanding information that could assist in the bias classification or are still under investigation are marked as "unknown".

b. Bias/Hate Crime Investigations Overview

The Portland Police Bureau has outlined procedures for investigating all potential bias incidents reported to the Bureau. The visual representation included at the bottom of the homepage outlines the process from reporting, through the investigation, and case outcome and notification.


II. Confirmed Bias Crime Statistics

The second tab of the data dashboard contains detailed information on all investigated bias crime incidents where it was confirmed that identified bias was a motivation for the crime.

a. Date Filter

The Date Filter is a comprehensive list of all time periods from which confirmed bias/hate crime data is available. Click the dropdown and select, or unselect, the boxes to include, or not, in the subsequent visualizations. Click the "Apply" button at the bottom of the filter to save your selections. All visuals will update accordingly, with the text box next to Date Filter displaying the selected date range.


b. Bias Crimes by Quarter

The first bar chart on the tab depicts the number of reported bias incidents that meet the FBI's National Incident-Based Reporting System (NIBRS) standards for bias motivation. This is a count of incidents only, which may include multiple offenses or victims (which are depicted in subsequent visualizations). 

Clicking on any of the bars or headers will filter the rest of the dashboard for that quarter, similar to the Date Filter above it. Several time periods can be chosen by clicking and dragging over multiple items or by holding the Ctrl button while clicking. The graph will also update when other filters are applied throughout the dashboard.

 

 


c. Offense Type

The horizontal bar chart depicts what offenses are associated with confirmed bias/hate crime incidents. Hovering over the bar with your mouse cursor will display additional information, including the percentage of confirmed bias cases with that particular offense type. For more information on how offenses are defined and classified, view PPB's Introduction to NIBRS Offenses guide. Note that incidents may have multiple offenses (e.g. crimes against persons are counted on a per-victim basis, while crimes against property are counted by incident). Hover over the blue information icon for a color key of the offense categories.

Click on one (or more) offense types to filter the rest of the visualization by reported offense. The graph will also update when other filters are applied throughout the dashboard.

 


d. Location Type

The above bar chart depicts the number of reported bias crime incidents by location type.

Click on one (or more) location categories or specific location types to filter the rest of the visualization by location type. The graph will also update when other filters are applied throughout the dashboard.


e. Bias Category and Type

The bar chart lists the broad bias crime categories and specific subtypes that were reported for each confirmed bias incident. For a full list of categories and types defined by NIBRS, hover or click on the info icon or visit the Introduction to Bias / Hate Crime StatisticsThere is also a dropdown menu that can be used to count the categories by Incident (bias crimes that occur at the same place and time regardless of offense or victim count), Offense (multiple offenses can occur per incident) and Victim.  

Click on one (or more) bias categories or specific bias types to filter the rest of the visualization. The graph will also update when other filters are applied throughout the dashboard.


f. Victim Type and Average Number of Offenders per Case

The Victim Type bar chart represents who or what the victim was for each reported bias crime. Individuals include person-to-person contacts and residences. Religious Organizations are comprised of churches, synagogues, temples, mosques or other places of worship. Businesses are buildings used for commercial purposes. Victims are counted by incident for this visual, so cases with an 'Individual' victim type may have multiple persons associated.

Click on one (or more) victim type to filter the rest of the visualization. The graph will also update when other filters are applied throughout the dashboard.

The Average Number of Offenders Per Case calculation shows how many known offenders are associated with confirmed bias cases. Offender counts are only included when an offender or offenders have been identified. The figure will update when filters are applied throughout the dashboard.


g. Victim and Offender Demographics

Demographics for both victims and offenders are listed in this section of the dashboard. Each is divided into graphs by race, gender, and age ranges. Only races, genders, or ages in which individuals have been victims or offenders of reported bias crimes are listed, therefore not all categories are represented. Demographics are also only recorded for individuals, not religious organizations or businesses, so victim demographics will be blank when those filters are applied.

Click on one (or more) of the demographic categories to filter the rest of the visualization. The graph will also update when other filters are applied throughout the dashboard.


h. Victim/Offender Relationship

This chart depicts how and if the offender was known by the victim. The relationship is only recorded for victims that are individuals, not religious organizations or businesses, so victim/offender relationship will be blank when those filters are applied. The chart is divided into two broad categories (known and unknown) and then further sub-divided into specific categories. For a definition of the specific categories hover over the bars for a pop-up which also lists the actual counts for each category.

Click on one (or more) of the relationship categories to filter the rest of the visualization. The graph will also update when other filters are applied throughout the dashboard.

 


h. Offender Status

The Offender Status bar chart shows whether an offender has been identified and whether they have been arrested. The lighter color denotes no arrest has been made and the darker color indicates the number of suspects that have been arrested. For additional information and definitions related to each category, hover your mouse cursor over the bars.

Click on one (or more) of the relationship categories to filter the rest of the visualization. The graph will also update when other filters are applied throughout the dashboard.


i. Toolbar  

The toolbar, located at the bottom of the visualization, contains several buttons that assist in the analysis of the data.

Tableau is the name of the software used to create this report visualization.

The Left and Right buttons become active when the above filters are applied to the report and act as "Undo" and "Redo", respectively. They operate just like the Undo and Redo buttons in other programs such as Microsoft Word.

The “Reset” button, depicted as a left arrow pointing at a straight line, 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.

The "Share Button" is three circles connected by three straight lines. This button creates a link you can share via email or other social media platforms. If you use the filters to adjust the view, you can also share a direct link with the filters you selected.

The downward arrow connected to a rectangle allows the user to save different versions of the visualization.

  • "Image" creates a .png of the report with all of the selected filters.
  • The "Crosstab" and "Data" options create a downloadable version of the data powering the report. This option is not recommended for use on the dashboard's main page. For more information on how to download Open Data, refer to the next section.
  • “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.”
  • “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.
  • “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.

4. Download 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.