DOI: 10.15468/dl.bwqc7p
title: Occurrence Download

description: A dataset containing 386 records in GBIF matching the query:
SELECT
 hostingOrganizationKey,
 COUNT(*) AS total_records,
 SUM(CASE WHEN COALESCE(CONCAT_WS(' | ', recordedByID), '') &lt;&gt; '' THEN 1 ELSE 0 END) AS records_with_recordedByID,
 100.0 * SUM(CASE WHEN COALESCE(CONCAT_WS(' | ', recordedByID), '') &lt;&gt; '' THEN 1 ELSE 0 END) / COUNT(*) AS pct_with_recordedByID,
 SUM(CASE WHEN (
 GBIF_StringArrayLike(recordedByID, 'https://orcid.org/%', true) OR
 GBIF_StringArrayLike(recordedByID, 'http://scholar.google.com/citations?user=%', true) OR
 GBIF_StringArrayLike(recordedByID, 'http://www.researcherid.com/rid/%', true) OR
 GBIF_StringArrayLike(recordedByID, 'http://www.wikidata.org/entity/%', true) OR
 GBIF_StringArrayLike(recordedByID, 'https://www.linkedin.com/profile/view?id=%', true)
 ) THEN 1 ELSE 0 END) AS records_with_valid_recordedByID,
 100.0 * SUM(CASE WHEN (
 GBIF_StringArrayLike(recordedByID, 'https://orcid.org/%', true) OR
 GBIF_StringArrayLike(recordedByID, 'http://scholar.google.com/citations?user=%', true) OR
 GBIF_StringArrayLike(recordedByID, 'http://www.researcherid.com/rid/%', true) OR
 GBIF_StringArrayLike(recordedByID, 'http://www.wikidata.org/entity/%', true) OR
 GBIF_StringArrayLike(recordedByID, 'https://www.linkedin.com/profile/view?id=%', true)
 ) THEN 1 ELSE 0 END) / COUNT(*) AS pct_valid_recordedByID,
 SUM(CASE WHEN COALESCE(CONCAT_WS(' | ', recordedByID), '') &lt;&gt; '' AND NOT (
 GBIF_StringArrayLike(recordedByID, 'https://orcid.org/%', true) OR
 GBIF_StringArrayLike(recordedByID, 'http://scholar.google.com/citations?user=%', true) OR
 GBIF_StringArrayLike(recordedByID, 'http://www.researcherid.com/rid/%', true) OR
 GBIF_StringArrayLike(recordedByID, 'http://www.wikidata.org/entity/%', true) OR
 GBIF_StringArrayLike(recordedByID, 'https://www.linkedin.com/profile/view?id=%', true)
 ) THEN 1 ELSE 0 END) AS records_with_invalid_recordedByID,
 100.0 * SUM(CASE WHEN COALESCE(CONCAT_WS(' | ', recordedByID), '') &lt;&gt; '' AND NOT (
 GBIF_StringArrayLike(recordedByID, 'https://orcid.org/%', true) OR
 GBIF_StringArrayLike(recordedByID, 'http://scholar.google.com/citations?user=%', true) OR
 GBIF_StringArrayLike(recordedByID, 'http://www.researcherid.com/rid/%', true) OR
 GBIF_StringArrayLike(recordedByID, 'http://www.wikidata.org/entity/%', true) OR
 GBIF_StringArrayLike(recordedByID, 'https://www.linkedin.com/profile/view?id=%', true)
 ) THEN 1 ELSE 0 END) / COUNT(*) AS pct_invalid_recordedByID,
 SUM(CASE WHEN GBIF_StringArrayLike(recordedByID, 'https://orcid.org/%', true) THEN 1 ELSE 0 END) AS records_with_orcid,
 100.0 * SUM(CASE WHEN GBIF_StringArrayLike(recordedByID, 'https://orcid.org/%', true) THEN 1 ELSE 0 END) / COUNT(*) AS pct_with_orcid,
 SUM(CASE WHEN GBIF_StringArrayLike(recordedByID, 'http://scholar.google.com/citations?user=%', true) THEN 1 ELSE 0 END) AS records_with_google_scholar,
 100.0 * SUM(CASE WHEN GBIF_StringArrayLike(recordedByID, 'http://scholar.google.com/citations?user=%', true) THEN 1 ELSE 0 END) / COUNT(*) AS pct_with_google_scholar,
 SUM(CASE WHEN GBIF_StringArrayLike(recordedByID, 'http://www.researcherid.com/rid/%', true) THEN 1 ELSE 0 END) AS records_with_researcherid,
 100.0 * SUM(CASE WHEN GBIF_StringArrayLike(recordedByID, 'http://www.researcherid.com/rid/%', true) THEN 1 ELSE 0 END) / COUNT(*) AS pct_with_researcherid,
 SUM(CASE WHEN GBIF_StringArrayLike(recordedByID, 'http://www.wikidata.org/entity/%', true) THEN 1 ELSE 0 END) AS records_with_wikidata,
 100.0 * SUM(CASE WHEN GBIF_StringArrayLike(recordedByID, 'http://www.wikidata.org/entity/%', true) THEN 1 ELSE 0 END) / COUNT(*) AS pct_with_wikidata,
 SUM(CASE WHEN GBIF_StringArrayLike(recordedByID, 'https://www.linkedin.com/profile/view?id=%', true) THEN 1 ELSE 0 END) AS records_with_linkedin,
 100.0 * SUM(CASE WHEN GBIF_StringArrayLike(recordedByID, 'https://www.linkedin.com/profile/view?id=%', true) THEN 1 ELSE 0 END) / COUNT(*) AS pct_with_linkedin
FROM occurrence
WHERE hostingOrganizationKey IS NOT NULL
GROUP BY hostingOrganizationKey
ORDER BY pct_with_recordedByID DESC;




 The dataset's 386 records were derived from 77377 constituent datasets; see https://api.gbif.org/v1/occurrence/download/0051430-251009101135966/datasets/export for details.
 
Data from some individual datasets included in this download may be licensed under less restrictive terms.