User:MargaretRDonald/Queries requested
Query for Korean wikidata items with no English labels edit
Query to produce the following output edit
Query request
Starting from usernames and using the username, usercontributions and the global account I would like to be able to produce the following table at any given point in time via a query:
| User | UserContributions | DateFirstEdit | TotalEdits | n_enwikiEdits | n_CommonsEdits | n_WikidataEdits | GlobalAccount | DateLastEdit | DaysEditing | |
|---|---|---|---|---|---|---|---|---|---|---|
| MargaretRDonald | https://en.wikipedia.org/wiki/Special:Contributions/MargaretRDonald | 2017-12-07T00:00:00Z | 535225 | 33802 | 18443 | 472570 | https://en.wikipedia.org/wiki/Special:CentralAuth/MargaretRDonald | 2022-04-13T00:00:00Z | 1588 | |
| Oronsay | https://en.wikipedia.org/wiki/Special:Contributions/Oronsay | 2014-10-27T00:00:00Z | 238065 | 75561 | 6254 | 154229 | https://en.wikipedia.org/wiki/Special:CentralAuth/Oronsay | 2022-04-13T00:00:00Z | 2725 | |
| Cuyahoga44 | https://en.wikipedia.org/wiki/Special:Contributions/Cuyahoga44 | 2019-07-22T00:00:00Z | 11 | 11 | 0 | 0 | https://en.wikipedia.org/wiki/Special:CentralAuth/Cuyahoga44 | 2022-04-07T00:00:00Z | 990 | |
| DrPlantGenomics | https://en.wikipedia.org/wiki/Special:Contributions/DrPlantGenomics | 2019-07-25T00:00:00Z | 1272 | 1247 | 0 | 0 | https://en.wikipedia.org/wiki/Special:CentralAuth/DrPlantGenomics | 2022-04-13T00:00:00Z | 993 |
- Ada Lovelace Day 2021 User list found here A list of outreach dashboards
- WLE 2021 AU Contributors
- First Nations Editathon Outreach dashboard 2021 July 10: 11 am-2 pm event page
| id | Query link | Date | Duration | Dashboard | Event page/Suggested content | Organisation |
|---|---|---|---|---|---|---|
| 1 | Women in Science | 2021-09-17 | UNSW Women in Science | Women in Science edit-a-thon 2021 (WP) | UNSW | |
| 2 | Art and Feminism Vic | 2022-03-11 | Art and Feminism Vic | multiple links from dashboard | Yarra Libraries, the Women's Art Register, Parlour's WikiD, and WMAU | |
| 3 | The Record AMC | 2022-02-18 | The Record Australian Music Centre Editathon | AMC Edit-a-thon Suggested Content (GS) | WMAU, Australian Music Centre and the Australia Council for the Arts | |
| 4 | The Record Editathon Melbourne Music Month | 2021-12-11 | The Record Editathon Melbourne Music Month | 40 Melbourne Music Month Edit-a-thon Suggested Content (GS) | WMAU and the Australia Council for the Arts | |
| 5 | The Country Record - Australian Music Edit-a-thon | 2022-03-17 | The Country Record - Australian Music Edit-a-thon | - | WMAU, the Country Music Association of Australia and the Australia Council for the Arts | |
| 6 | Ada Lovelace Day 2021 | 2021-10-12 | 24 hours | Ada Lovelace Day Dashboard | ||
| 7 | First Nations Editathon | 2021-07-10 | 3 hours | Outreach dashboard | Event page | |
| 8 | Franklin Women 2022 | 2022-04-07 | 6 hours + ? followup | |||
| 9 | Art + Feminism 2020 QAGOMA | 2020-08-16 | 4 evenings over 4 weeks | outreach dashboard | ||
| 10 | Geelong on the Record | 2022-04-30 | 3.5 hours | Eventbrite Invitation |
| Abbreviation | Full name of program | Notes |
|---|---|---|
| FW2022 | Franklin Women 2022 | mostly members of Franklin Women network |
| Women in Science | University of New South Wales Women in Science |