Skip to main content
U.S. flag

An official website of the United States government

Licenses and Inspections Code Violations

Published by City of Philadelphia | City of Philadelphia | Catalog Last Checked: August 02, 2025 at 12:37 PM
Violations issued by the Department of Licenses and Inspections in reference to the Philadelphia Building Construction and Occupancy Code. **Please note that L&I Violations is a very large dataset. To see all violations, 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

31 resources available

Find Related Datasets

Search by Tags

Click any tag below to search for similar datasets

Complete Metadata
@type dcat:Dataset
accessLevel public
contactPoint 
                                            {
  "fn": "LIGISTEAM@phila.gov",
  "hasEmail": "mailto:LIGISTEAM@phila.gov"
}
description Violations issued by the Department of Licenses and Inspections in reference to the Philadelphia Building Construction and Occupancy Code. **Please note that L&I Violations is a very large dataset. To see all violations, 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.**
distribution 
                                            [
  {
    "title": "L&I Imminently Dangerous Buildings (API)",
    "format": "API",
    "accessURL": "https://cityofphiladelphia.github.io/carto-api-explorer/#imm_dang",
    "mediaType": "application/http"
  },
  {
    "title": "L&I Unsafe Buildings (API)",
    "format": "API",
    "accessURL": "https://cityofphiladelphia.github.io/carto-api-explorer/#unsafe",
    "mediaType": "application/http"
  },
  {
    "title": "L&I Violations (API)",
    "format": "API",
    "accessURL": "https://cityofphiladelphia.github.io/carto-api-explorer/#violations",
    "mediaType": "application/http"
  },
  {
    "title": "L&I Imminently Dangerous (Visualization)",
    "format": "HTML",
    "accessURL": "https://data.phila.gov/visualizations/li-imminently-dangerous",
    "mediaType": "text/html"
  },
  {
    "title": "L&I Unsafe Buildings (Visualization)",
    "format": "HTML",
    "accessURL": "https://data.phila.gov/visualizations/li-unsafe",
    "mediaType": "text/html"
  },
  {
    "title": "L&I Violations (Visualization)",
    "format": "HTML",
    "accessURL": "https://data.phila.gov/visualizations/li-violations",
    "mediaType": "text/html"
  },
  {
    "title": "L&I Imminently Dangerous Buildings (Metadata)",
    "format": "HTML",
    "accessURL": "https://metadata.phila.gov/#home/datasetdetails/5543ca7a5c4ae4cd66d3ff86/representationdetails/5e98add33441510015135305/",
    "mediaType": "text/html"
  },
  {
    "title": "L&I Unsafe Buildings (Metadata)",
    "format": "HTML",
    "accessURL": "https://metadata.phila.gov/#home/datasetdetails/5543ca7a5c4ae4cd66d3ff86/representationdetails/5e98b247c4d4770015ca69f7/",
    "mediaType": "text/html"
  },
  {
    "title": "L&I Violations (Metadata)",
    "format": "HTML",
    "accessURL": "https://metadata.phila.gov/#home/datasetdetails/5543ca7a5c4ae4cd66d3ff86/representationdetails/5e99bab227c80700158695b0/",
    "mediaType": "text/html"
  },
  {
    "title": "L&I Contractor Violations (Metadata)",
    "format": "HTML",
    "accessURL": "https://metadata.phila.gov/#home/datasetdetails/5543ca7a5c4ae4cd66d3ff86/representationdetails/60a56925ef206f001ed69179/",
    "mediaType": "text/html"
  },
  {
    "title": "L&I Violation Definition (Metadata)",
    "format": "HTML",
    "accessURL": "https://metadata.phila.gov/#home/datasetdetails/5543ca7a5c4ae4cd66d3ff86/representationdetails/60f6cc83d3d51d00211c2c5e/",
    "mediaType": "text/html"
  },
  {
    "title": "L&I Violation Definition (API)",
    "format": "API",
    "accessURL": "https://services.arcgis.com/fLeGjb7u4uXqeF9q/ArcGIS/rest/services/VIOLATION_DEFINITION/FeatureServer/0/query?where=1%3D1",
    "mediaType": "application/http"
  },
  {
    "title": "L&I Contractor Violations (API)",
    "format": "API",
    "accessURL": "https://services.arcgis.com/fLeGjb7u4uXqeF9q/arcgis/rest/services/CONTRACTOR_VIOLATIONS/FeatureServer/0/query?outFields=%2A&where=1%3D1",
    "mediaType": "application/http"
  },
  {
    "title": "L&I Violation Definition (CSV)",
    "format": "CSV",
    "mediaType": "text/csv",
    "downloadURL": "https://hub.arcgis.com/api/v3/datasets/d9753daaefcb47cebabbfb9f9f344a91_0/downloads/data?format=csv&spatialRefId=3857&where=1%3D1"
  },
  {
    "title": "L&I Contractor Violations (CSV)",
    "format": "CSV",
    "mediaType": "text/csv",
    "downloadURL": "https://hub.arcgis.com/api/v3/datasets/dbc8c4b06d3c40aab87d48a5fcdafc58_0/downloads/data?format=csv&spatialRefId=3857&where=1%3D1"
  },
  {
    "title": "L&I Violations - 2007 to 2009 (CSV)",
    "format": "CSV",
    "mediaType": "text/csv",
    "downloadURL": "https://phl.carto.com/api/v2/sql?&filename=violations&format=csv&skipfields=cartodb_id,the_geom,the_geom_webmercator&q=SELECT%20%2A,%20ST_Y(the_geom)%20AS%20lat,%20ST_X(the_geom)%20AS%20lng%20FROM%20violations%20WHERE%20violationdate%20%3E=%20'2007-01-01'%20AND%20violationdate%20%3C%20'2010-01-01'"
  },
  {
    "title": "L&I Violations - 2010 to 2012 (CSV)",
    "format": "CSV",
    "mediaType": "text/csv",
    "downloadURL": "https://phl.carto.com/api/v2/sql?&filename=violations&format=csv&skipfields=cartodb_id,the_geom,the_geom_webmercator&q=SELECT%20%2A,%20ST_Y(the_geom)%20AS%20lat,%20ST_X(the_geom)%20AS%20lng%20FROM%20violations%20WHERE%20violationdate%20%3E=%20'2010-01-01'%20AND%20violationdate%20%3C%20'2013-01-01'"
  },
  {
    "title": "L&I Violations - 2013 to 2015 (CSV)",
    "format": "CSV",
    "mediaType": "text/csv",
    "downloadURL": "https://phl.carto.com/api/v2/sql?&filename=violations&format=csv&skipfields=cartodb_id,the_geom,the_geom_webmercator&q=SELECT%20%2A,%20ST_Y(the_geom)%20AS%20lat,%20ST_X(the_geom)%20AS%20lng%20FROM%20violations%20WHERE%20violationdate%20%3E=%20'2013-01-01'%20AND%20violationdate%20%3C%20'2016-01-01'"
  },
  {
    "title": "L&I Violations - 2016 to 2018 (CSV)",
    "format": "CSV",
    "mediaType": "text/csv",
    "downloadURL": "https://phl.carto.com/api/v2/sql?&filename=violations&format=csv&skipfields=cartodb_id,the_geom,the_geom_webmercator&q=SELECT%20%2A,%20ST_Y(the_geom)%20AS%20lat,%20ST_X(the_geom)%20AS%20lng%20FROM%20violations%20WHERE%20violationdate%20%3E=%20'2016-01-01'%20AND%20violationdate%20%3C%20'2019-01-01'"
  },
  {
    "title": "L&I Violations - 2019 to present (CSV)",
    "format": "CSV",
    "mediaType": "text/csv",
    "downloadURL": "https://phl.carto.com/api/v2/sql?&filename=violations&format=csv&skipfields=cartodb_id,the_geom,the_geom_webmercator&q=SELECT%20%2A,%20ST_Y(the_geom)%20AS%20lat,%20ST_X(the_geom)%20AS%20lng%20FROM%20violations%20WHERE%20violationdate%20%3E=%20'2019-01-01'"
  },
  {
    "title": "L&I Violations - 2007 to 2009 (SHP)",
    "format": "SHP",
    "mediaType": "application/zip",
    "downloadURL": "https://phl.carto.com/api/v2/sql?filename=violations&format=shp&skipfields=cartodb_id&q=SELECT%20%2A%20FROM%20violations%20WHERE%20violationdate%20%3E=%20'2007-01-01'%20AND%20violationdate%20%3C%20'2010-01-01'"
  },
  {
    "title": "L&I Violations - 2010 to 2012 (SHP)",
    "format": "SHP",
    "mediaType": "application/zip",
    "downloadURL": "https://phl.carto.com/api/v2/sql?filename=violations&format=shp&skipfields=cartodb_id&q=SELECT%20%2A%20FROM%20violations%20WHERE%20violationdate%20%3E=%20'2010-01-01'%20AND%20violationdate%20%3C%20'2013-01-01'"
  },
  {
    "title": "L&I Violations - 2013 to 2015 (SHP)",
    "format": "SHP",
    "mediaType": "application/zip",
    "downloadURL": "https://phl.carto.com/api/v2/sql?filename=violations&format=shp&skipfields=cartodb_id&q=SELECT%20%2A%20FROM%20violations%20WHERE%20violationdate%20%3E=%20'2013-01-01'%20AND%20violationdate%20%3C%20'2016-01-01'"
  },
  {
    "title": "L&I Violations - 2016 to 2018 (SHP)",
    "format": "SHP",
    "mediaType": "application/zip",
    "downloadURL": "https://phl.carto.com/api/v2/sql?filename=violations&format=shp&skipfields=cartodb_id&q=SELECT%20%2A%20FROM%20violations%20WHERE%20violationdate%20%3E=%20'2016-01-01'%20AND%20violationdate%20%3C%20'2019-01-01'"
  },
  {
    "title": "L&I Violations - 2019 to present (SHP)",
    "format": "SHP",
    "mediaType": "application/zip",
    "downloadURL": "https://phl.carto.com/api/v2/sql?filename=violations&format=shp&skipfields=cartodb_id&q=SELECT%20%2A%20FROM%20violations%20WHERE%20violationdate%20%3E=%20'2019-01-01'"
  },
  {
    "title": "L&I Imminently Dangerous Buildings (GeoJSON)",
    "format": "GEOJSON",
    "mediaType": "application/octet-stream",
    "downloadURL": "https://phl.carto.com/api/v2/sql?q=SELECT+%2A+FROM+imm_dang&filename=imm_dang&format=geojson&skipfields=cartodb_id"
  },
  {
    "title": "L&I Imminently Dangerous Buildings (SHP)",
    "format": "SHP",
    "mediaType": "application/zip",
    "downloadURL": "https://phl.carto.com/api/v2/sql?q=SELECT+%2A+FROM+imm_dang&filename=imm_dang&format=shp&skipfields=cartodb_id"
  },
  {
    "title": "L&I Unsafe Buildings (GeoJSON)",
    "format": "GEOJSON",
    "mediaType": "application/octet-stream",
    "downloadURL": "https://phl.carto.com/api/v2/sql?q=SELECT+%2A+FROM+unsafe&filename=unsafe&format=geojson&skipfields=cartodb_id"
  },
  {
    "title": "L&I Unsafe Buildings (SHP)",
    "format": "SHP",
    "mediaType": "application/zip",
    "downloadURL": "https://phl.carto.com/api/v2/sql?q=SELECT+%2A+FROM+unsafe&filename=unsafe&format=shp&skipfields=cartodb_id"
  },
  {
    "title": "L&I Imminently Dangerous Buildings (CSV)",
    "format": "CSV",
    "mediaType": "text/csv",
    "downloadURL": "https://phl.carto.com/api/v2/sql?q=SELECT+%2A,+ST_Y(the_geom)+AS+lat,+ST_X(the_geom)+AS+lng+FROM+imm_dang&filename=imm_dang&format=csv&skipfields=cartodb_id"
  },
  {
    "title": "L&I Unsafe Buildings (CSV)",
    "format": "CSV",
    "mediaType": "text/csv",
    "downloadURL": "https://phl.carto.com/api/v2/sql?q=SELECT+%2A,+ST_Y(the_geom)+AS+lat,+ST_X(the_geom)+AS+lng+FROM+unsafe&filename=unsafe&format=csv&skipfields=cartodb_id"
  }
]
identifier licenses-and-inspections-code-violations
keyword 
                                            [
  "Department of Licenses and Inspections",
  "code violations",
  "contractors",
  "dangerous buildings",
  "land records",
  "public safety",
  "real estate"
]
license https://metadata.phila.gov/#help/help-faqs/what-are-the-terms-of-use/
modified R/P1D
publisher 
                                            {
  "name": "City of Philadelphia",
  "@type": "org:Organization"
}
spatial Philadelphia, Pennsylvania
title Licenses and Inspections Code Violations

data.gov

An official website of the GSA's Technology Transformation Services

Looking for U.S. government information and services?
Visit USA.gov