{"accessLevel": "public", "contactPoint": {"fn": "publicsafetygis@phila.gov", "hasEmail": "mailto:publicsafetygis@phila.gov"}, "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.\r\n\r\n**Please note that this is a very large dataset. To see all incidents, download all datasets for all years.** \r\n\r\n**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\u2019s SQL API site and in the Carto guide in the section on making calls to the API.**", "distribution": [{"accessURL": "https://www.phillypolice.com/crimestats", "format": "HTML", "mediaType": "text/html", "title": "Crime Maps and Stats Application"}, {"accessURL": "https://data.phila.gov/visualizations/crime-incidents", "format": "HTML", "mediaType": "text/html", "title": "Crime Incidents (Visualization)"}, {"downloadURL": "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%272026-01-01%27%20AND%20dispatch_date_time%20%3C%20%272027-01-01%27", "format": "CSV", "mediaType": "text/csv", "title": "Crime Incidents from 2026 (CSV)"}, {"downloadURL": "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", "format": "CSV", "mediaType": "text/csv", "title": "Crime Incidents from 2025 (CSV)"}, {"downloadURL": "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", "format": "CSV", "mediaType": "text/csv", "title": "Crime Incidents from 2024 (CSV)"}, {"downloadURL": "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", "format": "CSV", "mediaType": "text/csv", "title": "Crime Incidents from 2023 (CSV)"}, {"downloadURL": "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", "format": "CSV", "mediaType": "text/csv", "title": "Crime Incidents from 2022 (CSV)"}, {"downloadURL": "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", "format": "CSV", "mediaType": "text/csv", "title": "Crime Incidents from 2021 (CSV)"}, {"downloadURL": "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", "format": "CSV", "mediaType": "text/csv", "title": "Crime Incidents from 2020 (CSV)"}, {"downloadURL": "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'", "format": "CSV", "mediaType": "text/csv", "title": "Crime Incidents from 2019 (CSV)"}, {"downloadURL": "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'", "format": "CSV", "mediaType": "text/csv", "title": "Crime Incidents from 2018 (CSV)"}, {"downloadURL": "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'", "format": "CSV", "mediaType": "text/csv", "title": "Crime Incidents from 2017 (CSV)"}, {"downloadURL": "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'", "format": "CSV", "mediaType": "text/csv", "title": "Crime Incidents from 2016 (CSV)"}, {"downloadURL": "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'", "format": "CSV", "mediaType": "text/csv", "title": "Crime Incidents from 2015 (CSV)"}, {"downloadURL": "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'", "format": "CSV", "mediaType": "text/csv", "title": "Crime Incidents from 2014 (CSV)"}, {"downloadURL": "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'", "format": "CSV", "mediaType": "text/csv", "title": "Crime Incidents from 2013 (CSV)"}, {"downloadURL": "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'", "format": "CSV", "mediaType": "text/csv", "title": "Crime Incidents from 2012 (CSV)"}, {"downloadURL": "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'", "format": "CSV", "mediaType": "text/csv", "title": "Crime Incidents from 2011 (CSV)"}, {"downloadURL": "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'", "format": "CSV", "mediaType": "text/csv", "title": "Crime Incidents from 2010 (CSV)"}, {"downloadURL": "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'", "format": "CSV", "mediaType": "text/csv", "title": "Crime Incidents from 2009 (CSV)"}, {"downloadURL": "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'", "format": "CSV", "mediaType": "text/csv", "title": "Crime Incidents from 2008 (CSV)"}, {"downloadURL": "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'", "format": "CSV", "mediaType": "text/csv", "title": "Crime Incidents from 2007 (CSV)"}, {"downloadURL": "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'", "format": "CSV", "mediaType": "text/csv", "title": "Crime Incidents from 2006 (CSV)"}, {"downloadURL": "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%272026-01-01%27%20AND%20dispatch_date_time%20%3C%20%272027-01-01%27", "format": "SHP", "mediaType": "application/zip", "title": "Crime Incidents from 2026 (SHP)"}, {"downloadURL": "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", "format": "SHP", "mediaType": "application/zip", "title": "Crime Incidents from 2025 (SHP)"}, {"downloadURL": "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", "format": "SHP", "mediaType": "application/zip", "title": "Crime Incidents from 2024 (SHP)"}, {"downloadURL": "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", "format": "SHP", "mediaType": "application/zip", "title": "Crime Incidents from 2023 (SHP)"}, {"downloadURL": "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", "format": "SHP", "mediaType": "application/zip", "title": "Crime Incidents from 2022 (SHP)"}, {"downloadURL": "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", "format": "SHP", "mediaType": "application/zip", "title": "Crime Incidents from 2021 (SHP)"}, {"downloadURL": "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'", "format": "SHP", "mediaType": "application/zip", "title": "Crime Incidents from 2020 (SHP)"}, {"downloadURL": "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'", "format": "SHP", "mediaType": "application/zip", "title": "Crime Incidents from 2019 (SHP)"}, {"downloadURL": "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'", "format": "SHP", "mediaType": "application/zip", "title": "Crime Incidents from 2018 (SHP)"}, {"downloadURL": "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'", "format": "SHP", "mediaType": "application/zip", "title": "Crime Incidents from 2017 (SHP)"}, {"downloadURL": "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'", "format": "SHP", "mediaType": "application/zip", "title": "Crime Incidents from 2016 (SHP)"}, {"downloadURL": "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'", "format": "SHP", "mediaType": "application/zip", "title": "Crime Incidents from 2015 (SHP)"}, {"downloadURL": "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'", "format": "SHP", "mediaType": "application/zip", "title": "Crime Incidents from 2014 (SHP)"}, {"downloadURL": "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'", "format": "SHP", "mediaType": "application/zip", "title": "Crime Incidents from 2013 (SHP)"}, {"downloadURL": "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'", "format": "SHP", "mediaType": "application/zip", "title": "Crime Incidents from 2012 (SHP)"}, {"downloadURL": "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'", "format": "SHP", "mediaType": "application/zip", "title": "Crime Incidents from 2011 (SHP)"}, {"downloadURL": "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'", "format": "SHP", "mediaType": "application/zip", "title": "Crime Incidents from 2010 (SHP)"}, {"downloadURL": "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'", "format": "SHP", "mediaType": "application/zip", "title": "Crime Incidents from 2009 (SHP)"}, {"downloadURL": "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'", "format": "SHP", "mediaType": "application/zip", "title": "Crime Incidents from 2008 (SHP)"}, {"downloadURL": "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'", "format": "SHP", "mediaType": "application/zip", "title": "Crime Incidents from 2007 (SHP)"}, {"downloadURL": "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'", "format": "SHP", "mediaType": "application/zip", "title": "Crime Incidents from 2006 (SHP)"}, {"accessURL": "https://cityofphiladelphia.github.io/carto-api-explorer/#incidents_part1_part2", "format": "HTML", "mediaType": "text/html", "title": "Crime Incidents - Full Dataset (API Documentation)"}, {"accessURL": "http://metadata.phila.gov/#home/datasetdetails/5543868920583086178c4f8e/representationdetails/570e7621c03327dc14f4b68d/", "format": "HTML", "mediaType": "text/html", "title": "Crime Incidents (Metadata)"}], "identifier": "crime-incidents", "keyword": ["public safety", "Philadelphia Police Department"], "license": "https://metadata.phila.gov/#help/help-faqs/what-are-the-terms-of-use/", "modified": "R/P1D", "publisher": {"@type": "org:Organization", "name": "City of Philadelphia"}, "spatial": "Philadelphia, Pennsylvania", "title": "Crime Incidents"}