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=3807 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3807SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3425SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3807 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mustelus' 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='Mustelus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mustelus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mustelus' 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='Mustelus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinobatos' AND (junior_species='planiceps' OR junior_species='planiceps')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhinobatos' AND (species='planiceps' OR species='planiceps') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhinobatos' AND (species='planiceps' OR species='planiceps')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinobatos' AND (junior_species='planiceps' OR junior_species='planiceps')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='Rhinobatos' AND (species='planiceps' OR species='planiceps') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sardinops' AND (junior_species='sagax' OR junior_species='sagax')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sardinops' AND (species='sagax' OR species='sagax') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sardinops' AND (species='sagax' OR species='sagax')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sardinops' AND (junior_species='sagax' OR junior_species='sagax')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='Sardinops' AND (species='sagax' OR species='sagax') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mugil' AND (junior_species='cephalus' OR junior_species='cephalus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mugil' AND (species='cephalus' OR species='cephalus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mugil' AND (species='cephalus' OR species='cephalus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mugil' AND (junior_species='cephalus' OR junior_species='cephalus')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='Mugil' AND (species='cephalus' OR species='cephalus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paralonchurus' AND (junior_species='peruanus' OR junior_species='peruanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Paralonchurus' AND (species='peruanus' OR species='peruanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paralonchurus' AND (species='peruanus' OR species='peruanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paralonchurus' AND (junior_species='peruanus' OR junior_species='peruanus')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='Paralonchurus' AND (species='peruanus' OR species='peruanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sciaena' AND (junior_species='deliciosa' OR junior_species='deliciosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sciaena' AND (species='deliciosa' OR species='deliciosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sciaena' AND (species='deliciosa' OR species='deliciosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sciaena' AND (junior_species='deliciosa' OR junior_species='deliciosa')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='Sciaena' AND (species='deliciosa' OR species='deliciosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anisotremus' AND (junior_species='scapularis' OR junior_species='scapularis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anisotremus' AND (species='scapularis' OR species='scapularis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anisotremus' AND (species='scapularis' OR species='scapularis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anisotremus' AND (junior_species='scapularis' OR junior_species='scapularis')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='Anisotremus' AND (species='scapularis' OR species='scapularis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phalacrocorax' AND (junior_species='bougainvilillii' OR junior_species='bougainvililli')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phalacrocorax' AND (species='bougainvilillii' OR species='bougainvililli') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phalacrocorax' AND (species='bougainvilillii' OR species='bougainvililli')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phalacrocorax' AND (junior_species='bougainvilillii' OR junior_species='bougainvililli')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='Phalacrocorax' AND (species='bougainvilillii' OR species='bougainvililli') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sula' AND (junior_species='variegata' OR junior_species='variegata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sula' AND (species='variegata' OR species='variegata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sula' AND (species='variegata' OR species='variegata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sula' AND (junior_species='variegata' OR junior_species='variegata')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='Sula' AND (species='variegata' OR species='variegata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pelecanus' 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='Pelecanus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pelecanus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pelecanus' 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='Pelecanus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zenaida' AND (junior_species='asiatica' OR junior_species='asiatica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zenaida' AND (species='asiatica' OR species='asiatica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zenaida' AND (species='asiatica' OR species='asiatica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zenaida' AND (junior_species='asiatica' OR junior_species='asiatica')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='Zenaida' AND (species='asiatica' OR species='asiatica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cavia' AND (junior_species='porcellus' OR junior_species='porcellus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cavia' AND (species='porcellus' OR species='porcellus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cavia' AND (species='porcellus' OR species='porcellus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cavia' AND (junior_species='porcellus' OR junior_species='porcellus')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='porcellus' OR species='porcellus') 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='Lycalopex' AND (junior_species='sechurae' OR junior_species='sechurae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lycalopex' AND (species='sechurae' OR species='sechurae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lycalopex' AND (species='sechurae' OR species='sechurae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lycalopex' AND (junior_species='sechurae' OR junior_species='sechurae')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='Lycalopex' AND (species='sechurae' OR species='sechurae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Otaria' 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='Otaria' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Otaria' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Otaria' 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='Otaria' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odocoileus' AND (junior_species='virginianus' OR junior_species='virginianus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Odocoileus' AND (species='virginianus' OR species='virginianus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odocoileus' AND (junior_species='virginianus' OR junior_species='virginianus')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='Odocoileus' AND (species='virginianus' OR species='virginianus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lama' 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='Lama' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lama' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lama' 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='Lama' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3807
Reference:A. K. Alaica. 2018. Partial and complete deposits and depictions: Social zooarchaeology, iconography and the role of animals in Late Moche Peru. Journal of Archaeological Science20:864-872 [ER 3425]
Geography
Country: Peru
Coordinate:-7.40° S, -79.45° W
Coordinate basis: estimated from map
Time interval: Holocene
Max Ma: 0.0013
Min Ma: 0.0011
Age basis: other
Geography comments: "Late Moche... AD650-850" based on ceramics
Habitat comments: "aa 20-m high pyramidal mound"
there is pottery and "copper slag and spindle whorls for the production of copper and textiles"
burials, hearths, and stone tools are present in the overall site, but Swenson et al. (2012) do not make clear if they are present in Zone A
Methods
Life forms: carnivores,rodents,ungulates,marine mammals,birds,fishes
Sampling methods: quarry
Sample size: 1874 specimens
Metadata
Sample number: 3807
Contributor: John Alroy
Enterer: John Alroy
Created: 2021-06-12 10:42:56
Modified: 2021-06-12 00:43:54
Abundance distribution
17 species
0 singletons
total count 1874
extrapolated richness: 20.6
Fisher's α: 2.580
geometric series k: 0.6729
Hurlbert's PIE: 0.5860
Shannon's H: 1.3237
Good's u: 1.0000
Each square represents a species. Square sizes are proportional to counts.