[NullPointerException]

Hello everyone,today I am going to leak PhoneMondo.com database

Database Dumped Date: 2024/12/31

Database Size: 3.3G Uncompressed

Database info:

106 Tables format csv
20M+ Lines

Tables:

accounts.csv accounts_addons.csv account_licenses.csv account_settings.csv account_setup_todos.csv account_subscriptions.csv account_subscription_data.csv account_subscription_items.csv account_themes.csv addons.csv addon_countries.csv addon_groups.csv addon_settings.csv admins.csv admin_cookies.csv admin_dataset_notes.csv admin_rights.csv admin_settings.csv affiliates.csv affiliate_commissions.csv affiliate_cookies.csv affiliate_invitations.csv affiliate_payoffs.csv affiliate_totals.csv api_token.csv applications.csv avatars.csv calls.csv calls_sources.csv calls_users.csv call_metadata.csv call_redirects.csv call_reporting_data.csv changetokens.csv clients.csv client_settings.csv contacts.csv contacts_dialcodes.csv contacts_numbers.csv contact_external.csv contact_external_index.csv contact_metadata.csv custom_lookup.csv dataset_history.csv dataset_notes.csv devices.csv dialcodes.csv email_log.csv exchange_rates.csv jserrors.csv lookup_data.csv lookup_locks.csv messages.csv missing_datasets.csv monitoring.csv nnpc_data_raw.csv numbers.csv number_blacklist.csv number_detection_buffer.csv number_metadata.csv number_ranges_new.csv number_whitelist.csv placetel.csv print_jobs.csv processing_actions.csv processing_conditions.csv processing_rules.csv recordings.csv reports.csv sessions.csv setup_keys.csv short_urls.csv sounds.csv sources.csv source_groups.csv source_settings.csv spamscores.csv todos.csv uithemes.csv users.csv users_vouchers.csv user_cookies.csv user_invitations.csv user_profiles.csv user_settings.csv user_setup_todos.csv view_account_licenses.csv view_aitoken.csv view_deleted_calls.csv view_devices.csv view_sources.csv vouchers.csv wdf_cache.csv wdf_locks.csv wdf_oauthstore.csv wdf_objects.csv wdf_ratelimits.csv wdf_requests.csv wdf_routes.csv wdf_tasks.csv wdf_translations.csv wdf_unknown_strings.csv wdf_unknown_strings_data.csv wdf_versions.csv webhook_events.csv zmq_client_actions.csv

Sample in accounts.csv

