Number of instances of LegalEntity with administrative unit indicated
Number of instances of LegalEntity with stirdata:tradingName
Sample of instance of LegalEntity without legal identifier
Extract compliant endpoints from catalog
Number of instances of LegalEntity with registered site
Sample of instance of LegalEntity without registered site
Number of instances of LegalEntity with site
Number of instances of LegalEntity with schema:url
Number of instances of LegalEntity with stirdata:abbreviatedName
Sample of instance of LegalEntity without activity
Number of instances of LegalEntity with Primary activity
Number of instances of LegalEntity with registered address
Number of instances of LegalEntity with stirdata:taxIdentifier
Number of instances of LegalEntity with street address
Number of instances of LegalEntity with schema:email
Number of instances of LegalEntity with Auxiliary activity
Number of instances of LegalEntity with m8g:registrationDate
Number of instances of LegalEntity with stirdata:taxIdentifier with creator specified
Number of instances of LegalEntity with legal:legalIdentifier with creator specified
Number of instances of LegalEntity with schema:dissolutionDate
Number of instances of LegalEntity with legal:legalIdentifier
Number of instances of LegalEntity with units
Sample of instance of LegalEntity without dissolution date
Number of instances of LegalEntity with Company Type
Number of instances of LegalEntity with legal name
Number of instances of LegalEntity with legal:legalIdentifier with issued date
Number of instances of LegalEntity with schema:sameAs
Number of instances of LegalEntity with activity
Number of instances of LegalEntity with stirdata:leiCode
Number of instances of LegalEntity with postal address
Sample of instance of LegalEntity without registration date
Number of instances of LegalEntity with schema:telephone
Number of instances of LegalEntity with Secondary activity
Sample of instance of LegalEntity without administrative unit
Number of instances of LegalEntity with stirdata:taxIdentifier with issued date
Sample of instance of LegalEntity without legal name
PREFIX stir: <urn:stirdata:> INSERT { ?endpointURL stir:allLegalEntitiesHaveIdentifier ?allLegalEntitiesHaveIdentifier; stir:allLegalEntitiesHaveLegalName ?allLegalEntitiesHaveLegalName . } WHERE { ?endpointURL stir:numberOfLegalEntities ?numberOfLegalEntities; stir:numberOfLegalEntitiesWithLegalName ?numberOfLegalEntitiesWithLegalName ; stir:numberOfLegalEntitiesWithIdentifier ?numberOfLegalEntitiesWithIdentifier . BIND((?numberOfLegalEntities = ?numberOfLegalEntitiesWithIdentifier) AS ?allLegalEntitiesHaveIdentifier) BIND((?numberOfLegalEntities = ?numberOfLegalEntitiesWithLegalName) AS ?allLegalEntitiesHaveLegalName) }
{{! PREFIX dcterms: <http://purl.org/dc/terms/> }} STIRData datasets validation report STIRData compliant datasets discovered in data.europa.eu Report available also in RDF Turtle and CSV. Validation performed on <date>{{urn:stirdata:now}}</date>. {{#urn:stirdata:endpoint}} {{dcterms:title}} {{@id}} Basic validation Number of legal entities found {{urn:stirdata:numberOfLegalEntities}} All legal entities have legal name {{urn:stirdata:allLegalEntitiesHaveLegalName}} {{#urn:stirdata:LegalEntityWithoutLegalNameExample}} Example of legal entity without legal name {{@id}} {{/urn:stirdata:LegalEntityWithoutLegalNameExample}} All legal entities have identifier {{urn:stirdata:allLegalEntitiesHaveIdentifier}} {{#urn:stirdata:LegalEntityWithoutIdentifierExample}} Example of legal entity without identifier {{@id}} {{/urn:stirdata:LegalEntityWithoutIdentifierExample}} Presence of metadata Metadata present according to specification {{urn:stirdata:AdditionalMetadataPresent}} {{#urn:stirdata:AdditionalMetadata}} Country indicated in metadata {{#urn:stirdata:AdditionalMetadataCountry}}{{@id}}{{/urn:stirdata:AdditionalMetadataCountry}} Country indicated in metadata from Countries code list {{urn:stirdata:AdditionalMetadataCountryCorrect}} Modified date indicated in metadata {{urn:stirdata:AdditionalMetadataModified}} Modified date indicated in metadata has xsd:dateTimeStamp datatype {{urn:stirdata:AdditionalMetadataCountryCorrect}} Source {{#urn:stirdata:AdditionalMetadataSource}}{{@id}}{{/urn:stirdata:AdditionalMetadataSource}} Source license {{#urn:stirdata:AdditionalMetadataSourceLicense}}{{@id}}{{/urn:stirdata:AdditionalMetadataSourceLicense}} NACE codelist present {{urn:stirdata:AdditionalMetadataNACEDatasetPresent}} NACE codelist dataset {{#urn:stirdata:AdditionalMetadataNACEDataset}}{{@id}}{{/urn:stirdata:AdditionalMetadataNACEDataset}} {{/urn:stirdata:AdditionalMetadata}} {{/urn:stirdata:endpoint}}
PREFIX esl: <http://plugins.linkedpipes.com/ontology/e-sparqlEndpointList#> PREFIX : <urn:stirdata:> CONSTRUCT { ?task a esl:Task ; esl:query ?query ; esl:group ?uritext ; esl:endpoint ?uritext . } WHERE { ?s :endpoint ?uritext . BIND("numberOfLegalEntitiesWithAddressAndAdminUnit" AS ?metric) BIND(IRI(?uritext) as ?uri) BIND(UUID() AS ?task) BIND(CONCAT("""PREFIX : <urn:stirdata:> PREFIX legal: <http://www.w3.org/ns/legal#> PREFIX m8g: <http://data.europa.eu/m8g/> PREFIX stirdata: <https://w3id.org/stirdata/vocabulary/> PREFIX locn: <http://www.w3.org/ns/locn#> PREFIX adms: <http://www.w3.org/ns/adms#> PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> PREFIX schema: <https://schema.org/> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> PREFIX org: <http://www.w3.org/ns/org#> CONSTRUCT { <""",?uritext,"""> :""",?metric,""" ?""",?metric,""" . } WHERE { { SELECT (COUNT(DISTINCT ?resource) AS ?""",?metric,""") WHERE { ?resource a legal:LegalEntity ; legal:registeredAddress|stirdata:postalAddress|stirdata:streetAddress|((org:hasRegisteredSite|org:hasSite)/org:siteAddress) ?address . ?address a locn:Address ; m8g:adminUnit ?adminUnit . ?adminUnit a m8g:AdminUnit ; m8g:level ?level ; m8g:code ?adminUnit . FILTER(isIRI(?level) && STRSTARTS(STR(?level), "https://w3id.org/stirdata/resource/adminUnitLevel")) } } }""") as ?query) }
PREFIX esl: <http://plugins.linkedpipes.com/ontology/e-sparqlEndpointList#> PREFIX : <urn:stirdata:> CONSTRUCT { ?task a esl:Task ; esl:query ?query ; esl:group ?uritext ; esl:endpoint ?uritext . } WHERE { ?s :endpoint ?uritext . BIND("numberOfLegalEntitiesWithTradingName" AS ?metric) BIND(UUID() AS ?task) BIND(IRI(?uritext) as ?uri) BIND(CONCAT("""PREFIX : <urn:stirdata:> PREFIX legal: <http://www.w3.org/ns/legal#> PREFIX m8g: <http://data.europa.eu/m8g/> PREFIX stirdata: <https://w3id.org/stirdata/vocabulary/> PREFIX locn: <http://www.w3.org/ns/locn#> CONSTRUCT { <""",?uritext,"""> :""",?metric,""" ?""",?metric,""" . } WHERE { { SELECT (COUNT(DISTINCT ?resource) AS ?""",?metric,""") WHERE { ?resource a legal:LegalEntity ; stirdata:tradingName ?name . FILTER(isLiteral(?name) && STRLEN(?name) > 0) } } }""") as ?query) }
PREFIX stir: <urn:stirdata:> INSERT { <urn:Root> a <urn:Root> ; stir:now ?now ; <http://plugins.linkedpipes.com/ontology/t-mustache#fileName> "index.html" ; <urn:stirdata:endpoint> ?endpointURL . } WHERE { ?endpointURL stir:numberOfLegalEntities ?numberOfLegalEntities. BIND(NOW() AS ?now) }
PREFIX esl: <http://plugins.linkedpipes.com/ontology/e-sparqlEndpointList#> PREFIX : <urn:stirdata:> CONSTRUCT { ?task a esl:Task ; esl:query ?query ; esl:group ?uritext ; esl:endpoint ?uritext . } WHERE { ?s :endpoint ?uritext . BIND("LegalEntityWithoutIdentifier" AS ?metric) BIND(IRI(?uritext) as ?uri) BIND(UUID() AS ?task) BIND(CONCAT("""PREFIX : <urn:stirdata:> PREFIX legal: <http://www.w3.org/ns/legal#> PREFIX m8g: <http://data.europa.eu/m8g/> PREFIX stirdata: <https://w3id.org/stirdata/vocabulary/> PREFIX locn: <http://www.w3.org/ns/locn#> PREFIX adms: <http://www.w3.org/ns/adms#> PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> PREFIX schema: <https://schema.org/> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> PREFIX org: <http://www.w3.org/ns/org#> CONSTRUCT { <""",?uritext,"""> :""",?metric,"""Example ?example . } WHERE { { SELECT (SAMPLE(?resource) AS ?example) WHERE { ?resource a legal:LegalEntity . FILTER NOT EXISTS { ?resource legal:legalIdentifier ?identifier . ?identifier a adms:Identifier ; skos:notation ?value . FILTER(isLiteral(?value)) } } } }""") as ?query) }
PREFIX dcterms: <http://purl.org/dc/terms/> PREFIX dcat: <http://www.w3.org/ns/dcat#> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> CONSTRUCT { ?endpoint <urn:stirdata:endpoint> ?endpointString ; dcterms:title ?title . } WHERE { { ?dataset a dcat:Dataset ; dcterms:title ?title ; dcterms:conformsTo <https://stirdata.github.io/data-specification/> ; dcat:distribution/dcat:accessService ?service . ?service a dcat:DataService ; dcterms:conformsTo <https://www.w3.org/TR/sparql11-protocol/> ; dcat:endpointURL ?endpoint . FILTER(langMatches(LANG(?title), "en")) } UNION #For Norwegian dataset { ?dataset a dcat:Dataset ; dcterms:title ?title ; dcterms:conformsTo/dcterms:source "https://stirdata.github.io/data-specification/" ; dcat:distribution ?distribution. ?distribtion a dcat:Distribution ; dcat:accessURL ?endpoint ; dcterms:conformsTo/dcterms:source "https://www.w3.org/TR/sparql11-protocol/" . FILTER(langMatches(LANG(?title), "en")) } BIND(STR(?endpoint) AS ?endpointString) }
<https://obchodní-rejstřík.stirdata.opendata.cz/sparql> <urn:stirdata:endpoint> "https://obchodní-rejstřík.stirdata.opendata.cz/sparql" . <https://stirdata-semantic.ails.ece.ntua.gr/api/content/ee/sparql> <urn:stirdata:endpoint> "https://stirdata-semantic.ails.ece.ntua.gr/api/content/ee/sparql" . <https://stirdata-semantic.ails.ece.ntua.gr/api/content/be/sparql> <urn:stirdata:endpoint> "https://stirdata-semantic.ails.ece.ntua.gr/api/content/be/sparql" . <https://stirdata-semantic.ails.ece.ntua.gr/api/content/uk/sparql> <urn:stirdata:endpoint> "https://stirdata-semantic.ails.ece.ntua.gr/api/content/uk/sparql" . <https://stirdata-semantic.ails.ece.ntua.gr/api/content/be/sparql> <urn:stirdata:endpoint> "https://stirdata-semantic.ails.ece.ntua.gr/api/content/be/sparql" . <https://stirdata-semantic.ails.ece.ntua.gr/api/content/el/sparql> <urn:stirdata:endpoint> "https://stirdata-semantic.ails.ece.ntua.gr/api/content/el/sparql" . <https://stirdata-semantic.ails.ece.ntua.gr/api/content/fi/sparql> <urn:stirdata:endpoint> "https://stirdata-semantic.ails.ece.ntua.gr/api/content/fi/sparql" . <https://stirdata-semantic.ails.ece.ntua.gr/api/content/md/sparql> <urn:stirdata:endpoint> "https://stirdata-semantic.ails.ece.ntua.gr/api/content/md/sparql" . <https://stirdata-semantic.ails.ece.ntua.gr/api/content/lv/sparql> <urn:stirdata:endpoint> "https://stirdata-semantic.ails.ece.ntua.gr/api/content/lv/sparql" . <https://stirdata-semantic.ails.ece.ntua.gr/api/content/fr/sparql> <urn:stirdata:endpoint> "https://stirdata-semantic.ails.ece.ntua.gr/api/content/fr/sparql" . <https://stirdata-semantic.ails.ece.ntua.gr/api/content/cy/sparql> <urn:stirdata:endpoint> "https://stirdata-semantic.ails.ece.ntua.gr/api/content/cy/sparql" . <https://stirdata-semantic.ails.ece.ntua.gr/api/content/no/sparql> <urn:stirdata:endpoint> "https://stirdata-semantic.ails.ece.ntua.gr/api/content/no/sparql" . <https://stirdata-semantic.ails.ece.ntua.gr/api/content/nl/sparql> <urn:stirdata:endpoint> "https://stirdata-semantic.ails.ece.ntua.gr/api/content/nl/sparql" . <https://stirdata-semantic.ails.ece.ntua.gr/api/content/ro/sparql> <urn:stirdata:endpoint> "https://stirdata-semantic.ails.ece.ntua.gr/api/content/ro/sparql" .
PREFIX dcterms: <http://purl.org/dc/terms/> PREFIX dcat: <http://www.w3.org/ns/dcat#> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> CONSTRUCT { ?endpoint <urn:stirdata:endpoint> ?endpointString . #; # dcterms:title ?title . } WHERE { ?dataset a dcat:Dataset ; dcterms:title ?title ; dcterms:conformsTo <https://stirdata.github.io/data-specification/> ; dcat:distribution/dcat:accessService ?service . ?service a dcat:DataService ; dcterms:conformsTo <https://www.w3.org/TR/sparql11-protocol/> ; dcat:endpointURL ?endpoint . FILTER(langMatches(LANG(?title), "en")) BIND(STR(?endpoint) AS ?endpointString) }
PREFIX esl: <http://plugins.linkedpipes.com/ontology/e-sparqlEndpointList#> PREFIX : <urn:stirdata:> CONSTRUCT { ?task a esl:Task ; esl:query ?query ; esl:group ?uritext ; esl:endpoint ?uritext . } WHERE { ?s :endpoint ?uritext . BIND("numberOfLegalEntitiesWithRegisteredSite" AS ?metric) BIND(IRI(?uritext) as ?uri) BIND(UUID() AS ?task) BIND(CONCAT("""PREFIX : <urn:stirdata:> PREFIX legal: <http://www.w3.org/ns/legal#> PREFIX m8g: <http://data.europa.eu/m8g/> PREFIX stirdata: <https://w3id.org/stirdata/vocabulary/> PREFIX locn: <http://www.w3.org/ns/locn#> PREFIX adms: <http://www.w3.org/ns/adms#> PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> PREFIX schema: <https://schema.org/> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> PREFIX org: <http://www.w3.org/ns/org#> CONSTRUCT { <""",?uritext,"""> :""",?metric,""" ?""",?metric,""" . } WHERE { { SELECT (COUNT(DISTINCT ?resource) AS ?""",?metric,""") WHERE { ?resource a legal:LegalEntity ; org:hasRegisteredSite ?site . ?site a org:Site ; org:siteAddress ?address . ?address a locn:Address . } } }""") as ?query) }
PREFIX esl: <http://plugins.linkedpipes.com/ontology/e-sparqlEndpointList#> PREFIX : <urn:stirdata:> CONSTRUCT { ?task a esl:Task ; esl:query ?query ; esl:group ?uritext ; esl:endpoint ?uritext . } WHERE { ?s :endpoint ?uritext . BIND("LegalEntityWithoutRegisteredSite" AS ?metric) BIND(IRI(?uritext) as ?uri) BIND(UUID() AS ?task) BIND(CONCAT("""PREFIX : <urn:stirdata:> PREFIX legal: <http://www.w3.org/ns/legal#> PREFIX m8g: <http://data.europa.eu/m8g/> PREFIX stirdata: <https://w3id.org/stirdata/vocabulary/> PREFIX locn: <http://www.w3.org/ns/locn#> PREFIX adms: <http://www.w3.org/ns/adms#> PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> PREFIX schema: <https://schema.org/> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> PREFIX org: <http://www.w3.org/ns/org#> CONSTRUCT { <""",?uritext,"""> :""",?metric,"""Example ?example . } WHERE { { SELECT (SAMPLE(?resource) AS ?example) WHERE { ?resource a legal:LegalEntity . FILTER NOT EXISTS { ?resource org:hasRegisteredSite ?site . ?site a org:Site ; org:siteAddress ?address . ?address a locn:Address . } } } }""") as ?query) }
PREFIX esl: <http://plugins.linkedpipes.com/ontology/e-sparqlEndpointList#> PREFIX : <urn:stirdata:> CONSTRUCT { ?task a esl:Task ; esl:query ?query ; esl:group ?uritext ; esl:endpoint ?uritext . } WHERE { ?s :endpoint ?uritext . BIND("numberOfLegalEntitiesWithSite" AS ?metric) BIND(IRI(?uritext) as ?uri) BIND(UUID() AS ?task) BIND(CONCAT("""PREFIX : <urn:stirdata:> PREFIX legal: <http://www.w3.org/ns/legal#> PREFIX m8g: <http://data.europa.eu/m8g/> PREFIX stirdata: <https://w3id.org/stirdata/vocabulary/> PREFIX locn: <http://www.w3.org/ns/locn#> PREFIX adms: <http://www.w3.org/ns/adms#> PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> PREFIX schema: <https://schema.org/> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> PREFIX org: <http://www.w3.org/ns/org#> CONSTRUCT { <""",?uritext,"""> :""",?metric,""" ?""",?metric,""" . } WHERE { { SELECT (COUNT(DISTINCT ?resource) AS ?""",?metric,""") WHERE { ?resource a legal:LegalEntity ; org:hasSite ?site . ?site a org:Site ; org:siteAddress ?address . ?address a locn:Address . } } }""") as ?query) }
ASK { [] a <https://vocabulary.etl.linkedpipes.com/report/Report> ; <https://vocabulary.etl.linkedpipes.com/report/status> <https://vocabulary.etl.linkedpipes.com/report/Failed> . }
PREFIX esl: <http://plugins.linkedpipes.com/ontology/e-sparqlEndpointList#> PREFIX : <urn:stirdata:> CONSTRUCT { ?task a esl:Task ; esl:query ?query ; esl:group ?uritext ; esl:endpoint ?uritext . } WHERE { ?s :endpoint ?uritext . BIND("numberOfLegalEntitiesWithUrl" AS ?metric) BIND(IRI(?uritext) as ?uri) BIND(UUID() AS ?task) BIND(CONCAT("""PREFIX : <urn:stirdata:> PREFIX legal: <http://www.w3.org/ns/legal#> PREFIX m8g: <http://data.europa.eu/m8g/> PREFIX stirdata: <https://w3id.org/stirdata/vocabulary/> PREFIX locn: <http://www.w3.org/ns/locn#> PREFIX adms: <http://www.w3.org/ns/adms#> PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> PREFIX schema: <https://schema.org/> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> CONSTRUCT { <""",?uritext,"""> :""",?metric,""" ?""",?metric,""" . } WHERE { { SELECT (COUNT(DISTINCT ?resource) AS ?""",?metric,""") WHERE { ?resource a legal:LegalEntity ; schema:url [] . } } }""") as ?query) }
PREFIX esl: <http://plugins.linkedpipes.com/ontology/e-sparqlEndpointList#> PREFIX : <urn:stirdata:> CONSTRUCT { ?task a esl:Task ; esl:query ?query ; esl:group ?uritext ; esl:endpoint ?uritext . } WHERE { ?s :endpoint ?uritext . BIND("numberOfLegalEntitiesWithAbbreviatedName" AS ?metric) BIND(IRI(?uritext) as ?uri) BIND(UUID() AS ?task) BIND(CONCAT("""PREFIX : <urn:stirdata:> PREFIX legal: <http://www.w3.org/ns/legal#> PREFIX m8g: <http://data.europa.eu/m8g/> PREFIX stirdata: <https://w3id.org/stirdata/vocabulary/> PREFIX locn: <http://www.w3.org/ns/locn#> CONSTRUCT { <""",?uritext,"""> :""",?metric,""" ?""",?metric,""" . } WHERE { { SELECT (COUNT(DISTINCT ?resource) AS ?""",?metric,""") WHERE { ?resource a legal:LegalEntity ; stirdata:abbreviatedName ?name . FILTER(isLiteral(?name) && STRLEN(?name) > 0) } } }""") as ?query) }
PREFIX esl: <http://plugins.linkedpipes.com/ontology/e-sparqlEndpointList#> PREFIX : <urn:stirdata:> CONSTRUCT { ?task a esl:Task ; esl:query ?query ; esl:group ?uritext ; esl:endpoint ?uritext . } WHERE { ?s :endpoint ?uritext . BIND("LegalEntityWithoutActivity" AS ?metric) BIND(IRI(?uritext) as ?uri) BIND(UUID() AS ?task) BIND(CONCAT("""PREFIX : <urn:stirdata:> PREFIX legal: <http://www.w3.org/ns/legal#> PREFIX m8g: <http://data.europa.eu/m8g/> PREFIX stirdata: <https://w3id.org/stirdata/vocabulary/> PREFIX locn: <http://www.w3.org/ns/locn#> PREFIX adms: <http://www.w3.org/ns/adms#> PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> PREFIX schema: <https://schema.org/> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> PREFIX org: <http://www.w3.org/ns/org#> CONSTRUCT { <""",?uritext,"""> :""",?metric,"""Example ?example . } WHERE { { SELECT (SAMPLE(?resource) AS ?example) WHERE { ?resource a legal:LegalEntity . FILTER NOT EXISTS { ?resource legal:companyActivity ?activity . ?activity a stirdata:BusinessActivity, skos:Concept ; skos:prefLabel [] ; skos:notation [] ; skos:inScheme [] ; stirdata:level [] ; skos:exactMatch [] . } } } }""") as ?query) }
PREFIX : <urn:stirdata:> INSERT { ?s :AdditionalMetadata true . } WHERE { ?s :numberOfLegalEntities [] ; :AdditionalMetadataCountry [] ; :AdditionalMetadataSource [] ; :AdditionalMetadataModified [] . }
PREFIX esl: <http://plugins.linkedpipes.com/ontology/e-sparqlEndpointList#> PREFIX : <urn:stirdata:> CONSTRUCT { ?task a esl:Task ; esl:query ?query ; esl:group ?uritext ; esl:endpoint ?uritext . } WHERE { ?s :endpoint ?uritext . BIND(IRI(?uritext) as ?uri) BIND(UUID() AS ?task) BIND(CONCAT("""PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> PREFIX dcterms: <http://purl.org/dc/terms/> PREFIX stirdata: <https://w3id.org/stirdata/vocabulary/> PREFIX : <urn:stirdata:> CONSTRUCT { <""",?uritext,"""> :AdditionalMetadataCountryCorrect ?AdditionalMetadataCountryCorrect ; :AdditionalMetadataCountry ?country ; :AdditionalMetadataModifiedCorrect ?AdditionalMetadataModifiedCorrect ; :AdditionalMetadataModifiedPresent ?AdditionalMetadataModifiedPresent ; :AdditionalMetadataModified ?modified ; :AdditionalMetadataSource ?source ; :AdditionalMetadataSourceLicense ?license ; :AdditionalMetadataNACEDatasetPresent ?naceDatasetPresent ; :AdditionalMetadataNACEDataset ?naceDataset . } WHERE { ?dataset dcterms:spatial ?country ; dcterms:source ?source . OPTIONAL { ?source dcterms:license ?license . } OPTIONAL { ?dataset dcterms:modified ?modified . } OPTIONAL { ?dataset stirdata:naceDataset ?naceDataset . } BIND(BOUND(?modified) AS ?AdditionalMetadataModifiedPresent) BIND((DATATYPE(?modified) = xsd:dateTimeStamp) AS ?AdditionalMetadataModifiedCorrect) BIND(STRSTARTS(STR(?country), "http://publications.europa.eu/resource/authority/country/") AS ?AdditionalMetadataCountryCorrect) BIND(BOUND(?naceDataset) AS ?naceDatasetPresent) }""") as ?query) }
PREFIX esl: <http://plugins.linkedpipes.com/ontology/e-sparqlEndpointList#> PREFIX : <urn:stirdata:> CONSTRUCT { ?task a esl:Task ; esl:query ?query ; esl:group ?uritext ; esl:endpoint ?uritext . } WHERE { ?s :endpoint ?uritext . BIND("numberOfLegalEntitiesWithPrimaryActivity" AS ?metric) BIND(IRI(?uritext) as ?uri) BIND(UUID() AS ?task) BIND(CONCAT("""PREFIX : <urn:stirdata:> PREFIX legal: <http://www.w3.org/ns/legal#> PREFIX m8g: <http://data.europa.eu/m8g/> PREFIX stirdata: <https://w3id.org/stirdata/vocabulary/> PREFIX locn: <http://www.w3.org/ns/locn#> PREFIX adms: <http://www.w3.org/ns/adms#> PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> PREFIX schema: <https://schema.org/> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> CONSTRUCT { <""",?uritext,"""> :""",?metric,""" ?""",?metric,""" . } WHERE { { SELECT (COUNT(DISTINCT ?resource) AS ?""",?metric,""") WHERE { ?resource a legal:LegalEntity ; stirdata:primaryActivity ?activity . ?activity a stirdata:BusinessActivity, skos:Concept ; skos:prefLabel [] ; skos:notation [] ; skos:inScheme [] ; stirdata:level [] ; skos:exactMatch [] . } } }""") as ?query) }
PREFIX esl: <http://plugins.linkedpipes.com/ontology/e-sparqlEndpointList#> PREFIX : <urn:stirdata:> CONSTRUCT { ?task a esl:Task ; esl:query ?query ; esl:group ?uritext ; esl:endpoint ?uritext . } WHERE { ?s :endpoint ?uritext . BIND("numberOfLegalEntitiesWithRegisteredAddress" AS ?metric) BIND(IRI(?uritext) as ?uri) BIND(UUID() AS ?task) BIND(CONCAT("""PREFIX : <urn:stirdata:> PREFIX legal: <http://www.w3.org/ns/legal#> PREFIX m8g: <http://data.europa.eu/m8g/> PREFIX stirdata: <https://w3id.org/stirdata/vocabulary/> PREFIX locn: <http://www.w3.org/ns/locn#> PREFIX adms: <http://www.w3.org/ns/adms#> PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> PREFIX schema: <https://schema.org/> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> PREFIX org: <http://www.w3.org/ns/org#> CONSTRUCT { <""",?uritext,"""> :""",?metric,""" ?""",?metric,""" . } WHERE { { SELECT (COUNT(DISTINCT ?resource) AS ?""",?metric,""") WHERE { ?resource a legal:LegalEntity ; m8g:registeredAddress ?address . ?address a locn:Address . } } }""") as ?query) }
PREFIX esl: <http://plugins.linkedpipes.com/ontology/e-sparqlEndpointList#> PREFIX : <urn:stirdata:> CONSTRUCT { ?task a esl:Task ; esl:query ?query ; esl:group ?uritext ; esl:endpoint ?uritext . } WHERE { ?s :endpoint ?uritext . BIND(IRI(?uritext) as ?uri) BIND("numberOfLegalEntitiesWithTaxIdentifier" AS ?metric) BIND(CONCAT("""PREFIX : <urn:stirdata:> PREFIX legal: <http://www.w3.org/ns/legal#> PREFIX m8g: <http://data.europa.eu/m8g/> PREFIX stirdata: <https://w3id.org/stirdata/vocabulary/> PREFIX locn: <http://www.w3.org/ns/locn#> PREFIX adms: <http://www.w3.org/ns/adms#> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> CONSTRUCT { <""",?uritext,"""> :""",?metric,""" ?""",?metric,""" . } WHERE { { SELECT (COUNT(DISTINCT ?resource) AS ?""",?metric,""") WHERE { ?resource a legal:LegalEntity ; stirdata:taxIdentifier ?identifier . ?identifier a adms:Identifier ; skos:notation ?value . FILTER(isLiteral(?value)) } } }""") as ?query) FILTER NOT EXISTS { ?s2 :ep ?uritext2 . FILTER(?s != ?s2 && STRSTARTS(?uritext, ?uritext2)) } BIND(UUID() AS ?task) }
PREFIX esl: <http://plugins.linkedpipes.com/ontology/e-sparqlEndpointList#> PREFIX : <urn:stirdata:> CONSTRUCT { ?task a esl:Task ; esl:query ?query ; esl:group ?uritext ; esl:endpoint ?uritext . } WHERE { ?s :endpoint ?uritext . BIND("numberOfLegalEntitiesWithStreetAddress" AS ?metric) BIND(IRI(?uritext) as ?uri) BIND(UUID() AS ?task) BIND(CONCAT("""PREFIX : <urn:stirdata:> PREFIX legal: <http://www.w3.org/ns/legal#> PREFIX m8g: <http://data.europa.eu/m8g/> PREFIX stirdata: <https://w3id.org/stirdata/vocabulary/> PREFIX locn: <http://www.w3.org/ns/locn#> PREFIX adms: <http://www.w3.org/ns/adms#> PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> PREFIX schema: <https://schema.org/> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> PREFIX org: <http://www.w3.org/ns/org#> CONSTRUCT { <""",?uritext,"""> :""",?metric,""" ?""",?metric,""" . } WHERE { { SELECT (COUNT(DISTINCT ?resource) AS ?""",?metric,""") WHERE { ?resource a legal:LegalEntity ; stirdata:streetAddress ?address . ?address a locn:Address . } } }""") as ?query) }
PREFIX esl: <http://plugins.linkedpipes.com/ontology/e-sparqlEndpointList#> PREFIX : <urn:stirdata:> CONSTRUCT { ?task a esl:Task ; esl:query ?query ; esl:group ?uritext ; esl:endpoint ?uritext . } WHERE { ?s :endpoint ?uritext . BIND("numberOfLegalEntitiesWithEMail" AS ?metric) BIND(IRI(?uritext) as ?uri) BIND(UUID() AS ?task) BIND(CONCAT("""PREFIX : <urn:stirdata:> PREFIX legal: <http://www.w3.org/ns/legal#> PREFIX m8g: <http://data.europa.eu/m8g/> PREFIX stirdata: <https://w3id.org/stirdata/vocabulary/> PREFIX locn: <http://www.w3.org/ns/locn#> PREFIX adms: <http://www.w3.org/ns/adms#> PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> PREFIX schema: <https://schema.org/> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> CONSTRUCT { <""",?uritext,"""> :""",?metric,""" ?""",?metric,""" . } WHERE { { SELECT (COUNT(DISTINCT ?resource) AS ?""",?metric,""") WHERE { ?resource a legal:LegalEntity ; schema:email [] . } } }""") as ?query) }
PREFIX esl: <http://plugins.linkedpipes.com/ontology/e-sparqlEndpointList#> PREFIX : <urn:stirdata:> CONSTRUCT { ?task a esl:Task ; esl:query ?query ; esl:group ?uritext ; esl:endpoint ?uritext . } WHERE { ?s :endpoint ?uritext . BIND("numberOfLegalEntitiesWithAuxiliaryActivity" AS ?metric) BIND(IRI(?uritext) as ?uri) BIND(UUID() AS ?task) BIND(CONCAT("""PREFIX : <urn:stirdata:> PREFIX legal: <http://www.w3.org/ns/legal#> PREFIX m8g: <http://data.europa.eu/m8g/> PREFIX stirdata: <https://w3id.org/stirdata/vocabulary/> PREFIX locn: <http://www.w3.org/ns/locn#> PREFIX adms: <http://www.w3.org/ns/adms#> PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> PREFIX schema: <https://schema.org/> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> CONSTRUCT { <""",?uritext,"""> :""",?metric,""" ?""",?metric,""" . } WHERE { { SELECT (COUNT(DISTINCT ?resource) AS ?""",?metric,""") WHERE { ?resource a legal:LegalEntity ; stirdata:auxiliaryActivity ?activity . ?activity a stirdata:BusinessActivity, skos:Concept ; skos:prefLabel [] ; skos:notation [] ; skos:inScheme [] ; stirdata:level [] ; skos:exactMatch [] . } } }""") as ?query) }
PREFIX esl: <http://plugins.linkedpipes.com/ontology/e-sparqlEndpointList#> PREFIX m8g: <http://data.europa.eu/m8g/> PREFIX : <urn:stirdata:> CONSTRUCT { ?task a esl:Task ; esl:query ?query ; esl:group ?uritext ; esl:endpoint ?uritext . } WHERE { ?s :endpoint ?uritext . BIND("numberOfLegalEntitiesWithRegistrationDate" AS ?metric) BIND(IRI(?uritext) as ?uri) BIND(UUID() AS ?task) BIND(CONCAT("""PREFIX : <urn:stirdata:> PREFIX legal: <http://www.w3.org/ns/legal#> PREFIX m8g: <http://data.europa.eu/m8g/> PREFIX stirdata: <https://w3id.org/stirdata/vocabulary/> PREFIX locn: <http://www.w3.org/ns/locn#> PREFIX adms: <http://www.w3.org/ns/adms#> PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> CONSTRUCT { <""",?uritext,"""> :""",?metric,""" ?""",?metric,""" . } WHERE { { SELECT (COUNT(DISTINCT ?resource) AS ?""",?metric,""") WHERE { ?resource a legal:LegalEntity ; m8g:registrationDate ?date . FILTER(isLiteral(?date) && datatype(?date) = xsd:date) } } }""") as ?query) }
PREFIX esl: <http://plugins.linkedpipes.com/ontology/e-sparqlEndpointList#> PREFIX : <urn:stirdata:> CONSTRUCT { ?task a esl:Task ; esl:query ?query ; esl:group ?uritext ; esl:endpoint ?uritext . } WHERE { ?s :endpoint ?uritext . BIND("numberOfLegalEntitiesWithTaxIdentifierAndCreator" AS ?metric) BIND(IRI(?uritext) as ?uri) BIND(UUID() AS ?task) BIND(CONCAT("""PREFIX : <urn:stirdata:> PREFIX legal: <http://www.w3.org/ns/legal#> PREFIX m8g: <http://data.europa.eu/m8g/> PREFIX stirdata: <https://w3id.org/stirdata/vocabulary/> PREFIX locn: <http://www.w3.org/ns/locn#> PREFIX adms: <http://www.w3.org/ns/adms#> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> PREFIX dcterms: <http://purl.org/dc/terms/> CONSTRUCT { <""",?uritext,"""> :""",?metric,""" ?""",?metric,""" . } WHERE { { SELECT (COUNT(DISTINCT ?resource) AS ?""",?metric,""") WHERE { ?resource a legal:LegalEntity ; stirdata:taxIdentifier ?identifier . ?identifier a adms:Identifier ; skos:notation ?value ; dcterms:creator [] . FILTER(isLiteral(?value)) } } }""") as ?query) }
PREFIX esl: <http://plugins.linkedpipes.com/ontology/e-sparqlEndpointList#> PREFIX : <urn:stirdata:> CONSTRUCT { ?task a esl:Task ; esl:query ?query ; esl:group ?uritext ; esl:endpoint ?uritext . } WHERE { ?s :endpoint ?uritext . BIND("numberOfLegalEntitiesWithIdentifierAndCreator" AS ?metric) BIND(IRI(?uritext) as ?uri) BIND(UUID() AS ?task) BIND(CONCAT("""PREFIX : <urn:stirdata:> PREFIX legal: <http://www.w3.org/ns/legal#> PREFIX m8g: <http://data.europa.eu/m8g/> PREFIX stirdata: <https://w3id.org/stirdata/vocabulary/> PREFIX locn: <http://www.w3.org/ns/locn#> PREFIX adms: <http://www.w3.org/ns/adms#> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> PREFIX dcterms: <http://purl.org/dc/terms/> CONSTRUCT { <""",?uritext,"""> :""",?metric,""" ?""",?metric,""" . } WHERE { { SELECT (COUNT(DISTINCT ?resource) AS ?""",?metric,""") WHERE { ?resource a legal:LegalEntity ; legal:legalIdentifier ?identifier . ?identifier a adms:Identifier ; skos:notation ?value ; dcterms:creator [] . FILTER(isLiteral(?value)) } } }""") as ?query) }
PREFIX esl: <http://plugins.linkedpipes.com/ontology/e-sparqlEndpointList#> PREFIX : <urn:stirdata:> CONSTRUCT { ?task a esl:Task ; esl:query ?query ; esl:group ?uritext ; esl:endpoint ?uritext . } WHERE { ?s :endpoint ?uritext . BIND("numberOfLegalEntitiesWithDissolutionDate" AS ?metric) BIND(IRI(?uritext) as ?uri) BIND(UUID() AS ?task) BIND(CONCAT("""PREFIX : <urn:stirdata:> PREFIX legal: <http://www.w3.org/ns/legal#> PREFIX m8g: <http://data.europa.eu/m8g/> PREFIX stirdata: <https://w3id.org/stirdata/vocabulary/> PREFIX locn: <http://www.w3.org/ns/locn#> PREFIX adms: <http://www.w3.org/ns/adms#> PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> PREFIX schema: <https://schema.org/> CONSTRUCT { <""",?uritext,"""> :""",?metric,""" ?""",?metric,""" . } WHERE { { SELECT (COUNT(DISTINCT ?resource) AS ?""",?metric,""") WHERE { ?resource a legal:LegalEntity ; schema:dissolutionDate ?date . FILTER(isLiteral(?date) && datatype(?date) = xsd:date) } } }""") as ?query) }
PREFIX esl: <http://plugins.linkedpipes.com/ontology/e-sparqlEndpointList#> PREFIX : <urn:stirdata:> CONSTRUCT { ?task a esl:Task ; esl:query ?query ; esl:group ?uritext ; esl:endpoint ?uritext . } WHERE { ?s :endpoint ?uritext . BIND("numberOfLegalEntitiesWithIdentifier" AS ?metric) BIND(IRI(?uritext) as ?uri) BIND(UUID() AS ?task) BIND(CONCAT("""PREFIX : <urn:stirdata:> PREFIX legal: <http://www.w3.org/ns/legal#> PREFIX m8g: <http://data.europa.eu/m8g/> PREFIX stirdata: <https://w3id.org/stirdata/vocabulary/> PREFIX locn: <http://www.w3.org/ns/locn#> PREFIX adms: <http://www.w3.org/ns/adms#> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> CONSTRUCT { <""",?uritext,"""> :""",?metric,""" ?""",?metric,""" . } WHERE { { SELECT (COUNT(DISTINCT ?resource) AS ?""",?metric,""") WHERE { ?resource a legal:LegalEntity ; legal:legalIdentifier ?identifier . ?identifier a adms:Identifier ; skos:notation ?value . FILTER(isLiteral(?value)) } } }""") as ?query) }
PREFIX esl: <http://plugins.linkedpipes.com/ontology/e-sparqlEndpointList#> PREFIX : <urn:stirdata:> CONSTRUCT { ?task a esl:Task ; esl:query ?query ; esl:group ?uritext ; esl:endpoint ?uritext . } WHERE { ?s :endpoint ?uritext . BIND("numberOfLegalEntitiesWithUnits" AS ?metric) BIND(IRI(?uritext) as ?uri) BIND(UUID() AS ?task) BIND(CONCAT("""PREFIX : <urn:stirdata:> PREFIX legal: <http://www.w3.org/ns/legal#> PREFIX m8g: <http://data.europa.eu/m8g/> PREFIX stirdata: <https://w3id.org/stirdata/vocabulary/> PREFIX locn: <http://www.w3.org/ns/locn#> PREFIX adms: <http://www.w3.org/ns/adms#> PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> PREFIX schema: <https://schema.org/> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> PREFIX org: <http://www.w3.org/ns/org#> CONSTRUCT { <""",?uritext,"""> :""",?metric,""" ?""",?metric,""" . } WHERE { { SELECT (COUNT(DISTINCT ?resource) AS ?""",?metric,""") WHERE { ?resource a legal:LegalEntity ; org:hasUnit ?unit . ?unit a org:OrganizationalUnit . } } }""") as ?query) }
PREFIX esl: <http://plugins.linkedpipes.com/ontology/e-sparqlEndpointList#> PREFIX : <urn:stirdata:> CONSTRUCT { ?task a esl:Task ; esl:query ?query ; esl:group ?uritext ; esl:endpoint ?uritext . } WHERE { ?s :endpoint ?uritext . BIND("LegalEntityWithoutDissolutionDateDate" AS ?metric) BIND(IRI(?uritext) as ?uri) BIND(UUID() AS ?task) BIND(CONCAT("""PREFIX : <urn:stirdata:> PREFIX legal: <http://www.w3.org/ns/legal#> PREFIX m8g: <http://data.europa.eu/m8g/> PREFIX stirdata: <https://w3id.org/stirdata/vocabulary/> PREFIX locn: <http://www.w3.org/ns/locn#> PREFIX adms: <http://www.w3.org/ns/adms#> PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> PREFIX schema: <https://schema.org/> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> PREFIX org: <http://www.w3.org/ns/org#> CONSTRUCT { <""",?uritext,"""> :""",?metric,"""Example ?example . } WHERE { { SELECT (SAMPLE(?resource) AS ?example) WHERE { ?resource a legal:LegalEntity . FILTER NOT EXISTS { ?resource schema:dissolutionDate ?date . FILTER(isLiteral(?date) && datatype(?date) = xsd:date) } } } }""") as ?query) }
PREFIX esl: <http://plugins.linkedpipes.com/ontology/e-sparqlEndpointList#> PREFIX : <urn:stirdata:> CONSTRUCT { ?task a esl:Task ; esl:query ?query ; esl:group ?uritext ; esl:endpoint ?uritext . } WHERE { ?s :endpoint ?uritext . BIND("numberOfLegalEntitiesWithCompanyType" AS ?metric) BIND(IRI(?uritext) as ?uri) BIND(UUID() AS ?task) BIND(CONCAT("""PREFIX : <urn:stirdata:> PREFIX legal: <http://www.w3.org/ns/legal#> PREFIX m8g: <http://data.europa.eu/m8g/> PREFIX stirdata: <https://w3id.org/stirdata/vocabulary/> PREFIX locn: <http://www.w3.org/ns/locn#> PREFIX adms: <http://www.w3.org/ns/adms#> PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> PREFIX schema: <https://schema.org/> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> CONSTRUCT { <""",?uritext,"""> :""",?metric,""" ?""",?metric,""" . } WHERE { { SELECT (COUNT(DISTINCT ?resource) AS ?""",?metric,""") WHERE { ?resource a legal:LegalEntity ; legal:companyType ?type . FILTER(isIRI(?type) && STRSTARTS(STR(?type),"https://w3id.org/stirdata/resource/companyType/item/")) } } }""") as ?query) }
PREFIX esl: <http://plugins.linkedpipes.com/ontology/e-sparqlEndpointList#> PREFIX : <urn:stirdata:> CONSTRUCT { ?task a esl:Task ; esl:query ?query ; esl:group ?uritext ; esl:endpoint ?uritext . } WHERE { ?s :endpoint ?uritext . BIND("numberOfLegalEntitiesWithLegalName" AS ?metric) BIND(IRI(?uritext) as ?uri) BIND(UUID() AS ?task) BIND(CONCAT("""PREFIX : <urn:stirdata:> PREFIX legal: <http://www.w3.org/ns/legal#> PREFIX m8g: <http://data.europa.eu/m8g/> PREFIX stirdata: <https://w3id.org/stirdata/vocabulary/> PREFIX locn: <http://www.w3.org/ns/locn#> CONSTRUCT { <""",?uritext,"""> :""",?metric,""" ?""",?metric,""" . } WHERE { { SELECT (COUNT(DISTINCT ?resource) AS ?""",?metric,""") WHERE { ?resource a legal:LegalEntity ; legal:legalName ?name . FILTER(isLiteral(?name) && STRLEN(?name) > 0) } } }""") as ?query) }
PREFIX esl: <http://plugins.linkedpipes.com/ontology/e-sparqlEndpointList#> PREFIX : <urn:stirdata:> CONSTRUCT { ?task a esl:Task ; esl:query ?query ; esl:group ?uritext ; esl:endpoint ?uritext . } WHERE { ?s :endpoint ?uritext . BIND("numberOfLegalEntitiesWithIdentifierAndIssuedDate" AS ?metric) BIND(IRI(?uritext) as ?uri) BIND(UUID() AS ?task) BIND(CONCAT("""PREFIX : <urn:stirdata:> PREFIX legal: <http://www.w3.org/ns/legal#> PREFIX m8g: <http://data.europa.eu/m8g/> PREFIX stirdata: <https://w3id.org/stirdata/vocabulary/> PREFIX locn: <http://www.w3.org/ns/locn#> PREFIX adms: <http://www.w3.org/ns/adms#> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> PREFIX dcterms: <http://purl.org/dc/terms/> PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> CONSTRUCT { <""",?uritext,"""> :""",?metric,""" ?""",?metric,""" . } WHERE { { SELECT (COUNT(DISTINCT ?resource) AS ?""",?metric,""") WHERE { ?resource a legal:LegalEntity ; legal:legalIdentifier ?identifier . ?identifier a adms:Identifier ; skos:notation ?value ; dcterms:issued ?issued . FILTER(isLiteral(?value)) FILTER(isLiteral(?issued) && datatype(?issued) = xsd:date) } } }""") as ?query) }
PREFIX esl: <http://plugins.linkedpipes.com/ontology/e-sparqlEndpointList#> PREFIX : <urn:stirdata:> CONSTRUCT { ?task a esl:Task ; esl:query ?query ; esl:group ?uritext ; esl:endpoint ?uritext . } WHERE { ?s :endpoint ?uritext . BIND("numberOfLegalEntitiesWithLinkToOfficialPages" AS ?metric) BIND(IRI(?uritext) as ?uri) BIND(UUID() AS ?task) BIND(CONCAT("""PREFIX : <urn:stirdata:> PREFIX legal: <http://www.w3.org/ns/legal#> PREFIX m8g: <http://data.europa.eu/m8g/> PREFIX stirdata: <https://w3id.org/stirdata/vocabulary/> PREFIX locn: <http://www.w3.org/ns/locn#> PREFIX adms: <http://www.w3.org/ns/adms#> PREFIX schema: <https://schema.org/> CONSTRUCT { <""",?uritext,"""> :""",?metric,""" ?""",?metric,""" . } WHERE { { SELECT (COUNT(DISTINCT ?resource) AS ?""",?metric,""") WHERE { ?resource a legal:LegalEntity ; schema:sameAs ?url . FILTER(isIRI(?url)) } } }""") as ?query) }
PREFIX esl: <http://plugins.linkedpipes.com/ontology/e-sparqlEndpointList#> PREFIX : <urn:stirdata:> CONSTRUCT { ?task a esl:Task ; esl:query ?query ; esl:group ?uritext ; esl:endpoint ?uritext . } WHERE { ?s :endpoint ?uritext . BIND("numberOfLegalEntitiesWithActivity" AS ?metric) BIND(IRI(?uritext) as ?uri) BIND(UUID() AS ?task) BIND(CONCAT("""PREFIX : <urn:stirdata:> PREFIX legal: <http://www.w3.org/ns/legal#> PREFIX m8g: <http://data.europa.eu/m8g/> PREFIX stirdata: <https://w3id.org/stirdata/vocabulary/> PREFIX locn: <http://www.w3.org/ns/locn#> PREFIX adms: <http://www.w3.org/ns/adms#> PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> PREFIX schema: <https://schema.org/> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> CONSTRUCT { <""",?uritext,"""> :""",?metric,""" ?""",?metric,""" . } WHERE { { SELECT (COUNT(DISTINCT ?resource) AS ?""",?metric,""") WHERE { ?resource a legal:LegalEntity ; legal:companyActivity ?activity . ?activity a stirdata:BusinessActivity, skos:Concept ; skos:prefLabel [] ; skos:notation [] ; skos:inScheme [] ; stirdata:level [] ; skos:exactMatch [] . } } }""") as ?query) }
PREFIX esl: <http://plugins.linkedpipes.com/ontology/e-sparqlEndpointList#> PREFIX : <urn:stirdata:> CONSTRUCT { ?task a esl:Task ; esl:query ?query ; esl:group ?uritext ; esl:endpoint ?uritext . } WHERE { ?s :endpoint ?uritext . BIND("numberOfLegalEntitiesWithLeiCode" AS ?metric) BIND(IRI(?uritext) as ?uri) BIND(UUID() AS ?task) BIND(CONCAT("""PREFIX : <urn:stirdata:> PREFIX legal: <http://www.w3.org/ns/legal#> PREFIX m8g: <http://data.europa.eu/m8g/> PREFIX stirdata: <https://w3id.org/stirdata/vocabulary/> PREFIX locn: <http://www.w3.org/ns/locn#> PREFIX adms: <http://www.w3.org/ns/adms#> CONSTRUCT { <""",?uritext,"""> :""",?metric,""" ?""",?metric,""" . } WHERE { { SELECT (COUNT(DISTINCT ?resource) AS ?""",?metric,""") WHERE { ?resource a legal:LegalEntity ; stirdata:leiCode ?leiCode . FILTER(isLiteral(?leiCode)) } } }""") as ?query) }
PREFIX esl: <http://plugins.linkedpipes.com/ontology/e-sparqlEndpointList#> PREFIX : <urn:stirdata:> CONSTRUCT { ?task a esl:Task ; esl:query ?query ; esl:group ?uritext ; esl:endpoint ?uritext . } WHERE { ?s :endpoint ?uritext . BIND("numberOfLegalEntitiesWithPostalAddress" AS ?metric) BIND(IRI(?uritext) as ?uri) BIND(UUID() AS ?task) BIND(CONCAT("""PREFIX : <urn:stirdata:> PREFIX legal: <http://www.w3.org/ns/legal#> PREFIX m8g: <http://data.europa.eu/m8g/> PREFIX stirdata: <https://w3id.org/stirdata/vocabulary/> PREFIX locn: <http://www.w3.org/ns/locn#> PREFIX adms: <http://www.w3.org/ns/adms#> PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> PREFIX schema: <https://schema.org/> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> PREFIX org: <http://www.w3.org/ns/org#> CONSTRUCT { <""",?uritext,"""> :""",?metric,""" ?""",?metric,""" . } WHERE { { SELECT (COUNT(DISTINCT ?resource) AS ?""",?metric,""") WHERE { ?resource a legal:LegalEntity ; stirdata:postalAddress ?address . ?address a locn:Address . } } }""") as ?query) }
PREFIX esl: <http://plugins.linkedpipes.com/ontology/e-sparqlEndpointList#> PREFIX m8g: <http://data.europa.eu/m8g/> PREFIX : <urn:stirdata:> CONSTRUCT { ?task a esl:Task ; esl:query ?query ; esl:group ?uritext ; esl:endpoint ?uritext . } WHERE { ?s :endpoint ?uritext . BIND("LegalEntityWithoutRegistrationDate" AS ?metric) BIND(IRI(?uritext) as ?uri) BIND(UUID() AS ?task) BIND(CONCAT("""PREFIX : <urn:stirdata:> PREFIX legal: <http://www.w3.org/ns/legal#> PREFIX m8g: <http://data.europa.eu/m8g/> PREFIX stirdata: <https://w3id.org/stirdata/vocabulary/> PREFIX locn: <http://www.w3.org/ns/locn#> PREFIX adms: <http://www.w3.org/ns/adms#> PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> PREFIX org: <http://www.w3.org/ns/org#> CONSTRUCT { <""",?uritext,"""> :""",?metric,"""Example ?example . } WHERE { { SELECT (SAMPLE(?resource) AS ?example) WHERE { ?resource a legal:LegalEntity . FILTER NOT EXISTS { ?resource m8g:registrationDate ?date . FILTER(isLiteral(?date) && datatype(?date) = xsd:date) } } } }""") as ?query) }
PREFIX : <urn:stirdata:> INSERT { ?s :AdditionalMetadataPresent ?present . } WHERE { ?s :numberOfLegalEntities [] . BIND( EXISTS {?s :AdditionalMetadataCountry [] } && EXISTS {?s :AdditionalMetadataSource [] } && EXISTS {?s :AdditionalMetadataModified [] } AS ?present) }
PREFIX esl: <http://plugins.linkedpipes.com/ontology/e-sparqlEndpointList#> PREFIX : <urn:stirdata:> CONSTRUCT { ?task a esl:Task ; esl:query ?query ; esl:group ?uritext ; esl:endpoint ?uritext . } WHERE { ?s :endpoint ?uritext . BIND("numberOfLegalEntitiesWithTelephone" AS ?metric) BIND(IRI(?uritext) as ?uri) BIND(UUID() AS ?task) BIND(CONCAT("""PREFIX : <urn:stirdata:> PREFIX legal: <http://www.w3.org/ns/legal#> PREFIX m8g: <http://data.europa.eu/m8g/> PREFIX stirdata: <https://w3id.org/stirdata/vocabulary/> PREFIX locn: <http://www.w3.org/ns/locn#> PREFIX adms: <http://www.w3.org/ns/adms#> PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> PREFIX schema: <https://schema.org/> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> CONSTRUCT { <""",?uritext,"""> :""",?metric,""" ?""",?metric,""" . } WHERE { { SELECT (COUNT(DISTINCT ?resource) AS ?""",?metric,""") WHERE { ?resource a legal:LegalEntity ; schema:telephone [] . } } }""") as ?query) }
PREFIX esl: <http://plugins.linkedpipes.com/ontology/e-sparqlEndpointList#> PREFIX : <urn:stirdata:> CONSTRUCT { ?task a esl:Task ; esl:query ?query ; esl:group ?uritext ; esl:endpoint ?uritext . } WHERE { ?s :endpoint ?uritext . BIND("numberOfLegalEntitiesWithSecondaryActivity" AS ?metric) BIND(IRI(?uritext) as ?uri) BIND(UUID() AS ?task) BIND(CONCAT("""PREFIX : <urn:stirdata:> PREFIX legal: <http://www.w3.org/ns/legal#> PREFIX m8g: <http://data.europa.eu/m8g/> PREFIX stirdata: <https://w3id.org/stirdata/vocabulary/> PREFIX locn: <http://www.w3.org/ns/locn#> PREFIX adms: <http://www.w3.org/ns/adms#> PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> PREFIX schema: <https://schema.org/> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> CONSTRUCT { <""",?uritext,"""> :""",?metric,""" ?""",?metric,""" . } WHERE { { SELECT (COUNT(DISTINCT ?resource) AS ?""",?metric,""") WHERE { ?resource a legal:LegalEntity ; stirdata:secondaryActivity ?activity . ?activity a stirdata:BusinessActivity, skos:Concept ; skos:prefLabel [] ; skos:notation [] ; skos:inScheme [] ; stirdata:level [] ; skos:exactMatch [] . } } }""") as ?query) }
PREFIX esl: <http://plugins.linkedpipes.com/ontology/e-sparqlEndpointList#> PREFIX : <urn:stirdata:> CONSTRUCT { ?task a esl:Task ; esl:query ?query ; esl:group ?uritext ; esl:endpoint ?uritext . } WHERE { ?s :endpoint ?uritext . BIND("numberOfLegalEntities" AS ?metric) BIND(UUID() AS ?task) BIND(IRI(?uritext) as ?uri) BIND(CONCAT("""PREFIX : <urn:stirdata:> PREFIX legal: <http://www.w3.org/ns/legal#> PREFIX m8g: <http://data.europa.eu/m8g/> PREFIX stirdata: <https://w3id.org/stirdata/vocabulary/> PREFIX locn: <http://www.w3.org/ns/locn#> CONSTRUCT { <""",?uritext,"""> :""",?metric,""" ?""",?metric,""" . } WHERE { { SELECT (COUNT(DISTINCT ?resource) AS ?""",?metric,""") WHERE { ?resource a legal:LegalEntity. } } }""") as ?query) }
PREFIX dcterms: <http://purl.org/dc/terms/> PREFIX stir: <urn:stirdata:> SELECT * WHERE { ?endpointURL dcterms:title ?title ; stir:numberOfLegalEntities ?numberOfLegalEntities; stir:allLegalEntitiesHaveIdentifier ?allLegalEntitiesHaveIdentifier ; stir:numberOfLegalEntitiesWithIdentifier ?numberOfLegalEntitiesWithIdentifier ; stir:allLegalEntitiesHaveLegalName ?allLegalEntitiesHaveLegalName ; stir:numberOfLegalEntitiesWithLegalName ?numberOfLegalEntitiesWithLegalName ; stir:AdditionalMetadataPresent ?AdditionalMetadataPresent . } ORDER BY DESC(?numberOfLegalEntities)
PREFIX esl: <http://plugins.linkedpipes.com/ontology/e-sparqlEndpointList#> PREFIX : <urn:stirdata:> CONSTRUCT { ?task a esl:Task ; esl:query ?query ; esl:group ?uritext ; esl:endpoint ?uritext . } WHERE { ?s :endpoint ?uritext . BIND("LegalEntityWithoutAdministrativeUnit" AS ?metric) BIND(IRI(?uritext) as ?uri) BIND(UUID() AS ?task) BIND(CONCAT("""PREFIX : <urn:stirdata:> PREFIX legal: <http://www.w3.org/ns/legal#> PREFIX m8g: <http://data.europa.eu/m8g/> PREFIX stirdata: <https://w3id.org/stirdata/vocabulary/> PREFIX locn: <http://www.w3.org/ns/locn#> PREFIX adms: <http://www.w3.org/ns/adms#> PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> PREFIX schema: <https://schema.org/> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> PREFIX org: <http://www.w3.org/ns/org#> CONSTRUCT { <""",?uritext,"""> :""",?metric,"""Example ?example . } WHERE { { SELECT (SAMPLE(?resource) AS ?example) WHERE { ?resource a legal:LegalEntity . FILTER NOT EXISTS { ?resource #legal:registeredAddress|stirdata:postalAddress|stirdata:streetAddress|((org:hasRegisteredSite|org:hasSite)/org:siteAddress) ?address . #(org:hasRegisteredSite|org:hasSite)/org:siteAddress ?address . org:hasRegisteredSite/org:siteAddress ?address . ?address a locn:Address ; m8g:adminUnit ?adminUnit . ?adminUnit a m8g:AdminUnit ; m8g:level ?level ; m8g:code ?adminUnit . FILTER(isIRI(?level) && STRSTARTS(STR(?level), "https://w3id.org/stirdata/resource/adminUnitLevel")) } } } }""") as ?query) }
PREFIX esl: <http://plugins.linkedpipes.com/ontology/e-sparqlEndpointList#> PREFIX : <urn:stirdata:> CONSTRUCT { ?task a esl:Task ; esl:query ?query ; esl:group ?uritext ; esl:endpoint ?uritext . } WHERE { ?s :endpoint ?uritext . BIND("numberOfLegalEntitiesWithTaxIdentifierAndIssuedDate" AS ?metric) BIND(IRI(?uritext) as ?uri) BIND(UUID() AS ?task) BIND(CONCAT("""PREFIX : <urn:stirdata:> PREFIX legal: <http://www.w3.org/ns/legal#> PREFIX m8g: <http://data.europa.eu/m8g/> PREFIX stirdata: <https://w3id.org/stirdata/vocabulary/> PREFIX locn: <http://www.w3.org/ns/locn#> PREFIX adms: <http://www.w3.org/ns/adms#> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> PREFIX dcterms: <http://purl.org/dc/terms/> PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> CONSTRUCT { <""",?uritext,"""> :""",?metric,""" ?""",?metric,""" . } WHERE { { SELECT (COUNT(DISTINCT ?resource) AS ?""",?metric,""") WHERE { ?resource a legal:LegalEntity ; stirdata:taxIdentifier ?identifier . ?identifier a adms:Identifier ; skos:notation ?value ; dcterms:issued ?issued . FILTER(isLiteral(?value)) FILTER(isLiteral(?issued) && datatype(?issued) = xsd:date) } } }""") as ?query) }
PREFIX esl: <http://plugins.linkedpipes.com/ontology/e-sparqlEndpointList#> PREFIX : <urn:stirdata:> CONSTRUCT { ?task a esl:Task ; esl:query ?query ; esl:group ?uritext ; esl:endpoint ?uritext . } WHERE { ?s :endpoint ?uritext . BIND("LegalEntityWithoutLegalName" AS ?metric) BIND(IRI(?uritext) as ?uri) BIND(UUID() AS ?task) BIND(CONCAT("""PREFIX : <urn:stirdata:> PREFIX legal: <http://www.w3.org/ns/legal#> PREFIX m8g: <http://data.europa.eu/m8g/> PREFIX stirdata: <https://w3id.org/stirdata/vocabulary/> PREFIX locn: <http://www.w3.org/ns/locn#> CONSTRUCT { <""",?uritext,"""> :""",?metric,"""Example ?example . } WHERE { { SELECT (SAMPLE(?resource) AS ?example) WHERE { ?resource a legal:LegalEntity . FILTER NOT EXISTS { ?resource legal:legalName ?name . FILTER(isLiteral(?name) && STRLEN(?name) > 0) } } } }""") as ?query) }