SELECT * FROM sessions,people WHERE ip=20315109220 AND enterer=person_noSELECT p.first_name AS contributor_first,p.last_name AS contributor_last,p2.first_name AS enterer_first,p2.last_name AS enterer_last,t.* FROM people p,people p2,samples t WHERE t.contributor_no=p.person_no AND t.enterer_no=p2.person_no AND t.sample_no=3562 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3562SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3233SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3562 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Equus' AND (junior_species='ferus' OR junior_species='ferus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Equus' AND (species='ferus' OR species='ferus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Equus' AND (junior_species='ferus' OR junior_species='ferus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Equus' AND (species='ferus' OR species='ferus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Equus' AND (junior_species='hemionus' OR junior_species='hemionus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Equus' AND (species='hemionus' OR species='hemionus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Equus' AND (species='hemionus' OR species='hemionus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Equus' AND (junior_species='hemionus' OR junior_species='hemionus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Equus' AND (species='hemionus' OR species='hemionus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bos' AND (junior_species='primigenius' OR junior_species='primigenius')SELECT junior_genus,junior_species FROM itis WHERE senior_genus='' AND senior_species=''SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bos' AND (species='primigenius' OR species='primigenius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bos' AND (species='primigenius' OR species='primigenius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bos' AND (junior_species='primigenius' OR junior_species='primigenius')SELECT junior_genus,junior_species FROM itis WHERE senior_genus='' AND senior_species=''SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bos' AND (species='primigenius' OR species='primigenius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Saiga' AND (junior_species='tatarica' OR junior_species='tatarica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Saiga' AND (species='tatarica' OR species='tatarica') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Saiga' AND (junior_species='tatarica' OR junior_species='tatarica')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Saiga' AND (species='tatarica' OR species='tatarica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cervus' AND (junior_species='elaphus' OR junior_species='elaphus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cervus' AND (species='elaphus' OR species='elaphus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cervus' AND (junior_species='elaphus' OR junior_species='elaphus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cervus' AND (species='elaphus' OR species='elaphus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sus' AND (junior_species='scrofa' OR junior_species='scrofa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sus' AND (species='scrofa' OR species='scrofa') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sus' AND (junior_species='scrofa' OR junior_species='scrofa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Sus' AND (species='scrofa' OR species='scrofa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vulpes' AND (junior_species='vulpes' OR junior_species='vulpes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vulpes' AND (species='vulpes' OR species='vulpes') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vulpes' AND (junior_species='vulpes' OR junior_species='vulpes')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Vulpes' AND (species='vulpes' OR species='vulpes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canis' AND (junior_species='lupus' OR junior_species='lupus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canis' AND (species='lupus' OR species='lupus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canis' AND (junior_species='lupus' OR junior_species='lupus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Canis' AND (species='lupus' OR species='lupus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Meles' AND (junior_species='meles' OR junior_species='meles')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Meles' AND (species='meles' OR species='meles') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Meles' AND (junior_species='meles' OR junior_species='meles')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Meles' AND (species='meles' OR species='meles') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepus' AND (junior_species='europaeus' OR junior_species='europaeus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lepus' AND (species='europaeus' OR species='europaeus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepus' AND (junior_species='europaeus' OR junior_species='europaeus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lepus' AND (species='europaeus' OR species='europaeus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3562 The Ecological Register: Mirnoe
Mirnoe
Basic information
Sample name: Mirnoe

Sample aka: Myrne

Reference: K. Kitagawa, M. Julien, O. Krotova, A. A. Bessudnov, M. V. Sablin, D. Kiosak, N. Leonova, B. Plohenko, and M. Patou-Mathis. 2018. Glacial and post-glacial adaptations of hunter-gatherers: Investigating the late Upper Paleolithic and Mesolithic subsistence strategies in the southern steppe of Eastern Europe. Quaternary International 465:192-209 [ER 3233]
Geography
Country: Ukraine

State: Odessa


Coordinate: 45.573277° N, 29.451138° E
Coordinate basis: estimated from map

Time interval: Holocene

Max Ma: 0.008475

Min Ma: 0.00828

Age basis: radiocarbon (uncalibrated)

Geography comments: There are two places called Mirnoe in this area, and I'm pretty sure this paper got it wrong. They list 46˚28'N 30˚22'E, but the previous papers referring to the site have the other location, so I've put that one in as the official location.
dates are apparently uncalibrated (table says 14C BP)
calculated dates: 8280 ± 45, 8350 ± 45, 8385 ± 45, and 8475 ± 45

•
Environment
Lithology: peat

Taphonomic context: human accumulation

Archaeology: buildings,hearths,stone tools,other artifacts

Habitat comments: "The site sequence was described as follows according to the profiles of the trenches opened in 1969–1976: 1) topsoil, composed of two horizons: a) turf, b) loamy layer with Chalcolithic finds); 2) dusty, peaty loam; 3) light brownish loam, with carbonate inclusions (‘‘buried soil’’?); 4) yellowish, sandy loam, containing the cultural layer, radiocarbon-dated to 7200 % 80 uncal BP (Le-1647) from bone; 5) heavy, dense, light brown loam with carbonate inclusions.
The Mesolithic layer was found between the Late Pleistocene loam deposit (5), and the ‘‘buried soil’’ that formed under mild, Atlantic climatic conditions (3)."

Methods
Life forms: carnivores,ungulates,other small mammals

Sampling methods: quarry

Sample size: 9800 specimens

Sampled by: Stanko

Years: 1969 - 1976

Sampling comments: "A representative sample of surface finds was collected in 1964, thanks to which the site was attributed to the Late Mesolithic, like those of Grebenyky and Gyrzheve. During the opening of the first test-trench, a rich cultural layer was discovered in situ at the depth of 0.9–1.1 m.66 From 1969 to 1976, Stanko carried out an extensive programme of excavations"

Metadata
Sample number: 3562

Contributor: Aniko Toth

Enterer: Aniko Toth

Created: 2019-10-10 13:06:43

Modified: 2023-04-03 07:12:43

Abundance distribution
10 species
0 singletons
total count 9800
extrapolated richness: 10.6
Fisher's α: 1.099
geometric series k: 0.4292
Hurlbert's PIE: 0.2968
Shannon's H: 0.6043
Good's u: 1.0000
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Equus ferus1369422 kg
Equus hemionus hydruntinus112 grazer
"Equus hydruntinus"
Bos primigenius8101
Saiga tatarica6128 kg
Cervus elaphus29104 kg
Sus scrofa6954 kg herbivore
Vulpes vulpes45.3 kg carnivore-insectivore
Canis lupus3643 kg carnivore
Meles meles611 kg invertivore-herbivore
Lepus europaeus133.4 kg herbivore