Difference between revisions of "Workdocumentation 2021-05-10"

From BITPlan cr Wiki
Jump to navigation Jump to search
Line 7: Line 7:
 
</source>
 
</source>
 
89% of event records have a year property that is not null
 
89% of event records have a year property that is not null
 +
[[Category:Workdocumentation]]

Revision as of 19:56, 22 June 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