Historical Weather In The Netherlands 1901-2018

Historical weather in the Netherlands collected from 1901 to 2018

@kaggle.sinaasappel_historical_weather_in_the_netherlands_19012018

Table List

2 tables(20.87 MB)

Knmi 20181231

Knmi Stations 2018

Knmi 20181231

@kaggle.sinaasappel_historical_weather_in_the_netherlands_19012018.knmi_20181231

20.87 MB
804098 rows
41 columns

stn STN	yyyymmdd YYYYMMDD	ddvec DDVEC	fhvec FHVEC	n__fg FG	n__fhx FHX	n__fhxh FHXH	n__fhn FHN	n__fhnh FHNH	n__fxx FXX	n__fxxh FXXH
209	20010130
209	20010131
209	20010201	236	13	24	50	8	10	1	90	20
209	20010202	150	46	58	80	9	10	3	100	9
209	20010203	106	65	66	90	8	50	1	120	8
209	20010204	115	52	75	110	24	50	15	140	23
209	20010205	222	105	112	140	19	90	12	180	6
209	20010206	203	125	127	150	7	90	2	200	7
209	20010207	191	89	95	120	1	50	24	160	10
209	20010208	168	10	99	140	9	30	15	210	7


CREATE TABLE knmi_20181231 (
  "stn" BIGINT,
  "yyyymmdd" BIGINT,
  "ddvec" VARCHAR,
  "fhvec" VARCHAR,
  "n__fg" VARCHAR,
  "n__fhx" VARCHAR,
  "n__fhxh" VARCHAR,
  "n__fhn" VARCHAR,
  "n__fhnh" VARCHAR,
  "n__fxx" VARCHAR,
  "n__fxxh" VARCHAR,
  "n__tg" VARCHAR,
  "n__tn" VARCHAR,
  "n__tnh" VARCHAR,
  "n__tx" VARCHAR,
  "n__txh" VARCHAR,
  "n__t10n" VARCHAR,
  "t10nh" VARCHAR,
  "n__sq" VARCHAR,
  "n__sp" VARCHAR,
  "n__q" VARCHAR,
  "n__dr" VARCHAR,
  "n__rh" VARCHAR,
  "n__rhx" VARCHAR,
  "n__rhxh" VARCHAR,
  "n__pg" VARCHAR,
  "n__px" VARCHAR,
  "n__pxh" VARCHAR,
  "n__pn" VARCHAR,
  "n__pnh" VARCHAR,
  "n__vvn" VARCHAR,
  "n__vvnh" VARCHAR,
  "n__vvx" VARCHAR,
  "n__vvxh" VARCHAR,
  "n__ng" VARCHAR,
  "n__ug" VARCHAR,
  "n__ux" VARCHAR,
  "n__uxh" VARCHAR,
  "n__un" VARCHAR,
  "n__unh" VARCHAR,
  "n__ev24" VARCHAR
);