Dataset: HOV ALVIN DIVES DATA

About this Dataset

HOV ALVIN DIVES DATA

Context

Woods Hole Institute's (WHOI) Human Occupied Vehicle HOV ALVIN allows in-situ data collection and observation by two scientists of the seafloor and water column to depths reaching 4,500 meters on dives lasting up to ten hours (https://ndsf.whoi.edu/alvin/).

Content

The dataset consists of HOV ALVIN's dive data between 1964-2020.

One can find dive number, dive date, depth, operation area, the purpose of the dive, cruise information, chief scientist, pilot, observers, dive destination, dive coordinates (latitude and longitude in decimal degrees format).

There are two versions of the dataset. One is already cleaned and prepared and the other is raw data after collected from the website. One can use the raw data to practice data cleaning and data preparation skills.

Acknowledgements

In 2018, when I've started to learn data science through online courses, I used Woods Hole Institute's (WHOI) Human Occupied Vehicle (HOV) Alvin's dive logs for exploratory data analysis (EDA) and visualization practices.
The data which I studied back then has Alvin's dive logs up to 2017. One can reach that data set through https://www.kaggle.com/sauuyer/alvin-dives
One can find the WHOI's data through this link: https://ndsf.whoi.edu/alvin/dive-log/
Banner photo by WHOI MISO Facility, © Woods Hole Oceanographic Institution

Tables

Alvin Data Cleaned

@kaggle.akdagmelih_hov_alvin_dives_data.alvin_data_cleaned

288.07 KB
5065 rows
16 columns


CREATE TABLE alvin_data_cleaned (
  "unnamed_0" BIGINT,
  "dive_nu" BIGINT,
  "date" TIMESTAMP,
  "op_area" VARCHAR,
  "cruise" VARCHAR,
  "leg" VARCHAR,
  "purpose" VARCHAR,
  "depth" BIGINT,
  "dive_time" BIGINT,
  "bottom_time" DOUBLE,
  "chief_sci" VARCHAR,
  "pilot" VARCHAR,
  "obs1" VARCHAR,
  "obs2" VARCHAR,
  "lat_dd" DOUBLE,
  "long_dd" DOUBLE
);

Alvin Data Raw

@kaggle.akdagmelih_hov_alvin_dives_data.alvin_data_raw

276.85 KB
5065 rows
16 columns


CREATE TABLE alvin_data_raw (
  "unnamed_0" BIGINT,
  "dive_nu" BIGINT,
  "date" TIMESTAMP,
  "op_area" VARCHAR,
  "lat" VARCHAR,
  "lon" VARCHAR,
  "cruise" VARCHAR,
  "leg" VARCHAR,
  "purpose" VARCHAR,
  "depth" BIGINT,
  "dive_time" VARCHAR,
  "bottom_time" VARCHAR,
  "chief_sci" VARCHAR,
  "pilot" VARCHAR,
  "obs1" VARCHAR,
  "obs2" VARCHAR
);