Return to search results
311 Service and Information Requests
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.
**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.**
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](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/).**
Complete Metadata
| accessLevel | public |
|---|---|
| contactPoint |
{
"fn": "City of Philadelphia Open Data Program",
"hasEmail": "mailto:james.morse@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. **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.** 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](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 |
[
{
"title": "311 Requests (Metadata)",
"format": "HTML",
"accessURL": "http://metadata.phila.gov/#home/datasetdetails/5543864d20583086178c4e98/representationdetails/5762e19fa237544b2ecfe722/",
"mediaType": "text/html"
},
{
"title": "311 Requests - Full Dataset (API Documentation)",
"format": "HTML",
"accessURL": "https://cityofphiladelphia.github.io/carto-api-explorer/#public_cases_fc",
"mediaType": "text/html"
},
{
"title": "311 Requests - Full Dataset (Visualization)",
"format": "HTML",
"accessURL": "https://data.phila.gov/visualizations/311-requests/",
"mediaType": "text/html"
},
{
"title": "311 Requests for 2021 (CSV)",
"format": "CSV",
"mediaType": "text/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%272021-01-01%27%20AND%20requested_datetime%20%3C%20%272022-01-01%27"
},
{
"title": "311 Requests for 2022 (CSV)",
"format": "CSV",
"mediaType": "text/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"
},
{
"title": "311 Requests for 2023 (CSV)",
"format": "CSV",
"mediaType": "text/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"
},
{
"title": "311 Requests for 2024 (CSV)",
"format": "CSV",
"mediaType": "text/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"
},
{
"title": "311 Requests for 2025 (CSV)",
"format": "CSV",
"mediaType": "text/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"
},
{
"title": "311 Requests for 2014 (CSV)",
"format": "CSV",
"mediaType": "text/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'"
},
{
"title": "311 Requests for 2015 (CSV)",
"format": "CSV",
"mediaType": "text/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'"
},
{
"title": "311 Requests for 2016 (CSV)",
"format": "CSV",
"mediaType": "text/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'"
},
{
"title": "311 Requests for 2017 (CSV)",
"format": "CSV",
"mediaType": "text/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'"
},
{
"title": "311 Requests for 2018 (CSV)",
"format": "CSV",
"mediaType": "text/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'"
},
{
"title": "311 Requests for 2019 (CSV)",
"format": "CSV",
"mediaType": "text/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'"
},
{
"title": "311 Requests for 2020 (CSV)",
"format": "CSV",
"mediaType": "text/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'"
},
{
"title": "311 Requests for 2014 (SHP)",
"format": "SHP",
"mediaType": "application/zip",
"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'"
},
{
"title": "311 Requests for 2015 (SHP)",
"format": "SHP",
"mediaType": "application/zip",
"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'"
},
{
"title": "311 Requests for 2016 (SHP)",
"format": "SHP",
"mediaType": "application/zip",
"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'"
},
{
"title": "311 Requests for 2017 (SHP)",
"format": "SHP",
"mediaType": "application/zip",
"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'"
},
{
"title": "311 Requests for 2018 (SHP)",
"format": "SHP",
"mediaType": "application/zip",
"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'"
},
{
"title": "311 Requests for 2019 (SHP)",
"format": "SHP",
"mediaType": "application/zip",
"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'"
},
{
"title": "311 Requests for 2020 (SHP)",
"format": "SHP",
"mediaType": "application/zip",
"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'"
},
{
"title": "311 Requests for 2021 (SHP)",
"format": "SHP",
"mediaType": "application/zip",
"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'"
},
{
"title": "311 Requests for 2022 (SHP)",
"format": "SHP",
"mediaType": "application/zip",
"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'"
},
{
"title": "311 Requests for 2023 (SHP)",
"format": "SHP",
"mediaType": "application/zip",
"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'"
},
{
"title": "311 Requests for 2024 (SHP)",
"format": "SHP",
"mediaType": "application/zip",
"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'"
},
{
"title": "311 Requests for 2025 (SHP)",
"format": "SHP",
"mediaType": "application/zip",
"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'"
}
]
|
| 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 |
{
"name": "City of Philadelphia",
"@type": "org:Organization"
}
|
| spatial | Philadelphia, Pennsylvania |
| title | 311 Service and Information Requests |