geocoded
Data license: Creative Commons V4.0 · Data source: Zoo Arch Project OSF
18 rows where continent = "Asia"
This data as json, CSV (advanced)
Suggested facets: sexOriginal, preparationsOriginal, NCBIIDref, NCBIID, NCBIIDURL, verbatimEventDate, locality, verbatimLocality, GBIFtaxonIDURL, allTaxonIDs, fishbaseID, canonicalName, scientificNameAuthorship, acceptedNameUsage, measurementRemarks, measurementType, measurementUnit, totalLength, catalogueYearYy, catalogueYearYyyy, geocoderDecimalLatitude, geocoderDecimalLongitude, DistanceInKMBetweenTwoCoordinates, georeferencePrecision, georeferenceRemarksFromGeocoder
vernacularName 10
occurrenceRemarks >10
- Caught off Kuril Island, Russia on 07/25/03, length: 21cm, weight: 162.2g, donated by: J. Waite 1
- Caught off Kuril Island, Russia on July 23, 2003; ID J. Waite, Length: 16.5cm, Weight: 59.0g, Donated by J. Waite 1
- Caught off Kuril Island, Russia on July 25, 2003, length: 29.0cm, weight: 723.9g, donated by: J. Waite 1
- Caught off Kuril Island, Russia on July 25, 2003; ID J. Waite, length: 26.0cm, weight: 160.7g, donated by: J Waite 1
- Caught off Kuril Island, Russia on July 27, 2003; ID J. Waite. Length: 29.0cm, Weight: 172.8g, Donated by: J. Waite 1
- Collected in Kuril Islands, length: 14.5cm, weight: 35.3g, donated by J. Waite, 25 July 03 1
- Collected in Kuril Islands, length: 24cm (TL), weight: 170g, donated by: Jason Waite, 25 July 03 1
- Collected in Kuril Islands, length: 25cm (TL), weight: 206g, donated by: Jason Waite, 25 July 03 1
- From Avancha bay , Kamchatka July 2001. Length: 10cm, Weight: 4.5g 1
- From Avancha bay Kamchatka. July 01. Length: 9.5cm, Weight: 3.2g 1
- …
occurrenceID >10
catalogNumber >10
bibliographicCitation >10
- University of Victoria, Zooarchaeology Lab Collection, UVICZL-03.30 1
- University of Victoria, Zooarchaeology Lab Collection, UVICZL-03.61 1
- University of Victoria, Zooarchaeology Lab Collection, UVICZL-03.62 1
- University of Victoria, Zooarchaeology Lab Collection, UVICZL-03.63 1
- University of Victoria, Zooarchaeology Lab Collection, UVICZL-04.103 1
- University of Victoria, Zooarchaeology Lab Collection, UVICZL-04.106 1
- University of Victoria, Zooarchaeology Lab Collection, UVICZL-04.107 1
- University of Victoria, Zooarchaeology Lab Collection, UVICZL-04.108 1
- University of Victoria, Zooarchaeology Lab Collection, UVICZL-04.17 1
- University of Victoria, Zooarchaeology Lab Collection, UVICZL-04.18 1
- …
taxonID 9
scientificName 9
- Gasterosteus aculeatus Linnaeus, 1758 4
- Gymnocanthus detrisus Gilbert & Burke, 1912 3
- Hemilepidotus zapus Gilbert & Burke, 1912 3
- Enophrys diceraus (Pallas, 1787) 2
- Hemitripterus villosus (Pallas, 1814) 2
- Atheresthes evermanni Jordan & Starks, 1904 1
- Hemilepidotus gilberti Jordan & Starks, 1904 1
- Mallotus villosus (Müller, 1776) 1
- Oncorhynchus masou (Brevoort, 1856) 1
fishbaseIDURL 9
- http://www.fishbase.se/summary/2420 4
- https://www.fishbase.ca/summary/23956 3
- https://www.fishbase.ca/summary/4096 3
- https://www.fishbase.ca/summary/11725 2
- https://www.fishbase.ca/summary/4087 2
- http://www.fishbase.se/summary/242 1
- http://www.fishbase.se/summary/252 1
- http://www.fishbase.se/summary/518 1
- https://www.fishbase.ca/summary/23903 1
NCBIIDrefURL 9
GBIFtaxonID 9
specificEpithet 8
genus 8
- Gasterosteus 4
- Hemilepidotus 4
- Gymnocanthus 3
- Enophrys 2
- Hemitripterus 2
- Atheresthes 1
- Mallotus 1
- Oncorhynchus 1
order 5
family 5
- Cottidae 11
- Gasterosteidae 4
- Osmeridae 1
- Pleuronectidae 1
- Salmonidae 1
recordedBy 3
eventRemarks 3
decimalLongitude 3
- 152.0 12
- 158.566852 5
- 139.6 1
waterBody 2
- - 17
- Kuril Island River 1
preparations 2
islandGroup 2
- Kuril Islands 12
- - 6
taxonRank 1
- species 18
subgenus 1
- - 18
stateProvince 1
- - 18
phylum 1
- Chordata 18
lifeStage 1
- - 18
kingdom 1
- Animalia 18
island 1
- - 18
infraspecificEpithet 1
- - 18
georeferencedBy 1
georeferenceSources 1
georeferenceRemarks 1
- - 18
dynamicProperties 1
- - 18
datasetName 1
- UVICZL Fish 18
coordinatePrecision 1
- - 18
continent 1
- Asia · 18 ✖
associatedReferences 1
- - 18
associatedMedia 1
- - 18
IndigenousName 1
- - 18
Link | rowid ▼ | Index | type | language | license | rightsHolder | accessRights | bibliographicCitation | collectionID | institutionCode | institutionID | collectionCode | datasetName | basisOfRecord | dynamicProperties | occurenceIDURL | occurrenceID | catalogNumber | recordedBy | sexOriginal | sex | lifeStageOriginal | lifeStage | preparationsOriginal | preparations | disposition | associatedMedia | associatedReferences | NCBIIDrefURL | NCBIIDref | NCBIID | NCBIIDURL | otherCatalogNumbers | occurrenceRemarksOriginal | occurrenceRemarks | eventRemarks | eventDate | verbatimEventDate | year | month | day | continent | waterBody | islandGroup | island | country | countryCode | stateProvince | municipality | locality | verbatimLocality | locationRemarks | verbatimCoordinates | geodeticDatum | decimalLatitude | decimalLongitude | coordinateUncertaintyInMeters | coordinatePrecision | georeferencedBy | georeferenceSources | georeferenceRemarks | identifiedBy | identificationRemarks | GBIFtaxonIDURL | GBIFtaxonID | allTaxonIDs | ITIStaxonID | taxonID | fishbaseIDURL | fishbaseID | canonicalName | scientificName | kingdom | phylum | _73 | order | family | genus | subgenus | specificEpithet | infraspecificEpithet | taxonRank | scientificNameAuthorship | taxonomicStatus | acceptedNameUsage | vernacularName | IndigenousName | _86 | taxonRemarks | previousIdentifications | measurementRemarks | measurementType | measurementUnit | measurementValue | weight | length | width | totalLength | forkLength | standardLength | wing | tarsus | culmen | diameter | catalogueYearYy | catalogueNumberNn | catalogueYearYyyy | geocoderDecimalLatitude | geocoderDecimalLongitude | DistanceInKMBetweenTwoCoordinates | nativeLandLanguage | georeferencePrecision | georeferenceRemarksFromGeocoder | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1121 | 1121 | 1120 | 1230 | PhysicalObject | en | http://creativecommons.org/licenses/by/4.0/legalcode | The Anthropology Department of the University of Victoria | University of Victoria, Zooarchaeology Lab Collection, UVICZL-06.8 | https://www.gbif.org/grscicoll/collection/1cbebd16-1e98-417a-b1fe-531208312892 | UVIC | http://grscicoll.org/institution/university-victoria | UVICZL | UVICZL Fish | PreservedSpecimen | UVICZL-06.8 | 06.8 | NCBI:txID30960 | NCBI:txID30960 | 30960 | https://www.ncbi.nlm.nih.gov/Taxonomy/Browser/wwwtax.cgi?id=30960 | 06/8 | From Kamchatka, Avacha bay, caught July, 2001. TL= 16.5cm. Weight: 20.4g | Date of death | 2001-7-1 | 2001 | 7 | 1 | Asia | Russia | RU | Kamchatka | Avacha Bay | Avacha Bay, Kamchatka | unknown | 52.967732 | 158.566852 | 0.0846 | steve.vandervalk@hakai.org | Hakai Institute of the Tula Foundation | Ubaldino, M (MITRE Corporation), 'OpenSextant Xponents: Geotagging Toolkit for World-wide Geography', 2019. https://opensextant.github.io/Xponents/ | https://www.gbif.org/species/5214420 | 5214420 | https://www.gbif.org/species/5214420|http://www.fishbase.se/summary/252|NCBI:txID30960 | 162035 | ITIS TSN: 162035 | http://www.fishbase.se/summary/252 | 252 | Mallotus villosus | Mallotus villosus (Müller, 1776) | Animalia | Chordata | Actinopterygii | Osmeriformes | Osmeridae | Mallotus | villosus | species | (Müller, 1776) | accepted | Mallotus villosus (Müller, 1776) | Capelin | weight | Weight | Length | g | cm | 16.5 | 20.4 | 16.5 | 6 | 8 | 2006 | 50000.0 | Avacha Bay, Kamchatka | |||||||||||||||||||||||||||||||||||||||||||
1164 | 1164 | 1163 | 1299 | PhysicalObject | en | http://creativecommons.org/licenses/by/4.0/legalcode | The Anthropology Department of the University of Victoria | University of Victoria, Zooarchaeology Lab Collection, UVICZL-06.7 | https://www.gbif.org/grscicoll/collection/1cbebd16-1e98-417a-b1fe-531208312892 | UVIC | http://grscicoll.org/institution/university-victoria | UVICZL | UVICZL Fish | PreservedSpecimen | UVICZL-06.7 | 06.7 | Jason Waite | skeleton | vertebrate elements tDAR Faunal Element Ontology doi:10.6067/XCV8HQ3XDT | skeleton OLS Uber anatomy ontology http://purl.obolibrary.org/obo/UBERON_0004288 | NCBI:txid274760 | 274760 | 06/7 | Kuril Island, Russia, caught on July 25, 2003, length: TL~12 cm (tail falling off), weight: 23.3g, donated by: J. Waite | Kuril Island, Russia, caught on July 25, 2003, length: TL~12 cm (tail falling off), weight: 23.3g, donated by: J. Waite | Date of death | 2003-7-25 | 2003 | 7 | 25 | Asia | Kuril Islands | Russia | RU | Kuril Islands, Russia | unknown | 46.16667 | 152.0 | 0.0 | steve.vandervalk@hakai.org | Hakai Institute of the Tula Foundation | Ubaldino, M (MITRE Corporation), 'OpenSextant Xponents: Geotagging Toolkit for World-wide Geography', 2019. https://opensextant.github.io/Xponents/ | https://www.gbif.org/species/2333944 | 2333944 | https://www.gbif.org/species/2333944|https://www.fishbase.ca/summary/4096|NCBI:txid274760 | 167284 | ITIS TSN: 167284 | https://www.fishbase.ca/summary/4096 | 4096 | Hemilepidotus zapus | Hemilepidotus zapus Gilbert & Burke, 1912 | Animalia | Chordata | Actinopterygii | Scorpaeniforms | Cottidae | Hemilepidotus | zapus | species | Gilbert & Burke, 1912 | accepted | Hemilepidotus zapus Gilbert & Burke, 1912 | Longfin Irish Lord | weightlength | Weight | Length | g | cm | 12 | 23.3 | 6 | 7 | 50000.0 | Russia | ||||||||||||||||||||||||||||||||||||||||||||
1236 | 1236 | 1235 | 1387 | PhysicalObject | en | http://creativecommons.org/licenses/by/4.0/legalcode | The Anthropology Department of the University of Victoria | University of Victoria, Zooarchaeology Lab Collection, UVICZL-04.17 | https://www.gbif.org/grscicoll/collection/1cbebd16-1e98-417a-b1fe-531208312892 | UVIC | http://grscicoll.org/institution/university-victoria | UVICZL | UVICZL Fish | PreservedSpecimen | UVICZL-04.17 | 04.17 | Jason Waite | Alaska Sealife Center | skeleton | vertebrate elements tDAR Faunal Element Ontology doi:10.6067/XCV8HQ3XDT | skeleton OLS Uber anatomy ontology http://purl.obolibrary.org/obo/UBERON_0004288 | NCBI:txid255553 | 255553 | 04/17 | length: 17.3cm, weight: 47.7g, Kuril Is, RU, ID - J. Waite 7/25/03 | Length: 17.3cm, weight: 47.7g, Kuril Is, RU, ID - J. Waite 7/25/03 | Date entered collection | 2003-7-25 | 2003 | 7 | 25 | Asia | Kuril Islands | Russia | RU | Kuril Islands, Russia | unknown | 46.16667 | 152.0 | 0.0 | steve.vandervalk@hakai.org | Hakai Institute of the Tula Foundation | Ubaldino, M (MITRE Corporation), 'OpenSextant Xponents: Geotagging Toolkit for World-wide Geography', 2019. https://opensextant.github.io/Xponents/ | https://www.gbif.org/species/2334015 | 2334015 | https://www.gbif.org/species/2334015|https://www.fishbase.ca/summary/23956|NCBI:txid255553 | 167272 | ITIS TSN: 167272 | https://www.fishbase.ca/summary/23956 | 23956 | Gymnocanthus detrisus | Gymnocanthus detrisus Gilbert & Burke, 1912 | Animalia | Chordata | Actinopterygii | Scorpaeniforms | Cottidae | Gymnocanthus | detrisus | species | Gilbert & Burke, 1912 | accepted | Gymnocanthus detrisus Gilbert & Burke, 1912 | Purplegray Sculpin | weightlength | Weight | Length | g | cm | 17.3 | 47.7 | 4 | 17 | 50000.0 | Russia | ||||||||||||||||||||||||||||||||||||||||||||
1245 | 1245 | 1244 | 1396 | PhysicalObject | en | http://creativecommons.org/licenses/by/4.0/legalcode | The Anthropology Department of the University of Victoria | University of Victoria, Zooarchaeology Lab Collection, UVICZL-04.18 | https://www.gbif.org/grscicoll/collection/1cbebd16-1e98-417a-b1fe-531208312892 | UVIC | http://grscicoll.org/institution/university-victoria | UVICZL | UVICZL Fish | PreservedSpecimen | UVICZL-04.18 | 04.18 | Jason Waite | Alaska Sealife Center | skeleton | vertebrate elements tDAR Faunal Element Ontology doi:10.6067/XCV8HQ3XDT | skeleton OLS Uber anatomy ontology http://purl.obolibrary.org/obo/UBERON_0004288 | NCBI:txid255553 | 255553 | 04/18 | length: 19.6.cm, weight: 76.9g, Kuril Is, RU, ID - J. Waite 7/25/03 | Length: 19.6.cm, weight: 76.9g, Kuril Is, RU, ID - J. Waite 7/25/03 | Date entered collection | 2003-7-25 | 2003 | 7 | 25 | Asia | Kuril Islands | Russia | RU | Kuril Islands, Russia | unknown | 46.16667 | 152.0 | 0.0 | steve.vandervalk@hakai.org | Hakai Institute of the Tula Foundation | Ubaldino, M (MITRE Corporation), 'OpenSextant Xponents: Geotagging Toolkit for World-wide Geography', 2019. https://opensextant.github.io/Xponents/ | https://www.gbif.org/species/2334015 | 2334015 | https://www.gbif.org/species/2334015|https://www.fishbase.ca/summary/23956|NCBI:txid255553 | 167272 | ITIS TSN: 167272 | https://www.fishbase.ca/summary/23956 | 23956 | Gymnocanthus detrisus | Gymnocanthus detrisus Gilbert & Burke, 1912 | Animalia | Chordata | Actinopterygii | Scorpaeniforms | Cottidae | Gymnocanthus | detrisus | species | Gilbert & Burke, 1912 | accepted | Gymnocanthus detrisus Gilbert & Burke, 1912 | Purplegray Sculpin | weightlength | Weight | Length | g | cm | 19.6 | 76.9 | 4 | 18 | 50000.0 | Russia | ||||||||||||||||||||||||||||||||||||||||||||
1339 | 1339 | 1338 | 1504 | PhysicalObject | en | http://creativecommons.org/licenses/by/4.0/legalcode | The Anthropology Department of the University of Victoria | University of Victoria, Zooarchaeology Lab Collection, UVICZL-03.30 | https://www.gbif.org/grscicoll/collection/1cbebd16-1e98-417a-b1fe-531208312892 | UVIC | http://grscicoll.org/institution/university-victoria | UVICZL | UVICZL Fish | PreservedSpecimen | UVICZL-03.30 | 03.30 | NCBI:txID8020 | NCBI:txID8020 | 8020 | https://www.ncbi.nlm.nih.gov/Taxonomy/Browser/wwwtax.cgi?id=8020 | 03/30 | Sent from Japan, gutted and salted, weight not collected | Sent from Japan, gutted and salted, weight not collected. Length: approx. 5cm. Donated by a Japanese researcher. | -- | Asia | Japan | JP | Japan | unknown | 36.75 | 139.6 | 0.0 | steve.vandervalk@hakai.org | Hakai Institute of the Tula Foundation | Ubaldino, M (MITRE Corporation), 'OpenSextant Xponents: Geotagging Toolkit for World-wide Geography', 2019. https://opensextant.github.io/Xponents/ | https://www.gbif.org/species/5711979 | 5711979 | https://www.gbif.org/species/5711979|http://www.fishbase.se/summary/242|NCBI:txID8020 | 161978 | ITIS TSN: 161978 | http://www.fishbase.se/summary/242 | 242 | Oncorhynchus masou | Oncorhynchus masou (Brevoort, 1856) | Animalia | Chordata | Actinopterygii | Salmoniformes | Salmonidae | Oncorhynchus | masou | species | (Brevoort, 1856) | accepted | Oncorhynchus masou (Brevoort, 1856) | Masou Salmon | weightlength | 52 | 3 | 30 | 1000.0 | Japan | |||||||||||||||||||||||||||||||||||||||||||||||||||||
1468 | 1468 | 1467 | 1642 | PhysicalObject | en | http://creativecommons.org/licenses/by/4.0/legalcode | The Anthropology Department of the University of Victoria | University of Victoria, Zooarchaeology Lab Collection, UVICZL-03.61 | https://www.gbif.org/grscicoll/collection/1cbebd16-1e98-417a-b1fe-531208312892 | UVIC | http://grscicoll.org/institution/university-victoria | UVICZL | UVICZL Fish | PreservedSpecimen | UVICZL-03.61 | 03.61 | Jason Waite | Alaska Sealife Center | skeleton | vertebrate elements tDAR Faunal Element Ontology doi:10.6067/XCV8HQ3XDT | skeleton OLS Uber anatomy ontology http://purl.obolibrary.org/obo/UBERON_0004288 | NCBI:txid238838 | 238838 | 03/61 | collected in Kuril Islands, length: 14.5cm, weight: 35.3g, donated by J. Waite, 25 July 03 | Collected in Kuril Islands, length: 14.5cm, weight: 35.3g, donated by J. Waite, 25 July 03 | Date entered collection | 2003-7-25 | 2003 | 7 | 25 | Asia | Kuril Islands | Russia | RU | Kuril Islands, Russia | unknown | 46.16667 | 152.0 | 0.0 | steve.vandervalk@hakai.org | Hakai Institute of the Tula Foundation | Ubaldino, M (MITRE Corporation), 'OpenSextant Xponents: Geotagging Toolkit for World-wide Geography', 2019. https://opensextant.github.io/Xponents/ | https://www.gbif.org/species/2333948 | 2333948 | https://www.gbif.org/species/2333948|https://www.fishbase.ca/summary/23903|NCBI:txid238838 | 167278 | ITIS TSN: 167278 | https://www.fishbase.ca/summary/23903 | 23903 | Hemilepidotus gilberti | Hemilepidotus gilberti Jordan & Starks, 1904 | Animalia | Chordata | Actinopterygii | Scorpaeniforms | Cottidae | Hemilepidotus | gilberti | species | Jordan & Starks, 1904 | accepted | Hemilepidotus gilberti Jordan & Starks, 1904 | Banded Irish Lord | weightlength | Weight | Length | g | cm | 14.5 | 35.3 | 3 | 61 | 50000.0 | Russia | ||||||||||||||||||||||||||||||||||||||||||||
1472 | 1472 | 1471 | 1646 | PhysicalObject | en | http://creativecommons.org/licenses/by/4.0/legalcode | The Anthropology Department of the University of Victoria | University of Victoria, Zooarchaeology Lab Collection, UVICZL-03.62 | https://www.gbif.org/grscicoll/collection/1cbebd16-1e98-417a-b1fe-531208312892 | UVIC | http://grscicoll.org/institution/university-victoria | UVICZL | UVICZL Fish | PreservedSpecimen | UVICZL-03.62 | 03.62 | Jason Waite | Alaska Sealife Center | skeleton | vertebrate elements tDAR Faunal Element Ontology doi:10.6067/XCV8HQ3XDT | skeleton OLS Uber anatomy ontology http://purl.obolibrary.org/obo/UBERON_0004288 | NCBI:txid980326 | 980326 | 03/62 | collected in Kuril Islands, length: 25cm (TL), weight: 206g, donated by: Jason Waite, 25 July 03 | Collected in Kuril Islands, length: 25cm (TL), weight: 206g, donated by: Jason Waite, 25 July 03 | Date entered collection | 2003-7-25 | 2003 | 7 | 25 | Asia | Kuril Islands | Russia | RU | Kuril Islands, Russia | unknown | 46.16667 | 152.0 | 0.0 | steve.vandervalk@hakai.org | Hakai Institute of the Tula Foundation | Ubaldino, M (MITRE Corporation), 'OpenSextant Xponents: Geotagging Toolkit for World-wide Geography', 2019. https://opensextant.github.io/Xponents/ | https://www.gbif.org/species/5201186 | 5201186 | https://www.gbif.org/species/5201186|https://www.fishbase.ca/summary/4087|NCBI:txid980326 | 167268 | ITIS TSN: 167268 | https://www.fishbase.ca/summary/4087 | 4087 | Enophrys diceraus | Enophrys diceraus (Pallas, 1787) | Animalia | Chordata | Actinopterygii | Scorpaeniforms | Cottidae | Enophrys | diceraus | species | (Pallas, 1787) | accepted | Enophrys diceraus (Pallas, 1787) | Antlered Sculpin | weightlength | Weight | Length | g | cm | 25 | 206 | 3 | 62 | 1000.0 | Russia | ||||||||||||||||||||||||||||||||||||||||||||
1476 | 1476 | 1475 | 1650 | PhysicalObject | en | http://creativecommons.org/licenses/by/4.0/legalcode | The Anthropology Department of the University of Victoria | University of Victoria, Zooarchaeology Lab Collection, UVICZL-03.63 | https://www.gbif.org/grscicoll/collection/1cbebd16-1e98-417a-b1fe-531208312892 | UVIC | http://grscicoll.org/institution/university-victoria | UVICZL | UVICZL Fish | PreservedSpecimen | UVICZL-03.63 | 03.63 | Jason Waite | Alaska Sealife Center | skeleton | vertebrate elements tDAR Faunal Element Ontology doi:10.6067/XCV8HQ3XDT | skeleton OLS Uber anatomy ontology http://purl.obolibrary.org/obo/UBERON_0004288 | NCBI:txid980326 | 980326 | 03/63 | collected in Kuril Islands, length: 24cm (TL), weight: 170g, donated by: Jason Waite, 25 July 03 | Collected in Kuril Islands, length: 24cm (TL), weight: 170g, donated by: Jason Waite, 25 July 03 | Date entered collection | 2003-7-25 | 2003 | 7 | 25 | Asia | Kuril Islands | Russia | RU | Kuril Islands, Russia | unknown | 46.16667 | 152.0 | 0.0 | steve.vandervalk@hakai.org | Hakai Institute of the Tula Foundation | Ubaldino, M (MITRE Corporation), 'OpenSextant Xponents: Geotagging Toolkit for World-wide Geography', 2019. https://opensextant.github.io/Xponents/ | https://www.gbif.org/species/5201186 | 5201186 | https://www.gbif.org/species/5201186|https://www.fishbase.ca/summary/4087|NCBI:txid980326 | 167268 | ITIS TSN: 167268 | https://www.fishbase.ca/summary/4087 | 4087 | Enophrys diceraus | Enophrys diceraus (Pallas, 1787) | Animalia | Chordata | Actinopterygii | Scorpaeniforms | Cottidae | Enophrys | diceraus | species | (Pallas, 1787) | accepted | Enophrys diceraus (Pallas, 1787) | Antlered Sculpin | weightlength | Weight | Length | g | cm | 24 | 170 | 3 | 63 | 1000.0 | Russia | ||||||||||||||||||||||||||||||||||||||||||||
1531 | 1531 | 1530 | 1715 | PhysicalObject | en | http://creativecommons.org/licenses/by/4.0/legalcode | The Anthropology Department of the University of Victoria | University of Victoria, Zooarchaeology Lab Collection, UVICZL-04.76 | https://www.gbif.org/grscicoll/collection/1cbebd16-1e98-417a-b1fe-531208312892 | UVIC | http://grscicoll.org/institution/university-victoria | UVICZL | UVICZL Fish | PreservedSpecimen | UVICZL-04.76 | 04.76 | F | Female tDAR Faunal Sex Ontology doi:10.6067/XCV87H1GP8 | NCBI:txID69293 | NCBI:txID69293 | 69293 | https://www.ncbi.nlm.nih.gov/Taxonomy/Browser/wwwtax.cgi?id=69293 | 04/76 | From Avancha bay Kamchatka. July 01. Length: 9.5cm, Weight: 3.2g | Date of death | 2004-7-1 | 2004 | 7 | 1 | Asia | Russia | RU | Kamchatka | Avacha Bay | Avacha Bay, Kamchatka | unknown | 52.967732 | 158.566852 | 0.0846 | steve.vandervalk@hakai.org | Hakai Institute of the Tula Foundation | Ubaldino, M (MITRE Corporation), 'OpenSextant Xponents: Geotagging Toolkit for World-wide Geography', 2019. https://opensextant.github.io/Xponents/ | https://www.gbif.org/species/4286327 | 4286327 | https://www.gbif.org/species/4286327|http://www.fishbase.se/summary/2420|NCBI:txID69293 | 166365 | ITIS TSN: 166365 | http://www.fishbase.se/summary/2420 | 2420 | Gasterosteus aculeatus | Gasterosteus aculeatus Linnaeus, 1758 | Animalia | Chordata | Actinopterygii | Gasterosteiformes | Gasterosteidae | Gasterosteus | aculeatus | species | Linnaeus, 1758 | accepted | Gasterosteus aculeatus Linnaeus, 1758 | Three-spine Stickleback | weightlength | Weight | g | 9.5 | 3.2 | 4 | 76 | 50000.0 | Avacha Bay, Kamchatka | |||||||||||||||||||||||||||||||||||||||||||
1536 | 1536 | 1535 | 1723 | PhysicalObject | en | http://creativecommons.org/licenses/by/4.0/legalcode | The Anthropology Department of the University of Victoria | University of Victoria, Zooarchaeology Lab Collection, UVICZL-04.77 | https://www.gbif.org/grscicoll/collection/1cbebd16-1e98-417a-b1fe-531208312892 | UVIC | http://grscicoll.org/institution/university-victoria | UVICZL | UVICZL Fish | PreservedSpecimen | UVICZL-04.77 | 04.77 | Female | Female tDAR Faunal Sex Ontology doi:10.6067/XCV87H1GP8 | NCBI:txID69293 | NCBI:txID69293 | 69293 | https://www.ncbi.nlm.nih.gov/Taxonomy/Browser/wwwtax.cgi?id=69293 | 04/77 | From Avancha bay, Kamchatka, July 2001. Length: 8.75cm, weight: 2.8g | Date of death | 2004-7-1 | 2004 | 7 | 1 | Asia | Russia | RU | Kamchatka | Avacha Bay | Avacha Bay, Kamchatka | unknown | 52.967732 | 158.566852 | 0.0846 | steve.vandervalk@hakai.org | Hakai Institute of the Tula Foundation | Ubaldino, M (MITRE Corporation), 'OpenSextant Xponents: Geotagging Toolkit for World-wide Geography', 2019. https://opensextant.github.io/Xponents/ | https://www.gbif.org/species/4286327 | 4286327 | https://www.gbif.org/species/4286327|http://www.fishbase.se/summary/2420|NCBI:txID69293 | 166365 | ITIS TSN: 166365 | http://www.fishbase.se/summary/2420 | 2420 | Gasterosteus aculeatus | Gasterosteus aculeatus Linnaeus, 1758 | Animalia | Chordata | Actinopterygii | Gasterosteiformes | Gasterosteidae | Gasterosteus | aculeatus | species | Linnaeus, 1758 | accepted | Gasterosteus aculeatus Linnaeus, 1758 | Three-Spine Stickleback | weightlength | Weight | g | 8.75 | 2.8 | 4 | 77 | 50000.0 | Avacha Bay, Kamchatka | |||||||||||||||||||||||||||||||||||||||||||
1542 | 1542 | 1541 | 1730 | PhysicalObject | en | http://creativecommons.org/licenses/by/4.0/legalcode | The Anthropology Department of the University of Victoria | University of Victoria, Zooarchaeology Lab Collection, UVICZL-04.78 | https://www.gbif.org/grscicoll/collection/1cbebd16-1e98-417a-b1fe-531208312892 | UVIC | http://grscicoll.org/institution/university-victoria | UVICZL | UVICZL Fish | PreservedSpecimen | UVICZL-04.78 | 04.78 | F | Female tDAR Faunal Sex Ontology doi:10.6067/XCV87H1GP8 | NCBI:txID69293 | NCBI:txID69293 | 69293 | https://www.ncbi.nlm.nih.gov/Taxonomy/Browser/wwwtax.cgi?id=69293 | 04/78 | From Avancha bay , Kamchatka July 2001. Length: 10cm, Weight: 4.5g | Date of death | 2004-7-1 | 2004 | 7 | 1 | Asia | Russia | RU | Kamchatka | Avacha Bay | Avacha Bay, Kamchatka | unknown | 52.967732 | 158.566852 | 0.0846 | steve.vandervalk@hakai.org | Hakai Institute of the Tula Foundation | Ubaldino, M (MITRE Corporation), 'OpenSextant Xponents: Geotagging Toolkit for World-wide Geography', 2019. https://opensextant.github.io/Xponents/ | https://www.gbif.org/species/4286327 | 4286327 | https://www.gbif.org/species/4286327|http://www.fishbase.se/summary/2420|NCBI:txID69293 | 166365 | ITIS TSN: 166365 | http://www.fishbase.se/summary/2420 | 2420 | Gasterosteus aculeatus | Gasterosteus aculeatus Linnaeus, 1758 | Animalia | Chordata | Actinopterygii | Gasterosteiformes | Gasterosteidae | Gasterosteus | aculeatus | species | Linnaeus, 1758 | accepted | Gasterosteus aculeatus Linnaeus, 1758 | Three-spine Stickleback | weightlength | Weight | g | 10 | 4.5 | 4 | 78 | 50000.0 | Avacha Bay, Kamchatka | |||||||||||||||||||||||||||||||||||||||||||
1548 | 1548 | 1547 | 1737 | PhysicalObject | en | http://creativecommons.org/licenses/by/4.0/legalcode | The Anthropology Department of the University of Victoria | University of Victoria, Zooarchaeology Lab Collection, UVICZL-04.79 | https://www.gbif.org/grscicoll/collection/1cbebd16-1e98-417a-b1fe-531208312892 | UVIC | http://grscicoll.org/institution/university-victoria | UVICZL | UVICZL Fish | PreservedSpecimen | UVICZL-04.79 | 04.79 | NCBI:txID69293 | NCBI:txID69293 | 69293 | https://www.ncbi.nlm.nih.gov/Taxonomy/Browser/wwwtax.cgi?id=69293 | 04/79 | From Avancha bay, Kamchatka July 2001. Weight: 3.8g, Length: 9.5cm | Date of death | 2004-7-1 | 2004 | 7 | 1 | Asia | Russia | RU | Kamchatka | Avacha Bay | Avacha Bay, Kamchatka | unknown | 52.967732 | 158.566852 | 0.0846 | steve.vandervalk@hakai.org | Hakai Institute of the Tula Foundation | Ubaldino, M (MITRE Corporation), 'OpenSextant Xponents: Geotagging Toolkit for World-wide Geography', 2019. https://opensextant.github.io/Xponents/ | https://www.gbif.org/species/4286327 | 4286327 | https://www.gbif.org/species/4286327|http://www.fishbase.se/summary/2420|NCBI:txID69293 | 166365 | ITIS TSN: 166365 | http://www.fishbase.se/summary/2420 | 2420 | Gasterosteus aculeatus | Gasterosteus aculeatus Linnaeus, 1758 | Animalia | Chordata | Actinopterygii | Gasterosteiformes | Gasterosteidae | Gasterosteus | aculeatus | species | Linnaeus, 1758 | accepted | Gasterosteus aculeatus Linnaeus, 1758 | Three-spine Stickleback | weightlength | Weight | g | 9.5 | 3.8000000000000003 | 4 | 79 | 50000.0 | Avacha Bay, Kamchatka | |||||||||||||||||||||||||||||||||||||||||||||
1586 | 1586 | 1585 | 1782 | PhysicalObject | en | http://creativecommons.org/licenses/by/4.0/legalcode | The Anthropology Department of the University of Victoria | University of Victoria, Zooarchaeology Lab Collection, UVICZL-04.88 | https://www.gbif.org/grscicoll/collection/1cbebd16-1e98-417a-b1fe-531208312892 | UVIC | http://grscicoll.org/institution/university-victoria | UVICZL | UVICZL Fish | PreservedSpecimen | UVICZL-04.88 | 04.88 | skeleton | vertebrate elements tDAR Faunal Element Ontology doi:10.6067/XCV8HQ3XDT | skeleton OLS Uber anatomy ontology http://purl.obolibrary.org/obo/UBERON_0004288 | NCBI:txid255551 | 255551 | 04/88 | Kuril Island River, weight 194.6g, length 25cm | Kuril Island River, weight 194.6g, length 25cm | Date entered collection | 1988-- | 1988-- | 1988 | Asia | Kuril Island River | Kuril Islands | Russia | RU | Kuril Island River | unknown | 46.16667 | 152.0 | 0.0596 | steve.vandervalk@hakai.org | Hakai Institute of the Tula Foundation | Ubaldino, M (MITRE Corporation), 'OpenSextant Xponents: Geotagging Toolkit for World-wide Geography', 2019. https://opensextant.github.io/Xponents/ | https://www.gbif.org/species/2335110 | 2335110 | https://www.gbif.org/species/2335110|https://www.fishbase.ca/summary/11725|NCBI:txid255551 | 167286 | ITIS TSN: 167286 | https://www.fishbase.ca/summary/11725 | 11725 | Hemitripterus villosus | Hemitripterus villosus (Pallas, 1814) | Animalia | Chordata | Actinopterygii | Scorpaeniforms | Cottidae | Hemitripterus | villosus | species | (Pallas, 1814) | accepted | Hemitripterus villosus (Pallas, 1814) | Shaggy Sea Raven | weightlength | Weight | Length | g | cm | 25 | 194.6 | 4 | 88 | 55.15019 | -88.71666 | 7396.806960635642 | Ainu Itak | 50000.0 | Island River | |||||||||||||||||||||||||||||||||||||||||
1634 | 1634 | 1633 | 1837 | PhysicalObject | en | http://creativecommons.org/licenses/by/4.0/legalcode | The Anthropology Department of the University of Victoria | University of Victoria, Zooarchaeology Lab Collection, UVICZL-04.99 | https://www.gbif.org/grscicoll/collection/1cbebd16-1e98-417a-b1fe-531208312892 | UVIC | http://grscicoll.org/institution/university-victoria | UVICZL | UVICZL Fish | PreservedSpecimen | UVICZL-04.99 | 04.99 | Jason Waite | Alaska Sealife Center | skeleton | vertebrate elements tDAR Faunal Element Ontology doi:10.6067/XCV8HQ3XDT | skeleton OLS Uber anatomy ontology http://purl.obolibrary.org/obo/UBERON_0004288 | NCBI:txid274760 | 274760 | 04/99 | Caught off Kuril Island, Russia on 07/25/03, length: 21cm, weight: 162.2g, donated by: J. Waite | Caught off Kuril Island, Russia on 07/25/03, length: 21cm, weight: 162.2g, donated by: J. Waite | Date of death | 2003-7-25 | 2003 | 7 | 25 | Asia | Kuril Islands | Russia | RU | Kuril Islands, Russia | unknown | 46.16667 | 152.0 | 0.0 | steve.vandervalk@hakai.org | Hakai Institute of the Tula Foundation | Ubaldino, M (MITRE Corporation), 'OpenSextant Xponents: Geotagging Toolkit for World-wide Geography', 2019. https://opensextant.github.io/Xponents/ | https://www.gbif.org/species/2333944 | 2333944 | https://www.gbif.org/species/2333944|https://www.fishbase.ca/summary/4096|NCBI:txid274760 | 167284 | ITIS TSN: 167284 | https://www.fishbase.ca/summary/4096 | 4096 | Hemilepidotus zapus | Hemilepidotus zapus Gilbert & Burke, 1912 | Animalia | Chordata | Actinopterygii | Scorpaeniforms | Cottidae | Hemilepidotus | zapus | species | Gilbert & Burke, 1912 | accepted | Hemilepidotus zapus Gilbert & Burke, 1912 | Longfin Irish Lord | weightlength | Weight | Length | g | cm | 21 | 162.2 | 4 | 99 | 5000.0 | Russia | ||||||||||||||||||||||||||||||||||||||||||||
1649 | 1649 | 1648 | 1854 | PhysicalObject | en | http://creativecommons.org/licenses/by/4.0/legalcode | The Anthropology Department of the University of Victoria | University of Victoria, Zooarchaeology Lab Collection, UVICZL-04.103 | https://www.gbif.org/grscicoll/collection/1cbebd16-1e98-417a-b1fe-531208312892 | UVIC | http://grscicoll.org/institution/university-victoria | UVICZL | UVICZL Fish | PreservedSpecimen | UVICZL-04.103 | 04.103 | Jason Waite | skeleton | vertebrate elements tDAR Faunal Element Ontology doi:10.6067/XCV8HQ3XDT | skeleton OLS Uber anatomy ontology http://purl.obolibrary.org/obo/UBERON_0004288 | NCBI:txid255551 | 255551 | 04/103 | Caught off Kuril Island, Russia on July 25, 2003, length: 29.0cm, weight: 723.9g, donated by: J. Waite | Caught off Kuril Island, Russia on July 25, 2003, length: 29.0cm, weight: 723.9g, donated by: J. Waite | Date of death | 2003-7-25 | 2003 | 7 | 25 | Asia | Kuril Islands | Russia | RU | Kuril Islands, Russia | unknown | 46.16667 | 152.0 | 0.0 | steve.vandervalk@hakai.org | Hakai Institute of the Tula Foundation | Ubaldino, M (MITRE Corporation), 'OpenSextant Xponents: Geotagging Toolkit for World-wide Geography', 2019. https://opensextant.github.io/Xponents/ | https://www.gbif.org/species/2335110 | 2335110 | https://www.gbif.org/species/2335110|https://www.fishbase.ca/summary/11725|NCBI:txid255551 | 167286 | ITIS TSN: 167286 | https://www.fishbase.ca/summary/11725 | 11725 | Hemitripterus villosus | Hemitripterus villosus (Pallas, 1814) | Animalia | Chordata | Actinopterygii | Scorpaeniforms | Cottidae | Hemitripterus | villosus | species | (Pallas, 1814) | accepted | Hemitripterus villosus (Pallas, 1814) | Shaggy Sea Raven | weightlength | Weight | Length | g | cm | 29 | 723.9 | 4 | 103 | 20000.0 | Russia | ||||||||||||||||||||||||||||||||||||||||||||
1660 | 1660 | 1659 | 1865 | PhysicalObject | en | http://creativecommons.org/licenses/by/4.0/legalcode | The Anthropology Department of the University of Victoria | University of Victoria, Zooarchaeology Lab Collection, UVICZL-04.106 | https://www.gbif.org/grscicoll/collection/1cbebd16-1e98-417a-b1fe-531208312892 | UVIC | http://grscicoll.org/institution/university-victoria | UVICZL | UVICZL Fish | PreservedSpecimen | UVICZL-04.106 | 04.106 | Jason Waite | skeleton | vertebrate elements tDAR Faunal Element Ontology doi:10.6067/XCV8HQ3XDT | skeleton OLS Uber anatomy ontology http://purl.obolibrary.org/obo/UBERON_0004288 | NCBI:txid274760 | 274760 | 04/106 | Caught off Kuril Island, Russia on July 23, 2003; ID J. Waite | Caught off Kuril Island, Russia on July 23, 2003; ID J. Waite, Length: 16.5cm, Weight: 59.0g, Donated by J. Waite | Date of death | 2003-7-23 | 2003 | 7 | 23 | Asia | Kuril Islands | Russia | RU | Kuril Islands, Russia | unknown | 46.16667 | 152.0 | 0.0 | steve.vandervalk@hakai.org | Hakai Institute of the Tula Foundation | Ubaldino, M (MITRE Corporation), 'OpenSextant Xponents: Geotagging Toolkit for World-wide Geography', 2019. https://opensextant.github.io/Xponents/ | https://www.gbif.org/species/2333944 | 2333944 | https://www.gbif.org/species/2333944|https://www.fishbase.ca/summary/4096|NCBI:txid274760 | 167284 | ITIS TSN: 167284 | https://www.fishbase.ca/summary/4096 | 4096 | Hemilepidotus zapus | Hemilepidotus zapus Gilbert & Burke, 1912 | Animalia | Chordata | Actinopterygii | Scorpaeniforms | Cottidae | Hemilepidotus | zapus | species | Gilbert & Burke, 1912 | accepted | Hemilepidotus zapus Gilbert & Burke, 1912 | Longfin Irish Lord | weightlength | Weight | Length | g | cm | 16.5 | 59 | 4 | 106 | 50000.0 | Russia | ||||||||||||||||||||||||||||||||||||||||||||
1664 | 1664 | 1663 | 1869 | PhysicalObject | en | http://creativecommons.org/licenses/by/4.0/legalcode | The Anthropology Department of the University of Victoria | University of Victoria, Zooarchaeology Lab Collection, UVICZL-04.107 | https://www.gbif.org/grscicoll/collection/1cbebd16-1e98-417a-b1fe-531208312892 | UVIC | http://grscicoll.org/institution/university-victoria | UVICZL | UVICZL Fish | PreservedSpecimen | UVICZL-04.107 | 04.107 | Jason Waite | skeleton | vertebrate elements tDAR Faunal Element Ontology doi:10.6067/XCV8HQ3XDT | skeleton OLS Uber anatomy ontology http://purl.obolibrary.org/obo/UBERON_0004288 | NCBI:txid255553 | 255553 | 04/107 | Caught off Kuril Island, Russia on July 25, 2003; ID J. Waite, length: 26.0cm, weight: 160.7g, donated by: J Waite | Caught off Kuril Island, Russia on July 25, 2003; ID J. Waite, length: 26.0cm, weight: 160.7g, donated by: J Waite | Date entered collection | 2003-7-25 | 2003 | 7 | 25 | Asia | Kuril Islands | Russia | RU | Kuril Islands, Russia | unknown | 46.16667 | 152.0 | 0.0 | steve.vandervalk@hakai.org | Hakai Institute of the Tula Foundation | Ubaldino, M (MITRE Corporation), 'OpenSextant Xponents: Geotagging Toolkit for World-wide Geography', 2019. https://opensextant.github.io/Xponents/ | https://www.gbif.org/species/2334015 | 2334015 | https://www.gbif.org/species/2334015|https://www.fishbase.ca/summary/23956|NCBI:txid255553 | 167272 | ITIS TSN: 167272 | https://www.fishbase.ca/summary/23956 | 23956 | Gymnocanthus detrisus | Gymnocanthus detrisus Gilbert & Burke, 1912 | Animalia | Chordata | Actinopterygii | Scorpaeniforms | Cottidae | Gymnocanthus | detrisus | species | Gilbert & Burke, 1912 | accepted | Gymnocanthus detrisus Gilbert & Burke, 1912 | Purplegray Sculpin | weightlength | Weight | Length | g | cm | 26 | 160.7 | 4 | 107 | 50000.0 | Russia | ||||||||||||||||||||||||||||||||||||||||||||
1668 | 1668 | 1667 | 1873 | PhysicalObject | en | http://creativecommons.org/licenses/by/4.0/legalcode | The Anthropology Department of the University of Victoria | University of Victoria, Zooarchaeology Lab Collection, UVICZL-04.108 | https://www.gbif.org/grscicoll/collection/1cbebd16-1e98-417a-b1fe-531208312892 | UVIC | http://grscicoll.org/institution/university-victoria | UVICZL | UVICZL Fish | PreservedSpecimen | UVICZL-04.108 | 04.108 | Jason Waite | NCBI:txID195645 | NCBI:txID195645 | 195645 | https://www.ncbi.nlm.nih.gov/Taxonomy/Browser/wwwtax.cgi?id=195645 | 04/108 | Caught off Kuril Island, Russia on July 27, 2003; ID J. Waite | Caught off Kuril Island, Russia on July 27, 2003; ID J. Waite. Length: 29.0cm, Weight: 172.8g, Donated by: J. Waite | Date of death | 2003-7-27 | 2003 | 7 | 27 | Asia | Kuril Islands | Russia | RU | Kuril Islands, Russia | unknown | 46.16667 | 152.0 | 0.0 | steve.vandervalk@hakai.org | Hakai Institute of the Tula Foundation | Ubaldino, M (MITRE Corporation), 'OpenSextant Xponents: Geotagging Toolkit for World-wide Geography', 2019. https://opensextant.github.io/Xponents/ | https://www.gbif.org/species/2409095 | 2409095 | https://www.gbif.org/species/2409095|http://www.fishbase.se/summary/518|NCBI:txID195645 | 172861 | ITIS TSN: 172861 | http://www.fishbase.se/summary/518 | 518 | Atheresthes evermanni | Atheresthes evermanni Jordan & Starks, 1904 | Animalia | Chordata | Actinopterygii | Pleuronectiformes | Pleuronectidae | Atheresthes | evermanni | species | Jordan & Starks, 1904 | accepted | Atheresthes evermanni Jordan & Starks, 1904 | Kamchatka Flounder | weightlength | 29 | 172.8 | 4 | 108 | 50000.0 | Russia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "geocoded" ( [] INTEGER, [Index] INTEGER, [type] TEXT, [language] TEXT, [license] TEXT, [rightsHolder] TEXT, [accessRights] INTEGER, [bibliographicCitation] TEXT, [collectionID] TEXT, [institutionCode] TEXT, [institutionID] TEXT, [collectionCode] TEXT, [datasetName] TEXT, [basisOfRecord] TEXT, [dynamicProperties] TEXT, [occurenceIDURL] TEXT, [occurrenceID] TEXT, [catalogNumber] TEXT, [recordedBy] TEXT, [sexOriginal] TEXT, [sex] TEXT, [lifeStageOriginal] TEXT, [lifeStage] TEXT, [preparationsOriginal] TEXT, [preparations] TEXT, [disposition] TEXT, [associatedMedia] TEXT, [associatedReferences] TEXT, [NCBIIDrefURL] TEXT, [NCBIIDref] TEXT, [NCBIID] INTEGER, [NCBIIDURL] TEXT, [otherCatalogNumbers] TEXT, [occurrenceRemarksOriginal] TEXT, [occurrenceRemarks] TEXT, [eventRemarks] TEXT, [eventDate] TEXT, [verbatimEventDate] TEXT, [year] INTEGER, [month] TEXT, [day] INTEGER, [continent] TEXT, [waterBody] TEXT, [islandGroup] TEXT, [island] TEXT, [country] TEXT, [countryCode] TEXT, [stateProvince] TEXT, [municipality] TEXT, [locality] TEXT, [verbatimLocality] TEXT, [locationRemarks] TEXT, [verbatimCoordinates] TEXT, [geodeticDatum] TEXT, [decimalLatitude] FLOAT, [decimalLongitude] FLOAT, [coordinateUncertaintyInMeters] FLOAT, [coordinatePrecision] INTEGER, [georeferencedBy] TEXT, [georeferenceSources] TEXT, [georeferenceRemarks] INTEGER, [identifiedBy] TEXT, [identificationRemarks] TEXT, [GBIFtaxonIDURL] TEXT, [GBIFtaxonID] INTEGER, [allTaxonIDs] TEXT, [ITIStaxonID] INTEGER, [taxonID] TEXT, [fishbaseIDURL] TEXT, [fishbaseID] INTEGER, [canonicalName] TEXT, [scientificName] TEXT, [kingdom] TEXT, [phylum] TEXT, [_73] TEXT, [order] TEXT, [family] TEXT, [genus] TEXT, [subgenus] TEXT, [specificEpithet] TEXT, [infraspecificEpithet] TEXT, [taxonRank] TEXT, [scientificNameAuthorship] TEXT, [taxonomicStatus] TEXT, [acceptedNameUsage] TEXT, [vernacularName] TEXT, [IndigenousName] INTEGER, [_86] INTEGER, [taxonRemarks] TEXT, [previousIdentifications] TEXT, [measurementRemarks] TEXT, [measurementType] TEXT, [measurementUnit] TEXT, [measurementValue] TEXT, [weight] TEXT, [length] FLOAT, [width] INTEGER, [totalLength] FLOAT, [forkLength] FLOAT, [standardLength] FLOAT, [wing] FLOAT, [tarsus] FLOAT, [culmen] FLOAT, [diameter] FLOAT, [catalogueYearYy] INTEGER, [catalogueNumberNn] TEXT, [catalogueYearYyyy] INTEGER, [geocoderDecimalLatitude] FLOAT, [geocoderDecimalLongitude] FLOAT, [DistanceInKMBetweenTwoCoordinates] FLOAT, [nativeLandLanguage] TEXT, [georeferencePrecision] FLOAT, [georeferenceRemarksFromGeocoder] TEXT );