[vobka]

Etudebordet specializes in legal services such as debt recovery. Thanks to this they have a huge database of Belgian citizens.
They had a deadline of two days to make contact to not have this happen.

Example of data:

Avis table (336496 lines)

ID_ETUDE,ID_AVIS,TYPE_BERICHT,NEERLEGGER_GDW_ID,LANGUAGE,DF_TYPE_PERS,DF_ONDERNEMINGSNUMMER,DF_JURIDIQUE,DF_RECHTSVORM_ID,DF_RECHTSVORM,DF_CCB_PARTY_ID,DF_RIJKSREGISTER_NUMMER,DF_BUITENLANDER,DF_NAAM,DF_VOORNAMEN,DF_GEBOORTEDATUM,DF_STRAAT,DF_NUMMER,DF_BUS_NUMMER,DF_POST_CODE,DF_PLAATS,DF_LAND,CIA_LOG_ID,RQ_TYPE_PERS,RQ_ONDERNEMINGSNUMMER,RQ_JURIDIQUE,RQ_RECHTSVORM_ID,RQ_RECHTSVORM,RQ_CCB_PARTY_ID,RQ_RIJKSREGISTER_NUMMER,RQ_BUITENLANDER,RQ_NAAM,RQ_VOORNAMEN,RQ_GEBOORTEDATUM,RQ_STRAAT,RQ_NUMMER,RQ_BUS_NUMMER,RQ_POST_CODE,RQ_PLAATS,RQ_LAND,AARD_SCHULD_VORDERING,REDEN_VOORRANG,BEDRAG_VORDERING_WAARDE,BEDRAG_VORDERING_DEVISE,TS_TYPE_PERS,TS_ONDERNEMINGSNUMMER,TS_JURIDIQUE,TS_RECHTSVORM_ID,TS_RECHTSVORM,TS_CCB_PARTY_ID,TS_RIJKSREGISTER_NUMMER,TS_BUITENLANDER,TS_NAAM,TS_VOORNAMEN,TS_GEBOORTEDATUM,TS_STRAAT,TS_NUMMER,TS_BUS_NUMMER,TS_POST_CODE,TS_PLAATS,TS_LAND,SAISIE_STRAAT,SAISIE_NUMMER,SAISIE_BUS_NUMMER,SAISIE_POST_CODE,SAISIE_PLAATS,SAISIE_LAND,SOORT_BESLAG,SORTE_SAISIE,TYPE_BESLAG,TYPE_SAISIE,VASTSTELLING_NIET_BEVINDING,BESLAG_DATUM,BEVEL_DATUM,BESCHRIJVING_GOEDEREN,ID_TRIBUNAL,TRIBUNAL,RECHTBANK,ID_TRIBUNAL_COMMERCE,TRIBUNAL_COMMERCE,RECHTBANK_KOOPHANDEL,DOSSIER_REFERENTIE,ID_ACTE,ID_SERIE,ID_DOSSIER,ID_PROCEDURE,ID_STADE,TYPE_SIG_SEQ_DF,TYPE_SIG_SEQ_RQ,TYPE_SIG_TS,TYPE_SIG_SEQ_TS,DATE_VENTE_PUBLIQUE,DATE_PV_VENTE_AMIABLE,DATE_CANTONNEMENT,PAIEMENT_MONTANT_TOTAL,REF_ETU,CBBID,STATUT_OPERATION,INFO_OPERATION,DATE_DEPOT,TRANSACTION_ID,TIME_STAMP,CBB_PARTY_ID,NBR_VD,IMPRIME,ID_IMPRIME,GDH_IMPRIME,ID_C,GDH_C,ID_M,GDH_M,SUPPRIME,ID_SUPPRIME,GDH_SUPPRIME,OLD_VERSION_ID,USAGE_TER,CIA_LOG_ID_RRN,CIA_LOG_ID_KBO,RENOUVELLEMENT,DATE_RENOUVELLEMENT,MOTIF_RENOUVELLEMENT,ID_RENOUVELLEMENT,GDH_RENOUVELLEMENT,NOTIFICATION,NOTIFICATION_ID,CBB_PARTY_ID_OLD[/b] [b]1,17,1,51091717363,2,P,,,0,,0,,0,Schraeyen,Fabian,19710101,Chauss�e de Tongres,279,,4450,Juprelle,BE,2127813,M,0422481124,SA,25,la soci�t� anonyme,0,,0,Houben,,,rue du Teris - Zoning Industriel de la Boverie,65,,4100,Seraing,BE,titre ex�cutoire,,18712,92,EUR, ,,,0,,0,,0,,,,,,,,,,,,,,,,2,ex�cutoire,4,Commandement saisie ex�cution mobili�re,0,0:00:00,31/01/2011,,1402,Tribunal de Premi�re Instance de Li�ge,518300,0,,,1/0CF/0003L/002/3,1786865,0CF,0003L,002,3,1280011,1021794,,0,,,,0,1/0CF/0003L/002/3,3949,1,,2011-02-01 17:31:53,3518,1296577913190,63810,1,1,2,2011-02-22 14:37:42.653000000,1000127,2011-02-01 17:31:36,,,0,,,0,0,,,0,,,,,,,0[/b] [b]1,18,1,51091717363,2,P,,,0,,0,,0,Heckmans,Fr�d�rick,19770516,Rue du W�rixhet,13,,4620,Fl�ron,BE,2191860,M,0000000000,SADP,38,la Soci�t� Anonyme de droit public,0,,0,Centre Hospitalier Universitaire,,,Domaine Universitaire du Sart Tilman B35,35,2,4000,Li�ge,BE,titre ex�cutoire,,289,98,EUR, ,,,0,,0,,0,,,,,,,,,,,,,,,,2,ex�cutoire,4,Commandement saisie ex�cution mobili�re,0,0:00:00,31/01/2011,,1402,Tribunal de Premi�re Instance de Li�ge,518300,0,,,1/00J/01AS8/002/3,1787864,00J,01AS8,002,3,1351781,1000029,,0,,,,0,1/00J/01AS8/002/3,8876,1,,2011-02-03 10:34:28,7455,1296725668257,13498,1,1,9,2011-02-22 15:59:30.590000000,1000127,2011-02-03 10:34:12,,,0,,,0,0,,,0,,,,,,,0[/b] [b]1,19,1,51091717363,2,P,,,0,,0,,0,Fraikin,Jean,19570102,Rue de L'Institut(cer),58,,4632,Soumagne,BE,2194939,M,0000000000,0,35,autres (ILL),0,,0,Contributions Fl�ron,,,Sur les Keyeux,15,,4630,Micheroux  -  Soumagne,BE,titre ex�cutoire,,1123,28,EUR, ,,,0,,0,,0,,,,,,,,,,,,,,,,2,ex�cutoire,4,Commandement saisie ex�cution mobili�re,0,0:00:00,31/01/2011,,1402,Tribunal de Premi�re Instance de Li�ge,518300,0,,,1/0BK/000WL/001/3,1788146,0BK,000WL,001,3,1527854,1000026,,0,,,,0,1/0BK/000WL/001/3,9242,1,,2011-02-03 10:58:31,7718,1296727111915,14076,1,1,1000123,2011-02-24 13:53:49.903000000,1000127,2011-02-03 10:58:15,,,0,,,0,0,,,0,,,,,,,0[/b] [b]1,20,1,51091717363,2,P,,,0,,0,,1,P�tr�,Jean-Marc,19600324,Rue Bureau,35,,4621,Retinne  -  Fl�ron,BE,2213326,M,0000000000,0,35,autres (ILL),0,,0,Contributions Fl�ron,,,Sur les Keyeux,15,,4630,Micheroux  -  Soumagne,BE,titre ex�cutoire,,7022,89,EUR, ,,,0,,0,,0,,,,,,,,,,,,,,,,2,ex�cutoire,4,Commandement saisie ex�cution mobili�re,0,0:00:00,31/01/2011,,1402,Tribunal de Premi�re Instance de Li�ge,518300,0,,,1/0BK/000WN/001/3,1788153,0BK,000WN,001,3,1527856,1000026,,0,,,,0,1/0BK/000WN/001/3,10765,1,,2011-02-03 13:54:17,8893,1296737657018,16459,1,1,1000123,2011-02-24 13:53:49.903000000,1000127,2011-02-03 13:54:01,,,0,,,0,0,,,0,,,,,,,0[/b] [b]1,21,1,51091717363,2,P,,,0,,0,,0,Chardron,Ang�le,19600104,Rue Bureau,35,,4621,Retinne  -  Fl�ron,BE,2213350,M,0000000000,0,35,autres (ILL),0,,0,Contributions Fl�ron,,,Sur les Keyeux,15,,4630,Micheroux  -  Soumagne,BE,titre ex�cutoire,,7022,89,EUR, ,,,0,,0,,0,,,,,,,,,,,,,,,,2,ex�cutoire,4,Commandement saisie ex�cution mobili�re,0,0:00:00,31/01/2011,,1402,Tribunal de Premi�re Instance de Li�ge,518300,0,,,1/0BK/000WN/001/3,1788153,0BK,000WN,001,3,1527857,1000026,,0,,,,0,1/0BK/000WN/001/3,10769,1,,2011-02-03 13:54:29,8897,1296737669732,16465,1,1,1000123,2011-02-24 13:53:49.920000000,1000127,2011-02-03 13:54:13,,,0,,,0,0,,,0,,,,,,,0[/b] [b]1,22,1,51091717363,2,P,,,0,,0,42040113368,0,Maury,Fredy,19420401,Avenue Fran�ois Spirlet,2,,4623,Fl�ron,BE,2213372,M,0000000000,0,35,autres (ILL),0,,0,Region Wallonne Dgo7 Rtr,,,Avenue Gouverneur Bovesse,29,,5100,Jambes  -  Namur,BE,titre ex�cutoire,,784,29,EUR, ,,,0,,0,,0,,,,,,,,,,,,,,,,2,ex�cutoire,4,Commandement saisie ex�cution mobili�re,0,0:00:00,31/01/2011,,1402,Tribunal de Premi�re Instance de Li�ge,518300,0,,,1/0CA/002DZ/001/3,1788578,0CA,002DZ,001,3,1388912,1020225,,0,,,,0,1/0CA/002DZ/001/3,10770,1,,2011-02-03 13:54:36,8898,1296737676534,16467,1,1,1000123,2011-02-24 13:53:51.513000000,1000127,2011-02-03 13:54:20,,,0,,,0,0,,,0,,,,,,,0[/b] [b]1,23,1,51091717363,2,P,,,0,,0,,0,De Leo,Mirella,19730314,Rue de la Croix Henes,23,,4630,Soumagne,BE,2213539,M,0000000000,SADP,38,la Soci�t� Anonyme de droit public,0,,0,Centre Hospitalier Universitaire,,,Domaine Universitaire du Sart Tilman B35,35,2,4000,Li�ge,BE,titre ex�cutoire,,111,90,EUR, ,,,0,,0,,0,,,,,,,,,,,,,,,,2,ex�cutoire,4,Commandement saisie ex�cution mobili�re,0,0:00:00,31/01/2011,,1402,Tribunal de Premi�re Instance de Li�ge,518300,0,,,1/00J/00S86/002/3,1788779,00J,00S86,002,3,1340746,1000029,,0,,,,0,1/00J/00S86/002/3,10773,1,,2011-02-03 13:55:53,8900,1296737753910,16472,1,1,9,2011-02-22 15:59:30.340000000,1000127,2011-02-03 13:55:38,,,0,,,0,0,,,0,,,,,,,0[/b] [b]1,24,1,51091717363,2,P,,,0,,0,,0,Goblet,Jo�lle,19621011,Rue Cul de Sac(pou),8,,4350,Remicourt,BE,2213541,M,0237224881,INTER,35,autres (ILL),0,,0,Centre Hospitalier Regional De Huy,,,Rue des Trois-Ponts,2,,4500,Huy,BE,titre ex�cutoire,,138,12,EUR, ,,,0,,0,,0,,,,,,,,,,,,,,,,2,ex�cutoire,4,Commandement saisie ex�cution mobili�re,0,0:00:00,31/01/2011,,1402,Tribunal de Premi�re Instance de Li�ge,518300,0,,,1/00U/000LA/001/3,1789012,00U,000LA,001,3,1515640,1000288,,0,,,,0,1/00U/000LA/001/3,10774,1,,2011-02-03 13:55:55,8901,1296737755610,16474,1,1,1000127,2011-02-24 12:09:36.710000000,1000127,2011-02-03 13:55:40,,,0,,,0,0,,,0,,,,,,,0[/b] [b]1,25,1,51091717363,2,P,,,0,,0,57060305626,0,Postelmans,Colette,19570603,Rue de la Batterie,18,A000,4000,Li�ge,BE,2220110,M,0000000000,0,35,autres (ILL),0,,0,Region Wallonne Dgo7 Rtr,,,Avenue Gouverneur Bovesse,29,,5100,Jambes  -  Namur,BE,titre ex�cutoire,,142,27,EUR, ,,,0,,0,,0,,,,,,,,,,,,,,,,2,ex�cutoire,4,Commandement saisie ex�cution mobili�re,0,0:00:00,31/01/2011,,1402,Tribunal de Premi�re Instance de Li�ge,518300,0,,,1/0CA/0034Y/001/3,1789975,0CA,0034Y,001,3,1272352,1020225,,0,,,,0,1/0CA/0034Y/001/3,11188,1,,2011-02-03 14:56:33,9185,1296741393147,17103,1,1,1000123,2011-02-24 13:53:51.530000000,1000127,2011-02-03 14:56:18,,,0,,,0,0,,,0,,,,,,,0[/b] [b]1,26,1,51091717363,2,P,,,0,,0,71031413386,0,Di Carlantonio,Franco,19710314,Rue du Bouxthay,20,,4041,Herstal,BE,2220632,M,0000000000,0,35,autres (ILL),0,,0,Amendes Penales,,,Rue Rutxhiel,8,,4000,Li�ge,BE,titre ex�cutoire,,49,58,EUR, ,,,0,,0,,0,,,,,,,,,,,,,,,,2,ex�cutoire,4,Commandement saisie ex�cution mobili�re,0,0:00:00,31/01/2011,,1402,Tribunal de Premi�re Instance de Li�ge,518300,0,,,1/004/004ME/002/3,1789827,004,004ME,002,3,616955,1000027,,0,,,,0,1/004/004ME/002/3,11220,1,,2011-02-03 15:01:24,9215,1296741684618,17144,1,1,2,2014-02-10 13:50:57.740000000,1000127,2011-02-03 15:01:09,1000127,2014-02-07 15:25:39,0,,,0,0,,,1,2014-02-03 15:01:24,EN COURS,28,2014-02-03 15:01:24,,,0

