- Joined
- Jun 14, 2024
- Messages
- 2,617
- Reaction score
- 31,198
- Points
- 113
- Thread Author
- #1
Nerasolgh.com
Nerasolgh.com 300k
date: 08/2024
format: csv and json
all customers: 293294
all ussd_transactions_dump: 1357155
sample:
Code:
INSERT INTO iwms_new6959644''-0.0160964''ACC154754'5868'2019-09-07 13:36:06''2022-03-04 15:52:02''96''DELIGHT FATI''HLORKA''GB - 002 - 4085''n''$2y$10$UxwxoilffcDRyr4e4Txo6.PzdmDa4v0byT.1DB.6d4HeqLsg7HhDm''Y''Y''2021-06-04 06:44:43''92493321060411''2021-05''20240119.133717.926988'70.'20240119.133717.926988'),
'11000015''OBENG OPHELIA''Active''0541668432''OBENG OPHELIA''0541668432'6880771''-0.0172327''ACC154754'5868'2019-09-07 13:48:38''2022-03-04 15:52:02''11''Female''OPHELIA''OBENG''n''$2y$10$UxwxoilffcDRyr4e4Txo6.PzdmDa4v0byT.1DB.6d4HeqLsg7HhDm''Y''Y''2023-12-06 13:18:22''18995023120611''2023-11''20240119.133718.038198'''445.'20240119.133718.038198'),
'11000016''ADDO WINIFRED''Active''0246217449''Nouvelle Street''ADDO WINIFRED''0246217449'6959644''-0.0160963''ACC154754'5868'2019-09-07 13:56:30''2022-03-04 15:52:03''11''Female''WINIFRED''ADDO''GB - 002 - 3084''n''$2y$10$UxwxoilffcDRyr4e4Txo6.PzdmDa4v0byT.1DB.6d4HeqLsg7HhDm''Y''Y''2023-12-06 13:18:22''30102223120611''2023-11''20240119.133718.164364''''20240119.133718.164364');
'11000017''AYONGO GEORGINA''Active''0201310186''Nouvelle Street''AYONGO GEORGINA''0201310186'6959633''-0.0160967''ACC154754'5868'2019-09-07 14:09:08''2022-03-04 15:52:03''11''Female''GEORGINA''AYONGO''n''$2y$10$UxwxoilffcDRyr4e4Txo6.PzdmDa4v0byT.1DB.6d4HeqLsg7HhDm''Y''Y''2023-12-06 13:18:22''24073223120611''2023-11''20240119.133718.259669'380.'20240119.133718.259669'),
'11000018'' NOUVELL SCHOOL COMPLEX''C''Active'[email protected]'0241455086''0243577952''INST/203 ASH''NOUVELL SCHOOL COMPLEX''0241455086'[email protected]''-0.0173646''ACC154754'1982'2019-09-07 14:29:08''2022-09-19 17:57:39''11''Male'55.'NOUVELL SCHOOL COMPLEX''n''$2y$10$UxwxoilffcDRyr4e4Txo6.PzdmDa4v0byT.1DB.6d4HeqLsg7HhDm''Y''Y''2024-08-05 19:46:35''17292924080511''2024-07''20240119.133718.373623'''3390.'20240805.194635.037267'),
'11000019''MAWUSI KRAPAH ANTHONIA''Active''0244655144''# 5 Bougainvillea Street''MAWUSI KRAPAH ANTHONIA''0244655144'6908714''-0.0157385''ACC154754'5868'2019-09-07 15:10:27''2022-03-04 15:52:05''11''Female''ANTHONIA''MAWUSI''KRAPAH''n''$2y$10$UxwxoilffcDRyr4e4Txo6.PzdmDa4v0byT.1DB.6d4HeqLsg7HhDm''Y''Y''2023-12-06 13:18:22''12390323120611''2023-11''20240119.133718.453300'875.'20240119.133718.453300'),
'11000020''BORKOR GLORIA''Active''0248246339''# 39 Aseidu St''BORKOR GLORIA''0248246339'6880771''-0.0172327''ACC154754'5868'2019-09-07 15:27:54''2022-03-04 15:52:05''11''Female''GLORIA''BORKOR''GB - 001 - 4179''n''$2y$10$UxwxoilffcDRyr4e4Txo6.PzdmDa4v0byT.1DB.6d4HeqLsg7HhDm''Y''Y''2023-12-06 13:18:22''63189223120611''2023-11''20240119.133718.575389''',-1220.'20240808.202258.053078'),
'11000021''KOFI TETTEH''Active''0540760392''KOFI TETTEH''0540760392'6878738''-0.0176284''ACC154754'5868'2019-09-07 15:46:36''2022-03-04 15:52:06''11''Male''TETTEH''KOFI''n''$2y$10$UxwxoilffcDRyr4e4Txo6.PzdmDa4v0byT.1DB.6d4HeqLsg7HhDm''Y''Y''2023-12-06 13:18:22''37248023120611''2023-11''20240119.133718.693009'''390.'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":3.
"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":9.
"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":2.
"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":3.
"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
},