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
Fri Jun 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	4635	1	Philadelphia	1	Philadelphia	1	Fri Jun 01 2018 17:46:00 GMT+0000 (Coordinated Universal Time)	Fri Jun 01 2018 17:46:27 GMT+0000 (Coordinated Universal Time)	0.45	departed	Atl. City Line	NJ Transit
Fri Jun 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	4635	2	Philadelphia	1	Pennsauken	43298	Fri Jun 01 2018 18:07:00 GMT+0000 (Coordinated Universal Time)	Fri Jun 01 2018 18:12:40 GMT+0000 (Coordinated Universal Time)	5.66666666667	departed	Atl. City Line	NJ Transit
Fri Jun 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	4635	3	Pennsauken	43298	Cherry Hill	28	Fri Jun 01 2018 18:14:00 GMT+0000 (Coordinated Universal Time)	Fri Jun 01 2018 18:20:38 GMT+0000 (Coordinated Universal Time)	6.63333333333	departed	Atl. City Line	NJ Transit
Fri Jun 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	4635	4	Cherry Hill	28	Lindenwold	71	Fri Jun 01 2018 18:25:00 GMT+0000 (Coordinated Universal Time)	Fri Jun 01 2018 18:30:29 GMT+0000 (Coordinated Universal Time)	5.48333333333	departed	Atl. City Line	NJ Transit
Fri Jun 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	4635	5	Lindenwold	71	Atco	9	Fri Jun 01 2018 18:32:00 GMT+0000 (Coordinated Universal Time)	Fri Jun 01 2018 18:37:47 GMT+0000 (Coordinated Universal Time)	5.78333333333	departed	Atl. City Line	NJ Transit
Fri Jun 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	4635	6	Atco	9	Hammonton	55	Fri Jun 01 2018 18:45:00 GMT+0000 (Coordinated Universal Time)	Fri Jun 01 2018 18:56:25 GMT+0000 (Coordinated Universal Time)	11.4166666667	departed	Atl. City Line	NJ Transit
Fri Jun 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	4635	7	Hammonton	55	Egg Harbor City	39	Fri Jun 01 2018 18:56:00 GMT+0000 (Coordinated Universal Time)	Fri Jun 01 2018 18:58:23 GMT+0000 (Coordinated Universal Time)	2.38333333333	departed	Atl. City Line	NJ Transit
Fri Jun 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	4635	8	Egg Harbor City	39	Absecon	2	Fri Jun 01 2018 19:06:00 GMT+0000 (Coordinated Universal Time)	Fri Jun 01 2018 19:11:38 GMT+0000 (Coordinated Universal Time)	5.63333333333	departed	Atl. City Line	NJ Transit
Fri Jun 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	4635	9	Absecon	2	Atlantic City Rail Terminal	10	Fri Jun 01 2018 19:23:00 GMT+0000 (Coordinated Universal Time)	Fri Jun 01 2018 19:22:00 GMT+0000 (Coordinated Universal Time)		estimated	Atl. City Line	NJ Transit
Fri Jun 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	1175	1	Hoboken	63	Hoboken	63	Fri Jun 01 2018 19:18:00 GMT+0000 (Coordinated Universal Time)	Fri Jun 01 2018 19:17:11 GMT+0000 (Coordinated Universal Time)		departed	Bergen Co. Line	NJ Transit


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