{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":80254295,"defaultBranch":"main","name":"movement-metrics","ownerLogin":"wikimedia-research","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2017-01-27T23:19:07.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/10491092?v=4","public":true,"private":false,"isOrgOwned":true},"refInfo":{"name":"","listCacheKey":"v0:1712685815.0","currentOid":""},"activityList":{"items":[{"before":"8382d66bad09324429c1069d2c0f5351a31949a8","after":"94472b6a453f36d2d3bf34560588cd86536932ac","ref":"refs/heads/main","pushedAt":"2024-04-10T00:41:32.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"nshahquinn","name":"Neil Shah-Quinn","path":"/nshahquinn","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/4515586?s=80&v=4"},"commit":{"message":"Point to repo's new location\n\nBug: T362131","shortMessageHtmlLink":"Point to repo's new location"}},{"before":"e72c3a2067aec2436845a777338334e6fadd29b0","after":null,"ref":"refs/heads/prune_charts_and_data","pushedAt":"2024-04-09T18:03:35.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"nshahquinn","name":"Neil Shah-Quinn","path":"/nshahquinn","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/4515586?s=80&v=4"}},{"before":"c56a6a058a9a39241cd708d5e023b8eabe114b41","after":"8382d66bad09324429c1069d2c0f5351a31949a8","ref":"refs/heads/main","pushedAt":"2024-04-09T16:24:47.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"hghani-ctr","name":null,"path":"/hghani-ctr","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/145786695?s=80&v=4"},"commit":{"message":"Remove unnecessary metrics and charts and make all Wikicharts code work (#9)\n\n* Remove unnecessary metrics\r\n  * All mobile-heavy metrics\r\n  * All Global North/Global South metrics\r\n  * Unclassed and unknown regional unique devices\r\n  * Total, non-anonymous, other non-bot, upload, and Wikidata edits\r\n* Remove unnecessary charts\r\n  * Combined new and returning editors\r\n  * Unknown and unclassed regional unique devices and active editors\r\n  * Regional active editors transformed timeseries\r\n  * 2022 quality articles maps\r\n  * User pageviews\r\n  * Growth of content items\r\n* Improve regional active editor query\r\n* Streamline content metrics query and cleanup function\r\n* Make Wikicharts mapping code run again and heavily improve it\r\n\r\nBug: T359692\r\nBug: T359695\r\nBug: T362130","shortMessageHtmlLink":"Remove unnecessary metrics and charts and make all Wikicharts code wo…"}},{"before":"f37a9a5f86b3a9488d78690414958a5d98ba1caf","after":"e72c3a2067aec2436845a777338334e6fadd29b0","ref":"refs/heads/prune_charts_and_data","pushedAt":"2024-04-09T02:36:46.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"nshahquinn","name":"Neil Shah-Quinn","path":"/nshahquinn","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/4515586?s=80&v=4"},"commit":{"message":"Remove unnecessary metrics and charts and make all Wikicharts code work\n\n* Remove unnecessary metrics\n  * All mobile-heavy metrics\n  * All Global North/Global South metrics\n  * Unclassed and unknown regional unique devices\n  * Total, non-anonymous, other non-bot, upload, and Wikidata edits\n* Remove unnecessary charts\n  * Combined new and returning editors\n  * Unknown and unclassed regional unique devices and active editors\n  * Regional active editors transformed timeseries\n  * 2022 quality articles maps\n  * User pageviews\n  * Growth of content items\n* Improve regional active editor query\n* Streamline content metrics query and cleanup function\n* Make Wikicharts mapping code run again and heavily improve it\n\nBug: T359692\nBug: T359695\nBug: T362130","shortMessageHtmlLink":"Remove unnecessary metrics and charts and make all Wikicharts code work"}},{"before":"8d7b1150993b230352bae78279f5319d798b192d","after":"f37a9a5f86b3a9488d78690414958a5d98ba1caf","ref":"refs/heads/prune_charts_and_data","pushedAt":"2024-04-09T02:34:51.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"nshahquinn","name":"Neil Shah-Quinn","path":"/nshahquinn","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/4515586?s=80&v=4"},"commit":{"message":"Remove unnecessary metrics and charts and make all Wikicharts code work\n\n* Remove unnecessary metrics\n  * All mobile-heavy metrics\n  * All Global North/Global South metrics\n  * Unclassed and unknown regional unique devices\n  * Total, non-anonymous, other non-bot, upload, and Wikidata edits\n* Remove unnecessary charts\n  * Combined new and returning editors\n  * Unknown and unclassed regional unique devices and active editors\n  * Regional active editors transformed timeseries\n  * 2022 quality articles maps\n  * User pageviews\n  * Growth of content items\n* Improve regional active editor query\n* Streamline content metrics query and cleanup function\n* Make Wikicharts mapping code run again and heavily improve it\n\nBug: T359692\nBug: T359695\nBug: T362130","shortMessageHtmlLink":"Remove unnecessary metrics and charts and make all Wikicharts code work"}},{"before":"0aef7920dff2454cb757654d2d4e61e3678d5da8","after":"8d7b1150993b230352bae78279f5319d798b192d","ref":"refs/heads/prune_charts_and_data","pushedAt":"2024-04-09T02:30:21.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"nshahquinn","name":"Neil Shah-Quinn","path":"/nshahquinn","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/4515586?s=80&v=4"},"commit":{"message":"Remove unnecessary metrics and charts and ensure all Wikicharts code works\n\n* Remove unnecessary metrics\n  * All mobile-heavy metrics\n  * All Global North/Global South metrics\n  * Unclassed and unknown regional unique devices\n  * Total, non-anonymous, other non-bot, upload, and Wikidata edits\n* Remove unnecessary charts\n  * Combined new and returning editors\n  * Unknown and unclassed regional unique devices and active editors\n  * Regional active editors transformed timeseries\n  * 2022 quality articles maps\n  * User pageviews\n  * Growth of content items\n* Improve regional active editor query\n* Streamline content metrics query and cleanup function\n* Make Wikicharts mapping code run again and heavily improve it\n\nBug: T359692\nBug: T359695\nBug: T362130","shortMessageHtmlLink":"Remove unnecessary metrics and charts and ensure all Wikicharts code …"}},{"before":null,"after":"0aef7920dff2454cb757654d2d4e61e3678d5da8","ref":"refs/heads/prune_charts_and_data","pushedAt":"2024-04-09T02:25:30.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"nshahquinn","name":"Neil Shah-Quinn","path":"/nshahquinn","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/4515586?s=80&v=4"},"commit":{"message":"Remove unnecessary metrics and charts and make all remaining Wikicharts code work\n\n* Remove unnecessary metrics\n  * All mobile-heavy metrics\n  * All Global North/Global South metrics\n  * Unclassed and unknown regional unique devices\n  * Total, non-anonymous, other non-bot, upload, and Wikidata edits\n* Remove unnecessary charts\n  * Combined new and returning editors\n  * Unknown and unclassed regional unique devices and active editors\n  * Regional active editors transformed timeseries\n  * 2022 quality articles maps\n  * User pageviews\n  * Growth of content items\n* Improve regional active editor query\n* Streamline content metrics query and cleanup function\n* Make Wikicharts mapping code run again and heavily improve it\n\nBug: T359692\nBug: T359695\nBug: T362130","shortMessageHtmlLink":"Remove unnecessary metrics and charts and make all remaining Wikichar…"}},{"before":"bd9effe5e5e47ee42d6ef4ae07c213e2849cc822","after":null,"ref":"refs/heads/wikicharts_data_cleanup","pushedAt":"2024-03-27T00:37:52.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"nshahquinn","name":"Neil Shah-Quinn","path":"/nshahquinn","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/4515586?s=80&v=4"}},{"before":"3fc50f1926612e8e33b99ccbb8423d3e239f465a","after":"c56a6a058a9a39241cd708d5e023b8eabe114b41","ref":"refs/heads/main","pushedAt":"2024-03-27T00:28:19.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"hghani-ctr","name":null,"path":"/hghani-ctr","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/145786695?s=80&v=4"},"commit":{"message":"Wikicharts: Clean up static data files (#8)\n\n* Removed 9 unused static data files\r\n* Corrected the chart title and static data file path in pageviews_useronly.ipynb\r\n\r\nBug: T359695","shortMessageHtmlLink":"Wikicharts: Clean up static data files (<a class=\"issue-link js-issue-link\" data-error-text=\"Failed to load title\" data-id=\"2206812982\" data-permission-text=\"Title is private\" data-url=\"https://github.com/wikimedia-research/movement-metrics/issues/8\" data-hovercard-type=\"pull_request\" data-hovercard-url=\"/wikimedia-research/movement-metrics/pull/8/hovercard\" href=\"https://github.com/wikimedia-research/movement-metrics/pull/8\">#8</a>)"}},{"before":null,"after":"bd9effe5e5e47ee42d6ef4ae07c213e2849cc822","ref":"refs/heads/wikicharts_data_cleanup","pushedAt":"2024-03-25T22:12:04.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"nshahquinn","name":"Neil Shah-Quinn","path":"/nshahquinn","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/4515586?s=80&v=4"},"commit":{"message":"Wikicharts: Clean up static data files\n\n* Removed 9 unused static data files\n* Corrected the chart title and static data file path in pageviews_useronly.ipynb\n\nBug: T359695","shortMessageHtmlLink":"Wikicharts: Clean up static data files"}},{"before":"fc8110570ab93373ed5e6b11a18ce3e5dc0db912","after":null,"ref":"refs/heads/feb2024metrics","pushedAt":"2024-03-19T00:11:59.000Z","pushType":"branch_deletion","commitsCount":0,"pusher":{"login":"nshahquinn","name":"Neil Shah-Quinn","path":"/nshahquinn","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/4515586?s=80&v=4"}},{"before":"ae8426947383ac61ff327542d67ca8318a589a03","after":"3fc50f1926612e8e33b99ccbb8423d3e239f465a","ref":"refs/heads/main","pushedAt":"2024-03-19T00:11:51.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"nshahquinn","name":"Neil Shah-Quinn","path":"/nshahquinn","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/4515586?s=80&v=4"},"commit":{"message":"Recalculate active editor metrics for all history\n\nRecalculate active_editors, returning_active_editors, and new_active_editors columns for all history using the new version of active_editors.sql, in order to fix a classification bug. \r\n\r\nBug: T358684\r\nCo-authored-by: Hamid Ghani <hghani@stat1008.eqiad.wmnet>","shortMessageHtmlLink":"Recalculate active editor metrics for all history"}},{"before":"69d233632c5b43b90a67c443b17caf431ab7abaf","after":"ae8426947383ac61ff327542d67ca8318a589a03","ref":"refs/heads/main","pushedAt":"2024-03-19T00:06:21.000Z","pushType":"force_push","commitsCount":0,"pusher":{"login":"nshahquinn","name":"Neil Shah-Quinn","path":"/nshahquinn","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/4515586?s=80&v=4"},"commit":{"message":"Improve readability of active_editors.sql syntax\n\n-Replace sum(cast(x as int)) with count_if to streamline readability. \r\n-Correct e.MONTH to e.month\r\n-Keep only one instance of anonymous and bot filtering 'where' clause to improve readability.","shortMessageHtmlLink":"Improve readability of active_editors.sql syntax"}},{"before":null,"after":"2c3b076198fc770ae713d1ec69b7daa4c2232e70","ref":"refs/heads/revert-6-feb2024metrics","pushedAt":"2024-03-19T00:03:47.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"nshahquinn","name":"Neil Shah-Quinn","path":"/nshahquinn","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/4515586?s=80&v=4"},"commit":{"message":"Revert \"Update February 2024 metrics\"\n\nThis reverts commit 69d233632c5b43b90a67c443b17caf431ab7abaf.","shortMessageHtmlLink":"Revert \"Update February 2024 metrics\""}},{"before":"ae8426947383ac61ff327542d67ca8318a589a03","after":"69d233632c5b43b90a67c443b17caf431ab7abaf","ref":"refs/heads/main","pushedAt":"2024-03-19T00:03:42.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"nshahquinn","name":"Neil Shah-Quinn","path":"/nshahquinn","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/4515586?s=80&v=4"},"commit":{"message":"Update February 2024 metrics\n\nBackfill entire history of editing_metrics.tsv for returning_active_editors, active_editors, and new_active_editors columns with corrected values derived from the updated active_editors.sql query. Bug:T358684","shortMessageHtmlLink":"Update February 2024 metrics"}},{"before":null,"after":"fc8110570ab93373ed5e6b11a18ce3e5dc0db912","ref":"refs/heads/feb2024metrics","pushedAt":"2024-03-18T17:21:46.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"hghani-ctr","name":null,"path":"/hghani-ctr","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/145786695?s=80&v=4"},"commit":{"message":"Update February 2024 metrics\n\nBackfill entire history of editing_metrics.tsv for returning_active_editors, active_editors, and new_active_editors columns with corrected values derived from the updated active_editors.sql query. Bug:T358684","shortMessageHtmlLink":"Update February 2024 metrics"}},{"before":"b084e526feb0cadd864e0285171e1cf8c4e97a42","after":"ae8426947383ac61ff327542d67ca8318a589a03","ref":"refs/heads/main","pushedAt":"2024-03-11T20:52:09.000Z","pushType":"pr_merge","commitsCount":1,"pusher":{"login":"nshahquinn","name":"Neil Shah-Quinn","path":"/nshahquinn","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/4515586?s=80&v=4"},"commit":{"message":"Improve readability of active_editors.sql syntax\n\n-Replace sum(cast(x as int)) with count_if to streamline readability. \r\n-Correct e.MONTH to e.month\r\n-Keep only one instance of anonymous and bot filtering 'where' clause to improve readability.","shortMessageHtmlLink":"Improve readability of active_editors.sql syntax"}},{"before":"b084e526feb0cadd864e0285171e1cf8c4e97a42","after":"b00beaa343b6b7a6a1c62c2a469ed7cab7ec903f","ref":"refs/heads/hghani-active_editors_sql_edit","pushedAt":"2024-03-11T20:26:08.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"hghani-ctr","name":null,"path":"/hghani-ctr","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/145786695?s=80&v=4"},"commit":{"message":"Improve readability of active_editors.sql syntax\n\n-Replace sum(cast(x as int)) with count_if to streamline readability. \r\n-Correct e.MONTH to e.month\r\n-Keep only one instance of anonymous and bot filtering 'where' clause to improve readability.","shortMessageHtmlLink":"Improve readability of active_editors.sql syntax"}},{"before":null,"after":"b084e526feb0cadd864e0285171e1cf8c4e97a42","ref":"refs/heads/hghani-active_editors_sql_edit","pushedAt":"2024-03-11T20:26:07.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"hghani-ctr","name":null,"path":"/hghani-ctr","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/145786695?s=80&v=4"},"commit":{"message":"Updated February 2023 metrics","shortMessageHtmlLink":"Updated February 2023 metrics"}},{"before":"b5d6e22355f9f6d053c079981fcf60137edb06dd","after":"b084e526feb0cadd864e0285171e1cf8c4e97a42","ref":"refs/heads/main","pushedAt":"2024-03-07T23:38:56.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"hghani-ctr","name":null,"path":"/hghani-ctr","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/145786695?s=80&v=4"},"commit":{"message":"Updated February 2023 metrics","shortMessageHtmlLink":"Updated February 2023 metrics"}},{"before":"918e4cdfa36013e928406651cb2bb1f4d967991b","after":"b5d6e22355f9f6d053c079981fcf60137edb06dd","ref":"refs/heads/main","pushedAt":"2024-03-07T23:33:17.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"hghani-ctr","name":null,"path":"/hghani-ctr","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/145786695?s=80&v=4"},"commit":{"message":"Updated February 2023 metrics","shortMessageHtmlLink":"Updated February 2023 metrics"}},{"before":"e6243fd8f1ff287d53142f7ce4b81f8f0e2370e4","after":"918e4cdfa36013e928406651cb2bb1f4d967991b","ref":"refs/heads/main","pushedAt":"2024-03-07T23:32:03.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"hghani-ctr","name":null,"path":"/hghani-ctr","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/145786695?s=80&v=4"},"commit":{"message":"Updated February 2023 metrics","shortMessageHtmlLink":"Updated February 2023 metrics"}},{"before":"3b36869fd14f5c53df392744bb7f9fe4ebdebc9b","after":"e6243fd8f1ff287d53142f7ce4b81f8f0e2370e4","ref":"refs/heads/main","pushedAt":"2024-03-07T23:31:23.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"hghani-ctr","name":null,"path":"/hghani-ctr","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/145786695?s=80&v=4"},"commit":{"message":"Updated February 2024 metrics\n\nadded dynamic sizing for labels and annotation","shortMessageHtmlLink":"Updated February 2024 metrics"}},{"before":"e5e99ecd11597d7a2f537fb243b0ad79e6d8d7f2","after":"3b36869fd14f5c53df392744bb7f9fe4ebdebc9b","ref":"refs/heads/main","pushedAt":"2024-03-07T19:04:22.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"janstee","name":null,"path":"/janstee","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/9000701?s=80&v=4"},"commit":{"message":"Update February 2024 Metrics","shortMessageHtmlLink":"Update February 2024 Metrics"}},{"before":"da912be62abfca7ae65f158858ea6238ce307507","after":"e5e99ecd11597d7a2f537fb243b0ad79e6d8d7f2","ref":"refs/heads/main","pushedAt":"2024-03-07T16:54:59.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"hghani-ctr","name":null,"path":"/hghani-ctr","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/145786695?s=80&v=4"},"commit":{"message":"Updated query: T358684","shortMessageHtmlLink":"Updated query: T358684"}},{"before":"ecb15bdac3db5f137ab3a722638c0af748331fed","after":"da912be62abfca7ae65f158858ea6238ce307507","ref":"refs/heads/main","pushedAt":"2024-03-05T20:35:52.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"hghani-ctr","name":null,"path":"/hghani-ctr","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/145786695?s=80&v=4"},"commit":{"message":"Split chart into two\n\nSplit returning editors and new active editors into separate charts to reflect variability in new active editors.","shortMessageHtmlLink":"Split chart into two"}},{"before":"1b14988f81798c2830ad73cb5d1faacdcc5454a3","after":"ecb15bdac3db5f137ab3a722638c0af748331fed","ref":"refs/heads/main","pushedAt":"2024-03-05T01:51:30.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"nshahquinn","name":"Neil Shah-Quinn","path":"/nshahquinn","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/4515586?s=80&v=4"},"commit":{"message":"Update instructions in readme\n\nBug: T358730","shortMessageHtmlLink":"Update instructions in readme"}},{"before":"9620f18382d1e003a41d5baccb9266712e183857","after":"1b14988f81798c2830ad73cb5d1faacdcc5454a3","ref":"refs/heads/main","pushedAt":"2024-02-28T18:10:44.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"janstee","name":null,"path":"/janstee","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/9000701?s=80&v=4"},"commit":{"message":"Update January 2024 Metrics","shortMessageHtmlLink":"Update January 2024 Metrics"}},{"before":"8d3039160f1486a965ae0d91311d77f57658e220","after":"9620f18382d1e003a41d5baccb9266712e183857","ref":"refs/heads/main","pushedAt":"2024-02-13T17:19:47.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"janstee","name":null,"path":"/janstee","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/9000701?s=80&v=4"},"commit":{"message":"Updated January 2024 Metrics","shortMessageHtmlLink":"Updated January 2024 Metrics"}},{"before":"c8131395fc83d8decf7c5a38e1dc95b554c515b2","after":"8d3039160f1486a965ae0d91311d77f57658e220","ref":"refs/heads/main","pushedAt":"2024-02-13T16:25:57.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"hghani-ctr","name":null,"path":"/hghani-ctr","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/145786695?s=80&v=4"},"commit":{"message":"Updated variable names\n\nadded underscores(_) to y variables","shortMessageHtmlLink":"Updated variable names"}}],"hasNextPage":true,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"djE6ks8AAAAELIr0dQA","startCursor":null,"endCursor":null}},"title":"Activity · wikimedia-research/movement-metrics"}