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=3798 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3798SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3413SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3798 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lama' AND (junior_species='guanicoe' OR junior_species='guanicoe')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='Lama' AND (species='guanicoe' OR species='guanicoe') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lama' AND (junior_species='guanicoe' OR junior_species='guanicoe')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='Lama' AND (species='guanicoe' OR species='guanicoe') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cervidae' 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='Cervidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cervidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cervidae' 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='Cervidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canidae' 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='Canidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canidae' 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='Canidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cavia' 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='Cavia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cavia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cavia' 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='Cavia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anatidae' 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='Anatidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anatidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anatidae' 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='Anatidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rallidae' 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='Rallidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rallidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rallidae' 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='Rallidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Recurvirostra' AND (junior_species='andina' OR junior_species='andina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Recurvirostra' AND (species='andina' OR species='andina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Recurvirostra' AND (species='andina' OR species='andina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Recurvirostra' AND (junior_species='andina' OR junior_species='andina')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='Recurvirostra' AND (species='andina' OR species='andina') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3798
Reference:J. M. Capriles, J. Albarracin-Jordan, D. W. Bird, S. T. Goldstein, G. M. Jarpa, S. C. Maldonado, and C. M. Santoro. 2018. Mobility, subsistence, and technological strategies of early Holocene hunter-gatherers in the Bolivian Altiplano. Quaternary International473(B):190-205 [ER 3413]
Geography
Country: Bolivia
Coordinate:-18.06° S, -67.04° W
Coordinate basis: estimated from map
Time interval: Holocene
Max Ma: 0.008273
Min Ma: 0.008105
Age basis: radiocarbon (uncalibrated)
Geography comments: shown in Fig. at the eastern edge of Lake Uru-Uru, "125 km southeast of Viscachani"
there are uncalibrated 14C dates of 8273 +/- 82 and 8105 +/- 92 ybp, respectively on Lama guanicoe and Cavia tschudii
the material is from Unit 6
•
Environment
Lithology: not described
Taphonomic context: human accumulation,midden
Archaeology: stone tools
Habitat comments: a "trash pit"
"Approximately, 81% of the surface assemblage is lithic debitage, with the remaining 19% identified as stone tools and a few cores"
Methods
Life forms: carnivores,rodents,ungulates,birds
Sampling methods: quarry,surface
Sample size: 225 specimens
Years: 2005
Sampling comments: "Surface collections and excavations were carried out in 2005... All cultural materials from 100 plots (25 m2 each) were collected and six test pits were excavated"
Metadata
Sample number: 3798
Contributor: John Alroy
Enterer: John Alroy
Created: 2021-06-10 20:58:07
Modified: 2021-06-10 11:00:28
Abundance distribution
7 species
1 singleton
total count 225
extrapolated richness: 9.6
Fisher's α: 1.371
geometric series k: 0.4597
Hurlbert's PIE: 0.6178
Shannon's H: 1.1792
Good's u: 0.9956
Each square represents a species. Square sizes are proportional to counts.