Workdocumentation 2021-05-10: Difference between revisions

From BITPlan cr Wiki
Jump to navigation Jump to search
(Created page with "= PTP Event Corpus = == Year availability == <source lang='sql'> select yearavailable,allCount,yearavailable*100/allCount from (select count(*) as yearavailable from event wh...")
 
No edit summary
Line 6: Line 6:
(select count(*) as allCount from event)
(select count(*) as allCount from event)
</source>
</source>
89% of event records have a year property that is not null

Revision as of 06:20, 10 May 2021

PTP Event Corpus

Year availability

select yearavailable,allCount,yearavailable*100/allCount from 
(select count(*) as yearavailable from event where year is not null), 
(select count(*) as allCount from event)

89% of event records have a year property that is not null