Dutch rail (OVapi) train positions, Monday 2 November 2026
Train positions recorded on this day, in Netherlands local time. Below: how it went, then the whole day as one file to download.
What this day holds
- Trains
- 3,998
- Rows
- 260,540
- Recorded
- 00:00 to 23:59
Download
Get the CSV Accounts are free: you sign in with a code sent to your email, no password. You come back here after signing in.
Read this day from code
This day’s positions has a fixed address. Read it from DuckDB, Polars or curl, with one of your API tokens in place of YOUR_TOKEN:
https://data.train-archive.eu/provider=nl-ovapi/service=VehiclePosition/date=2026-11-02/day.parquet?token=YOUR_TOKEN
A few rows of the file
15 positions from across the day. The CSV has more columns, listed below.
Time time | Line route | Train vehicle | Speed (km/h) speed_kmh |
|---|---|---|---|
| 00:00 | Intercity Den Haag Centraal <-> Eindhoven Centraal IC1100 | IC 1184 | 132.4 |
| 00:00 | Intercity Maastricht <-> Utrecht Centraal IC83100 | IC 183186 | 109.7 |
| 00:00 | Intercity Amsterdam Centraal <-> Almere Centrum IC2600 | IC 2687 | 0 |
| 00:00 | IC 303082 | 138 | |
| 00:00 | Stoptrein RS33 Tiel <-> Arnhem Centraal ST31100 | ARR 31174 | 102.6 |
| 00:00 | Intercity Dordrecht <-> Venlo IC3500 | IC 3585 | 82.8 |
| 00:00 | Sprinter Uitgeest <-> Rotterdam Centraal SPR4000 | SPR 4084 | 66.2 |
| 23:59 | Sprinter Haarlem <-> Den Haag Centraal SPR4200 | SPR 4276 | 66.7 |
| 23:59 | Sprinter Den Haag Centraal <-> Dordrecht SPR5100 | SPR 5182 | 0 |
| 23:59 | Intercity Den Haag Centraal <-> Groningen IC500 | IC 587 | 131.2 |
| 23:59 | Sprinter 's-Hertogenbosch <-> Deurne SPR6500 | SPR 6585 | 0 |
| 23:59 | Sprinter Apeldoorn <-> Almelo SPR7000 | SPR 7088 | 41.5 |
| 23:59 | Sprinter Amsterdam Centraal <-> Hoofddorp SPR8100 | SPR 8189 | 0 |
| 23:59 | Sprinter Lelystad Centrum <-> Leeuwarden SPR9000 | SPR 9090 | 18.1 |
| 23:59 | Intercity Schiphol Airport <-> Amersfoort Schothorst IC900 | IC 984 | 55.4 |
What the columns mean
time- When the position was measured, in local time.
route, trip_id- The line and the train run.
vehicle- The train’s number or name, as the operator gives it.
latitude, longitude- Where it was.
bearing- Direction of travel in degrees (0 is north, 90 east).
speed_kmh- Speed in km/h, when the operator sends it.
stop_name, status- The next or current stop, and whether the train is on the way to it or stopped at it.
route_id- The route’s code in the timetable, to join with it.