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=3998 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3998SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3750SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3998 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ovis' AND (junior_species='aries' OR junior_species='aries')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ovis' AND (species='aries' OR species='aries') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ovis' AND (junior_species='aries' OR junior_species='aries')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='Ovis' AND (species='aries' OR species='aries') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Capra' AND (junior_species='aegagrus' OR junior_species='aegagrus')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='Capra' AND (species='aegagrus' OR species='aegagrus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Capra' AND (junior_species='aegagrus' OR junior_species='aegagrus')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='Capra' AND (species='aegagrus' OR species='aegagrus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bos' AND (junior_species='taurus' OR junior_species='taurus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bos' AND (species='taurus' OR species='taurus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bos' AND (junior_species='taurus' OR junior_species='taurus')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='taurus' OR species='taurus') ORDER BY year,last_namesSELECT 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='africanus' OR junior_species='africanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Equus' AND (species='africanus' OR species='africanus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Equus' AND (junior_species='africanus' OR junior_species='africanus')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='africanus' OR species='africanus') 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='Gazella' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gazella' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gazella' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gazella' AND (junior_species='sp.' OR junior_species='sp.')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='Gazella' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Camelus' AND (junior_species='dromedarius' OR junior_species='dromedarius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Camelus' AND (species='dromedarius' OR species='dromedarius') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Camelus' AND (junior_species='dromedarius' OR junior_species='dromedarius')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='Camelus' AND (species='dromedarius' OR species='dromedarius') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3998
The Ecological Register: Tell Tuneinir (Area 6 - Market)
Reference:M. A. Loyet. 1999. Small ungulate butchery in the Islamic period (AD 632-1260) at Tell Tuneinir, Syria. Journal of Near Eastern Studies58(1):33-45 [ER 3750]
Geography
Country: Syria
State: Al-Hasakah
Coordinate:36° 25' 18" N, 40° 51' 59" E
Coordinate basis: stated in text
Time interval: Holocene
Max Ma: 0.00077
Min Ma: 0.00069
Age basis: other
Geography comments: "Tell Tuneinir is situated on the eastern bank of the Khabur river, 15 km southeast of Al-Hasakah, northeastern Syria. It consists of a central mound, 18.2 metres high, surrounded by a lower city covering an area of 46 hectares".
"Use of the market falls between A.D. 1180 and A.D. 1260 based on mint dates of associated coins".
Habitat comments: "Tuneinir is one of the largest tells in the area and at its highest point rises 20 meters above the surrounding plain. The ruins can be divided into three zones: the mound summit and the lower town, which are both located on the tell proper, and the suburban settlements, which are located on the plain surrounding the tell".
"A total of eight areas have been excavated, both on and off the tell: Area 1 consists of a step trench extending from the summit down the eastern edge of the tell; Area 2, near the summit of the tell, encompasses the remains of Ayyubid and Mamluk houses that belonged to the elite; Area 3 is a low mound situated on the eastern edge of the suburban settlement, off the tell proper, containing the remains of a Christian church; Area 4 is the south khan, or caravansary, which includes a small mosque; Area 5 is a bath complex; Area 6 is the market area; Area 7 is the north khan, which is much smaller than the south khan; and Area 8 consists of houses that belonged to the workers of the tell".
Methods
Life forms: ungulates
Sampling methods: quarry
Sample size: 318 specimens
Years: 1987 -
Sampling comments: The faunal remains below were obtained from the market area (Area 6), where butchery probably took place. "The market is one large building that consists of fifty rooms, all of which open onto the streets on each side of the building or the courtyard in the centre of the building".
"Forty-nine 5 x 5 metre squares were excavated. The faunal remains were hand collected and not screened".
Metadata
Sample number: 3998
Contributor: Benjamin Carter
Enterer: Benjamin Carter
Created: 2022-10-07 11:50:28
Modified: 2022-10-07 00:55:03
Abundance distribution
8 species
0 singletons
total count 318
extrapolated richness: 8.5
Fisher's α: 1.490
geometric series k: 0.6351
Hurlbert's PIE: 0.6815
Shannon's H: 1.5594
Good's u: 1.0000
Each square represents a species. Square sizes are proportional to counts.