User:MargaretRDonald/Queries requested

Query for Korean wikidata items with no English labels

edit

Query request

  1. Ordered by sitelink results
  2. Country of citizenship Results
  3. modified to give instance of results
  4. No property limitations (100 results)

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
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