Ranking & Scoring - SPARQLqueries

Wikidata Quality Signals

Wikidata provides built-in metrics that indicate entity importance and data quality.

Property	Meaning	Higher = ?
`wikibase:sitelinks`	Wikipedia articles linking to entity	More notable
`wikibase:statements`	Number of statements on entity	Better documented
`wikibase:identifiers`	Number of external IDs	Better linked

Basic Ranking

Programming Languages by Notability

Run ↗

SELECT ?lang ?langLabel ?sitelinks
WHERE {
  ?lang wdt:P31 wd:Q9143 ;
        wikibase:sitelinks ?sitelinks .

  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "en" .
  }
}
ORDER BY DESC(?sitelinks)
LIMIT 30

Pattern Simple ranking by sitelinks

Museums by Documentation Quality

Run ↗

SELECT ?museum ?museumLabel ?statements ?identifiers
WHERE {
  ?museum wdt:P31/wdt:P279* wd:Q33506 ;  # museum
          wikibase:statements ?statements ;
          wikibase:identifiers ?identifiers .

  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "en" .
  }
}
ORDER BY DESC(?statements)
LIMIT 30

Pattern Domain: Cultural Heritage

Composite Scoring

Weighted Score Formula

Run ↗

SELECT ?lang ?langLabel
       ?sitelinks ?statements ?identifiers
       (?sitelinks * 3 + ?statements + ?identifiers * 2 AS ?score)
WHERE {
  ?lang wdt:P31 wd:Q9143 ;
        wikibase:sitelinks ?sitelinks ;
        wikibase:statements ?statements ;
        wikibase:identifiers ?identifiers .

  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "en" .
  }
}
ORDER BY DESC(?score)
LIMIT 30

Pattern Formula: sitelinks×3 + statements + identifiers×2

Normalized Scores (0-100)

Run ↗

SELECT ?lang ?langLabel ?sitelinks
       (ROUND(?sitelinks * 100.0 / 350) AS ?normalizedScore)
WHERE {
  ?lang wdt:P31 wd:Q9143 ;
        wikibase:sitelinks ?sitelinks .

  # Only include languages with some notability
  FILTER(?sitelinks > 10)

  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "en" .
  }
}
ORDER BY DESC(?normalizedScore)
LIMIT 30

Pattern Normalized to 0-100 scale (assuming max ~350)

Domain-Specific Ranking

Cities by Population and Notability

Run ↗

SELECT ?city ?cityLabel ?pop ?sitelinks
       (?pop / 10000 + ?sitelinks * 10 AS ?score)
WHERE {
  ?city wdt:P31/wdt:P279* wd:Q515 ;  # city
        wdt:P17 wd:Q142 ;              # France
        wdt:P1082 ?pop ;
        wikibase:sitelinks ?sitelinks .

  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "en" .
  }
}
ORDER BY DESC(?score)
LIMIT 30

Pattern Domain: Urban | Combine population + notability

Programming Languages by Relationship Count

Run ↗

SELECT ?lang ?langLabel
       (COUNT(DISTINCT ?influenced) AS ?influenceCount)
WHERE {
  ?lang wdt:P31 wd:Q9143 .

  # Count languages this one influenced
  OPTIONAL { ?influenced wdt:P737 ?lang . }

  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "en" .
  }
}
GROUP BY ?lang ?langLabel
ORDER BY DESC(?influenceCount)
LIMIT 30

Pattern Rank by incoming relationships (P737 influenced by)

Recency-Based Ranking

Most Recently Created Languages

Run ↗

SELECT ?lang ?langLabel ?inception
       (YEAR(NOW()) - YEAR(?inception) AS ?age)
WHERE {
  ?lang wdt:P31 wd:Q9143 ;
        wdt:P571 ?inception .

  # Only languages created in last 20 years
  FILTER(?inception >= "2005-01-01"^^xsd:dateTime)

  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "en" .
  }
}
ORDER BY DESC(?inception)
LIMIT 30

Pattern Rank by recency (P571 inception date)

Tiered Rankings

Categorize into Tiers

Run ↗

SELECT ?lang ?langLabel ?sitelinks ?tier
WHERE {
  ?lang wdt:P31 wd:Q9143 ;
        wikibase:sitelinks ?sitelinks .

  BIND(
    IF(?sitelinks >= 200, "Tier 1: Major",
      IF(?sitelinks >= 50, "Tier 2: Notable",
        IF(?sitelinks >= 10, "Tier 3: Minor",
          "Tier 4: Obscure")))
    AS ?tier)

  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "en" .
  }
}
ORDER BY ?tier DESC(?sitelinks)
LIMIT 50

Pattern Nested IF for tier assignment

Ranking Strategies

Strategy	Use Case	Approach
Sitelinks	General notability	Higher = more Wikipedia coverage
Statements	Data quality	More data = better documented
Relationships	Network importance	Count incoming/outgoing links
Recency	Freshness	Sort by date properties
Domain metrics	Specific relevance	Population, citations, etc.
Composite	Balanced ranking	Weighted combination