Overview:

Color key for this chart for sheriffs is not being rendered correctly in the actual chart

Details:

Info about the Environment:

• URL: https://staging.policescorecard.org/ca/sheriff/santa-clara

Acceptance Criteria:

Issue will be considered complete when the following criteria are met:

• Chart Colors should match Chart Labels

Documentation:

Screenshots, Attachments, Linked GitHub Issues, etc

Dev & QA Notes:

Any additional notes from developers or QA required to complete this issue.

Overview:

The dots on the map aren't showing up after I ran the Import Everything importer.

Details:

Info about the Environment:

• URL: https://staging.policescorecard.org/mo

Acceptance Criteria:

Issue will be considered complete when the following criteria are met:

• The dots show up

Documentation:

Screenshots, Attachments, Linked GitHub Issues, etc

Dev & QA Notes:

Any additional notes from developers or QA required to complete this issue.

Currently the rankings at the bottom of the page include the following header text:

Rankings are based upon a 0 to 100 percentage scale. Departments with higher scores use less force, more accountability, less police spending, fewer arrests for low level offenses, and more murders solved.

This should be changed to:
Rankings are based upon a 0 to 100 percentage scale. Departments with higher scores use less force, make fewer arrests for low level offenses, solve murder cases more often, hold officers more accountable and spend less on policing overall.

Overview:

Replace all labels that read City Did Not Provide Data with No Data Found. [ Add Data ]

Details:

Info about the Environment:

• URL: https://staging.policescorecard.org/tx

Acceptance Criteria:

Issue will be considered complete when the following criteria are met:

• City Did Not Provide Data text should be changed to No Data Found.
• New button added after No Data Found that reads Add Data
• New Button should link to https://forms.gle/R7ADBELo1cQ4sbfz7

Documentation:

Screenshots, Attachments, Linked GitHub Issues, etc

Dev & QA Notes:

Any additional notes from developers or QA required to complete this issue.

The indicator referenced as 16% here is 1 - calc_percentile_police_spending_ratio when it should instead be using 1 - calc_percentile_police_spending which in this case would yield 97% instead of 16%.
Source: https://staging.policescorecard.org/ny/police-department/new-york

Overview:

This 97% is the wrong indicator being referenced in the chart. It should be using calc_percentile_police_spending not calc_percentile_police_spending_ratio

Details:

Info about the Environment:

• URL: https://staging.policescorecard.org/ca/sheriff/santa-clara

Acceptance Criteria:

Issue will be considered complete when the following criteria are met:

• Report Card uses correct percentile_police_spending data

Documentation:

Screenshots, Attachments, Linked GitHub Issues, etc

Dev & QA Notes:

Any additional notes from developers or QA required to complete this issue.

Overview:

The new link, "Contribute Data", should link to the following form https://forms.gle/WPC2Z6A92tBqxGWZ8.

Details:

Info about the Environment:

• URL: https://staging.policescorecard.org/ca

Acceptance Criteria:

Issue will be considered complete when the following criteria are met:

• A new nav header link, "Contribute Data", links to https://forms.gle/WPC2Z6A92tBqxGWZ8.

On the homepage:

• The "7,645" in "7,645" killings by police should be in bold, consistent with the formatting of the other two sections.
• The "2.6x" and "1.3x" should be in bold
• Change the "2016-2018" to "2016-19" (in the section "Only 1 in every 7 complaints were ruled in favor of civilians from 2016-18.")
• Change "Police in America made 14.3x as many arrests for low level offenses as for violent crimes in 2013-2018." to "Police in America made 12x as many arrests for low level offenses as for violent crimes from 2013-2019."

Overview:

For some reason South Dakota is showing no data for county departments despite the fact we actually do have data for these departments

Details:

Info about the Environment:

• URL: https://staging.policescorecard.org/us/sheriff

Acceptance Criteria:

Issue will be considered complete when the following criteria are met:

• Sheriff Departments should show up for South Dakota on USA Map

Documentation:

Screenshots, Attachments, Linked GitHub Issues, etc

Dev & QA Notes:

Any additional notes from developers or QA required to complete this issue.

