Titanic Dataset With Port Coordinates

Lat, lon coordinates assigned to ports of embarkation for geographical plots

@kaggle.amykzhang_titanic_dataset_with_coordinates

Table List

1 table(43.93 KB)

Titanic Coord

@kaggle.amykzhang_titanic_dataset_with_coordinates.titanic_coord

43.93 KB
891 rows
14 columns

passengerid PassengerId	survived Survived	pclass Pclass	name Name	sex Sex	age Age	sibsp SibSp	parch Parch	ticket Ticket	fare Fare	cabin Cabin	embarked Embarked	latitude Latitude	longitude Longitude
1		3	Braund, Mr. Owen Harris	male	22	1		A/5 21171	7.25	nan	S	50.891847	-1.398293
2	1	1	Cumings, Mrs. John Bradley (Florence Briggs Thayer)	female	38	1		PC 17599	71.2833	C85	C	49.679263	-1.647213
3	1	3	Heikkinen, Miss. Laina	female	26			STON/O2. 3101282	7.925	nan	S	50.891847	-1.398293
4	1	1	Futrelle, Mrs. Jacques Heath (Lily May Peel)	female	35	1		113803	53.1	C123	S	50.891847	-1.398293
5		3	Allen, Mr. William Henry	male	35			373450	8.05	nan	S	50.891847	-1.398293
6		3	Moran, Mr. James	male				330877	8.4583	nan	Q	51.793	-8.254611
7		1	McCarthy, Mr. Timothy J	male	54			17463	51.8625	E46	S	50.891847	-1.398293
8		3	Palsson, Master. Gosta Leonard	male	2	3	1	349909	21.075	nan	S	50.891847	-1.398293
9	1	3	Johnson, Mrs. Oscar W (Elisabeth Vilhelmina Berg)	female	27		2	347742	11.1333	nan	S	50.891847	-1.398293
10	1	2	Nasser, Mrs. Nicholas (Adele Achem)	female	14	1		237736	30.0708	nan	C	49.679263	-1.647213


CREATE TABLE titanic_coord (
  "passengerid" BIGINT,
  "survived" BIGINT,
  "pclass" BIGINT,
  "name" VARCHAR,
  "sex" VARCHAR,
  "age" DOUBLE,
  "sibsp" BIGINT,
  "parch" BIGINT,
  "ticket" VARCHAR,
  "fare" DOUBLE,
  "cabin" VARCHAR,
  "embarked" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);