{"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\u2019s 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"}