{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":719236762,"defaultBranch":"main","name":"Teacher_Payroll_Analysis","ownerLogin":"Anias-clo","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2023-11-15T18:45:24.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/143330306?v=4","public":true,"private":false,"isOrgOwned":false},"refInfo":{"name":"","listCacheKey":"v0:1700073925.0","currentOid":""},"activityList":{"items":[{"before":"aa055f26c79b0175d1327bf875f70697f0cabed3","after":"1494d05911daa19192ccfe37a71dd2469bdcc620","ref":"refs/heads/main","pushedAt":"2024-06-06T23:25:37.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Anias-clo","name":"Chris Ortiz","path":"/Anias-clo","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/143330306?s=80&v=4"},"commit":{"message":"Moved visual in readme","shortMessageHtmlLink":"Moved visual in readme"}},{"before":"b816ebf0968c207b189a1f70fb49646dd88b715f","after":"aa055f26c79b0175d1327bf875f70697f0cabed3","ref":"refs/heads/main","pushedAt":"2024-06-06T23:14:30.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Anias-clo","name":"Chris Ortiz","path":"/Anias-clo","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/143330306?s=80&v=4"},"commit":{"message":"Added visuals to README. Added requirements.txt file - will update with more/less libraries later.","shortMessageHtmlLink":"Added visuals to README. Added requirements.txt file - will update wi…"}},{"before":"29f3687291ba2eedc3bafaf36e3bf507815bf494","after":"b816ebf0968c207b189a1f70fb49646dd88b715f","ref":"refs/heads/main","pushedAt":"2024-06-06T22:39:17.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Anias-clo","name":"Chris Ortiz","path":"/Anias-clo","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/143330306?s=80&v=4"},"commit":{"message":"Added a getting started section to the README so users can recreate the project locally. Need to add requirements.txt file.","shortMessageHtmlLink":"Added a getting started section to the README so users can recreate t…"}},{"before":"f9f189e9492c7db9bfade28dbb735a3cdf4c4717","after":"29f3687291ba2eedc3bafaf36e3bf507815bf494","ref":"refs/heads/main","pushedAt":"2024-06-05T03:54:52.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Anias-clo","name":"Chris Ortiz","path":"/Anias-clo","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/143330306?s=80&v=4"},"commit":{"message":"Revised several cells and added a todo list to complete the project","shortMessageHtmlLink":"Revised several cells and added a todo list to complete the project"}},{"before":"b60f64012b12c567db41d87e407609a4f8671bd8","after":"f9f189e9492c7db9bfade28dbb735a3cdf4c4717","ref":"refs/heads/main","pushedAt":"2023-12-14T20:52:20.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Anias-clo","name":"Chris Ortiz","path":"/Anias-clo","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/143330306?s=80&v=4"},"commit":{"message":"Created visualizations comparing salary delta and effective rate with fiscal year rate.","shortMessageHtmlLink":"Created visualizations comparing salary delta and effective rate with…"}},{"before":"3602d807354bce8aeb3b26bf8e6b9bc39e7e0d7b","after":"b60f64012b12c567db41d87e407609a4f8671bd8","ref":"refs/heads/main","pushedAt":"2023-12-14T20:16:13.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Anias-clo","name":"Chris Ortiz","path":"/Anias-clo","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/143330306?s=80&v=4"},"commit":{"message":"Removed large file from commit.","shortMessageHtmlLink":"Removed large file from commit."}},{"before":"1287bb730d0089651e09db691c370c8a34a7dbdf","after":"3602d807354bce8aeb3b26bf8e6b9bc39e7e0d7b","ref":"refs/heads/main","pushedAt":"2023-12-03T02:32:24.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Anias-clo","name":"Chris Ortiz","path":"/Anias-clo","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/143330306?s=80&v=4"},"commit":{"message":"Created salary summary dataset. WIP","shortMessageHtmlLink":"Created salary summary dataset. WIP"}},{"before":"3ab31dfbb613d727b5ad3a1874b1fce9f187b6a8","after":"1287bb730d0089651e09db691c370c8a34a7dbdf","ref":"refs/heads/main","pushedAt":"2023-12-02T04:37:11.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Anias-clo","name":"Chris Ortiz","path":"/Anias-clo","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/143330306?s=80&v=4"},"commit":{"message":"Uploading WIP lifetime earnings tables.","shortMessageHtmlLink":"Uploading WIP lifetime earnings tables."}},{"before":"0afec1c54d9f6bbba71fa7880fe5abc7a64c1c34","after":"3ab31dfbb613d727b5ad3a1874b1fce9f187b6a8","ref":"refs/heads/main","pushedAt":"2023-12-02T02:57:20.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Anias-clo","name":"Chris Ortiz","path":"/Anias-clo","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/143330306?s=80&v=4"},"commit":{"message":"Created table with lifetime earnings for each teacher.\"","shortMessageHtmlLink":"Created table with lifetime earnings for each teacher.\""}},{"before":"3b270dab3698db839d9f30b28eb47dc02a2d33a5","after":"0afec1c54d9f6bbba71fa7880fe5abc7a64c1c34","ref":"refs/heads/main","pushedAt":"2023-12-01T10:27:55.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Anias-clo","name":"Chris Ortiz","path":"/Anias-clo","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/143330306?s=80&v=4"},"commit":{"message":"Updated readme, cleaning salary schedule","shortMessageHtmlLink":"Updated readme, cleaning salary schedule"}},{"before":"a8968f22e2c00b3a5a6ea130cc476c6aa553aed9","after":"3b270dab3698db839d9f30b28eb47dc02a2d33a5","ref":"refs/heads/main","pushedAt":"2023-12-01T02:09:40.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Anias-clo","name":"Chris Ortiz","path":"/Anias-clo","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/143330306?s=80&v=4"},"commit":{"message":"Creating decades, teacher lifetime earnings summary, union dues, cumulative dues paid, cumulative additional pay tomorrow.","shortMessageHtmlLink":"Creating decades, teacher lifetime earnings summary, union dues, cumu…"}},{"before":"74239f1088f013a066cf0cd775f2214cf44f8487","after":"a8968f22e2c00b3a5a6ea130cc476c6aa553aed9","ref":"refs/heads/main","pushedAt":"2023-11-30T18:26:57.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Anias-clo","name":"Chris Ortiz","path":"/Anias-clo","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/143330306?s=80&v=4"},"commit":{"message":"Wrangled salary schedules. Need CPI data. Cleaned up repository and removed datasets.","shortMessageHtmlLink":"Wrangled salary schedules. Need CPI data. Cleaned up repository and r…"}},{"before":"26614cfd34de8a2f9735392bfeb329157dfff761","after":"74239f1088f013a066cf0cd775f2214cf44f8487","ref":"refs/heads/main","pushedAt":"2023-11-30T05:57:18.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Anias-clo","name":"Chris Ortiz","path":"/Anias-clo","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/143330306?s=80&v=4"},"commit":{"message":"Cleaned up repository. Added salary schedules from 2018-2027: Paystep, Salary Schedule, Differential, Differential Category, and Degree.","shortMessageHtmlLink":"Cleaned up repository. Added salary schedules from 2018-2027: Paystep…"}},{"before":"e3d375b7050eda6804f26dc956aff87f26106f38","after":"26614cfd34de8a2f9735392bfeb329157dfff761","ref":"refs/heads/main","pushedAt":"2023-11-29T22:34:47.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Anias-clo","name":"Chris Ortiz","path":"/Anias-clo","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/143330306?s=80&v=4"},"commit":{"message":"Cleaning up repo","shortMessageHtmlLink":"Cleaning up repo"}},{"before":"3ae1e3a2d85656d166c9f16281a2fb87f40bc460","after":"e3d375b7050eda6804f26dc956aff87f26106f38","ref":"refs/heads/main","pushedAt":"2023-11-29T22:33:13.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Anias-clo","name":"Chris Ortiz","path":"/Anias-clo","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/143330306?s=80&v=4"},"commit":{"message":"Found uft salary schedules from 2018-2021. Added pdfs and csv files of each salary schedule.","shortMessageHtmlLink":"Found uft salary schedules from 2018-2021. Added pdfs and csv files o…"}},{"before":"058161459de77ea06a197b7abeda7cdbcf5234cb","after":"3ae1e3a2d85656d166c9f16281a2fb87f40bc460","ref":"refs/heads/main","pushedAt":"2023-11-29T04:11:16.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Anias-clo","name":"Chris Ortiz","path":"/Anias-clo","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/143330306?s=80&v=4"},"commit":{"message":"EDA of pay schedule","shortMessageHtmlLink":"EDA of pay schedule"}},{"before":"ecbc5feb5877d8085f9ba9a12652c75c742ef103","after":"058161459de77ea06a197b7abeda7cdbcf5234cb","ref":"refs/heads/main","pushedAt":"2023-11-29T04:03:10.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Anias-clo","name":"Chris Ortiz","path":"/Anias-clo","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/143330306?s=80&v=4"},"commit":{"message":"Deleted unused salary schedule. More UFT contract analysis.","shortMessageHtmlLink":"Deleted unused salary schedule. More UFT contract analysis."}},{"before":"d3d2ccab68e75b0f7f3a19a81175a8a66c9c51bb","after":"ecbc5feb5877d8085f9ba9a12652c75c742ef103","ref":"refs/heads/main","pushedAt":"2023-11-29T02:48:44.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Anias-clo","name":"Chris Ortiz","path":"/Anias-clo","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/143330306?s=80&v=4"},"commit":{"message":"Analyzed fiscal years 2021-2023 to determine UFT negotiation impact.","shortMessageHtmlLink":"Analyzed fiscal years 2021-2023 to determine UFT negotiation impact."}},{"before":"89ca12d05561e7e9c0ad09570c033aa3111fe6af","after":"d3d2ccab68e75b0f7f3a19a81175a8a66c9c51bb","ref":"refs/heads/main","pushedAt":"2023-11-28T05:17:12.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Anias-clo","name":"Chris Ortiz","path":"/Anias-clo","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/143330306?s=80&v=4"},"commit":{"message":"Removed some cells","shortMessageHtmlLink":"Removed some cells"}},{"before":"a8b8f6768cc5fcf568c95ab659353d54a6d9add5","after":"89ca12d05561e7e9c0ad09570c033aa3111fe6af","ref":"refs/heads/main","pushedAt":"2023-11-28T05:15:05.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Anias-clo","name":"Chris Ortiz","path":"/Anias-clo","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/143330306?s=80&v=4"},"commit":{"message":"Created crosstabs to sanity check my initial findings.","shortMessageHtmlLink":"Created crosstabs to sanity check my initial findings."}},{"before":"ecfe95c2c13def7f30a7870df1928f4b768f35e7","after":"a8b8f6768cc5fcf568c95ab659353d54a6d9add5","ref":"refs/heads/main","pushedAt":"2023-11-27T21:16:47.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Anias-clo","name":"Chris Ortiz","path":"/Anias-clo","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/143330306?s=80&v=4"},"commit":{"message":"Created a new featured called Salary Simplified Delta Category. Need to determine the cost to teachers before and after negotiations: YoY deltas, YoY salary change factoring in UFT dues.","shortMessageHtmlLink":"Created a new featured called Salary Simplified Delta Category. Need …"}},{"before":"a832fabe4ac0007641c078b7cb72180fd964a91d","after":"ecfe95c2c13def7f30a7870df1928f4b768f35e7","ref":"refs/heads/main","pushedAt":"2023-11-27T08:27:04.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Anias-clo","name":"Chris Ortiz","path":"/Anias-clo","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/143330306?s=80&v=4"},"commit":{"message":"Removed Paystep columns. Need to recalc category bins.","shortMessageHtmlLink":"Removed Paystep columns. Need to recalc category bins."}},{"before":"1b84209907c5961ddcac48723afebe3f557a166a","after":"a832fabe4ac0007641c078b7cb72180fd964a91d","ref":"refs/heads/main","pushedAt":"2023-11-27T08:12:59.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Anias-clo","name":"Chris Ortiz","path":"/Anias-clo","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/143330306?s=80&v=4"},"commit":{"message":"Half of all teachers employed during 2022 and 2023 fiscal years receieved less money YoY. Significantly more than prior years. Does the UFT's new salary schedules renegotiate salaries?","shortMessageHtmlLink":"Half of all teachers employed during 2022 and 2023 fiscal years recei…"}},{"before":"376d93a8b88efabcb7918372273055f640b9168c","after":"1b84209907c5961ddcac48723afebe3f557a166a","ref":"refs/heads/main","pushedAt":"2023-11-27T06:49:40.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Anias-clo","name":"Chris Ortiz","path":"/Anias-clo","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/143330306?s=80&v=4"},"commit":{"message":"Decided to use salary schedules in analysis. UFT annual dues eat away at teachers salary increases. Need to more DOMAIN KNOWLEDGE about United Federation of Teachers. What are the benefits??????","shortMessageHtmlLink":"Decided to use salary schedules in analysis. UFT annual dues eat away…"}},{"before":"9d989a2912328957f608584df88ccae655328917","after":"376d93a8b88efabcb7918372273055f640b9168c","ref":"refs/heads/main","pushedAt":"2023-11-26T07:58:08.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Anias-clo","name":"Chris Ortiz","path":"/Anias-clo","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/143330306?s=80&v=4"},"commit":{"message":"Modified wrangle functions to cast columns to categories. Performed initial chi2 tests with expected results.","shortMessageHtmlLink":"Modified wrangle functions to cast columns to categories. Performed i…"}},{"before":"09f998ab106f78cc47794cdda5709b0b0f79b2c2","after":"9d989a2912328957f608584df88ccae655328917","ref":"refs/heads/main","pushedAt":"2023-11-25T05:26:58.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Anias-clo","name":"Chris Ortiz","path":"/Anias-clo","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/143330306?s=80&v=4"},"commit":{"message":"Removed outliers. Removed salary schedules. Not enough info to infer salary differentials. Removed Total Paid columns.","shortMessageHtmlLink":"Removed outliers. Removed salary schedules. Not enough info to infer …"}},{"before":"f4b3e651934c317661f9c007f8e2e24409a2ec2a","after":"09f998ab106f78cc47794cdda5709b0b0f79b2c2","ref":"refs/heads/main","pushedAt":"2023-11-24T08:55:13.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Anias-clo","name":"Chris Ortiz","path":"/Anias-clo","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/143330306?s=80&v=4"},"commit":{"message":"Uploading datasets with all employment statuses. EDA manana","shortMessageHtmlLink":"Uploading datasets with all employment statuses. EDA manana"}},{"before":"5718b49d6f68905903d5e3ceb4a941ba9c4a6e01","after":"f4b3e651934c317661f9c007f8e2e24409a2ec2a","ref":"refs/heads/main","pushedAt":"2023-11-24T08:37:01.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Anias-clo","name":"Chris Ortiz","path":"/Anias-clo","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/143330306?s=80&v=4"},"commit":{"message":"Created new features, new datasets, added salary schedules","shortMessageHtmlLink":"Created new features, new datasets, added salary schedules"}},{"before":"d4b04b1687f2af85ba323ba5d1ef4bc02f70c0c6","after":"5718b49d6f68905903d5e3ceb4a941ba9c4a6e01","ref":"refs/heads/main","pushedAt":"2023-11-16T23:11:46.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Anias-clo","name":"Chris Ortiz","path":"/Anias-clo","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/143330306?s=80&v=4"},"commit":{"message":"Finished data prep.","shortMessageHtmlLink":"Finished data prep."}},{"before":"d9c1ab577b83850b035f588c75a26377bcd9b3f6","after":"d4b04b1687f2af85ba323ba5d1ef4bc02f70c0c6","ref":"refs/heads/main","pushedAt":"2023-11-16T05:25:31.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"Anias-clo","name":"Chris Ortiz","path":"/Anias-clo","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/143330306?s=80&v=4"},"commit":{"message":"Created src file, prepared teachers payroll data, and starting to handle outliers.","shortMessageHtmlLink":"Created src file, prepared teachers payroll data, and starting to han…"}}],"hasNextPage":true,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"djE6ks8AAAAEXrI45AA","startCursor":null,"endCursor":null}},"title":"Activity · Anias-clo/Teacher_Payroll_Analysis"}