Baselight

Train Delays

Information about delays of polish trains from May 14 to May 29 2022

@kaggle.bartek358_train_delays

Loading...
Loading...

About this Dataset

Train Delays

The dataset contains information about delays on polish railroads published by the Polish State Railways in real time. Data was scraped from https://infopasazer.intercity.pl. It covers the period from the midnight of 2022-05-16 until the midnight of 2022-05-30. Observations were collected every 5 minutes.

Columns:

  • datetime - timestamp at which the sample was collected (Warsaw time)
  • id - train ID
  • carrier - the name of the carrier (mainly its PKP Intercity)
  • date - date of the train departure
  • connection - beginning and the destination for the train
  • arrival - planned arrival time at the destination
  • delay - current estimated delay
  • name - train station name

Tables

Delays

@kaggle.bartek358_train_delays.delays
  • 17.33 MB
  • 3718170 rows
  • 8 columns
Loading...

CREATE TABLE delays (
  "datetime" TIMESTAMP,
  "id" VARCHAR,
  "carrier" VARCHAR,
  "date" TIMESTAMP,
  "connection" VARCHAR,
  "arrival" VARCHAR,
  "delay" VARCHAR,
  "name" VARCHAR
);

Share link

Anyone who has the link will be able to view this.