tablename | attname | null_frac | avg_width | n_distinct | most_common_vals | most_common_freqs | histogram_bounds | correlation -----------+----------------------------+-------------+-----------+------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------- prospect | cree_par | 0 | 11 | 170 | {plemoal,pmarrone,apommet,lmorotgaudry,mpicolet,bledesma,amoal,asvassort,csaurel,sbranca} | {0.0656667,0.0586667,0.0546667,0.0543333,0.0476667,0.0393333,0.036,0.0313333,0.03,0.0296667} | {AM,BC,JD,SM,amitterrand,bshafaghat,dyvars,fvivien,mjabouille,sflora,vtaltavull} | -0.00965845 prospect | cree_le | 0 | 8 | -0.595229 | {"2001-07-20 13:18:42+02","2001-05-09 10:28:44+02","2001-07-20 13:06:06+02","2001-07-20 13:06:08+02","2001-07-20 13:06:15+02","2001-07-20 13:08:06+02","2001-07-20 13:09:13+02","2001-07-20 13:23:10+02","2001-05-09 10:27:00+02","2001-05-09 10:27:02+02"} | {0.00133333,0.001,0.001,0.001,0.001,0.001,0.001,0.001,0.000666667,0.000666667} | {"2001-05-09 10:26:57+02","2001-07-20 13:07:09+02","2001-09-10 17:40:14+02","2001-09-17 18:54:21+02","2001-09-17 19:32:39+02","2001-11-27 17:10:20+01","2002-02-14 12:17:09+01","2002-03-18 21:21:17+01","2002-03-27 11:04:26.384102+01","2002-04-03 12:34:53.046576+02","2002-04-16 15:28:59.833901+02"} | -0.0168134 prospect | modifie_par | 0 | 10 | 156 | {plemoal,apommet,mpicolet,lmorotgaudry,amoal,bledesma,pmarrone,asvassort,csaurel,avallet} | {0.0676667,0.055,0.0483333,0.0373333,0.037,0.0363333,0.0316667,0.031,0.0303333,0.029} | {AM,CON,LMG,PHM,SM,bdaubigney,dgedoux,fvandermissen,mccollignon,sbranca,vtaltavull} | -0.129771 prospect | modifie_le | 0 | 8 | 354 | {"2002-04-12 17:07:08.202726+02","2002-03-06 11:50:20+01","2002-04-15 15:46:40.276908+02","2002-02-26 15:33:14+01","2002-02-28 11:01:03+01","2002-04-03 13:31:25.253536+02","2002-04-12 17:04:34.168351+02","2002-04-03 11:15:34.312676+02","2002-04-15 11:13:46.696363+02","2002-03-27 11:13:49.627686+01"} | {0.212333,0.16,0.108333,0.0986667,0.0563333,0.034,0.0303333,0.0273333,0.0193333,0.017} | {"2002-02-28 10:55:37+01","2002-03-02 16:56:41+01","2002-03-21 21:23:07+01","2002-03-27 11:35:39.887561+01","2002-03-28 12:03:01.688528+01","2002-04-02 15:13:07.362185+02","2002-04-08 21:24:01.971303+02","2002-04-12 17:05:04.755033+02","2002-04-12 17:10:43.795726+02","2002-04-15 18:10:35.093568+02","2002-04-16 15:30:21.675532+02"} | 0.30075 prospect | id_prospect | 0 | 4 | -1 | | | {8,2693,5721,9040,12898,16250,18796,21019,22986,25434,28509} | -0.0168261 prospect | id_dp | 0.0126667 | 7 | 9 | {RA,IDF1,IDF2,PROV1} | {0.286333,0.243333,0.176,0.125} | {0,IDF3,IDF3,PROV2,PROV2} | 0.0257649 prospect | devise | 0 | 7 | 2 | {EUR,DEM} | {0.993667,0.00633333} | | 0.998284 prospect | position_prospect | 0 | 2 | 7 | {2,1,3,0,4,5,6} | {0.546,0.367333,0.0526667,0.0266667,0.00433333,0.002,0.001} | | 0.576302 prospect | id_personne1 | 0 | 4 | -1 | | | {4729,8858,12622,17811,24238,29548,33207,36006,38898,42047,46069} | -0.0168102 prospect | id_personne2 | 0.650667 | 4 | -1 | | | {4759,7224,12571,16070,19231,22743,25560,30076,37981,42431,46070} | -0.0599433 prospect | situation_familiale | 0.303667 | 5 | 8 | {M," ",C} | {0.313333,0.202,0.119333} | {A,K,K,K,V} | 0.429113 prospect | nb_enfants | 0 | 2 | 6 | {0,2,1,3,4,5} | {0.886,0.0496667,0.047,0.0126667,0.00333333,0.00133333} | | 0.83759 prospect | id_csp | 0.238333 | 4 | 15 | {0,10,2} | {0.167,0.119333,0.119} | {1,1,3,3,4,5,5,8,12,17,17} | 0.243572 prospect | id_orig_pub | 0.000333333 | 4 | 95 | {10,1,6,208,228,2,4,15,78,13} | {0.283667,0.096,0.0863333,0.0713333,0.0573333,0.036,0.0296667,0.0276667,0.0236667,0.0223333} | {0,7,9,27,63,106,170,181,213,221,257} | 0.180438 prospect | utilisation | 0.124333 | 5 | 8 | {RP,"",IL,"A ",RS,A," ","L "} | {0.552,0.222333,0.0873333,0.00633333,0.00333333,0.002,0.00166667,0.000666667} | | 0.591052 prospect | type_logement | 0.34 | 5 | 9 | {CO,MI} | {0.518,0.119} | {"","","","","","",RMH} | 0.695227 prospect | surface | 0.333667 | 4 | 83 | {0,70,100,80,90,60} | {0.413667,0.0283333,0.028,0.0216667,0.0193333,0.0163333} | {23,37,44,50,56,66,76,86,110,130,1300} | 0.353379 prospect | nb_pieces | 0.144 | 4 | 8 | {3,2,4,1} | {0.24,0.204667,0.139333,0.117} | {0,0,5,150} | 0.239878 prospect | budget | 0.148333 | 8 | 449 | {0,152440,121950,137200,182930,106710,91460,198170,76220,228660} | {0.272333,0.0356667,0.0336667,0.0226667,0.021,0.019,0.018,0.0173333,0.0163333,0.0153333} | {80,53350,83840,105950,121959,140000,167680,212490,274390,381100,6000000} | 0.254923 prospect | mensualite | 0.384 | 8 | 73 | {0} | {0.559667} | {2,410,460,530,610,630,710,762,910,1070,6930} | 0.805883 prospect | occupation_logt_actuel | 0.308 | 5 | 6 | {" ",L,P,C,I,G} | {0.213333,0.177333,0.160667,0.108333,0.0263333,0.006} | | 0.395149 prospect | type_logt_act | 0.692333 | 5 | 3 | {CO,"",MI} | {0.183667,0.069,0.055} | | 0.53756 prospect | nb_pieces_logt_act | 0.405 | 4 | 11 | {0} | {0.409333} | {1,1,2,2,2,3,3,4,4,28500} | 0.545044 prospect | loyer_logt_actuel | 0.380333 | 8 | 61 | {0} | {0.566333} | {70,340,410,460,490,530,580,610,690,840,5340} | 0.836824 prospect | revente | 0.346 | 5 | 3 | {" ",N,O} | {0.339,0.191667,0.123333} | | 0.516137 prospect | revenus_mensuels1 | 0.369 | 8 | 143 | {0,1830} | {0.484667,0.0103333} | {3,1220,1370,1520,1680,1980,2290,2740,3200,4270,533540} | 0.648804 prospect | revenus_mensuels2 | 0.397 | 8 | 78 | {0} | {0.539} | {3.8,850,1070,1220,1310,1460,1520,1680,1830,2290,20120} | 0.80749 prospect | revenus_autres | 0.406667 | 8 | 27 | {0} | {0.583667} | {90,130,180,230,260,610,760,2897,3810,4570,38110} | 0.971514 prospect | mt_impots | 0.408667 | 8 | 6 | {0} | {0.589667} | {80,1830,8290,9150,25150} | 0.995381 prospect | mt_credits_en_cours | 0.931667 | 8 | 23 | {0} | {0.059} | {70,120,150,180,210,282,300,336,457,910,18659.76} | 0.709253 prospect | nb_mois_credits | 0.402 | 4 | 13 | {0} | {0.59} | {18,24,30,36,36,48,48,48,58,240,109754} | 0.971763 prospect | apport_perso | 0.366 | 8 | 157 | {0,30490,15240,45730,60980,7620} | {0.433333,0.017,0.016,0.0116667,0.011,0.00866667} | {10,6100,11280,22870,35060,53350,76220,99090,121950,182930,1371950} | 0.558159 prospect | taux_zero | 0.388 | 8 | 35 | {0} | {0.551333} | {10,10670,15240,15240,15240,16770,18290,21340,21340,22870,274390} | 0.802942 prospect | tmi | 0.407333 | 8 | 11 | {0} | {0.585333} | {23,24,25,33,43,43,53,54,54,54} | 0.98378 prospect | mt_pret_principal | 0.393333 | 8 | 150 | {0} | {0.527} | {40,39630,54420,63110,76220,83840,92070,106710,121950,142146,1006100} | 0.738187 prospect | mt_autre | 0.408333 | 8 | 17 | {0} | {0.581667} | {10,6400,7620,7620,10670,13720,13720,16770,24390,76220,137200} | 0.965 prospect | mensualite_totale | 0.399333 | 8 | 61 | {0} | {0.564667} | {10,370,460,560,610,670,760,840,950,1070,1520} | 0.866161 prospect | abandon | 0.370667 | 5 | 3 | {" ",O,N} | {0.389667,0.167333,0.0723333} | | 0.423767 prospect | parts_fiscales | 0 | 8 | 7 | {0} | {0.995667} | {1,1,2,2,3,54} | 0.992184 prospect | net_imposable | 0.927667 | 8 | 10 | | | {0,0,0,0,0,0,0,0,0,50150} | 0.812665 prospect | referer | 0.957333 | 52 | 59 | | | {"","","","","",http://rechercher.nomade.tiscali.fr/recherche.asp?src=MSNAL&mt=CONSTRUCTEUR+IMMOBILIER&GL=FR&opt=1,http://wgc.pagesjaunes.fr/pj.cgi,http://www.immoneuf.com/bonnesaf.asp,http://www.immoneuf.com/list_ann.asp?categ=BA&dept=92&ville=Montrouge,http://www.immoneuf.com/list_ann.asp?page=3&categ=BA&dept=92&ville=Issy%2Dles%2DMoulineaux,http://www.selogerneuf.com/rech_neuf.htm?cp=92700&select=92&imageField2.x=21&imageField2.y=12} | 0.398798 prospect | premier_contact | 0.015 | 4 | -1 | | | {8,2746,5793,9118,12893,16464,20195,22375,24463,27148,30991} | -0.0182299 prospect | dernier_contact | 0.015 | 4 | -1 | | | {8,3070,6433,9918,13654,17344,20290,22459,24627,27671,30991} | 0.00653483 prospect | operations | 0.0136667 | 8 | 216 | {:765,:732,:749,:0,:705,:763,:692,:713,:536,:707} | {0.057,0.0426667,0.039,0.0363333,0.0336667,0.0326667,0.029,0.028,0.0233333,0.0223333} | {"",:589,:660,:702,:711,:721,:733,:750,:765:0,:774,:9:9} | -0.0257981 prospect | transmis | 0.225333 | 5 | 19 | {0} | {0.765333} | {674,689,692,709,724,748,755,762,769,788,791} | 0.961633 prospect | notes_prospect | 0.994667 | 92 | -1 | | | {"ADRESSE EN RESIDENCE PRINCIPALE : 70 avenue Guillaume Apollinaire 91250 SAINT-GERMAIN LES CORBEIL 65 ans","Annie était sur rillieux voir avec elle","DEVRONT METTRE EN PLACE UN PRET RELAIS SI LA REVENTE N'EST PAS FAITE PENDANT LA CONSTRUCTION FAMILLE A MOUGINS LES CABRIERES RECHERCHENT DE PREFERENCE AVEC VUE ET PAS TROP DE TERRAIN","FINANCEMENT IMPOSSIBLE MEME SUR 30 ANS TRANSMIS A FEREAL POUR RESERVATION SUR NOTRE PROGRAMME EN CO PROMOTION","MME CONGE PARENTAL","NE VEUT PAS LAISSER SON ADRESSE.CHERCHE T3 3EME OU 7 EME. TRES PRESSEE","REVENTE APPARTEMENT 2P A CANNES ETOILE (182 938 Euros)","TERRAIN TROP PETIT. RECHERCHE + DE 1000 M²","VEUT 4 CHAMBRES IMPERATIF. RIEN A PROPOSER.","VEUT HABITER IMPERATIVEMENT DANS LE 7EME,CAR POUR INSCRIRE SA FILLEA L'ECOLE DE GERLAND DOIT AVOIR UNE ADRESSE DANS LE 7EME.OCCUPENT AUJOURD'HUI 150 M2, VEULENT AU MOINS 100M2.","VU LE LOT 131 134 ET 134 O51 VENU AVEC SA MAMAN"} | 0.164706 prospect | id_csp_conj | 0.999333 | 4 | 1 | {0} | {0.000666667} | | 1 personne | cree_par | 0 | 10 | 164 | {apommet,mpicolet,PHM,plemoal,isabelle,bledesma,OC,csaurel,PLM,amoal} | {0.0936667,0.06,0.0556667,0.0546667,0.0436667,0.0403333,0.0376667,0.032,0.0273333,0.027} | {1P,BMI,GMG,MM,"SF ",avallet,cmagat,ffuchs,lmorotgaudry,pmarrone,vtaltavull} | 0.0456082 personne | cree_le | 0 | 8 | -0.258049 | {"2001-04-19 10:41:54+02","2001-04-19 10:42:06+02","2001-04-19 10:43:02+02","2001-04-19 10:43:14+02","2001-04-19 10:43:43+02","2001-04-19 10:44:56+02","2001-04-19 10:47:07+02","2001-04-19 10:48:18+02","2001-04-19 10:48:34+02","2001-09-17 18:36:55+02"} | {0.00133333,0.00133333,0.00133333,0.00133333,0.00133333,0.00133333,0.00133333,0.00133333,0.00133333,0.00133333} | {"2001-03-28 10:47:21+02","2001-04-19 10:49:01+02","2001-07-20 13:07:48+02","2001-09-17 18:30:42+02","2001-09-17 18:54:59+02","2001-09-17 19:24:07+02","2001-10-19 16:42:05+02","2002-02-05 14:27:15+01","2002-03-25 11:58:35.641987+01","2002-04-03 12:30:45.047551+02","2002-04-16 11:37:33.652415+02"} | 0.555676 personne | modifie_par | 0 | 10 | 158 | {apommet,mpicolet,plemoal,PHM,isabelle,bledesma,OC,csaurel,PLM,amoal} | {0.094,0.0613333,0.056,0.0556667,0.0436667,0.04,0.0376667,0.0323333,0.0273333,0.0273333} | {1P,BR,IP,MM,SFA,avallet,cmagat,ffuchs,lmorotgaudry,pmarrone,vtaltavull} | 0.05001 personne | modifie_le | 0 | 8 | -0.258049 | {"2001-04-19 10:41:54+02","2001-04-19 10:42:06+02","2001-04-19 10:43:02+02","2001-04-19 10:43:14+02","2001-04-19 10:43:43+02","2001-04-19 10:44:56+02","2001-04-19 10:47:07+02","2001-04-19 10:48:18+02","2001-04-19 10:48:34+02","2001-09-17 18:36:55+02"} | {0.00133333,0.00133333,0.00133333,0.00133333,0.00133333,0.00133333,0.00133333,0.00133333,0.00133333,0.00133333} | {"2001-03-28 10:47:21+02","2001-04-19 10:49:01+02","2001-07-20 13:07:48+02","2001-09-17 18:30:42+02","2001-09-17 18:54:59+02","2001-09-17 19:24:07+02","2001-10-19 16:42:05+02","2002-02-05 14:27:15+01","2002-03-25 11:58:35.641987+01","2002-04-03 12:30:45.047551+02","2002-04-16 11:37:33.652415+02"} | 0.555676 personne | id_personne | 0 | 4 | -1 | | | {21,4134,8620,13699,18232,22890,27290,32253,36889,41644,46062} | 0.555676 personne | titre | 0.0663333 | 6 | 30 | {M,MME,Mr,Mme} | {0.336333,0.313,0.0816667,0.068} | {"","DR ","M ",M.,M.,MLL,MR,Mad,Mle,Mon,mer} | 0.479291 personne | nom | 0 | 12 | -0.240372 | {MARTIN,THOMAS,BLANC,GIRARD,LAURENT,DUFOUR,FABRE,FERNANDEZ,MERCIER,COULON} | {0.00466667,0.00266667,0.002,0.002,0.002,0.00166667,0.00166667,0.00166667,0.00166667,0.00133333} | {"",BERTHIAU,CHAN,DESZMAISONS,GAILLY,JANIN,LUDIG,NAYS,REGNERO,SZKARADEK,vroux} | 0.00319397 personne | nom_marital | 0.999667 | 8 | -1 | | | | personne | prenom | 0.238667 | 7 | 610 | {"",PHILIPPE,DOMINIQUE,MICHEL,OLIVIER,ALAIN,CHRISTOPHE,GILLES,ISABELLE,JACQUES} | {0.446,0.007,0.003,0.003,0.003,0.00266667,0.00266667,0.00266667,0.00266667,0.00266667} | {"18 RUE GODILLOT",Bernard,DANIELLE,FRANCOISE,JACQUELINE,"Jean Noel","MARIE ODILE",PASCAL,Raphael,VALENTINE,ÉRIC} | 0.56059 personne | id_conjoint | 0.875 | 4 | 130 | {0} | {0.0836667} | {7629,12843,27253,28298,29797,31314,32920,35459,36684,43762,46057} | 0.509898 personne | date_naissance | 0.998667 | 8 | -1 | | | {"1935-12-23 00:00:00+00","1949-03-17 00:00:00+01","1954-08-26 00:00:00+01","1956-08-27 00:00:00+01"} | 0.4 personne | lieu_naissance | 0.998333 | 17 | -1 | | | {"BOULOGNE-BILLANCOURT (92)","CHARENTON 94","STRASBOURG 67000","TALENCE 33",paris} | 0.6 personne | numero_secu | 0.999667 | 10 | -1 | | | | personne | id_adresse_principale | 0.00533333 | 4 | -1 | | | {77,8348,26625,36725,45809,55013,63580,73906,83618,93439,102257} | 0.548577 personne | id_adresse_professionnelle | 0.0113333 | 4 | -1 | | | {191,8343,26652,36726,45740,54882,63304,74279,83743,93506,102258} | 0.554035 personne | qualification | 0.396333 | 4 | 3 | {""} | {0.597} | {A,g} | 0.95757 personne | fonction | 0.998667 | 15 | 3 | | | {"Directeur General",Gerant,President-Direc} | -0.4 adresse | cree_par | 0 | 10 | 173 | {lemine,apommet,plemoal,mpicolet,PHM,isabelle,OC,bledesma,amoal,csaurel} | {0.104333,0.0836667,0.0426667,0.042,0.0396667,0.0386667,0.0376667,0.035,0.0296667,0.0283333} | {1P,BMI,JD,PLM,SM,avallet,cpaillusson,ffuchs,lmorotgaudry,pmarrone,vtaltavull} | 0.037434 adresse | cree_le | 0 | 8 | -0.123491 | {"2001-04-19 10:43:06+02","2001-04-19 10:42:09+02","2001-04-19 10:42:13+02","2001-04-19 10:42:19+02","2001-04-19 10:43:25+02","2001-04-19 10:43:57+02","2001-04-19 10:44:35+02","2001-04-19 12:19:58+02","2001-04-19 12:20:54+02","2001-04-19 15:01:15+02"} | {0.00166667,0.00133333,0.00133333,0.00133333,0.00133333,0.00133333,0.00133333,0.00133333,0.00133333,0.00133333} | {"2001-03-23 12:14:01+01","2001-04-19 12:19:28+02","2001-05-09 10:28:40+02","2001-07-20 13:19:34+02","2001-09-17 18:46:10+02","2001-09-17 19:17:30+02","2001-09-24 18:04:15+02","2002-02-05 14:38:02+01","2002-03-26 13:41:50.237044+01","2002-04-03 12:30:28.040271+02","2002-04-16 13:25:49.956321+02"} | 0.900328 adresse | modifie_par | 0 | 10 | 168 | {lemine,apommet,plemoal,mpicolet,PHM,isabelle,OC,bledesma,amoal,csaurel} | {0.104333,0.0836667,0.043,0.0423333,0.0396667,0.0386667,0.0376667,0.0346667,0.0306667,0.0283333} | {1P,BR,JD,PLM,VK,avallet,cpaillusson,ffuchs,lmorotgaudry,pmarrone,vtaltavull} | 0.0381809 adresse | modifie_le | 0 | 8 | -0.123491 | {"2001-04-19 10:43:06+02","2001-04-19 10:42:09+02","2001-04-19 10:42:13+02","2001-04-19 10:42:19+02","2001-04-19 10:43:25+02","2001-04-19 10:43:57+02","2001-04-19 10:44:35+02","2001-04-19 12:19:58+02","2001-04-19 12:20:54+02","2001-04-19 15:01:15+02"} | {0.00166667,0.00133333,0.00133333,0.00133333,0.00133333,0.00133333,0.00133333,0.00133333,0.00133333,0.00133333} | {"2001-03-23 12:14:01+01","2001-04-19 12:19:28+02","2001-05-09 10:28:40+02","2001-07-20 13:19:34+02","2001-09-17 18:46:10+02","2001-09-17 19:17:30+02","2001-09-24 18:04:15+02","2002-02-05 14:38:02+01","2002-03-26 13:41:50.237044+01","2002-04-03 12:30:28.040271+02","2002-04-16 13:25:49.956321+02"} | 0.900328 adresse | id_adresse | 0 | 4 | -1 | | | {37,9824,18416,31793,42759,52956,62831,73712,84202,93319,102266} | 0.900327 adresse | adresse | 0.495333 | 25 | 2399 | {" ","Tour Maine Montparnasse 33, avenue du Maine","","1 AVENUE DES BEGUINES BP 8416"," ","116, AV VILLENEUVE ST GEORGES ","Tour Maine Montparnasse 33 avenue du Maine","1, rue du Petit Robinson","4, ALLEE DES AMBALAIS","Le Pilon du Roy-Rue P.Berthier ZI d'Aix-en-Provence"} | {0.0206667,0.003,0.00266667,0.00233333,0.00166667,0.00133333,0.00133333,0.001,0.001,0.001} | {" les semboules,les pins entrée C2","12 rue Ducouédic","166 RUE MAURICE ARNOUX","21 RUE DE SEINE ","29 RUE MONTE CRISTO ","38 BIS RUE DES GRANDES ","5 AV ROBERT ","61 RUE DEDIEU ","80 RUE DE PARIS ","LA BATARELLE ",paris} | -0.0330607 adresse | codep | 0.105 | 6 | 486 | {"",69003,69008,75015,69007,69005,69100,13008,75014,69006} | {0.376,0.0293333,0.0166667,0.013,0.0126667,0.0116667,0.0106667,0.008,0.00733333,0.007} | {" ",13013,37000,69009,69340,75012,77190,91280,92360,93700,ec1} | 0.0626572 adresse | ville | 0 | 9 | 626 | {"",LYON,PARIS," ",VILLEURBANNE,"LYON 08","MARSEILLE 08","LYON 03","LYON 07",ECULLY} | {0.465,0.0523333,0.035,0.0136667,0.011,0.008,0.008,0.00733333,0.00666667,0.00633333} | {"2371 EJ ROELOFARENDSVEEN",BRIGNAIS,"CHOISY LE ROI",GAREOULT,"LES LILAS","MARSEILLE 09","MONTREUIL ","PARIS 11","RILLIEUX LA PAPE",TASSIN,æYON} | 0.309116 adresse | no_tel | 0.115 | 8 | 1804 | {""," "} | {0.488,0.00533333} | {" 01 40 84 09 07","01 48 58 23 77",01.47.85.22.41,0143735430,"04 42 66 95 80",0437377033,0491064973,0608825842,72227403,78347178,"À'Ç&È\"ÉÈÇÀ"} | 0.338822 adresse | no_fax | 0.768333 | 4 | 4 | {""} | {0.222333} | {" "," ",01.53.24.48.41} | 0.972146 adresse | no_portable | 0.579667 | 5 | 182 | {""," "} | {0.354667,0.009} | {00358405697666,"06 10 30 93 04","06 22 34 65 68","06 74 09 19 02",0603681007,0615038708,0623144745,0663610896,0680758074,603812397,689108342} | 0.79558 adresse | email | 0.664333 | 5 | 74 | {""} | {0.303333} | {" "," "," ",C.magali@wanadoo.fr,amine.ba@caramail.com,david.renaud@generale-des-eaux.net,fdsauvage@aol.com,immo9491@yahoo.fr,malicaarb@hotmail.com,roselyne.ravel@voila.fr,yanticfr@yahoo.com} | 0.862856 adresse | web | 0.999333 | 18 | 1 | {www.premier.fr} | {0.000666667} | | 1 adresse | pays | 0.541 | 10 | 6 | {France} | {0.455333} | {"",Deutschland,Deutschland,Deutschland,algèrie} | 0.978139 adresse | mailing_ok | 0.0603333 | 1 | 1 | {f} | {0.939667} | | 1 contact | cree_par | 0 | 10 | 178 | {apommet,plemoal,mpicolet,lmorotgaudry,csaurel,amoal,asvassort,avallet,bledesma,PHM} | {0.078,0.0736667,0.049,0.0486667,0.038,0.035,0.031,0.0306667,0.0303333,0.03} | {"",CON,JD,OC,alexandra,cmagat,ffuchs,gpradal,mmeunier,serenis,vtaltavull} | 0.018802 contact | cree_le | 0 | 8 | -0.483731 | {"2002-02-05 11:33:53+01","2002-04-03 13:31:02.306754+02","2002-03-27 11:11:30.151648+01","2002-04-11 15:40:30.589791+02","2001-07-20 13:07:13+02","2001-07-20 13:08:31+02","2001-07-20 13:12:55+02","2001-07-20 13:23:10+02","2001-05-09 10:27:08+02","2001-05-09 10:27:15+02"} | {0.03,0.0193333,0.004,0.002,0.00133333,0.001,0.001,0.001,0.000666667,0.000666667} | {"2001-05-04 15:23:07+02","2001-07-20 13:07:15+02","2001-07-20 13:22:02+02","2001-09-17 18:49:59+02","2001-09-17 19:23:19+02","2001-10-09 18:41:20+02","2002-01-30 17:48:58+01","2002-03-10 14:58:44+01","2002-03-27 21:19:30.525544+01","2002-04-03 12:40:51.099622+02","2002-04-15 21:25:08.595331+02"} | 0.267054 contact | modifie_par | 0 | 10 | 160 | {plemoal,apommet,lmorotgaudry,mpicolet,csaurel,amoal,asvassort,avallet,bledesma,PHM} | {0.0786667,0.078,0.0496667,0.049,0.038,0.035,0.0306667,0.0306667,0.0303333,0.03} | {"",EC,JJ,PG,alexandra,dgedoux,ffuchs,gpradal,mmeunier,serenis,vtaltavull} | 0.00937019 contact | modifie_le | 0 | 8 | 1315 | {"2002-03-06 11:50:20+01","2002-02-05 09:50:47+01","2002-04-03 11:15:34.312676+02","2002-04-03 13:31:11.785869+02","2001-07-20 14:07:24+02","2002-03-27 11:11:56.443619+01","2002-02-05 11:33:53+01","2002-04-11 15:40:38.547868+02","2002-04-04 15:04:10.384469+02","2002-04-03 13:31:02.306754+02"} | {0.244667,0.0813333,0.0753333,0.0576667,0.0483333,0.03,0.0286667,0.0236667,0.022,0.018} | {"2001-06-01 14:48:35+02","2001-09-28 20:26:59+02","2001-12-03 10:58:54+01","2002-02-11 15:56:58+01","2002-02-21 11:23:49+01","2002-03-10 11:12:25+01","2002-03-23 14:47:34.716429+01","2002-03-28 18:31:20.792533+01","2002-04-03 11:15:47.569659+02","2002-04-10 21:23:23.196746+02","2002-04-16 14:35:29.730152+02"} | 0.511407 contact | id_contact | 0 | 4 | -1 | | | {1,2987,5638,9555,12752,15705,19079,22004,25100,27937,30959} | 0.266482 contact | id_prospect | 0 | 4 | -0.843182 | {65,238,1158,1890,12495,12539,12593,12665,13275,14085} | {0.000666667,0.000666667,0.000666667,0.000666667,0.000666667,0.000666667,0.000666667,0.000666667,0.000666667,0.000666667} | {1,2770,5075,8706,12120,14663,17951,20702,23484,25921,28488} | 0.293594 contact | id_operation | 0.003 | 4 | 108 | {765,749,705,763,692,713,732,709,707,0} | {0.0513333,0.05,0.0426667,0.0416667,0.041,0.0396667,0.0363333,0.0306667,0.028,0.0253333} | {2,536,651,674,703,717,727,744,757,770,999} | 0.0172324 contact | id_vendeur | 0.00233333 | 11 | 102 | {apommet,plemoal,lmorotgaudry,pmarrone,mpicolet,ggesualdi,csaurel,amoal,asvassort,avallet} | {0.0823333,0.074,0.0623333,0.054,0.051,0.0386667,0.038,0.0346667,0.0333333,0.0323333} | {"",IP,PG,bledesma,dgedoux,ekazitani,gpradal,mjmasurier,ofrard,sflora,vtaltavull} | -0.20718 contact | date_contact | 0 | 8 | 2643 | {"2002-03-28 00:00:00+01","2000-11-05 00:00:00+01","2001-03-13 00:00:00+01","2002-02-01 00:00:00+01","1999-09-25 00:00:00+02","2001-03-09 00:00:00+01","2001-04-21 00:00:00+02","2001-11-18 00:00:00+01","2002-03-22 00:00:00+01","2001-03-12 00:00:00+01"} | {0.01,0.00433333,0.00433333,0.00433333,0.00366667,0.00366667,0.00366667,0.00366667,0.00366667,0.00333333} | {"1992-01-31 00:00:00+01","1998-09-07 00:00:00+02","1999-11-07 00:00:00+01","2000-06-17 02:00:00+02","2000-11-10 00:00:00+01","2001-03-24 00:00:00+01","2001-06-28 00:00:00+02","2001-10-12 18:43:09+02","2002-01-13 11:47:17+01","2002-03-10 15:40:25+01","2020-07-07 00:00:00+02"} | 0.0255223 contact | type_contact | 0 | 6 | 11 | {E1,IMP,TEL} | {0.468333,0.217333,0.133} | {BV,DES,NET,NET,RES,RES,SAL,SIG} | 0.310614 contact | accord_budget | 0.672333 | 5 | 3 | {O," ",N} | {0.167333,0.094,0.0663333} | | 0.486813 contact | accord_site | 0.666333 | 5 | 3 | {O," ",N} | {0.199,0.097,0.0376667} | | 0.540805 contact | accord_produit | 0.677 | 5 | 3 | {O," ",N} | {0.164333,0.099,0.0596667} | | 0.430799 contact | accord_delai | 0.669 | 5 | 3 | {O," ",N} | {0.194,0.100333,0.0366667} | | 0.579159 contact | transmis_autre_programme | 0.215333 | 4 | 11 | {0} | {0.777667} | {692,692,752,757,757,770,770,788,788,791} | 0.987286 contact | nouveau_rdv | 0.756333 | 8 | 73 | {"2000-01-01 00:00:00+01"} | {0.219333} | {"1999-09-26 00:00:00+02","2000-08-02 18:30:00+02","2000-12-02 10:30:00+01","2001-02-24 15:00:00+01","2001-04-26 00:00:00+02","2001-05-26 11:00:00+02","2001-08-12 17:00:00+02","2001-10-17 18:30:00+02","2001-11-23 13:30:00+01","2002-01-14 16:00:00+01","2002-04-11 18:00:00+02"} | 0.795377 contact | date_echeance | 0.738333 | 8 | 95 | {"2000-01-01 00:00:00+01"} | {0.218} | {"2000-05-15 00:00:00+02","2000-09-01 00:00:00+02","2001-01-01 00:00:00+01","2001-07-31 00:00:00+02","2001-09-15 00:00:00+02","2001-10-16 00:00:00+02","2001-11-01 00:00:00+01","2001-11-25 00:00:00+01","2002-01-20 00:00:00+01","2002-02-15 00:00:00+01","2002-04-20 00:00:00+02"} | 0.634139 contact | observation | 0.105333 | 61 | -0.118789 | {""," ","Envoyez-moi une documentation sur le programme "," ","EN DEBUT DE RECHERCHE","PLUS LE PRODUIT","Je souhaite qu'un conseiller commercial me contacte ",SERENIS.,"Il ne souhaite pas laisser son adresse.","Elle ne souhaite pas laisser son adresse."} | {0.23,0.0523333,0.0156667,0.00566667,0.00566667,0.00433333,0.004,0.00266667,0.00233333,0.00166667} | {" N AIME PAS LES PLANS DES 4 PIECES LES 5 PIECES TROP CHERS HORS BUDGET","AIME LE PROJET MAIS PRIX TROP ELEVE PROPOSITION LOT 15 SUR LIEUSAINT","DOC POSTEE LE 05/10/2000. RELANCE FAITE LE 12/10 : pas pressé, passera peut_ être à Noë l 2000. ","Elle recherche une surface de 150 M². Elle souhaite recevoir une documentation.",INFINANCABLE,"LOT 002 R/V 13/02 POUR AFFINER LE FINANCEMENT. ILS ONT ETE VISITER LEVALLOIS. 13/02 ILS ONT RESERVE CHEZ CAPRI, PAS DE REZ DE CHAUSSEE POUR LE MEME PRIX.","NON CAR PASSE SUR SITE VEUT MI DIFFUS PAS DE VOISIN ILS REVENT","RDV QUI A ETE ANNULE ABANDON","RT 2EME TRANCHE COLLECTIF.NE VEUT PAS D'UN APPARTEMENT FACE AUX HLM. ","VILLA ST LOUIS OU BAGATELLE. PAS PRESSE . DANS 1 AN OU 2. LORSQUE LES ENFANTS SERONT PARTIS.","à relancer "} | -0.0517738 contact | date_reponse | 0.27 | 8 | 1426 | {"2000-11-05 00:00:00+01","2001-03-13 00:00:00+01","1999-09-25 00:00:00+02","2001-03-09 00:00:00+01","2001-04-21 00:00:00+02","2001-03-12 00:00:00+01","2001-03-24 00:00:00+01","2001-03-27 00:00:00+02","2001-10-05 00:00:00+02","2001-10-18 00:00:00+02"} | {0.00433333,0.00433333,0.00366667,0.00366667,0.00366667,0.00333333,0.00333333,0.00333333,0.00333333,0.00333333} | {"1992-01-31 00:00:00+01","1997-05-05 00:00:00+02","1999-05-29 00:00:00+02","1999-12-10 00:00:00+01","2000-05-22 00:00:00+02","2000-09-23 00:00:00+02","2001-01-04 00:00:00+01","2001-04-06 00:00:00+02","2001-06-26 00:00:00+02","2001-10-11 00:00:00+02","2009-12-03 00:00:00+01"} | -0.0980967 contact | type_reponse | 0.930667 | 12 | 11 | | | {"",Telefon,abandon,abandon,abandon,abandon,abandon,abandon,"envoi de documentation",téléphone,téléphone} | 0.314692 contact | obs_reponse | 0.942667 | 49 | 150 | | | {"","","ABANDON PROJET LE SITE NE CONVIENT PAS IL N'EST PAS ASSEZ AERE.","ETAIT RETOURNE EN PROVINCE JE LUI AI FAIT LA PROPOSITION DES FRAIS DE NOTAIRES PROBLEME AVEC LA DATE DE LIVRAISON","JE N AI PLUS LE PRODUIT","MADAME NE VEUT PAS ACHETER DANS LE NEUF. CONCEPTION QUI NE LUI CONVIENT PAS","Mehrmals auf Band, kein Rü","ONT RESERVE CHEZ HAUSSMANN","RDV ANNULER. TROP CHER A FAIT SIMULATION AVEC SON BANQUIER.","Termin abspr. für Fina Frau hat anger. Mann hat angerufen und haben aus privaten und pers. Gründen abgesagt. Wollen nun doch in Ihrer Wohnung bleiben Vorrauss.1.11. 18Uhr","à relancer vers le 13/04/02"} | 0.1163 (100 rows)