🔍 Published vs crawled repo counts (data-quality audit)

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 ?institution ?publishedRepos (COUNT(DISTINCT ?repo) AS ?derivedRepos) (COUNT(DISTINCT ?repo) - ?publishedRepos AS ?drift) WHERE { ?i a ossb:Institution ; schema:name ?institution ; ossb:numRepos ?publishedRepos . ?o org:unitOf ?i . ?repo pulse:ownedBy ?o . } GROUP BY ?institution ?publishedRepos ORDER BY ?drift LIMIT 20