User

Difference between revisions of "Yug/Gallery"

< User:Yug
 
(10 intermediate revisions by the same user not shown)
Line 9: Line 9:
 
   ?speaker prop:P2 entity:Q3 .
 
   ?speaker prop:P2 entity:Q3 .
 
   FILTER NOT EXISTS { ?speaker prop:P8 ?gender }
 
   FILTER NOT EXISTS { ?speaker prop:P8 ?gender }
−
   ?audio prop:P5 ?speaker .  # Filter: P5 'speaker' is Q445757 'SangeetaRH‎'
+
   ?audio prop:P5 ?speaker .  # Filter: P5 'speaker'
−
   ?audio prop:P4 ?language .  # Filter: P4 'language' is Q34 'Marathi'
+
   ?audio prop:P4 ?language .  # Filter: P4 'language'
 
   # Add labels
 
   # Add labels
 
   SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en"}  
 
   SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en"}  
Line 23: Line 23:
 
   ?speaker prop:P2 entity:Q3 .
 
   ?speaker prop:P2 entity:Q3 .
 
   FILTER NOT EXISTS { ?speaker prop:P8 ?gender }
 
   FILTER NOT EXISTS { ?speaker prop:P8 ?gender }
−
   ?audio prop:P5 ?speaker .  # Filter: P5 'speaker' is Q445757 'SangeetaRH‎'
+
   ?audio prop:P5 ?speaker .  # Filter: P5 'speaker'
 
   ?audio prop:P4 ?language .  # Filter: P4 'language' is Q34 'Marathi'
 
   ?audio prop:P4 ?language .  # Filter: P4 'language' is Q34 'Marathi'
 
   # Add labels
 
   # Add labels
Line 30: Line 30:
 
GROUP BY ?speaker ?speakerLabel ?genderLabel ?language ?languageLabel  # Sorting first groups per language and speaker
 
GROUP BY ?speaker ?speakerLabel ?genderLabel ?language ?languageLabel  # Sorting first groups per language and speaker
 
ORDER BY DESC (?audio)
 
ORDER BY DESC (?audio)
 +
</query>
 +
|}
 +
 +
=== Is Sex or Gender ([[Q7]]) → List existing sexes or genders ===
 +
''This query is going to be DEPRECATED as the queried data will no longer be available.''
 +
{| style="width:100%"
 +
|- style="vertical-align:top;"
 +
|style="padding: 0 3em;width:60%"|
 +
<syntaxhighlight lang="sparql">
 +
SELECT ?item ?itemLabel
 +
WHERE {
 +
  ?item prop:P2 entity:Q7    # Filter: P2 'instance of' is Q7 'sex or gender'.
 +
  # Add labels to each variable used.
 +
  SERVICE wikibase:label {
 +
    bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
 +
  }
 +
}
 +
</syntaxhighlight>
 +
|
 +
<query _pagination="10" item="Property" itemLabel="Values">
 +
SELECT ?item ?itemLabel
 +
WHERE {
 +
  ?item prop:P2 entity:Q7    # Filter: P2 'instance of' is Q7 'sex or gender'.
 +
  # Add labels to each variable used.
 +
  SERVICE wikibase:label {
 +
    bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
 +
  }
 +
}
 
</query>
 
</query>
 
|}
 
|}
Line 73: Line 101:
 
|}
 
|}
  
−
=== Speaker Qid (Q445757) + Language LL Qid (Q34) → List records ===
+
=== Speaker Qid + Language LL Qid → List records ===
 
''This query is going to be DEPRECATED as the queried data will no longer be available.''
 
''This query is going to be DEPRECATED as the queried data will no longer be available.''
 
