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=4054 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=4054SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3773SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=4054 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Galliformes' 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='Galliformes' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Galliformes' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Galliformes' 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='Galliformes' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nesotragus' AND (junior_species='moschatus' OR junior_species='moschatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nesotragus' AND (species='moschatus' OR species='moschatus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nesotragus' AND (junior_species='moschatus' OR junior_species='moschatus')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='Nesotragus' AND (species='moschatus' OR species='moschatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Raphicerus' AND (junior_species='campestris' OR junior_species='campestris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Raphicerus' AND (species='campestris' OR species='campestris') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Raphicerus' AND (junior_species='campestris' OR junior_species='campestris')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='Raphicerus' AND (species='campestris' OR species='campestris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sylvicapra' AND (junior_species='grimmia' OR junior_species='grimmia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sylvicapra' AND (species='grimmia' OR species='grimmia') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sylvicapra' AND (junior_species='grimmia' OR junior_species='grimmia')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='Sylvicapra' AND (species='grimmia' OR species='grimmia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Potamochoerus' AND (junior_species='larvatus' OR junior_species='larvatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Potamochoerus' AND (species='larvatus' OR species='larvatus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Potamochoerus' AND (junior_species='larvatus' OR junior_species='larvatus')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='Potamochoerus' AND (species='larvatus' OR species='larvatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Herpestes' AND (junior_species='sanguineus' OR junior_species='sanguineus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Herpestes' AND (species='sanguineus' OR species='sanguineus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Herpestes' AND (junior_species='sanguineus' OR junior_species='sanguineus')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='Herpestes' AND (species='sanguineus' OR species='sanguineus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Civettictis' AND (junior_species='civetta' OR junior_species='civetta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Civettictis' AND (species='civetta' OR species='civetta') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Civettictis' AND (junior_species='civetta' OR junior_species='civetta')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='Civettictis' AND (species='civetta' OR species='civetta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pteropodidae' 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='Pteropodidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pteropodidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pteropodidae' 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='Pteropodidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendrohyrax' AND (junior_species='validus' OR junior_species='validus')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='Dendrohyrax' AND (species='validus' OR species='validus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dendrohyrax' AND (species='validus' OR species='validus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendrohyrax' AND (junior_species='validus' OR junior_species='validus')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='Dendrohyrax' AND (species='validus' OR species='validus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepus' 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='Lepus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lepus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepus' 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='Lepus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macroscelididae' 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='Macroscelididae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Macroscelididae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macroscelididae' 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='Macroscelididae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Equus' AND (junior_species='quagga' OR junior_species='quagga')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Equus' AND (species='quagga' OR species='quagga') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Equus' AND (junior_species='quagga' OR junior_species='quagga')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='quagga' OR species='quagga') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Homo' AND (junior_species='sapiens' OR junior_species='sapiens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Homo' AND (species='sapiens' OR species='sapiens') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Homo' AND (junior_species='sapiens' OR junior_species='sapiens')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='Homo' AND (species='sapiens' OR species='sapiens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Piliocolobus' AND (junior_species='kirkii' OR junior_species='kirki')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Piliocolobus' AND (species='kirkii' OR species='kirki') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Piliocolobus' AND (species='kirkii' OR species='kirki')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Piliocolobus' AND (junior_species='kirkii' OR junior_species='kirki')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='Piliocolobus' AND (species='kirkii' OR species='kirki') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paragalago' AND (junior_species='zanzibaricus' OR junior_species='zanzibaricus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Paragalago' AND (species='zanzibaricus' OR species='zanzibaricus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paragalago' AND (species='zanzibaricus' OR species='zanzibaricus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paragalago' AND (junior_species='zanzibaricus' OR junior_species='zanzibaricus')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='Paragalago' AND (species='zanzibaricus' OR species='zanzibaricus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cricetomys' AND (junior_species='gambianus' OR junior_species='gambianus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cricetomys' AND (species='gambianus' OR species='gambianus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cricetomys' AND (junior_species='gambianus' OR junior_species='gambianus')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='Cricetomys' AND (species='gambianus' OR species='gambianus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hystrix' AND (junior_species='cristata' OR junior_species='cristata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hystrix' AND (species='cristata' OR species='cristata') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hystrix' AND (junior_species='cristata' OR junior_species='cristata')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='Hystrix' AND (species='cristata' OR species='cristata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sciuridae' 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='Sciuridae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sciuridae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sciuridae' 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='Sciuridae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Varanus' AND (junior_species='niloticus' OR junior_species='niloticus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Varanus' AND (species='niloticus' OR species='niloticus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Varanus' AND (species='niloticus' OR species='niloticus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Varanus' AND (junior_species='niloticus' OR junior_species='niloticus')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='Varanus' AND (species='niloticus' OR species='niloticus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chelonia' AND (junior_species='mydas' OR junior_species='mydas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chelonia' AND (species='mydas' OR species='mydas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chelonia' AND (species='mydas' OR species='mydas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chelonia' AND (junior_species='mydas' OR junior_species='mydas')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='Chelonia' AND (species='mydas' OR species='mydas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Serpentes' 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='Serpentes' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Serpentes' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Serpentes' 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='Serpentes' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=4054
The Ecological Register: Kuumbi Cave (Trench 10, Phase 2)
Reference:M. E. Prendergast, H. Rouby, P. Punnwong, R. Marchant, A. Crowther, N. Kourampas, C. Shipton, M. Walsh, K. Lambeck, and N. L. Boivin. 2016. Continental island formation and the archaeology of defaunation on Zanzibar, eastern Africa. PloS One11(2):e0149565 [ER 3773]
Geography
Country: Tanzania
State: Zanzibar
Coordinate:6° 21' 40" S, 39° 32' 33" E
Coordinate basis: stated in text
Time interval: Pleistocene - Holocene
Section: 3773
Unit number: 2
Unit order: above to below
Max Ma: 0.011082
Min Ma: 0.010069
Age basis: radiocarbon (uncalibrated)
Geography comments: "Kuumbi Cave is located in Kusini District, in the Unguja South Region of Tanzania. It is located near the southeastern coast of Unguja Island, part of the semi-autonomous province of Zanzibar, c. 2.5 km from the present day shoreline".
"Phase 2 dates to the Pleistocene-Holocene transition, from 11082 ± 37 to 10069 ± 32 BP (c. 13,040 to 11,340 cal. BP)".
•
Environment
Lithology: limestone
Taphonomic context: cave,human accumulation
Archaeology: bone tools,stone tools
Habitat comments: "Kuumbi is a large solutional cave, one of several in a series of Pleistocene-era marine terraces on limestone. Five main phases were identfied in the main trench: Phase 1a contains large limestone lithics and Swahili ceramics; Phase 1b contains the same lithics and earlier Tana Tradition/Triangular Incised Ware ceramics; Phase 2 does not contain any ceramics but includes Later Stone Age (LSA) bone projectile points and other bone tools and a quartz microlithic industry; Phase 3 contains similar LSA quartz and bone technologies; Phase 4 does not bear any unambiguous evidence of human occupation, but it does contain faunal remains, a few of which are burned".
Methods
Life forms: bats,carnivores,primates,rodents,ungulates,other large mammals,other small mammals,birds,lizards,snakes,turtles
Sampling methods: quarry,screenwash
Sample size: 163 specimens
Years: 2012
Sampling comments: "Four trenches were excavated in Kuumbi Cave during the Sealinks field season in 2012: Trench 10 was located in the upper main chamber. All deposits from Trench 10 were dry-sieved on site using 3 mm mesh, except for sub-samples of between 7–60L per context; these were bagged separately and processed by flotation to recover archaeobotanical remains and subsequently wet-sieved through 1mm mesh. The wet- and dry-sieved faunal samples (excluding land and marine molluscs and fish) were included in the analysis, for a total of 17.6 kg of tetrapod faunal remains".
Metadata
Sample number: 4054
Contributor: Benjamin Carter
Enterer: Benjamin Carter
Created: 2023-02-16 11:25:31
Modified: 2023-05-30 03:42:35
Abundance distribution
21 species
1 singleton
total count 163
extrapolated richness: 33.1
Fisher's α: 6.415
geometric series k: 0.8199
Hurlbert's PIE: 0.8225
Shannon's H: 2.2392
Good's u: 0.9945
Each square represents a species. Square sizes are proportional to counts.