There is a newer version of this record available.

Dataset Open Access

BioTIME

BioTIME Consortium

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. https://doi.org/10.1111/geb.12729

Files (2.2 GB)
Name Size
BioTIMECitations_02_04_2018.csv
md5:46f83f4daae28bb3ba57bd9d0d8368a9
132.1 kB Download
BioTIMECitations_02_04_2018.xlsx
md5:f3fb60c3cdc1730e810ff28aa2421b01
51.9 kB Download
BioTIMEInteractions_02_04_2018.Rmd
md5:af113ee88316ed5a173616784f020e72
25.6 kB Download
BioTIMEMetadata_02_04_2018.csv
md5:ca9778c1ea41e0af8f307bab9a9f5837
989.0 kB Download
BioTIMEQuery02_04_2018.csv
md5:429dc9685cde87fc8eff0098b8aa8101
1.2 GB Download
BioTIMESQL02_04_2018.sql
md5:6fd7c73439b81e0b4944936c60ca141d
1.0 GB Download
1,869
2,622
views
downloads
All versions This version
Views 1,869198
Downloads 2,622773
Data volume 416.5 GB97.1 GB
Unique views 1,606167
Unique downloads 1,587492

Share

Cite as