{| style="width:100%"  
 
{| style="width:100%"  
Line 79: Line 107:
 
|style="padding: 0 3em;width:60%"|
 
|style="padding: 0 3em;width:60%"|
 
<syntaxhighlight lang="sparql">
 
<syntaxhighlight lang="sparql">
−
SELECT ?audio ?audioLabel
+
SELECT ?speakerLabel ?languageLabel ?audioLabel ?filename
 
WHERE {
 
WHERE {
−
   ?audio prop:P5 entity:Q445757 .  # Filter: P5 Speaker is Q445757 User:SangeetaRH‎
+
  VALUES ?speakers { entity:Q214043 entity:Q43323 }
−
   ?audio prop:P4 entity:Q34 .  # Filter: P4 language is Q34 Marathi
+
   ?audio prop:P5 ?speakers .  # Filter: P5 Speaker
 +
  ?audio prop:P5 ?speaker .  # Filter: P5 Speaker
 +
   ?audio prop:P4 ?language .  # Filter: P4 language
 +
  ?audio prop:P3 ?filename .
 +
  # ?speaker prop:P8 ?gender
 
   # Add labels
 
   # Add labels
 
   SERVICE wikibase:label {
 
   SERVICE wikibase:label {
Line 88: Line 120:
 
   }  
 
   }  
 
}
 
}
−
 
 
</syntaxhighlight>
 
</syntaxhighlight>
 
|
 
|
 
<query _pagination="10" item="Property" itemLabel="Values">
 
<query _pagination="10" item="Property" itemLabel="Values">
−
SELECT ?audio ?audioLabel
+
SELECT ?speakerLabel ?languageLabel ?audioLabel ?filename
 
WHERE {
 
WHERE {
−
   ?audio prop:P5 entity:Q445757 .  # Filter: P5 Speaker is Q445757 User:SangeetaRH‎
+
  VALUES ?speakers { entity:Q214043 entity:Q43323 entity:Q405732 entity:Q5018 }
−
   ?audio prop:P4 entity:Q34 .  # Filter: P4 language is Q34 Marathi
+
   ?audio prop:P5 ?speakers .  # Filter: P5 Speaker
 +
  ?audio prop:P5 ?speaker .  # Filter: P5 Speaker
 +
   ?audio prop:P4 ?language .  # Filter: P4 language
 +
  ?audio prop:P3 ?filename .
 +
  # ?speaker prop:P8 ?gender
 
   # Add labels
 
   # Add labels
 
   SERVICE wikibase:label {
 
   SERVICE wikibase:label {

Latest revision as of 08:33, 11 August 2022

✅ Speakers → missing gender value

This query returns speakers who have missing gender value. See also list of genders.
SELECT ?speaker ?speakerLabel ?gender ?language ?languageLabel (COUNT(?audio) AS ?audio)
WHERE {
  ?speaker prop:P2 entity:Q3 .
  FILTER NOT EXISTS { ?speaker prop:P8 ?gender }
  ?audio prop:P5 ?speaker .   # Filter: P5 'speaker'
  ?audio prop:P4 ?language .  # Filter: P4 'language'
  # Add labels
  SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en"} 
}
GROUP BY ?speaker ?speakerLabel ?genderLabel ?language ?languageLabel  # Sorting first groups per language and speaker
ORDER BY DESC (?audio)
... Loading ...

Is Sex or Gender (sex or gender (Q7)) → List existing sexes or genders

This query is going to be DEPRECATED as the queried data will no longer be available. 

SELECT ?item ?itemLabel
WHERE {
  ?item prop:P2 entity:Q7    # Filter: P2 'instance of' is Q7 'sex or gender'.
  # Add labels to each variable used.
  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
  } 
}
... Loading ...

Language LL Qid → List speakers

This query is going to be DEPRECATED as the queried data will no longer be available. 

SELECT ?language ?speaker ?speakerLabel ?genderLabel (COUNT(?audio) AS ?audio)
WHERE {
  VALUES ?language { entity:Q150 }
  ?speaker prop:P2 entity:Q3 .  # P2 'instance of' is Q3 'speaker'
  ?speaker prop:P4 ?language .  # P4 'language'
  ?speaker prop:P8 ?gender .  # P8 'language'
  # Audios
  ?audio prop:P5 ?speaker .   # Filter: P5 'speaker'
  ?audio prop:P4 ?language .  # Filter: P4 'language'
  # Add labels
  SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en"} 
}
GROUP BY ?language ?speaker ?speakerLabel ?genderLabel
ORDER BY DESC (?audio)
... Loading ...

Speaker Qid + Language LL Qid → List records

This query is going to be DEPRECATED as the queried data will no longer be available. 

SELECT ?speakerLabel ?languageLabel ?audioLabel ?filename
WHERE {
  VALUES ?speakers { entity:Q214043 entity:Q43323 }
  ?audio prop:P5 ?speakers .   # Filter: P5 Speaker
  ?audio prop:P5 ?speaker .   # Filter: P5 Speaker
  ?audio prop:P4 ?language .   # Filter: P4 language
  ?audio prop:P3 ?filename . 
  # ?speaker prop:P8 ?gender
  # Add labels
  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .
  } 
}
... Loading ...

✅ Languages with media type video → written word (P7), url (P3) speakers (P5)

SELECT ?word ?filename ?speaker WHERE { 
  ?record prop:P4 entity:Q99628 . 
  ?record prop:P2 entity:Q2 . 
  ?record prop:P7 ?word . 
  ?record prop:P3 ?filename . 
  ?record prop:P5 ?speakerItem . 
  ?speakerItem rdfs:label 
  ?speaker filter ( lang( ?speaker ) = "en" ) . 
}
... Loading ...
Retrieved from "https://lingualibre.org/index.php?title=User:Yug/Gallery&oldid=782534"