2020 1st Quarter - MPD Stop and Search Data
Fire and Police CommissionAbout this dataset
Per the requirements in the settlement to Federal Case 17-CV-234-JPS the Milwaukee Fire and Police Commission (FPC) is required to publish particular stop and search encounter data in compliance with Sec. IV(A)(10-13).
MPD stands for Milwaukee Police Department
To download XML and JSON files, click the CSV option below and click the down arrow next to the Download button in the upper right on its page.
Data and resources (35)
This document serves as a guide to the stop and search data.
396 KBUpdated Nov 6, 2020
195 KBUpdated Jul 16, 2020
182 KBUpdated Jul 16, 2020
This data set contains the dispositions for each CAD call associated with each no-action encounter.
2.1 KBUpdated Jul 16, 2020Table and Data API available
The primary data set containing CAD call segments. Each CAD call can have many of these segments. The key that joins these segments is CADCALLKEY. Also it is important to note that some original call types that may start off as a stop, end up as something…
1.2 MBUpdated Jul 16, 2020Table and Data API available
This data set contains the each squad (car) unit that responded to a given call. This table has a many:1 relationship with CADPCARSCALLJOINED
1.1 MBUpdated Jul 16, 2020Table and Data API available
This is the primary data set where field interview data is stored. Each field interview will have one record in this data set. Important note: Any given field interview may have multiple persons involved in it.
95 KBUpdated Jul 16, 2020Table and Data API available
This data set contains the person information for each individual involved in a field interview. For each field interview, there can be many FieldInterview persons. If the same person is involved in two separate field interviews, they will be entered into…
457 KBUpdated Feb 12, 2021Table and Data API available
This is the primary data set where no action encounter data is stored. Each no action encounter will have one record in this data set. Note: Similar to how the field interviews work, any given no action encounter can have multiple persons involved.
6.8 KBUpdated Jul 16, 2020Table and Data API available
This data set contains the person information for each individual involved in a no action encounter. For each no action encounter, there can be many No Action Encounter persons. If the same person is involved in two separate no action encounters, they will be…
31 KBUpdated Jul 16, 2020Table and Data API available
This data set has been included facilitate linking a Peoplesoft number from a given contact summary or field interview to an officer.
64 KBUpdated Jul 16, 2020Table and Data API available
This data set links each individual involved in a contact summary to the actual contact summary. It also contains a few additional fields as shown below. Has a many:1 relationship with TracsPrdHeader
2.3 MBUpdated Jul 16, 2020Table and Data API available
This data set represents additional header information for a given contact summary. It has a 1:1 relationship with the TracsPrdHeader table and includes information about the stop.
3.6 MBUpdated Jul 16, 2020Table and Data API available
This data set represents information related to any vehicle search in regards to a given stop. Has a many:1 relationship with TracsPrdHeader and TracsContactSummaryJoined.
2.1 MBUpdated Jul 16, 2020Table and Data API available
This data set includes the text-based narratives for electronic citations. It has a 1:1 relationship with the TracsPrdHeader table and includes information about the stop.
3.7 MBUpdated Jul 16, 2020Table and Data API available
This data set links to each involved individual indicated in the data sets for each of the four form types (Contact Summary, ELCI, NTC and Warning). Each form entry will usually have one entry in this table. However, one exception to this is when a Contact…
3.2 MBUpdated Jul 16, 2020Table and Data API available
This data set contains the latitude and longitude of each stop. Each stop in TraCS should have a single location.
3.5 MBUpdated Jul 16, 2020Table and Data API available
This data set includes the text-based narratives for non-traffic citations that occurred as a part of a traffic, targeted traffic or subject stop. It has a 1:1 relationship with the TracsPrdHeader table and includes information about the stop
784 KBUpdated Jul 16, 2020Table and Data API available
This data set represents the lookup table for contraband in TraCS
205 BUpdated Jul 16, 2020Table and Data API available
This data set represents the lookup table for summary outcomes in TraCS
149 BUpdated Jul 16, 2020Table and Data API available
This data set represents the lookup table for race in TraCS
152 BUpdated Jul 16, 2020Table and Data API available
This data set represents the lookup table for reasons in the contact summary form.
427 BUpdated Jul 16, 2020Table and Data API available
This data set represents the lookup table for search basis in TraCS
199 BUpdated Jul 16, 2020Table and Data API available
This data set represents the lookup table for the status of all forms in TraCS.
375 BUpdated Jul 16, 2020Table and Data API available
This data set includes the text-based narratives for warnings. It has a 1:1 relationship with the TracsPrdHeader table and includes information about the stop.
2.0 MBUpdated Jul 16, 2020Table and Data API available
The data set is included to primarily indicate the outcome of the stop. Note: This table was not joinable, as it involves a 1:many relationship with each Tracs warning.
867 KBUpdated Jul 16, 2020Table and Data API available
This data set contains each officer that responded to a given call and includes the unit key to link to. This table has a many:1 relationship with CADPCARSCALLUNIT. Some stops may not include a row in this data set (e.g. may not contain a PERSID/Peoplesoft ID…
1.2 MBUpdated Nov 6, 2020Table and Data API available
This data set contains the involved officer(s) for each field interview. Data set has a many:1 relationship with InformFieldInterviewJoined.
199 KBUpdated Nov 6, 2020Table and Data API available
This data set contains the involved officer(s) for each no action encounter.
11 KBUpdated Nov 23, 2020Table and Data API available
This data set represents the primary table in Tracs. Each contact summary, electronic citation (ELCI), non-traffic citation (NTC), or warning will contain a row in this data sets.
3.5 MBUpdated Nov 6, 2020Table and Data API available
This data set represents the use of force incidents for both field interviews and traffic stops.
5.8 KBUpdated Nov 6, 2020Table and Data API available
This data set represents the lookup table for reason for a stop in TraCS.
428 BUpdated Nov 6, 2020Table and Data API available
- CSV
Inform ELCI
This data set contains imported citations that were matched to an MNI number in TraCS. Note: an individual that has two MNIs with the same ethnicity, race, age, and date of birth may not reflect the same person.
1.8 MBUpdated Aug 23, 2021Table and Data API available
This data set represents the lookup table for individual entity type in TraCS.
100 BUpdated Nov 6, 2020Table and Data API available
174 KBUpdated Jan 22, 2021