{"text_format":"dbase-jsonl-2026-09-30","columns":[{"name":"SA_NUMERO","type":"number","width":10,"decimals":0},{"name":"SA_ADRESSE","type":"number","width":6,"decimals":0},{"name":"SA_NOM","type":"character","width":60},{"name":"SA_PRENOM","type":"character","width":40},{"name":"SA_CONJOIN","type":"character","width":40},{"name":"SA_RUE_1","type":"character","width":40},{"name":"SA_RUE_2","type":"character","width":40},{"name":"SA_NPA","type":"character","width":10},{"name":"SA_VILLE","type":"character","width":40},{"name":"SA_RCANTON","type":"character","width":2},{"name":"SA_PAYS","type":"character","width":50},{"name":"SA_TITRE","type":"character","width":40},{"name":"SA_CODE","type":"character","width":15},{"name":"SA_GROUPE","type":"character","width":40},{"name":"SA_TXTPOLI","type":"character","width":50},{"name":"SA_TEL1","type":"character","width":20},{"name":"SA_TEL2","type":"character","width":20},{"name":"SA_TEL3","type":"character","width":20},{"name":"SA_EMAIL","type":"character","width":50},{"name":"SA_TEXTE","type":"memo","width":10,"read":false},{"name":"SA_PICTURE","type":"memo","width":10,"read":false},{"name":"SA_FILIAT","type":"character","width":40},{"name":"SA_LANGUE","type":"number","width":1,"decimals":0},{"name":"SA_NAISSAN","type":"date","width":8},{"name":"SA_SEXE","type":"number","width":1,"decimals":0},{"name":"SA_ETCIVIL","type":"number","width":2,"decimals":0},{"name":"SA_ENFANTS","type":"number","width":2,"decimals":0},{"name":"SA_MIL_SIT","type":"character","width":20},{"name":"SA_NO_AVS","type":"character","width":15},{"name":"SA_SS","type":"character","width":16},{"name":"SA_RCE","type":"character","width":15},{"name":"SA_CAISMAL","type":"character","width":50},{"name":"SA_ENTRE_1","type":"date","width":8},{"name":"SA_SORTI_1","type":"date","width":8},{"name":"SA_ENTRE_2","type":"date","width":8},{"name":"SA_SORTI_2","type":"date","width":8},{"name":"SA_ENTRE_3","type":"date","width":8},{"name":"SA_SORTI_3","type":"date","width":8},{"name":"SA_ENGAGEM","type":"date","width":8},{"name":"SA_TYP_ACT","type":"number","width":1,"decimals":0},{"name":"SA_ACT_FIN","type":"date","width":8},{"name":"SA_ACT_DEF","type":"number","width":1,"decimals":0},{"name":"SA_DEPART","type":"character","width":50},{"name":"SA_FONCTIO","type":"character","width":50},{"name":"SA_LIEU","type":"character","width":40},{"name":"SA_NATION","type":"character","width":50},{"name":"SA_PERMIS","type":"character","width":15},{"name":"SA_C_SUVA","type":"character","width":2},{"name":"SA_C_AVS","type":"number","width":1,"decimals":0},{"name":"SA_C_AC","type":"number","width":1,"decimals":0},{"name":"SA_C_LPP","type":"number","width":1,"decimals":0},{"name":"SA_CLEARIN","type":"character","width":10},{"name":"SA_CCP","type":"character","width":15},{"name":"SA_ADHERCP","type":"character","width":15},{"name":"SA_CPTBANQ","type":"character","width":30},{"name":"SA_BANNOM","type":"character","width":60},{"name":"SA_BANRUE","type":"character","width":30},{"name":"SA_BANNPA","type":"character","width":10},{"name":"SA_BANVILL","type":"character","width":30},{"name":"SA_BANCCP","type":"character","width":15},{"name":"SA_PMT_MOD","type":"number","width":1,"decimals":0},{"name":"SA_IBAN","type":"character","width":50},{"name":"SA_SWIFT","type":"character","width":15},{"name":"SA_BCOUNT","type":"character","width":50},{"name":"SA_BCCOUNT","type":"character","width":4},{"name":"SA_BLNAME","type":"character","width":60},{"name":"SA_BFNAME","type":"character","width":40},{"name":"SA_BSTREET","type":"character","width":40},{"name":"SA_BZIP","type":"character","width":10},{"name":"SA_BCITY","type":"character","width":40},{"name":"SA_VAC_JOU","type":"number","width":7,"decimals":2},{"name":"SA_VAC_HEU","type":"number","width":7,"decimals":2},{"name":"SA_VACJPRE","type":"number","width":7,"decimals":2},{"name":"SA_VACHPRE","type":"number","width":7,"decimals":2},{"name":"SA_C_IMPOT","type":"logical","width":1},{"name":"SA_ISTARIF","type":"character","width":2},{"name":"SA_ISECCLE","type":"character","width":1},{"name":"SA_ISFRONT","type":"character","width":2},{"name":"SA_ISCANTO","type":"character","width":2},{"name":"SA_COMPTE","type":"character","width":12},{"name":"SA_COMPTE1","type":"character","width":12},{"name":"SA_LIBELLE","type":"character","width":40},{"name":"SA_ANA_SCH","type":"number","width":6,"decimals":0},{"name":"SA_ANA_CPT","type":"character","width":14},{"name":"SA_VAC_PRT","type":"logical","width":1},{"name":"SA_DIVER1","type":"character","width":40},{"name":"SA_DIVER2","type":"character","width":40},{"name":"SA_DIVER3","type":"character","width":40},{"name":"SA_DIVER4","type":"character","width":40},{"name":"SA_DIVER5","type":"character","width":40},{"name":"SA_DIVER6","type":"character","width":40},{"name":"SA_DIVER7","type":"character","width":40},{"name":"SA_DIVER8","type":"character","width":40},{"name":"SA_DIVER9","type":"character","width":40},{"name":"SA_DIVER10","type":"character","width":40},{"name":"SA_DIVER11","type":"number","width":15,"decimals":2},{"name":"SA_DIVER12","type":"number","width":15,"decimals":2},{"name":"SA_DIVER13","type":"number","width":15,"decimals":2},{"name":"SA_DIVER14","type":"number","width":15,"decimals":2},{"name":"SA_MODELE","type":"character","width":20},{"name":"SA_VERSION","type":"number","width":2,"decimals":0},{"name":"SA_CPIBAN","type":"character","width":50},{"name":"SA_COMMUNI","type":"character","width":35},{"name":"SA_PREVDAT","type":"date","width":8},{"name":"SA_LPPPREV","type":"number","width":2,"decimals":0},{"name":"SA_LPPMNT","type":"number","width":10,"decimals":2},{"name":"SA_OFS","type":"number","width":6,"decimals":0},{"name":"SA_CNTRYCD","type":"character","width":2},{"name":"SA_TAXE","type":"number","width":1,"decimals":0}],"n_rows":8,"rows_kept":8,"cut":false,"deleted_skipped":0,"read_ended":"whole","bounds":"16MiB/16384/4096/first_that_fit","version":"foxpro_two","encoding_class":"enc_single_byte","reader":"statdb_count/12"}
[1,0,"Duchêne","Marc",null,"Chemin de la Montagne 55C",null,"1224","Chêne-Bougeries",null,null,"Monsieur",null,null,null,null,null,"078 881 2002",null,null,null,null,0,null,1,0,0,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,0.00,0.00,0.00,0.00,false,null,null,null,null,"4000","2090",null,0,null,false,null,null,null,null,null,null,null,null,null,null,0.00,0.00,0.00,0.00,"Normal",1,null,null,null,0,0.00,0,null,0]
[30,0,"Mpika","Raulh Franguy",null,"Ch. Isabelle-de-Montolieu 183",null,"1010","Lausanne","VD","Suisse","Monsieur","10",null,null,null,null,"078 849 18 43","franguy.mpika@hotmail.fr",null,null,null,1,"1991-05-04",1,1,0,null,".  .   .","756.1254.1655.16",null,null,null,null,null,null,null,null,"2020-02-03",0,"2020-02-19",0,"Distribution",null,"Romanel-sur-Lausanne",null,null,"A1",2,2,2,null,null,null,null,"PostFinance",null,null,null,null,2,"CH8509000000142352518","POFICHBEXXX","Suisse","CH","Mpika","Raulh Franguy","Ch. Isabelle-de-Montolieu 183","1010","Lausanne",0.00,0.00,0.00,0.00,true,"A",null,null,"VD","4000","2090",null,0,null,false,null,null,null,null,null,null,null,null,null,null,0.00,0.00,0.00,0.00,null,1,null,null,null,1,0.00,0,"CH",2]
[28,0,"Pasche","Bettina",null,"Ch. de Champ Pâquis 4",null,"1071","Chexbres","VD","Suisse","Madame","11",null,null,null,null,null,null,null,null,null,1,"1972-04-06",2,2,0,null,".  .   .","756.2136.3620.85",null,null,null,null,null,null,null,null,"2019-10-07",0,null,0,null,"Disponente","Romanel-sur-Lausanne",null,null,"A1",2,2,2,null,null,null,null,"BCV",null,null,null,null,2,"CH2100767000C52717478",null,"Suisse","CH",null,null,null,null,null,10.00,0.00,1.36,-1.25,false,"A",null,null,null,"4000","2090",null,0,null,true,null,null,null,null,null,null,null,null,null,null,0.00,0.00,0.00,0.00,null,1,null,"Salaire mensuel",null,1,0.00,0,"CH",2]
[24,0,"GAGNERE","Gabriel",null,"Route du Jura 9",null,"1123","Aclens","VD","Suisse","Monsieur","1",null,null,null,null,"078 855 70 07","gabriel.gagnere@promerka.com",null,null,null,1,"1981-07-09",1,2,0,null,null,"756.0343.1902.31",null,null,null,null,null,null,null,null,"2018-01-01",0,null,0,"Direction","CEO","Romanel-sur-Lausanne",null,null,"A1",2,2,2,"80460",null,null,"54021826","Banque Raiffeisen Morges Venoge","Rue du Chêne 1","1315","Sarraz, La","10-1933-9",2,"CH1380460000054021826","RAIFCH22460","Suisse","CH",null,null,null,null,null,20.00,0.00,24.00,0.00,true,"C",null,null,"VD","4000","2090",null,0,null,true,null,null,null,null,null,null,null,null,null,null,0.00,0.00,0.00,0.00,null,1,null,"Salaire Mensuel PROMERKA SA",null,1,0.00,0,"CH",2]
[13,0,"Sandra","Schmid",null,"Chemin de Vassin 34",null,"1814","La Tour-de-Peilz","VD","Suisse","Mademoiselle","9",null,null,null,null,null,null,null,null,null,2,"1982-12-27",2,1,0,null,".  .   .","756.2222.9469.46",null,null,null,null,null,null,null,null,"2016-07-01",0,null,0,"Administration","Operation Manager","Romanel-sur-Lausanne",null,null,"A1",2,2,2,null,null,null,null,"BCV",null,null,null,null,2,"CH4000767000R52469735",null,"Suisse",null,null,null,null,null,null,20.00,0.00,5.00,10.75,true,"A",null,null,"VD","4000","2090",null,0,null,true,null,null,null,null,null,null,null,null,null,null,0.00,0.00,0.00,0.00,null,1,null,"Salaire Mensuel",null,1,0.00,5889,"CH",2]
[26,0,"Ben Arfa","Bilel",null,"Avenue de Censuy 20",null,"1020","Renens","VD","Suisse","Monsieur","12",null,null,null,null,"079 696 45 52",null,null,null,null,1,"1984-01-09",1,2,1,null,null,"756.5141.5398.86",null,null,null,null,null,null,null,null,"2018-04-23",0,null,0,"Distribution","Livreur-Monteur","Romanel-sur-Lausanne",null,null,"A1",2,2,2,null,"10-202288-5",null,null,null,null,null,null,null,1,null,"POFICHBEXXX",null,null,null,null,null,null,null,20.00,0.00,1.33,-14.00,false,"A",null,null,null,"4000","2090",null,0,null,true,null,null,null,null,null,null,null,null,null,null,0.00,0.00,0.00,0.00,null,1,"CH9809000000102022885","Salaire Mensuel PROMERKA",null,1,0.00,0,"CH",2]
[34,0,"Blom","Julia",null,"Chemin de Fleur de Lys 15D",null,"1071","Chexbres","VD","Suisse","Madame","13",null,null,null,null,"078 696 33 13",null,null,null,null,1,"1990-12-30",2,1,0,null,".  .   .","756.0471.9836.68",null,null,null,null,null,null,null,null,"2020-06-02",0,null,0,null,null,null,null,null,"A1",2,2,2,null,null,null,null,"Banque Cantonale Vaudoise",null,null,null,null,2,"CH6700767000Z51612479",null,null,null,null,null,null,null,null,0.94,0.00,0.00,0.00,false,"A",null,null,null,"4000","2090",null,0,null,true,null,null,null,null,null,null,null,null,null,null,0.00,0.00,0.00,0.00,null,1,null,null,null,1,0.00,0,"CH",2]
[37,0,"Miege Bosson","Annick","Xavier Pierre Miege","Route des Bois-Enclos 47",null,"74100","Juvigny","GE","France","Madame","14",null,null,null,null,"078 233 20 26",null,null,null,null,1,"1967-10-11",2,2,0,null,".  .   .","756.3177.1461.91",null,null,null,null,null,null,null,null,"2020-08-01",0,null,0,null,null,null,null,null,"A1",2,2,1,"788",null,null,null,"Banque Cantonale de Genève",null,"1211","Genève 2","12-1-2",2,"CH5200788000T07739238","BCGECHGGXXX",null,null,null,null,null,null,null,8.33,0.00,0.00,0.00,true,"F",null,null,"VD","4000","2090",null,0,null,true,null,null,null,null,null,null,null,null,null,null,0.00,0.00,0.00,0.00,null,1,null,null,null,1,0.00,0,"FR",2]