Talk:Q55003547

Source

Dates are from Wikidata:News or edit history of lexeme.

Queries

Milestone chart over time

• Items used: LID milestone (Q55003547)   

• Properties used: quantity (P1114)   , point in time (P585)   

#defaultView:LineChart
# by Jura1, 2018-07-15
SELECT ?date ?lid (URI(CONCAT("https://www.wikidata.org/w/index.php?title=Lexeme:L",str(?lid),"&action=history")) as ?check)
WHERE
{
  wd:Q55003547 p:P1114 [ ps:P1114 ?lid ; pq:P585 ?date ]
}
ORDER BY ?lid

Try it!

Lexemes in Latin by creation date

• Items used: Latin (Q397)   , LID milestone (Q55003547)   

• Properties used: quantity (P1114)   , point in time (P585)   

PREFIX llang:   <http://purl.org/dc/terms/language>
# by Jura1, 2020-03-28
# Number of lexemes in Latin created at a given milestone
#defaultView:AreaChart
SELECT ?date ?cumulativecount 
{
    hint:Query hint:optimizer "None".
    {   SELECT ?milestonep (COUNT(?lexeme) as ?cumulativecount)
        WHERE
        {
          { SELECT DISTINCT ?lexeme { ?lexeme llang: wd:Q397 }  LIMIT 190000 }
          BIND( xsd:integer( substr(str(?lexeme), 33)) as ?lid)
          wd:Q55003547 p:P1114 ?milestonep .
          ?milestonep ps:P1114 ?milestone .
          FILTER( ?milestone > ?lid ) 
        }
        GROUP BY ?milestonep
    }          
    ?milestonep pq:P585 ?date
}

Try it!

See also

• QID milestone (Q38074555) (talk)
• PID milestone (Q73616850) (talk)
• EID milestone (Q115255107) (talk)
• edit number milestone (Q66002030) (talk)

Discussion

Too fast creation

As there is no time precision finer than day, multiple values per 1 date are ruining visualisation, so I deleted them. --Infovarius (talk) 15:12, 22 November 2019 (UTC)

Ok for me even if it would be mainly for defaultView:LineChart . I don't have a better solution for now.--- Jura 15:26, 22 November 2019 (UTC)