{"id":947,"date":"2016-10-17T11:44:51","date_gmt":"2016-10-17T18:44:51","guid":{"rendered":"http:\/\/miriamposner.com\/classes\/dh101f16\/?p=947"},"modified":"2016-10-17T11:44:51","modified_gmt":"2016-10-17T18:44:51","slug":"week-4-top-city-earners","status":"publish","type":"post","link":"http:\/\/miriamposner.com\/classes\/dh101f16\/2016\/10\/17\/week-4-top-city-earners\/","title":{"rendered":"Week 4 – Top City Earners"},"content":{"rendered":"

I thought the Top City Earners<\/a> dataset from the L.A. Controller\u2019s Office<\/a> would be an interesting set to dive into. This dataset showcases the top salaries for Los Angeles city workers. These salaries are comprised of various factors such as base pay, overtime pay, other pay, and more.<\/p>\n

The various data types are the occupations, and the amounts of money they are paid. These monetary values are also broken down into sections. These pieces of data comprise a record with occupation title and total pay. Wallack and Srinivasan describe ontologies as, \u201csystems of categories and their interrelations by which groups order and manage information about the people, places, things, and events around them.\u201d The ontology can be seen in the records for each occupation. The various categories data types add up to make total salaries. But when looking at each position, the data types combine in different ways. For instance, when looking at purely base pay, the Chief of Police and the General Manager & Chief Engineer of Water and Power earn the most. However, when factoring things such as bonus pay and overtime pay, the positions at the port earn the most. Another thing that is quite interesting is that firefighters seem to make the lowest base pay. Often, their overtime pay is double that of their base pay. Why is this the case?<\/p>\n

\"screen-shot-2016-10-17-at-11-41-22-am\"Some people that may find this data useful are city officials who are in charge of the budget, and also taxpayers. City officials can see how much of the budget is going to what positions and how they affect the city as a whole. Taxpayers can see where some of their tax dollars are going, and how the city of LA is paying its workers. I would imagine people would wonder why some positions get so much bonus pay. The job descriptions and years of experience are missing from the data set. This would help to differentiate the positions and give context as to why they are being paid so much. This also helps in comparison. For instance, why does a port pilot make significantly more than firefighters or police officers?<\/p>\n

When approaching this data again, it would be interesting to divide the records by job types such as firefighters, police officers, and port pilots. It would be interesting to see the pay distribution in the individual categories.<\/p>\n","protected":false},"excerpt":{"rendered":"

I thought the Top City Earners dataset from the L.A. Controller\u2019s Office would be an interesting set to dive into. This dataset showcases the top salaries for Los Angeles city … Continue reading “Week 4 – Top City Earners”<\/span><\/a><\/p>\n","protected":false},"author":55,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_eb_attr":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-947","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"jetpack_featured_media_url":"","_links":{"self":[{"href":"http:\/\/miriamposner.com\/classes\/dh101f16\/wp-json\/wp\/v2\/posts\/947","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/miriamposner.com\/classes\/dh101f16\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/miriamposner.com\/classes\/dh101f16\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/miriamposner.com\/classes\/dh101f16\/wp-json\/wp\/v2\/users\/55"}],"replies":[{"embeddable":true,"href":"http:\/\/miriamposner.com\/classes\/dh101f16\/wp-json\/wp\/v2\/comments?post=947"}],"version-history":[{"count":0,"href":"http:\/\/miriamposner.com\/classes\/dh101f16\/wp-json\/wp\/v2\/posts\/947\/revisions"}],"wp:attachment":[{"href":"http:\/\/miriamposner.com\/classes\/dh101f16\/wp-json\/wp\/v2\/media?parent=947"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/miriamposner.com\/classes\/dh101f16\/wp-json\/wp\/v2\/categories?post=947"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/miriamposner.com\/classes\/dh101f16\/wp-json\/wp\/v2\/tags?post=947"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}