Collecting requirements for webservices as ETL tools for covidgraph

[amalic]

I was thinking to create a personByNameQuery OpenApi web service. Here's the information we can get out of SciGraph.

One of the ideas is to perform variations of queries by first and last name. Curious to hear what you think.

Some stats

Persons
7008483

Attribute count of instances of the Person class

Properties of Person	count
rdf:type	7008483
sg:sdDataset	7008483
schema:familyName	7008474
schema:givenName	6994866
schema:sameAs	7631920
schema:sdDatePublished	7008485
schema:sdLicense	7008483
schema:sdPublisher	7008485
sg:sdSource	7008485
schema:affiliation	8078374
schema:identifier	621560

Persons affiliations by type

Affiliation Type	count
schema:OrganizationRole	3946090
foaf:Organization	4132268
grid:Education	2204569
schema:Organization	4132284
grid:Government	216941
grid:Archive	7382
grid:Facility	353385
grid:Healthcare	1124019
grid:Other	26129
grid:Nonprofit	123332
grid:Company	71459

and their properties

And here the affiliations and their property count

Affiliation Type	properties	count
schema:Organization	schema:name	7008485
schema:Organization	scigraph:sdDataset	45269
schema:Organization	vivo:abbreviation	18501
schema:Organization	grid:crossrefFunderId	7867
schema:Organization	grid:establishedYear	34302
schema:Organization	grid:hasAddress	45269
schema:Organization	grid:hasChild	10079
schema:Organization	grid:hasParent	8742
schema:Organization	grid:hasRelated	5972
schema:Organization	grid:hasWikidataId	12884
schema:Organization	grid:id	45269
schema:Organization	grid:isni	24469
schema:Organization	grid:ukprn	155
schema:Organization	grid:wikipediaPage	16546
schema:Organization	rdf:type	7143639
schema:Organization	rdfs:label	45269
schema:Organization	skos:altLabel	11144
schema:Organization	skos:prefLabel	45269
schema:Organization	foaf:homepage	38367
schema:OrganizationRole	schema:affiliation	3946090
schema:OrganizationRole	scigraph:isCurrent	3946090
schema:OrganizationRole	rdf:type	3946090
grid:Archive	scigraph:sdDataset	2239
grid:Archive	vivo:abbreviation	506
grid:Archive	grid:crossrefFunderId	99
grid:Archive	grid:establishedYear	1373
grid:Archive	grid:hasAddress	2239
grid:Archive	grid:hasChild	16
grid:Archive	grid:hasParent	83
grid:Archive	grid:hasRelated	8
grid:Archive	grid:hasWikidataId	172
grid:Archive	grid:id	2239
grid:Archive	grid:isni	975
grid:Archive	grid:wikipediaPage	909
grid:Archive	rdf:type	4993
grid:Archive	rdfs:label	2239
grid:Archive	skos:altLabel	443
grid:Archive	skos:prefLabel	2239
grid:Archive	foaf:homepage	1509
grid:Company	scigraph:sdDataset	24302
grid:Company	vivo:abbreviation	2330
grid:Company	grid:crossrefFunderId	1108
grid:Company	grid:establishedYear	16374
grid:Company	grid:hasAddress	24302
grid:Company	grid:hasChild	1374
grid:Company	grid:hasParent	1379
grid:Company	grid:hasRelated	205
grid:Company	grid:hasWikidataId	892
grid:Company	grid:id	24302
grid:Company	grid:isni	4307
grid:Company	grid:wikipediaPage	4677
grid:Company	rdf:type	58006
grid:Company	rdfs:label	24302
grid:Company	skos:altLabel	2625
grid:Company	skos:prefLabel	24302
grid:Company	foaf:homepage	18237
grid:Education	scigraph:sdDataset	17952
grid:Education	vivo:abbreviation	7183
grid:Education	grid:crossrefFunderId	3424
grid:Education	grid:establishedYear	12203
grid:Education	grid:hasAddress	17952
grid:Education	grid:hasChild	2540
grid:Education	grid:hasParent	1159
grid:Education	grid:hasRelated	3003
grid:Education	grid:hasWikidataId	11088
grid:Education	grid:id	17952
grid:Education	grid:isni	10177
grid:Education	grid:ukprn	169
grid:Education	grid:wikipediaPage	9182
grid:Education	rdf:type	46744
grid:Education	rdfs:label	17952
grid:Education	skos:altLabel	5396
grid:Education	skos:prefLabel	17952
grid:Education	foaf:homepage	12747
grid:Facility	scigraph:sdDataset	7217
grid:Facility	vivo:abbreviation	5319
grid:Facility	grid:crossrefFunderId	584
grid:Facility	grid:establishedYear	6171
grid:Facility	grid:hasAddress	7217
grid:Facility	grid:hasChild	574
grid:Facility	grid:hasParent	4966
grid:Facility	grid:hasRelated	215
grid:Facility	grid:hasWikidataId	701
grid:Facility	grid:id	7217
grid:Facility	grid:isni	3917
grid:Facility	grid:wikipediaPage	1253
grid:Facility	rdf:type	19950
grid:Facility	rdfs:label	7217
grid:Facility	skos:altLabel	2293
grid:Facility	skos:prefLabel	7217
grid:Facility	foaf:homepage	7156
grid:Government	scigraph:sdDataset	5173
grid:Government	vivo:abbreviation	3064
grid:Government	grid:crossrefFunderId	1999
grid:Government	grid:establishedYear	3683
grid:Government	grid:hasAddress	5173
grid:Government	grid:hasChild	4360
grid:Government	grid:hasParent	1118
grid:Government	grid:hasRelated	104
grid:Government	grid:hasWikidataId	764
grid:Government	grid:id	5173
grid:Government	grid:isni	2600
grid:Government	grid:ukprn	1
grid:Government	grid:wikipediaPage	2269
grid:Government	rdf:type	13014
grid:Government	rdfs:label	5173
grid:Government	skos:altLabel	1225
grid:Government	skos:prefLabel	5173
grid:Government	foaf:homepage	4930
grid:Healthcare	scigraph:sdDataset	12081
grid:Healthcare	vivo:abbreviation	2454
grid:Healthcare	grid:crossrefFunderId	380
grid:Healthcare	grid:establishedYear	8078
grid:Healthcare	grid:hasAddress	12081
grid:Healthcare	grid:hasChild	1706
grid:Healthcare	grid:hasParent	1968
grid:Healthcare	grid:hasRelated	2553
grid:Healthcare	grid:hasWikidataId	2569
grid:Healthcare	grid:id	12081
grid:Healthcare	grid:isni	6131
grid:Healthcare	grid:wikipediaPage	3020
grid:Healthcare	rdf:type	33861
grid:Healthcare	rdfs:label	12081
grid:Healthcare	skos:altLabel	2421
grid:Healthcare	skos:prefLabel	12081
grid:Healthcare	foaf:homepage	10110
grid:Nonprofit	scigraph:sdDataset	9934
grid:Nonprofit	vivo:abbreviation	5722
grid:Nonprofit	grid:crossrefFunderId	3704
grid:Nonprofit	grid:establishedYear	8975
grid:Nonprofit	grid:hasAddress	9934
grid:Nonprofit	grid:hasChild	395
grid:Nonprofit	grid:hasParent	220
grid:Nonprofit	grid:hasRelated	116
grid:Nonprofit	grid:hasWikidataId	331
grid:Nonprofit	grid:id	9934
grid:Nonprofit	grid:isni	4435
grid:Nonprofit	grid:wikipediaPage	2819
grid:Nonprofit	rdf:type	23666
grid:Nonprofit	rdfs:label	9934
grid:Nonprofit	skos:altLabel	1665
grid:Nonprofit	skos:prefLabel	9934
grid:Nonprofit	foaf:homepage	9902
grid:Other	scigraph:sdDataset	6686
grid:Other	vivo:abbreviation	3918
grid:Other	grid:crossrefFunderId	1342
grid:Other	grid:establishedYear	5476
grid:Other	grid:hasAddress	6686
grid:Other	grid:hasChild	76
grid:Other	grid:hasParent	238
grid:Other	grid:hasRelated	50
grid:Other	grid:hasWikidataId	182
grid:Other	grid:id	6686
grid:Other	grid:isni	2645
grid:Other	grid:ukprn	1
grid:Other	grid:wikipediaPage	1382
grid:Other	rdf:type	15555
grid:Other	rdfs:label	6686
grid:Other	skos:altLabel	1323
grid:Other	skos:prefLabel	6686
grid:Other	foaf:homepage	6648
foaf:Organization	scigraph:sdDataset	88628
foaf:Organization	vivo:abbreviation	30535
foaf:Organization	grid:crossrefFunderId	12648
foaf:Organization	grid:establishedYear	62361
foaf:Organization	grid:hasAddress	88628
foaf:Organization	grid:hasChild	11149
foaf:Organization	grid:hasParent	11149
foaf:Organization	grid:hasRelated	6270
foaf:Organization	grid:hasWikidataId	16849
foaf:Organization	grid:id	88628
foaf:Organization	grid:isni	35199
foaf:Organization	grid:ukprn	172
foaf:Organization	grid:wikipediaPage	25520
foaf:Organization	rdf:type	219481
foaf:Organization	rdfs:label	88628
foaf:Organization	skos:altLabel	17407
foaf:Organization	skos:prefLabel	88628
foaf:Organization	foaf:homepage	71281