INSERT INTO `openagreementconsumers` (`id`, `owner_unique_id`, `consumer_hash`, `device_ip`, `owner_full_name`, `owner_guardian_name`, `owner_guardian_contact`, `owner_guardian_email`, `owner_guardian_aadhar`, `owner_guardian_father_name`, `owner_guardian_pan`, `owner_guardian_service_id`, `owner_guardian_aadhar_address`, `guardian_occupation`, `owner_occupation`, `owner_permanent_address`, `correspondance_address`, `owner_alternate_email`, `owner_pin`, `correspondance_pin`, `owner_image`, `owner_mobile`, `owner_email`, `owner_dob`, `owner_aadhar_card`, `owner_pan_card`, `owner_aadhar_card_front_side`, `owner_aadhar_card_back_side`, `owner_pan_card_front_side`, `owner_service_id_image`, `is_active`, `is_delete`, `consumer_type`, `job_type`, `owner_service_id`, `is_court_check_pass`, `with_copartner`, `copartner_relationship_status`, `host_type`, `host_invited_by`, `court_check_rec_certificate_file`, `final_agreement_rec_file`, `owner_property_society_id`, `owner_property_society_name`, `owner_property_block_name`, `owner_property_apartment_name`, `owner_property_flat_name`, `owner_property_address`, `owner_property_pin`, `property_type`, `property_structure`, `size_property`, `parking_address`, `floor_no`, `furnishing_status`, `rental_amount`, `rental_amount_word`, `security_money`, `security_money_word`, `maintenance_charge`, `rental_amount_increase`, `agreement_start_date`, `period_accomodation`, `expire_agreement`, `lock_in_period_month`, `termination_period_month`, `rental_occupant_full_name`, `rental_occupant_guardian_name`, `rental_occupant_address`, `rental_occupant_pin`, `rental_occupant_dob`, `rental_occupant_mobile`, `rental_occupant_email`, `rental_occupant_aadhar`, `rental_occupant_pan_card_no`, `rental_occupant_aadhar_back`, `rental_occupant_aadhar_front`, `rental_occupant_pan`, `rental_occupant_profile_image`, `rental_occupant_service_id`, `rental_occupant_job_type`, `rental_occupant_guardian_occupation`, `rental_occupant_guardian_address`, `rental_occupant_guardian_aadhar`, `rental_occupant_guardian_pan`, `rental_occupant_guardian_service_id`, `rental_occupant_guardian_email`, `rental_occupant_guardian_mobile`, `ps_id`, `agreement_clause`, `created_at`, `updated_at`) VALUES
(220, '#OPNAG-OW-00000206', '$2y$10$39XPbjMBTNYuJhgB1/ic9uku/0wF0XiAIe1FLkn4MOantRb0hPgMm', '157.40.212.109', 'Abdus Samad Sarkar', 'Late Abdul Gafur Sarkar', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'Ward no 17,Chakbhabani,College Para,Balurghat,Dakshin Dinajpur,West Bengal,733101', NULL, '', '700135', NULL, NULL, '9733124655', 'mostanali04@gmail.com', '1960-03-13', '497122926505', NULL, 0x[encoded data, 14902 characters], '', NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'y', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'K', 'K45', 'K/45/1302', 'K45/1302,SP Sukhobrishti,New Town,Kolkata,700135', '700135', 'f', '2', '620', 'No', '13', 'f', 16000, 'Sixteen Thousand ', 32000, 'Thirty Two Thousand ', 0.00, 10, '2023-10-06', 11, '2024-09-05', 6, 2, 'Ashish Das', 'Madhu Sudan', '559, road no 5, magadh colony, chandauti, Gaya,Gaya,Bihar,823001', '823001', '1995-09-13', '7782036693', 'ashish.das131995@gmail.com', '928667334342', 'BVXPD1026Q', '', 0x[encoded data, 9390 characters], 0x[encoded data, 14558 characters], 0x[encoded data, 20414 characters], 'TCS/EP2023RA2605308', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '2023-10-07 01:01:08', '2023-10-07 01:17:37');
INSERT INTO `openagreementconsumers` (`id`, `owner_unique_id`, `consumer_hash`, `device_ip`, `owner_full_name`, `owner_guardian_name`, `owner_guardian_contact`, `owner_guardian_email`, `owner_guardian_aadhar`, `owner_guardian_father_name`, `owner_guardian_pan`, `owner_guardian_service_id`, `owner_guardian_aadhar_address`, `guardian_occupation`, `owner_occupation`, `owner_permanent_address`, `correspondance_address`, `owner_alternate_email`, `owner_pin`, `correspondance_pin`, `owner_image`, `owner_mobile`, `owner_email`, `owner_dob`, `owner_aadhar_card`, `owner_pan_card`, `owner_aadhar_card_front_side`, `owner_aadhar_card_back_side`, `owner_pan_card_front_side`, `owner_service_id_image`, `is_active`, `is_delete`, `consumer_type`, `job_type`, `owner_service_id`, `is_court_check_pass`, `with_copartner`, `copartner_relationship_status`, `host_type`, `host_invited_by`, `court_check_rec_certificate_file`, `final_agreement_rec_file`, `owner_property_society_id`, `owner_property_society_name`, `owner_property_block_name`, `owner_property_apartment_name`, `owner_property_flat_name`, `owner_property_address`, `owner_property_pin`, `property_type`, `property_structure`, `size_property`, `parking_address`, `floor_no`, `furnishing_status`, `rental_amount`, `rental_amount_word`, `security_money`, `security_money_word`, `maintenance_charge`, `rental_amount_increase`, `agreement_start_date`, `period_accomodation`, `expire_agreement`, `lock_in_period_month`, `termination_period_month`, `rental_occupant_full_name`, `rental_occupant_guardian_name`, `rental_occupant_address`, `rental_occupant_pin`, `rental_occupant_dob`, `rental_occupant_mobile`, `rental_occupant_email`, `rental_occupant_aadhar`, `rental_occupant_pan_card_no`, `rental_occupant_aadhar_back`, `rental_occupant_aadhar_front`, `rental_occupant_pan`, `rental_occupant_profile_image`, `rental_occupant_service_id`, `rental_occupant_job_type`, `rental_occupant_guardian_occupation`, `rental_occupant_guardian_address`, `rental_occupant_guardian_aadhar`, `rental_occupant_guardian_pan`, `rental_occupant_guardian_service_id`, `rental_occupant_guardian_email`, `rental_occupant_guardian_mobile`, `ps_id`, `agreement_clause`, `created_at`, `updated_at`) VALUES
(221, '#OPNAG-OW-00000207', '$2y$10$frP9GYB/Dn00B6Wv8gAiBOSU3rQRstvMvznnjMKAJZYXVqKrxSZtC', '106.212.85.230', 'Chhaya Biswas', 'Late Harendranath Biswas', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'Ghat Lane, Kumorpara, Krishnanagar, Ghumi, Nadia, West Bengal', NULL, 'dkmondal610@gmail.com', '741103', NULL, NULL, '7278483897', 'sanjoy.dop@gmail.com', '1949-01-01', '726885600980', NULL, '', '', NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'B', 'B176', 'B176/103', 'B176/103 SP Sukhobristhi Newtown Kolkata 700135', '700135', 'f', '1', '320', 'S3', '1', 'f', 7000, '', 14000, '', 8552.00, 10, '2023-10-01', 11, '2024-08-31', 6, 1, 'Ritesh Karmakar', 'Shankar Karmakar', '220, Kalpanapuri Colony, Near Hill, PO - Adityapur, Seraikel-Kharsawan, Jharkhand 831013', '831013', '1989-08-21', '8797876284', 'karmakar.ritesh@gmail.com', '407225031760', 'BKVPK2376P', 0x[encoded data, 16126 characters], 0x[encoded data, 16262 characters], 0x[encoded data, 15366 characters], 0x[encoded data, 18926 characters], 'Service', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '2023-10-07 19:25:00', '2023-10-07 19:37:06');
INSERT INTO `openagreementconsumers` (`id`, `owner_unique_id`, `consumer_hash`, `device_ip`, `owner_full_name`, `owner_guardian_name`, `owner_guardian_contact`, `owner_guardian_email`, `owner_guardian_aadhar`, `owner_guardian_father_name`, `owner_guardian_pan`, `owner_guardian_service_id`, `owner_guardian_aadhar_address`, `guardian_occupation`, `owner_occupation`, `owner_permanent_address`, `correspondance_address`, `owner_alternate_email`, `owner_pin`, `correspondance_pin`, `owner_image`, `owner_mobile`, `owner_email`, `owner_dob`, `owner_aadhar_card`, `owner_pan_card`, `owner_aadhar_card_front_side`, `owner_aadhar_card_back_side`, `owner_pan_card_front_side`, `owner_service_id_image`, `is_active`, `is_delete`, `consumer_type`, `job_type`, `owner_service_id`, `is_court_check_pass`, `with_copartner`, `copartner_relationship_status`, `host_type`, `host_invited_by`, `court_check_rec_certificate_file`, `final_agreement_rec_file`, `owner_property_society_id`, `owner_property_society_name`, `owner_property_block_name`, `owner_property_apartment_name`, `owner_property_flat_name`, `owner_property_address`, `owner_property_pin`, `property_type`, `property_structure`, `size_property`, `parking_address`, `floor_no`, `furnishing_status`, `rental_amount`, `rental_amount_word`, `security_money`, `security_money_word`, `maintenance_charge`, `rental_amount_increase`, `agreement_start_date`, `period_accomodation`, `expire_agreement`, `lock_in_period_month`, `termination_period_month`, `rental_occupant_full_name`, `rental_occupant_guardian_name`, `rental_occupant_address`, `rental_occupant_pin`, `rental_occupant_dob`, `rental_occupant_mobile`, `rental_occupant_email`, `rental_occupant_aadhar`, `rental_occupant_pan_card_no`, `rental_occupant_aadhar_back`, `rental_occupant_aadhar_front`, `rental_occupant_pan`, `rental_occupant_profile_image`, `rental_occupant_service_id`, `rental_occupant_job_type`, `rental_occupant_guardian_occupation`, `rental_occupant_guardian_address`, `rental_occupant_guardian_aadhar`, `rental_occupant_guardian_pan`, `rental_occupant_guardian_service_id`, `rental_occupant_guardian_email`, `rental_occupant_guardian_mobile`, `ps_id`, `agreement_clause`, `created_at`, `updated_at`) VALUES
(222, '#OPNAG-OW-00000208', '$2y$10$YJDnZQ7.AqBb2dEAY1MtuuHI8XVK5AMY7niN6//oTQHKErICla1ZW', '157.40.239.119', 'UMMA BIBI', 'Jalil Molla', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'Chakpachuria, baligori, North 24 parganas 700156', NULL, '', '700135', NULL, NULL, '8017435527', 'mostanali04@gmail.com', '1982-01-01', '679942350194', NULL, 0x[encoded data, 13518 characters], '', NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'B', 'B122', 'B122/104', 'B122/104 sp shukhobrishty shapoorji New Town Kolkata West Bengal 700135', '700135', 'f', '1', '425', 'No', '1', 'f', 13000, 'Thirteen Thousand ', 26000, 'Twenty Six Thousand ', 0.00, 10, '2023-10-12', 11, '2024-09-11', 6, 2, 'Tanishq Dasgupta ', 'Abhijit Dasgupta ', 'Word no 12 Road no 2 opp sbi branch sadar agartala west tripura 799002', '799002', '2004-08-15', '8257094712', 'tanishq12131415@gmail.com', '805000240191', 'FHBPD9491K', 0x[encoded data, 18870 characters], 0x[encoded data, 17182 characters], 0x[encoded data, 16270 characters], 0x[encoded data, 13814 characters], 'A91005223244', 's', 'Business', 'Word no 12 Road no 2 opp sbi branch sadar agartala west tripura 799002', '896082645114', 'AGSPD3134G', 'NA', 'abhijit.adg69@gmail.com', '7005571851', NULL, '', '2023-10-07 19:30:02', '2023-10-07 20:05:08');
INSERT INTO `openagreementconsumers` (`id`, `owner_unique_id`, `consumer_hash`, `device_ip`, `owner_full_name`, `owner_guardian_name`, `owner_guardian_contact`, `owner_guardian_email`, `owner_guardian_aadhar`, `owner_guardian_father_name`, `owner_guardian_pan`, `owner_guardian_service_id`, `owner_guardian_aadhar_address`, `guardian_occupation`, `owner_occupation`, `owner_permanent_address`, `correspondance_address`, `owner_alternate_email`, `owner_pin`, `correspondance_pin`, `owner_image`, `owner_mobile`, `owner_email`, `owner_dob`, `owner_aadhar_card`, `owner_pan_card`, `owner_aadhar_card_front_side`, `owner_aadhar_card_back_side`, `owner_pan_card_front_side`, `owner_service_id_image`, `is_active`, `is_delete`, `consumer_type`, `job_type`, `owner_service_id`, `is_court_check_pass`, `with_copartner`, `copartner_relationship_status`, `host_type`, `host_invited_by`, `court_check_rec_certificate_file`, `final_agreement_rec_file`, `owner_property_society_id`, `owner_property_society_name`, `owner_property_block_name`, `owner_property_apartment_name`, `owner_property_flat_name`, `owner_property_address`, `owner_property_pin`, `property_type`, `property_structure`, `size_property`, `parking_address`, `floor_no`, `furnishing_status`, `rental_amount`, `rental_amount_word`, `security_money`, `security_money_word`, `maintenance_charge`, `rental_amount_increase`, `agreement_start_date`, `period_accomodation`, `expire_agreement`, `lock_in_period_month`, `termination_period_month`, `rental_occupant_full_name`, `rental_occupant_guardian_name`, `rental_occupant_address`, `rental_occupant_pin`, `rental_occupant_dob`, `rental_occupant_mobile`, `rental_occupant_email`, `rental_occupant_aadhar`, `rental_occupant_pan_card_no`, `rental_occupant_aadhar_back`, `rental_occupant_aadhar_front`, `rental_occupant_pan`, `rental_occupant_profile_image`, `rental_occupant_service_id`, `rental_occupant_job_type`, `rental_occupant_guardian_occupation`, `rental_occupant_guardian_address`, `rental_occupant_guardian_aadhar`, `rental_occupant_guardian_pan`, `rental_occupant_guardian_service_id`, `rental_occupant_guardian_email`, `rental_occupant_guardian_mobile`, `ps_id`, `agreement_clause`, `created_at`, `updated_at`) VALUES
(224, '#OPNAG-OW-00000209', '$2y$10$UQZDk/PxbkjXWcPL7hWSxuT7cpuI6dv1h040iJqIj0cmg/.cLP3o2', '45.250.247.195', 'Arindam ghosh', 'Biswanath ghosh', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', 'Paisara. Kapsit, Hooghly, 712-613 West Bengal', NULL, '', '712613', NULL, NULL, '9735556178', 'arindam.ghosh14@yahoo.com', '1987-04-14', '731627024151', NULL, 0x[encoded data, 18006 characters], 0x[encoded data, 19030 characters], NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'n', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'D', '298', '204', 'D-298/204, Shapporji sukhobriti, action area 3 ', '700135', 'f', '1', '320', 'yes', '2', 'f', 9000, 'Nine Thousand ', 17000, 'Seventeen Thousand ', 0.00, 10, '2023-10-01', 11, '2024-08-31', 1, 1, 'Sourav roy', 'Bijoy Krishna roy', 'G-1/485a and 486. Dall mill road Uttam Nagar west Delhi 110059', '110059', '1988-11-25', '9958690108', 'roytan.sourav25@gmail.com', '426046201492', 'Avopr5280l', 0x[encoded data, 17750 characters], 0x[encoded data, 18062 characters], 0x[encoded data, 15302 characters], 0x[encoded data, 13486 characters], 'BT57191', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '2023-10-09 02:13:03', '2023-10-09 02:33:22');
INSERT INTO `openagreementconsumers` (`id`, `owner_unique_id`, `consumer_hash`, `device_ip`, `owner_full_name`, `owner_guardian_name`, `owner_guardian_contact`, `owner_guardian_email`, `owner_guardian_aadhar`, `owner_guardian_father_name`, `owner_guardian_pan`, `owner_guardian_service_id`, `owner_guardian_aadhar_address`, `guardian_occupation`, `owner_occupation`, `owner_permanent_address`, `correspondance_address`, `owner_alternate_email`, `owner_pin`, `correspondance_pin`, `owner_image`, `owner_mobile`, `owner_email`, `owner_dob`, `owner_aadhar_card`, `owner_pan_card`, `owner_aadhar_card_front_side`, `owner_aadhar_card_back_side`, `owner_pan_card_front_side`, `owner_service_id_image`, `is_active`, `is_delete`, `consumer_type`, `job_type`, `owner_service_id`, `is_court_check_pass`, `with_copartner`, `copartner_relationship_status`, `host_type`, `host_invited_by`, `court_check_rec_certificate_file`, `final_agreement_rec_file`, `owner_property_society_id`, `owner_property_society_name`, `owner_property_block_name`, `owner_property_apartment_name`, `owner_property_flat_name`, `owner_property_address`, `owner_property_pin`, `property_type`, `property_structure`, `size_property`, `parking_address`, `floor_no`, `furnishing_status`, `rental_amount`, `rental_amount_word`, `security_money`, `security_money_word`, `maintenance_charge`, `rental_amount_increase`, `agreement_start_date`, `period_accomodation`, `expire_agreement`, `lock_in_period_month`, `termination_period_month`, `rental_occupant_full_name`, `rental_occupant_guardian_name`, `rental_occupant_address`, `rental_occupant_pin`, `rental_occupant_dob`, `rental_occupant_mobile`, `rental_occupant_email`, `rental_occupant_aadhar`, `rental_occupant_pan_card_no`, `rental_occupant_aadhar_back`, `rental_occupant_aadhar_front`, `rental_occupant_pan`, `rental_occupant_profile_image`, `rental_occupant_service_id`, `rental_occupant_job_type`, `rental_occupant_guardian_occupation`, `rental_occupant_guardian_address`, `rental_occupant_guardian_aadhar`, `rental_occupant_guardian_pan`, `rental_occupant_guardian_service_id`, `rental_occupant_guardian_email`, `rental_occupant_guardian_mobile`, `ps_id`, `agreement_clause`, `created_at`, `updated_at`) VALUES
(225, '#OPNAG-OW-00000210', '$2y$10$nsCByEVhOZJrhexZRWIY0u7ZYXlJWcdo8ePBNS68eEAfmmYWn11KG', '152.58.183.236', 'Narayan prasad', 'Late Rup Narayana prasad', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'j', '32 Raja Ram Mohan Ray sarani, Near Amherst Street post office, Kolkata, West Bengal,700009', NULL, '', '700009', NULL, NULL, '9903212765', 'narayan121977@gmail.com', '1977-12-25', '366762925269', NULL, 0x[encoded data, 8998 characters], 0x[encoded data, 14398 characters], NULL, NULL, 'y', 'n', 8, NULL, NULL, 'n', 'y', 'f', NULL, NULL, NULL, NULL, 1, 'SP Sukhobrishti Housing Complex', 'K ', 'K30', 'K30/1106', 'K30/1106, Sp Sukhobristi, Newtown Kolkata, 700135', '700135', 'f', '3', '898', 'No', '11', 'f', 16500, '', 33000, '', 0.00, 0, '2023-10-03', 11, '2024-09-02', 6, 1, 'Hrishi Raj', 'Shiv Shankar Prasad ', 'hn 203, B block Akansha enclave, Chutia, Chunna bhatta, Ranchi, 834001', '834001', '2000-12-30', '7077918142', 'rhrishi92@gmail.com', '530862534907', 'ELOPR8895H', 0x[encoded data, 12998 characters], 0x[encoded data, 8662 characters], 0x[encoded data, 12534 characters], 0x[encoded data, 19222 characters], '934395', 'j', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '2023-10-09 22:57:11', '2023-10-09 23:12:16');