This is likely an issue with FIPS codes. Might look at what we are using the the Google Sheets document for these states and make sure that it's the correct FIPS code that that state. If it is correct there, it might be how it got ported over into the database.

Overview:

Change this text to [agency_name] [agency type] killed 1 person from 2013-19 So it would be Laclede police department killed... or Laclede sheriff's department killed...

Details:

Info about the Environment:

• URL: https://staging.policescorecard.org/mo/sheriff/laclede

Acceptance Criteria:

Issue will be considered complete when the following criteria are met:

• Text should read [agency_name] [agency type] killed 1 person from 2013-19
• [agency_name] should be the name of the location, e.g. Los Angelos
• [agency type] should be either Sheriff Department or Police Department

Documentation:

Screenshots, Attachments, Linked GitHub Issues, etc

Dev & QA Notes:

Any additional notes from developers or QA required to complete this issue.

When this bar chart is showing 100% of a particular armed status it incorrectly adds another 100% category to the chart. It should be just 100% in red for the police killings by armed status chart here: https://staging.policescorecard.org/mo/police-department/joplin

Overview:

This still says United States even when it’s on a state page. It should have the state name here instead. And for the homepage it should just say “Police Department Scores” with no location named (i.e. remove the “United States” text).

Details:

Info about the Environment:

• URL: https://staging.policescorecard.org/ca

Acceptance Criteria:

Issue will be considered complete when the following criteria are met:

• Home Page Department Scores should read UNITED STATES
• Every other page should use the name of the state, e.g. CALIFORNIA
• Police Pages should read POLICE DEPARTMENT SCORES
• Sheriff Pages should read SHERIFF DEPARTMENT SCORES

Documentation:

Screenshots, Attachments, Linked GitHub Issues, etc

Dev & QA Notes:

Any additional notes from developers or QA required to complete this issue.

Overview:

The Add New Data button should go to this form: https://forms.gle/WPC2Z6A92tBqxGWZ8

Details:

Info about the Environment:

• URL: https://staging.policescorecard.org/ca

Acceptance Criteria:

Issue will be considered complete when the following criteria are met:

• Target for Add New Data link should be https://forms.gle/WPC2Z6A92tBqxGWZ8

Documentation:

Screenshots, Attachments, Linked GitHub Issues, etc

Dev & QA Notes:

Any additional notes from developers or QA required to complete this issue.

Overview:

Add explainer text to the scorecard at a glance section and make it 13pt font.

Acceptance Criteria:

Issue will be considered complete when the following criteria are met:

• Add the following text above the scorecard.
• New text should be 13px
• For [cities or counties] use cities for Police Departments and counties for Sheriff Departments
• For [comparison_group] use the comparison_group from CSV column

Scores range from 0-100% comparing [cities or counties] with [comparison_group]. [Cities or counties] with higher scores spend less on policing, use less force, are more likely to hold officers accountable and make fewer arrests for low-level offenses.

Documentation:

Screenshots, Attachments, Linked GitHub Issues, etc

Dev & QA Notes:

Any additional notes from developers or QA required to complete this issue.

Overview:

The rankings reverse when you go from nationwide to state pages. It should be the lowest scores at the top for both types of pages. Also, the departments with incomplete scores should show up with the asterisk on the state pages

Details:

Info about the Environment:

• URL: https://staging.policescorecard.org & https://staging.policescorecard.org/ca

Acceptance Criteria:

Issue will be considered complete when the following criteria are met:

• Order should be Lowest to Highest Score for COMPLETE data

Steps to Duplicate:

A step by step guide written for a person who might be looking at this for the first time:

1. Check the Department Scores on the Home Page
2. Check the Department Scores on a Report Page ( specific to a location )
3. You will see they are not rendered the same way

Documentation:

Screenshots, Attachments, Linked GitHub Issues, etc

Dev & QA Notes:

Any additional notes from developers or QA required to complete this issue.

The 7% for the "unarmed" category displaying in red in the chart should be rounded up to 8% since it's 3/40 = 7.5%. The text above the chart displays the 8% correctly but the chart below it needs to be fixed to be consistent with the top. https://staging.policescorecard.org/mo/police-department/st-louis-metro

