ConferenceCorpus/statistics
Jump to navigation
Jump to search
Ordinal histogramms
ceurws
orbackup
orclonebackup
confref
gnd
wikicfp
or
orclone
tibkat
dblp
crossref
wikidata
Eventseries completeness
wikidata
sql query
SELECT
eventInSeriesId,
min(ordinal) as minOrdinal,
max(ordinal) as maxOrdinal,
avg(ordinal) as avgOrdinal,
max(Ordinal)-min(Ordinal) as available,
(max(Ordinal)-min(Ordinal)) /(max(Ordinal)-1.0) as completeness
FROM event_wikidata
Where ordinal is not null
group by eventInSeriesId
order by 6 desc