SI_person (1248321 lines)

ID_PERS_PHYS,PATRONYME,NOM,PRENOM,PRENOMS,SEXE,PAYS_NAIS,LOC_NAIS,LIEU_NAIS,DATE_NAIS,DATE_DECES,LANGUE,ETAT_CIVIL,NATIONALITE,NUMERO_NAT,NUMERO_TVA,NUMERO_ONSS,PATRON_ABG,TITRE,FAILLITE,DATE_FAILLITE,GDH_VD,PHOTO,COMMENTS,ID_C,GDH_C,ID_M,GDH_M,SOLVABILITE,ENFAILLITE,ENADMIN,ENEXPULSION,ENRCD,ENVENTE,ENCONCORDAT,ENREORGANISATIONJUDICIAIRE,GDH_DIV,ENLIQUIDATION,NUMERO_SSIN[/b] [b]0,Louis Fr�d�ric Ernest Marcel Ghislain,Louis,Fr�d�ric,Ernest Marcel Ghislain,M,250,1017766,Huy,1972-01-28 00:00:00,1900-01-01 00:00:00,NL,2,1,72012825536,,,LOUISFREDERICERNESTMARCELGHISLAIN,MR      ,0,1899-12-30 00:00:00,2018-06-25 12:28:43,,1,2009-12-28 10:51:21.380000000,1000501,2023-12-15 15:07:13.270000000,1,1,1,,,1,,,,0,,[/b] [b]2,Bordet Alain,Bordet,Alain,,M,0,0,,1951-09-17 00:00:00,,FR,2,1,,,,BORDETALAIN,ME      ,0,,1900-01-01 00:00:00,,,,EAB\U29,2002-01-10 16:21:29.890000000,,,,,,,,,,0,,[/b] [b]3,Bussers Bernard,Bussers,Bernard,,M,0,0,,1968-10-20 00:00:00,,FR,1,1,,,,BUSSERSBERNARD,MR      ,0,,1900-01-01 00:00:00,,,,2,2004-10-22 09:20:48.863000000,,0,0,,,,,,,0,,[/b] [b]4,Pasteels Paul,Pasteels,Paul,,M,0,0,,1948-07-28 00:00:00,,FR,2,1,,,,PASTEELSPAUL,MR      ,0,,1900-01-01 00:00:00,,,,,,,,,,,,,,,0,,[/b] [b]5,Froidbise Fabian,Froidbise,Fabian,,M,1,1808,,1973-04-20 00:00:00,,FR,7,1,,,,FROIDBISEFABIAN,MR      ,0,,2003-03-24 00:00:00,,,,gest,2003-03-24 09:26:13.810000000,,0,0,0,0,,0,,,0,,[/b] [b]6,Scheen Fr�d�ric,Scheen,Fr�d�ric,,M,0,0,,1899-12-30 00:00:00,,FR,1,1,,,,SCHEENFREDERIC,MR      ,0,,1900-01-01 00:00:00,,,,,,,,,,,,,,,0,,[/b] [b]7,Tilman Beno�t,Tilman,Beno�t,,M,0,0,,1965-05-29 00:00:00,,FR,2,1,,,,TILMANBENOIT,MR      ,0,,1900-01-01 00:00:00,,,,EAB\U29,2002-01-10 15:12:01.233000000,,,,,,,,,,0,,[/b] [b]8,Delchef Claudine,Delchef,Claudine,,F,1,0,,1968-08-24 00:00:00,,FR,2,1,,,,DELCHEFCLAUDINE,MD      ,0,,1900-01-01 00:00:00,,,,EAB\U29,2002-01-10 15:52:21.560000000,,,,,,,,,,0,,[/b] [b]9,De Froidmont Georges,De Froidmont,Georges,,M,1,0,,1955-07-19 00:00:00,,FR,2,1,,,,DEFROIDMONTGEORGES,MR      ,0,,1900-01-01 00:00:00,,,,EAB\U29,2002-01-10 15:46:43.093000000,,,,,,,,,,0,,[/b] [b]10,Loux Christine,Loux,Christine,,F,1,0,,1974-04-03 00:00:00,,FR,1,1,,,,LOUXCHRISTINE,ML      ,0,,1900-01-01 00:00:00,,,,,,,,,,,,,,,0,,

