1750-1850 Oceanic Climatology: Daily Ship Logbook
Detailed Weather and Voyage Observations
@kaggle.thedevastator_1750_1850_oceanic_climatology_daily_ship_logbook
Detailed Weather and Voyage Observations
@kaggle.thedevastator_1750_1850_oceanic_climatology_daily_ship_logbook
CREATE TABLE cliwoc15 (
"index" BIGINT,
"recid" BIGINT,
"instabbr" VARCHAR,
"instname" VARCHAR,
"instplace" VARCHAR,
"instland" VARCHAR,
"numberentry" VARCHAR,
"namearchiveset" VARCHAR,
"archivepart" VARCHAR,
"specification" VARCHAR,
"logbookident" VARCHAR,
"logbooklanguage" VARCHAR,
"enteredby" VARCHAR,
"dasnumber" DOUBLE,
"imagenumber" VARCHAR,
"voyagefrom" VARCHAR,
"voyageto" VARCHAR,
"shipname" VARCHAR,
"shiptype" VARCHAR,
"company" VARCHAR,
"othershipinformation" VARCHAR,
"nationality" VARCHAR,
"name1" VARCHAR,
"rank1" VARCHAR,
"name2" VARCHAR,
"rank2" VARCHAR,
"name3" VARCHAR,
"rank3" VARCHAR,
"zeromeridian" VARCHAR,
"startday" VARCHAR,
"timegen" VARCHAR,
"obsgen" VARCHAR,
"referencecourse" VARCHAR,
"referencewinddirection" VARCHAR,
"distunits" VARCHAR,
"disttolandmarkunits" VARCHAR,
"disttravelledunits" VARCHAR,
"longitudeunits" VARCHAR,
"voyageini" DOUBLE,
"unitsofmeasurement" VARCHAR,
"calendar" BIGINT,
"year" BIGINT,
"month" BIGINT,
"day" BIGINT,
"dayoftheweek" VARCHAR,
"partday" VARCHAR,
"timeob" BIGINT,
"watch" VARCHAR,
"glasses" DOUBLE,
"utc" BIGINT,
"cmg" VARCHAR,
"shipspeed" DOUBLE,
"distance" DOUBLE,
"drlatdeg" DOUBLE,
"drlatmin" DOUBLE,
"drlatsec" DOUBLE,
"drlathem" VARCHAR,
"drlongdeg" DOUBLE,
"drlongmin" DOUBLE,
"drlongsec" DOUBLE,
"drlonghem" VARCHAR,
"latdeg" DOUBLE,
"latmin" DOUBLE,
"latsec" DOUBLE,
"lathem" VARCHAR,
"longdeg" DOUBLE,
"longmin" DOUBLE,
"longsec" DOUBLE,
"longhem" VARCHAR,
"lat3" DOUBLE,
"lon3" DOUBLE,
"latind" BIGINT,
"lonind" BIGINT,
"poscoastal" BIGINT,
"encname" VARCHAR,
"encnat" VARCHAR,
"encrem" VARCHAR,
"anchored" BIGINT,
"anchorplace" VARCHAR,
"lmname1" VARCHAR,
"lmdirection1" VARCHAR,
"lmdistance1" DOUBLE,
"lmname2" VARCHAR,
"lmdirection2" VARCHAR,
"lmdistance2" DOUBLE,
"lmname3" VARCHAR,
"lmdirection3" VARCHAR,
"lmdistance3" DOUBLE,
"esterror" VARCHAR,
"applerror" VARCHAR,
"winddirection" VARCHAR,
"allwinddirections" VARCHAR,
"windforce" VARCHAR,
"windforcescale" DOUBLE,
"allwindforces" VARCHAR,
"windscale" VARCHAR,
"weather" VARCHAR,
"shapeclouds" VARCHAR,
"dirclouds" VARCHAR,
"clearness" VARCHAR
);
Anyone who has the link will be able to view this.