Baselight

Global Sea Temperatures - 18/07/2022

Global Sea Temperatures as on 18 Jul 2022

@kaggle.kkhandekar_global_sea_temperatures_18072022

Loading...
Loading...

About this Dataset

Global Sea Temperatures - 18/07/2022

Global Sea Temperatures as on 18 Jul 2022

  • File#1 = Countries.csv (list of continents & their countries)
  • File#2 = Cities.csv (list of countries and their cities)
  • File#3 = SeaTemperatures.csv (list of cities and their sea temperatures)

Joining key File#1 to File#2 = Country
Joining key File#2 to File#3 = City

I agree I could've put everything in one single CSV but I just wanted it to be organized.

Note: The SeaTemperatures.csv file needs data cleansing.

Tables

Cities

@kaggle.kkhandekar_global_sea_temperatures_18072022.cities
  • 43.51 KB
  • 3627 rows
  • 2 columns
Loading...

CREATE TABLE cities (
  "country" VARCHAR,
  "city" VARCHAR
);

Countries

@kaggle.kkhandekar_global_sea_temperatures_18072022.countries
  • 4.09 KB
  • 172 rows
  • 2 columns
Loading...

CREATE TABLE countries (
  "continent" VARCHAR,
  "country" VARCHAR
);

Seatemperatures

@kaggle.kkhandekar_global_sea_temperatures_18072022.seatemperatures
  • 49.52 KB
  • 3627 rows
  • 4 columns
Loading...

CREATE TABLE seatemperatures (
  "city" VARCHAR,
  "currtemp" VARCHAR,
  "windspeed" VARCHAR,
  "humidity" VARCHAR
);

Share link

Anyone who has the link will be able to view this.