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
Tue May 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	3926	1	Trenton	148	Trenton	148	Tue May 01 2018 07:31:00 GMT+0000 (Coordinated Universal Time)	Tue May 01 2018 07:35:13 GMT+0000 (Coordinated Universal Time)	4.21666666667	departed	Northeast Corrdr	NJ Transit
Tue May 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	3926	2	Trenton	148	Hamilton	32905	Tue May 01 2018 07:38:00 GMT+0000 (Coordinated Universal Time)	Tue May 01 2018 07:40:10 GMT+0000 (Coordinated Universal Time)	2.16666666667	departed	Northeast Corrdr	NJ Transit
Tue May 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	3926	3	Hamilton	32905	Princeton Junction	125	Tue May 01 2018 07:45:00 GMT+0000 (Coordinated Universal Time)	Tue May 01 2018 07:46:09 GMT+0000 (Coordinated Universal Time)	1.15	departed	Northeast Corrdr	NJ Transit
Tue May 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	3926	4	Princeton Junction	125	Newark Penn Station	107	Tue May 01 2018 08:22:00 GMT+0000 (Coordinated Universal Time)	Tue May 01 2018 08:24:02 GMT+0000 (Coordinated Universal Time)	2.03333333333	departed	Northeast Corrdr	NJ Transit
Tue May 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	3926	5	Newark Penn Station	107	Secaucus Upper Lvl	38187	Tue May 01 2018 08:30:00 GMT+0000 (Coordinated Universal Time)	Tue May 01 2018 08:35:12 GMT+0000 (Coordinated Universal Time)	5.2	departed	Northeast Corrdr	NJ Transit
Tue May 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	3926	6	Secaucus Upper Lvl	38187	New York Penn Station	105	Tue May 01 2018 08:46:00 GMT+0000 (Coordinated Universal Time)	Tue May 01 2018 08:49:00 GMT+0000 (Coordinated Universal Time)	3	estimated	Northeast Corrdr	NJ Transit
Tue May 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	1216	1	Waldwick	151	Waldwick	151	Tue May 01 2018 10:50:00 GMT+0000 (Coordinated Universal Time)	Tue May 01 2018 10:50:06 GMT+0000 (Coordinated Universal Time)	0.1	departed	Main Line	NJ Transit
Tue May 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	1216	2	Waldwick	151	Ho-Ho-Kus	64	Tue May 01 2018 10:54:00 GMT+0000 (Coordinated Universal Time)	Tue May 01 2018 10:55:04 GMT+0000 (Coordinated Universal Time)	1.06666666667	departed	Main Line	NJ Transit
Tue May 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	1216	3	Ho-Ho-Kus	64	Ridgewood	131	Tue May 01 2018 10:57:00 GMT+0000 (Coordinated Universal Time)	Tue May 01 2018 10:58:08 GMT+0000 (Coordinated Universal Time)	1.13333333333	departed	Main Line	NJ Transit
Tue May 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	1216	4	Ridgewood	131	Glen Rock Main Line	52	Tue May 01 2018 11:00:00 GMT+0000 (Coordinated Universal Time)	Tue May 01 2018 11:02:05 GMT+0000 (Coordinated Universal Time)	2.08333333333	departed	Main Line	NJ Transit


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