Company database dump for sale: Études Environnement
website: https://etudesenvironnement.fr/
![[Image: EE-Logo-H-e1641827335846.png]](https://external-content.duckduckgo.com/iu/?u=https://etudesenvironnement.fr/wp-content/uploads/2023/07/EE-Logo-H-e1641827335846.png)
The dump includes separate sql files of each table of one database, which are located in a folder. (In quantity of 48 pieces)
The folder name corresponds to the name of the database from which the tables were exported. (A screenshot of the names and sizes of all tables will be attached below.)
One of the tables, called "yj_fiche", contains the following personal data in 700,000 rows. (This table is also downloadable separately in csv format):
Full name (without duplicatess) - 740.000
Phone number (without duplicatess) - 700.000
Address (without duplicatess) - 500.000
The table also contains other data such as: nom_centre, profession_mr, profession_mme, and so on.
Total lines: 826.516 (Table size: 631.0 MB)
Format: CSV (One table, other tables in SQL including table "yj_fiche")
Data retrieval date: 11/17/2024
Size on disk: 19.0 GB
PRICE: 500$
For any questions, please contact me via private messages.
Other contacts for contacting me:
Telegram - https://t.me/GoodDayArikos
Screenshot of all database tables
![[Image: 1.png]](https://external-content.duckduckgo.com/iu/?u=https://i.postimg.cc/x1GQF7pb/1.png)
Example table "yj_fiche" with 700,000 rows
website: https://etudesenvironnement.fr/
The dump includes separate sql files of each table of one database, which are located in a folder. (In quantity of 48 pieces)
The folder name corresponds to the name of the database from which the tables were exported. (A screenshot of the names and sizes of all tables will be attached below.)
One of the tables, called "yj_fiche", contains the following personal data in 700,000 rows. (This table is also downloadable separately in csv format):
Full name (without duplicatess) - 740.000
Phone number (without duplicatess) - 700.000
Address (without duplicatess) - 500.000
The table also contains other data such as: nom_centre, profession_mr, profession_mme, and so on.
Total lines: 826.516 (Table size: 631.0 MB)
Format: CSV (One table, other tables in SQL including table "yj_fiche")
Data retrieval date: 11/17/2024
Size on disk: 19.0 GB
PRICE: 500$
For any questions, please contact me via private messages.
Other contacts for contacting me:
Telegram - https://t.me/GoodDayArikos
Screenshot of all database tables
Example table "yj_fiche" with 700,000 rows
[
{
"id": "842499",
"civ": "MLLE",
"nom": "ALAIN",
"prenom": "LEXA",
"tel": "382334987",
"gsm1": "382334987",
"gsm2": "382334987",
"Adresse": "10 R LUCIEN GILLES",
"cp": "54800",
"ville": "LABRY",
"maison_orientation": "NON",
"etude": "MME",
"etude_observation": "PRESENTATION NON CONFORME/PAS DE CONFIRMATION DE LA CONSOMMATION DU GAZ/PAS DE CONFIRMATION DE L AGE DE LA CHAUDIERE/CLIENTE MEFIANTE//MERCI DE VERIFIER LA CONSOMMATION ELEC ET GAZ/L AGE DE LA CHAUDIERE ET L EXISTENCE DES RADIATEURS A EAU",
"installation": "13/11/2024 18:38:59",
"installation_type": "0",
"installation_annee": "0",
"installation_production": "AG2175",
"installation_prix": "0",
"entretient": "QUALITE2",
"commentaire": "Call_JWS_PAC",
"date_heure_appel": "1",
"nom_commercial": "RET AUTRE",
"nom_commercial_2": "RET AUTRE",
"id_commercial": "-75",
"nom_confirmateur": "-75",
"nom_confirmateur_2": "0",
"nom_confirmateur_3": "MARIE",
"id_confirmateur": "1500",
"nom_agent": "0",
"id_agent": "0/0/0 00:00:00",
"nom_qualite": "0/0/0 00:00:00",
"id_qualite": "13/11/2024 19:00:00",
"nom_centre": "EN-ATTENTE",
"id_centre": "PAC",
"profession_mr": "GAZ",
"age_mr": "0",
"age_mme": "0",
"enfant_encharge": "0",
"situation_conju": "0",
"revenu": "100",
"credit": "100",
"site_classe": "5",
"zones_ombres": "2019",
"chemines": "100",
"nb_chemines": "LES DEUX",
"surface_disponible": "0",
"etat_qualite": "0",
"date_heure_playning": "0",
"date_heure_mod": "0",
"date_insertion": "0",
"motif_qualification": "0",
"adresse_ip": "0",
"etat_final": "0",
"sous_etat": "0/0/0 00:00:00",
"conf_rdv_avec": "",
"conf_prise_autre_personne": "",
"conf_profession_monsieur": "",
"conf_profession": "",
"conf_profession_detail": "",
"conf_profession_madame": "",
"conf_profession_mme": "",
"conf_profession_detail_mme": "",
"conf_deja_fait_etude": "",
"conf_detail_etude": "",
"conf_revenu": "",
"conf_credit": "",
"conf_deja_installe": "",
"conf_type_installation": "",
"conf_annee_installation": "",
"conf_production_installation": "",
"conf_prix_installation": "",
"conf_annulee_precedemment": "",
"conf_annulee_precedemment_par": "",
"conf_produit": "",
"conf_energie": "",
"conf_consommations": "",
"conf_consommation_chauffage": "",
"conf_commentaire_produit": "",
"observation_qualite": "",
"exportation": "",
"favorite": "",
"color": "",
"PENALITE": "",
"DETAIL_PENALITE": "",
"pac_consomation": "",
"pac_surface_habitable": "",
"pac_nombre_pieces": "",
"pac_age_maison": "",
"pac_annee_chauf": "",
"pac_surface_chauf": "",
"pac_propritaire_maison": "",
"conf_presence_couple": "",
"archive": "",
"valider": "",
"ph3_pac": "",
"ph3_attente": "",
"ph3_alimentation": "",
"ph3_type": "",
"ph3_prix": "",
"ph3_puissance": "",
"ph3_ballon": "",
"ph3_nbr_unite": "",
"ph3_nbr_group": "",
"ph3_rr_model": "",
"ph3_installateur": "",
"ph3_mensualite": "",
"ph3_bonus_15": "",
"ph3_bonus_30": "",
"decalage": "",
"valeur_mensualite": "",
"nbr_annee_finance": "",
"cq_etat": "",
"cq_dossier": "",
"cq_observations": "",
"cq_date_modif": "",
"credit_autre": "",
"credit_immobilier": "",
"ph3_marque_pac": "",
"ph3_marque_ballon": ""
},
{
"id": "842500",
"civ": "MR",
"nom": "MICHEL",
"prenom": "COLLET",
"tel": "477668136",
"gsm1": "477668136",
"gsm2": "477668136",
"Adresse": "446 R CHARMILLES",
"cp": "42155",
"ville": "POUILLY LES NONAINS",
"maison_orientation": "MR",
"etude": "ELEC : 1200 EURO / BATIE : 50 M² MR 73 ANS /MME 72 ANS / LES 2 PROP / MARIE / RETRAITES / REVENU 1500",
"etude_observation": "13/11/2024 18:51:46",
"installation": "0",
"installation_type": "0",
"installation_annee": "AG785",
"installation_production": "0",
"installation_prix": "QUALITE6",
"entretient": "Call_JWS_PV",
"commentaire": "1",
"date_heure_appel": "RET AUTRE",
"nom_commercial": "RET AUTRE",
"nom_commercial_2": "73",
"id_commercial": "72",
"nom_confirmateur": "0",
"nom_confirmateur_2": "MARIE",
"nom_confirmateur_3": "1500",
"id_confirmateur": "NON",
"nom_agent": "0",
"id_agent": "0/0/0 00:00:00",
"nom_qualite": "0/0/0 00:00:00",
"id_qualite": "13/11/2024 19:01:00",
"nom_centre": "EN-ATTENTE",
"id_centre": "PV",
"profession_mr": "PAC/BOIS",
"age_mr": "1200",
"age_mme": "0",
"enfant_encharge": "0",
"situation_conju": "0",
"revenu": "1200",
"credit": "100",
"site_classe": "5",
"zones_ombres": "0",
"chemines": "100",
"nb_chemines": "LES DEUX",
"surface_disponible": "0",
"etat_qualite": "0",
"date_heure_playning": "0",
"date_heure_mod": "0",
"date_insertion": "0",
"motif_qualification": "0",
"adresse_ip": "0",
"etat_final": "0",
"sous_etat": "0/0/0 00:00:00",
"conf_rdv_avec": "",
"conf_prise_autre_personne": "",
"conf_profession_monsieur": "",
"conf_profession": "",
"conf_profession_detail": "",
"conf_profession_madame": "",
"conf_profession_mme": "",
"conf_profession_detail_mme": "",
"conf_deja_fait_etude": "",
"conf_detail_etude": "",
"conf_revenu": "",
"conf_credit": "",
"conf_deja_installe": "",
"conf_type_installation": "",
"conf_annee_installation": "",
"conf_production_installation": "",
"conf_prix_installation": "",
"conf_annulee_precedemment": "",
"conf_annulee_precedemment_par": "",
"conf_produit": "",
"conf_energie": "",
"conf_consommations": "",
"conf_consommation_chauffage": "",
"conf_commentaire_produit": "",
"observation_qualite": "",
"exportation": "",
"favorite": "",
"color": "",
"PENALITE": "",
"DETAIL_PENALITE": "",
"pac_consomation": "",
"pac_surface_habitable": "",
"pac_nombre_pieces": "",
"pac_age_maison": "",
"pac_annee_chauf": "",
"pac_surface_chauf": "",
"pac_propritaire_maison": "",
"conf_presence_couple": "",
"archive": "",
"valider": "",
"ph3_pac": "",
"ph3_attente": "",
"ph3_alimentation": "",
"ph3_type": "",
"ph3_prix": "",
"ph3_puissance": "",
"ph3_ballon": "",
"ph3_nbr_unite": "",
"ph3_nbr_group": "",
"ph3_rr_model": "",
"ph3_installateur": "",
"ph3_mensualite": "",
"ph3_bonus_15": "",
"ph3_bonus_30": "",
"decalage": "",
"valeur_mensualite": "",
"nbr_annee_finance": "",
"cq_etat": "",
"cq_dossier": "",
"cq_observations": "",
"cq_date_modif": "",
"credit_autre": "",
"credit_immobilier": "",
"ph3_marque_pac": "",
"ph3_marque_ballon": ""
},
{
"id": "842501",
"civ": "MME",
"nom": "THIERRY",
"prenom": "EXCOFFIER",
"tel": "450440587",
"gsm1": "450440587",
"gsm2": "450440587",
"Adresse": "341 RTE JUSSY 74350",
"cp": "74350",
"ville": "COPPONEX",
"maison_orientation": "4 ORIENTATION",
"etude": "MME",
"etude_observation": "MAIS INDV /CONS ELEC : 1000 EURO / 2PROP MARIE / MME CDI ADM -60ANS MR CDI 60ANS CHARGE PROJET / REVENU : 1800 EUROZN /SURF BATIE : 60 M² / 4 PANS / Z OMBRES : NON / OBSTACLES : 2VELUX ,1 CHEM ET 2 FENETRE / ETUDE PV : ELLE A DEUX DEVIS ET EN TRAIN DE REFLECHIR / VALORISATIONACCORD POUR LE RAPPEL MERCI DE POUSSER L INTERET",
"installation": "13/11/2024 18:51:25",
"installation_type": "0",
"installation_annee": "0",
"installation_production": "AG2164",
"installation_prix": "0",
"entretient": "QUALITE3",
"commentaire": "Call_JWS_PV",
"date_heure_appel": "1",
"nom_commercial": "SALARIE CDI",
"nom_commercial_2": "SALARIE CDI",
"id_commercial": "60",
"nom_confirmateur": "-60",
"nom_confirmateur_2": "0",
"nom_confirmateur_3": "MARIE",
"id_confirmateur": "1800",
"nom_agent": "1",
"id_agent": "0/0/0 00:00:00",
"nom_qualite": "0/0/0 00:00:00",
"id_qualite": "13/11/2024 19:03:00",
"nom_centre": "EN-ATTENTE",
"id_centre": "PV",
"profession_mr": "PAC",
"age_mr": "1000",
"age_mme": "0",
"enfant_encharge": "0",
"situation_conju": "0",
"revenu": "0",
"credit": "0",
"site_classe": "0",
"zones_ombres": "0",
"chemines": "0",
"nb_chemines": "LES DEUX",
"surface_disponible": "0",
"etat_qualite": "0",
"date_heure_playning": "0",
"date_heure_mod": "0",
"date_insertion": "0",
"motif_qualification": "0",
"adresse_ip": "0",
"etat_final": "0",
"sous_etat": "0/0/0 00:00:00",
"conf_rdv_avec": "",
"conf_prise_autre_personne": "",
"conf_profession_monsieur": "",
"conf_profession": "",
"conf_profession_detail": "",
"conf_profession_madame": "",
"conf_profession_mme": "",
"conf_profession_detail_mme": "",
"conf_deja_fait_etude": "",
"conf_detail_etude": "",
"conf_revenu": "",
"conf_credit": "",
"conf_deja_installe": "",
"conf_type_installation": "",
"conf_annee_installation": "",
"conf_production_installation": "",
"conf_prix_installation": "",
"conf_annulee_precedemment": "",
"conf_annulee_precedemment_par": "",
"conf_produit": "",
"conf_energie": "",
"conf_consommations": "",
"conf_consommation_chauffage": "",
"conf_commentaire_produit": "",
"observation_qualite": "",
"exportation": "",
"favorite": "",
"color": "",
"PENALITE": "",
"DETAIL_PENALITE": "",
"pac_consomation": "",
"pac_surface_habitable": "",
"pac_nombre_pieces": "",
"pac_age_maison": "",
"pac_annee_chauf": "",
"pac_surface_chauf": "",
"pac_propritaire_maison": "",
"conf_presence_couple": "",
"archive": "",
"valider": "",
"ph3_pac": "",
"ph3_attente": "",
"ph3_alimentation": "",
"ph3_type": "",
"ph3_prix": "",
"ph3_puissance": "",
"ph3_ballon": "",
"ph3_nbr_unite": "",
"ph3_nbr_group": "",
"ph3_rr_model": "",
"ph3_installateur": "",
"ph3_mensualite": "",
"ph3_bonus_15": "",
"ph3_bonus_30": "",
"decalage": "",
"valeur_mensualite": "",
"nbr_annee_finance": "",
"cq_etat": "",
"cq_dossier": "",
"cq_observations": "",
"cq_date_modif": "",
"credit_autre": "",
"credit_immobilier": "",
"ph3_marque_pac": "",
"ph3_marque_ballon": ""
},
{
"id": "842502",
"civ": "MLLE",
"nom": "ANNIE",
"prenom": "VERSEPUY",
"tel": "556951731",
"gsm1": "556951731",
"gsm2": "556951731",
"Adresse": "13 R FRANCOIS MAURIAC",
"cp": "33290",
"ville": "BLANQUEFORT",
"maison_orientation": "est ouest",
"etude": "NON",
"etude_observation": "MME",
"installation": "FICHE PV, ZONE NORMALE, 100M AU SOL, EST OUEST, PROJET EXPLIQUE NA PAS FAIT UNE ETUDE, MERCI DE CONFIRMER LA CONSOMMATION ELECT,",
"installation_type": "13/11/2024 18:54:31",
"installation_annee": "0",
"installation_production": "0",
"installation_prix": "AG2096",
"entretient": "0",
"commentaire": "RE_MALEK",
"date_heure_appel": "Call_JWS_PV",
"nom_commercial": "1",
"nom_commercial_2": "-1",
"id_commercial": "RETR AUTRE",
"nom_confirmateur": "0",
"nom_confirmateur_2": "70",
"nom_confirmateur_3": "0",
"id_confirmateur": "CELIBATAIRE",
"nom_agent": "1300",
"id_agent": "0",
"nom_qualite": "0/0/0 00:00:00",
"id_qualite": "0/0/0 00:00:00",
"nom_centre": "13/11/2024 19:03:00",
"id_centre": "EN-ATTENTE",
"profession_mr": "PV",
"age_mr": "1000",
"age_mme": "0",
"enfant_encharge": "0",
"situation_conju": "0",
"revenu": "1000",
"credit": "100",
"site_classe": "0",
"zones_ombres": "0",
"chemines": "100",
"nb_chemines": "MADAME",
"surface_disponible": "0",
"etat_qualite": "0",
"date_heure_playning": "0",
"date_heure_mod": "0",
"date_insertion": "0",
"motif_qualification": "0",
"adresse_ip": "0",
"etat_final": "0",
"sous_etat": "0/0/0 00:00:00",
"conf_rdv_avec": "",
"conf_prise_autre_personne": "",
"conf_profession_monsieur": "",
"conf_profession": "",
"conf_profession_detail": "",
"conf_profession_madame": "",
"conf_profession_mme": "",
"conf_profession_detail_mme": "",
"conf_deja_fait_etude": "",
"conf_detail_etude": "",
"conf_revenu": "",
"conf_credit": "",
"conf_deja_installe": "",
"conf_type_installation": "",
"conf_annee_installation": "",
"conf_production_installation": "",
"conf_prix_installation": "",
"conf_annulee_precedemment": "",
"conf_annulee_precedemment_par": "",
"conf_produit": "",
"conf_energie": "",
"conf_consommations": "",
"conf_consommation_chauffage": "",
"conf_commentaire_produit": "",
"observation_qualite": "",
"exportation": "",
"favorite": "",
"color": "",
"PENALITE": "",
"DETAIL_PENALITE": "",
"pac_consomation": "",
"pac_surface_habitable": "",
"pac_nombre_pieces": "",
"pac_age_maison": "",
"pac_annee_chauf": "",
"pac_surface_chauf": "",
"pac_propritaire_maison": "",
"conf_presence_couple": "",
"archive": "",
"valider": "",
"ph3_pac": "",
"ph3_attente": "",
"ph3_alimentation": "",
"ph3_type": "",
"ph3_prix": "",
"ph3_puissance": "",
"ph3_ballon": "",
"ph3_nbr_unite": "",
"ph3_nbr_group": "",
"ph3_rr_model": "",
"ph3_installateur": "",
"ph3_mensualite": "",
"ph3_bonus_15": "",
"ph3_bonus_30": "",
"decalage": "",
"valeur_mensualite": "",
"nbr_annee_finance": "",
"cq_etat": "",
"cq_dossier": "",
"cq_observations": "",
"cq_date_modif": "",
"credit_autre": "",
"credit_immobilier": "",
"ph3_marque_pac": "",
"ph3_marque_ballon": ""
},
{
"id": "842503",
"civ": "MLLE",
"nom": "SYLVAIN",
"prenom": "DUFOUR",
"tel": "982534470",
"gsm1": "982534470",
"gsm2": "982534470",
"Adresse": "16 ALL PLATANES",
"cp": "42340",
"ville": "VEAUCHE",
"maison_orientation": "NON",
"etude": "FICHE PAC, MAISON INDIVID, CHAUD AVEC RAD A EAU, PROJET EXPLIQUE NA PAS FAIT UNE ETUDE CLIENTE MEFIANTE POSE LA QUESTION PLUSIEURS FOIS ON EST QUEL ORGANISME",
"etude_observation": "13/11/2024 17:24:55",
"installation": "0",
"installation_type": "0",
"installation_annee": "AG2192",
"installation_production": "0",
"installation_prix": "RE_MALEK",
"entretient": "Call_JWS_PAC",
"commentaire": "1",
"date_heure_appel": "EN ACTIVITE CDI",
"nom_commercial": "EN ACTIVITE CDI",
"nom_commercial_2": "-65",
"id_commercial": "-65",
"nom_confirmateur": "0",
"nom_confirmateur_2": "MARIE",
"nom_confirmateur_3": "1800",
"id_confirmateur": "0",
"nom_agent": "0/0/0 00:00:00",
"id_agent": "0/0/0 00:00:00",
"nom_qualite": "13/11/2024 19:05:00",
"id_qualite": "EN-ATTENTE",
"nom_centre": "PAC",
"id_centre": "GAZ",
"profession_mr": "0",
"age_mr": "0",
"age_mme": "0",
"enfant_encharge": "0",
"situation_conju": "700",
"revenu": "90",
"credit": "0",
"site_classe": "2012",
"zones_ombres": "90",
"chemines": "LES DEUX",
"nb_chemines": "0",
"surface_disponible": "0",
"etat_qualite": "0",
"date_heure_playning": "0",
"date_heure_mod": "0",
"date_insertion": "0",
"motif_qualification": "0",
"adresse_ip": "0",
"etat_final": "0/0/0 00:00:00",
"sous_etat": "",
"conf_rdv_avec": "",
"conf_prise_autre_personne": "",
"conf_profession_monsieur": "",
"conf_profession": "",
"conf_profession_detail": "",
"conf_profession_madame": "",
"conf_profession_mme": "",
"conf_profession_detail_mme": "",
"conf_deja_fait_etude": "",
"conf_detail_etude": "",
"conf_revenu": "",
"conf_credit": "",
"conf_deja_installe": "",
"conf_type_installation": "",
"conf_annee_installation": "",
"conf_production_installation": "",
"conf_prix_installation": "",
"conf_annulee_precedemment": "",
"conf_annulee_precedemment_par": "",
"conf_produit": "",
"conf_energie": "",
"conf_consommations": "",
"conf_consommation_chauffage": "",
"conf_commentaire_produit": "",
"observation_qualite": "",
"exportation": "",
"favorite": "",
"color": "",
"PENALITE": "",
"DETAIL_PENALITE": "",
"pac_consomation": "",
"pac_surface_habitable": "",
"pac_nombre_pieces": "",
"pac_age_maison": "",
"pac_annee_chauf": "",
"pac_surface_chauf": "",
"pac_propritaire_maison": "",
"conf_presence_couple": "",
"archive": "",
"valider": "",
"ph3_pac": "",
"ph3_attente": "",
"ph3_alimentation": "",
"ph3_type": "",
"ph3_prix": "",
"ph3_puissance": "",
"ph3_ballon": "",
"ph3_nbr_unite": "",
"ph3_nbr_group": "",
"ph3_rr_model": "",
"ph3_installateur": "",
"ph3_mensualite": "",
"ph3_bonus_15": "",
"ph3_bonus_30": "",
"decalage": "",
"valeur_mensualite": "",
"nbr_annee_finance": "",
"cq_etat": "",
"cq_dossier": "",
"cq_observations": "",
"cq_date_modif": "",
"credit_autre": "",
"credit_immobilier": "",
"ph3_marque_pac": "",
"ph3_marque_ballon": ""
},
{
"id": "842506",
"civ": "MLLE",
"nom": "ANNELAURE",
"prenom": "LETEXIER",
"tel": "659896890",
"gsm1": "659896890",
"gsm2": "659896890",
"Adresse": "3 RUE DES HORTENSIAS",
"cp": "35500",
"ville": "CORNILLE",
"maison_orientation": "4 orientations",
"etude": "MME",
"etude_observation": "PAS DE VERIFICATION DES DOMIANES D ACTIVITE ELEC : 1000 EURO / ELEL A 10 PANNEAUX POUR LA REVENTE ET L AUTOCONSO",
"installation": "13/11/2024 18:59:25",
"installation_type": "0",
"installation_annee": "0",
"installation_production": "AG2137",
"installation_prix": "0",
"entretient": "QUALITE6",
"commentaire": "Call_JWS_PV",
"date_heure_appel": "1",
"nom_commercial": "GARAGISTE LIBERAL",
"nom_commercial_2": "GARAGISTE LIBERAL",
"id_commercial": "-65",
"nom_confirmateur": "-65",
"nom_confirmateur_2": "0",
"nom_confirmateur_3": "MARIE",
"id_confirmateur": "22000",
"nom_agent": "NON",
"id_agent": "0",
"nom_qualite": "0/0/0 00:00:00",
"id_qualite": "0/0/0 00:00:00",
"nom_centre": "13/11/2024 19:08:00",
"id_centre": "EN-ATTENTE",
"profession_mr": "PV",
"age_mr": "ELEC",
"age_mme": "1000",
"enfant_encharge": "0",
"situation_conju": "0",
"revenu": "0",
"credit": "1200",
"site_classe": "100",
"zones_ombres": "0",
"chemines": "1",
"nb_chemines": "100",
"surface_disponible": "LES DEUX",
"etat_qualite": "0",
"date_heure_playning": "0",
"date_heure_mod": "0",
"date_insertion": "0",
"motif_qualification": "0",
"adresse_ip": "0",
"etat_final": "0",
"sous_etat": "0",
"conf_rdv_avec": "0/0/0 00:00:00",
"conf_prise_autre_personne": "",
"conf_profession_monsieur": "",
"conf_profession": "",
"conf_profession_detail": "",
"conf_profession_madame": "",
"conf_profession_mme": "",
"conf_profession_detail_mme": "",
"conf_deja_fait_etude": "",
"conf_detail_etude": "",
"conf_revenu": "",
"conf_credit": "",
"conf_deja_installe": "",
"conf_type_installation": "",
"conf_annee_installation": "",
"conf_production_installation": "",
"conf_prix_installation": "",
"conf_annulee_precedemment": "",
"conf_annulee_precedemment_par": "",
"conf_produit": "",
"conf_energie": "",
"conf_consommations": "",
"conf_consommation_chauffage": "",
"conf_commentaire_produit": "",
"observation_qualite": "",
"exportation": "",
"favorite": "",
"color": "",
"PENALITE": "",
"DETAIL_PENALITE": "",
"pac_consomation": "",
"pac_surface_habitable": "",
"pac_nombre_pieces": "",
"pac_age_maison": "",
"pac_annee_chauf": "",
"pac_surface_chauf": "",
"pac_propritaire_maison": "",
"conf_presence_couple": "",
"archive": "",
"valider": "",
"ph3_pac": "",
"ph3_attente": "",
"ph3_alimentation": "",
"ph3_type": "",
"ph3_prix": "",
"ph3_puissance": "",
"ph3_ballon": "",
"ph3_nbr_unite": "",
"ph3_nbr_group": "",
"ph3_rr_model": "",
"ph3_installateur": "",
"ph3_mensualite": "",
"ph3_bonus_15": "",
"ph3_bonus_30": "",
"decalage": "",
"valeur_mensualite": "",
"nbr_annee_finance": "",
"cq_etat": "",
"cq_dossier": "",
"cq_observations": "",
"cq_date_modif": "",
"credit_autre": "",
"credit_immobilier": "",
"ph3_marque_pac": "",
"ph3_marque_ballon": ""
},
{
"id": "842507",
"civ": "MLLE",
"nom": "MANUELLA",
"prenom": "DELOURME",
"tel": "683810962",
"gsm1": "683810962",
"gsm2": "683810962",
"Adresse": "21 RUE LA MAISON NEUVE",
"cp": "35270",
"ville": "COMBOURG",
"maison_orientation": "sud nord",
"etude": "NON",
"etude_observation": "MME",
"installation": "FICHE PV, ZONE NORMALE, 90M AU SOL, NORD SUD, PROJET EXPLIQUE, NA PAS FAIT UNE ETUDE OK POUR RAPPEL",
"installation_type": "13/11/2024 19:02:09",
"installation_annee": "0",
"installation_production": "0",
"installation_prix": "AG2102",
"entretient": "0",
"commentaire": "RE_MALEK",
"date_heure_appel": "Call_JWS_PV",
"nom_commercial": "1",
"nom_commercial_2": "ACTIVE CDI",
"id_commercial": "ACTIVE CDI",
"nom_confirmateur": "-60",
"nom_confirmateur_2": "-60",
"nom_confirmateur_3": "0",
"id_confirmateur": "PAXE",
"nom_agent": "2000",
"id_agent": "0",
"nom_qualite": "0/0/0 00:00:00",
"id_qualite": "0/0/0 00:00:00",
"nom_centre": "13/11/2024 19:08:00",
"id_centre": "EN-ATTENTE",
"profession_mr": "PV",
"age_mr": "1000",
"age_mme": "0",
"enfant_encharge": "0",
"situation_conju": "0",
"revenu": "1000",
"credit": "100",
"site_classe": "0",
"zones_ombres": "0",
"chemines": "100",
"nb_chemines": "LES DEUX",
"surface_disponible": "0",
"etat_qualite": "0",
"date_heure_playning": "0",
"date_heure_mod": "0",
"date_insertion": "0",
"motif_qualification": "0",
"adresse_ip": "0",
"etat_final": "0",
"sous_etat": "0/0/0 00:00:00",
"conf_rdv_avec": "",
"conf_prise_autre_personne": "",
"conf_profession_monsieur": "",
"conf_profession": "",
"conf_profession_detail": "",
"conf_profession_madame": "",
"conf_profession_mme": "",
"conf_profession_detail_mme": "",
"conf_deja_fait_etude": "",
"conf_detail_etude": "",
"conf_revenu": "",
"conf_credit": "",
"conf_deja_installe": "",
"conf_type_installation": "",
"conf_annee_installation": "",
"conf_production_installation": "",
"conf_prix_installation": "",
"conf_annulee_precedemment": "",
"conf_annulee_precedemment_par": "",
"conf_produit": "",
"conf_energie": "",
"conf_consommations": "",
"conf_consommation_chauffage": "",
"conf_commentaire_produit": "",
"observation_qualite": "",
"exportation": "",
"favorite": "",
"color": "",
"PENALITE": "",
"DETAIL_PENALITE": "",
"pac_consomation": "",
"pac_surface_habitable": "",
"pac_nombre_pieces": "",
"pac_age_maison": "",
"pac_annee_chauf": "",
"pac_surface_chauf": "",
"pac_propritaire_maison": "",
"conf_presence_couple": "",
"archive": "",
"valider": "",
"ph3_pac": "",
"ph3_attente": "",
"ph3_alimentation": "",
"ph3_type": "",
"ph3_prix": "",
"ph3_puissance": "",
"ph3_ballon": "",
"ph3_nbr_unite": "",
"ph3_nbr_group": "",
"ph3_rr_model": "",
"ph3_installateur": "",
"ph3_mensualite": "",
"ph3_bonus_15": "",
"ph3_bonus_30": "",
"decalage": "",
"valeur_mensualite": "",
"nbr_annee_finance": "",
"cq_etat": "",
"cq_dossier": "",
"cq_observations": "",
"cq_date_modif": "",
"credit_autre": "",
"credit_immobilier": "",
"ph3_marque_pac": "",
"ph3_marque_ballon": ""
},
{
"id": "842511",
"civ": "MLLE",
"nom": "MAX",
"prenom": "BOUDES",
"tel": "477319103",
"gsm1": "477319103",
"gsm2": "477319103",
"Adresse": "16 IMP FRIAUDE",
"cp": "42400",
"ville": "SAINT CHAMOND",
"maison_orientation": "Est OUEST",
"etude": "MR",
"etude_observation": "ELEC : 1000 EURO ZONE NORMALE / 2 PANS / EST OUEST / PAS DE ZONE D OMBRE / 20 METRES DEGAGES LES 2 PROP / LES 2 EN CDI / LES 2 AAGES DE – 65ANS / REVENU 1800 EURO",
"installation": "13/11/2024 18:51:04",
"installation_type": "0",
"installation_annee": "0",
"installation_production": "AG2137",
"installation_prix": "0",
"entretient": "QUALITE6",
"commentaire": "Call_JWS_PV",
"date_heure_appel": "1",
"nom_commercial": "0 CDI",
"nom_commercial_2": "0 CDI",
"id_commercial": "-65",
"nom_confirmateur": "-65",
"nom_confirmateur_2": "0",
"nom_confirmateur_3": "MARIE",
"id_confirmateur": "1800",
"nom_agent": "NON",
"id_agent": "0",
"nom_qualite": "0/0/0 00:00:00",
"id_qualite": "0/0/0 00:00:00",
"nom_centre": "13/11/2024 19:13:00",
"id_centre": "EN-ATTENTE",
"profession_mr": "PV",
"age_mr": "GAZ",
"age_mme": "1000",
"enfant_encharge": "0",
"situation_conju": "0",
"revenu": "0",
"credit": "1000",
"site_classe": "100",
"zones_ombres": "0",
"chemines": "3",
"nb_chemines": "100",
"surface_disponible": "MONSIEUR",
"etat_qualite": "0",
"date_heure_playning": "0",
"date_heure_mod": "0",
"date_insertion": "0",
"motif_qualification": "0",
"adresse_ip": "0",
"etat_final": "0",
"sous_etat": "0",
"conf_rdv_avec": "0/0/0 00:00:00",
"conf_prise_autre_personne": "",
"conf_profession_monsieur": "",
"conf_profession": "",
"conf_profession_detail": "",
"conf_profession_madame": "",
"conf_profession_mme": "",
"conf_profession_detail_mme": "",
"conf_deja_fait_etude": "",
"conf_detail_etude": "",
"conf_revenu": "",
"conf_credit": "",
"conf_deja_installe": "",
"conf_type_installation": "",
"conf_annee_installation": "",
"conf_production_installation": "",
"conf_prix_installation": "",
"conf_annulee_precedemment": "",
"conf_annulee_precedemment_par": "",
"conf_produit": "",
"conf_energie": "",
"conf_consommations": "",
"conf_consommation_chauffage": "",
"conf_commentaire_produit": "",
"observation_qualite": "",
"exportation": "",
"favorite": "",
"color": "",
"PENALITE": "",
"DETAIL_PENALITE": "",
"pac_consomation": "",
"pac_surface_habitable": "",
"pac_nombre_pieces": "",
"pac_age_maison": "",
"pac_annee_chauf": "",
"pac_surface_chauf": "",
"pac_propritaire_maison": "",
"conf_presence_couple": "",
"archive": "",
"valider": "",
"ph3_pac": "",
"ph3_attente": "",
"ph3_alimentation": "",
"ph3_type": "",
"ph3_prix": "",
"ph3_puissance": "",
"ph3_ballon": "",
"ph3_nbr_unite": "",
"ph3_nbr_group": "",
"ph3_rr_model": "",
"ph3_installateur": "",
"ph3_mensualite": "",
"ph3_bonus_15": "",
"ph3_bonus_30": "",
"decalage": "",
"valeur_mensualite": "",
"nbr_annee_finance": "",
"cq_etat": "",
"cq_dossier": "",
"cq_observations": "",
"cq_date_modif": "",
"credit_autre": "",
"credit_immobilier": "",
"ph3_marque_pac": "",
"ph3_marque_ballon": ""
},
{
"id": "842515",
"civ": "MLLE",
"nom": "CLEMENT",
"prenom": "JEAN LUC",
"tel": "607323719",
"gsm1": "607323719",
"gsm2": "607323719",
"Adresse": "8 RUE HENRI DHEURLE",
"cp": "33260",
"ville": "LA TESTE DE BUCH",
"maison_orientation": "NON",
"etude": "MR",
"etude_observation": "MOINS 1000EUR ELEC/1500EUR CHAUFFAGE/",
"installation": "13/11/2024 14:35:15",
"installation_type": "0",
"installation_annee": "0",
"installation_production": "AG874",
"installation_prix": "0",
"entretient": "QUALITE2",
"commentaire": "Call_JWS_PAC",
"date_heure_appel": "1",
"nom_commercial": "RETRAITE LIBERAL",
"nom_commercial_2": "RETRAITE AUTRE",
"id_commercial": "-70",
"nom_confirmateur": "-70",
"nom_confirmateur_2": "0",
"nom_confirmateur_3": "CONCUBINAGE",
"id_confirmateur": "1800",
"nom_agent": "0",
"id_agent": "0/0/0 00:00:00",
"nom_qualite": "0/0/0 00:00:00",
"id_qualite": "13/11/2024 19:21:00",
"nom_centre": "EN-ATTENTE",
"id_centre": "PAC",
"profession_mr": "GAZ",
"age_mr": "0",
"age_mme": "0",
"enfant_encharge": "0",
"situation_conju": "0",
"revenu": "1500",
"credit": "100",
"site_classe": "5",
"zones_ombres": "2014",
"chemines": "100",
"nb_chemines": "LES DEUX",
"surface_disponible": "0",
"etat_qualite": "0",
"date_heure_playning": "0",
"date_heure_mod": "0",
"date_insertion": "0",
"motif_qualification": "0",
"adresse_ip": "0",
"etat_final": "0",
"sous_etat": "0/0/0 00:00:00",
"conf_rdv_avec": "",
"conf_prise_autre_personne": "",
"conf_profession_monsieur": "",
"conf_profession": "",
"conf_profession_detail": "",
"conf_profession_madame": "",
"conf_profession_mme": "",
"conf_profession_detail_mme": "",
"conf_deja_fait_etude": "",
"conf_detail_etude": "",
"conf_revenu": "",
"conf_credit": "",
"conf_deja_installe": "",
"conf_type_installation": "",
"conf_annee_installation": "",
"conf_production_installation": "",
"conf_prix_installation": "",
"conf_annulee_precedemment": "",
"conf_annulee_precedemment_par": "",
"conf_produit": "",
"conf_energie": "",
"conf_consommations": "",
"conf_consommation_chauffage": "",
"conf_commentaire_produit": "",
"observation_qualite": "",
"exportation": "",
"favorite": "",
"color": "",
"PENALITE": "",
"DETAIL_PENALITE": "",
"pac_consomation": "",
"pac_surface_habitable": "",
"pac_nombre_pieces": "",
"pac_age_maison": "",
"pac_annee_chauf": "",
"pac_surface_chauf": "",
"pac_propritaire_maison": "",
"conf_presence_couple": "",
"archive": "",
"valider": "",
"ph3_pac": "",
"ph3_attente": "",
"ph3_alimentation": "",
"ph3_type": "",
"ph3_prix": "",
"ph3_puissance": "",
"ph3_ballon": "",
"ph3_nbr_unite": "",
"ph3_nbr_group": "",
"ph3_rr_model": "",
"ph3_installateur": "",
"ph3_mensualite": "",
"ph3_bonus_15": "",
"ph3_bonus_30": "",
"decalage": "",
"valeur_mensualite": "",
"nbr_annee_finance": "",
"cq_etat": "",
"cq_dossier": "",
"cq_observations": "",
"cq_date_modif": "",
"credit_autre": "",
"credit_immobilier": "",
"ph3_marque_pac": "",
"ph3_marque_ballon": ""
},
{
"id": "842516",
"civ": "MLLE",
"nom": "ISABELLE",
"prenom": "SITTER",
"tel": "369021862",
"gsm1": "369021862",
"gsm2": "369021862",
"Adresse": "43 R",
"cp": "67500",
"ville": "HAGUENAU",
"maison_orientation": "MME",
"etude": "ELEC : 1000 EURO ZONE CLASSEE / AU JARDIN : 100 M² / 4 H DENSOLEILLEMENT / 20 METRES DEGAGES MME SEULE PROP / VEUVE / AGEE DE – 75ANS / REVENU 1300 EURO / RETRAITE",
"etude_observation": "13/11/2024 19:02:02",
"installation": "0",
"installation_type": "0",
"installation_annee": "AG1028",
"installation_production": "0",
"installation_prix": "QUALITE6",
"entretient": "Call_JWS_PV",
"commentaire": "1",
"date_heure_appel": "- -1",
"nom_commercial": "RETRAITE -1",
"nom_commercial_2": "0",
"id_commercial": "-75",
"nom_confirmateur": "0",
"nom_confirmateur_2": "VEUF/VEUVE",
"nom_confirmateur_3": "1300",
"id_confirmateur": "OUI",
"nom_agent": "0",
"id_agent": "0/0/0 00:00:00",
"nom_qualite": "0/0/0 00:00:00",
"id_qualite": "13/11/2024 19:23:00",
"nom_centre": "EN-ATTENTE",
"id_centre": "PV",
"profession_mr": "ELECTRICITE",
"age_mr": "1000",
"age_mme": "0",
"enfant_encharge": "0",
"situation_conju": "0",
"revenu": "1000",
"credit": "100",
"site_classe": "5",
"zones_ombres": "2019",
"chemines": "100",
"nb_chemines": "MADAME",
"surface_disponible": "0",
"etat_qualite": "0",
"date_heure_playning": "0",
"date_heure_mod": "0",
"date_insertion": "0",
"motif_qualification": "0",
"adresse_ip": "0",
"etat_final": "0",
"sous_etat": "0/0/0 00:00:00",
"conf_rdv_avec": "",
"conf_prise_autre_personne": "",
"conf_profession_monsieur": "",
"conf_profession": "",
"conf_profession_detail": "",
"conf_profession_madame": "",
"conf_profession_mme": "",
"conf_profession_detail_mme": "",
"conf_deja_fait_etude": "",
"conf_detail_etude": "",
"conf_revenu": "",
"conf_credit": "",
"conf_deja_installe": "",
"conf_type_installation": "",
"conf_annee_installation": "",
"conf_production_installation": "",
"conf_prix_installation": "",
"conf_annulee_precedemment": "",
"conf_annulee_precedemment_par": "",
"conf_produit": "",
"conf_energie": "",
"conf_consommations": "",
"conf_consommation_chauffage": "",
"conf_commentaire_produit": "",
"observation_qualite": "",
"exportation": "",
"favorite": "",
"color": "",
"PENALITE": "",
"DETAIL_PENALITE": "",
"pac_consomation": "",
"pac_surface_habitable": "",
"pac_nombre_pieces": "",
"pac_age_maison": "",
"pac_annee_chauf": "",
"pac_surface_chauf": "",
"pac_propritaire_maison": "",
"conf_presence_couple": "",
"archive": "",
"valider": "",
"ph3_pac": "",
"ph3_attente": "",
"ph3_alimentation": "",
"ph3_type": "",
"ph3_prix": "",
"ph3_puissance": "",
"ph3_ballon": "",
"ph3_nbr_unite": "",
"ph3_nbr_group": "",
"ph3_rr_model": "",
"ph3_installateur": "",
"ph3_mensualite": "",
"ph3_bonus_15": "",
"ph3_bonus_30": "",
"decalage": "",
"valeur_mensualite": "",
"nbr_annee_finance": "",
"cq_etat": "",
"cq_dossier": "",
"cq_observations": "",
"cq_date_modif": "",
"credit_autre": "",
"credit_immobilier": "",
"ph3_marque_pac": "",
"ph3_marque_ballon": ""
}
]