{"id":876,"date":"2016-10-16T21:22:01","date_gmt":"2016-10-17T04:22:01","guid":{"rendered":"http:\/\/miriamposner.com\/classes\/dh101f16\/?p=876"},"modified":"2016-10-17T11:33:49","modified_gmt":"2016-10-17T18:33:49","slug":"exploring-los-angeles-payroll","status":"publish","type":"post","link":"http:\/\/miriamposner.com\/classes\/dh101f16\/2016\/10\/16\/exploring-los-angeles-payroll\/","title":{"rendered":"Exploring Los Angeles Payroll"},"content":{"rendered":"<p>I chose to explore the <a href=\"https:\/\/controllerdata.lacity.org\/Payroll\/City-Payroll-Data\/pazn-qyym\">City Payroll Data<\/a> of Los Angeles, which provides the payroll information for all the city departments since 2013. The information is organized under various data types and is put into a spreadsheet, which is updated after payments for each quarter are made.<\/p>\n<p>The data types include year, department title, payroll department, record number, job class title, employment type, hourly or event rate, projected annual salary, Q1 payments, Q2 payments, Q3 payments, Q4 payments, payments over base pay, % over base pay, total payments, base pay, permanent bonus pay, longevity bonus pay, temporary bonus pay, lump sum pay, overtime pay, other pay &amp; adjustments, other pay (payroll explorer), MOU, MOU title, FMS department, job class, pay grade, average health cost, average dental cost, average basic life, average benefit cost, benefits plan, and job class link. Details about the data types can be found by\u00a0hovering over\u00a0the information button under the column headings. Each row of the spreadsheet presents a record of each city department employee in this dataset.<\/p>\n<p>According to Wallack and Srinivasan, communities and states present information about people, places, things, and events around them, organized in the form of ontologies, which are essentially \u201csystems of categories and their interrelations\u201d. The dataset is a meta ontology, as it is a community-based ontology and a large-scale dataset with numerous quantitative indicators, looking at payroll for the Los Angeles departments.<\/p>\n<p>This data would be most useful and illuminating to city department employees, enabling them to explore and compare the payroll of other employees in various job titles and departments. It would be easier for them to go through the information, as they are able to understand the financial data types and terms used in the dataset. I think it\u2019s also important for residents to explore this dataset and grasp a better understanding of the payroll of city employees and the imbalance of taxpayers\u2019 contributions amongst the departments.<\/p>\n<p>If I had to reorganize the dataset, I would focus on the annual salary and the hourly rate, organizing them from the highest to the lowest. It would also be interesting to organize the data according to job titles. The reorganization of the dataset could make it more focused on identifying which departments are being more favored in terms of payroll. As for data collection, I would like to include gender and race indicators to gain insight on how these data types influence payroll for city department jobs and how sexism and racism still exist in the workforce.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I chose to explore the City Payroll Data of Los Angeles, which provides the payroll information for all the city departments since 2013. The information is organized under various data &hellip; <a href=\"http:\/\/miriamposner.com\/classes\/dh101f16\/2016\/10\/16\/exploring-los-angeles-payroll\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Exploring Los Angeles Payroll&#8221;<\/span><\/a><\/p>\n","protected":false},"author":43,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_eb_attr":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-876","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\/876","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\/43"}],"replies":[{"embeddable":true,"href":"http:\/\/miriamposner.com\/classes\/dh101f16\/wp-json\/wp\/v2\/comments?post=876"}],"version-history":[{"count":0,"href":"http:\/\/miriamposner.com\/classes\/dh101f16\/wp-json\/wp\/v2\/posts\/876\/revisions"}],"wp:attachment":[{"href":"http:\/\/miriamposner.com\/classes\/dh101f16\/wp-json\/wp\/v2\/media?parent=876"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/miriamposner.com\/classes\/dh101f16\/wp-json\/wp\/v2\/categories?post=876"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/miriamposner.com\/classes\/dh101f16\/wp-json\/wp\/v2\/tags?post=876"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}