Vande Bharat, Indian Railways

Dataset contains list of 25 Vande Bharat that are in service as of July 2023

@kaggle.anirudhkulkarni455_vande_bharat

Table List

1 table(17.18 KB)

Vande Bharat Jan 2024 Vande Bharat

Vande Bharat Jan 2024 Vande Bharat

@kaggle.anirudhkulkarni455_vande_bharat.vande_bharat_jan_2024_vande_bharat

17.18 KB
42 rows
17 columns

sr_no Sr. No.	train_name Train Name	train_number Train Number	originating_city Originating City	originating_station Originating Station	terminal_city Terminal City	terminal_station Terminal Station	operator Operator	no_of_cars No. Of Cars	frequency Frequency	distance Distance	travel_time Travel Time	speed Speed	average_speed Average Speed	inauguration Inauguration	average_occupancy Average Occupancy	color Color
1	New Delhi - Varanasi Vande Bharat Express	22435/22436	Delhi	New Delhi	Varanasi	Varanasi Junction	NR	16	Except Thursdays	759 km (472 mi)	08h 00m	130 km/h (81 mph)	95 km/h (59 mph)	2/15/2019	126%	Blue & White
2	New Delhi - Shri Mata Vaishno Devi Katra Vande Bharat Express	22439/22440	Delhi	New Delhi	Katra	Shri Mata Vaishno Devi Katra	NR	16	Except Tuesdays	655 km (407 mi)	08h 00m	130 km/h (81 mph)	82 km/h (51 mph)	10/3/2019	114%	Blue & White
3	Mumbai Central - Gandhinagar Capital Vande Bharat Express	20901/20902	Mumbai	Mumbai Central	Gandhinagar	Gandhinagar Capital	WR	16	Except Wednesdays	522 km (324 mi)	06h 25m	130 km/h (81 mph)	82 km/h (51 mph)	9/30/2022	132%	Blue & White
4	New Delhi - Amb Andaura Vande Bharat Express	22447/22448	Delhi	New Delhi	Andaura	Amb Andaura	NR	16	Except Fridays	412 km (256 mi)	05h 10m	130 km/h (81 mph)	79 km/h (49 mph)	10/13/2022	70%	Blue & White
5	MGR Chennai Central - Mysuru Vande Bharat Express	20607/20608	Chennai	Chennai Central	Mysuru	Mysore Junction	SR	16	Except Wednesdays	496 km (308 mi)	06h 30m	130 km/h (81 mph)	79 km/h (49 mph)	11/11/2022	122%	Blue & White
6	Bilaspur - Nagpur Vande Bharat Express	20825/20826	Bilaspur	Bilaspur Junction	Nagpur	Nagpur Junction	SECR	8	Except Saturdays	412 km (256 mi)	05h 30m	130 km/h (81 mph)	75 km/h (47 mph)	12/11/2022	96%	Blue & White
7	Howrah - New Jalpaiguri Vande Bharat Express	22301/22302	Kolkata	Howrah Junction	Siliguri	New Jalpaiguri Junction	ER	16	Except Wednesdays	565 km (351 mi)	07h 30m	130 km/h (81 mph)	75 km/h (47 mph)	12/30/2022	100%	Blue & White
8	Visakhapatnam - Secunderabad Vande Bharat Express	20833/20834	Visakhapatnam	Visakhapatnam Junction	Hyderabad	Secunderabad Junction	ECoR	16	Except Sundays	698 km (434 mi)	08h 30m	130 km/h (81 mph)	82 km/h (51 mph)	1/15/2023	120%	Blue & White
9	Mumbai CSMT - Solapur Vande Bharat Express	22225/22226	Mumbai	Chhatrapati Shivaji Terminus	Solapur	Solapur	CR	16	Except Wednesdays (22225) , Except Thursdays (22226)	452 km (281 mi)	06h 30m	110 km/h (68 mph)	70 km/h (43 mph)	2/10/2023	94%	Blue & White
10	Mumbai CSMT - Sainagar Shirdi Vande Bharat Express	22223/22224	Mumbai	Chhatrapati Shivaji Terminus	Shirdi	Sainagar Shirdi	CR	16	Except Tuesdays	339 km (211 mi)	05h 20m	110 km/h (68 mph)	64 km/h (40 mph)	2/10/2023	82%	Blue & White


CREATE TABLE vande_bharat_jan_2024_vande_bharat (
  "sr_no" BIGINT,
  "train_name" VARCHAR,
  "train_number" VARCHAR,
  "originating_city" VARCHAR,
  "originating_station" VARCHAR,
  "terminal_city" VARCHAR,
  "terminal_station" VARCHAR,
  "operator" VARCHAR,
  "no_of_cars" BIGINT,
  "frequency" VARCHAR,
  "distance" VARCHAR,
  "travel_time" VARCHAR,
  "speed" VARCHAR,
  "average_speed" VARCHAR,
  "inauguration" VARCHAR,
  "average_occupancy" VARCHAR,
  "color" VARCHAR
);