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 Jul 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	0724	1	Gladstone	49	Gladstone	49	Sun Jul 01 2018 12:52:00 GMT+0000 (Coordinated Universal Time)	Sun Jul 01 2018 12:52:05 GMT+0000 (Coordinated Universal Time)	0.0833333333333	departed	Gladstone Branch	NJ Transit
Sun Jul 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	0724	2	Gladstone	49	Peapack	117	Sun Jul 01 2018 12:55:00 GMT+0000 (Coordinated Universal Time)	Sun Jul 01 2018 12:56:09 GMT+0000 (Coordinated Universal Time)	1.15	departed	Gladstone Branch	NJ Transit
Sun Jul 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	0724	3	Peapack	117	Far Hills	45	Sun Jul 01 2018 12:59:00 GMT+0000 (Coordinated Universal Time)	Sun Jul 01 2018 13:00:15 GMT+0000 (Coordinated Universal Time)	1.25	departed	Gladstone Branch	NJ Transit
Sun Jul 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	0724	4	Far Hills	45	Bernardsville	18	Sun Jul 01 2018 13:05:00 GMT+0000 (Coordinated Universal Time)	Sun Jul 01 2018 13:07:04 GMT+0000 (Coordinated Universal Time)	2.06666666667	departed	Gladstone Branch	NJ Transit
Sun Jul 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	0724	5	Bernardsville	18	Basking Ridge	12	Sun Jul 01 2018 13:08:00 GMT+0000 (Coordinated Universal Time)	Sun Jul 01 2018 13:11:05 GMT+0000 (Coordinated Universal Time)	3.08333333333	departed	Gladstone Branch	NJ Transit
Sun Jul 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	0724	6	Basking Ridge	12	Lyons	76	Sun Jul 01 2018 13:11:00 GMT+0000 (Coordinated Universal Time)	Sun Jul 01 2018 13:12:17 GMT+0000 (Coordinated Universal Time)	1.28333333333	departed	Gladstone Branch	NJ Transit
Sun Jul 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	0724	7	Lyons	76	Millington	88	Sun Jul 01 2018 13:14:00 GMT+0000 (Coordinated Universal Time)	Sun Jul 01 2018 13:16:12 GMT+0000 (Coordinated Universal Time)	2.2	departed	Gladstone Branch	NJ Transit
Sun Jul 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	0724	8	Millington	88	Stirling	143	Sun Jul 01 2018 13:17:00 GMT+0000 (Coordinated Universal Time)	Sun Jul 01 2018 13:18:10 GMT+0000 (Coordinated Universal Time)	1.16666666667	departed	Gladstone Branch	NJ Transit
Sun Jul 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	0724	9	Stirling	143	Gillette	48	Sun Jul 01 2018 13:20:00 GMT+0000 (Coordinated Universal Time)	Sun Jul 01 2018 13:21:14 GMT+0000 (Coordinated Universal Time)	1.23333333333	departed	Gladstone Branch	NJ Transit
Sun Jul 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	0724	10	Gillette	48	Berkeley Heights	17	Sun Jul 01 2018 13:24:00 GMT+0000 (Coordinated Universal Time)	Sun Jul 01 2018 13:24:22 GMT+0000 (Coordinated Universal Time)	0.366666666667	departed	Gladstone Branch	NJ Transit


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