Norway Meteorological Data

Meteorololgical data for Norway parsed with Frost API

@kaggle.annbengardt_noway_meteorological_data

Table List

1 table(1.83 MB)

Norwaymeteodatacompleted

@kaggle.annbengardt_noway_meteorological_data.norwaymeteodatacompleted

1.83 MB
237629 rows
14 columns

unnamed_0 Unnamed: 0	sourceid SourceId	latitude Latitude	longtitude Longtitude	sum_precipitation_amount_p1d Sum(precipitation Amount P1D)	day Day	month Month	year Year
	SN100	61.1349	12.5039	0.4	1	1	2010
1	SN1135	58.99	11.5408		1	1	2010
2	SN1151800	50.1002777777778	14.2555555555556		1	1	2010
3	SN15262	61.674	8.3685		1	1	2010
4	SN1531000	45.4730555555556	28.0322222222222		1	1	2010
5	SN1547000	44.1072222222222	24.9786111111111		1	1	2010
6	SN1571200	41.55	23.2666666666667		1	1	2010
7	SN16400	62.0172	9.2143		1	1	2010
8	SN18160	59.873	10.7912	0.4	1	1	2010
9	SN18420	59.946	10.7903		1	1	2010


CREATE TABLE norwaymeteodatacompleted (
  "unnamed_0" BIGINT,
  "sourceid" VARCHAR,
  "latitude" DOUBLE,
  "longtitude" DOUBLE,
  "max_air_temperature_p1d" DOUBLE,
  "max_relative_humidity_p1d" DOUBLE,
  "max_wind_speed_p1d" DOUBLE,
  "mean_air_temperature_p1d" DOUBLE,
  "mean_relative_humidity_p1d" DOUBLE,
  "mean_wind_speed_p1d" DOUBLE,
  "sum_precipitation_amount_p1d" DOUBLE,
  "day" BIGINT,
  "month" BIGINT,
  "year" BIGINT
);