Workdocumentation 2021-05-10


Wolfgang Fahl

PTP Event Corpus

PTP Event Corpus[edit]

Year availability[edit]

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 

Year availability[edit]

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 
🖨 🚪