id uid md5uid admin_id affiliate_id crypt_key created last_cleanup warn_at expiry_warning_sent expired deleted timezone company_name address1 address2 zip city country vat_id account_holder iban bic mandate mandate_created free_users free_sources free_contacts storage_limit storage_limit_max can_buy prepay_only invoice_email ncextra 1 JDhH1W6DXWvTA2f5b 4c8f8a97a82c122c39a265bd010ee8c5 1 G8eurY2tq/AUPhqMyaKCrdWcGlshBk8OGbOZdWM2ACc= 5/2/2023 12:04 12/29/2024 21:00 Europe/Berlin Scavix Software GmbH & Co. KG 29588 Oetzen DE x 3/17/2022 13:10 100 31000 100 -1 30 1 0 446 2 0It7iA3Sft 67fd2ac16dd7c19cfbc3da6bd6429d3e 2 9/11/2013 8:51 3/19/2020 9:02 11/7/2019 15:02 11/15/2019 8:01 2/4/2020 19:02 1 3 100 30 30 1 11 YtzY9Afh9U c2a411682688ccf7b4c85ed0d6f3df95 10 ab1V5nuZmniI3aucFU0RBaDpBaBHvipiIB+7nnZ1soE= 1/17/2014 12:59 3/18/2020 6:02 11/7/2019 22:01 11/15/2019 15:02 2/5/2020 13:02 1 3 100 30 30 1 47 zmzK2MA1bcb 7a3c678d9151e882b1985c337b95f323 61 a27F9J2cEsMyPDnQpLdt4o+/kgCklAez/Db0u9muIHU= 3/13/2015 1:37 3/19/2020 1:02 11/7/2019 2:01 11/14/2019 19:01 2/7/2020 2:02 1 3 100 30 30 1 48 RP7f7mA1bcb 3611ed8e91f790fecf4b6fda8b2a085c 63 woRA9BmBLtbJzzBXGCEAxIF20NyntPa09MZjPumG8cw= 3/13/2015 11:57 3/18/2020 8:02 11/7/2019 20:01 11/15/2019 13:02 2/5/2020 13:02 1 3 100 30 30 1 49 eZemwiA1c93 9dcae2542ad62da25507ccb4725a325b 66 fVoj6qUYPIswQ6F/CIbvO4SBSNUrKmqTitLnpEysIZE= 3/15/2015 1:06 3/18/2020 18:02 11/6/2019 18:01 11/14/2019 11:02 2/6/2020 14:02 1 3 100 30 30 1 51 vTmVoaA1e87 9f85aab6c869b19a09ab45ade3fe4e58 68 i1Vbo5b92V5IF5CrT4R4ndq6iwRR+eVjp50cGki9R+Y= 3/20/2015 16:46 12/31/2024 10:00 1 3 100 30 30 1 52 EiKCk9A1f4f 60659252bfb6c11ac7953b9ce64e2377 69 kSUlCP4asTy7KBsV4RZ/k80qwHPvZb8psfvZT6hgZog= 3/22/2015 8:37 3/19/2020 10:02 11/7/2019 7:01 11/15/2019 0:02 2/4/2020 19:02 1 3 100 30 30 1 53 FQzbovA207b c27a00e406bb262464e1f308b65cd95a 70 lw6tu12dJ1o0f2JsdQSUWnfyy9awDTp0hWfK9FolD9o= 3/25/2015 11:01 3/19/2020 10:02 11/7/2019 7:01 11/15/2019 0:02 2/4/2020 20:01 1 3 100 30 30 1 54 Ixyr0FA226f ea5f76414b225915f5a387dd8a1c8e0b 71 2 7TtzY283oCGXnDrhX3rubAJwDk/wvJxQn7nXe/OFBok= 3/30/2015 8:39 3/19/2020 11:03 11/7/2019 7:02 11/15/2019 0:02 2/4/2020 21:01 DE 1 3 100 30 30 1 56 ItJjBVA258f 70314d78e6807c16fe655c4cbb7151d9 74 4/7/2015 21:36 3/19/2020 13:02 11/7/2019 7:02 11/15/2019 1:01 2/4/2020 23:01 1 3 100 30 30 1 57 iQz6DxA284b 3da0e4e1277cbb8ce89339a412d68bf7 75 W883cDtmJMtEUDoGRex2rl/c/JOPFs5w7rYnR9BIhuk= 4/14/2015 7:56 3/19/2020 13:02 11/7/2019 8:01 11/15/2019 1:01 2/4/2020 23:01 1 3 100 30 30 1 58 ES0Q0aA2913 08ea29adedc6379056974bed6b5c7db8 76 uP4SE8hJdNKAlXCQ+FePgVTXjZOcQvM8sILMVTIUwaU= 4/16/2015 23:31 3/19/2020 14:02 11/7/2019 10:02 11/15/2019 3:01 2/5/2020 1:01 1 3 100 30 30 1 61 f13NZVA2c33 a202e0a81c9ebc5818225cf3ec403a02 79 opR4lsBe5f5BEKQysYN1LjBwXYAtKwzvq5PDiUF/XAw= 4/24/2015 8:54 3/19/2020 16:02 11/7/2019 14:02 11/15/2019 7:01 2/5/2020 5:02 1 3 100 30 30 1 62 G6VzPeA2d5f fb9520e56f96377406fa07eedbdde20d 80 4/27/2015 15:32 3/18/2020 8:02 11/7/2019 18:01 11/15/2019 11:02 2/5/2020 15:02 1 3 100 30 30 1 69 VDOwIjA2dc3 1e3d15acfb4ccc0cc51ca0554876f6bf 87 CAoGnQvqheRLZmT0fQh/lkqop0SBe43rH7O6uKWw0Wk= 6/1/2015 23:57 3/18/2020 3:02 11/7/2019 10:02 11/15/2019 3:01 2/5/2020 5:02 DE 1 3 100 30 30 1 71 eLjTaCA2eef 956867b6be1b40e5e725406620f567fc 88 6mSnIz36URkoYSbBX6F47R9YNELc8bXKoIGC4XP1X8Y= 5/1/2015 13:06 3/18/2020 4:02 11/7/2019 10:02 11/15/2019 3:01 2/5/2020 6:01 1 3 100 30 30 1 72 uwp9jIA307f 0970801592707123137aeeb3ffdf5e25 89 +6KkJiMuiP2l/UqQ9HGuJHD1jLPDpmomvBQOEYNqzNU= 5/5/2015 17:43 3/18/2020 8:02 11/7/2019 17:02 11/15/2019 10:02 2/5/2020 17:02 1 3 100 30 30 1 73 LYfLR1A307f c638452042fa49700da29c9df1a60fba 90 5/5/2015 22:37 3/18/2020 9:02 11/7/2019 18:01 11/15/2019 11:02 2/5/2020 18:02 1 3 100 30 30 1

