CNDR Finds Database - Insect Species table

Insect Species table

Sample	Context	CTX group	Entity	Trench	Order	Family	genus_or_species	Genus or Species	Ecology coding	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 20 LIMIT 10
first\|prev\|3 of 130\|next\|last
first\|prev\|3 of 130\|next\|last
1,296 records in total.Out of which 30 are unique records.
top
70294	70314	70300	Later Neolithic organic deposit	Bay D	COLEOPTERA	Staphylinidae	Aleocharinidae Genus ...(see all) & spp. Indet.	Aleocharinidae Genus & spp. Indet.		2
70294	70314	70300	Later Neolithic organic deposit	Bay D	COLEOPTERA	Staphylinidae	Lesteva longelytrata ...(see all) (Goeze)	Lesteva longelytrata (Goeze)	ws	1
70294	70314	70300	Later Neolithic organic deposit	Bay D	COLEOPTERA	Staphylinidae	Olophrum spp.	Olophrum spp.		1
70294	70314	70300	Later Neolithic organic deposit	Bay D	COLEOPTERA	Staphylinidae	Philonthus spp.	Philonthus spp.		1
70294	70314	70300	Later Neolithic organic deposit	Bay D	COLEOPTERA	Staphylinidae	Stenus spp.	Stenus spp.		3
70294	70314	70300	Later Neolithic organic deposit	Bay D	DIPTERA	CYCLORRHAPHA Family, ...(see all) genus & spp. indet.	CYCLORRHAPHA Family, ...(see all) genus & spp. indet.	CYCLORRHAPHA Family, genus & spp. indet.		15
70294	70314	70300	Later Neolithic organic deposit	Bay D	HYMENOPTERA	HYMENOPTERA Genus and ...(see all) spp. Indet.	HYMENOPTERA Genus and ...(see all) spp. Indet.	HYMENOPTERA Genus and spp. Indet.		2
70294	70314	70300	Later Neolithic organic deposit	Bay D	TRICOPTERA	TRICOPTERA Genus and ...(see all) spp. Indet.	TRICOPTERA Genus and ...(see all) spp. Indet.	TRICOPTERA Genus and spp. Indet.		4
70341	70187	70135	Earlier Neolithic alluvium	Bay B	COLEOPTERA	Carabidae	Pterostichus diligens ...(see all) (Sturm)	Pterostichus diligens (Sturm)		1
70341	70187	70135	Earlier Neolithic alluvium	Bay B	COLEOPTERA	Carabidae	Trechus spp.	Trechus spp.		1