Dataset: Butterflies

About this Dataset

Butterflies

Context

The Dataset contains two CSV file.

Content

Multimedia - 7 Features and 1900+ Samples
Occurrence - 71 Features and 1000+ Samples

In Multimedia there are URL's of different - different species of Butterflies

Tables

Multimedia

@kaggle.taruntiwarihp_butterflies.multimedia

126.1 KB
1990 rows
7 columns


CREATE TABLE multimedia (
  "n__id" BIGINT,
  "license" VARCHAR,
  "title" VARCHAR,
  "format" VARCHAR,
  "rightsholder" VARCHAR,
  "identifier" VARCHAR,
  "type" VARCHAR
);

Occurrence

@kaggle.taruntiwarihp_butterflies.occurrence

162.95 KB
1001 rows
71 columns


CREATE TABLE occurrence (
  "n__id" BIGINT,
  "dynamicproperties" VARCHAR,
  "basisofrecord" VARCHAR,
  "bed" VARCHAR,
  "catalognumber" VARCHAR,
  "class" VARCHAR,
  "collectioncode" VARCHAR,
  "continent" VARCHAR,
  "country" VARCHAR,
  "day" VARCHAR,
  "decimallatitude" VARCHAR,
  "decimallongitude" VARCHAR,
  "earliestageorloweststage" VARCHAR,
  "earliesteonorlowesteonothem" VARCHAR,
  "earliestepochorlowestseries" VARCHAR,
  "earliesteraorlowesterathem" VARCHAR,
  "earliestperiodorlowestsystem" VARCHAR,
  "family" VARCHAR,
  "fieldnumber" VARCHAR,
  "formation" VARCHAR,
  "genus" VARCHAR,
  "geodeticdatum" VARCHAR,
  "georeferenceprotocol" VARCHAR,
  "group" VARCHAR,
  "habitat" VARCHAR,
  "higherclassification" VARCHAR,
  "highergeography" VARCHAR,
  "highestbiostratigraphiczone" VARCHAR,
  "identificationqualifier" VARCHAR,
  "identifiedby" VARCHAR,
  "individualcount" BIGINT,
  "infraspecificepithet" VARCHAR,
  "institutioncode" VARCHAR,
  "island" VARCHAR,
  "islandgroup" VARCHAR,
  "kingdom" VARCHAR,
  "latestageorhigheststage" VARCHAR,
  "latesteonorhighesteonothem" VARCHAR,
  "latestepochorhighestseries" VARCHAR,
  "latesteraorhighesterathem" VARCHAR,
  "latestperiodorhighestsystem" VARCHAR,
  "lifestage" VARCHAR,
  "locality" VARCHAR,
  "lowestbiostratigraphiczone" VARCHAR,
  "maximumdepthinmeters" VARCHAR,
  "maximumelevationinmeters" VARCHAR,
  "member" VARCHAR,
  "minimumdepthinmeters" VARCHAR,
  "minimumelevationinmeters" VARCHAR,
  "modified" BIGINT,
  "month" VARCHAR,
  "occurrenceid" VARCHAR,
  "order" VARCHAR,
  "othercatalognumbers" VARCHAR,
  "phylum" VARCHAR,
  "preparations" VARCHAR,
  "recordnumber" VARCHAR,
  "recordedby" VARCHAR,
  "samplingprotocol" VARCHAR,
  "scientificname" VARCHAR,
  "scientificnameauthorship" VARCHAR,
  "sex" VARCHAR,
  "specificepithet" VARCHAR,
  "stateprovince" VARCHAR,
  "subgenus" VARCHAR,
  "taxonrank" VARCHAR,
  "typestatus" VARCHAR,
  "verbatimlatitude" VARCHAR,
  "verbatimlongitude" VARCHAR,
  "waterbody" VARCHAR,
  "year" VARCHAR
);