The data file pikeextinction.xls contains three tables: 1. “lake level data” contains information about lakes 2. “fragment level data”. In this table the data in table 1 have been aggregated to fragments that may include several interconnected lakes. 3. “archeological records” contains information about archaeological records of pike remains __________________________________________________________________________________ Variables in table 1 “lake level data” fragmentID: Lakes belonging to the same fragment have the same ID. A fragment is either an isolated lake or a set of interconnected lakes that are isolated from the rest of the catchment. lake name % lake in catchment: The proportion of the catchment area covered by lakes, including the focal lake area (ha) % agricultural land: The proportion of the catchment area covered by agricultural land catchment area (ha) latitude (decimal degrees) longitude (decimal degrees) Introduction: 1 = Pike colonized at the result of an anthropogenic introduction. 0= pike colonized without known help from humans Pike: 1=Pike is present today (or at the time of the last record). 0=pike is absent lake area (ha) metapopulation area (ha): The total area of lakes with bidirectional connectivity within a fragment source population area (ha):Metapopulation area plus the area of lakes positioned upstream of a dispersal barrier (waterfall or steep rapid) that can provide colonizers through downstream dispersal metapopulation number: The number of lakes in a metapopulation sourcepopulation number: The number of lakes in a source population Depth: Lake depth (meters) Age: Time since the lake became isolated from the Baltic Sea, or the time since pike were introduced by humans temperature sum: Degree days using 6 oC as base. elevation (m asl): Elevation of the lake Left: “left” and “right” defines the time period within which pike will go extinct. If pike colonized 9500 years ago and is present today it means that pike extinction will happen in the time span 9500 to infinity, denoted as left=9500 and right=NA. If pike colonized 9500 years ago and is absent today, it means that extinction happened sometime between year 0 and today, which is denoted as left=0, right=9500. If the date of extinction is known, it means that left=right.For more information see Anderson-Bergman, C. (2017) icenReg: Regression Models for Interval Censored Data in R. Journal of Statistical Software, 81, 1-23. Right: See above distance to nearest farm: The distance from a lake to the nearest farm (m) distance to nearest village: The distance from a lake to the nearest village, defined as a cluster with at least ten buildings (m) Comment __________________________________________________________________________________ Variables in table 2 “fragment level data” fragmentID: A fragment is either an isolated lake or a set of interconnected lakes that are isolated from downstream lakes that are potential dispersal sources. latitude (decimal degrees) longitude (decimal degrees) introduction or presence absence data: 1 = Pike colonized at the result of an anthropogenic introduction. 0= pike colonized without known help from humans time since isolation or introduction (years): Time since the fragment became isolated from the Baltic Sea, or the time since pike were introduced by humans metapopulation area: The total area of lakes with bidirectional connectivity within a fragment source population area. Metapopulation area plus the area of lakes positioned upstream of a dispersal barrier (waterfall or steep rapid). These additional lakes can potentially provide colonizers through downstream dispersal metapopulation number: The number of lakes in a metapopulation sourcepopulation number: The number of lakes in a source population Left: Left and right defines the time period within which pike went extinct, or will go extinct. For example, if pike colonized 9500 years ago and is present today it means that pike extinction will happen in the time span 9500 to infinity, denoted as left=9500 and right=NA. If pike colonized 9500 years ago and is absent today, it means that extinction happened sometime between year 0 and today, which is denoted as left=0, right=9500. If the date of extinction is known, it means that left=right. For more information, see Anderson-Bergman, C. (2017) icenReg: Regression Models for Interval Censored Data in R. Journal of Statistical Software, 81, 1-23. Right: See above distance to farm (m): The distance from a lake to the nearest farm distance to village (m): The distance from a lake to the nearest village, defined as a cluster with at least ten buildings pike presence/absence: 1=Pike is present today (or at the time of the last record). 0=pike is absent elevation of lake (m): Elevation of the lowest lake in a fragment temperature sum: Degree days using 6 oC as base. CV lake area: The coefficient of variation of lake area within a fragment catchment area (ha) % lake in the catchment: The proportion of the catchment area covered by lakes, including the focal lakes are % agricultural land in catchment: The proportion of the catchment area covered by agricultural land _____________________________________________________________________________ Variables in table 3, “archeological records” site name: Name of the site used in the original publication time period (years): Approximate date for the record Y-coordinate (RT 90) X-coordinate (RT 90) source: Database from which the record were retrieved reference: Original reference Fish species: Pike = pike remains were found, other species may also be present. Other= fish remains, not including pike, were recorded ________________________________________________________________________________