reteplayground
Aggregate

⚖️ Licensing practice by sector

SectorRepos (non-fork)With a licence+2
IT @en54342570
ResearchAndEducation @en35961513
Others @en503311
Media @en445176
Run this query → no server · no download · no account
caviri.github.io/rete
Run this query in the playground → 14 rows · 1.0 s · 5.0 MB of 30.7 MB read over HTTP range · no server, no download — the query runs in your browser.

The query

PREFIX ossb: <https://w3id.org/rete/oss-benchmark#> PREFIX pulse: <https://open-pulse.epfl.ch/ontology#> PREFIX gme: <https://openpulse.science/git-metadata-extractor#> PREFIX org: <http://www.w3.org/ns/org#> PREFIX schema: <http://schema.org/> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> SELECT ?sector (COUNT(DISTINCT ?repo) AS ?repos) (COUNT(DISTINCT ?lr) AS ?licensed) (COUNT(DISTINCT ?pr) AS ?permissive) (COUNT(DISTINCT ?cr) AS ?copyleft) WHERE { ?i a ossb:Institution ; ossb:sector ?s . ?s skos:prefLabel ?sector . ?o org:unitOf ?i . ?repo pulse:ownedBy ?o ; ossb:isFork false . OPTIONAL { ?repo schema:license ?anyl . BIND(?repo AS ?lr) } OPTIONAL { ?repo schema:license ?pl . FILTER(?pl IN (<https://spdx.org/licenses/MIT>,<https://spdx.org/licenses/Apache-2.0>,<https://spdx.org/licenses/BSD-3-Clause>,<https://spdx.org/licenses/ISC>)) BIND(?repo AS ?pr) } OPTIONAL { ?repo schema:license ?cl . FILTER(?cl IN (<https://spdx.org/licenses/GPL-3.0-only>,<https://spdx.org/licenses/AGPL-3.0-only>,<https://spdx.org/licenses/GPL-2.0-only>,<https://spdx.org/licenses/LGPL-3.0-only>)) BIND(?repo AS ?cr) } } GROUP BY ?sector ORDER BY DESC(?repos)

rete playground · documentation · github.com/caviri/rete