Baselight

Train Delays

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

@kaggle.bartek358_train_delays

Delays
@kaggle.bartek358_train_delays.delays

  • 17.33 MB
  • 3718170 rows
  • 8 columns
datetime

Datetime

id

Id

carrier

Carrier

date

Date

connection

Connection

arrival

Arrival

delay

Delay

name

Name

Mon May 16 2022 00:00:00 GMT+0000 (Coordinated Universal Time)41002/3 (102) POLONIAPKP IntercitySun May 15 2022 00:00:00 GMT+0000 (Coordinated Universal Time)Bohumin - Warszawa Wschodnia21:31162 minWarszawa Zachodnia
Mon May 16 2022 00:00:00 GMT+0000 (Coordinated Universal Time)91888/9 (102) Koleje MazowieckieMon May 16 2022 00:00:00 GMT+0000 (Coordinated Universal Time)Siedlce - Warszawa Zachodnia00:150 minWarszawa Zachodnia
Mon May 16 2022 00:00:00 GMT+0000 (Coordinated Universal Time)21644/5 (102) Koleje MazowieckieMon May 16 2022 00:00:00 GMT+0000 (Coordinated Universal Time)Radom Główny - Warszawa Wschodnia00:290 minWarszawa Zachodnia
Mon May 16 2022 00:00:00 GMT+0000 (Coordinated Universal Time)19300/1 (102) Koleje MazowieckieMon May 16 2022 00:00:00 GMT+0000 (Coordinated Universal Time)Warszawa Wschodnia - Grodzisk Mazowiecki00:340 minWarszawa Zachodnia
Mon May 16 2022 00:00:00 GMT+0000 (Coordinated Universal Time)38170/1 (102) USTRONIEPKP IntercityMon May 16 2022 00:00:00 GMT+0000 (Coordinated Universal Time)Kraków Główny - Kołobrzeg00:550 minWarszawa Zachodnia
Mon May 16 2022 00:00:00 GMT+0000 (Coordinated Universal Time)83170/1 (102) USTRONIEPKP IntercityMon May 16 2022 00:00:00 GMT+0000 (Coordinated Universal Time)Kołobrzeg - Kraków Główny04:192 minWarszawa Zachodnia
Mon May 16 2022 00:00:00 GMT+0000 (Coordinated Universal Time)35170/1 (102) KARPATYPKP IntercityMon May 16 2022 00:00:00 GMT+0000 (Coordinated Universal Time)Kraków Główny - Gdynia Główna04:320 minWarszawa Zachodnia
Mon May 16 2022 00:00:00 GMT+0000 (Coordinated Universal Time)91130/1 (102) ZOSIAPKP IntercityMon May 16 2022 00:00:00 GMT+0000 (Coordinated Universal Time)Łódź Fabryczna - Warszawa Wschodnia06:120 minWarszawa Zachodnia
Mon May 16 2022 00:00:00 GMT+0000 (Coordinated Universal Time)81170/1 (102) UZNAMPKP IntercityMon May 16 2022 00:00:00 GMT+0000 (Coordinated Universal Time)Świnoujście - Warszawa Wschodnia06:460 minWarszawa Zachodnia
Mon May 16 2022 00:00:00 GMT+0000 (Coordinated Universal Time)61170/1 (102) KARKONOSZEPKP IntercityMon May 16 2022 00:00:00 GMT+0000 (Coordinated Universal Time)Jelenia Góra - Warszawa Wschodnia06:580 minWarszawa Zachodnia

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