One idea: You can play with the github dataset in ClickHouse playground. This is just a quick sql query to look for the DOI number pattern mentioned in any com

One idea: You can play with the github dataset in ClickHouse playground. This is just a quick sql query to look for the DOI number pattern mentioned in any comment on repositories: https://play.clickhouse.com/play?user=play#c2VsZWN0IHJlcG9fbmFtZSxldmVudF90eXBlLGJvZHkgZnJvbSBnaXRodWJfZXZlbnRzIHdoZXJlIGV2ZW50X3R5cGUgaW4gKCdJc3N1ZUNvbW1lbnRFdmVudCcsJ0lzc3Vlc0V2ZW50JywnUHVsbFJlcXVlc3RFdmVudCcsJ1B1bGxSZXF1ZXN0UmV2aWV3Q29tbWVudEV2ZW50JykgYW5kIG1hdGNoIChib2R5LCcuKjEwXC5cZHs0LDl9XC9bLVwuXzsoKVwvOkEtWjAtOV0rLionKSBsaW1pdCAxMA== https://play.clickhouse.com/play?user=play#c2VsZWN0IHJlcG9fb... ``` select repo_name,event_type,body from github_events where event_type in ('IssueCommentEvent','IssuesEvent','PullRequestEvent','PullRequestReviewCommentEvent') and match (body,'.10\.\d{4,9}\/[-\._;()\/:A-Z0-9]+.') limit 10 ``` perhaps you can extend on that :)