Skip to main content
U.S. flag

An official website of the United States government

Licenses and Inspections: Case Investigations

Published by City of Philadelphia | City of Philadelphia | Catalog Last Checked: September 10, 2026 at 06:58 PM
All investigations completed on a property with property maintenance violations by an inspector of the Department of Licenses & Inspections. **Please note that this is a very large dataset. To see all investigations, 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

15 resources available

  • L&I Case investigations (API)

    API
    Visit Page

  • L&I Inspections (Visualization)

    HTML
    Visit Page

  • L&I Case investigations (Metadata)

    HTML
    Visit Page

  • L&I Case investigations - before 2007 (CSV)

    CSV
    Download

  • L&I Case investigations - 2007 to 2009 (CSV)

    CSV
    Download

  • L&I Case investigations - 2010 to 2012 (CSV)

    CSV
    Download

  • L&I Case investigations - 2013 to 2015 (CSV)

    CSV
    Download

  • L&I Case investigations - 2016 to 2018 (CSV)

    CSV
    Download

  • L&I Case investigations - 2019 to present (CSV)

    CSV
    Download

  • L&I Case investigations - before 2007 (SHP)

    SHP
    Download

  • L&I Case investigations - 2007 to 2009 (SHP)

    SHP
    Download

  • L&I Case investigations - 2010 to 2012 (SHP)

    SHP
    Download

  • L&I Case investigations - 2013 to 2015 (SHP)

    SHP
    Download

  • L&I Case investigations - 2016 to 2018 (SHP)

    SHP
    Download

  • L&I Case investigations - 2019 to present (SHP)

    SHP
    Download

Find Related Datasets

Search by Tags

Click any tag below to search for similar datasets