Sample in contact_external.csv

id account_id origin type identifier data created updated deleted modified ext_created ext_modified 1 4614 placetel contact 90904001 {"id":90904001,"user_id":237902,"last_name":"Bob Tree","address":"7, Stone Hill, W 240 St, NY","address_work":"7, Stone Hill, W 240 St, NY","phone":"+498295701297","blocked":false,"color":"#d8d9da","updated_at":"2022-08-30T09:18:59.000+02:00","created_at":"2022-08-22T15:30:10.000+02:00"} 5/11/2023 16:01 8/16/2024 10:30 8/16/2024 10:30 8/22/2022 15:30 8/30/2022 9:18 2 4614 placetel contact 90996721 {"id":90996721,"user_id":237902,"last_name":"Mein Test","company":"Eine kleine GmbH","phone_work":"0221123465678","blocked":true,"color":"#d8d9da","updated_at":"2024-04-12T00:04:14.000+02:00","created_at":"2022-08-24T15:27:55.000+02:00"} 5/11/2023 16:01 8/16/2024 10:30 8/16/2024 10:30 8/24/2022 15:27 4/12/2024 0:04 3 4614 placetel contact 90999101 {"id":90999101,"user_id":237902,"last_name":"Fritz M\u00fcller","company":"Eine kleine GmbH","phone_work":"03362227000","mobile_work":"0221123465678","blocked":true,"color":"#d8d9da","updated_at":"2024-04-12T00:04:14.000+02:00","created_at":"2022-08-24T15:56:43.000+02:00"} 5/11/2023 16:01 8/16/2024 10:31 8/16/2024 10:31 8/24/2022 15:56 4/12/2024 0:04 4 4614 placetel contact 90999106 {"id":90999106,"user_id":237902,"last_name":"E-Build-Test","address_work":"F\u00fcrther Str. 111\r\n90429 N\u00fcrnberg","phone_work":"+499113193196","mobile_work":"+4991131903","mobile":"+499113190","blocked":false,"color":"#d8d9da","updated_at":"2022-10-12T10:10:28.000+02:00","created_at":"2022-08-24T15:56:43.000+02:00"} 5/11/2023 16:01 8/16/2024 10:32 8/16/2024 10:32 8/24/2022 15:56 10/12/2022 10:10 5 4614 placetel contact 90999111 {"id":90999111,"user_id":237902,"last_name":"Jeschar Group 2","phone_work":"+491732467934","blocked":false,"color":"#d8d9da","updated_at":"2022-08-24T15:56:53.000+02:00","created_at":"2022-08-24T15:56:43.000+02:00"} 5/11/2023 16:01 8/16/2024 10:32 8/16/2024 10:32 8/24/2022 15:56 8/24/2022 15:56 6 4614 placetel contact 90999116 {"id":90999116,"user_id":237902,"last_name":"Emily Garcia","address_work":"86-90 Paul Street, London, EC2A 4NE","phone_work":"+448081698824","blocked":false,"color":"#d8d9da","updated_at":"2022-08-24T15:56:44.000+02:00","created_at":"2022-08-24T15:56:43.000+02:00"} 5/11/2023 16:01 8/16/2024 10:33 8/16/2024 10:33 8/24/2022 15:56 8/24/2022 15:56 7 4614 placetel contact 90999126 {"id":90999126,"user_id":237902,"last_name":"Bob Tree","address_work":"7, Stone Hill, W 240 St, NY","phone_work":"+498295701297","blocked":false,"color":"#d8d9da","updated_at":"2022-08-24T15:56:55.000+02:00","created_at":"2022-08-24T15:56:47.000+02:00"} 5/11/2023 16:01 8/16/2024 10:34 8/16/2024 10:34 8/24/2022 15:56 8/24/2022 15:56 8 4614 placetel contact 90999131 {"id":90999131,"user_id":237902,"last_name":"Jeschar Group 2","phone_work":"+491732467934","blocked":false,"color":"#d8d9da","updated_at":"2022-10-12T10:10:28.000+02:00","created_at":"2022-08-24T15:56:54.000+02:00"} 5/11/2023 16:01 8/16/2024 10:34 8/16/2024 10:34 8/24/2022 15:56 10/12/2022 10:10 9 4614 placetel contact 90999136 {"id":90999136,"user_id":237902,"company":"Acme Inc.","address_work":"Level 28\r\n161 Castlereagh Street","phone_work":"+611800861302","blocked":false,"color":"#d8d9da","updated_at":"2022-10-26T08:51:24.000+02:00","created_at":"2022-08-24T15:56:55.000+02:00"} 5/11/2023 16:01 8/16/2024 10:34 8/16/2024 10:34 8/24/2022 15:56 10/26/2022 8:51 10 4614 placetel contact 90999141 {"id":90999141,"user_id":237902,"last_name":"Emily Dean","address_work":"25, Sispal Street, Upper east side, Manhattan","phone_work":"+49257715491","blocked":false,"color":"#d8d9da","updated_at":"2022-08-24T15:56:56.000+02:00","created_at":"2022-08-24T15:56:55.000+02:00"} 5/11/2023 16:01 8/16/2024 10:34 8/16/2024 10:34 8/24/2022 15:56 8/24/2022 15:56 11 4614 placetel contact 90999146 {"id":90999146,"user_id":237902,"last_name":"Joe Mathew","phone_work":"+491716906052","mobile_work":"+4958120889653","blocked":false,"color":"#d8d9da","updated_at":"2022-08-24T15:56:56.000+02:00","created_at":"2022-08-24T15:56:56.000+02:00"} 5/11/2023 16:01 8/16/2024 10:34 8/16/2024 10:34 8/24/2022 15:56 8/24/2022 15:56 12 4614 placetel contact 90999151 {"id":90999151,"user_id":237902,"last_name":"Erik Rerik","phone_work":"+493098765432","blocked":false,"color":"#d8d9da","updated_at":"2022-08-24T15:56:56.000+02:00","created_at":"2022-08-24T15:56:56.000+02:00"} 5/11/2023 16:01 8/16/2024 10:34 8/16/2024 10:34 8/24/2022 15:56 8/24/2022 15:56 13 4614 placetel contact 91087911 {"id":91087911,"user_id":237902,"last_name":"Erik Rerik","phone_work":"+493098765432","blocked":false,"color":"#d8d9da","updated_at":"2022-08-25T09:51:02.000+02:00","created_at":"2022-08-25T09:51:02.000+02:00"} 5/11/2023 16:01 8/16/2024 10:34 8/16/2024 10:34 8/25/2022 9:51 8/25/2022 9:51 14 4614 placetel contact 91087916 {"id":91087916,"user_id":237902,"last_name":"Joe Mathew","phone_work":"+491716906052","mobile_work":"+4958120889653","blocked":false,"color":"#d8d9da","updated_at":"2022-08-25T09:51:02.000+02:00","created_at":"2022-08-25T09:51:02.000+02:00"} 5/11/2023 16:01 8/16/2024 10:34 8/16/2024 10:34 8/25/2022 9:51 8/25/2022 9:51 15 4614 placetel contact 91087921 {"id":91087921,"user_id":237902,"last_name":"Emily Dean","address_work":"25, Sispal Street, Upper east side, Manhattan","phone_work":"+49257715491","blocked":false,"color":"#d8d9da","updated_at":"2022-08-25T09:51:02.000+02:00","created_at":"2022-08-25T09:51:02.000+02:00"} 5/11/2023 16:01 8/16/2024 10:34 8/16/2024 10:34 8/25/2022 9:51 8/25/2022 9:51 16 4614 placetel contact 91087926 {"id":91087926,"user_id":237902,"last_name":"Matt Rogers","company":"Acme Inc.","address_work":"Level 28\r\n161 Castlereagh Street","mobile":"+611800861302","blocked":false,"color":"#d8d9da","updated_at":"2022-11-05T10:30:17.000+01:00","created_at":"2022-08-25T09:51:02.000+02:00"} 5/11/2023 16:01 8/16/2024 10:34 8/16/2024 10:34 8/25/2022 9:51 11/5/2022 10:30 17 4614 placetel contact 91087931 {"id":91087931,"user_id":1669457,"last_name":"Emily Garcia","phone_work":"+448081698824","blocked":false,"color":"#d8d9da","updated_at":"2024-08-15T09:15:02.000+02:00","created_at":"2022-08-25T09:51:02.000+02:00"} 5/11/2023 16:01 8/16/2024 10:34 8/16/2024 10:34 8/25/2022 9:51 8/15/2024 9:15 18 4614 placetel contact 91087936 {"id":91087936,"user_id":237902,"last_name":"Jeschar Group Inc.","phone_work":"+491732467934","blocked":false,"color":"#d8d9da","updated_at":"2022-10-12T10:10:32.000+02:00","created_at":"2022-08-25T09:51:02.000+02:00"} 5/11/2023 16:01 8/16/2024 10:34 8/16/2024 10:34 8/25/2022 9:51 10/12/2022 10:10 19 4614 placetel contact 91087941 {"id":91087941,"user_id":237902,"last_name":"Bob Tree","address_work":"7, Stone Hill, W 240 St, NY","mobile":"+498295701297","blocked":false,"color":"#d8d9da","updated_at":"2022-08-25T09:51:03.000+02:00","created_at":"2022-08-25T09:51:02.000+02:00"} 5/11/2023 16:01 8/16/2024 10:34 8/16/2024 10:34 8/25/2022 9:51 8/25/2022 9:51

Data Download Link

Hidden Content

You must register or login to view this content.

[Bobr]

can you post sample users.csv table, and how many here?

[ThinkingOne]

... and maybe a sample that is representative of what you have. The sample that has anything useful is the first lines of the file, which is normally great and all...except this seems to be one of these little companies that starts their database with a bunch of test accounts that they forget to delete.

It has "Jeschar Group", for example... no hits in Google. 2 that have "Test" in the name. It doesn't look like a single one is a real customer.

It's probably legit, but all the sample is doing is placating the people that have no clue what to do with a sample, and figure that if you know to post a sample it has to be good! People who understand how to use a sample won't unlock it.

The other thing: are there 1,000 users or 100,000?

[GoodVibesOnly]

this is interesting data, thanks G!

[LeagueEnjoyerTY]

How many users?

[19689p]

This is epic. This looks like a European, corporate truecaller!

[xigodCC]

That'great! thanks man! Your data is amazing

[19689p]

Takes hell to download. showing 15 hrs to download a 900MB fill? Is the delay from the file host?

[Mafia_Pizza]

Thanks for sharing, I am going to unlock this one, look interesting! Cheers mate!

[Cante84]

this is interesting data, thanks G!