Southeast Asian Bumblebee Specimen Dataset
List of Southeast Asian bumblebee specimens
@kaggle.debjeetdas_southeast_asian_bumblebee_specimen_database
List of Southeast Asian bumblebee specimens
@kaggle.debjeetdas_southeast_asian_bumblebee_specimen_database
Biology, Bumblebee, Specimens, Southeast Asia
By: [source]
List of Southeast Asian bumblebee specimens (the CT database), including CT ID, collection (BEEP=Bee Protection Laboratory, Department of Biology, Chiang Mai University, Chiang Mai, Thailand; CUNHM= Chulalongkorn University Natural History Museum, Bangkok, Thailand; ACMU= Department of Entomology and Plant Pathology, Chiang Mai University, Chiang Mai, Thailand; FRIM= Entomological Reference Collection, Forest Research Institute Malaysia, Kuala Lumpur, Malaysia; QSBG= Entomology section, Queen Sirikit Botanic Garden, Chiang Mai, Thailand; DNP= Forest Insect Collection, Forest Entomology and Microbiology Research Group, Forest and Plant Conservation Research Office, Department of National Park, Wildlife and Plant Conservation, Bangkok, Thailand; KKIC= Kasetsart Kamphaeng Saen Insect Collection, Kasetsart University Kamphaeng Saen Campus, Nakhon Pathom, Thailand; NHMUK= Natural History Museum, London, UK; NMNL= Naturalis Biodiversity Center, Leiden, the Netherlands;NHMW= Naturhistorisches Museum Wien, Vienna, Austria; PHW= Paul H. Williams research collection, UK; MJUMZ= The Museum of Zoology, Maejo University, Chiang Mai, Thailand; PCYU= The Packer Collection at York University, Canada), collection ID, subgenus and species name, collecting date (dd/mm/yyyy), year and month (Jan=January; Feb=February; Mar=March; Apr=April; May=May; Jun=June; Jul=July; Aug=August; Sep=September; Oct=October; Nov=November; Dec=December), collecting site with georeferences (latitude and longitude), elevation maximum and minimum (m), collector, and caste (Worker and Queen=Female; Male). NA= not available.
Chawatat Thanoosing; Alfried Vogler; Paul H Williams (2022). Southeast Asian Bumblebee Specimen Database [Data set]. Natural History Museum. https://doi.org/10.5519/isxh6saw
CREATE TABLE resource (
"n__id" BIGINT -- Id,
"ct_id" VARCHAR,
"collection" VARCHAR,
"coilection_id" VARCHAR,
"subgenus" VARCHAR,
"species" VARCHAR,
"year" DOUBLE,
"month" VARCHAR,
"collecting_date" VARCHAR,
"country" VARCHAR,
"location" VARCHAR,
"latitude" DOUBLE,
"longitude" DOUBLE,
"elevation_minimum" VARCHAR,
"elevation_maximum" VARCHAR,
"collector" VARCHAR,
"caste" VARCHAR
);
Anyone who has the link will be able to view this.