Overview:

The percents in the text above this chart are slightly off from the chart itself, maybe this is a rounding error?

Details:

Info about the Environment:

• URL: https://staging.policescorecard.org/ca

Acceptance Criteria:

Issue will be considered complete when the following criteria are met:

• Percentage Unarmed should match what is in Google Sheets

Documentation:

Screenshots, Attachments, Linked GitHub Issues, etc

Dev & QA Notes:

Any additional notes from developers or QA required to complete this issue.

The jail incarceration rate 'progress bar' chart should use (1- calc_percentile_jail_incarceration_per_1k_population). Currently, it is not displaying for some reason. For example, for LA sheriff calc_percentile_jail_incarceration_per_1k_population should be (1 - 62%) = 38%.

Link: https://staging.policescorecard.org/ca/sheriff/los-angeles

Screenshot:

Overview:

The "No Data Found [Add Data button]" should be added to the total complaints sustained indicator and the criminal complaints sustained indicator when there's no data for those indicators (when calc_complaints_sustained = no data or when calc_percent_criminal_complaints_sustained = no data) just like it displays for the other complaints indicators.

Details:

Info about the Environment:

• URL:
• Environment:
• Browser:
• Device:
• Operating System:

Acceptance Criteria:

Issue will be considered complete when the following criteria are met:

• TEXT

Steps to Duplicate:

A step by step guide written for a person who might be looking at this for the first time:

1. TEXT

Documentation:

Screenshots, Attachments, Linked GitHub Issues, etc

Dev & QA Notes:

Any additional notes from developers or QA required to complete this issue.

Overview:

It's still not showing the percent of use of force complaints sustained even though there’s a 0% for calc_use_of_force_complaints_sustained. It should only hide this when it’s blank, not when it’s a zero.

Details:

Info about the Environment:

• URL: https://staging.policescorecard.org/mo/police-department/st-louis

Acceptance Criteria:

Issue will be considered complete when the following criteria are met:

• Use of Force Complaints should show Complaints Sustained if exists and is a number ( including zero )
• Use of Force Complaints should hide Complaints Sustained if value is null or undefined

Documentation:

Screenshots, Attachments, Linked GitHub Issues, etc

Dev & QA Notes:

Any additional notes from developers or QA required to complete this issue.

Overview:

If both Black and Latinx numbers are 0x as likely then it should just say [x] people killed by [department name] from 2013-19

Details:

Info about the Environment:

• URL: https://staging.policescorecard.org/ny/police-department/greece-town

Acceptance Criteria:

Issue will be considered complete when the following criteria are met:

• If black and latinx are both 0x as likely in the description, switch the text to the following:
• X here is the number shown next to KILLINGS BY POLICE
• [department name] here is the department name, like Los Angeles Police Department

X people killed by [department name] from 2013-19

Documentation:

Screenshots, Attachments, Linked GitHub Issues, etc

Dev & QA Notes:

Any additional notes from developers or QA required to complete this issue.

Currently, on each department's Key Findings section of their page it says the arrests are from 2013-18. This should be changed to 2013-19 for all departments. We should also add the word "reported" to the descriptions so in the end it changes from:

58% of all arrests were for low-level, non-violent offenses from 2013-18.

to instead be:

58% of all reported arrests were for low-level, non-violent offenses from 2013-19.

Source page: https://staging.policescorecard.org/wi/police-department/milwaukee

Overview:

Where it currently says at the bottom of the rankings section that “ * An asterisk indicates this location did not publish enough data to evaluate. Click below to add data to the Scorecard.” it does not currently identify departments with an asterisk.

Info about the Environment:

• URL: https://dev.policescorecard.org/or

Acceptance Criteria:

Issue will be considered complete when the following criteria are met:

• Let’s make it so the score still displays but there’s an asterisk next to the score in the rankings in the table like “37%*” and it would still show the color for the score. And let’s set it so it displays the asterisk for all departments where the column completeness<50%.

Documentation:

Screenshots, Attachments, Linked GitHub Issues, etc

Dev & QA Notes:

Any additional notes from developers or QA required to complete this issue.

