- 373,056 — Person records (168 columns, one row per person)
- 372,220 — Complete identity sets (nationality + KYC doc JSON + both addresses)
- 373,055 — Dates of birth
- 372,494 — Mobile numbers · 372,861 — Emails
- 372,450 — Wallet accounts with balance
- 365,595 — Persons with OTP history · 365,357 — with SMS
- 82,421 — Pinot KYC citizen-ID (NID) numbers
- 76,775 — KYC review decisions
- 36,436 — Bank deposit/withdrawal records
- 34,426 — Merchant orders · 6,388 — QR collection codes
- 27,784 — Credentials (27,400 transaction PINs · 382 bcrypt password hashes · 11 refresh tokens)
- 13,275 — Wallet transactions (incl. counterparty name & mobile)
- 9,524 — Bill payments · 3,245 — saved bills
- 2,266 — Linked cards (2,049 card numbers + holder DOB)
- 2,519 — Split-bill participations
- 1,504 — Payee accounts · 1,469 bank payee accounts
- 23,074 — PEP (politically exposed person) roster entries
Contact: TG https://t.me/ahswd1/ [email protected] sold once. Support the intermediary
Price is 5000$ not negotiable.
- 372,220 — Complete identity sets (nationality + KYC doc JSON + both addresses)
- 373,055 — Dates of birth
- 372,494 — Mobile numbers · 372,861 — Emails
- 372,450 — Wallet accounts with balance
- 365,595 — Persons with OTP history · 365,357 — with SMS
- 82,421 — Pinot KYC citizen-ID (NID) numbers
- 76,775 — KYC review decisions
- 36,436 — Bank deposit/withdrawal records
- 34,426 — Merchant orders · 6,388 — QR collection codes
- 27,784 — Credentials (27,400 transaction PINs · 382 bcrypt password hashes · 11 refresh tokens)
- 13,275 — Wallet transactions (incl. counterparty name & mobile)
- 9,524 — Bill payments · 3,245 — saved bills
- 2,266 — Linked cards (2,049 card numbers + holder DOB)
- 2,519 — Split-bill participations
- 1,504 — Payee accounts · 1,469 bank payee accounts
- 23,074 — PEP (politically exposed person) roster entries
Contact: TG https://t.me/ahswd1/ [email protected] sold once. Support the intermediary
Price is 5000$ not negotiable.
{
"dataset": "Nepal HamroPay / HamroPatro",
"source_dir": "",
"sample_size_per_block": 1,
"note": "Each data block is sampled independently; only columns that are 100% populated across the block sample are kept, so the JSON contains no empty values.",
"files": {
"individual_summary_wide_table": {
"source_file": "个人汇总宽表_01.xlsx",
"total_records": 373056,
"total_columns": 168,
"blocks": {
"01_Identity": {
"columns": [
"AppID",
"Last Name",
"First Name",
"Middle Name",
"Gender",
"Date of Birth",
"Nationality",
"Father's Name",
"Mother's Name",
"Grandfather's Name",
"Marital Status",
"Occupation",
"Mobile",
"Alt Mobile",
"Email",
"Mobile Verified",
"Email Verified",
"KYC Status",
"KYC Verified",
"KYC Status Note",
"User Type",
"Signup Channel",
"User Category",
"KYC Document JSON",
"Permanent Address",
"Temporary Address",
"Avatar",
"Registered At",
"Last Updated"
],
"sample_count": 1,
"rows": [
{
"AppID": "hamropatro",
"Last Name": "Uprety",
"First Name": "Shankar",
"Middle Name": "Raj",
"Gender": "MALE",
"Date of Birth": "1981-09-13 18:30:00.000+0000",
"Nationality": "NEPAL",
"Father's Name": "Uttam Upreti",
"Mother's Name": "Shanti Upreti",
"Grandfather's Name": "Narayan Prasad Upreti",
"Marital Status": "MARRIED",
"Occupation": "Business",
"Mobile": "977-9802336429",
"Alt Mobile": "977-9802336429",
"Email": "[email protected]",
"Mobile Verified": "True",
"Email Verified": "False",
"KYC Status": "VERIFIED",
"KYC Verified": "True",
"KYC Status Note": "Congratulations, your KYC has been verified",
"User Type": "PERSONAL",
"Signup Channel": "MINI_APP",
"User Category": "PERSONAL",
"KYC Document JSON": "{\"document_id\":\"160325824\",\"document_type\":\"CITIZENSHIP\",\"document_back_photo\":\"ae33e0a0-79cf-11ed-8354-0242ac1b0004\",\"document_front_photo\":\"a99c0900-79cf-11ed-8354-0242ac1b0004\",\"issued_date\":939772800000,\"issued_place\":\"Parsa\",\"passport_photo\":\"157231f0-79cf-11ed-8354-0242ac1b0004\"}",
"Permanent Address": "{'district': 'Kathmandu', 'local_body': 'Ram Kumari Marg', 'state': 'Bagmati Province', 'ward': '32', 'zone': '1'}",
"Temporary Address": "{'district': 'Kathmandu', 'local_body': 'Ram Kumari Marg', 'state': 'Bagmati Province', 'ward': '32', 'zone': '1'}",
"Avatar": "157231f0-79cf-11ed-8354-0242ac1b0004",
"Registered At": "2022-09-21 14:55:19.979+0000",
"Last Updated": "2023-09-14 12:39:22.839+0000"
}
]
},
"02_Ledger_Account": {
"columns": [
"AppID",
"Last Name",
"First Name",
"Ledger Accounts (Count)",
"Ledger Balance (Total)",
"Ledger First Opened",
"Ledger Last Updated",
"Ledger KYC Status",
"Ledger Account Name"
],
"sample_count": 1,
"rows": [
{
"AppID": "hamropatro",
"Last Name": "Adhikari",
"First Name": "Mukesh",
"Ledger Accounts (Count)": "1.0",
"Ledger Balance (Total)": "57257.0",
"Ledger First Opened": "2022-09-22 08:39:19",
"Ledger Last Updated": "2025-09-25 11:45:05",
"Ledger KYC Status": "VERIFIED",
"Ledger Account Name": "Mukesh Adhikari"
}
]
},
"03_Ledger_Entries": {
"columns": [
"AppID",
"Last Name",
"First Name",
"Ledger Entries (Count)",
"Ledger Entries Income (Total)",
"Ledger Entries Expense (Total)",
"Latest Ledger Entry Date",
"Latest Ledger Entry Narration"
],
"sample_count": 1,
"rows": [
{
"AppID": "hamropatro",
"Last Name": "Adhikari",
"First Name": "Mukesh",
"Ledger Entries (Count)": "1206.0",
"Ledger Entries Income (Total)": "23922160.0",
"Ledger Entries Expense (Total)": "23864903.0",
"Latest Ledger Entry Date": "2025-09-25 11:45:05",
"Latest Ledger Entry Narration": "Received from Paritosh Bhattarai"
}
]
},
"04_Transactions": {
"columns": [
"AppID",
"Last Name",
"First Name",
"Transactions (Count)",
"Transactions Income (Total)",
"Transactions Expense (Total)",
"Latest Transaction Date",
"Latest Transaction Narration",
"Latest Transaction Category",
"Counterparty Name",
"Counterparty Mobile",
"Latest Counterparty"
],
"sample_count": 1,
"rows": [
{
"AppID": "hamropatro",
"Last Name": "Adhikari",
"First Name": "Mukesh",
"Transactions (Count)": "1526.0",
"Transactions Income (Total)": "35760505.0",
"Transactions Expense (Total)": "35741817.0",
"Latest Transaction Date": "2026-09-23 05:44:21",
"Latest Transaction Narration": "Ncell Topup to 9826937422",
"Latest Transaction Category": "Topup",
"Counterparty Name": "Sagar Siwakoti | Paritosh Bhattarai | Bibek Gautam | Sumesh Gajmer | NTC | Hamro Pay Cashback | Ncell | Deepshan Adhikari | Sifal Burger House | Dipesh Mainali | Ananda Kumar Maharjan | Suhent Bickram Rana",
"Counterparty Mobile": "977-9861448804 | 977-9849708219 | 9843888178 | 977-9843077759 | 977-9841589288 | 9861448804 | 9801075414 | 977-9843888178 | 977-9843391193 | 9803165215 | 977-9808155820 | 977-9812298351",
"Latest Counterparty": "Ncell"
}
]
},
"05_Bank_Transactions": {
"columns": [
"AppID",
"Last Name",
"First Name",
"Bank Transactions (Count)",
"Bank Transactions (Total)",
"Latest Bank Transaction Date",
"Latest Bank Payee",
"Latest Bank Payee Account No.",
"Latest Bank Name",
"Latest Bank Status"
],
"sample_count": 1,
"rows": [
{
"AppID": "hamropatro",
"Last Name": "Adhikari",
"First Name": "Mukesh",
"Bank Transactions (Count)": "606.0",
"Bank Transactions (Total)": "23938248.0",
"Latest Bank Transaction Date": "2025-09-25 11:45:05",
"Latest Bank Payee": "Deepshan Adhikari",
"Latest Bank Payee Account No.": "L-165a01f0-3e1b-11ed-bef8-0242c0a85006",
"Latest Bank Name": "Global SMART PLUS",
"Latest Bank Status": "COMPLETED"
}
]
},
"06_Payee_Accounts": {
"columns": [
"AppID",
"Last Name",
"First Name",
"Payee Accounts (Count)",
"Latest Payee Account No.",
"Latest Payee Account Name",
"Latest Payee Bound At",
"Bank Payee Accounts (Count)",
"Latest Bank Payee Account No.",
"Latest Bank Payee Account Name"
],
"sample_count": 1,
"rows": [
{
"AppID": "hamropatro",
"Last Name": "Adhikari",
"First Name": "Mukesh",
"Payee Accounts (Count)": "2.0",
"Latest Payee Account No.": "0700037166100011",
"Latest Payee Account Name": "Mukesh Adhikari",
"Latest Payee Bound At": "2023-09-05 11:28:19",
"Bank Payee Accounts (Count)": "2.0",
"Latest Bank Payee Account No.": "0700037166100011",
"Latest Bank Payee Account Name": "Mukesh Adhikari"
}
]
},
"07_Linked_Cards": {
"columns": [
"AppID",
"Last Name",
"First Name",
"Linked Cards (Count)",
"Latest Card No.",
"Latest Card Holder",
"Latest Card Mobile",
"Card Holder Date of Birth",
"Card Platform"
],
"sample_count": 1,
"rows": [
{
"AppID": "hamropatro",
"Last Name": "Pokharel",
"First Name": "Shisir",
"Linked Cards (Count)": "2.0",
"Latest Card No.": "***********849",
"Latest Card Holder": "Shisir Pokharel",
"Latest Card Mobile": "9851152452",
"Card Holder Date of Birth": "23-02-1994",
"Card Platform": "CIPS_LINKING | NIMB_LINKING"
}
]
},
"08_Transfer_Recipients": {
"columns": [
"AppID",
"Last Name",
"First Name",
"Transfer Recipients (Count)",
"Latest Recipient Name",
"Latest Recipient Phone",
"Transfer Recipient List"
],
"sample_count": 1,
"rows": [
{
"AppID": "hamropatro",
"Last Name": "Adhikari",
"First Name": "Mukesh",
"Transfer Recipients (Count)": "68.0",
"Latest Recipient Name": "Paritosh Bhattarai",
"Latest Recipient Phone": "9849708219",
"Transfer Recipient List": "Bibek Gautam | Dipesh Mainali | Pawan Raja Maharjan | Sifal Burger House | Deepshan Adhikari | Sumesh Gajmer | Sagar Siwakoti | Ganesh Ghimire | Santos Vai | Kishor Humagain | Subekshya Rijal | HamroPay -Fund Transfer Collection"
}
]
},
"09_Bills_and_Payments": {
"columns": [
"AppID",
"Last Name",
"First Name",
"Bill Payments (Count)",
"Bill Payments (Total)",
"Bill Payments Fee (Total)",
"Latest Bill Payment Date",
"Bill Payment Service Type",
"Latest Bill Provider",
"Saved Bills (Count)",
"Latest Saved Bill Name",
"Latest Saved Bill Request",
"Bills (Count)",
"Bill Service Type",
"Latest Bill Time"
],
"sample_count": 1,
"rows": [
{
"AppID": "hamropatro",
"Last Name": "Gautam",
"First Name": "Suraj",
"Bill Payments (Count)": "118.0",
"Bill Payments (Total)": "18834250.0",
"Bill Payments Fee (Total)": "18020.0",
"Latest Bill Payment Date": "2025-09-25 13:52:25.811+0000",
"Bill Payment Service Type": "KHANEPANI | DATA_PACK | TOPUP | ELECTRICITY",
"Latest Bill Provider": "KHALTI",
"Saved Bills (Count)": "7.0",
"Latest Saved Bill Name": "Suraj(Ncell)",
"Latest Saved Bill Request": "{\"phoneNumber\":\"9813574922\",\"amount\":10000}",
"Bills (Count)": "1.0",
"Bill Service Type": "ELECTRICITY_NEA",
"Latest Bill Time": "2025-09-25 13:52:19.013+0000"
}
]
},
"10_Split_Bill": {
"columns": [
"AppID",
"Last Name",
"First Name",
"Split Bill Customers (Count)",
"Split Bill Name",
"Split Bill Mobile",
"Split Participations (Count)",
"Split Shares (Total)",
"Latest Split Participant",
"Latest Split Purpose"
],
"sample_count": 1,
"rows": [
{
"AppID": "hamropatro",
"Last Name": "Adhikari",
"First Name": "Mukesh",
"Split Bill Customers (Count)": "1.0",
"Split Bill Name": "Mukesh Adhikari",
"Split Bill Mobile": "977-9810045698",
"Split Participations (Count)": "295.0",
"Split Shares (Total)": "904913611.0",
"Latest Split Participant": "9846563363",
"Latest Split Purpose": "Entertainment"
}
]
},
"11_Credentials_PIN_Tokens": {
"columns": [
"AppID",
"Last Name",
"First Name",
"Credentials (Count)",
"Credential Type",
"Transaction PIN",
"Credential Active",
"Credential Last Updated"
],
"sample_count": 1,
"rows": [
{
"AppID": "hamropatro",
"Last Name": "Adhikari",
"First Name": "Mukesh",
"Credentials (Count)": "4.0",
"Credential Type": "交易PIN",
"Transaction PIN": "RLAEN5SMDcxQe0mPwvOSMA== | tGkXj+j9hkhWx0qAk56zcQ== | E78DwjAzuEsfIAe7lwL1Ew== | L8anXAqZMOJR1uKqCPYWHg==",
"Credential Active": "True | False",
"Credential Last Updated": "2023-01-04 08:58:01.719+0000"
}
]
},
"12_Client_Credentials": {
"columns": [
"AppID",
"Last Name",
"First Name",
"Client Credentials (Count)",
"Client Credential Name",
"Client API Key",
"Client API Secret"
],
"sample_count": 1,
"rows": [
{
"AppID": "hamropatro",
"Last Name": "Adhikari",
"First Name": "Mukesh",
"Client Credentials (Count)": "1.0",
"Client Credential Name": "Encoders Lab Pvt. Ltd.",
"Client API Key": "C65TY9c085800825c488",
"Client API Secret": "DJV4C9c0830f0825c487"
}
]
},
"13_KYC_Review": {
"columns": [
"AppID",
"Last Name",
"First Name",
"KYC Reviews (Count)",
"Latest KYC Review Date",
"Latest KYC Review Result",
"Latest KYC Review Note",
"KYC Review History"
],
"sample_count": 1,
"rows": [
{
"AppID": "hamropatro",
"Last Name": "Adhikari",
"First Name": "Mukesh",
"KYC Reviews (Count)": "11.0",
"Latest KYC Review Date": "2023-02-27 09:10:35.425+0000",
"Latest KYC Review Result": "RETRY",
"Latest KYC Review Note": "Please update quality picture of citizenship copy",
"KYC Review History": "SUBMITTED | VERIFIED"
}
]
},
"14_Merchant_and_Corporate": {
"columns": [
"AppID",
"Last Name",
"First Name",
"Merchant Links (Count)",
"Merchant Role",
"Merchant Link Status",
"Merchant ID",
"Corporate KYC (Count)",
"Latest Corporate Company",
"Latest Corporate Role",
"Corporate Authorized Person",
"Corporate Document No."
],
"sample_count": 1,
"rows": [
{
"AppID": "hamropatro",
"Last Name": "Adhikari",
"First Name": "Mukesh",
"Merchant Links (Count)": "2.0",
"Merchant Role": "MODERATOR | ADMIN",
"Merchant Link Status": "ACTIVE",
"Merchant ID": "PN_-NfoAdcSz9cPxBQSg5jI | PN_-NbZmBzZHAb2sShzjFNe",
"Corporate KYC (Count)": "1.0",
"Latest Corporate Company": "Mukesh Adhikari Information Technology",
"Latest Corporate Role": "CEO",
"Corporate Authorized Person": "Mukesh Adhikari",
"Corporate Document No.": "123456"
}
]
},
"15_OTP_SMS_Email": {
"columns": [
"AppID",
"Last Name",
"First Name",
"OTP (Count)",
"Latest OTP Time",
"Latest OTP Status",
"OTP Service",
"SMS (Count)",
"Latest SMS Time",
"Emails (Count)",
"Latest Email Subject",
"Latest Email Time"
],
"sample_count": 1,
"rows": [
{
"AppID": "hamropatro",
"Last Name": "Adhikari",
"First Name": "Mukesh",
"OTP (Count)": "22.0",
"Latest OTP Time": "2025-09-25 10:21:03.648+0000",
"Latest OTP Status": "USED",
"OTP Service": "user-service | bank-service | HAMROPAY-FRONTEND",
"SMS (Count)": "56.0",
"Latest SMS Time": "2025-09-25 10:20:42.695+0000",
"Emails (Count)": "41.0",
"Latest Email Subject": "Hamro Pay OTP",
"Latest Email Time": "2025-04-14 06:10:55.908+0000"
}
]
},
"16_Rebind_Tickets_Votes_Invites": {
"columns": [
"AppID",
"Last Name",
"First Name",
"Mobile Rebinds (Count)",
"Latest Rebind Old Mobile",
"Latest Rebind New Mobile",
"Latest Rebind Reason",
"Latest Rebind Time",
"Votes (Count)",
"Votes Cast (Total)",
"Vote Project",
"Vote Category"
],
"sample_count": 1,
"rows": [
{
"AppID": "hamropatro",
"Last Name": "Khanal",
"First Name": "Santosh",
"Mobile Rebinds (Count)": "1.0",
"Latest Rebind Old Mobile": "977-9855061683",
"Latest Rebind New Mobile": "977-9861112512",
"Latest Rebind Reason": "Change my number",
"Latest Rebind Time": "2025-07-17 12:50:25.631+0000",
"Votes (Count)": "1.0",
"Votes Cast (Total)": "200.0",
"Vote Project": "Epicentre Hosting",
"Vote Category": "VOTING_PUBLIC_CHOICE"
}
]
},
"17_Pinot_KYC": {
"columns": [
"AppID",
"Last Name",
"First Name",
"Pinot KYC Full Name",
"Pinot KYC Father's Name",
"Pinot KYC Date of Birth",
"Pinot KYC Document Type",
"Pinot KYC Document No.",
"Pinot KYC Mobile",
"Pinot KYC Status",
"Pinot KYC Status Note",
"Pinot KYC Limit",
"Pinot KYC Risk Flag",
"Pinot KYC Flag Note"
],
"sample_count": 1,
"rows": [
{
"AppID": "hamropatro",
"Last Name": "Thapa",
"First Name": "Kushma",
"Pinot KYC Full Name": "Kushma Thapa",
"Pinot KYC Father's Name": "Rom bahadur thapa",
"Pinot KYC Date of Birth": "1991-12-15",
"Pinot KYC Document Type": "DRIVING_LICENCE",
"Pinot KYC Document No.": "01-06-00187064",
"Pinot KYC Mobile": "977-9843351163",
"Pinot KYC Status": "VERIFIED",
"Pinot KYC Status Note": "Congratulations, your KYC has been verified.",
"Pinot KYC Limit": "500000.0",
"Pinot KYC Risk Flag": "False",
"Pinot KYC Flag Note": "Another account was suspended."
}
]
},
"18_Orders_QR_Verifications": {
"columns": [
"AppID",
"Last Name",
"First Name",
"Orders (Count)",
"Orders (Total)",
"Latest Order Date",
"Latest Order Merchant",
"Latest Order Description",
"Latest Order Device",
"Latest Order Status",
"QR Codes (Count)",
"QR MID",
"QR TID",
"QR Mobile",
"Client Verifications (Count)",
"Latest Client Verification Date",
"Client Verification Source IP",
"Latest Client"
],
"sample_count": 1,
"rows": [
{
"AppID": "hamropatro",
"Last Name": "Adhikari",
"First Name": "Mukesh",
"Orders (Count)": "854.0",
"Orders (Total)": "49939071.0",
"Latest Order Date": "2026-09-23 05:44:21",
"Latest Order Merchant": "WorldLink",
"Latest Order Description": "Transfer to Deepshan Adhikari from Mukesh Adhikari",
"Latest Order Device": "Google Inc.",
"Latest Order Status": "SUCCESS",
"QR Codes (Count)": "1.0",
"QR MID": "019000623967524",
"QR TID": "01900070",
"QR Mobile": "9810045698",
"Client Verifications (Count)": "10.0",
"Latest Client Verification Date": "2026-09-19 11:22:36",
"Client Verification Source IP": "124.41.211.100 | 52.10.247.144 | 103.38.198.54 | 103.232.152.114",
"Latest Client": "Connect IPS"
}
]
}
}
},
"pep_political_persons_roster": {
"source_file": "PEP政治公众人物档案_全量.xlsx",
"total_records": 23074,
"columns": [
"ID",
"PEP No.",
"Full Name",
"Nationality",
"Party / Organization",
"Address",
"Created At",
"Updated At",
"Version",
"Record Type",
"Raw Record JSON"
],
"sample_count": 1,
"rows": [
{
"ID": "999",
"PEP No.": "999",
"Full Name": "Naresh Kumar Sah",
"Nationality": "Nepalese",
"Party / Organization": "National Democratic Party",
"Address": "Parsa",
"Created At": "2026-04-07T05:08:04.507000",
"Updated At": "2026-04-07T05:08:04.507000",
"Version": "1",
"Record Type": "com.hamropatro.dao.entity.PEPEntity",
"Raw Record JSON": "{\"key\":\"999\",\"createdAt\":null,\"updatedAt\":null,\"version\":null,\"score\":null,\"pepId\":\"999\",\"firstName\":null,\"middleName\":null,\"lastName\":null,\"fullName\":\"Naresh Kumar Sah\",\"dob\":null,\"pobCity\":null,\"pobCountry\":null,\"nationality\":\"Nepalese\",\"gender\":null,\"citizenshipNumber\":null,\"passportNumber\":null,\"comments\":null,\"lastUpdated\":0,\"organization\":\"National Democratic Party\",\"designation\":\"\",\"relationshipJson\":null,\"fullAddress\":\"Parsa\",\"politicalAffiliation\":null}"
}
]
}
}
}