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...") |
|||
| 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 08: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