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=4009 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=4009SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3758SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=4009 ORDER BY register_no ASCSELECT 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='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='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='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='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='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='Leporidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leporidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leporidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leporidae' AND (junior_species='indet.' OR junior_species='indet.')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='Leporidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aves' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aves' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aves' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aves' AND (junior_species='indet.' OR junior_species='indet.')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='Aves' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Testudinidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Testudinidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Testudinidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Testudinidae' AND (junior_species='indet.' OR junior_species='indet.')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='Testudinidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Siluriformes' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Siluriformes' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Siluriformes' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Siluriformes' AND (junior_species='indet.' OR junior_species='indet.')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='Siluriformes' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=4009 The Ecological Register: Kara-tepe
Kara-tepe
Basic information
Sample name: Kara-tepe

Reference: E. B. Brite, G. Khozhaniyazov, J. M. Marston, M. Negus Cleary, and F. J. Kidd. 2017. Kara-tepe, Karakalpakstan: Agropastoralism in a central Eurasian oasis in the 4th/5th century AD transition. Journal of Field Archaeology 42(6):514-549 [ER 3758]
Geography
Country: Uzbekistan

State: Karakalpakstan


Coordinate: 41° 53' 9" N, 60° 39' 56" E
Coordinate basis: stated in text

Time interval: Holocene

Max Ma: 0.00167

Min Ma: 0.00157

Age basis: radiocarbon (uncalibrated)

Geography comments: "Kara-tepe is a fortified, mounded site located near the modern town of Biruni in the semi-autonomous Republic of Karakalpakstan in northwestern Uzbekistan. The site is situated in the alluvial plain of the eastern Amu Darya delta, an area known in historic times as the Khorezm oasis".
Radiocarbon dates on seeds from the floor level of an off-mound household range from the 3rd–6th centuries AD (1670 ± 40 BP and 1570 ± 40 BP); occupation of the site most likely took place in the 4th-5th centuries A.D.

•
Environment
Lithology: not described

Taphonomic context: human accumulation,settlement

Archaeology: buildings,ceramics,hearths,stone tools,other artifacts,other structures

Habitat comments: "Kara-tepe’s 1-ha mound rises approximately 7 m above a flat agricultural plain and is abutted by modern fields rotating rice, melon, cotton, and wheat cultivation. Several additional small mounds are also located around the site. The square mound of Kara-tepe is a typical example of a Khorezmian qala (a type of building complex found throughout Central Eurasia)".
"The Early Medieval deposits included mudbrick walls demarcating the remains of a structure, within which was a 10-cm thick stratigraphic layer with extensive evidence of burning. Also associated with this layer was a nearly fully intact single-handled jug and plate of Early Medieval form and a large stone quern fragment. Two rooms of another domestic structure were also found, with a mix of mudbrick and pakhsa (rammed earth) construction. A stratigraphic layer of burning was present across both rooms of this structure and included the remains of charred wood fragments likely associated with roofing material. There was also a clay-lined pit adjacent to a hearth".
"Ninety-one diagnostic ceramic sherds and 338 total sherds were recovered from the two rooms, along with a wide variety of other, well-preserved materials. Two intact ceramic braziers and a possible third stand piece were found directly east of the hearth. More stone quern fragments and a silver coin were also recovered, along with a fragment of carbonized textile".

Methods
Life forms: ungulates,other small mammals,birds,turtles,fishes

Sampling methods: quarry,screenwash,surface

Sample size: 46 specimens

Years: 2008 - 2009

Sampling comments: "Two seasons of archaeological research were carried out at Kara-tepe in 2008–2009, and included topographic mapping, surface survey collection, geophysical survey, and the excavation of nine test trenches".
"A total of 4.9 kg of faunal remains were collected at Kara-tepe. The faunal collection consists of specimens from two contexts: Phase II occupation deposits in the two rooms, and deposits from below this architecture, presumably associated with the Phase I ditch that surrounded the fortifications. Due to several constraints, remains were collected mainly by hand, supplemented by the flotation and graduated sieving of samples of occupation deposits".

Metadata
Sample number: 4009

Contributor: Benjamin Carter

Enterer: Benjamin Carter

Created: 2022-10-14 14:30:41

Modified: 2022-10-14 04:04:23

Abundance distribution
10 species
2 singletons
total count 46
extrapolated richness: 17.4
Fisher's α: 3.936
geometric series k: 0.7520
Hurlbert's PIE: 0.8213
Shannon's H: 1.9725
Good's u: 0.9584
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Capra aegagrus hircus222 kg browser-grazer
"Capra hircus"
Ovis aries1341 kg
also 31 Caprinae indet.
Bos taurus11337 kg
Cervus elaphus4104 kg
Equus ferus3422 kg
also 4 Equus sp.
Sus scrofa254 kg herbivore
Leporidae indet.1
Aves indet.3
Testudinidae indet.1
Siluriformes indet.6