Mrbilit Trip Information Dataset

Trip Information Dataset

@kaggle.samyardaghighirad_mrbilit_trip_information_dataset

Table List

1 table(5.71 MB)

Mrbilit Dataset

@kaggle.samyardaghighirad_mrbilit_trip_information_dataset.mrbilit_dataset

5.71 MB
101017 rows
22 columns

created Created	canceltime CancelTime	departuretime DepartureTime	billid BillID	ticketid TicketID	reservestatus ReserveStatus	userid UserID	male Male	price Price	from From	to To	domestic Domestic	vehicletype VehicleType	vehicleclass VehicleClass	tripreason TripReason	vehicle Vehicle	cancel Cancel	hashpassportnumber_p HashPassportNumber P	hashemail HashEmail	buyermobile BuyerMobile	nationalcode NationalCode
Tue Jul 26 2022 13:33:20 GMT+0000 (Coordinated Universal Time)		Tue Jul 26 2022 16:30:00 GMT+0000 (Coordinated Universal Time)	38428546	7445571	3		true	1180000	شیراز	سیرجان	1	VIPمانیتوردار-شارژراختصاصی تخت شو مارال (جدید)مدل 140 -هرپنج سفریک سفرهدیه همسفر(جوایز به قید	True	Work	Bus		nan	nan	302222356019	330024570
Thu Oct 27 2022 23:07:01 GMT+0000 (Coordinated Universal Time)	Thu Oct 27 2022 23:26:39 GMT+0000 (Coordinated Universal Time)	Sat Oct 29 2022 09:45:00 GMT+0000 (Coordinated Universal Time)	39768762	7762719	5			1050000	قم	ساری	1	classicus 2+2	True	Int	Bus	1	nan	nan	900764168521	995520696
Mon Sep 12 2022 11:01:13 GMT+0000 (Coordinated Universal Time)		Mon Oct 03 2022 18:35:00 GMT+0000 (Coordinated Universal Time)	39128001	2327596	5	800398		4674000	تهران	ارومیه	1	فوکر 100	False	Int	Plane		nan	1c44d7a76b52341fa12dcfa993138576befcc9ebf01d14c1b2e68792	749804783291	979382950
Mon Aug 08 2022 17:43:35 GMT+0000 (Coordinated Universal Time)		Mon Aug 08 2022 22:30:00 GMT+0000 (Coordinated Universal Time)	38606546	7495440	3		true	1200000	تهران	ملایر	1	VIPدرسا+مانیتوردار+شارژراختصاصی+پذیرایی	True	Work	Bus		nan	nan	781396205677	911237229
Tue Nov 01 2022 15:12:56 GMT+0000 (Coordinated Universal Time)		Thu Nov 03 2022 11:30:00 GMT+0000 (Coordinated Universal Time)	39822185	2356902	5		true	6222000	چابهار	تهران	1	nan	False	Work	Plane		nan	bb38b345aec02255e31d178492907175c5984f2a1f5b59f779e8fc9e	524576220177	727496008
Mon Apr 11 2022 08:53:01 GMT+0000 (Coordinated Universal Time)		Fri Apr 15 2022 09:30:00 GMT+0000 (Coordinated Universal Time)	36870978	2238994	5			9804000	کرمان	تهران	1	nan	False	Int	Plane		nan	5cdec33b9740edf7a93e7e694ceb8c16dcae765f7be6a4cf27d81858	827115300546	133415535
Sun Aug 28 2022 23:43:42 GMT+0000 (Coordinated Universal Time)		Tue Sep 20 2022 12:15:00 GMT+0000 (Coordinated Universal Time)	38893130	2974202	2			2043000	مشهد	تهران	1	3 ستاره 6 تخته کوير	nan	Int	Train		nan	nan	885411108132	966172739
Sat Jun 25 2022 11:48:37 GMT+0000 (Coordinated Universal Time)		Mon Jun 27 2022 21:30:00 GMT+0000 (Coordinated Universal Time)	37957827	2867524	2			70000	تهران	قم	1	4 ستاره اتوبوسي صبا	nan	Work	Train		nan	nan	979627756303	868161300
Thu Oct 13 2022 15:00:58 GMT+0000 (Coordinated Universal Time)		Sat Oct 15 2022 10:00:00 GMT+0000 (Coordinated Universal Time)	39599432	7715434	3	383592	true	1775000	اصفهان	دزفول	1	VIPمانیتوردار	True	Work	Bus		nan	f0c41c01f5854719f738c63cb094b15beab6e1b1f886899ffd0b5af9	99750462327	579628913
Wed Oct 12 2022 14:03:12 GMT+0000 (Coordinated Universal Time)		Thu Oct 13 2022 14:45:00 GMT+0000 (Coordinated Universal Time)	39586973	3058791	2		true	80000	سرخس	مشهد	1	4 ستاره اتوبوسي صبا	nan	Int	Train		nan	nan	131055688227	115458484


CREATE TABLE mrbilit_dataset (
  "created" TIMESTAMP,
  "canceltime" TIMESTAMP,
  "departuretime" TIMESTAMP,
  "billid" BIGINT,
  "ticketid" DOUBLE,
  "reservestatus" BIGINT,
  "userid" DOUBLE,
  "male" BOOLEAN,
  "price" DOUBLE,
  "coupondiscount" DOUBLE,
  "from" VARCHAR,
  "to" VARCHAR,
  "domestic" BIGINT,
  "vehicletype" VARCHAR,
  "vehicleclass" VARCHAR,
  "tripreason" VARCHAR,
  "vehicle" VARCHAR,
  "cancel" BIGINT,
  "hashpassportnumber_p" VARCHAR,
  "hashemail" VARCHAR,
  "buyermobile" BIGINT,
  "nationalcode" BIGINT
);