This dataset contains all crime incidents where a police report was taken. Data goes back to 2019 and is updated each morning by 8:30am. Note that sex crimes and juvenile specific crime types are omitted from this dataset. Please see the data dictionary attached for more details. Terms of Use: The information in this portal is provided strictly as a courtesy to the public. This website provides information as to initial crime reports, and does not reflect subsequent changes in the investigation, nature, or accuracy of the initial report. While all attempts are made to ensure the correctness and suitability of information presented here, neither the City of Memphis nor the Memphis Police Department guarantee the accuracy of the information contained herein. Crime data may be amended or corrected by the Memphis Police Department at any time. This data may not reflect the official crime index totals as reported to the Tennessee Bureau of Investigation.
This dataset has the following 22 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| Crime ID | crime_id | text | Autogenerated system ID number | 2209800190ME 2201004858ME 2301012619ME 2312023015ME 2208012424ME view top 100 |
| Offense Date | offense_date | calendar_date | Date the offense occurred | 2019-04-01T00:00:00.000 2023-04-01T00:00:00.000 2021-01-01T00:00:00.000 2019-01-01T08:00:00.000 2022-01-01T00:00:00.000 view top 100 |
| Reported Date | reported_date | calendar_date | Date the offense was reported | 2018-08-10T15:47:00.000 2024-05-25T12:22:00.000 2022-09-28T22:59:12.000 2022-08-03T19:48:00.000 2024-07-06T09:14:00.000 view top 100 |
| Agency Crime ID | agency_crime_id | text | Internal MPD crime type | VANDALISM/MISDEMEANOR SHOPLIFTING/MISDEMEANOR SIMPLE ASSAULT/DV THEFT FROM MOTOR VEHICLE MVT/PASSENGER VEHICLE view top 100 |
| UCR Incident Code | ucr_incident_code | text | Uniform Crime Report (UCR) incident code. See Appendix A in data dictionary for full list. | 290 13B 23C 23F 240 view top 100 |
| UCR Description | ucr_description | text | UCR crime type based on NIBRS. 52 Group A offenses. See Appendix A in data dictionary for full list and definitions. | DEST/DAM/VAND OF PROPERTY SIMPLE ASSAULT SHOPLIFTING THEFT FROM A MOTOR VEHICLE MOTOR VEHICLE THEFT view top 100 |
| UCR Category | ucr_category | text | UCR index crime categories. The 52 offense types are grouped in 23 categories. See Appendix A in data dictionary for full list. | LARCENY/THEFT ASSAULT DEST/DAM/VAND OF PROPERTY MOTOR VEHICLE THEFT AGGRAVATED ASSAULT view top 100 |
| Offense Group (NIBRS) | offense_group_nibrs | text | NIBRS classified crimes as either crimes against people, property or society | CRIMES AGAINST PROPERTY CRIMES AGAINST PERSONS CRIMES AGAINST SOCIETY PERSON, PROPERTY, OR SOCIETY CRIMES AGAINST PERSON view top 100 |
| Group (NIBRS) | group_nibrs | text | Group A or B per the National Incident Based Reporting System (NIBRS) classification | A B view top 100 |
| 100 Block | _100_block | number | Rounded block number where the incident occurred | 3400 1400 100 2700 3500 view top 100 |
| Street Name | street_name | text | Street where the incident occurred | POPLAR AVE WINCHESTER RD SUMMER AVE LAMAR AVE ELVIS PRESLEY BLVD view top 100 |
| City | city | text | City where the incident occurred | MEMPHIS CORDOVA ARLINGTON BARTLETT , TN view top 100 |
| State | state | text | State where the incident occurred | TN CA MS AB FL view top 100 |
| Zip | zip | text | Zip code where the incident occurred | 38118 38116 38115 38109 38127 view top 100 |
| Full Address (100 Block) | full_address_100_block | text | Full address with rounded street number where the incident occurred | 3900 AUSTIN PEAY HWY MEMPHIS TN 38128 2900 LAMAR AVE MEMPHIS TN 38114 5200 ELVIS PRESLEY BLVD MEMPHIS TN 38116 100 N MAIN ST MEMPHIS TN 38103 4200 SUMMER AVE MEMPHIS TN 38122 view top 100 |
| Lat | lat | number | Rounded latitude for the incident | 35.140000 35.050000 35.100000 35.130000 35.160000 view top 100 |
| Long | long | number | Rounded longitude for the incident | -90.010000 -90.050000 -90.020000 -90.000000 -89.970000 view top 100 |
| Precinct | precinct | text | Police precinct where the incident occurred. See precinct boundaries here | RAINES APPLING FARMS AUSTIN PEAY RIDGEWAY TILLMAN view top 100 |
| Ward | ward | text | Police ward where the incident occurred. See ward boundaries here | 822 925 825 821 924 view top 100 |
| Part One/Two | part_one_two | number | Part 1 crimes include murder, robbery, rape, arson, burglary, larceny and motor vehicle theft | 1 2 view top 100 |
| Location | location | point | Combined latitude and longitude for the purpose of mapping | {"coordinates":[-90.05,35.14],"type":"Point"} {"coordinates":[-90.04,35.14],"type":"Point"} {"coordinates":[-89.85,35.04],"type":"Point"} {"coordinates":[-89.98,35.1],"type":"Point"} {"coordinates":[-89.88,35.07],"type":"Point"} view top 100 |
| 100 Block_Coordinates | _100_block_coordinates | point | {"coordinates":[-90.038906,35.105499],"type":"Point"} {"coordinates":[-90.0526264,35.1456981],"type":"Point"} {"coordinates":[-89.9258359,35.0439658],"type":"Point"} {"coordinates":[-90.076108,35.0396786],"type":"Point"} {"coordinates":[-89.788654041,35.199280989],"type":"Point"} view top 100 |