There is a newer version of the record available.

Published April 2, 2018 | Version 2
Dataset Open


  • 1. Centre for Biological Diversity and Scottish Oceans Institute, School of Biology, University of St. Andrews, St. Andrews, UK


The BioTIME database contains raw data on species identities and abundances in ecological assemblages through time. The database consists of 11 tables; one raw data table plus ten related meta data tables. For further information please see our associated data paper.

This data consists of several elements:

  • BioTIMESQL_02_04_2018.sql - an SQL file for the full public version of BioTIME which can be imported into any mySQL database. 
  • BioTIMEQuery_02_04_2018.csv - data file, although too large to view in Excel, this can be read into several software applications such as R or various database packages. 
  • BioTIMEMetadata_02_04_2018.csv  - file containing the meta data for all studies. 
  • BioTIMECitations_02_04_2018.csv - file containing the citation list for all studies. 
  • BioTIMECitations_02_04_2018.xlsx - file containing the citation list for all studies (some special characters are not supported in the csv format). 
  • BioTIMEInteractions_02_04_2018.Rmd - an r markdown page providing a brief overview of how to interact with the database and associated .csv files (this will not work until field paths and database connections have been added/updated).

Please note: any users of any of this material should cite the associated data paper in addition to the DOI listed here.

To cite the data paper use the following:

Dornelas M, Antão LH, Moyes F, Bates, AE, Magurran, AE, et al. BioTIME: A database of biodiversity time series for the Anthropocene. Global Ecol Biogeogr. 2018; 27:760 - 786.



Files (2.2 GB)

Name Size Download all
132.1 kB Preview Download
51.9 kB Download
25.6 kB Download
989.0 kB Preview Download
1.2 GB Preview Download
1.0 GB Download