Nerasolgh.com

Tanaka · 15-08-24, 12:07 AM

Nerasolgh.com 300k

date: 08/2024
format: csv and json
all customers: 293294
all ussd_transactions_dump: 1357155

Hidden Content

You must register or login to view this content.

sample:

INSERT INTO iwms_new.customers (CUSTOMER_ID,CUSTOMER_NAME,CUSTOMER_TYPE,CUSTOMER_STATUS,EMAIL_ADDRESS,PRIMARY_PHONE,SECONDARY_PHONE,HOUSE_NO,STREET_NO,STREET_NAME,SUBURB,LOCATION,POSTAL_ADDRESS,CONTACT_NAME,CONTACT_NUMBER,CONTACT_EMAIL,LATITUDE,LONGITUDE,USER_ID,COMMUNITY_ID,CREATED_ON,UPDATED_ON,DELETED_ON,SERVICE_PROVIDER_CODE,GENDER,OLD_ID,RATE,TOTAL_BINS,BINS_REQUESTED,FIRST_NAME,LAST_NAME,MIDDLE_NAME,DIGITAL_ADDRESS,AREA_ID,PROPERTY_CODE,DELETED_BY,DISCOUNT,TAXABLE,BANK_DETAILS,DEACTIVATED_BY,DEACTIVATED_DATE,COLLECTOR_ID,RESTORE_DATE,password,opt,isVerified,canLogin,is_default_password,last_invoice_date,last_invoice_no,last_invoice_year_month,sys_col1,sys_col2,cust_outst_bal,stm_lastupd) VALUES

 ('11000014','HLORKA  DELIGHT FATI','R','InActive',NULL,'0278676683',NULL,'Nouvelle street',NULL,NULL,NULL,NULL,NULL,'DELIGHT FATI HLORKA','0278676683',NULL,'5.6959644','-0.0160964','ACC154754',5868,'2019-09-07 13:36:06','2022-03-04 15:52:02',NULL,'96',NULL,NULL,NULL,0,NULL,'DELIGHT FATI','HLORKA',NULL,'GB - 002 - 4085',NULL,NULL,NULL,NULL,'n',NULL,NULL,NULL,NULL,NULL,'$2y$10$UxwxoilffcDRyr4e4Txo6.PzdmDa4v0byT.1DB.6d4HeqLsg7HhDm',NULL,NULL,'Y','Y','2021-06-04 06:44:43','92493321060411','2021-05','20240119.133717.926988','InActive',70.00,'20240119.133717.926988'),
     ('11000015','OBENG  OPHELIA','R','Active',NULL,'0541668432',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'OBENG OPHELIA','0541668432',NULL,'5.6880771','-0.0172327','ACC154754',5868,'2019-09-07 13:48:38','2022-03-04 15:52:02',NULL,'11','Female',NULL,NULL,0,NULL,'OPHELIA','OBENG',NULL,NULL,NULL,NULL,NULL,NULL,'n',NULL,NULL,NULL,NULL,NULL,'$2y$10$UxwxoilffcDRyr4e4Txo6.PzdmDa4v0byT.1DB.6d4HeqLsg7HhDm',NULL,NULL,'Y','Y','2023-12-06 13:18:22','18995023120611','2023-11','20240119.133718.038198','',445.00,'20240119.133718.038198'),
     ('11000016','ADDO  WINIFRED','R','Active',NULL,'0246217449',NULL,'Nouvelle Street',NULL,NULL,NULL,NULL,NULL,'ADDO WINIFRED','0246217449',NULL,'5.6959644','-0.0160963','ACC154754',5868,'2019-09-07 13:56:30','2022-03-04 15:52:03',NULL,'11','Female',NULL,NULL,0,NULL,'WINIFRED','ADDO',NULL,'GB - 002 - 3084',NULL,NULL,NULL,NULL,'n',NULL,NULL,NULL,NULL,NULL,'$2y$10$UxwxoilffcDRyr4e4Txo6.PzdmDa4v0byT.1DB.6d4HeqLsg7HhDm',NULL,NULL,'Y','Y','2023-12-06 13:18:22','30102223120611','2023-11','20240119.133718.164364','',5.00,'20240119.133718.164364');
     ('11000017','AYONGO  GEORGINA','R','Active',NULL,'0201310186',NULL,'Nouvelle Street',NULL,NULL,NULL,NULL,NULL,'AYONGO GEORGINA','0201310186',NULL,'5.6959633','-0.0160967','ACC154754',5868,'2019-09-07 14:09:08','2022-03-04 15:52:03',NULL,'11','Female',NULL,NULL,0,NULL,'GEORGINA','AYONGO',NULL,NULL,NULL,NULL,NULL,NULL,'n',NULL,NULL,NULL,NULL,NULL,'$2y$10$UxwxoilffcDRyr4e4Txo6.PzdmDa4v0byT.1DB.6d4HeqLsg7HhDm',NULL,NULL,'Y','Y','2023-12-06 13:18:22','24073223120611','2023-11','20240119.133718.259669','InActive',380.00,'20240119.133718.259669'),
     ('11000018','  NOUVELL SCHOOL COMPLEX','C','Active','[email protected]','0241455086','0243577952','INST/203 ASH',NULL,NULL,NULL,NULL,NULL,'NOUVELL SCHOOL COMPLEX','0241455086','[email protected]','5.6880094','-0.0173646','ACC154754',1982,'2019-09-07 14:29:08','2022-09-19 17:57:39',NULL,'11','Male',NULL,55.00,0,NULL,'NOUVELL SCHOOL COMPLEX',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'n',NULL,NULL,NULL,NULL,NULL,'$2y$10$UxwxoilffcDRyr4e4Txo6.PzdmDa4v0byT.1DB.6d4HeqLsg7HhDm',NULL,NULL,'Y','Y','2024-08-05 19:46:35','17292924080511','2024-07','20240119.133718.373623','',3390.00,'20240805.194635.037267'),
     ('11000019','MAWUSI KRAPAH ANTHONIA','R','Active',NULL,'0244655144',NULL,'# 5 Bougainvillea Street',NULL,NULL,NULL,NULL,NULL,'MAWUSI KRAPAH ANTHONIA','0244655144',NULL,'5.6908714','-0.0157385','ACC154754',5868,'2019-09-07 15:10:27','2022-03-04 15:52:05',NULL,'11','Female',NULL,NULL,0,NULL,'ANTHONIA','MAWUSI','KRAPAH',NULL,NULL,NULL,NULL,NULL,'n',NULL,NULL,NULL,NULL,NULL,'$2y$10$UxwxoilffcDRyr4e4Txo6.PzdmDa4v0byT.1DB.6d4HeqLsg7HhDm',NULL,NULL,'Y','Y','2023-12-06 13:18:22','12390323120611','2023-11','20240119.133718.453300','InActive',875.00,'20240119.133718.453300'),
     ('11000020','BORKOR  GLORIA','R','Active',NULL,'0248246339',NULL,'# 39 Aseidu St',NULL,NULL,NULL,NULL,NULL,'BORKOR GLORIA','0248246339',NULL,'5.6880771','-0.0172327','ACC154754',5868,'2019-09-07 15:27:54','2022-03-04 15:52:05',NULL,'11','Female',NULL,NULL,0,NULL,'GLORIA','BORKOR',NULL,'GB - 001 - 4179',NULL,NULL,NULL,NULL,'n',NULL,NULL,NULL,NULL,NULL,'$2y$10$UxwxoilffcDRyr4e4Txo6.PzdmDa4v0byT.1DB.6d4HeqLsg7HhDm',NULL,NULL,'Y','Y','2023-12-06 13:18:22','63189223120611','2023-11','20240119.133718.575389','',-1220.00,'20240808.202258.053078'),
     ('11000021','KOFI  TETTEH','R','Active',NULL,'0540760392',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'KOFI TETTEH','0540760392',NULL,'5.6878738','-0.0176284','ACC154754',5868,'2019-09-07 15:46:36','2022-03-04 15:52:06',NULL,'11','Male',NULL,NULL,0,NULL,'TETTEH','KOFI',NULL,NULL,NULL,NULL,NULL,NULL,'n',NULL,NULL,NULL,NULL,NULL,'$2y$10$UxwxoilffcDRyr4e4Txo6.PzdmDa4v0byT.1DB.6d4HeqLsg7HhDm',NULL,NULL,'Y','Y','2023-12-06 13:18:22','37248023120611','2023-11','20240119.133718.693009','',390.00,'20240119.133718.693009'),