Person table (89457 lines)

CLEF,ID_EXPORT,TYPE_SIG,TYPE_SIG_SEQ,TYPE_PERSONNE,ID_PERSONNE,IDPersonne,LanguePersonne,CodeTitrePersonne,Pr�nom,Nom,NomSuite,DateDeNaissance,LieuDeNaissance,Nationalit�,Num�roNational,Num�roTVA,Num�roBCE,Rue,Num�roMaison,Bo�teMaison,CodePays,CodePostal,Localit�,CompteFinancier,CompteTiers,DateD�c�s,DateRadi�,DateFaillite,DateAdmProv,DateDissolution,DateReorgJud,DateVente,DateConcordat,DateExpulsion,DateMediation,DatePartiEtranger,DateDisparu,DateInstance,DateInsolvable,DateRegistreNational,DateRegistreSoci�t�,DateDerni�reMise�Jour,T�l�phone1,T�l�phone2,GSM1,GSM2,Fax,Email[/b] [b]1,1,DF,2154383,P,2087718,DF/2154383,F,06,Michel,Th�ni�res,Jos� Georges,1964-03-01,Aiseau,France,64030101757,,,Avenue Prince de Li�ge(jb),108,REZ0,BE,5100,Namur,,,,,,,,,,,,,,,,,,,2022-11-22,,,,,,[/b] [b]2,1,DF,2154401,P,2087736,DF/2154401,F,03,Nathalie,Gille,,1976-07-05,Charleroi,Belgique,76070519836,,,Rue La-Valette,8,0001,BE,5620,Florennes,,,,,,,,,,,,,,,,,,,2022-11-21,,,,,,[/b] [b]3,1,HU,250,P,160113,HU/250,F,04,Alain,Bordet,,1951-09-17,,Belgique,,BE478382719,,Quai des Ardennes,118,119,BE,4031,Angleur  -  Li�ge,BE13068234644239 GKCCBEBB,,,,,,,,,,,,,,,,,,2007-11-29,,,,,,[/b] [b]4,1,RQ,1037537,M,1109241,RQ/1037537,F,00,,Service Public De Wallonie DGO7,,,,,,BE316381138,,Avenue Gouverneur Bovesse,29,,BE,5100,Jambes  -  Namur,BE38091215033972 GKCCBEBB,,,,,,,,,,,,,,,,,,2015-08-20,,,,,,[/b] [b]5,2,DF,2218944,P,2150703,DF/2218944,F,06,Tarik,Lamtalssi,,1986-02-22,Iaazzanene/Maroc,Maroc,86022249781,,,Rue des Cordonniers,36,,BE,7700,Mouscron,,,,,,,,,,,,,,,,,,,2022-12-02,,,,,,[/b] [b]6,2,DF,2219873,P,2151582,DF/2219873,F,03,Nancy,Verschoren,Elisabeth,1974-09-11,Bruxelles(district 2),Belgique,74091126057,,,Place Verte,34,,BE,7971,Bas�cles  -  Beloeil,,,,,,,,,,,,,,,,,,,2022-12-02,,,,,,[/b] [b]7,2,HU,250,P,160113,HU/250,F,04,Alain,Bordet,,1951-09-17,,Belgique,,BE478382719,,Quai des Ardennes,118,119,BE,4031,Angleur  -  Li�ge,BE13068234644239 GKCCBEBB,,,,,,,,,,,,,,,,,,2007-11-29,,,,,,

There are also ibans, emails and phone numbers included. You will figure out how to connect them to each person.

Hidden Content

You must register or login to view this content.

[Bluebird_Jay]

never knew belgium uses social security numbers, interesting.

[vobka]

never knew belgium uses social security numbers, interesting.

Maybe not in same context but as person ID number like other EU countries for banking, residence of stay etc

[xred07]

hello bro,

No emails?

Thanks

[vobka]

hello bro,

No emails?

Thanks

Read the thread again

[xred07]

hello bro,

No emails?

Thanks

Read the thread again

Sorry, I found it.

Thank you!

[Strugg010]

You are a real one. Thanks for the share

[19689p]

Link no longer working buddy,. Please check.

[Boat]

>There are also ibans, emails and phone numbers included. You will figure out how to connect them to each person.

Is it not presend already in the database corresponding to each row?

[rusel1gt]

This is good classic data thanks