NJ Transit + Amtrak (NEC) Rail Performance

date Date	train_id Train Id	stop_sequence Stop Sequence	from From	from_id From Id	to To	to_id To Id	scheduled_time Scheduled Time	actual_time Actual Time	delay_minutes Delay Minutes	status Status	line Line	type Type
Thu Mar 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	3805	1	New York Penn Station	105	New York Penn Station	105	Fri Mar 02 2018 01:22:00 GMT+0000 (Coordinated Universal Time)	Fri Mar 02 2018 01:21:05 GMT+0000 (Coordinated Universal Time)		departed	Northeast Corrdr	NJ Transit
Thu Mar 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	3805	2	New York Penn Station	105	Secaucus Upper Lvl	38187	Fri Mar 02 2018 01:31:00 GMT+0000 (Coordinated Universal Time)	Fri Mar 02 2018 01:31:08 GMT+0000 (Coordinated Universal Time)	0.133333333333	departed	Northeast Corrdr	NJ Transit
Thu Mar 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	3805	3	Secaucus Upper Lvl	38187	Newark Penn Station	107	Fri Mar 02 2018 01:40:00 GMT+0000 (Coordinated Universal Time)	Fri Mar 02 2018 01:40:07 GMT+0000 (Coordinated Universal Time)	0.116666666667	departed	Northeast Corrdr	NJ Transit
Thu Mar 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	3805	4	Newark Penn Station	107	Newark Airport	37953	Fri Mar 02 2018 01:45:00 GMT+0000 (Coordinated Universal Time)	Fri Mar 02 2018 01:45:10 GMT+0000 (Coordinated Universal Time)	0.166666666667	departed	Northeast Corrdr	NJ Transit
Thu Mar 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	3805	5	Newark Airport	37953	North Elizabeth	109	Fri Mar 02 2018 01:49:00 GMT+0000 (Coordinated Universal Time)	Fri Mar 02 2018 01:49:10 GMT+0000 (Coordinated Universal Time)	0.166666666667	departed	Northeast Corrdr	NJ Transit
Thu Mar 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	3805	6	North Elizabeth	109	Elizabeth	41	Fri Mar 02 2018 01:52:00 GMT+0000 (Coordinated Universal Time)	Fri Mar 02 2018 01:52:01 GMT+0000 (Coordinated Universal Time)	0.0166666666667	departed	Northeast Corrdr	NJ Transit
Thu Mar 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	3805	7	Elizabeth	41	Linden	70	Fri Mar 02 2018 01:58:00 GMT+0000 (Coordinated Universal Time)	Fri Mar 02 2018 01:58:05 GMT+0000 (Coordinated Universal Time)	0.0833333333333	departed	Northeast Corrdr	NJ Transit
Thu Mar 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	3805	8	Linden	70	Rahway	127	Fri Mar 02 2018 02:02:00 GMT+0000 (Coordinated Universal Time)	Fri Mar 02 2018 02:01:03 GMT+0000 (Coordinated Universal Time)		departed	Northeast Corrdr	NJ Transit
Thu Mar 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	3805	9	Rahway	127	Metropark	83	Fri Mar 02 2018 02:08:00 GMT+0000 (Coordinated Universal Time)	Fri Mar 02 2018 02:08:00 GMT+0000 (Coordinated Universal Time)		departed	Northeast Corrdr	NJ Transit
Thu Mar 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	3805	10	Metropark	83	Metuchen	84	Fri Mar 02 2018 02:13:00 GMT+0000 (Coordinated Universal Time)	Fri Mar 02 2018 02:13:10 GMT+0000 (Coordinated Universal Time)	0.166666666667	departed	Northeast Corrdr	NJ Transit


CREATE TABLE n_2018_03 (
  "date" TIMESTAMP,
  "train_id" VARCHAR,
  "stop_sequence" DOUBLE,
  "from" VARCHAR,
  "from_id" BIGINT,
  "to" VARCHAR,
  "to_id" BIGINT,
  "scheduled_time" TIMESTAMP,
  "actual_time" TIMESTAMP,
  "delay_minutes" DOUBLE,
  "status" VARCHAR,
  "line" VARCHAR,
  "type" VARCHAR
);