Difference between revisions of "Workdocumentation 2021-05-10"
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...") |
|||
| (4 intermediate revisions 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> | ||
| + | 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]] | ||
Latest revision as of 20: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