{"id":1585,"date":"2017-10-23T11:35:33","date_gmt":"2017-10-23T18:35:33","guid":{"rendered":"http:\/\/miriamposner.com\/classes\/dh101f17\/?p=1585"},"modified":"2017-10-23T11:35:33","modified_gmt":"2017-10-23T18:35:33","slug":"la-city-payroll","status":"publish","type":"post","link":"https:\/\/miriamposner.com\/classes\/dh101f17\/2017\/10\/23\/la-city-payroll\/","title":{"rendered":"LA City Payroll"},"content":{"rendered":"<p>For this week&#8217;s blogpost, I analyzed the <a href=\"https:\/\/controllerdata.lacity.org\/Payroll\/Payroll\/qjfm-3srk\">payroll<\/a> for all L<span style=\"font-size: 1.125rem\">os Angeles City\u00a0<\/span><span style=\"font-size: 1.125rem\">departments beginning in 2017. I chose this dataset as it provides an interesting account of the city&#8217;s fiscal expenditures, and therefore its priorities.<\/span><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1594 aligncenter\" style=\"font-size: 1.125rem\" src=\"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-content\/uploads\/sites\/7\/2017\/10\/lapd-1.png\" alt=\"\" width=\"472\" height=\"251\" srcset=\"https:\/\/miriamposner.com\/classes\/dh101f17\/wp-content\/uploads\/sites\/7\/2017\/10\/lapd-1.png 472w, https:\/\/miriamposner.com\/classes\/dh101f17\/wp-content\/uploads\/sites\/7\/2017\/10\/lapd-1-300x160.png 300w\" sizes=\"auto, (max-width: 472px) 100vw, 472px\" \/><\/p>\n<p>The dataset organizes its 265,000 records through 35 content types. These content types include (among many more): year, department title, job class title, pay grade, employment type, pr<span style=\"font-size: 1.125rem\">ojected annual salary, hourly or event rate, overtime, lump sum pay, and average city health cost. This organizational method allows for easy statistical and comparative readings of average salaries. This data set is useful for those looking for jobs with the city or those already employed looking to appraise salary cuts\/raises, or other payroll related analyses.\u00a0<\/span><\/p>\n<p>While the payroll is informative in a numerical sense, it does not necessarily offer a lot of information pertaining to the more qualitative aspects of these jobs. For example, we cannot see how long someone has been employed with the city, a major determinant of salary, or things as average hours worked. Because full-time jobs do not offer overtime, it is hard to assess the work-life balance these jobs offer.<\/p>\n<p>To offer a different ontology, I would wish to see more information pertaining to employees&#8217; backgrounds. What type of degrees do employees have and do levels of education correspond with pay rates? Do gender, sexuality, or ethnic\/racial identity make a difference in salary? While the data set offered, provides a lot of statistical information, its omission of employees&#8217; idiosyncrasies treats workers as numbers rather than people &#8212; and while this is all fine and good from a purely numbers standpoint, it offers very little to interpret for social analysis.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>For this week&#8217;s blogpost, I analyzed the payroll for all Los Angeles City\u00a0departments beginning in 2017. I chose this dataset<\/p>\n","protected":false},"author":166,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_eb_attr":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-1585","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/posts\/1585","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/users\/166"}],"replies":[{"embeddable":true,"href":"https:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/comments?post=1585"}],"version-history":[{"count":0,"href":"https:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/posts\/1585\/revisions"}],"wp:attachment":[{"href":"https:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/media?parent=1585"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/categories?post=1585"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/tags?post=1585"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}