Yesterday, 04:07 PM
(Jan 12, 2025, 02:08 AM)vobka Wrote: 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.
thank you for sharing