Palmer Archipelago (Antarctica) Penguin Data

Drop in replacement for Iris Dataset

@kaggle.parulpandey_palmer_archipelago_antarctica_penguin_data

Table List

2 tables(31.87 KB)

Penguins Lter

@kaggle.parulpandey_palmer_archipelago_antarctica_penguin_data.penguins_lter

23.59 KB
344 rows
17 columns

studyname StudyName	sample_number Sample Number	species Species	region Region	island Island	stage Stage	individual_id Individual ID	clutch_completion Clutch Completion	date_egg Date Egg	culmen_length_mm Culmen Length (mm)	culmen_depth_mm Culmen Depth (mm)	flipper_length_mm Flipper Length (mm)	body_mass_g Body Mass (g)	sex Sex	delta_15_n_o_oo Delta 15 N (o/oo)	delta_13_c_o_oo Delta 13 C (o/oo)	comments Comments
PAL0708	1	Adelie Penguin (Pygoscelis adeliae)	Anvers	Torgersen	Adult, 1 Egg Stage	N1A1	Yes	Sun Nov 11 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	39.1	18.7	181	3750	MALE			Not enough blood for isotopes.
PAL0708	2	Adelie Penguin (Pygoscelis adeliae)	Anvers	Torgersen	Adult, 1 Egg Stage	N1A2	Yes	Sun Nov 11 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	39.5	17.4	186	3800	FEMALE	8.94956	-24.69454	nan
PAL0708	3	Adelie Penguin (Pygoscelis adeliae)	Anvers	Torgersen	Adult, 1 Egg Stage	N2A1	Yes	Fri Nov 16 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	40.3	18	195	3250	FEMALE	8.36821	-25.33302	nan
PAL0708	4	Adelie Penguin (Pygoscelis adeliae)	Anvers	Torgersen	Adult, 1 Egg Stage	N2A2	Yes	Fri Nov 16 2007 00:00:00 GMT+0000 (Coordinated Universal Time)					nan			Adult not sampled.
PAL0708	5	Adelie Penguin (Pygoscelis adeliae)	Anvers	Torgersen	Adult, 1 Egg Stage	N3A1	Yes	Fri Nov 16 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	36.7	19.3	193	3450	FEMALE	8.76651	-25.32426	nan
PAL0708	6	Adelie Penguin (Pygoscelis adeliae)	Anvers	Torgersen	Adult, 1 Egg Stage	N3A2	Yes	Fri Nov 16 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	39.3	20.6	190	3650	MALE	8.66496	-25.29805	nan
PAL0708	7	Adelie Penguin (Pygoscelis adeliae)	Anvers	Torgersen	Adult, 1 Egg Stage	N4A1	No	Thu Nov 15 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	38.9	17.8	181	3625	FEMALE	9.18718	-25.21799	Nest never observed with full clutch.
PAL0708	8	Adelie Penguin (Pygoscelis adeliae)	Anvers	Torgersen	Adult, 1 Egg Stage	N4A2	No	Thu Nov 15 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	39.2	19.6	195	4675	MALE	9.4606	-24.89958	Nest never observed with full clutch.
PAL0708	9	Adelie Penguin (Pygoscelis adeliae)	Anvers	Torgersen	Adult, 1 Egg Stage	N5A1	Yes	Fri Nov 09 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	34.1	18.1	193	3475	nan			No blood sample obtained.
PAL0708	10	Adelie Penguin (Pygoscelis adeliae)	Anvers	Torgersen	Adult, 1 Egg Stage	N5A2	Yes	Fri Nov 09 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	42	20.2	190	4250	nan	9.13362	-25.09368	No blood sample obtained for sexing.


CREATE TABLE penguins_lter (
  "studyname" VARCHAR,
  "sample_number" BIGINT,
  "species" VARCHAR,
  "region" VARCHAR,
  "island" VARCHAR,
  "stage" VARCHAR,
  "individual_id" VARCHAR,
  "clutch_completion" VARCHAR,
  "date_egg" TIMESTAMP,
  "culmen_length_mm" DOUBLE,
  "culmen_depth_mm" DOUBLE,
  "flipper_length_mm" DOUBLE,
  "body_mass_g" DOUBLE,
  "sex" VARCHAR,
  "delta_15_n_o_oo" DOUBLE,
  "delta_13_c_o_oo" DOUBLE,
  "comments" VARCHAR
);