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
Schedules
@kaggle.bhavyarajdev_indian_railways_schedule_prices_availability_data.schedules
- 2.59 MB
- 3292 rows
- 13 columns
trainnumberTrainNumber | trainnameTrainName | stationfromStationFrom | stationtoStationTo | trainrunsonmonTrainRunsOnMon | trainrunsontueTrainRunsOnTue | trainrunsonwedTrainRunsOnWed | trainrunsonthuTrainRunsOnThu | trainrunsonfriTrainRunsOnFri | trainrunsonsatTrainRunsOnSat | trainrunsonsunTrainRunsOnSun | timestampTimeStamp | stationlistStationList |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 961 | VALLEY QUEEN SPL | MJ | MJMG | Y | Y | N | Y | Y | N | N | Sun Oct 15 2023 13:04:05 GMT+0000 (Coordinated Universal Time) | [{'stationCode': 'MJ', 'stationName': 'MARWAR JN', 'arrivalTime': '--', 'departureTime': '08:30', 'routeNumber': '1', 'haltTime': '--', 'distance': '0', 'dayCount': '1', 'stnSerialNumber': '1', 'boardingDisabled': 'false'}, {'stationCode': 'FLD', 'stationName': 'PHULAD', 'arrivalTime': '09:20', 'dep… |
| 1027 | DR GKP SPECIAL | DR | GKP | N | Y | N | Y | N | Y | Y | Sun Oct 15 2023 13:04:36 GMT+0000 (Coordinated Universal Time) | [{'stationCode': 'DR', 'stationName': 'DADAR', 'arrivalTime': '--', 'departureTime': '14:05', 'routeNumber': '1', 'haltTime': '--', 'distance': '0', 'dayCount': '1', 'stnSerialNumber': '1', 'boardingDisabled': 'false'}, {'stationCode': 'KYN', 'stationName': 'KALYAN JN', 'arrivalTime': '14:55', 'depa… |
| 1065 | DADAR DHULE SPL | DR | DHI | Y | N | N | N | Y | N | Y | Sun Oct 15 2023 13:05:16 GMT+0000 (Coordinated Universal Time) | [{'stationCode': 'DR', 'stationName': 'DADAR', 'arrivalTime': '--', 'departureTime': '16:15', 'routeNumber': '1', 'haltTime': '--', 'distance': '0', 'dayCount': '1', 'stnSerialNumber': '1', 'boardingDisabled': 'false'}, {'stationCode': 'TNA', 'stationName': 'THANE', 'arrivalTime': '16:40', 'departur… |
| 1066 | DHULE DADAR SPL | DHI | DR | Y | Y | N | N | N | Y | N | Sun Oct 15 2023 13:05:17 GMT+0000 (Coordinated Universal Time) | [{'stationCode': 'DHI', 'stationName': 'DHULE', 'arrivalTime': '--', 'departureTime': '06:30', 'routeNumber': '1', 'haltTime': '--', 'distance': '0', 'dayCount': '1', 'stnSerialNumber': '1', 'boardingDisabled': 'false'}, {'stationCode': 'SHF', 'stationName': 'SHIRUD', 'arrivalTime': '07:04', 'depart… |
| 1127 | LTT BPQ SPL | LTT | BPQ | N | Y | N | N | N | N | N | Sun Oct 15 2023 13:05:44 GMT+0000 (Coordinated Universal Time) | [{'stationCode': 'LTT', 'stationName': 'LOKMANYATILAK T', 'arrivalTime': '--', 'departureTime': '21:45', 'routeNumber': '1', 'haltTime': '--', 'distance': '0', 'dayCount': '1', 'stnSerialNumber': '1', 'boardingDisabled': 'false'}, {'stationCode': 'TNA', 'stationName': 'THANE', 'arrivalTime': '22:03'… |
| 1128 | BPQ LTT SPL | BPQ | LTT | N | N | Y | N | N | N | N | Sun Oct 15 2023 13:05:45 GMT+0000 (Coordinated Universal Time) | [{'stationCode': 'BPQ', 'stationName': 'BALHARSHAH', 'arrivalTime': '--', 'departureTime': '13:40', 'routeNumber': '1', 'haltTime': '--', 'distance': '0', 'dayCount': '1', 'stnSerialNumber': '1', 'boardingDisabled': 'false'}, {'stationCode': 'CD', 'stationName': 'CHANDRAPUR', 'arrivalTime': '13:55',… |
| 1139 | NGP MAO SPECIAL | NGP | MAO | N | N | Y | N | N | Y | N | Sun Oct 15 2023 13:05:50 GMT+0000 (Coordinated Universal Time) | [{'stationCode': 'NGP', 'stationName': 'NAGPUR', 'arrivalTime': '--', 'departureTime': '15:05', 'routeNumber': '1', 'haltTime': '--', 'distance': '0', 'dayCount': '1', 'stnSerialNumber': '1', 'boardingDisabled': 'false'}, {'stationCode': 'WR', 'stationName': 'WARDHA JN', 'arrivalTime': '16:10', 'dep… |
| 1140 | MAO NGP SPECIAL | MAO | NGP | N | N | N | Y | N | N | Y | Sun Oct 15 2023 13:05:51 GMT+0000 (Coordinated Universal Time) | [{'stationCode': 'MAO', 'stationName': 'MADGAON', 'arrivalTime': '--', 'departureTime': '19:00', 'routeNumber': '1', 'haltTime': '--', 'distance': '0', 'dayCount': '1', 'stnSerialNumber': '1', 'boardingDisabled': 'false'}, {'stationCode': 'KRMI', 'stationName': 'KARMALI', 'arrivalTime': '19:30', 'de… |
| 1423 | PUNE MRJ SPL | PUNE | MRJ | N | Y | N | N | N | N | N | Sun Oct 15 2023 13:09:14 GMT+0000 (Coordinated Universal Time) | [{'stationCode': 'PUNE', 'stationName': 'PUNE JN', 'arrivalTime': '--', 'departureTime': '08:00', 'routeNumber': '1', 'haltTime': '--', 'distance': '0', 'dayCount': '1', 'stnSerialNumber': '1', 'boardingDisabled': 'false'}, {'stationCode': 'JJR', 'stationName': 'JEJURI', 'arrivalTime': '08:53', 'dep… |
| 1424 | MRJ PUNE SPL | MRJ | PUNE | N | Y | N | N | N | N | N | Sun Oct 15 2023 13:09:15 GMT+0000 (Coordinated Universal Time) | [{'stationCode': 'MRJ', 'stationName': 'MIRAJ JN', 'arrivalTime': '--', 'departureTime': '14:25', 'routeNumber': '1', 'haltTime': '--', 'distance': '0', 'dayCount': '1', 'stnSerialNumber': '1', 'boardingDisabled': 'false'}, {'stationCode': 'SLI', 'stationName': 'SANGLI', 'arrivalTime': '14:37', 'dep… |
CREATE TABLE schedules (
"trainnumber" BIGINT,
"trainname" VARCHAR,
"stationfrom" VARCHAR,
"stationto" VARCHAR,
"trainrunsonmon" VARCHAR,
"trainrunsontue" VARCHAR,
"trainrunsonwed" VARCHAR,
"trainrunsonthu" VARCHAR,
"trainrunsonfri" VARCHAR,
"trainrunsonsat" VARCHAR,
"trainrunsonsun" VARCHAR,
"timestamp" TIMESTAMP,
"stationlist" VARCHAR
);