{"id":1607,"date":"2017-10-23T11:27:13","date_gmt":"2017-10-23T18:27:13","guid":{"rendered":"http:\/\/miriamposner.com\/classes\/dh101f17\/?p=1607"},"modified":"2017-10-23T11:27:13","modified_gmt":"2017-10-23T18:27:13","slug":"la-city-employee-payroll","status":"publish","type":"post","link":"http:\/\/miriamposner.com\/classes\/dh101f17\/2017\/10\/23\/la-city-employee-payroll\/","title":{"rendered":"LA City Employee Payroll"},"content":{"rendered":"

I chose to look at Los Angeles\u00a0City Employee Payroll<\/a>\u00a0Data. This dataset contains information about the pay of all City employees, with each row being an individual who is represented by a unique ID number, and the columns giving more information about their position and a breakdown of their pay and benefits. This seems to be the main function of their dataset: describing an individual\u2019s position within the city by indicating their Department, title, and job class, and then breaking down the different ways they are paid by the City. This dataset reveals the complexity of payroll, which is broken down into categories like \u2018Event or Hourly Rate\u2019 and \u2018Projected Hourly Salary\u2019, and then less easily understood categories, like \u2018Longevity Bonus Pay\u2019 and \u2018Other Pay and Adjustments\u2019.<\/p>\n

This Dataset has 294,229 rows, and is updated on a quarterly basis. The web-based interface allows users to apply their own filters, sort the data, search within it, and highlight cells. But even with the interactive tools, I found this dataset to be overwhelming due to my limited accounting knowledge.<\/p>\n

This dataset makes the most sense to someone with background knowledge payroll and different positions within the city–for internal use, such as audits of City spending payroll. This dataset is valuable for purposes of comparison across departments–looking at which department spends the most on Payroll, or has the most individuals on payroll. It could also be used to find average pay and benefit rates, or the number of people within a certain pay amount. The job title is not self-explanatory, so I appreciate that each row links to a PDF that describes each job class in detail. I can imagine that this dataset might upset Angelinos who feel like certain individuals are paid too much with their tax dollars–I was surprised to find that the top 5 highest salaries all come from the Los Angeles airports, with \u2018General Manager Airports\u2019 all earning over $360K a year. The mayor appears as the 408th highest paid individual. These are interesting facts for a member of the public, but the data is definitely focused on identifying spending within departments of the City.<\/p>\n

What this dataset does not include is more detailed demographic information–I think it would be interesting to know the gender, or race of the individuals listed.\u00a0 My suggestion for an alternative ontology would highlight these characteristics for the purpose of comparing pay between different groups and identifying disparities.\u00a0 A user would be able to compare pay by gender, enabling further investigation into the wage gap within the City. I can understand why the inclusion of such personally descriptive information might raise concerns about privacy; it would challenge the limitations of government transparency, and the extent to which individuals become publicly visible when they work in government.<\/p>\n

While this dataset seems impressively comprehensive and well-maintained, Open Government Data often leaves me asking the \u201cso what\u201d question\u2014what is the value of such a dataset beyond the gesture of transparency? I\u2019m interested in learning about how these open data portals are used at a community level to enact change, and how data open data can be made more useful to the public.<\/p>\n

\"Inline
The top 5 highest paid individuals it the City<\/figcaption><\/figure>\n

\n","protected":false},"excerpt":{"rendered":"

I chose to look at Los Angeles\u00a0City Employee Payroll\u00a0Data. This dataset contains information about the pay of all City employees,<\/p>\n","protected":false},"author":108,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_eb_attr":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-1607","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"jetpack_featured_media_url":"","_links":{"self":[{"href":"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/posts\/1607","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/users\/108"}],"replies":[{"embeddable":true,"href":"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/comments?post=1607"}],"version-history":[{"count":0,"href":"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/posts\/1607\/revisions"}],"wp:attachment":[{"href":"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/media?parent=1607"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/categories?post=1607"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/tags?post=1607"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}