{
                "id" : 46,
                "reference" : "e855971f-1d97-4be2-8681-bfc330e2d8d5",
                "createTs" : "2021-01-12 12:54 pm",
                "customerId" : "31012988",
                "customerName" : "ERNEST OFEI AYEH",
                "paymentAmount" : 30.0,
                "msisdn" : "233246406110",
                "mno" : "MTN",
                "primaryPhone" : "0246406110",
                "paymentPhone" : "233246406110",
                "txn_status" : "Success",
                "created_at" : "2021-12-01 12:54:25",
                "updated_at" : "2022-08-24 10:14:33",
                "customer" : null,
                "description" : null,
                "agentCode" : null,
                "server" : null
        },
        {
                "id" : 47,
                "reference" : "bb3035b1-771d-48f1-8ece-50d9cf110def",
                "createTs" : "2021-01-12 12:54 pm",
                "customerId" : "31017744",
                "customerName" : "ELIZABETH  ASIMAH",
                "paymentAmount" : 90.0,
                "msisdn" : "233550826971",
                "mno" : "MTN",
                "primaryPhone" : "0550826971",
                "paymentPhone" : "233550826971",
                "txn_status" : "Success",
                "created_at" : "2021-12-01 12:54:43",
                "updated_at" : "2022-08-24 10:13:37",
                "customer" : null,
                "description" : null,
                "agentCode" : null,
                "server" : null
        },
{
                "id" : 48,
                "reference" : "da49ce36-662e-4643-a2a9-8a277f24c29c",
                "createTs" : "2021-01-12 12:54 pm",
                "customerId" : "31017590",
                "customerName" : "Boateng A. Collins",
                "paymentAmount" : 20.0,
                "msisdn" : "233244448773",
                "mno" : "MTN",
                "primaryPhone" : "0244448773",
                "paymentPhone" : "233244448773",
                "txn_status" : "Pending",
                "created_at" : "2021-12-01 12:54:48",
                "updated_at" : "2021-12-01 12:54:48",
                "customer" : null,
                "description" : null,
                "agentCode" : null,
                "server" : null
        },
        {
                "id" : 49,
                "reference" : "6afc730d-2348-4c91-8526-0682d93f5fdd",
                "createTs" : "2021-01-12 12:54 pm",
                "customerId" : "31018389",
                "customerName" : "Mercy  Ankamah",
                "paymentAmount" : 30.0,
                "msisdn" : "233546574770",
                "mno" : "MTN",
                "primaryPhone" : "0546574770",
                "paymentPhone" : "233546574770",
                "txn_status" : "Success",
                "created_at" : "2021-12-01 12:54:58",
                "updated_at" : "2022-08-24 10:09:47",
                "customer" : null,
                "description" : null,
                "agentCode" : null,
                "server" : null
        },

~~simpleone~~ · 15-08-24, 08:45 AM

thanks for share

deep_down_x2 · 15-08-24, 07:07 PM

Thanks a lot. Appreciate it.

trentxxxl · 16-08-24, 03:29 PM

thanks for the share

ons1njane · 18-08-24, 11:02 AM

thanks for the share bruh

crackymeup · (This post was last modified: 01-10-24, 09:17 AM by crackymeup.)

Thanks a lot. Appreciate it.

Thanks a lot sir. Appreciate it.

ascasca456378ergew · 14-03-25, 09:27 AM

thinks

johi · (This post was last modified: 21-08-26, 07:03 AM by johi.)

great! work

nice work on this

NXSk2Voge · 25-08-26, 08:28 AM

Thank You

~~FancyGrad~~ · 14-09-26, 12:37 PM

love the share tyy