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
Sun Apr 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	7837	1	New York Penn Station	105	New York Penn Station	105	Sun Apr 01 2018 11:14:00 GMT+0000 (Coordinated Universal Time)	Sun Apr 01 2018 11:14:10 GMT+0000 (Coordinated Universal Time)	0.166666666667	departed	Northeast Corrdr	NJ Transit
Sun Apr 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	7837	2	New York Penn Station	105	Secaucus Upper Lvl	38187	Sun Apr 01 2018 11:23:00 GMT+0000 (Coordinated Universal Time)	Sun Apr 01 2018 11:26:05 GMT+0000 (Coordinated Universal Time)	3.08333333333	departed	Northeast Corrdr	NJ Transit
Sun Apr 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	7837	3	Secaucus Upper Lvl	38187	Newark Penn Station	107	Sun Apr 01 2018 11:32:00 GMT+0000 (Coordinated Universal Time)	Sun Apr 01 2018 11:36:07 GMT+0000 (Coordinated Universal Time)	4.11666666667	departed	Northeast Corrdr	NJ Transit
Sun Apr 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	7837	4	Newark Penn Station	107	Newark Airport	37953	Sun Apr 01 2018 11:37:00 GMT+0000 (Coordinated Universal Time)	Sun Apr 01 2018 11:40:08 GMT+0000 (Coordinated Universal Time)	3.13333333333	departed	Northeast Corrdr	NJ Transit
Sun Apr 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	7837	5	Newark Airport	37953	Elizabeth	41	Sun Apr 01 2018 11:42:00 GMT+0000 (Coordinated Universal Time)	Sun Apr 01 2018 11:46:04 GMT+0000 (Coordinated Universal Time)	4.06666666667	departed	Northeast Corrdr	NJ Transit
Sun Apr 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	7837	6	Elizabeth	41	Linden	70	Sun Apr 01 2018 11:48:00 GMT+0000 (Coordinated Universal Time)	Sun Apr 01 2018 11:51:07 GMT+0000 (Coordinated Universal Time)	3.11666666667	departed	Northeast Corrdr	NJ Transit
Sun Apr 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	7837	7	Linden	70	Rahway	127	Sun Apr 01 2018 11:52:00 GMT+0000 (Coordinated Universal Time)	Sun Apr 01 2018 11:55:08 GMT+0000 (Coordinated Universal Time)	3.13333333333	departed	Northeast Corrdr	NJ Transit
Sun Apr 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	7837	8	Rahway	127	Metropark	83	Sun Apr 01 2018 11:57:00 GMT+0000 (Coordinated Universal Time)	Sun Apr 01 2018 12:01:08 GMT+0000 (Coordinated Universal Time)	4.13333333333	departed	Northeast Corrdr	NJ Transit
Sun Apr 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	7837	9	Metropark	83	Metuchen	84	Sun Apr 01 2018 12:02:00 GMT+0000 (Coordinated Universal Time)	Sun Apr 01 2018 12:06:02 GMT+0000 (Coordinated Universal Time)	4.03333333333	departed	Northeast Corrdr	NJ Transit
Sun Apr 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	7837	10	Metuchen	84	Edison	38	Sun Apr 01 2018 12:07:00 GMT+0000 (Coordinated Universal Time)	Sun Apr 01 2018 12:11:06 GMT+0000 (Coordinated Universal Time)	4.1	departed	Northeast Corrdr	NJ Transit


CREATE TABLE n_2018_04 (
  "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
);