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=3559 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3559SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3231SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3559 ORDER BY register_no ASCSELECT 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='Bubalus' AND (junior_species='bubalis' OR junior_species='bubalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bubalus' AND (species='bubalis' OR species='bubalis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bubalus' AND (junior_species='bubalis' OR junior_species='bubalis')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='Bubalus' AND (species='bubalis' OR species='bubalis') 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='Boselaphus' AND (junior_species='tragocamelus' OR junior_species='tragocamelus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Boselaphus' AND (species='tragocamelus' OR species='tragocamelus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boselaphus' AND (junior_species='tragocamelus' OR junior_species='tragocamelus')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='Boselaphus' AND (species='tragocamelus' OR species='tragocamelus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gazella' AND (junior_species='bennettii' OR junior_species='bennetti')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gazella' AND (species='bennettii' OR species='bennetti') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gazella' AND (junior_species='bennettii' OR junior_species='bennetti')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='bennettii' OR species='bennetti') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetracerus' AND (junior_species='quadricornis' OR junior_species='quadricornis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tetracerus' AND (species='quadricornis' OR species='quadricornis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tetracerus' AND (species='quadricornis' OR species='quadricornis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetracerus' AND (junior_species='quadricornis' OR junior_species='quadricornis')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='Tetracerus' AND (species='quadricornis' OR species='quadricornis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Axis' AND (junior_species='axis' OR junior_species='axis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Axis' AND (species='axis' OR species='axis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Axis' AND (junior_species='axis' OR junior_species='axis')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='Axis' AND (species='axis' OR species='axis') 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='Lepus' AND (junior_species='nigricollis' OR junior_species='nigricollis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lepus' AND (species='nigricollis' OR species='nigricollis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lepus' AND (species='nigricollis' OR species='nigricollis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepus' AND (junior_species='nigricollis' OR junior_species='nigricollis')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='nigricollis' OR species='nigricollis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elephas' AND (junior_species='maximus' OR junior_species='maximus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elephas' AND (species='maximus' OR species='maximus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elephas' AND (junior_species='maximus' OR junior_species='maximus')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='Elephas' AND (species='maximus' OR species='maximus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Osteichthyes' 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='Osteichthyes' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Osteichthyes' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Osteichthyes' 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='Osteichthyes' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turbinella' AND (junior_species='pyrum' OR junior_species='pyrum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Turbinella' AND (species='pyrum' OR species='pyrum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Turbinella' AND (species='pyrum' OR species='pyrum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turbinella' AND (junior_species='pyrum' OR junior_species='pyrum')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='Turbinella' AND (species='pyrum' OR species='pyrum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scylla' AND (junior_species='serrata' OR junior_species='serrata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scylla' AND (species='serrata' OR species='serrata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scylla' AND (species='serrata' OR species='serrata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scylla' AND (junior_species='serrata' OR junior_species='serrata')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='Scylla' AND (species='serrata' OR species='serrata') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3559
Reference:P. P. Joglekar, G. S. Abhayan, J. Mungur-Medhi, and J. Nath. 2013. A glimpse of animal utilization pattern at Khirsara, Kachchh, Gujarat, India. Journal of Multidisciplinary Studies in Archaeology1:1-15 [ER 3231]
Geography
Country: India
State: Gujarat
Coordinate:23° 27' N, 69° 3' E
Coordinate basis: stated in text
Time interval: Holocene
Section: 3231
Unit number: 2
Unit order: above to below
Max Ma: 0.00445
Min Ma: 0.00385
Age basis: zone
Geography comments: near "Khirsara, a small village in western Kachchh" and the site is "locally known" as Gadhwali Wadi
"the entire deposit belongs to the mature phase of Harappan culture" (i.e., 25000 to 1900 B.C.: Possehl 2000)
•
Environment
Lithology: not described
Taphonomic context: human accumulation
Archaeology: bone tools,buildings
Habitat comments: a "fortified settlement, trapezoidal in shape (roughly 310 x 230 m)"
"Four bone fragments" appear to be tools; other tools are not discussed
Methods
Life forms: ungulates,other small mammals,fishes,crustaceans,snails
Sampling methods: quarry
Sample size: 55 specimens
Years: 2010, 2011
Sampling comments: excavated "since 2010" and the material was "found during the last two seasons of excavations"
Metadata
Sample number: 3559
Contributor: John Alroy
Enterer: John Alroy
Created: 2019-09-23 18:05:24
Modified: 2023-04-29 02:20:41
Abundance distribution
13 species
8 singletons
total count 55
extrapolated richness: 56.8
Fisher's α: 5.374
geometric series k: 0.7369
Hurlbert's PIE: 0.4798
Shannon's H: 1.3087
Good's u: 0.8572
Each square represents a species. Square sizes are proportional to counts.