************************************* File created May 03, 2020 ************************************* These data files accompany: L. H. Wong, J. R. K. Forrest. 2021. "The earlier the better? Nesting timing and reproductive success in subalpine cavity-nesting bees", Journal of Animal Ecology ************************************* CONTENTS There are 3 folders & raw temperature data (HOBO): - floral abundance data - offspring success data - trapnest occupant data All data files are comma-separated values files In most cases there is a separate file for each year of the study ************************************* FOLDER: FLORAL ABUNDANCE DATA - There is one CSV for each year of study - Contains data on flower densities recorded during flower surveys Site: location of data collection BC, FT, KC, KP, MCB, MM, RP, VB are abbreviations BC = Brush Creek (38.861, -106.920) EL = Emerald Lake (39.012, -107.044) *no bee data used from this site FT = 401 Trail (38.971, -106.991) KC = Kebler Clearing (38.858, -107.060) KP = Kebler Pass (38.853, -107.101) MCB = Mount Crested Butte (38.889, -106.962) MM = Maxfield Meadow (38.951, -106.994) *no bee data used from this site RP = Rosy Point (38.932, -106.970) VB = Virginia Basin (38.977, -106.976) (there are 9 sites listed here because floral density was measured for multiple sites, but EL and MM were excluded because EL did not have temperature data and because the focal species were not observed at MM) Date: Date on which flower survey occurred Day of year: Day of year of data collection Sampling occasion: Survey number Plant taxon: Species (or family in some years) counted Floral unit: Unit counted as "1" for each taxon (either flower, capitula, catkin) Distance: Straight-line distance from site centre to 100th floral unit counted. “na”, blank, or “>100” if 100 floral units not reached. Area surveyed: π * distance2. “#VALUE!” if Distance is non-numeric. Density: 100 units / Area surveyed. 0 if Area is non-numeric. Checked: Data verification (y = data verified) OR Verified by: Initials of person who did data verification (checked for errors) ----------------------------------------------------------------------------- FOLDER: OFFSPRING SUCCESS DATA - Contains 3 CSV files - 2 files contain Hoplitis fulgida offspring developmental success (cocoon) data for 2017 and 2018 - 1 file contains Hoplitis fulgida offspring emergence success data for all years together Hoplitis cocoon data_2017.CSV: year: Year of observation (i.e. year in which egg was laid) site: See floral abundance data for coordinates block letter: Trap-nest block letter (from A - K) hole number: Specific hole in trap-nest (10 holes per block) total cells: total number of brood cells contained in straw/nest cell number: brood cell number; innermost cell = #1 *Cells were checked on 3 occasions for cocoon success in 2017 1date cell opened: date of first check 1cocoon spun: whether or not larvae finished cocoon 1notes: specification of "film" = cocoon membrane Hoplitis cocoon data_2018.CSV: Site: See floral abundance data for coordinates Block letter: as above Hole no.: as above Nest ID: Nest identifier - site abbreviation, combined with block and hole number Cell no.: as above Date checked: date on which nest was opened to check for cocooning Cell no.: as above Status: Qualitative observation of larva: FL = feeding larva (no frass yet), DL = defecating larva (still may have pollen but frass visible), PDL = post-defecating larva (pollen seems to have all been consumed but no silk visible), SL = spinning larva, C = cocoon (can’t see larva through silk) Hoplitis emergence data_2014-18.CSV Site: See floral abundance data for coordinates Block and hole number: As above Year of nest construction: year in which nest was constructed by female Date found: Date on which individual was found emerged in trap Date traps last checked: Last date on which emergence traps were checked prior to finding emerged insect Estimated emergence date: Not estimated for this study Year of emergence: Year in which individual emerged Taxon: taxon emerged (Hoplitis fulgida only) Sex: F = Female, M = Male, some unidentified Status: Whether or not insect was found alive or dead in trap Collector: Initials of researcher collecting specimen (JF = Jessica Forrest, GG = Gabriel Gauthier, LW = Lydia Wong, CC = Charlotte Cahill) Success: 1 = alive, 0 = dead alive/dead - some bees that were found dead (Column: Status) were still considered successful as we assumed they died because we did not arrive in time to release them from emergence traps. In general: bees that had died in emergence trap vials (Column: Straw or Vial) were considered successful emergences and bees that were found dead in the nesting straw were considered unsuccessful. ----------------------------------------------------------------------------- FOLDER: TRAPNEST OCCUPANT DATA - Contains 6 CSV files (one for each year of study) Site: See floral abundance data for coordinates Current date: Date of current observation (site visit) Bee species: Bee species (identified in the field) Nest ID: Unique identity of the nest (consists of site abbreviation, block letter and hole number) Individual ID or Individual code: Unique identity of nest occupant (consists of site abbreviation, species, and paint marking colour) Previous date: Date of last observation or site visit Estimated nest start date: Estimated date on which the nest was started (this was interpolated in the field based on nesting progress, in some years, I estimate this in R scripts) Occupant Type: Bee or wasp (trap-nests were colonized by both solitary bees and wasps, but wasp data were removed from the archived files) Day elapsed: Days elapsed since last site visit or observation Estimated nest start date: Estimated date on which an individual began constructing a nest (sometimes this was estimated in the field based on observations of cell construction progress) Cells completed since last date: Estimation of proportion of brood cell completed (1 brood cell = pollen provision + egg) Observer: Initials of person recording data Data entered by: Initials of person entering data Checked by: Initials of person checking data entry ----------------------------------------------------------------------------- FILE: TRAPNEST HOBO TEMPERATURE DATA.CSV - Single file containing hourly temperatures for each site from 2013 to 2018