{
  "accessLevel": "public",
  "contactPoint": {
    "fn": "City of Philadelphia Open Data Program",
    "hasEmail": "mailto:311datarequest@phila.gov"
  },
  "description": "This represents all service and information requests since December 8th, 2014 submitted to Philly311 via the 311 mobile application, calls, walk-ins, emails, the 311 website or social media. \r\n\r\n**Please note that this is a very large dataset. Unless you are comfortable working with APIs, we recommend using the [visualization](https://data.phila.gov/visualizations/311-requests/) to explore the data.**\r\n\r\nIf 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](https://carto.com/developers/sql-api/)  and in the [CARTO guide in the section on making calls to the API](https://carto.com/developers/sql-api/guides/making-calls/).**",
  "distribution": [
    {
      "accessURL": "http://metadata.phila.gov/#home/datasetdetails/5543864d20583086178c4e98/representationdetails/5762e19fa237544b2ecfe722/",
      "format": "HTML",
      "mediaType": "text/html",
      "title": "311 Requests (Metadata)"
    },
    {
      "accessURL": "https://cityofphiladelphia.github.io/carto-api-explorer/#public_cases_fc",
      "format": "HTML",
      "mediaType": "text/html",
      "title": "311 Requests - Full Dataset (API Documentation)"
    },
    {
      "accessURL": "https://data.phila.gov/visualizations/311-requests/",
      "format": "HTML",
      "mediaType": "text/html",
      "title": "311 Requests - Full Dataset (Visualization)"
    },
    {
      "downloadURL": "https://phl.carto.com/api/v2/sql?filename=public_cases_fc&format=csv&skipfields=cartodb_id,the_geom,the_geom_webmercator&q=SELECT%20%2A%20FROM%20public_cases_fc%20WHERE%20requested_datetime%20%3E=%20%272021-01-01%27%20AND%20requested_datetime%20%3C%20%272022-01-01%27",
      "format": "CSV",
      "mediaType": "text/csv",
      "title": "311 Requests for 2021 (CSV)"
    },
    {
      "downloadURL": "https://phl.carto.com/api/v2/sql?filename=public_cases_fc&format=csv&skipfields=cartodb_id,the_geom,the_geom_webmercator&q=SELECT%20%2A%20FROM%20public_cases_fc%20WHERE%20requested_datetime%20%3E=%20%272022-01-01%27%20AND%20requested_datetime%20%3C%20%272023-01-01%27",
      "format": "CSV",
      "mediaType": "text/csv",
      "title": "311 Requests for 2022 (CSV)"
    },
    {
      "downloadURL": "https://phl.carto.com/api/v2/sql?filename=public_cases_fc&format=csv&skipfields=cartodb_id,the_geom,the_geom_webmercator&q=SELECT%20%2A%20FROM%20public_cases_fc%20WHERE%20requested_datetime%20%3E=%20%272023-01-01%27%20AND%20requested_datetime%20%3C%20%272024-01-01%27",
      "format": "CSV",
      "mediaType": "text/csv",
      "title": "311 Requests for 2023 (CSV)"
    },
    {
      "downloadURL": "https://phl.carto.com/api/v2/sql?filename=public_cases_fc&format=csv&skipfields=cartodb_id,the_geom,the_geom_webmercator&q=SELECT%20%2A%20FROM%20public_cases_fc%20WHERE%20requested_datetime%20%3E=%20%272024-01-01%27%20AND%20requested_datetime%20%3C%20%272025-01-01%27",
      "format": "CSV",
      "mediaType": "text/csv",
      "title": "311 Requests for 2024 (CSV)"
    },
    {
      "downloadURL": "https://phl.carto.com/api/v2/sql?filename=public_cases_fc&format=csv&skipfields=cartodb_id,the_geom,the_geom_webmercator&q=SELECT%20%2A%20FROM%20public_cases_fc%20WHERE%20requested_datetime%20%3E=%20%272025-01-01%27%20AND%20requested_datetime%20%3C%20%272026-01-01%27",
      "format": "CSV",
      "mediaType": "text/csv",
      "title": "311 Requests for 2025 (CSV)"
    },
    {
      "downloadURL": "https://phl.carto.com/api/v2/sql?filename=public_cases_fc&format=csv&skipfields=cartodb_id,the_geom,the_geom_webmercator&q=SELECT%20%2A%20FROM%20public_cases_fc%20WHERE%20requested_datetime%20%3E=%20%272026-01-01%27%20AND%20requested_datetime%20%3C%20%272027-01-01%27",
      "format": "CSV",
      "mediaType": "text/csv",
      "title": "311 Requests for 2026 (CSV)"
    },
    {
      "downloadURL": "https://phl.carto.com/api/v2/sql?filename=public_cases_fc&format=csv&skipfields=cartodb_id,the_geom,the_geom_webmercator&q=SELECT%20%2A%20FROM%20public_cases_fc%20WHERE%20requested_datetime%20%3E=%20'2014-01-01'%20AND%20requested_datetime%20%3C%20'2015-01-01'",
      "format": "CSV",
      "mediaType": "text/csv",
      "title": "311 Requests for 2014 (CSV)"
    },
    {
      "downloadURL": "https://phl.carto.com/api/v2/sql?filename=public_cases_fc&format=csv&skipfields=cartodb_id,the_geom,the_geom_webmercator&q=SELECT%20%2A%20FROM%20public_cases_fc%20WHERE%20requested_datetime%20%3E=%20'2015-01-01'%20AND%20requested_datetime%20%3C%20'2016-01-01'",
      "format": "CSV",
      "mediaType": "text/csv",
      "title": "311 Requests for 2015 (CSV)"
    },
    {
      "downloadURL": "https://phl.carto.com/api/v2/sql?filename=public_cases_fc&format=csv&skipfields=cartodb_id,the_geom,the_geom_webmercator&q=SELECT%20%2A%20FROM%20public_cases_fc%20WHERE%20requested_datetime%20%3E=%20'2016-01-01'%20AND%20requested_datetime%20%3C%20'2017-01-01'",
      "format": "CSV",
      "mediaType": "text/csv",
      "title": "311 Requests for 2016 (CSV)"
    },
    {
      "downloadURL": "https://phl.carto.com/api/v2/sql?filename=public_cases_fc&format=csv&skipfields=cartodb_id,the_geom,the_geom_webmercator&q=SELECT%20%2A%20FROM%20public_cases_fc%20WHERE%20requested_datetime%20%3E=%20'2017-01-01'%20AND%20requested_datetime%20%3C%20'2018-01-01'",
      "format": "CSV",
      "mediaType": "text/csv",
      "title": "311 Requests for 2017 (CSV)"
    },
    {
      "downloadURL": "https://phl.carto.com/api/v2/sql?filename=public_cases_fc&format=csv&skipfields=cartodb_id,the_geom,the_geom_webmercator&q=SELECT%20%2A%20FROM%20public_cases_fc%20WHERE%20requested_datetime%20%3E=%20'2018-01-01'%20AND%20requested_datetime%20%3C%20'2019-01-01'",
      "format": "CSV",
      "mediaType": "text/csv",
      "title": "311 Requests for 2018 (CSV)"
    },
    {
      "downloadURL": "https://phl.carto.com/api/v2/sql?filename=public_cases_fc&format=csv&skipfields=cartodb_id,the_geom,the_geom_webmercator&q=SELECT%20%2A%20FROM%20public_cases_fc%20WHERE%20requested_datetime%20%3E=%20'2019-01-01'%20AND%20requested_datetime%20%3C%20'2020-01-01'",
      "format": "CSV",
      "mediaType": "text/csv",
      "title": "311 Requests for 2019 (CSV)"
    },
    {
      "downloadURL": "https://phl.carto.com/api/v2/sql?filename=public_cases_fc&format=csv&skipfields=cartodb_id,the_geom,the_geom_webmercator&q=SELECT%20%2A%20FROM%20public_cases_fc%20WHERE%20requested_datetime%20%3E=%20'2020-01-01'%20AND%20requested_datetime%20%3C%20'2021-01-01'",
      "format": "CSV",
      "mediaType": "text/csv",
      "title": "311 Requests for 2020 (CSV)"
    },
    {
      "downloadURL": "https://phl.carto.com/api/v2/sql?filename=public_cases_fc&format=shp&skipfields=cartodb_id&q=SELECT%20%2A%20FROM%20public_cases_fc%20WHERE%20requested_datetime%20%3E=%20'2014-01-01'%20AND%20requested_datetime%20%3C%20'2015-01-01'",
      "format": "SHP",
      "mediaType": "application/zip",
      "title": "311 Requests for 2014 (SHP)"
    },
    {
      "downloadURL": "https://phl.carto.com/api/v2/sql?filename=public_cases_fc&format=shp&skipfields=cartodb_id&q=SELECT%20%2A%20FROM%20public_cases_fc%20WHERE%20requested_datetime%20%3E=%20'2015-01-01'%20AND%20requested_datetime%20%3C%20'2016-01-01'",
      "format": "SHP",
      "mediaType": "application/zip",
      "title": "311 Requests for 2015 (SHP)"
    },
    {
      "downloadURL": "https://phl.carto.com/api/v2/sql?filename=public_cases_fc&format=shp&skipfields=cartodb_id&q=SELECT%20%2A%20FROM%20public_cases_fc%20WHERE%20requested_datetime%20%3E=%20'2016-01-01'%20AND%20requested_datetime%20%3C%20'2017-01-01'",
      "format": "SHP",
      "mediaType": "application/zip",
      "title": "311 Requests for 2016 (SHP)"
    },
    {
      "downloadURL": "https://phl.carto.com/api/v2/sql?filename=public_cases_fc&format=shp&skipfields=cartodb_id&q=SELECT%20%2A%20FROM%20public_cases_fc%20WHERE%20requested_datetime%20%3E=%20'2017-01-01'%20AND%20requested_datetime%20%3C%20'2018-01-01'",
      "format": "SHP",
      "mediaType": "application/zip",
      "title": "311 Requests for 2017 (SHP)"
    },
    {
      "downloadURL": "https://phl.carto.com/api/v2/sql?filename=public_cases_fc&format=shp&skipfields=cartodb_id&q=SELECT%20%2A%20FROM%20public_cases_fc%20WHERE%20requested_datetime%20%3E=%20'2018-01-01'%20AND%20requested_datetime%20%3C%20'2019-01-01'",
      "format": "SHP",
      "mediaType": "application/zip",
      "title": "311 Requests for 2018 (SHP)"
    },
    {
      "downloadURL": "https://phl.carto.com/api/v2/sql?filename=public_cases_fc&format=shp&skipfields=cartodb_id&q=SELECT%20%2A%20FROM%20public_cases_fc%20WHERE%20requested_datetime%20%3E=%20'2019-01-01'%20AND%20requested_datetime%20%3C%20'2020-01-01'",
      "format": "SHP",
      "mediaType": "application/zip",
      "title": "311 Requests for 2019 (SHP)"
    },
    {
      "downloadURL": "https://phl.carto.com/api/v2/sql?filename=public_cases_fc&format=shp&skipfields=cartodb_id&q=SELECT%20%2A%20FROM%20public_cases_fc%20WHERE%20requested_datetime%20%3E=%20'2020-01-01'%20AND%20requested_datetime%20%3C%20'2021-01-01'",
      "format": "SHP",
      "mediaType": "application/zip",
      "title": "311 Requests for 2020 (SHP)"
    },
    {
      "downloadURL": "https://phl.carto.com/api/v2/sql?filename=public_cases_fc&format=shp&skipfields=cartodb_id&q=SELECT%20%2A%20FROM%20public_cases_fc%20WHERE%20requested_datetime%20%3E=%20'2021-01-01'%20AND%20requested_datetime%20%3C%20'2022-01-01'",
      "format": "SHP",
      "mediaType": "application/zip",
      "title": "311 Requests for 2021 (SHP)"
    },
    {
      "downloadURL": "https://phl.carto.com/api/v2/sql?filename=public_cases_fc&format=shp&skipfields=cartodb_id&q=SELECT%20%2A%20FROM%20public_cases_fc%20WHERE%20requested_datetime%20%3E=%20'2022-01-01'%20AND%20requested_datetime%20%3C%20'2023-01-01'",
      "format": "SHP",
      "mediaType": "application/zip",
      "title": "311 Requests for 2022 (SHP)"
    },
    {
      "downloadURL": "https://phl.carto.com/api/v2/sql?filename=public_cases_fc&format=shp&skipfields=cartodb_id&q=SELECT%20%2A%20FROM%20public_cases_fc%20WHERE%20requested_datetime%20%3E=%20'2023-01-01'%20AND%20requested_datetime%20%3C%20'2024-01-01'",
      "format": "SHP",
      "mediaType": "application/zip",
      "title": "311 Requests for 2023 (SHP)"
    },
    {
      "downloadURL": "https://phl.carto.com/api/v2/sql?filename=public_cases_fc&format=shp&skipfields=cartodb_id&q=SELECT%20%2A%20FROM%20public_cases_fc%20WHERE%20requested_datetime%20%3E=%20'2024-01-01'%20AND%20requested_datetime%20%3C%20'2025-01-01'",
      "format": "SHP",
      "mediaType": "application/zip",
      "title": "311 Requests for 2024 (SHP)"
    },
    {
      "downloadURL": "https://phl.carto.com/api/v2/sql?filename=public_cases_fc&format=shp&skipfields=cartodb_id&q=SELECT%20%2A%20FROM%20public_cases_fc%20WHERE%20requested_datetime%20%3E=%20'2025-01-01'%20AND%20requested_datetime%20%3C%20'2026-01-01'",
      "format": "SHP",
      "mediaType": "application/zip",
      "title": "311 Requests for 2025 (SHP)"
    },
    {
      "downloadURL": "https://phl.carto.com/api/v2/sql?filename=public_cases_fc&format=shp&skipfields=cartodb_id&q=SELECT%20%2A%20FROM%20public_cases_fc%20WHERE%20requested_datetime%20%3E=%20'2026-01-01'%20AND%20requested_datetime%20%3C%20'2027-01-01'",
      "format": "SHP",
      "mediaType": "application/zip",
      "title": "311 Requests for 2026 (SHP)"
    }
  ],
  "identifier": "311-service-and-information-requests",
  "keyword": [
    "environment",
    "health",
    "human services",
    "information requests",
    "maintenance",
    "repairs",
    "transportation"
  ],
  "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": "311 Service and Information Requests"
}