View source for S351.03 nl

{{DISPLAYTITLE:S351.03 - Criminele statistieken van België}}

{{#sparql:
PREFIX wd: <http://external-wikibase-statbel-wikibase/entity/>
PREFIX wdt: <http://external-wikibase-statbel-wikibase/prop/direct/>
PREFIX p: <http://external-wikibase-statbel-wikibase/prop/>
PREFIX ps: <http://external-wikibase-statbel-wikibase/prop/statement/>
PREFIX pq: <http://external-wikibase-statbel-wikibase/prop/qualifier/>
SELECT ?DatasetLabel ?TaalLabel ?JaarLabel ?NummerLabel ?GrootteLabel ?Link ?OpmerkingLabel
WHERE
{
     ?Dataset wdt:P1 wd:Q2624 .
     ?Dataset wdt:P299 wd:Q11930 .
     ?Dataset wdt:P303 ?Jaar .  
     ?Dataset wdt:P311 ?Nummer .
     ?Dataset wdt:P305 ?Dist .
     OPTIONAL {?Dataset wdt:P56 ?Opmerking .}
     OPTIONAL {?Dist wdt:P310 ?LinkNL . }
     BIND(STRLEN(str(?LinkNL)) as ?Iets) .
     BIND( SUBSTR(str( ?LinkNL), 1,?Iets-4 ) as ?IetsAnders) .
     BIND( CONCAT( "<a target=", '"', "_blank ",'"', "href=",'"',?IetsAnders,".pdf",'"',">",?IetsAnders,".pdf </a>" ) as ?Samen) .
     BIND(IRI(REPLACE(?Samen, '^(.+)$', ?Samen)) AS ?Link) .
     ?Dist wdt:P308 ?Code .
     ?Dist wdt:P307  ?Grootte .
     ?Dist wdt:P54  ?Taal .
     SERVICE wikibase:label { bd:serviceParam wikibase:language "nl". }
}
ORDER BY ASC(?JaarLabel) ASC(?Nummer)
| endpoint = https://wdqs-new-wikibase-statbel-external.aks-prod.internal.economie.fgov.be/proxy/wdqs/bigdata/namespace/wdq/sparql |log=2 |headers=Naam,Taal,Jaar,Nummer,Grootte bestand,Link,Opmerking}}

[[Category:S3 - Statistische gegevens - Samenleving]]