Open data about train services

All train services in the Netherlands since 2019 are stored in the train archive of Rijden de Treinen. This dataset contains all delays, cancellations and timetable changes of all trains in the Netherlands.

Go to:

Description of the data

This dataset contains all passenger train services in the Netherlands since 2019. The data is offered as CSV files compressed with Gzip.

Each row in these files represent a stop at a station. Each service at least departs from and arrives at a station (i.e. two rows). For each stop, you can find the name of the station, the arrival and departure time, delays and cancellations. The exact meaning of each column is explained below.

The source for this data is the real-time data from NS with live departure times, live arrival times and service updates. This data is also used in the app and website of Rijden de Treinen.

Columns

This dataset contains the following columns:

  • Service:RDT-ID
    Unique identifier (service)
    This is the ID that Rijden de Treinen uses for this service. It has no useful meaning beyond uniquely identifying a single service on a single date.
  • Service:Date
    Service date (schedule date)
    The scheduled service date for this service.
  • Service:Type
    Service type
    The service type, for example: Intercity, Sprinter or ICE International.
  • Service:Company
    Operator
    Company operating this service, like NS or Arriva.
  • Service:Train number
    Train number
    The train number (service number) for this service uniquely identifies this service on this date. This number is sometimes also communicated to passengers (especially for international trains).
  • Service:Completely cancelled
    Service is fully cancelled
    This column is true when all stops of this service have been cancelled. Or in other words: when the train does not run at all.
  • Service:Partly cancelled
    Partially cancelled
    This column is true when one or more stops of this service have been cancelled. Or in other words: when the train does not run on a part of the route.
  • Service:Maximum delay
    Highest delay for this service
    The highest delay (in minutes) of all stops of this service.
  • Stop:RDT-ID
    Unique identifier (stop)
    Unique identifier for this stop. This ID is unique for each stop in the dataset. It has no further useful meaning.
  • Stop:Station code
    Station code
    Code (abbreviation) of the station name. See also the dataset with railway stations.
  • Stop:Station name
    Station name
    The name of the station.
  • Stop:Arrival time
    Arrival time
    Scheduled arrival time in RFC 3339 format. This column is empty when no arrival was scheduled.
  • Stop:Arrival delay
    Arrival delay
    Arrival delay in minutes. This column is empty when no arrival was scheduled.
  • Stop:Arrival cancelled
    Cancelled arrival
    This column is true when the arrival at this stop has been cancelled. This column is empty when no arrival was scheduled.
  • Stop:Departure time
    Departure time
    Scheduled departure time in RFC 3339 format. This column is empty when no departure was scheduled.
  • Stop:Departure delay
    Departure delay
    Departure delay in minutes. This column is empty when no departure was scheduled.
  • Stop:Departure cancelled
    Cancelled departure
    This column is true when the departure at this stop has been cancelled. This column is empty when no departure was scheduled.

Downloads

The following datasets are available:

License and attribution

CC BY 4.0

This dataset is released under the Creative Commons Attribution 4.0 license. This means that you can use the data for any purpose, as long as you mention Rijden de Treinen as the source. If you have any questions about the data, please contact us.

The data is updated yearly. For media outlets and professional users, it's possible to get a more up-to-date version of this dataset or a custom selection. Please contact us for more information.

Related data

Rijden de Treinen also offers open data about: