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_24_06_2021.sql - an SQL file for the full public version of BioTIME which can be imported into any mySQL database. 
  • BioTIMEQuery_24_06_2021.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_24_06_2021.csv  - file containing the meta data for all studies. 
  • BioTIMECitations_24_06_2021.csv - file containing the citation list for all studies. 
  • BioTIMECitations_24_06_2021.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 (280.0 MB)
Name Size
BioTIMECitations_24_06_2021.csv
md5:c4fa9a78da4611505aa5ee66f527baac
147.5 kB Download
BioTIMECitations_24_06_2021.xlsx
md5:297b0412d4d817bf78ff8fe770750bd3
52.0 kB Download
BioTIMEInteractions_02_04_2018.Rmd
md5:af113ee88316ed5a173616784f020e72
25.6 kB Download
BioTIMEMetadata_24_06_2021.csv
md5:132ac80b6224078f354287d6267e1b74
1.1 MB Download
BioTIMEQuery_24_06_2021.zip
md5:b806be93a30beff46dda8fec497f83de
134.4 MB Download
BioTIMESQL_24_06_2021.zip
md5:f3642819a15b4392b2cf39ddbb38f9c7
144.2 MB Download
3,789
3,850
views
downloads
All versions This version
Views 3,789376
Downloads 3,850237
Data volume 567.6 GB17.0 GB
Unique views 3,274335
Unique downloads 2,350132

Share

Cite as