For the Deaths in Jail section, the color key is representing "Investigating" as the gray color for the data of "Other" and vice versa. The data referenced by these two categories should be switched. For example, this one should be 100% "Other" not 100% "Investigating" as per the data for this particular jurisdiction.
Example: https://staging.policescorecard.org/mo/sheriff/st-charles-county

Overview:

The box indicating which department is selected here is slightly off vs the text

Details:

Info about the Environment:

• URL: https://staging.policescorecard.org/ca

Acceptance Criteria:

Issue will be considered complete when the following criteria are met:

• Modal tabs should be centered visually within modal

Steps to Duplicate:

A step by step guide written for a person who might be looking at this for the first time:

1. Visit any report page ( other than Home Page )
2. Click Location Select Menu
3. View Modal Menu and see that Tabs at Top are not aligned with content below

Documentation:

Screenshots, Attachments, Linked GitHub Issues, etc

Dev & QA Notes:

Any additional notes from developers or QA required to complete this issue.

Overview:

The Latinx category in the chart isn’t displaying the name for some reason on the homepage

Details:

Info about the Environment:

• URL: https://staging.policescorecard.org/
• Device: Mobile

Acceptance Criteria:

Issue will be considered complete when the following criteria are met:

• Killings by Police Chart should show BLACK, LATINX & WHITE

Steps to Duplicate:

A step by step guide written for a person who might be looking at this for the first time:

1. This is only an issue on mobile, the charts to not show on desktop
2. Visit the Home Page and scroll down to the KILLINGS BY POLICE chart
3. Check that all three labels for BLACK, LATINX & WHITE are showing

Documentation:

Screenshots, Attachments, Linked GitHub Issues, etc

Dev & QA Notes:

Any additional notes from developers or QA required to complete this issue.

This chart is controlled by Highcharts, and in all honesty, it seems super finicky on showing these labels all the time. This has been a recurring issue, and each time it is fixed, another use case pops up where it breaks. We may end up having to just create this chart using HTML elements rather than relying on the chart software.

Currently, this section displays "2010-2017" as the time range. Since we now have 2018 data included in the calculations it should say "2010-2018" as the range instead. It looks like the actual calculations are correct, but the time frame just needs to be updated to reference 2018 instead of 2017.
Example: https://staging.policescorecard.org/ky/police-department/louisville-metro

Overview:

Let's change the current limit of displaying 500 max departments in this grid at a time. Texas has like 650 depts and they’re getting cut off from the grid. We should be able to change this to 1,000.

Details:

Info about the Environment:

• URL: https://staging.policescorecard.org/tx

Acceptance Criteria:

Issue will be considered complete when the following criteria are met:

• Department Scores should be able to show up to 1,000 departments

Documentation:

Screenshots, Attachments, Linked GitHub Issues, etc

Dev & QA Notes:

Any additional notes from developers or QA required to complete this issue.

Overview:

The highlighted text on the right here should say from 2013-18 at the end.

Details:

Info about the Environment:

• URL: https://staging.policescorecard.org/tx

Acceptance Criteria:

Issue will be considered complete when the following criteria are met:

• Key Findings Arrests Made sentence should end with from 2013-18.

Documentation:

Screenshots, Attachments, Linked GitHub Issues, etc

Dev & QA Notes:

Any additional notes from developers or QA required to complete this issue.

Overview:

Let's add a state selector to the top of the city selector popup so people can find everything from this interface.

Acceptance Criteria:

Issue will be considered complete when the following criteria are met:

• Update Modal for Department Selector to Contain State Selector
• When user selects a State, the list of departments should update for that state
• When the modal window opens for the first time, the current states data should always be selected
• When the modal window opens for the first time, the current location should be selected and scrolled into position

Documentation:

Screenshots, Attachments, Linked GitHub Issues, etc

These are the two separate bits that we would like to combine together inside this modal. We can leave the state selection at the top, but we're just duplicating it inside the new modal.

Dev & QA Notes:

Any additional notes from developers or QA required to complete this issue.

Currently there is no other state data available on the page, as it is only loaded with the current states info. We will need to add some AJAX based method of loading these other departments when the user switches states.