Create new SQL download

About SQL downloads

SQL downloads allow users to query GBIF occurrence data using Structured Query Language (SQL). This enables the selection of specific columns of interest and generation of summary views without having to download full occurrence datasets. The SQL query interface is used for the generation of species occurrences cubes.

Example of SQL download query

The below example returns a csv containing the number of European occurrence records grouped by dataset and country:

SELECT datasetKey, countryCode, COUNT(*) FROM occurrence WHERE continent = 'EUROPE' GROUP BY datasetKey, countryCode

Output:

Please refer to the SQL downloads documentation for full details of syntax and functions.