LinguaLibre
Difference between revisions of "Records"
(13 intermediate revisions by 3 users not shown) | |||
Line 1: | Line 1: | ||
− | < | + | <languages/> |
− | + | <translate><!--T:1--> | |
− | + | For performance reasons, the maximum number of audio recording shown at a time is 1000. This current page will be enhanced in the future. You can [https://lingualibre.fr/datasets/ download datasets here]. | |
− | <query record=" | + | <!--T:2--> |
− | select distinct ?record ?recordLabel ?locutorLabel (if( ?language = entity:Q4, '???', ?languageLabel ) as ?langLabel) (if( ?languageLevel = entity:Q5 || !BOUND(?languageLevel), '???', ?languageLevelLabel ) as ?levelLabel) | + | <query _pagination="100" record="Item" audio="Record" recordLabel="Transcription" locutorLabel="Speaker" langLabel="Language" levelLabel="Language level"> |
+ | select distinct ?record ?audio ?recordLabel ?locutorLabel (if( ?language = entity:Q4, '???', ?languageLabel ) as ?langLabel) (if( ?languageLevel = entity:Q5 || !BOUND(?languageLevel), '???', ?languageLevelLabel ) as ?levelLabel) | ||
where { | where { | ||
?record prop:P2 entity:Q2 . | ?record prop:P2 entity:Q2 . | ||
?record prop:P5 ?locutor . | ?record prop:P5 ?locutor . | ||
+ | ?record prop:P3 ?audio . | ||
#extra:{"type": "wikibase-item", "filter":"Q3", "label": "P5", "multiple": true} ?record prop:P5 entity:[EXTRA] . | #extra:{"type": "wikibase-item", "filter":"Q3", "label": "P5", "multiple": true} ?record prop:P5 entity:[EXTRA] . | ||
?record prop:P4 ?lang . | ?record prop:P4 ?lang . | ||
#extra:{"type": "wikibase-item", "filter":"Q4", "label": "P4", "multiple": true} ?record prop:P4 entity:[EXTRA] . | #extra:{"type": "wikibase-item", "filter":"Q4", "label": "P4", "multiple": true} ?record prop:P4 entity:[EXTRA] . | ||
BIND( IF( isBLANK(?lang), entity:Q4, ?lang ) as ?language ). | BIND( IF( isBLANK(?lang), entity:Q4, ?lang ) as ?language ). | ||
− | |||
− | |||
OPTIONAL { | OPTIONAL { | ||
− | |||
?locutor llp:P4 ?languageStatement . | ?locutor llp:P4 ?languageStatement . | ||
?languageStatement llv:P4 ?language . | ?languageStatement llv:P4 ?language . | ||
− | ?languageStatement llq: | + | ?languageStatement llq:P16 ?level . |
− | #extra:{"type": "wikibase-item", "filter":"Q5", "label": " | + | #extra:{"type": "wikibase-item", "filter":"Q5", "label": "P16", "multiple": true} ?languageStatement llq:P16 entity:[EXTRA] . |
BIND( IF( isBLANK(?level), entity:Q5, ?level ) as ?languageLevel ). | BIND( IF( isBLANK(?level), entity:Q5, ?level ) as ?languageLevel ). | ||
} | } | ||
Line 25: | Line 24: | ||
?record prop:P7 ?transcription. | ?record prop:P7 ?transcription. | ||
#extra:{"type": "string", "label": "P7"} filter contains(lcase(?transcription), lcase('[EXTRA]')). | #extra:{"type": "string", "label": "P7"} filter contains(lcase(?transcription), lcase('[EXTRA]')). | ||
− | |||
SERVICE wikibase:label { | SERVICE wikibase:label { | ||
bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . | bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . | ||
Line 33: | Line 31: | ||
?language rdfs:label ?languageLabel. | ?language rdfs:label ?languageLabel. | ||
} | } | ||
− | } ORDER BY ?recordLabel | + | } ORDER BY ?recordLabel LIMIT 1000 |
− | </query> | + | </query></translate> |
Revision as of 17:20, 21 February 2020
For performance reasons, the maximum number of audio recording shown at a time is 1000. This current page will be enhanced in the future. You can download datasets here.