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=3557 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3557SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3230SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3557 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='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='Digoniostoma' AND (junior_species='pulchella' OR junior_species='pulchella')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Digoniostoma' AND (species='pulchella' OR species='pulchella') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Digoniostoma' AND (species='pulchella' OR species='pulchella')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Digoniostoma' AND (junior_species='pulchella' OR junior_species='pulchella')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='Digoniostoma' AND (species='pulchella' OR species='pulchella') 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='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='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='Antilope' AND (junior_species='cervicapra' OR junior_species='cervicapra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Antilope' AND (species='cervicapra' OR species='cervicapra') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Antilope' AND (junior_species='cervicapra' OR junior_species='cervicapra')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='Antilope' AND (species='cervicapra' OR species='cervicapra') 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='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='Bubalus' AND (junior_species='arnee' OR junior_species='arnee')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='Bubalus' AND (species='arnee' OR species='arnee') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bubalus' AND (species='arnee' OR species='arnee')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bubalus' AND (junior_species='arnee' OR junior_species='arnee')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='Bubalus' AND (species='arnee' OR species='arnee') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bandicota' AND (junior_species='indica' OR junior_species='indica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bandicota' AND (species='indica' OR species='indica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bandicota' AND (species='indica' OR species='indica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bandicota' AND (junior_species='indica' OR junior_species='indica')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='Bandicota' AND (species='indica' OR species='indica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pila' AND (junior_species='globosa' OR junior_species='globosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pila' AND (species='globosa' OR species='globosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pila' AND (species='globosa' OR species='globosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pila' AND (junior_species='globosa' OR junior_species='globosa')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='Pila' AND (species='globosa' OR species='globosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zootecus' AND (junior_species='insularis' OR junior_species='insularis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zootecus' AND (species='insularis' OR species='insularis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zootecus' AND (species='insularis' OR species='insularis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zootecus' AND (junior_species='insularis' OR junior_species='insularis')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='Zootecus' AND (species='insularis' OR species='insularis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lamellidens' 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='Lamellidens' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lamellidens' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lamellidens' 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='Lamellidens' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3557 The Ecological Register: Girawad
Girawad
Basic information
Sample name: Girawad

Reference: C. V. Sharada, P. P. Joglekar, and V. S. Shinde. 2014. Faunal remains from Girawad (2006-2007), District Rohtak, Haryana. Journal of Multidisciplinary Studies in Archaeology 2:421-441 [ER 3230]
Geography
Country: India

State: Haryana


Coordinate: 28° 58' 41" N, 76° 28' 47" E
Coordinate basis: stated in text

Time interval: Holocene

Max Ma: 0.00515

Min Ma: 0.00455

Age basis: zone

Geography comments: "approximately 3 km to the east of the present village of Girawad"
"Early Harappan", which is 3200 to 2600 B.C. (Possehl 2000)

•
Environment
Lithology: not described

Taphonomic context: human accumulation

Archaeology: buildings,ceramics

Habitat comments: "an extensive single culture site spread over an area of roughly 8 hectares bearing the presence of Hakra, Early, Mature and Late Harappan ceramic remains" with "extensive pit-dwelling complexes" also including "mud brick structures"
metal and stone tools are not discussed

Methods
Life forms: carnivores,rodents,ungulates,birds,clams,snails

Sampling methods: quarry

Sample size: 249 specimens

Sampling comments: "thirteen pit-dwelling complexes" were excavated and sampled for zooarchaeological remains
there was no screening
a minimum figure of 150 NISP is given for Siluridae
"20 odd bones" of Rattus rattus are considered to be intrusive

Metadata
Sample number: 3557

Contributor: John Alroy

Enterer: John Alroy

Created: 2019-09-23 17:43:33

Modified: 2019-09-23 07:43:33

Abundance distribution
16 species
5 singletons
total count 249
extrapolated richness: 29.7
Fisher's α: 3.815
geometric series k: 0.7112
Hurlbert's PIE: 0.5349
Shannon's H: 1.3529
Good's u: 0.9800
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Bos taurus indicus166337 kg
"Bos indicus"
Bubalus bubalis15425 kg
Capra aegagrus hircus122 kg browser-grazer
"Capra hircus"
Ovis aries1041 kg
Digoniostoma pulchella2
"Diginostoma pulchella"
Canis lupus familiaris143 kg carnivore
"Canis familiaris"
Boselaphus tragocamelus5263 kg browser-grazer
Axis axis540 kg browser-grazer
Antilope cervicapra541 kg
Sus scrofa domesticus154 kg herbivore
"Sus domesticus"
Gazella bennettii117 kg browser-grazer
Bubalus arnee3
Bandicota indica2
Pila globosa4
Zootecus insularis1
Lamellidens sp.27