Climate Treasure

Climate data is a vital resource for understanding and addressing the complexiti

@kaggle.willianoliveiragibin_climate_treasure

Table List

1 table(9.91 KB)

Marine Csv Sample New

@kaggle.willianoliveiragibin_climate_treasure.marine_csv_sample_new

9.91 KB
55 rows
10 columns

identification Identification	latitude Latitude	longitude Longitude	time_of_observation Time Of Observation	sea_level_pressure Sea Level Pressure	characteristics_of_pressure_tendency Characteristics Of Pressure Tendency	air_temperature Air Temperature	dew_point_temperature Dew Point Temperature
D5GN6	-35.8	2.9	Mon Jan 12 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	29.83	8	70.5	65.5
D5GN6	-35.9	6.9	Mon Jan 12 2015 12:00:00 GMT+0000 (Coordinated Universal Time)	29.93	1	66.2	56.1
D5GN6	-35.9	8.6	Mon Jan 12 2015 18:00:00 GMT+0000 (Coordinated Universal Time)	30.02	1	61.2	48.9
D5GN6	-35.7	11.9	Tue Jan 13 2015 06:00:00 GMT+0000 (Coordinated Universal Time)	30.14		64.6	45
D5GN6	-35.6	13.7	Tue Jan 13 2015 12:00:00 GMT+0000 (Coordinated Universal Time)	30.12	8	66.7	50.5
D5GN6	-35.4	15.5	Tue Jan 13 2015 18:00:00 GMT+0000 (Coordinated Universal Time)	30.08	5	68.4	48.9
D5GN6	-35.3	17.1	Wed Jan 14 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	30.01	8	68	57.9
D5GN6	-35.2	18.6	Wed Jan 14 2015 06:00:00 GMT+0000 (Coordinated Universal Time)	29.98	3	69.3	61.7
D5GN6	-35.2	20.3	Wed Jan 14 2015 12:00:00 GMT+0000 (Coordinated Universal Time)	29.91	8	80.6	57.4
D5GN6	-35.1	21.8	Wed Jan 14 2015 18:00:00 GMT+0000 (Coordinated Universal Time)	29.88	3	73.2	64.8


CREATE TABLE marine_csv_sample_new (
  "identification" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "time_of_observation" TIMESTAMP,
  "sea_level_pressure" DOUBLE,
  "characteristics_of_pressure_tendency" BIGINT,
  "pressure_tendency" DOUBLE,
  "air_temperature" DOUBLE,
  "wet_bulb_temperature" BIGINT,
  "dew_point_temperature" DOUBLE
);