{"action":"create","ckan_id":null,"date_created":"Sat, 07 Mar 2026 20:51:07 GMT","date_finished":null,"harvest_job_id":"5c90c12e-4595-4662-b753-b87339da15a1","harvest_source_id":"273d8fe1-da31-4ee1-853a-037e5f9307bf","id":"962764d9-5b7c-4792-8998-5722f35f1378","identifier":"city-employee-earnings","parent_identifier":null,"source_hash":"55b6d7422be13809d42937bb70037f7ff9b5682a22bce4f7bcc2c560b455804b","source_raw":"{\"accessLevel\": \"public\", \"contactPoint\": {\"fn\": \"City of Philadelphia Open Data Program\", \"hasEmail\": \"mailto:maps@phila.gov\"}, \"description\": \"__This data does not necessarily represent current salaries of employees and is intended for informational purposes only. Formal requests to document salary details or other personnel information should be made through the [City's Human Resources department](https://www.phila.gov/departments/office-of-human-resources/).__\\r\\n\\r\\nEarnings for all City employees, including elected officials and Court staff.  Data since 2019 up to the most recent quarter of this year. Please note that since  employee counts fluctuate throughout the year, the sum  of the BASE_SALARY field does not reflect the total budgeted amount. Also, when the BASE_SALARY column is blank, it represents part-time, temporary, or seasonal employees paid by the hour. Please see [metadata](https://metadata.phila.gov/#home/datasetdetails/5543865520583086178c4ebd/representationdetails/604284dc49a209001d746460/?view_287_per_page=25&view_287_page=1) for detailed explanations of each field.\\r\\n\\r\\n\", \"distribution\": [{\"accessURL\": \"https://cityofphiladelphia.github.io/carto-api-explorer/#employee_earnings\", \"format\": \"API\", \"mediaType\": \"application/http\", \"title\": \"Employee Earnings - 2019 to this year's most recent quarter(API)\"}, {\"accessURL\": \"https://cityofphiladelphia.github.io/carto-api-explorer/#employee_salaries_archive\", \"format\": \"HTML\", \"mediaType\": \"text/html\", \"title\": \"ARCHIVED: Employee Salaries 2016 to CY2019 Q1  (API)\"}, {\"accessURL\": \"https://data.phila.gov/visualizations/employee-earnings\", \"format\": \"HTML\", \"mediaType\": \"text/html\", \"title\": \"Employee Earnings (Visualization)\"}, {\"accessURL\": \"https://metadata.phila.gov/#home/datasetdetails/5543865520583086178c4ebd/representationdetails/5702f25233ec3695104ca926/\", \"format\": \"HTML\", \"mediaType\": \"text/html\", \"title\": \"ARCHIVED:  Employee Salaries 2016 - CY2019 Q1 (Metadata)\"}, {\"accessURL\": \"https://metadata.phila.gov/#home/datasetdetails/5543865520583086178c4ebd/representationdetails/604284dc49a209001d746460/?view_287_per_page=25&view_287_page=1\", \"format\": \"HTML\", \"mediaType\": \"text/html\", \"title\": \"Employee Earnings - 2019 to this year's most recent quarter (Metadata)\"}, {\"downloadURL\": \"https://phl.carto.com/api/v2/sql?q=SELECT+%2A+FROM+employee_earnings&filename=employee_earnings&format=csv&skipfields=cartodb_id\", \"format\": \"CSV\", \"mediaType\": \"text/csv\", \"title\": \"Employee Earnings - 2019 to this year's most recent quarter (CSV)\"}, {\"downloadURL\": \"https://phl.carto.com/api/v2/sql?q=SELECT+%2A+FROM+employee_salaries_archive&filename=employee_salaries_archive&format=csv&skipfields=cartodb_id,the_geom,the_geom_webmercator\", \"format\": \"CSV\", \"mediaType\": \"text/csv\", \"title\": \"ARCHIVED: Employee Salaries 2016 to CY2019 Q1 (CSV)\"}], \"identifier\": \"city-employee-earnings\", \"keyword\": [\"budget\", \"earnings\", \"economy\", \"employee salaries\", \"finance\", \"overtime\", \"salaries\", \"wages\"], \"license\": \"https://metadata.phila.gov/#help/help-faqs/what-are-the-terms-of-use/\", \"modified\": null, \"publisher\": {\"@type\": \"org:Organization\", \"name\": \"City of Philadelphia\"}, \"spatial\": \"Philadelphia, Pennsylvania\", \"title\": \"City Employee Earnings\"}","source_transform":null,"status":"error"}