CODE AVAILABILITY

Kinds of metadata and its description:
SELECT metadata_field_id, element FROM metadatafieldregistry;

Validate the information by repository:
SELECT p1.metadata_field_id, count(*) FROM metadatavalue as p1, collection2item as p2 WHERE p1.dspace_object_id = p2.item_id AND p2.collection_id = 'b516b2f4-deac-41d6-97ec-fff2bfd1da34' GROUP BY p1.metadata_field_id;

All of kinds occurrences on C3data database:
SELECT p1.metadata_field_id, count(*) FROM metadatavalue as p1, collection2item as p2 WHERE p1.dspace_object_id = p2.item_id AND p2.collection_id = 'b516b2f4-deac-41d6-97ec-fff2bfd1da34' GROUP BY p1.metadata_field_id;


---

Observation: the COUNT result list is in the "COUNT_metadata" file in that dataset (https://dx.doi.org/10.5380/bdc/94)