[boo]

Onlinetours.ru is a Russian-based online travel agency specializing in offering a wide range of travel services and vacation packages. The platform provides users with options for booking flights, hotels, and complete tour packages to various destinations worldwide. It is tailored to the Russian-speaking market, featuring user-friendly search tools and competitive pricing. The company is headquartered in Moscow, Russia, and aims to make travel planning convenient and accessible for its customers within Russia and neighboring regions.

order_id,order_date,traveller_is_payer,order_phone,order_email,price,reservation_state,operator,adults,children,city_from,city_to,hotel,hotel_class,room,meal,traveller_last_name,traveller_first_name,traveller_middle_name,traveller_birth_date,traveller_citizenship,passport,passport_issued,passport_issued_by,passport_expiration,rf_passport,passport_issued,passport_issued_by,birth_certificate,flight_from_date,flight_from_time,flight_to_time,flight_back_date,flight_from,flight_to,flight_back_from,flight_back_to,flight_to_number,flight_back_number
427923,2014-05-03,false,79188963330,krasnoyarskiy_da@mail.ru,83520,paid,,2,2,Ростов-на-Дону,Шарм-эль-Шейх,"Sheraton Sharm Hotel, Resort, Villas & Spa",Villas,Standard,RO,KRASNOYARSKAYA,ANASTASIA,,2002-03-09,Россия,71 3463926,2011-03-02,FMS 61022,2021-03-02, ,,"", ,2014-07-03,"","",2014-06-24,"","","","","",""
427923,2014-05-03,false,79188963330,krasnoyarskiy_da@mail.ru,83520,paid,,2,2,Ростов-на-Дону,Шарм-эль-Шейх,"Sheraton Sharm Hotel, Resort, Villas & Spa",Villas,Standard,RO,IAKOVLEV,IVAN,,2007-09-11,Россия,71 8489077,2012-04-04,FMS 61022,2022-04-04, ,,"", ,2014-07-03,"","",2014-06-24,"","","","","",""
427923,2014-05-03,false,79188963330,krasnoyarskiy_da@mail.ru,83520,paid,,2,2,Ростов-на-Дону,Шарм-эль-Шейх,"Sheraton Sharm Hotel, Resort, Villas & Spa",Villas,Standard,RO,KRASNOYARSKAYA,ZOYA,,1947-02-26,Россия,72 636269,2012-08-09,FMS 61022,2022-08-09, ,,"", ,2014-07-03,"","",2014-06-24,"","","","","",""
427923,2014-05-03,true,79188963330,krasnoyarskiy_da@mail.ru,83520,paid,,2,2,Ростов-на-Дону,Шарм-эль-Шейх,"Sheraton Sharm Hotel, Resort, Villas & Spa",Villas,Standard,RO,KRASNOYARSKIY,ALEXANDR,,1946-09-12,Россия,72 703506,2012-08-14,FMS 61022,2022-08-14, ,,"", ,2014-07-03,"","",2014-06-24,"","","","","",""
429994,2014-05-14,false,79250061926,ekaterina-suhanova@bk.ru,0.000000,cancelled,Библио Глобус,2,1,Москва,Анталья,Ring Beach Hotel,Villas,STANDARD ROOM,RO,Gordeeva,Ekaterina,,1974-02-19,Россия,72 4601088,2013-05-22,OUFMS 77539,2023-05-22, ,,"", ,2014-09-12,"","",2014-09-03,"","","","","",""
429994,2014-05-14,true,79250061926,ekaterina-suhanova@bk.ru,0.000000,cancelled,Библио Глобус,2,1,Москва,Анталья,Ring Beach Hotel,Villas,STANDARD ROOM,RO,Gordeeva,Ekaterina,,1974-02-19,РОССИЯ,72 4601088,2013-05-22,ФМС 77539,2023-05-22, ,,"", ,2014-09-12,"","",2014-09-03,"","","","","",""
429994,2014-05-14,true,79250061926,ekaterina-suhanova@bk.ru,0.000000,cancelled,Библио Глобус,2,1,Москва,Анталья,Ring Beach Hotel,Villas,STANDARD ROOM,RO,Alisa,Gordeeva,,2008-08-09,Россия,72 4490466,2013-05-16,ФМС 77539,2023-05-16, ,,"", ,2014-09-12,"","",2014-09-03,"","","","","",""
429994,2014-05-14,true,79250061926,ekaterina-suhanova@bk.ru,0.000000,cancelled,Библио Глобус,2,1,Москва,Анталья,Ring Beach Hotel,Villas,STANDARD ROOM,RO,Shitova,AnastasiIa,,1976-01-26,Россия,11 1111111,2014-05-14,111,2024-05-14, ,,"", ,2014-09-12,"","",2014-09-03,"","","","","",""
429994,2014-05-14,false,79250061926,ekaterina-suhanova@bk.ru,0.000000,cancelled,Библио Глобус,2,1,Москва,Анталья,Ring Beach Hotel,Villas,STANDARD ROOM,RO,Gordeeva,Ekaterina,,1974-02-19,Россия,72 4601088,2013-05-22,OUFMS 77539,2023-05-22, ,0000-00-00,"", ,2014-09-12,"","",2014-09-03,"","","","","",""