CNDR Finds Database - Insect Species table

Insect Species table

Sample	Context	CTX group	Entity	Trench	Order	Family	genus_or_species	Genus or Species	Quantity

Query Builder Result columns Filter by Order by Show page Items per page SQL result SELECT "sample_number", "context_number", "context_group", "entity", "trench", "order", "family", "genus_or_species", "genus_or_species_display", "rdb_status", "phytophage_plant_hosts", "ecology_codings", "quantity", "enviro_id" FROM insect_species_report ORDER BY "sample_number" ASC OFFSET 1290 LIMIT 10
first\|prev\|130 of 130\| next \| last
first\|prev\|130 of 130\| next \| last
1,296 records in total.Out of which 30 are unique records.
top
71165	71070	71060	Mesolithic organic deposit	Bay X	COLEOPTERA	Staphylinidae	Stilicus orbiculatus ...(see all) (Payk.)	Stilicus orbiculatus (Payk.)	1
71165	71070	71060	Mesolithic organic deposit	Bay X	COLEOPTERA	Staphylinidae	Tachinus spp.	Tachinus spp.	2
71165	71070	71060	Mesolithic organic deposit	Bay X	COLEOPTERA	Staphylinidae	Xantholinus spp.	Xantholinus spp.	1
71165	71070	71060	Mesolithic organic deposit	Bay X	DIPTERA	CYCLORRHAPHA Family, ...(see all) genus & spp. indet.	CYCLORRHAPHA Family, ...(see all) genus & spp. indet.	CYCLORRHAPHA Family, genus & spp. indet.	40
71165	71070	71060	Mesolithic organic deposit	Bay X	HEMIPTERA	HEMIPTERA Family, genus ...(see all) and spp. Indet.	HEMIPTERA Family, genus ...(see all) and spp. Indet.	HEMIPTERA Family, genus and spp. Indet.	2
71165	71070	71060	Mesolithic organic deposit	Bay X	TRICOPTERA	TRICOPTERA Genus and ...(see all) spp. Indet.	TRICOPTERA Genus and ...(see all) spp. Indet.	TRICOPTERA Genus and spp. Indet.	15