India Special Trains Dataset (2020-2021)

Train data with route, distance, timetable changes etc.

@kaggle.noobidoobidoo_india_special_trains_dataset_2020_2021

Table List

1 table(604.22 KB)

Scraped

@kaggle.noobidoobidoo_india_special_trains_dataset_2020_2021.scraped

604.22 KB
2831 rows
18 columns

unnamed_0 Unnamed: 0	train_id Train Id	name Name	railway_zone Railway Zone	changes Changes	start_date Start Date	src_station SRC Station	start_time Start Time	desc_station DESC Station	end_time End Time	duration Duration	expected_duration Expected Duration	running_days Running Days	class_types Class Types	distance Distance	average_speed Average Speed	coach_order Coach Order	train_route Train Route
	5304	Ernakulam - Gorakhpur Special Fare Special	NER	No TT Change	Jun-21	ERS	23:55	GKP	06:30	54h 35m	27	M	2S SL 3A 2A	3032 km	56 km/hr	[]	['Tel: 0484- 2376131, Kerala', 'Ph: 0484-2624141, Kerala', 'Thrissur Tel: 0487 2423150, Kerala', 'Palakkad Tel: 0491 2555231, Kerala', 'Tele; 0422 - 2301301, Tamil Nadu', 'Tiruppur. Ph:0421-2200450, Tamil Nadu', 'Pincode-638002. Telephone Number- 0424 2256111., Tamil Nadu', 'Pincode-636005, Tamil Na…
1	2012	Kalka - New Delhi Shatabdi Special	NR	No TT Change	Jun-21	KLK	17:45	NDLS	21:45	4h 0m	4	S M T W T F S	CC Ex	269 km	67 km/hr	[' L', 'EOG', ' E2', ' E1', 'C14', 'C13', 'C12', 'C11', 'C10', ' C9', ' C8', ' C7', ' C6', ' C5', ' C4', ' C3', ' C2', ' C1', 'EOG']	['133302, Haryana', 'Daria. Jn. Pnt. KLK/NMDA/UMB, Chandigarh', 'Ambala 133001, Haryana', 'Kurukshetra 136118, Haryana', 'Panipat 132103, Haryana', 'Ajmeri Gate 110002, Delhi NCT']
2	2011	New Delhi - Kalka Shatabdi Special	NR	No TT Change	Jun-21	NDLS	07:40	KLK	11:40	4h 0m	4	S M T W T F S	CC Ex	269 km	67 km/hr	[' L', 'EOG', ' C1', ' C2', ' C3', ' C4', ' C5', ' C6', ' C7', ' C8', ' C9', 'C10', 'C11', 'C12', 'C13', 'C14', ' E1', ' E2', 'EOG']	['Ajmeri Gate 110002, Delhi NCT', 'Panipat 132103, Haryana', 'Kurukshetra 136118, Haryana', 'Ambala 133001, Haryana', 'Daria. Jn. Pnt. KLK/NMDA/UMB, Chandigarh', '133302, Haryana']
3	2030	Amritsar - New Delhi Swarna Jayanti Shatabdi Special	NR	No TT Change	Jul-02	ASR	16:50	NDLS	22:50	6h 0m	6	S M T W F S	CC Ex	448 km	75 km/hr	[' L', 'EOG', ' E3', ' E2', ' E1', 'C14', 'C13', 'C12', 'C11', 'C10', ' C9', ' C8', ' C7', ' C6', ' C5', ' C4', ' C3', ' C2', ' C1', 'EOG']	['Amritsar 143001., Punjab', 'Pincode-143201, Punjab', 'Jalandhar 144001. Jn. Pt. NRO/Kapurthala/JRC/Beas, Punjab', 'District Kapurthala 144401, Punjab', 'Ludhiana 141001, Punjab', 'Opp. Rajpura Bus Stand (Distt.Patiala) 140401, Punjab', 'Ambala 133001, Haryana', 'Ajmeri Gate 110002, Delhi NCT']
4	2029	New Delhi - Amritsar Swarna Jayanti Shatabdi Special	NR	No TT Change	Jul-02	NDLS	07:20	ASR	13:30	6h 10m	6	S M T W F S	CC Ex	448 km	73 km/hr	[' L', 'EOG', ' C1', ' C2', ' C3', ' C4', ' C5', ' C6', ' C7', ' C8', ' C9', 'C10', 'C11', 'C12', 'C13', 'C14', ' E1', ' E2', ' E3', 'EOG']	['Ajmeri Gate 110002, Delhi NCT', 'Ambala 133001, Haryana', 'Opp. Rajpura Bus Stand (Distt.Patiala) 140401, Punjab', 'Ludhiana 141001, Punjab', 'District Kapurthala 144401, Punjab', 'Jalandhar 144001. Jn. Pt. NRO/Kapurthala/JRC/Beas, Punjab', 'Pincode-143201, Punjab', 'Amritsar 143001., Punjab']
5	2461	Shri Shakti AC SF Special	NR	No TT Change	Jul-02	NDLS	19:05	SVDK	06:10	11h 5m	6	S M T W T F S	3A 2A 1A	655 km	59 km/hr	[' L', 'EOG', 'B12', 'B11', 'B10', ' B9', ' B8', ' B7', ' B6', ' B5', ' B4', ' B3', ' B2', ' B1', ' PC', ' A5', ' A4', ' A3', ' A2', ' A1', ' H2', ' H1', 'EOG']	['Ajmeri Gate 110002, Delhi NCT', 'Ambala 133001, Haryana', 'Ludhiana 141001, Punjab', 'Jalandhar - 144001, Punjab', 'Pathankot Cantt 145001 Ph;0186-2251594, Punjab', 'Jammu 180012, Jammu and Kashmir', 'District Udhampur - 182101, Jammu and Kashmir', 'Distt - Reasi Pin - 182320, Jammu and Kashmir']
6	2462	Shri Shakti AC SF Special	NR	No TT Change	Jul-01	SVDK	23:00	NDLS	09:45	10h 45m	6	S M T W T F S	3A 2A 1A	655 km	61 km/hr	[' L', 'EOG', ' H1', ' H2', ' A1', ' A2', ' A3', ' A4', ' A5', ' PC', ' B1', ' B2', ' B3', ' B4', ' B5', ' B6', ' B7', ' B8', ' B9', 'B10', 'B11', 'B12', 'EOG']	['Distt - Reasi Pin - 182320, Jammu and Kashmir', 'District Udhampur - 182101, Jammu and Kashmir', 'Jammu 180012, Jammu and Kashmir', 'Pathankot Cantt 145001 Ph;0186-2251594, Punjab', 'Jalandhar - 144001, Punjab', 'Ludhiana 141001, Punjab', 'Ambala 133001, Haryana', 'Ajmeri Gate 110002, Delhi NCT']
7	5631	Barmer - Guwahati Special	NFR	No TT Change	Jul-04	BME	23:35	GHY	00:35	49h 0m	30	S	2S SL 3A 2A	2453 km	50 km/hr	[]	['344001, Rajasthan', 'Balotra, Rajasthan', '342001, Rajasthan', 'Dist. Nagaur, Rajasthan', 'Dist- Nagaur, Rajasthan', 'Dist - Nagaur, Rajasthan', 'Palari Dist.Nagaur 341533, Rajasthan', 'Jaipur - 302006, Rajasthan', 'Bharatpur, Rajasthan', 'Agra District, Uttar Pradesh', 'PIN 282003, Uttar Pradesh'…
8	5632	Guwahati - Barmer Special	NFR	No TT Change	Jul-01	GHY	10:45	BME	08:25	45h 40m	30	T	2S SL 3A 2A	2453 km	54 km/hr	[]	['Dist - Kamrup Metropolitan, Assam', 'Dist - Kamrup Metropolitan, Assam', 'Dist - Kamrup Rural, Assam', 'Dist - Barpeta, Assam', 'Dist - Bongaigaon, Assam', 'Dist - Alipurduar, West Bengal', 'Dist - Cooch Behar, West Bengal', 'Dist - Jalpaiguri, West Bengal', 'Dist - Kishanganj, Bihar', 'Dist - Utt…
9	5634	Guwahati - Bikaner Special	NFR	No TT Change	Jun-26	GHY	10:45	BKN	05:50	43h 5m	30	S	2S SL 3A 2A	2313 km	54 km/hr	[]	['Dist - Kamrup Metropolitan, Assam', 'Dist - Kamrup Metropolitan, Assam', 'Dist - Kamrup Rural, Assam', 'Dist - Barpeta, Assam', 'Dist - Bongaigaon, Assam', 'Dist - Alipurduar, West Bengal', 'Dist - Cooch Behar, West Bengal', 'Dist - Jalpaiguri, West Bengal', 'Dist - Kishanganj, Bihar', 'Dist - Utt…


CREATE TABLE scraped (
  "unnamed_0" BIGINT,
  "train_id" VARCHAR,
  "name" VARCHAR,
  "railway_zone" VARCHAR,
  "changes" VARCHAR,
  "start_date" VARCHAR,
  "src_station" VARCHAR,
  "start_time" VARCHAR,
  "desc_station" VARCHAR,
  "end_time" VARCHAR,
  "duration" VARCHAR,
  "expected_duration" BIGINT,
  "running_days" VARCHAR,
  "class_types" VARCHAR,
  "distance" VARCHAR,
  "average_speed" VARCHAR,
  "coach_order" VARCHAR,
  "train_route" VARCHAR
);