Complete Metadata
accessLevel public
contactPoint 
{
  "fn": "ligisteam@phila.gov",
  "hasEmail": "mailto:LIGISTEAM@phila.gov"
}
description All investigations completed on a property with property maintenance violations by an inspector of the Department of Licenses & Inspections. **Please note that this is a very large dataset. To see all investigations, 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 Case investigations (API)",
    "format": "API",
    "accessURL": "https://cityofphiladelphia.github.io/carto-api-explorer/#case_investigations",
    "mediaType": "application/http"
  },
  {
    "title": "L&I Inspections (Visualization)",
    "format": "HTML",
    "accessURL": "https://data.phila.gov/visualizations/li-inspections",
    "mediaType": "text/html"
  },
  {
    "title": "L&I Case investigations (Metadata) ",
    "format": "HTML",
    "accessURL": "https://metadata.phila.gov/#home/datasetdetails/5543ca785c4ae4cd66d3ff80/representationdetails/5e986970b2c39b001522fb9d/",
    "mediaType": "text/html"
  },
  {
    "title": "L&I Case investigations - before 2007 (CSV)",
    "format": "CSV",
    "mediaType": "text/csv",
    "downloadURL": "https://phl.carto.com/api/v2/sql?filename=case_investigations&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%20case_investigations%20WHERE%20investigationcompleted%20%3C%20'2007-01-01'"
  },
  {
    "title": "L&I Case investigations - 2007 to 2009 (CSV)",
    "format": "CSV",
    "mediaType": "text/csv",
    "downloadURL": "https://phl.carto.com/api/v2/sql?filename=case_investigations&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%20case_investigations%20WHERE%20investigationcompleted%20%3E=%20'2007-01-01'%20AND%20investigationcompleted%20%3C%20'2010-01-01'"
  },
  {
    "title": "L&I Case investigations - 2010 to 2012 (CSV)",
    "format": "CSV",
    "mediaType": "text/csv",
    "downloadURL": "https://phl.carto.com/api/v2/sql?filename=case_investigations&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%20case_investigations%20WHERE%20investigationcompleted%20%3E=%20'2010-01-01'%20AND%20investigationcompleted%20%3C%20'2013-01-01'"
  },
  {
    "title": "L&I Case investigations - 2013 to 2015 (CSV)",
    "format": "CSV",
    "mediaType": "text/csv",
    "downloadURL": "https://phl.carto.com/api/v2/sql?filename=case_investigations&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%20case_investigations%20WHERE%20investigationcompleted%20%3E=%20'2013-01-01'%20AND%20investigationcompleted%20%3C%20'2016-01-01'"
  },
  {
    "title": "L&I Case investigations - 2016 to 2018 (CSV)",
    "format": "CSV",
    "mediaType": "text/csv",
    "downloadURL": "https://phl.carto.com/api/v2/sql?filename=case_investigations&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%20case_investigations%20WHERE%20investigationcompleted%20%3E=%20'2016-01-01'%20AND%20investigationcompleted%20%3C%20'2019-01-01'"
  },
  {
    "title": "L&I Case investigations - 2019 to present (CSV)",
    "format": "CSV",
    "mediaType": "text/csv",
    "downloadURL": "https://phl.carto.com/api/v2/sql?filename=case_investigations&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%20case_investigations%20WHERE%20investigationcompleted%20%3E=%20'2019-01-01'"
  },
  {
    "title": "L&I Case investigations - before 2007 (SHP)",
    "format": "SHP",
    "mediaType": "application/zip",
    "downloadURL": "https://phl.carto.com/api/v2/sql?filename=case_investigations&format=shp&skipfields=cartodb_id&q=SELECT%20%2A%20FROM%20case_investigations%20WHERE%20investigationcompleted%20%3C%20'2007-01-01'"
  },
  {
    "title": "L&I Case investigations - 2007 to 2009 (SHP)",
    "format": "SHP",
    "mediaType": "application/zip",
    "downloadURL": "https://phl.carto.com/api/v2/sql?filename=case_investigations&format=shp&skipfields=cartodb_id&q=SELECT%20%2A%20FROM%20case_investigations%20WHERE%20investigationcompleted%20%3E=%20'2007-01-01'%20AND%20investigationcompleted%20%3C%20'2010-01-01'"
  },
  {
    "title": "L&I Case investigations - 2010 to 2012 (SHP)",
    "format": "SHP",
    "mediaType": "application/zip",
    "downloadURL": "https://phl.carto.com/api/v2/sql?filename=case_investigations&format=shp&skipfields=cartodb_id&q=SELECT%20%2A%20FROM%20case_investigations%20WHERE%20investigationcompleted%20%3E=%20'2010-01-01'%20AND%20investigationcompleted%20%3C%20'2013-01-01'"
  },
  {
    "title": "L&I Case investigations - 2013 to 2015 (SHP)",
    "format": "SHP",
    "mediaType": "application/zip",
    "downloadURL": "https://phl.carto.com/api/v2/sql?filename=case_investigations&format=shp&skipfields=cartodb_id&q=SELECT%20%2A%20FROM%20case_investigations%20WHERE%20investigationcompleted%20%3E=%20'2013-01-01'%20AND%20investigationcompleted%20%3C%20'2016-01-01'"
  },
  {
    "title": "L&I Case investigations - 2016 to 2018 (SHP)",
    "format": "SHP",
    "mediaType": "application/zip",
    "downloadURL": "https://phl.carto.com/api/v2/sql?filename=case_investigations&format=shp&skipfields=cartodb_id&q=SELECT%20%2A%20FROM%20case_investigations%20WHERE%20investigationcompleted%20%3E=%20'2016-01-01'%20AND%20investigationcompleted%20%3C%20'2019-01-01'"
  },
  {
    "title": "L&I Case investigations - 2019 to present (SHP)",
    "format": "SHP",
    "mediaType": "application/zip",
    "downloadURL": "https://phl.carto.com/api/v2/sql?filename=case_investigations&format=shp&skipfields=cartodb_id&q=SELECT%20%2A%20FROM%20case_investigations%20WHERE%20investigationcompleted%20%3E=%20'2019-01-01'"
  }
]
identifier licenses-and-inspections-case-investigations
keyword 
[
  "Department of Licenses and Inspections",
  "Visualization",
  "land records",
  "planning",
  "real estate",
  "zoning"
]
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: Case Investigations

data.gov

An official website of the GSA's Technology Transformation Services

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