This dataset represents the Dallas Police Public Data - RMS Incidents beginning June 1, 2014 to current-date. The Dallas Police Department strives to collect and disseminate police report information in a timely, accurate manner. This information reflects crimes as reported to the Dallas Police Department as of the current date. Crime classifications are based upon preliminary information supplied to the Dallas Police Department by the reporting parties and the preliminary classifications may be changed at a later date based upon additional investigation. Therefore, the Dallas Police Department does not guarantee (either expressed or implied) the accuracy, completeness, timeliness, or correct sequencing of the information contained herein and the information should not be used for comparison purposes over time. The Dallas Police Department will not be responsible for any error or omission, or for the use of, or the results obtained from the use of this information. This online site is an attempt to make it easier for citizens to access offense reports. In disseminating this crime information, we must also comply with current laws that regulate the release of potentially sensitive and confidential information. To ensure that privacy concerns are protected and legal standards are met, report data is "filtered" prior to being made available to the public. Among the exclusions are: 1.) Sexually oriented offenses 2.) Offenses where juveniles or children (individuals under 17 years of age) are the victim or suspect 3.) Listing of property items that are considered evidence 4.) Social Service Referral offenses 5.) Identifying vehicle information in certain offenses
This dataset has the following 77 columns:
| Column Name | API Column Name | Data Type | Description |
|---|---|---|---|
| Incident Number w/year | incidentnum | text | An RMS generated incident number (report number) with the year |
| Year of Incident | servyr | number | Year associated with the incident number |
| Service Number ID | servnumid | text | Incident number plus year code plus offense number (Ex: -02 means there is two offense with this one incident) Internal use |
| Watch | watch | text | Police watch 1st 2nd or 3rd (1st watch = Late Night, 2nd watch = Days and 3rd watch = Evenings) |
| Call (911) Problem | signal | text | Police call signal generated by Communications ( Type of 911 call dispacthed) |
| Type of Incident | offincident | text | Type of Incident |
| Type Location | premise | text | Location type where incident took place For example, Apartment Parking, Residence |
| Type of Property | objattack | text | The target item… Parkinglot, Motor Vehicle |
| Incident Address | incident_address | text | Address where incident occurred |
| Apartment Number | apt | text | Apartment number |
| Reporting Area | ra | number | Geographic area comprised of reporting areas where incident occurred |
| Beat | beat | number | Geographic area comprised of beats where incident occurred |
| Division | division | text | Geographic area comprised of census blocks where incident occurred (smallest police geography) |
| Sector | sector | number | Geographic area comprised of Sectors where incident occurred |
| Council District | district | text | Geographic area comprised of city council districts where incident occurred |
| Target Area Action Grids | taag | text | Geographic areas targeted for higher than average crime |
| Community | community | text | Community Prosecution Areas as designated by the City Community Prosecutors |
| Year1 of Occurrence | year1 | number | Year of the indent based on the Date of Occurrence (Date1). Internal use |
| Month1 of Occurence | month1 | text | Month (starting) of the indent based on the Date of Occurrence (Date1). Internal use |
| Day1 of the Week | day1 | text | Day of the indent based on the Date of Occurrence (Date1). Internal use |
| Time1 of Occurrence | time1 | text | The first (starting) time of the time occurrence of the incident (Ex: incident occurred between 8:00am and 5:00pm) |
| Day1 of the Year | date1dayofyear | number | The calender number of the year 1‐365 based on Date1. Internal use |
| Year2 of Occurrence | year2 | number | Year of the indent based on the Date of Occurrence (Date2) |
| Month2 of Occurence | month2 | text | Month (end) of the indent based on the Date of Occurrence (Date2) |
| Day2 of the Week | day2 | text | Day of the indent based on the Date of Occurrence (Date1) |
| Time2 of Occurrence | time2 | text | The second(end) time of the time occurrence of the incident (Ex: incident occurred between 8:00am and 5:00pm) |
| Day2 of the Year | date2dayofyear | number | The calender number of the year 1‐365 based on Date2. Internal use |
| Offense Entered Year | eyear | number | The year the offense was entered into the system . Internal use |
| Offense Entered Month | emonth | text | The month the offense was entered into the system. Internal use |
| Offense Entered Day of the Week | eday | text | The day the offense was entered into the system. Internal use |
| Offense Entered Time | etime | text | The time the offense was entered into the system. Internal use |
| Offense Entered Date/Time | edatedayofyear | text | The calender number of the year the offense was entered. Internal use |
| CFS Number | cfs_number | text | CFS Number |
| Special Report (Pre-RMS) | splrpt | text | No longer applies.. PreRMS |
| Person Involvement Type | involvement | text | Person can be; victim, reporting person, witness |
| Victim Type | victimtype | text | Victim Type |
| Victim Race | comprace | text | Victim Race |
| Victim Ethnicity | compethnicity | text | Victim Ethnicity |
| Victim Gender | compsex | text | Victim Gender |
| Responding Officer #1 Badge No | ro1badge | text | Responding Officer #1 Badge No |
| Responding Officer #1 Name | ro1name | text | Responding Officer #1 Name |
| Responding Officer #2 Badge No | ro2badge | text | Responding officer #2 Badge number |
| Responding Officer #2 Name | ro2name | text | Responding officer #2 Name |
| Reporting Officer Badge No | reptoff | text | Reporting Officer Badge No |
| Assisting Officer Badge No | assoffbadge | text | Assisting Officer Badge No |
| Reviewing Officer Badge No | reviewbadgenum | text | Reviewing Officer Badge No |
| Element Number Assigned | elenum | text | Reporting officers assigned element number |
| Investigating Unit 1 | followup1 | text | 1st Assigned investigative unit |
| Investigating Unit 2 | followup2 | text | Investigating Unit 2 |
| Offense Status | status | text | Status of the offense |
| UCR Disposition | ucr_disp | text | UCR Disposition of the incident |
| Modus Operandi (MO) | mo | text | Short description of the offense |
| Family Offense | family | checkbox | Yes or no if the offense is family violence |
| Hate Crime | hate | text | Yes or no if offense is a hate crime |
| Hate Crime Description | hatecrimedescriptn | text | Hate Crime Description |
| Weapon Used | weaponused | text | Weapon Used |
| Gang Related Offense | gang | text | Yes or no if offense is gang realated |
| Drug Related Istevencident | drug | text | Yes or no if incident is drug related |
| RMS Code | offensecode | text | UCR Offense code |
| Criminal Justice Information Service Code | cjis | number | Criminal Justice Information Services Code (CJIS) |
| Penal Code | penalcode | text | State Penal Violation Code number |
| UCR Offense Name | ucr_offense | text | UCR Offense Name |
| UCR Offense Description | ucr_offdesc | text | UCR Offense description. Internal use |
| UCR Code | ucrcode | number | UCR Code |
| Offense Type | type | text | Offense category Part1 or Part2 or Not coded. Internal use |
| NIBRS Crime | nibrs_crime | text | NIBRS Crime |
| NIBRS Crime Category | nibrs_crime_category | text | NIBRS Crime Category |
| NIBRS Crime Against | nibrs_crimeagainst | text | NIBRS Crime Against |
| NIBRS Code | nibrs_code | text | NIBRS Code |
| NIBRS Group | nibrs_group | text | NIBRS Group |
| NIBRS Type | nibrs_type | text | NIBRS Type |
| X Coordinate | x_coordinate | number | X Coordinate |
| Y Cordinate | y_cordinate | number | Y Cordinate |
| Zip Code | zip_code | number | Zipcode in which incident occured |
| City | city | text | City in which incident occurred |
| State | state | text | State in which incident occurred |
| Location1 | geocoded_column | location | Location1 |