Workdocumentation 2021-05-10: Difference between revisions

From BITPlan cr Wiki
Jump to navigation Jump to search
No edit summary
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
2021-05-10: 89% of event records have a year property that is not null
2023-01-01: 70%
<pre>
1242839 1759954 70
</pre>
[[Category:Research]][[Category:Experiment]]
[[Category:Research]][[Category:Experiment]]

Revision as of 19:21, 1 January 2023

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)

2021-05-10: 89% of event records have a year property that is not null 2023-01-01: 70%

 1242839 	1759954 	70