{"id":966,"date":"2016-10-17T12:14:48","date_gmt":"2016-10-17T19:14:48","guid":{"rendered":"http:\/\/miriamposner.com\/classes\/dh101f16\/?p=966"},"modified":"2016-10-17T12:35:06","modified_gmt":"2016-10-17T19:35:06","slug":"data-analysis-gender-breakdown-by-department","status":"publish","type":"post","link":"https:\/\/miriamposner.com\/classes\/dh101f16\/2016\/10\/17\/data-analysis-gender-breakdown-by-department\/","title":{"rendered":"Data Analysis: Gender Breakdown by Department"},"content":{"rendered":"<p><a href=\"https:\/\/controllerdata.lacity.org\/Statistics\/Gender-Breakdown-of-City-Workers-by-Department\/q45p-mx3u\">Gender Breakdown of City Works by Department<\/a> documents the percentage of male and female full-time employees in 2015 across the various Departments of Los Angeles, including city planning, fire, and sub-departments of public works, such as engineering and sanitation. The data set also reports the employee count and total payroll per department, the number of males and females in each department, and what percentage of the department are male and female. Additionally, the information also breaks down the male and female total salary within departments, the average salaries of males and females within departments, and the percent of the payroll given to males and given to females.<\/p>\n<p>This dataset was created by the Los Angeles City Controller\u2019s Office. I believe Wallack and Srinivasan would identify this dataset\u2019s ontology as a comparison between employee gender and salary within and between government departments. This data set is very easy to navigate, and theres a tool guide that allows viewers to make data visualizations for even easier juxtaposition and comparison.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-969\" src=\"http:\/\/miriamposner.com\/classes\/dh101f16\/wp-content\/uploads\/sites\/5\/2016\/10\/Screen-Shot-2016-10-17-at-10.12.20-AM-300x73.png\" alt=\"screen-shot-2016-10-17-at-10-12-20-am\" width=\"601\" height=\"146\" srcset=\"https:\/\/miriamposner.com\/classes\/dh101f16\/wp-content\/uploads\/sites\/5\/2016\/10\/Screen-Shot-2016-10-17-at-10.12.20-AM-300x73.png 300w, https:\/\/miriamposner.com\/classes\/dh101f16\/wp-content\/uploads\/sites\/5\/2016\/10\/Screen-Shot-2016-10-17-at-10.12.20-AM-768x186.png 768w, https:\/\/miriamposner.com\/classes\/dh101f16\/wp-content\/uploads\/sites\/5\/2016\/10\/Screen-Shot-2016-10-17-at-10.12.20-AM-1024x248.png 1024w, https:\/\/miriamposner.com\/classes\/dh101f16\/wp-content\/uploads\/sites\/5\/2016\/10\/Screen-Shot-2016-10-17-at-10.12.20-AM-1200x291.png 1200w\" sizes=\"auto, (max-width: 709px) 85vw, (max-width: 909px) 67vw, (max-width: 984px) 61vw, (max-width: 1362px) 45vw, 600px\" \/><\/p>\n<p>The line graph above, for example, shows average female salary in navy and average male salary in orange across the various departments. This data is very straightforward: on average, men make more money than women in 37 (out of the 40) departments, with women making more only in the Library, Recreation and Parks, and Public Works &#8211; Street Lighting Departments.<\/p>\n<p>On the ground level, grassroots coalitions\u00a0and social justice organizations, particularly feminist advocacy groups, would find this data very useful. Pulling up these statistics could have a big impact on arguments for women\u2019s rights or affirmative action. Seeing as though Los Angeles is one of the most liberal and diverse major cities in California and in the entirety of the Unites States, one could use these numbers to argue that there are still mass inequalities in the workforce today. At a higher level, this ontology also makes sense for policy makers and those in the City Planning and City Ethics Commission Departments who: (1) (hopefully) want equal and just opportunities for women, and (2) want to appear as though they are working towards\u00a0equal and just opportunities for women.<\/p>\n<p>While the numbers state the \u201cwhat\u201d in this gender breakdown, there is no \u201cwhy\u201d to explain the reasons behind them. In the fire department, for example, 92.8% of the full-time employees were male whereas only 7.2% were female. I assume this disparity has less to do with discrimination and more to do with the fact that less women want to be firefighters. Nevertheless, this could certainly lead to further social science analyses to explain this kind of information that has been left out of the data set.<\/p>\n<p>If I were to start over with data-collection, I would attempt to describe the ontology of higher rates of males in leadership positions than females. In the current data set, in the City Administrative Officer Department, almost 70% of the employees are female, and yet the average female salary is about $34,000.00 less than the average male salary. This is (also hopefully) because males hold most of the leadership\/managerial roles than females in this department, and not because males are making more money for the same work. By including columns stating how many males\/females in each department hold leadership positions, and how many males\/females in each department make over\/under $50,000.00, the spreadsheet could produce different narratives based on a different ontology described by the data.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Gender Breakdown of City Works by Department documents the percentage of male and female full-time employees in 2015 across the various Departments of Los Angeles, including city planning, fire, and &hellip; <a href=\"https:\/\/miriamposner.com\/classes\/dh101f16\/2016\/10\/17\/data-analysis-gender-breakdown-by-department\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Data Analysis: Gender Breakdown by Department&#8221;<\/span><\/a><\/p>\n","protected":false},"author":69,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_eb_attr":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-966","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/miriamposner.com\/classes\/dh101f16\/wp-json\/wp\/v2\/posts\/966","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/miriamposner.com\/classes\/dh101f16\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/miriamposner.com\/classes\/dh101f16\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/miriamposner.com\/classes\/dh101f16\/wp-json\/wp\/v2\/users\/69"}],"replies":[{"embeddable":true,"href":"https:\/\/miriamposner.com\/classes\/dh101f16\/wp-json\/wp\/v2\/comments?post=966"}],"version-history":[{"count":0,"href":"https:\/\/miriamposner.com\/classes\/dh101f16\/wp-json\/wp\/v2\/posts\/966\/revisions"}],"wp:attachment":[{"href":"https:\/\/miriamposner.com\/classes\/dh101f16\/wp-json\/wp\/v2\/media?parent=966"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/miriamposner.com\/classes\/dh101f16\/wp-json\/wp\/v2\/categories?post=966"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/miriamposner.com\/classes\/dh101f16\/wp-json\/wp\/v2\/tags?post=966"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}