There is a simple way to run all the queries you are interested in.
The CPDP is a responsive tool. When you click a filter, the information will update to display only the information responsive to the filters you clicked.
When a filter is applied, you will see it on the left side of the page above the map. To keep a filter in place, just 'pin it' - click the pushpin image. To remove it, just click again and 'unpin it’.
After you pick the filters you want, if you scroll to the bottom of the website, you'll see a link that says "Download Table" - this will give you an excel file. (But you don't need to do this to see all the relevant statistics you want!)
An example:
Here we've selected all complaints about "Use of Force" (under categories) that were "Sustained" (under outcomes).
There are 2,030 complaints about use of force that were sustained.
If you click "Complainant" you can see the age, race and gender of the people who made the complaints. 38% of complainants sustained for use of force are black (as compared to 53% black for all use of force complaints.)
If you click "Accused" you can see the age, race and gender of officers who were accused. 35% of accused officers with sustained use of force complaints are black (as compared to 25% black for all use of force complaints, regardless of outcome.)
You can go deeper by clicking the race of either complainants or accused.
Here is a search for all complaints about use of force that were sustained where the complainant was black and the officer was white. There are 151 of these.
You can run this filter all sorts of ways. Here are the 336 complaints sustained for use of force where the complainant was a female and the officer was a male:
Here are the complaints sustained for use of force that resulted in fewer than less than 9 days of suspension: