Name: Historical Weather In The Netherlands 1901-2018
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Historical Weather In The Netherlands 1901-2018

Context

The data set was collected by the KNMI (Dutch weather institute) and contains information on weather collected from 50 weather stations across The Netherlands.

Content

This data consists of two datasets: a) KNMI_stations_2018.csv and b) KNMI_20181231.csv.

The data set KNMI_stations_2018.csv contains general information on the weather stations. That is longitude (LON) and latitude (LAT), altitude (in meters) and the general name of that weather station.

The data set KNMI_20181231 contains information about the different weather variables measured by each weather station i.e. temperature, wind speed, precipitation etc.

The data was collected from 1901 to 2018.

Acknowledgements

Source: KONINKLIJK NEDERLANDS METEOROLOGISCH INSTITUUT (KNMI)

Inspiration

Your data will be in front of the world's largest data science community. What questions do you want to see answered?

Tables

Knmi 20181231

@kaggle.sinaasappel_historical_weather_in_the_netherlands_19012018.knmi_20181231

21.88 MB
804,098 rows
41 columns

CREATE TABLE knmi_20181231 (
  "stn" BIGINT,
  "yyyymmdd" BIGINT,
  "ddvec" VARCHAR,
  "fhvec" VARCHAR,
  "n__fg" VARCHAR  -- FG,
  "n__fhx" VARCHAR  -- FHX,
  "n__fhxh" VARCHAR  -- FHXH,
  "n__fhn" VARCHAR  -- FHN,
  "n__fhnh" VARCHAR  -- FHNH,
  "n__fxx" VARCHAR  -- FXX,
  "n__fxxh" VARCHAR  -- FXXH,
  "n__tg" VARCHAR  -- TG,
  "n__tn" VARCHAR  -- TN,
  "n__tnh" VARCHAR  -- TNH,
  "n__tx" VARCHAR  -- TX,
  "n__txh" VARCHAR  -- TXH,
  "n__t10n" VARCHAR  -- T10N,
  "t10nh" VARCHAR,
  "n__sq" VARCHAR  -- SQ,
  "n__sp" VARCHAR  -- SP,
  "n__q" VARCHAR  -- Q,
  "n__dr" VARCHAR  -- DR,
  "n__rh" VARCHAR  -- RH,
  "n__rhx" VARCHAR  -- RHX,
  "n__rhxh" VARCHAR  -- RHXH,
  "n__pg" VARCHAR  -- PG,
  "n__px" VARCHAR  -- PX,
  "n__pxh" VARCHAR  -- PXH,
  "n__pn" VARCHAR  -- PN,
  "n__pnh" VARCHAR  -- PNH,
  "n__vvn" VARCHAR  -- VVN,
  "n__vvnh" VARCHAR  -- VVNH,
  "n__vvx" VARCHAR  -- VVX,
  "n__vvxh" VARCHAR  -- VVXH,
  "n__ng" VARCHAR  -- NG,
  "n__ug" VARCHAR  -- UG,
  "n__ux" VARCHAR  -- UX,
  "n__uxh" VARCHAR  -- UXH,
  "n__un" VARCHAR  -- UN,
  "n__unh" VARCHAR  -- UNH,
  "n__ev24" VARCHAR  -- EV24
);

Knmi Stations 2018

@kaggle.sinaasappel_historical_weather_in_the_netherlands_19012018.knmi_stations_2018

5.81 kB
50 rows
5 columns

CREATE TABLE knmi_stations_2018 (
  "stn" BIGINT,
  "lon" DOUBLE,
  "lat" DOUBLE,
  "alt" DOUBLE,
  "name" VARCHAR
);