CNDR Finds Database - Insect Species table

Insect Species table

Sample	Context	CTX group	Entity	Trench	Order	Family	genus_or_species	Genus or Species	Phytophage plant_hosts	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 1260 LIMIT 10
first\|prev\|127 of 130\|next\|last
first\|prev\|127 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	Dryopidae	Dryops spp.	Dryops spp.		a	1
71165	71070	71060	Mesolithic organic deposit	Bay X	COLEOPTERA	Dytiscidae	Agabus bipustulatus ...(see all)(L.)	Agabus bipustulatus (L.)		a	1
71165	71070	71060	Mesolithic organic deposit	Bay X	COLEOPTERA	Dytiscidae	Agabus spp	Agabus spp		a	4
71165	71070	71060	Mesolithic organic deposit	Bay X	COLEOPTERA	Dytiscidae	Hydroporus spp.	Hydroporus spp.		a	1
71165	71070	71060	Mesolithic organic deposit	Bay X	COLEOPTERA	Elateridae	Athous haemorrhoidalis ...(see all) (F.)	Athous haemorrhoidalis (F.)		p	1
71165	71070	71060	Mesolithic organic deposit	Bay X	COLEOPTERA	Helodidae	Helodidae Gen. & ...(see all) spp. Indet.	Helodidae Gen. & spp. Indet.		a	5
71165	71070	71060	Mesolithic organic deposit	Bay X	COLEOPTERA	Histeridae	Paromalus flavicornis ...(see all) (Hbst.)	Paromalus flavicornis (Hbst.)	associated with the deadwood ...(see all) and bracket fungi of a range of deciduous trees	dw	1
71165	71070	71060	Mesolithic organic deposit	Bay X	COLEOPTERA	Hydraenidae	Hydraena spp.	Hydraena spp.		a	13
71165	71070	71060	Mesolithic organic deposit	Bay X	COLEOPTERA	Hydraenidae	Limnebius spp.	Limnebius spp.		a	5
71165	71070	71060	Mesolithic organic deposit	Bay X	COLEOPTERA	Hydraenidae	Ochthebius minimus (F ...(see all).)	Ochthebius minimus (F.)		a	1