Crime Incidents

Description

Crime incidents from the Philadelphia Police Department. Part I crimes include violent offenses such as aggravated assault, rape, arson, among others. Part II crimes include simple assault, prostitution, gambling, fraud, and other non-violent offenses. **Please note that this is a very large dataset. To see all incidents, download all datasets for all years.** **If you are comfortable with APIs, you can also use the API links to access this data. You can learn more about how to use the API at Carto’s SQL API site and in the Carto guide in the section on making calls to the API.**

Resources

Name Format Description Link
8 https://phl.carto.com/api/v2/sql?filename=incidents_part1_part2&format=csv&skipfields=cartodb_id,the_geom,the_geom_webmercator&q=SELECT%20%2A%20,%20ST_Y(the_geom)%20AS%20lat,%20ST_X(the_geom)%20AS%20lng%20FROM%20incidents_part1_part2%20WHERE%20dispatch_date_time%20%3E=%20'2018-01-01'%20AND%20dispatch_date_time%20%3C%20'2019-01-01'
8 https://phl.carto.com/api/v2/sql?filename=incidents_part1_part2&format=csv&skipfields=cartodb_id,the_geom,the_geom_webmercator&q=SELECT%20%2A%20,%20ST_Y(the_geom)%20AS%20lat,%20ST_X(the_geom)%20AS%20lng%20FROM%20incidents_part1_part2%20WHERE%20dispatch_date_time%20%3E=%20'2017-01-01'%20AND%20dispatch_date_time%20%3C%20'2018-01-01'
8 https://phl.carto.com/api/v2/sql?filename=incidents_part1_part2&format=csv&skipfields=cartodb_id,the_geom,the_geom_webmercator&q=SELECT%20%2A%20,%20ST_Y(the_geom)%20AS%20lat,%20ST_X(the_geom)%20AS%20lng%20FROM%20incidents_part1_part2%20WHERE%20dispatch_date_time%20%3E=%20'2016-01-01'%20AND%20dispatch_date_time%20%3C%20'2017-01-01'
8 https://phl.carto.com/api/v2/sql?filename=incidents_part1_part2&format=csv&skipfields=cartodb_id,the_geom,the_geom_webmercator&q=SELECT%20%2A%20,%20ST_Y(the_geom)%20AS%20lat,%20ST_X(the_geom)%20AS%20lng%20FROM%20incidents_part1_part2%20WHERE%20dispatch_date_time%20%3E=%20'2014-01-01'%20AND%20dispatch_date_time%20%3C%20'2015-01-01'
8 https://phl.carto.com/api/v2/sql?filename=incidents_part1_part2&format=csv&skipfields=cartodb_id,the_geom,the_geom_webmercator&q=SELECT%20%2A%20,%20ST_Y(the_geom)%20AS%20lat,%20ST_X(the_geom)%20AS%20lng%20FROM%20incidents_part1_part2%20WHERE%20dispatch_date_time%20%3E=%20'2013-01-01'%20AND%20dispatch_date_time%20%3C%20'2014-01-01'
8 https://phl.carto.com/api/v2/sql?filename=incidents_part1_part2&format=csv&skipfields=cartodb_id,the_geom,the_geom_webmercator&q=SELECT%20%2A%20,%20ST_Y(the_geom)%20AS%20lat,%20ST_X(the_geom)%20AS%20lng%20FROM%20incidents_part1_part2%20WHERE%20dispatch_date_time%20%3E=%20'2012-01-01'%20AND%20dispatch_date_time%20%3C%20'2013-01-01'
8 https://phl.carto.com/api/v2/sql?filename=incidents_part1_part2&format=csv&skipfields=cartodb_id,the_geom,the_geom_webmercator&q=SELECT%20%2A%20,%20ST_Y(the_geom)%20AS%20lat,%20ST_X(the_geom)%20AS%20lng%20FROM%20incidents_part1_part2%20WHERE%20dispatch_date_time%20%3E=%20'2011-01-01'%20AND%20dispatch_date_time%20%3C%20'2012-01-01'
8 https://phl.carto.com/api/v2/sql?filename=incidents_part1_part2&format=csv&skipfields=cartodb_id,the_geom,the_geom_webmercator&q=SELECT%20%2A%20,%20ST_Y(the_geom)%20AS%20lat,%20ST_X(the_geom)%20AS%20lng%20FROM%20incidents_part1_part2%20WHERE%20dispatch_date_time%20%3E=%20'2010-01-01'%20AND%20dispatch_date_time%20%3C%20'2011-01-01'
8 https://phl.carto.com/api/v2/sql?filename=incidents_part1_part2&format=csv&skipfields=cartodb_id,the_geom,the_geom_webmercator&q=SELECT%20%2A%20,%20ST_Y(the_geom)%20AS%20lat,%20ST_X(the_geom)%20AS%20lng%20FROM%20incidents_part1_part2%20WHERE%20dispatch_date_time%20%3E=%20'2009-01-01'%20AND%20dispatch_date_time%20%3C%20'2010-01-01'
8 https://phl.carto.com/api/v2/sql?filename=incidents_part1_part2&format=csv&skipfields=cartodb_id,the_geom,the_geom_webmercator&q=SELECT%20%2A%20,%20ST_Y(the_geom)%20AS%20lat,%20ST_X(the_geom)%20AS%20lng%20FROM%20incidents_part1_part2%20WHERE%20dispatch_date_time%20%3E=%20'2007-01-01'%20AND%20dispatch_date_time%20%3C%20'2008-01-01'
8 https://phl.carto.com/api/v2/sql?filename=incidents_part1_part2&format=csv&skipfields=cartodb_id,the_geom,the_geom_webmercator&q=SELECT%20%2A%20,%20ST_Y(the_geom)%20AS%20lat,%20ST_X(the_geom)%20AS%20lng%20FROM%20incidents_part1_part2%20WHERE%20dispatch_date_time%20%3E=%20'2006-01-01'%20AND%20dispatch_date_time%20%3C%20'2007-01-01'
61 https://phl.carto.com/api/v2/sql?filename=incidents_part1_part2&format=shp&skipfields=cartodb_id&q=SELECT%20%2A%20FROM%20incidents_part1_part2%20WHERE%20dispatch_date_time%20%3E=%20%272025-01-01%27%20AND%20dispatch_date_time%20%3C%20%272026-01-01%27
61 https://phl.carto.com/api/v2/sql?filename=incidents_part1_part2&format=shp&skipfields=cartodb_id&q=SELECT%20%2A%20FROM%20incidents_part1_part2%20WHERE%20dispatch_date_time%20%3E=%20%272023-01-01%27%20AND%20dispatch_date_time%20%3C%20%272024-01-01%27
61 https://phl.carto.com/api/v2/sql?filename=incidents_part1_part2&format=shp&skipfields=cartodb_id&q=SELECT%20%2A%20FROM%20incidents_part1_part2%20WHERE%20dispatch_date_time%20%3E=%20%272022-01-01%27%20AND%20dispatch_date_time%20%3C%20%272023-01-01%27
61 https://phl.carto.com/api/v2/sql?filename=incidents_part1_part2&format=shp&skipfields=cartodb_id&q=SELECT%20%2A%20FROM%20incidents_part1_part2%20WHERE%20dispatch_date_time%20%3E=%20'2020-01-01'%20AND%20dispatch_date_time%20%3C%20'2021-01-01'
61 https://phl.carto.com/api/v2/sql?filename=incidents_part1_part2&format=shp&skipfields=cartodb_id&q=SELECT%20%2A%20FROM%20incidents_part1_part2%20WHERE%20dispatch_date_time%20%3E=%20'2019-01-01'%20AND%20dispatch_date_time%20%3C%20'2020-01-01'
61 https://phl.carto.com/api/v2/sql?filename=incidents_part1_part2&format=shp&skipfields=cartodb_id&q=SELECT%20%2A%20FROM%20incidents_part1_part2%20WHERE%20dispatch_date_time%20%3E=%20'2018-01-01'%20AND%20dispatch_date_time%20%3C%20'2019-01-01'
61 https://phl.carto.com/api/v2/sql?filename=incidents_part1_part2&format=shp&skipfields=cartodb_id&q=SELECT%20%2A%20FROM%20incidents_part1_part2%20WHERE%20dispatch_date_time%20%3E=%20'2017-01-01'%20AND%20dispatch_date_time%20%3C%20'2018-01-01'
61 https://phl.carto.com/api/v2/sql?filename=incidents_part1_part2&format=shp&skipfields=cartodb_id&q=SELECT%20%2A%20FROM%20incidents_part1_part2%20WHERE%20dispatch_date_time%20%3E=%20'2016-01-01'%20AND%20dispatch_date_time%20%3C%20'2017-01-01'
61 https://phl.carto.com/api/v2/sql?filename=incidents_part1_part2&format=shp&skipfields=cartodb_id&q=SELECT%20%2A%20FROM%20incidents_part1_part2%20WHERE%20dispatch_date_time%20%3E=%20'2015-01-01'%20AND%20dispatch_date_time%20%3C%20'2016-01-01'
61 https://phl.carto.com/api/v2/sql?filename=incidents_part1_part2&format=shp&skipfields=cartodb_id&q=SELECT%20%2A%20FROM%20incidents_part1_part2%20WHERE%20dispatch_date_time%20%3E=%20'2014-01-01'%20AND%20dispatch_date_time%20%3C%20'2015-01-01'
61 https://phl.carto.com/api/v2/sql?filename=incidents_part1_part2&format=shp&skipfields=cartodb_id&q=SELECT%20%2A%20FROM%20incidents_part1_part2%20WHERE%20dispatch_date_time%20%3E=%20'2013-01-01'%20AND%20dispatch_date_time%20%3C%20'2014-01-01'
61 https://phl.carto.com/api/v2/sql?filename=incidents_part1_part2&format=shp&skipfields=cartodb_id&q=SELECT%20%2A%20FROM%20incidents_part1_part2%20WHERE%20dispatch_date_time%20%3E=%20'2012-01-01'%20AND%20dispatch_date_time%20%3C%20'2013-01-01'
61 https://phl.carto.com/api/v2/sql?filename=incidents_part1_part2&format=shp&skipfields=cartodb_id&q=SELECT%20%2A%20FROM%20incidents_part1_part2%20WHERE%20dispatch_date_time%20%3E=%20'2011-01-01'%20AND%20dispatch_date_time%20%3C%20'2012-01-01'
61 https://phl.carto.com/api/v2/sql?filename=incidents_part1_part2&format=shp&skipfields=cartodb_id&q=SELECT%20%2A%20FROM%20incidents_part1_part2%20WHERE%20dispatch_date_time%20%3E=%20'2010-01-01'%20AND%20dispatch_date_time%20%3C%20'2011-01-01'
61 https://phl.carto.com/api/v2/sql?filename=incidents_part1_part2&format=shp&skipfields=cartodb_id&q=SELECT%20%2A%20FROM%20incidents_part1_part2%20WHERE%20dispatch_date_time%20%3E=%20'2009-01-01'%20AND%20dispatch_date_time%20%3C%20'2010-01-01'
61 https://phl.carto.com/api/v2/sql?filename=incidents_part1_part2&format=shp&skipfields=cartodb_id&q=SELECT%20%2A%20FROM%20incidents_part1_part2%20WHERE%20dispatch_date_time%20%3E=%20'2008-01-01'%20AND%20dispatch_date_time%20%3C%20'2009-01-01'
61 https://phl.carto.com/api/v2/sql?filename=incidents_part1_part2&format=shp&skipfields=cartodb_id&q=SELECT%20%2A%20FROM%20incidents_part1_part2%20WHERE%20dispatch_date_time%20%3E=%20'2007-01-01'%20AND%20dispatch_date_time%20%3C%20'2008-01-01'
61 https://phl.carto.com/api/v2/sql?filename=incidents_part1_part2&format=shp&skipfields=cartodb_id&q=SELECT%20%2A%20FROM%20incidents_part1_part2%20WHERE%20dispatch_date_time%20%3E=%20'2006-01-01'%20AND%20dispatch_date_time%20%3C%20'2007-01-01'
21 http://metadata.phila.gov/#home/datasetdetails/5543868920583086178c4f8e/representationdetails/570e7621c03327dc14f4b68d/
21 https://www.phillypolice.com/crimestats
21 https://data.phila.gov/visualizations/crime-incidents
8 https://phl.carto.com/api/v2/sql?filename=incidents_part1_part2&format=csv&q=SELECT%20%2A%20,%20ST_Y(the_geom)%20AS%20lat,%20ST_X(the_geom)%20AS%20lng%20FROM%20incidents_part1_part2%20WHERE%20dispatch_date_time%20%3E=%20%272024-01-01%27%20AND%20dispatch_date_time%20%3C%20%272025-01-01%27
8 https://phl.carto.com/api/v2/sql?filename=incidents_part1_part2&format=csv&q=SELECT%20%2A%20,%20ST_Y(the_geom)%20AS%20lat,%20ST_X(the_geom)%20AS%20lng%20FROM%20incidents_part1_part2%20WHERE%20dispatch_date_time%20%3E=%20%272023-01-01%27%20AND%20dispatch_date_time%20%3C%20%272024-01-01%27
8 https://phl.carto.com/api/v2/sql?filename=incidents_part1_part2&format=csv&q=SELECT%20%2A%20,%20ST_Y(the_geom)%20AS%20lat,%20ST_X(the_geom)%20AS%20lng%20FROM%20incidents_part1_part2%20WHERE%20dispatch_date_time%20%3E=%20%272022-01-01%27%20AND%20dispatch_date_time%20%3C%20%272023-01-01%27
8 https://phl.carto.com/api/v2/sql?filename=incidents_part1_part2&format=csv&q=SELECT%20%2A%20,%20ST_Y(the_geom)%20AS%20lat,%20ST_X(the_geom)%20AS%20lng%20FROM%20incidents_part1_part2%20WHERE%20dispatch_date_time%20%3E=%20%272021-01-01%27%20AND%20dispatch_date_time%20%3C%20%272022-01-01%27
8 https://phl.carto.com/api/v2/sql?filename=incidents_part1_part2&format=csv&q=SELECT%20%2A%20,%20ST_Y(the_geom)%20AS%20lat,%20ST_X(the_geom)%20AS%20lng%20FROM%20incidents_part1_part2%20WHERE%20dispatch_date_time%20%3E=%20%272020-01-01%27%20AND%20dispatch_date_time%20%3C%20%272021-01-01%27
8 https://phl.carto.com/api/v2/sql?filename=incidents_part1_part2&format=csv&skipfields=cartodb_id,the_geom,the_geom_webmercator&q=SELECT%20%2A%20,%20ST_Y(the_geom)%20AS%20lat,%20ST_X(the_geom)%20AS%20lng%20FROM%20incidents_part1_part2%20WHERE%20dispatch_date_time%20%3E=%20'2019-01-01'%20AND%20dispatch_date_time%20%3C%20'2020-01-01'
8 https://phl.carto.com/api/v2/sql?filename=incidents_part1_part2&format=csv&q=SELECT%20%2A%20,%20ST_Y(the_geom)%20AS%20lat,%20ST_X(the_geom)%20AS%20lng%20FROM%20incidents_part1_part2%20WHERE%20dispatch_date_time%20%3E=%20%272025-01-01%27%20AND%20dispatch_date_time%20%3C%20%272026-01-01%27
8 https://phl.carto.com/api/v2/sql?filename=incidents_part1_part2&format=csv&skipfields=cartodb_id,the_geom,the_geom_webmercator&q=SELECT%20%2A%20,%20ST_Y(the_geom)%20AS%20lat,%20ST_X(the_geom)%20AS%20lng%20FROM%20incidents_part1_part2%20WHERE%20dispatch_date_time%20%3E=%20'2015-01-01'%20AND%20dispatch_date_time%20%3C%20'2016-01-01'
8 https://phl.carto.com/api/v2/sql?filename=incidents_part1_part2&format=csv&skipfields=cartodb_id,the_geom,the_geom_webmercator&q=SELECT%20%2A%20,%20ST_Y(the_geom)%20AS%20lat,%20ST_X(the_geom)%20AS%20lng%20FROM%20incidents_part1_part2%20WHERE%20dispatch_date_time%20%3E=%20'2008-01-01'%20AND%20dispatch_date_time%20%3C%20'2009-01-01'
61 https://phl.carto.com/api/v2/sql?filename=incidents_part1_part2&format=shp&skipfields=cartodb_id&q=SELECT%20%2A%20FROM%20incidents_part1_part2%20WHERE%20dispatch_date_time%20%3E=%20%272024-01-01%27%20AND%20dispatch_date_time%20%3C%20%272025-01-01%27
61 https://phl.carto.com/api/v2/sql?filename=incidents_part1_part2&format=shp&skipfields=cartodb_id&q=SELECT%20%2A%20FROM%20incidents_part1_part2%20WHERE%20dispatch_date_time%20%3E=%20%272021-01-01%27%20AND%20dispatch_date_time%20%3C%20%272022-01-01%27
21 https://cityofphiladelphia.github.io/carto-api-explorer/#incidents_part1_part2

Tags

  • philadelphia-police-department
  • public-safety

Topics

  • Local Government

Categories