07-12-25, 03:53 AM
I have dumped lacasadelascarcasas.es SQL Servers and Pipedrive Database.
SQL Databases: +300K lines including orders customers and internal users
Pipedrive Database: +150K lines of customer data including name phone number email etc.
Sample orders DB:
Code:
INSERT INTO `clientes_crm`(`idclientes_crm`, `numTienda`, `nombreTienda`, `nombreCliente`, `apellidoCliente`, `sexoCliente`, `telefonoCliente`, `mailCliente`, `modeloCliente`, `ticketCliente`, `inscrito`, `activo`, `creado`, `idioma`, `identificador`) VALUES ('91824', '11', '11.- CC PLAZA NORTE (SAN SEBASTIAN DE LOS REYES)', 'Ivan ', 'Vidal', 'Hombre', '622433284', 'elkuki98@gmail.com', 'iPhone 15 Pro', '1117306325', '0', '1', '2025-11-10 18:43:44', 'ES', '1169122450ef0c8');
INSERT INTO `clientes_crm`(`idclientes_crm`, `numTienda`, `nombreTienda`, `nombreCliente`, `apellidoCliente`, `sexoCliente`, `telefonoCliente`, `mailCliente`, `modeloCliente`, `ticketCliente`, `inscrito`, `activo`, `creado`, `idioma`, `identificador`) VALUES ('91825', '11', '11.- CC PLAZA NORTE (SAN SEBASTIAN DE LOS REYES)', 'Rawan', 'Hassan', 'Mujer', '641890905', 'rwanty85@gmail.com', 'iPhone 17 Pro Max', '11192012999', '0', '1', '2025-11-19 13:18:38', 'ES', '11691db59e7603e');Sample Pipedrive DB:
Code:
{"org_id": 7462, "org_name": "LCDLC_ES", "person": {"id": 465660, "owner_id": {"id": 17857957, "name": "La Casa de las Carcasas", "email": "crm@lacasadelascarcasas.es", "has_pic": 0, "pic_hash": null, "active_flag": true, "value": 17857957}, "org_id": {"name": "69", "people_count": 4795, "owner_id": 17857957, "address": "España", "label_ids": [2], "active_flag": true, "cc_email": "lacasadelascarcasas@pipedrivemail.com", "owner_name": "La Casa de las Carcasas", "value": 1435}, "name": "María Vera Fernández Verá fernandez Verá fernandez", "first_name": "María Vera Fernández Verá fernandez", "last_name": "Verá fernandez", "open_deals_count": 0, "related_open_deals_count": 0, "closed_deals_count": 5, "related_closed_deals_count": 0, "participant_open_deals_count": 0, "participant_closed_deals_count": 0, "email_messages_count": 0, "activities_count": 0, "done_activities_count": 0, "undone_activities_count": 0, "files_count": 0, "notes_count": 4, "followers_count": 2, "won_deals_count": 5, "related_won_deals_count": 0, "lost_deals_count": 0, "related_lost_deals_count": 0, "active_flag": true, "phone": [{"label": "mobile", "value": "+34677839190", "primary": true}], "email": [{"label": "work", "value": "mariaverafernandez20@gmail.com", "primary": true}], "first_char": "m", "update_time": "2025-12-02 21:02:58", "delete_time": null, "add_time": "2023-10-12 01:14:17", "visible_to": "3", "picture_id": null, "next_activity_date": null, "next_activity_time": null, "next_activity_id": null, "last_activity_id": null, "last_activity_date": null, "last_incoming_mail_time": null, "last_outgoing_mail_time": null, "label": 7, "label_ids": [7], "im": [{"value": "", "primary": true}], "postal_address": null, "postal_address_lat": null, "postal_address_long": null, "postal_address_subpremise": null, "postal_address_street_number": null, "postal_address_route": null, "postal_address_sublocality": null, "postal_address_locality": null, "postal_address_admin_area_level_1": null, "postal_address_admin_area_level_2": null, "postal_address_country": null, "postal_address_postal_code": null, "postal_address_formatted_address": null, "notes": null, "birthday": null, "job_title": null, "org_name": "69", "owner_name": "La Casa de las Carcasas", "primary_email": "mariaverafernandez20@gmail.com", "fbd36fb983aa0bf06090fb29ada1a80d26e86525": "125", "35afac5f3fffc84f83b5fd55774bcb8658bfbdc5": null, "dd552a35b0eb16b355cafff40d80412458fbde98": null, "71263027b35d40462483f6cff069989bf058d62e": "57", "4ccc7c48984bba0bcc5ed74a119a60699fe4ab4a": "España", "4ccc7c48984bba0bcc5ed74a119a60699fe4ab4a_subpremise": "", "4ccc7c48984bba0bcc5ed74a119a60699fe4ab4a_street_number": "", "4ccc7c48984bba0bcc5ed74a119a60699fe4ab4a_route": "", "4ccc7c48984bba0bcc5ed74a119a60699fe4ab4a_sublocality": "", "4ccc7c48984bba0bcc5ed74a119a60699fe4ab4a_locality": "", "4ccc7c48984bba0bcc5ed74a119a60699fe4ab4a_admin_area_level_1": "", "4ccc7c48984bba0bcc5ed74a119a60699fe4ab4a_admin_area_level_2": "", "4ccc7c48984bba0bcc5ed74a119a60699fe4ab4a_country": "España", "4ccc7c48984bba0bcc5ed74a119a60699fe4ab4a_postal_code": "", "4ccc7c48984bba0bcc5ed74a119a60699fe4ab4a_formatted_address": "España", "013d7468004699635c921bf152be46dd33655005": null, "a41a9216a67cf69cb4f471ec7db2e4bdabf366b5": "1992-11-26", "5463f8295a98ee339b1de9a15f7180f76c11221c": null, "e0ad7ba8e950263a7e67967bd76bd474f9465d00": null, "79673989de0dd85807a42fb3dc8f294191832d05": null, "8e241cc70fd7a35b57ad8621d2274ce306364e58": null, "1d4939ab2f33cf4d335a944ded1d4304e9d694b2": null, "33895ef4aebc639ab5063d6e18940442062dce28": "74", "b28df0715683858948c17e05fbb0104bd48b2f64": null, "55cb07a9f18af02e8b4949ce9c06268a54f0740e": null, "729c5bcd269aa05e826c7d4d2cca11bdc9b12b22": "34677839190", "d7f7b90c76ffe775d584d9edc5395661b331478d": "78", "a700d1c5035bb4ed4c58e372c0c7140d586775d2": null, "dde7b435cc97ff782a4a7f526cdc9c69b586725e": "", "459fdac437ee27e35744f52660ac0c82f7b50b7f": 0, "459fdac437ee27e35744f52660ac0c82f7b50b7f_currency": "EUR", "30c91bb3f51434defe8fb43720b0dfbe5f2f8614": null, "6dd45f537133813278febf01f5a6750c647b1111": "spain", "a5ae301f9d951835a858f0c4ab8d8be99459aa59": "madrid", "3252f7325f3e48fcf4fca2773f4035d4381b6aeb": "", "01f19fdcb97b504f49be41d289cb334b9909a6a1": 5182359, "16502a6a7a19f04bdbe048a6d21b03035a1c990b": "m", "11010a8bcbb67890862d01c8554f9e00a34ef200": "es", "2da4bbc70ad992308df1a02ecd9cb551d47faf75": null, "e3a3c521f45996ef151ef2adffaa2237d987a2c4": "173", "39ae1fc7351ac8bcdb1da28f3a56400b7a850fc0": null, "bea579aa9371381cf3c7ae2d2ffac2d2c39f25b1": "2025-12-02", "cc_email": "lacasadelascarcasas@pipedrivemail.com", "company_id": 12266660}}