Southeast Asian Bumblebee Specimen Dataset

List of Southeast Asian bumblebee specimens

@kaggle.debjeetdas_southeast_asian_bumblebee_specimen_database

Table List

1 table(43.23 KB)

Resource

@kaggle.debjeetdas_southeast_asian_bumblebee_specimen_database.resource

43.23 KB
1024 rows
17 columns

n__id Id	ct_id CT ID	collection Collection	coilection_id Coilection ID	subgenus Subgenus	species Species	year Year	month Month	collecting_date Collecting Date	country Country	location Location	latitude Latitude	longitude Longitude	elevation_minimum Elevation Minimum	elevation_maximum Elevation Maximum	collector Collector	caste Caste
1	CT#1	NHMUK	010820547	Megabombus	Bombus montivagus	1991	Nov	17/1/1900	Thailand	Doi Suthep-Pui NP	18.8067	98.9164	1130.00	1130.00	I. J. Kitching	Male
2	CT#2	NHMUK	010820548	Megabombus	Bombus montivagus	1991	Nov	17/11/1991	Thailand	Doi Suthep-Pui NP	18.8067	98.9164	1130.00	1130.00	I. J. Kitching	Worker
3	CT#3	NHMUK	010820549	Megabombus	Bombus montivagus	1920	May	31/05/1920	Laos	Luang Prabang	20.0656	102.6216	nan	nan	R. V. de Salvaza	Male
4	CT#4	NHMUK	010820550	Megabombus	Bombus montivagus	1964	Feb	14/02/1964	Malaysia	Gunung Brinchang	4.5175	101.3825	2030.00	2030.00	H. T. Pagden	Queen
5	CT#5	NHMUK	010820551	Megabombus	Bombus montivagus	1935	Jun	17/06/1935	Malaysia	Cameron highlands	4.4721	101.3801	1382.00	1524.00	H. M. Pendlebury	Worker
6	CT#6	NHMUK	010820552	Megabombus	Bombus montivagus	1938	Jul	26/07/1938	Malaysia	Gunung Berembun	4.3333	101.45	1841.00	1841.00	H. M. Pendlebury	Worker
7	CT#7	NHMUK	010820553	Megabombus	Bombus montivagus	1938	Jul	19/07/1938	Malaysia	Cameron highlands	4.4721	101.3801	1585.00	1585.00	H. M. Pendlebury	Worker
8	CT#8	NHMUK	010820554	Megabombus	Bombus albopleuralis	1935	Mar	14/03/1935	India	Mishmi Hills	28.25	96	747.00	747.00	M. Steele	Queen
9	CT#9	NHMUK	010820555	Megabombus	Bombus albopleuralis	1935	Mar	28/03/1935	India	Lohit River	27.7985	95.6353	nan	nan	M. Steele	Queen
10	CT#10	NHMUK	010820556	Megabombus	Bombus albopleuralis	1938	Jul	27/7/1938	Myanmar	Nam Tamai Valley	27.7	97.9	914.00	914.00	R. Kaulback	Worker


CREATE TABLE resource (
  "n__id" BIGINT,
  "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
);