{ "total_orders": "1232", "payment_statuses": [ { "payment_status": "paid", "cnt": "750" }, { "payment_status": "created", "cnt": "481" }, { "payment_status": "pending", "cnt": "1" } ], "ticket_statuses": [ { "ticket_status": "Booking Confirmed", "cnt": "326" }, { "ticket_status": "Booking Pending Confirmation", "cnt": "324" }, { "ticket_status": "Ticketing In Progress", "cnt": "299" }, { "ticket_status": "Ticketing_Failed", "cnt": "159" }, { "ticket_status": "Booking Failed", "cnt": "115" }, { "ticket_status": "PNR=", "cnt": "9" } ], "unique_emails": [ "00rahulthapa@gmail.com", "07yashgupta@gmail.com", "14mohitchawla@gmail.com", "18subhash.in@gmail.com", "aadfkk@gmail.com", "aaditya@gmail.com", "aadityashukla409@gmail.com", "aakarshjain811@gmail.com", "aashishjaink@gmail.com", "abdulshahid0393@gmail.com", "abenterprise209@gmail.com", "abutalhaa7978@gmail.com", "achandra250@gmail.com", "achismitadey@gmail.com", "aditisrivastava110@gmail.com", "adityajain9699@gmail.com", "adityaraj@gmail.com", "afs@gmail.com", "agrimborgohain@gmail.com", "ahmedbanaqeeb.07@gmail.com", "aisha.sharma@example.com", "aishwaryajadhav70@gmail.com", "ajaya2v2verma@gmail.com", "ajbaralam027@gmail.com", "akash.kumar@thebookflight.com", "akash@example.com", "akashpatil297@gmail.com", "akashsharma@gmail.com", "akshat.sunbeam03@gmail.com", "albertomimi16@gmail.com", "allenln43110@gmail.com", "am.tanjiro@gmail.com", "aminulhoque613@gmail.com", "aniruddhmukhiya@gmail.com", "ansariyasir128@gmail.com", "anubhavverma9918@gmail.com", "anuprajsinghdav@gmail.com", "anushadadam01@gmail.com", "archieajay115@gmail.com", "archijain223@gmail.com", "arjungkp005@gmail.com", "arjunv748@gmail.com", "arnavgupta1920@gmail.com", "aryandynamo9@gmail.com", "aryankumar973@gmail.com", "ashutosh319kumar@gmail.com", "asiftair07@gmail.com", "atifmandu@yahoo.co.in", "avikadubey124@gmail.com", "awaisansari845@gmail.com" ], "unique_phones": [ "0000000000", "6006213273", "6006740709", "6201912992", "6280163296", "6281918829", "6289117196", "6359336999", "6361960324", "6376779398", "6387536990", "6387763006", "6599695632", "6909199397", "7000746396", "7002207073", "7002411274", "7002476460", "7002649921", "7004674852", "7006632138", "7017730017", "7022277762", "7045120199", "7051717560", "7075772029", "7085184558", "7093746845", "7203925377", "7204503643", "7217644767", "7228018855", "7259159508", "7310733316", "7353469367", "7385450504", "7404444375", "7406646909", "7409792531", "7411478561", "7447044171", "7477335781", "7488847536", "7503396947", "7504729725", "7507799323", "7507997972", "7600044475", "7619180686", "7664865562" ], "recent_bookings": [ { "id": "1246", "order_ref": "TBF_DDE54725_1783954804", "pnr": null, "airline_name": "Indigo", "flight_number": "6801", "origin": "BLR", "destination": "PAT", "departure_time": "2026-07-24 08:25:00", "payment_status": "created", "ticket_status": "Booking Pending Confirmation", "contact_email": "snjvkmr0009@gmail.com", "contact_phone": "7217644767", "fare_total": "7756.00", "created_at": "2026-07-13 20:30:04" }, { "id": "1245", "order_ref": "TBF_04EA798A_1783887562", "pnr": null, "airline_name": "Indigo", "flight_number": "5237", "origin": "BLR", "destination": "GOP", "departure_time": "2026-07-21 10:15:00", "payment_status": "created", "ticket_status": "Booking Pending Confirmation", "contact_email": "aaditya@gmail.com", "contact_phone": "9140572853", "fare_total": "6950.00", "created_at": "2026-07-13 01:49:22" }, { "id": "1244", "order_ref": "TBF_9A5CA506_1783886174", "pnr": "PENDING", "airline_name": "Air India Express", "flight_number": "2963", "origin": "IXA", "destination": "BOM", "departure_time": "2026-07-22 14:15:00", "payment_status": "paid", "ticket_status": "Booking Failed", "contact_email": "mabdulfattah90@gmail.com", "contact_phone": "7085184558", "fare_total": "8176.00", "created_at": "2026-07-13 01:26:14" }, { "id": "1243", "order_ref": "TBF_DAF304E7_1783882125", "pnr": null, "airline_name": "Air India Express", "flight_number": "2963", "origin": "IXA", "destination": "BOM", "departure_time": "2026-07-22 14:15:00", "payment_status": "created", "ticket_status": "Booking Pending Confirmation", "contact_email": "mabdulfattah90@gmail.com", "contact_phone": "7085184558", "fare_total": "8176.00", "created_at": "2026-07-13 00:18:45" }, { "id": "1242", "order_ref": "TBF_E53F06A1_1783881618", "pnr": null, "airline_name": "Air India Express", "flight_number": "2963", "origin": "IXA", "destination": "BOM", "departure_time": "2026-07-22 14:15:00", "payment_status": "created", "ticket_status": "Booking Pending Confirmation", "contact_email": "mabdulfattah90@gmail.com", "contact_phone": "7085184558", "fare_total": "8176.00", "created_at": "2026-07-13 00:10:18" }, { "id": "1241", "order_ref": "TBF_4BEC6448_1783881557", "pnr": null, "airline_name": "Air India Express", "flight_number": "2963", "origin": "IXA", "destination": "BOM", "departure_time": "2026-07-22 14:15:00", "payment_status": "created", "ticket_status": "Booking Pending Confirmation", "contact_email": "mabdulfattah90@gmail.com", "contact_phone": "7085184558", "fare_total": "8176.00", "created_at": "2026-07-13 00:09:17" }, { "id": "1240", "order_ref": "TBF_22171A4A_1783876723_IB", "pnr": null, "airline_name": "Indigo", "flight_number": "2137", "origin": "SXR", "destination": "DEL", "departure_time": "2026-07-18 11:55:00", "payment_status": "created", "ticket_status": "Booking Pending Confirmation", "contact_email": "sakendarhussain4@gmail.com", "contact_phone": "7051717560", "fare_total": "0.00", "created_at": "2026-07-12 22:48:43" }, { "id": "1239", "order_ref": "TBF_22171A4A_1783876723", "pnr": null, "airline_name": "Air India", "flight_number": "1799", "origin": "DEL", "destination": "SXR", "departure_time": "2026-07-14 06:40:00", "payment_status": "created", "ticket_status": "Booking Pending Confirmation", "contact_email": "sakendarhussain4@gmail.com", "contact_phone": "7051717560", "fare_total": "14374.00", "created_at": "2026-07-12 22:48:43" }, { "id": "1238", "order_ref": "TBF_A8D374CD_1783848513", "pnr": null, "airline_name": "Indigo", "flight_number": "5237", "origin": "BLR", "destination": "GOP", "departure_time": "2026-07-21 10:15:00", "payment_status": "created", "ticket_status": "Booking Pending Confirmation", "contact_email": "aadityashukla409@gmail.com", "contact_phone": "9140572382", "fare_total": "6950.00", "created_at": "2026-07-12 14:58:33" }, { "id": "1237", "order_ref": "TBF_12FB958B_1783841494", "pnr": null, "airline_name": "Air India Express", "flight_number": "2963", "origin": "IXA", "destination": "BOM", "departure_time": "2026-07-22 14:15:00", "payment_status": "created", "ticket_status": "Booking Pending Confirmation", "contact_email": "mabdulfattah90@gmail.com", "contact_phone": "7085184558", "fare_total": "8176.00", "created_at": "2026-07-12 13:01:34" }, { "id": "1236", "order_ref": "TBF_CBD35593_1783801356", "pnr": null, "airline_name": "Indigo", "flight_number": "5237", "origin": "BLR", "destination": "GOP", "departure_time": "2026-07-21 10:15:00", "payment_status": "created", "ticket_status": "Booking Pending Confirmation", "contact_email": "aadfkk@gmail.com", "contact_phone": "9858695847", "fare_total": "6950.00", "created_at": "2026-07-12 01:52:37" }, { "id": "1235", "order_ref": "TBF_7C0FDD04_1783774192", "pnr": "PENDING", "airline_name": "Indigo", "flight_number": "749", "origin": "GAU", "destination": "JAI", "departure_time": "2026-07-21 17:55:00", "payment_status": "paid", "ticket_status": "Booking Failed", "contact_email": "archieajay115@gmail.com", "contact_phone": "7002207073", "fare_total": "6648.00", "created_at": "2026-07-11 18:19:52" }, { "id": "1234", "order_ref": "TBF_11496D70_1783773759", "pnr": null, "airline_name": "Indigo", "flight_number": "749", "origin": "GAU", "destination": "JAI", "departure_time": "2026-07-21 17:55:00", "payment_status": "created", "ticket_status": "Booking Pending Confirmation", "contact_email": "rishabhjainrokstar@gmail.com", "contact_phone": "7002207073", "fare_total": "6648.00", "created_at": "2026-07-11 18:12:40" }, { "id": "1233", "order_ref": "TBF_24A4A9F7_1783748063", "pnr": null, "airline_name": "Singapore Airlines", "flight_number": "421", "origin": "BOM", "destination": "CHC", "departure_time": "2026-11-04 11:50:00", "payment_status": "created", "ticket_status": "Booking Pending Confirmation", "contact_email": "pce.sachin@gmail.com", "contact_phone": "9004545025", "fare_total": "337004.00", "created_at": "2026-07-11 11:04:23" }, { "id": "1232", "order_ref": "TBF_6D85BC2E_1783702053_IB", "pnr": null, "airline_name": "Air India Express", "flight_number": "1561", "origin": "DEL", "destination": "DIB", "departure_time": "2026-07-16 11:30:00", "payment_status": "created", "ticket_status": "Booking Pending Confirmation", "contact_email": "agrimborgohain@gmail.com", "contact_phone": "7002411274", "fare_total": "0.00", "created_at": "2026-07-10 22:17:34" }, { "id": "1231", "order_ref": "TBF_6D85BC2E_1783702053", "pnr": null, "airline_name": "Air India Express", "flight_number": "1547", "origin": "DIB", "destination": "DEL", "departure_time": "2026-07-13 16:50:00", "payment_status": "created", "ticket_status": "Booking Pending Confirmation", "contact_email": "agrimborgohain@gmail.com", "contact_phone": "7002411274", "fare_total": "59130.00", "created_at": "2026-07-10 22:17:34" }, { "id": "1230", "order_ref": "TBF_6A61763B_1783693295", "pnr": "PENDING", "airline_name": "Indigo", "flight_number": "6220", "origin": "DEL", "destination": "BDQ", "departure_time": "2026-07-11 06:40:00", "payment_status": "paid", "ticket_status": "Booking Failed", "contact_email": "HASNAINGOVANI05@GMAIL.COM", "contact_phone": "8780999714", "fare_total": "6878.00", "created_at": "2026-07-10 19:51:36" }, { "id": "1229", "order_ref": "TBF_CE5EC66F_1783693065", "pnr": null, "airline_name": "Indigo", "flight_number": "5014", "origin": "DEL", "destination": "BDQ", "departure_time": "2026-07-11 18:30:00", "payment_status": "created", "ticket_status": "Booking Pending Confirmation", "contact_email": "HASNAINGOVANI05@GMAIL.COM", "contact_phone": "8780999714", "fare_total": "6878.00", "created_at": "2026-07-10 19:47:45" }, { "id": "1228", "order_ref": "TBF_9E4A7F88_1783661749_IB", "pnr": null, "airline_name": "Indigo", "flight_number": "445", "origin": "IXB", "destination": "BLR", "departure_time": "2026-08-09 11:40:00", "payment_status": "created", "ticket_status": "Ticketing In Progress", "contact_email": "thrupthi.s@bt.com", "contact_phone": "8861365942", "fare_total": "0.00", "created_at": "2026-07-10 11:05:49" }, { "id": "1227", "order_ref": "TBF_9E4A7F88_1783661749", "pnr": null, "airline_name": "Air India Express", "flight_number": "2461", "origin": "BLR", "destination": "IXB", "departure_time": "2026-08-04 05:50:00", "payment_status": "created", "ticket_status": "Ticketing In Progress", "contact_email": "thrupthi.s@bt.com", "contact_phone": "8861365942", "fare_total": "17888.00", "created_at": "2026-07-10 11:05:49" } ], "excluded_by_filter": [ { "id": "383", "order_ref": "TBF-TEST-001", "payment_status": "pending", "ticket_status": "Ticketing In Progress", "contact_email": "test@example.com", "created_at": "2026-05-30 00:09:19" } ], "table_columns": [ "id", "order_ref", "rzp_order_id", "rzp_payment_id", "rzp_signature", "payment_amount", "payment_status", "trace_id", "result_index", "is_lcc", "adivaha_booking_id", "pnr", "return_pnr", "ticket_status", "offline_booking", "offline_message", "airline_code", "airline_name", "flight_number", "origin", "destination", "departure_time", "arrival_time", "trip_type", "is_domestic", "fare_total", "lead_pax_name", "contact_email", "contact_phone", "customer_ip", "fraud_risk_score", "fraud_hold", "fraud_review_status", "passenger_count", "passenger_data", "booking_payload", "formatted_passengers", "book_response", "ticket_response", "details_response", "poll_count", "last_polled_at", "created_at", "updated_at", "email_sent" ] }