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

From BITPlan cr Wiki
Jump to navigation Jump to search
 
(One intermediate revision by the same user not shown)
Line 1: Line 1:
 +
{{WorkSequence|prev=Workdocumentation 2021-05-03|next=Workdocumentation 2023-01-01}}
 
= PTP Event Corpus =
 
= PTP Event Corpus =
 
== Year availability ==
 
== Year availability ==
Line 6: Line 7:
 
(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]]

Latest revision as of 21:23, 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