Difference between revisions of "S230.A2 nl"

From wikibase-docker
S230.A2 nl
Jump to navigation Jump to search
Line 7: Line 7:
 
PREFIX ps: <http://external-wikibase-statbel-wikibase/prop/statement/>
 
PREFIX ps: <http://external-wikibase-statbel-wikibase/prop/statement/>
 
PREFIX pq: <http://external-wikibase-statbel-wikibase/prop/qualifier/>
 
PREFIX pq: <http://external-wikibase-statbel-wikibase/prop/qualifier/>
SELECT ?DatasetLabel ?TaalLabel ?JaarLabel ?NummerLabel ?GrootteLabel ?LinkNL ?OpmerkingLabel
+
SELECT ?DatasetLabel ?TaalLabel ?JaarLabel ?NummerLabel ?GrootteLabel ?Link ?OpmerkingLabel
 
WHERE
 
WHERE
 
{
 
{
Line 17: Line 17:
 
     OPTIONAL {?Dataset wdt:P56 ?Opmerking .}
 
     OPTIONAL {?Dataset wdt:P56 ?Opmerking .}
 
     OPTIONAL {?Dist wdt:P310 ?LinkNL . }
 
     OPTIONAL {?Dist wdt:P310 ?LinkNL . }
     BIND(IRI(REPLACE(?LinkNL, '^(.+)$', ?LinkNL)) AS ?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:P308 ?Code .
 
     ?Dist wdt:P307  ?Grootte .
 
     ?Dist wdt:P307  ?Grootte .

Revision as of 11:51, 13 April 2023


Naam Taal Jaar Nummer Grootte bestand Link Opmerking
Sterftetafels 1992 - 2 (gegevens 1988 - 1990) Nederlands 1992 01 24.27 MB https://doc.statbel.fgov.be/publications/S230.A2/S230.A2N_Sterftetafel_1992.pdf  
Sterftetafels 1992 - 2 (gegevens 1988 - 1990) Frans 1992 01 3.38 MB https://doc.statbel.fgov.be/publications/S230.A2/S230.A2F_Mortalite_1992.pdf  
Sterftetafels 1994 (gegevens 1991 - 1993) Nederlands 1994 01 4.31 MB https://doc.statbel.fgov.be/publications/S230.A2/S230.A2N_Sterftetafel_1994.pdf  
Sterftetafels 1994 (gegevens 1991 - 1993) Frans 1994 01 4.14 MB https://doc.statbel.fgov.be/publications/S230.A2/S230.A2F_Mortalite_1994.pdf  
Sterftetafels 1998 (gegevens 1995 - 1997) Nederlands 1998 01 7.66 MB https://doc.statbel.fgov.be/publications/S230.A2/S230.A2N_Sterftetafel_1998.pdf  
Sterftetafels 1998 (gegevens 1995 - 1997) Frans 1998 01 7.71 MB https://doc.statbel.fgov.be/publications/S230.A2/S230.A2F_Mortalite_1998.pdf  
Sterftetafels 1999 Nederlands 1999 01 7.94 MB https://doc.statbel.fgov.be/publications/S230.A2/S230.A2N_Sterftetafel_1999_01.pdf  
Sterftetafels 1999 Frans 1999 01 7.67 MB https://doc.statbel.fgov.be/publications/S230.A2/S230.A2F_Mortalite_1999_01.pdf  
Sterftetafels 1999 (gegevens 1996 - 1998) Nederlands 1999 02 1.53 MB https://doc.statbel.fgov.be/publications/S230.A2/S230.A2N_Sterftetafel_1999_02.pdf  
Sterftetafels 1999 (gegevens 1996 - 1998) Frans 1999 02 2.62 MB https://doc.statbel.fgov.be/publications/S230.A2/S230.A2F_Mortalite_1999_02.pdf  
Sterftetafels 2000 Nederlands 2000 01 2.37 MB https://doc.statbel.fgov.be/publications/S230.A2/S230.A2N_Sterftetafel_2000.pdf  
Sterftetafels 2000 Frans 2000 01 2.44 MB https://doc.statbel.fgov.be/publications/S230.A2/S230.A2F_Mortalite_2000.pdf  
Sterftetafels 2001 Nederlands 2001 01 1.86 MB https://doc.statbel.fgov.be/publications/S230.A2/S230.A2N_Sterftetafel_2001.pdf  
Sterftetafels 2001 Frans 2001 01 1.88 MB https://doc.statbel.fgov.be/publications/S230.A2/S230.A2F_Mortalite_2001.pdf  
Sterftetafels 2002 Nederlands 2002 01 2.15 MB https://doc.statbel.fgov.be/publications/S230.A2/S230.A2N_Sterftetafel_2002.pdf  
Sterftetafels 2002 Frans 2002 01 2.20 MB https://doc.statbel.fgov.be/publications/S230.A2/S230.A2F_Mortalite_2002.pdf  
Sterftetafels 2003 Nederlands 2003 01 2.67 MB https://doc.statbel.fgov.be/publications/S230.A2/S230.A2N_Sterftetafel_2003.pdf  
Sterftetafels 2003 Frans 2003 01 3.19 MB https://doc.statbel.fgov.be/publications/S230.A2/S230.A2F_Mortalite_2003.pdf  
Sterftetafels 2004 Nederlands 2004 01 2.57 MB https://doc.statbel.fgov.be/publications/S230.A2/S230.A2N_Sterftetafel_2004.pdf  
Sterftetafels 2004 Frans 2004 01 2.56 MB https://doc.statbel.fgov.be/publications/S230.A2/S230.A2F_Mortalite_2004.pdf  
Sterftetafels 2005 Nederlands 2005 01 3.42 MB https://doc.statbel.fgov.be/publications/S230.A2/S230.A2N_Sterftetafel_2005.pdf  
Sterftetafels 2005 Frans 2005 01 3.47 MB https://doc.statbel.fgov.be/publications/S230.A2/S230.A2F_Mortalite_2005.pdf  
Sterftetafels 2006 Nederlands 2006 01 6.36 MB https://doc.statbel.fgov.be/publications/S230.A2/S230.A2N_Sterftetafel_2006.pdf  
Sterftetafels 2006 Frans 2006 01 2.26 MB https://doc.statbel.fgov.be/publications/S230.A2/S230.A2F_Mortalite_2006.pdf  
02:57:19 12/19/2024 -- Refresh -- Duration of query :5.075s -- CSV