Indian Railways Schedule-Prices-Availability Data

Comprehensive Dataset Featuring Public Trains Scrapped from IRCTC in 10-2023

@kaggle.bhavyarajdev_indian_railways_schedule_prices_availability_data

Table List

2 tables(7.92 MB)

Price Data

@kaggle.bhavyarajdev_indian_railways_schedule_prices_availability_data.price_data

5.33 MB
326643 rows
19 columns

basefare BaseFare	reservationcharge ReservationCharge	servicetax ServiceTax	totalfare TotalFare	availability Availability	trainnumber TrainNumber	timestamp TimeStamp	fromstncode FromStnCode	tostncode ToStnCode	classcode ClassCode	distance Distance	duration Duration
1059	60	56	1175	[{'date': '2-12-2023', 'status': 'AVAILABLE-0008'}, {'date': '3-12-2023', 'status': 'AVAILABLE-0014'}, {'date': '5-12-2023', 'status': 'AVAILABLE-0011'}, {'date': '6-12-2023', 'status': 'AVAILABLE-0004'}, {'date': '7-12-2023', 'status': 'AVAILABLE-0014'}, {'date': '9-12-2023', 'status': 'AVAILABLE-0…	11464	Tue Oct 03 2023 22:13:07 GMT+0000 (Coordinated Universal Time)	JBP	SRID	1A	54	33
626	50	34	710	[{'date': '2-12-2023', 'status': 'AVAILABLE-0020'}, {'date': '3-12-2023', 'status': 'AVAILABLE-0026'}, {'date': '5-12-2023', 'status': 'AVAILABLE-0029'}, {'date': '6-12-2023', 'status': 'AVAILABLE-0018'}, {'date': '7-12-2023', 'status': 'AVAILABLE-0026'}, {'date': '9-12-2023', 'status': 'AVAILABLE-0…	11464	Tue Oct 03 2023 22:13:07 GMT+0000 (Coordinated Universal Time)	JBP	SRID	2A	54	33
441	40	24	505	[{'date': '2-12-2023', 'status': 'AVAILABLE-0136'}, {'date': '3-12-2023', 'status': 'AVAILABLE-0192'}, {'date': '5-12-2023', 'status': 'AVAILABLE-0185'}, {'date': '6-12-2023', 'status': 'AVAILABLE-0139'}, {'date': '7-12-2023', 'status': 'AVAILABLE-0154'}, {'date': '9-12-2023', 'status': 'AVAILABLE-0…	11464	Tue Oct 03 2023 22:13:07 GMT+0000 (Coordinated Universal Time)	JBP	SRID	3A	54	33
125	20		145	[{'date': '2-12-2023', 'status': 'AVAILABLE-0090'}, {'date': '3-12-2023', 'status': 'AVAILABLE-0101'}, {'date': '5-12-2023', 'status': 'AVAILABLE-0100'}, {'date': '6-12-2023', 'status': 'AVAILABLE-0067'}, {'date': '7-12-2023', 'status': 'AVAILABLE-0118'}, {'date': '9-12-2023', 'status': 'AVAILABLE-0…	11464	Tue Oct 03 2023 22:13:07 GMT+0000 (Coordinated Universal Time)	JBP	SRID	SL	54	33
1059	60	56	1175	[{'date': '2-12-2023', 'status': 'AVAILABLE-0008'}, {'date': '3-12-2023', 'status': 'AVAILABLE-0014'}, {'date': '5-12-2023', 'status': 'AVAILABLE-0011'}, {'date': '6-12-2023', 'status': 'AVAILABLE-0004'}, {'date': '7-12-2023', 'status': 'AVAILABLE-0014'}, {'date': '9-12-2023', 'status': 'AVAILABLE-0…	11464	Tue Oct 03 2023 22:13:07 GMT+0000 (Coordinated Universal Time)	JBP	KKB	1A	69	49
626	50	34	710	[{'date': '2-12-2023', 'status': 'AVAILABLE-0020'}, {'date': '3-12-2023', 'status': 'AVAILABLE-0026'}, {'date': '5-12-2023', 'status': 'AVAILABLE-0029'}, {'date': '6-12-2023', 'status': 'AVAILABLE-0018'}, {'date': '7-12-2023', 'status': 'AVAILABLE-0026'}, {'date': '9-12-2023', 'status': 'AVAILABLE-0…	11464	Tue Oct 03 2023 22:13:07 GMT+0000 (Coordinated Universal Time)	JBP	KKB	2A	69	49
441	40	24	505	[{'date': '2-12-2023', 'status': 'AVAILABLE-0136'}, {'date': '3-12-2023', 'status': 'AVAILABLE-0192'}, {'date': '5-12-2023', 'status': 'AVAILABLE-0185'}, {'date': '6-12-2023', 'status': 'AVAILABLE-0139'}, {'date': '7-12-2023', 'status': 'AVAILABLE-0154'}, {'date': '9-12-2023', 'status': 'AVAILABLE-0…	11464	Tue Oct 03 2023 22:13:07 GMT+0000 (Coordinated Universal Time)	JBP	KKB	3A	69	49
125	20		145	[{'date': '2-12-2023', 'status': 'AVAILABLE-0090'}, {'date': '3-12-2023', 'status': 'AVAILABLE-0101'}, {'date': '5-12-2023', 'status': 'AVAILABLE-0100'}, {'date': '6-12-2023', 'status': 'AVAILABLE-0067'}, {'date': '7-12-2023', 'status': 'AVAILABLE-0118'}, {'date': '9-12-2023', 'status': 'AVAILABLE-0…	11464	Tue Oct 03 2023 22:13:07 GMT+0000 (Coordinated Universal Time)	JBP	KKB	SL	69	49
1059	60	56	1175	[{'date': '2-12-2023', 'status': 'AVAILABLE-0008'}, {'date': '3-12-2023', 'status': 'AVAILABLE-0014'}, {'date': '5-12-2023', 'status': 'AVAILABLE-0011'}, {'date': '6-12-2023', 'status': 'AVAILABLE-0004'}, {'date': '7-12-2023', 'status': 'AVAILABLE-0014'}, {'date': '9-12-2023', 'status': 'AVAILABLE-0…	11464	Tue Oct 03 2023 22:13:07 GMT+0000 (Coordinated Universal Time)	JBP	NU	1A	85	72
626	50	34	710	[{'date': '2-12-2023', 'status': 'AVAILABLE-0020'}, {'date': '3-12-2023', 'status': 'AVAILABLE-0026'}, {'date': '5-12-2023', 'status': 'AVAILABLE-0029'}, {'date': '6-12-2023', 'status': 'AVAILABLE-0018'}, {'date': '7-12-2023', 'status': 'AVAILABLE-0026'}, {'date': '9-12-2023', 'status': 'AVAILABLE-0…	11464	Tue Oct 03 2023 22:13:07 GMT+0000 (Coordinated Universal Time)	JBP	NU	2A	85	72


CREATE TABLE price_data (
  "basefare" BIGINT,
  "reservationcharge" BIGINT,
  "superfastcharge" BIGINT,
  "fuelamount" DOUBLE,
  "totalconcession" BIGINT,
  "tatkalfare" BIGINT,
  "servicetax" DOUBLE,
  "othercharge" BIGINT,
  "cateringcharge" BIGINT,
  "dynamicfare" BIGINT,
  "totalfare" BIGINT,
  "availability" VARCHAR,
  "trainnumber" BIGINT,
  "timestamp" TIMESTAMP,
  "fromstncode" VARCHAR,
  "tostncode" VARCHAR,
  "classcode" VARCHAR,
  "distance" BIGINT,
  "duration" DOUBLE
);