Category variable name
metai
Chart type
Series variable name
iregistruota
isregistruota
Title
Legal entities registered and deregistereden
Įregistruoti ir išregistruoti juridiniai asmenyslt
Text
PREFIX schema: <https://schema.org/>

# The year is a string so the chart draws it as a category axis (a number axis would
# print "1,994").
SELECT ?metai (SUM(?registered) AS ?iregistruota) (SUM(?deregistered) AS ?isregistruota)
WHERE
{
    {
        GRAPH ?graph { ?entity schema:foundingDate ?date }
        BIND(1 AS ?registered)
        BIND(0 AS ?deregistered)
    }
    UNION
    {
        GRAPH ?graph { ?entity schema:dissolutionDate ?date }
        BIND(0 AS ?registered)
        BIND(1 AS ?deregistered)
    }
    BIND(YEAR(?date) AS ?year)
    FILTER(?year >= 1990)
    BIND(STR(?year) AS ?metai)
}
GROUP BY ?year ?metai
ORDER BY ?year
Title
Legal entities registered and deregistered per yearen
Įregistruoti ir išregistruoti juridiniai asmenys pagal metuslt