Fetch Zenodo stats for communities and queries

zenodo-community-stats.sh

#!/bin/bash

# To use this script you need to have "curl" and "jq" installed.

COMMUNITY_ID="craft-oa"
OUTPUT_CSV="${COMMUNITY_ID}_community_stats.csv"

# Create CSV file header
echo "URL,DOI,Title,PublicationDate,Views,Downloads" > "${OUTPUT_CSV}"

# Download all records (including multiple versions) from the community (max 10k records)
curl -s -G "https://zenodo.org/api/records/" -d "size=10000" -d "all_versions=true" -d "communities=${COMMUNITY_ID}" \
    `# Process with jq to extract the required fields` \
    | jq -r '.hits.hits[] | [.links.self, .metadata.doi, .metadata.title, .metadata.publication_date, .stats.views, .stats.downloads] | @csv' \
    >> "${OUTPUT_CSV}"

zenodo-query-stats.sh

#!/bin/bash

# To use this script you need to have "curl" and "jq" installed.

QUERY="grants.code:12345"
OUTPUT_CSV="[${QUERY}]_query_stats.csv"

# Create CSV file header
echo "URL,DOI,Title,PublicationDate,Views,Downloads" > "${OUTPUT_CSV}"

# Download all records (including multiple versions) for the query (max 10k records)
curl -s -G "https://zenodo.org/api/records/" -d "size=10000" -d "all_versions=true" -d "q=${QUERY}" \
    `# Process with jq to extract the required fields` \
    | jq -r '.hits.hits[] | [.links.self, .metadata.doi, .metadata.title, .metadata.publication_date, .stats.views, .stats.downloads] | @csv' \
    >> "${OUTPUT_CSV}"

zenodo-user-stats.sh

#!/bin/bash

# To use this script you need to have "curl" and "jq" installed.

USER_ID="12345"
OUTPUT_CSV="${USER_ID}_user_stats.csv"

# Create CSV file header
echo "URL,DOI,Title,PublicationDate,Views,Downloads" > "${OUTPUT_CSV}"

# Download all records (including multiple versions) for the user (max 10k records)
curl -s -G "https://zenodo.org/api/records/" -d "size=10000" -d "all_versions=true" -d "q=owners:${USER_ID}" \
    `# Process with jq to extract the required fields` \
    | jq -r '.hits.hits[] | [.links.self, .metadata.doi, .metadata.title, .metadata.publication_date, .stats.views, .stats.downloads] | @csv' \
    >> "${OUTPUT_CSV}"