User:Ideophagous
Jump to navigation
Jump to search
Babel user information | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||
Users by language |
Operator of DarijaBot
Some plans
[edit]- Adjusting Moroccan communes and localities, so much mess there. Queries:
- Scrape some Morocco related public lists and databases, clean the data and add the items to Wikidata with Quickstatements (or with a bot task):
- This database of Moroccan university professors and researchers
- List of Moroccan Parliament members
- Fill the fish base list with Moroccan Darija names (I have it locally as CSV), and similarly enter them on Wikidata
- Find other resources to scrape
Shortcuts
[edit]- Get list of non-ID properties by type of item, ordered by percentage of use (could help with creating automatic infoboxes on Wikipedia): https://w.wiki/5t8y
- List properties: https://w.wiki/5vS8 and https://w.wiki/6G$4
- Moroccan newspapers: https://w.wiki/5vSV
- Special:MergeItems
For 2023 contest
[edit]- Science and technology in Morocco:
- People https://w.wiki/6JML
- Research institutes https://w.wiki/6ME$
Moroccan territorial entities
[edit]- Verify if Moroccan geocodes are correct (at least in comparison to the province) for urban communes: https://w.wiki/7Hv9
- List of Moroccan communes that have two values or more for P131 (that are a province, adding the circle is OK): https://w.wiki/8PdG (should be 0, last check: 05-12-2023)
- List of rural communes in a given province: https://w.wiki/7UfA
- List of communes without picture (or Commons category) on Wikidata: https://w.wiki/8BeE
Finnish books
[edit]- Written works: https://w.wiki/A27R
- Editions: https://w.wiki/A27U
Other useful queries
[edit]Full Queries
[edit]List of Moroccan women
[edit]SELECT ?person ?personLabel
(GROUP_CONCAT(DISTINCT ?occupationLabel; separator = ", ") AS ?occupations)
(SAMPLE(?birthYearValue) AS ?birthYear)
(SAMPLE(?deathYearValue) AS ?deathYear)
(GROUP_CONCAT(DISTINCT ?website; separator = " , ") AS ?websites)
(GROUP_CONCAT(DISTINCT ?facebook; separator = " , ") AS ?facebookPages)
(GROUP_CONCAT(DISTINCT ?instagram; separator = " , ") AS ?instagramAccounts)
(GROUP_CONCAT(DISTINCT ?tiktok; separator = " , ") AS ?tiktokAccounts)
(GROUP_CONCAT(DISTINCT ?youtube; separator = " , ") AS ?youtubeChannels)
WHERE
{
?person wdt:P31 wd:Q5.
?person wdt:P27 wd:Q1028.
?person wdt:P21 wd:Q6581072.
?person wdt:P106 ?occupation.
OPTIONAL { ?person wdt:P569 ?birthDate. }
OPTIONAL { ?person wdt:P570 ?deathDate. }
BIND(YEAR(?birthDate) AS ?birthYearValue)
BIND(YEAR(?deathDate) AS ?deathYearValue)
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,fr,ar,ary,shi,zgh". }
?occupation rdfs:label ?occupationLabel FILTER (LANG(?occupationLabel) = "en")
OPTIONAL { ?person wdt:P856 ?website. }
OPTIONAL { ?person wdt:P2013 ?facebook. }
OPTIONAL { ?person wdt:P2003 ?instagram. }
OPTIONAL { ?person wdt:P7085 ?tiktok. }
OPTIONAL { ?person wdt:P2397 ?youtube. }
}
GROUP BY ?person ?personLabel
ORDER BY ?personLabel